1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| client:
_attributes: { phpName: Client }
id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
# user_id: { type: INTEGER }
user_id: { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
societe: { type: VARCHAR, size: '50' }
civilite: { type: VARCHAR, size: '4', required: true }
nom: { type: VARCHAR, size: '50', required: true }
prenom: { type: VARCHAR, size: '50', required: true }
adresse: { type: LONGVARCHAR, required: true }
cp: { type: VARCHAR, size: '5', required: true }
ville: { type: VARCHAR, size: '50', required: true }
tel: { type: VARCHAR, size: '14', required: true }
liv_societe: { type: VARCHAR, size: '50', required: true }
liv_nom: { type: VARCHAR, size: '50', required: true }
liv_prenom: { type: VARCHAR, size: '50', required: true }
liv_adresse: { type: VARCHAR, size: '50', required: true }
liv_cp: { type: VARCHAR, size: '5', required: true }
liv_ville: { type: VARCHAR, size: '50', required: true }
created_at: { type: TIMESTAMP }
updated_at: { type: TIMESTAMP }
_indexes: { '': [user] } |
Partager