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
|
Fournisseur:
connection: doctrine
tableName: fournisseur
actAs: { Timestampable: ~ }
columns:
nom_fournisseur:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
.....
user_creation:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
user_maj:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
Stock:
connection: doctrine
tableName: stock
actAs: { Timestampable: ~ }
columns:
numero:
type: string()
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
user_creation:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
user_maj:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
Article:
connection: doctrine
tableName: article
actAs: { Timestampable: ~ }
columns:
id: { type: integer, notnull: true, primary: true }
nom_article:
type: string()
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
n_inventaire:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
.......
creation_user:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
update_user:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
ArticleLivre:
connection: doctrine
tableName: articlelivre
actAs: { Timestampable: ~ }
columns:
article_id: { type: integer, notnull: true, primary: true }
fournisseur_id: { type: integer, notnull: true, primary: true }
stock_id: { type: integer, notnull: true, primary: true }
date_livraison:
type: date(25)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
quantite:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
relations:
Article: { onDelete: RESTRICT, local: article_id, foreign: id}
Fournisseur: { onDelete: RESTRICT, local: fournisseur_id, foreign: id}
Stock: { onDelete: RESTRICT, local: stock_id, foreign: id} |
Partager