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
| Client:
actAs: { Timestampable: ~ }
columns:
nom: { type: string(255), notnull: true }
adresse1: { type: string(255), notnull: true }
adresse2: { type: string(255) }
cp: { type: string(255), notnull: true }
ville: { type: string(255), notnull: true }
pays: { type: string(255), notnull: true, default: "France" }
siret: { type: string(155) }
Contact:
actAs: { Timestampable: ~ }
columns:
civilite:
type: enum
length: 3
values: ['M.','Mme','Melle']
nom: { type: string(255), notnull: true }
prenom: { type: string(255), notnull: true }
fonction: { type: string(255) }
tel: { type: string(255) }
gsm: { type: string(255) }
fax: { type: string(255) }
courriel: { type: string(255) }
client_id: { type: integer, notnull: true }
relations:
Client: { local: client_id, foreign: id, foreignAlias: Clients }
Facture:
actAs: { Timestampable: ~ }
columns:
numero: { type: integer, notnull: true }
prestation: { type: string(255), notnull: true }
client_id: { type: integer, notnull: true }
echeance: { type: date, notnull: true }
devis: { type: boolean, notnull: true, default: true }
payee: { type: date }
relations:
Client: { local: client_id, foreign: id, foreignAlias: Factures }
EntreeFacture:
actAs: { Timestampable: ~ }
columns:
facture_id: { type: integer, notnull: true }
designation: { type: string(255), notnull: true }
montant_ht:
type: decimal(6)
scale: 2
relations:
Facture: { local: facture_id, foreign: id, foreignAlias: Entrees } |
Partager