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