1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
|
Fabriquant:
connection: doctrine
tableName: fabriquant
actAs: { Timestampable: ~ }
columns:
nom_fabriquant:
type: string()
Fournisseur:
connection: doctrine
tableName: fournisseur
actAs: { Timestampable: ~ }
columns:
nom_fournisseur:
type: string()
Package:
connection: doctrine
tableName: package
actAs: { Timestampable: ~ }
columns:
id:
type: integer
notnull: true
primary: true
code_package:
type: integer(4)
nom_package:
type: string()
n_inventaire_package:
type: string()
Stock:
connection: doctrine
tableName: stock
actAs: { Timestampable: ~ }
columns:
batiment_id:
type: integer
notnull: true
numero:
type: string()
relations:
Batiment:
onDelete: RESTRICT
foreignAlias: Stocks
ArticleFabrique:
connection: doctrine
tableName: articlefabrique
columns:
article_id:
type: integer
notnull: true
fabriquant_id:
type: integer
notnull: true
relations:
Article:
onDelete: RESTRICT
foreignAlias: ArticleFabriques
Fabriquant:
onDelete: RESTRICT
foreignAlias: ArticleFabriques
ArticleIntegrePackage:
connection: doctrine
tableName: articlepackage
columns:
article_id:
type: integer
notnull: true
package_id:
type: integer
notnull: true
nbr_pieces:
type: integer(4)
quantite_par_piece:
type: integer(4)
unite:
type: string()
date_livraison:
type: date
relations:
Article:
foreignAlias: ArticleIntegrePackages
Package:
foreignAlias: ArticleIntegrePackages
ArticleLivreFournisseurStock:
connection: doctrine
tableName: articlefournisseurstock
actAs:
Timestampable: ~
columns:
article_id:
type: integer
notnull: true
fournisseur_id:
type: integer
notnull: true
stock_id:
type: integer
notnull: true
date_livraison:
type: date(25)
nombre_pieces:
type: integer(4)
quantite_par_piece:
type: integer(4)
unite:
type: string()
relations:
Article:
onDelete: RESTRICT
foreignAlias: ArticleLivreFournisseurStocks
Fournisseur:
onDelete: RESTRICT
foreignAlias: ArticleLivreFournisseurStocks
Stock:
onDelete: RESTRICT
foreignAlias: ArticleLivreFournisseurStocks
Article:
connection: doctrine
tableName: article
actAs: { Timestampable: ~ }
columns:
id:
type: integer
notnull: true
primary: true
autoincrement: true
forme_id:
type: integer
notnull: true
nom:
type: string()
notnull: true
nom_categorie:
type: enum(25)
values:
....
notnull: true
n_inventaire:
type: string()
...............................
relations:
Forme:
onDelete: RESTRICT
foreignAlias: Articles |
Partager