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
|
panier:
_attributes: { phpName: Panier }
id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
mtime: { type: INTEGER }
session: { type: VARCHAR, size: '32', required: true }
produit_id: { type: INTEGER, required: true, foreignTable: produit, foreignReference: id, onDelete: cascade }
nom: { type: VARCHAR, size: '100' }
qte: { type: INTEGER }
prix_ht: { type: INTEGER }
prix_ttc: { type: INTEGER }
produit:
_attributes: { phpName: Produit }
id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
code: { type: VARCHAR, size: '16' }
boutique_id: { type: INTEGER, required: true, foreignTable: boutique, foreignReference: id, onDelete: cascade }
famille_id: { type: INTEGER, required: true, foreignTable: produit_famille, foreignReference: id, onDelete: cascade }
marque_id: { type: INTEGER, required: true, foreignTable: produit_marque, foreignReference: id, onDelete: cascade }
ordre: { type: INTEGER }
nom: { type: VARCHAR, size: '100', required: true }
stripped_nom: { type: VARCHAR, size: '100' }
resume: { type: VARCHAR, size: '255' }
description: { type: LONGVARCHAR, required: true }
prix_ht: { type: INTEGER }
tva_id: { type: INTEGER, required: true, foreignTable: tva, foreignReference: id }
montant_tva: { type: INTEGER, required: true }
prix_ttc: { type: INTEGER, required: true }
photo: { type: VARCHAR, size: '255' }
rating_field: { type: FLOAT }
_indexes: { '': [stripped_nom] }
commande_ligne:
_attributes: { phpName: CommandeLigne }
id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
commande_id: { type: INTEGER, required: true, foreignTable: commande, foreignReference: id, onDelete: cascade }
produit_id: { type: INTEGER, required: true, foreignTable: produit, foreignReference: id, onDelete: cascade }
texte: { type: VARCHAR, size: '100', required: true }
qte: { type: INTEGER, required: true }
prix_ht: { type: INTEGER, required: true }
prix_ttc: { type: INTEGER, required: true } |
Partager