1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Dotation:
columns:
id: { type: integer(11), primary: true, autoincrement: true }
name: { type: string(255) }
Partner:
columns:
id: { type: integer(11), primary: true, autoincrement: true }
name: { type: string(255) }
relations:
Dotations: { class: Dotation, refClass: DotationPartner, foreignAlias: Partners }
DotationPartner:
columns:
dotation_id: { type: integer(11), primary: true }
partner_id: { type: integer(11), primary: true }
quantity: { type: integer(11) }
partner_sales_assistant_id: { type: integer(11) }
partner_sales_manager_id: { type: integer(11) }
relations:
Dotation: { foreignAlias: DotationPartners, onDelete: CASCADE }
Partner: { foreignAlias: DotationPartners, onDelete: CASCADE }
PartnerAssistant: { class: Profile, local: partner_sales_assistant_id, foreign: id, foreignAlias: AssistantDotationPartners }
PartnerManager: { class: Profile, local: partner_sales_manager_id, foreign: id, foreignAlias: ManagerDotationPartners } |
Partager