API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 12th, 2017
196
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
INI file 14.70 KB | None | 0 0
raw download clone embed print report
  1. options:
  2.   collate: utf8_unicode_ci
  3.   charset: utf8
  4.  
  5. detect_relations: true
  6.  
  7. User:
  8.   actAs: { Timestampable: ~ }
  9.   columns:
  10.     login: { type: string(255), notnull: true, unique: true }
  11.     password: { type: string(255), notnull: true }
  12.     password_salt: { type: string(255), notnull: true }
  13.     locale: { type: varchar(5), notnull: true }
  14.     title: { type: integer(1), notnull: true }
  15.     name: { type: string(255), notnull: true }
  16.     firstname: { type: string(255), notnull: true }
  17.     email: { type: string(255), notnull: true }
  18.     status: integer(2)
  19.     access_type: { type: integer, notnull: true, default: 0 } # 0 = Free, 1 = Free start      
  20.  
  21. Profile:
  22.   actAs: { Timestampable: ~ }
  23.   tableName: user_profile
  24.   columns:
  25.     address: { type: string(255), notnull: false }
  26.     zipcode: { type: string(255), notnull: false }
  27.     city: { type: string(255), notnull: false }
  28.     driver_license: { type: string(255), notnull: false }
  29.     marital_status: { type: string(255), notnull: false }
  30.     home_phone: { type: string(255), notnull: true }
  31.     cell_phone: { type: string(255), notnull: true }
  32.     career_level: { type: string(255), notnull: true }
  33.     job_position_id: { type: integer, notnull: false }
  34.     job_position: { type: string(255), notnull: false }
  35.     years_experience: { type: integer, notnull: true }
  36.     user_photo: { type: string(255), notnull: false }
  37.     career_highlights: { type: text, notnull: true }
  38.     department_id: { type: integer, notnull: false }
  39.     department: { type: string(255), notnull: false }
  40.     job_position_summary: { type: text, notnull: false }
  41.     user_id: { type: integer, notnull: true }
  42.     is_company: boolean
  43.   relations:
  44.     User:
  45.       local: user_id
  46.       foreign: id
  47.       type: one
  48.       foreignType: one
  49.     Interests:
  50.       class: Interest
  51.       local: id
  52.       foreign: user_profile_id
  53.       type: many
  54.     Languages:
  55.       class: Language
  56.       local: id
  57.       foreign: user_profile_id
  58.       type: many
  59.     Formations:
  60.       class: Formation
  61.       local: id
  62.       foreign: user_profile_id
  63.       type: many
  64.       foreignType: one
  65.     Associations:
  66.       class: Association
  67.       local: id
  68.       foreign: user_profile_id
  69.       type: many
  70.     Awards:
  71.       class: Award
  72.       local: id
  73.       foreign: user_profile_id
  74.       type: many
  75.    
  76. Formation:
  77.   actAs: { Timestampable: ~ }
  78.   tableName: user_profile_formation
  79.   columns:
  80.     study_field: { type: string(255), notnull: true }
  81.     start_month: { type: integer, notnull: false, default: 0 }
  82.     start_year: { type: integer, notnull: true }
  83.     end_month: { type: integer, notnull: false, default: 0 }
  84.     end_year: { type: integer, notnull: true }
  85.     school_name: { type: string(255), notnull: true }
  86.     school_city: { type: string(255), notnull: true }
  87.     school_country: { type: string(255), notnull: true }
  88.     study_summary: { type: text, notnull: true }
  89.     graduated: { type: bool, notnull: true }
  90.     diploma: { type: string(255), notnull: false }
  91.     other_diploma: { type: string(255), notnull: false }
  92.     educational_level: { type: string(255), notnull: true }
  93.     user_profile_id: { type: integer, notnull: false }
  94.  
  95. Reference:
  96.   actAs: { Timestampable: ~ }
  97.   tableName: user_profile_reference
  98.   columns:
  99.     name: { type: string(255), notnull: true }
  100.     job_position: { type: string(255), notnull: true }
  101.     phone_number: { type: string(255), notnull: true }
  102.     email: { type: string(255), notnull: true }
  103.  
  104. Association:
  105.   actAs: { Timestampable: ~ }
  106.   tableName: user_profile_association
  107.   columns:
  108.     role: { type: string(255), notnull: true }
  109.     association_name: { type: string(255), notnull: true }
  110.     association_city: { type: string(255), notnull: true }
  111.     association_country: { type: string(255), notnull: true }
  112.     start_month: { type: integer, notnull: false, default: 0 }
  113.     start_year: { type: integer, notnull: true }
  114.     end_month: { type: integer, notnull: false, default: 0 }
  115.     end_year: { type: integer, notnull: false, default: 0 }
  116.     user_profile_id: { type: integer, notnull: false }
  117.    
  118. Award:
  119.   actAs: { Timestampable: ~ }
  120.   tableName: user_profile_award
  121.   columns:
  122.     title: { type: string(255), notnull: true }
  123.     prize_date: { type: date, notnull: true }
  124.     user_profile_id: { type: integer, notnull: true }
  125.  
  126. Travel:
  127.   actAs: { Timestampable: ~ }
  128.   tableName: professional_travels
  129.   columns:
  130.     country: { type: string(255), notnull: true, primary: true }
  131.     user_profile_id: { type: integer, notnull: true }
  132.    
  133. Interest:
  134.   actAs: { Timestampable: ~ }
  135.   tableName: user_profile_interest
  136.   columns:
  137.     title: { type: string(255), notnull: true }
  138.     user_profile_id: { type: integer, notnull: false }
  139.  
  140. Language:
  141.   actAs: { Timestampable: ~ }
  142.   tableName: user_profile_language
  143.   columns:
  144.     lang: { type: string(255), notnull: true }
  145.     level: { type: string(255), notnull: true }
  146.  
  147.     user_profile_id: { type: integer, notnull: false }
  148.  
  149. Skill:
  150.   actAs: { Timestampable: ~ }
  151.   tableName: user_professional_skill
  152.   columns:
  153.     title: { type: string(255), notnull: true }
  154.     level: { type: string(255), notnull: true }
  155.     user_profile_id: { type: integer, notnull: false }
  156.  
  157. Objective:
  158.   actAs: { Timestampable: ~ }
  159.   tableName: user_professional_objective
  160.   columns:
  161.     job_position: { type: string(255), notnull: true }
  162.     contract: { type: string(255), notnull: true }
  163.     minimum_salary: { type: integer, notnull: true }
  164.     maximum_salary: { type: integer, notnull: true }
  165.     city: { type: string(255), notnull: true }
  166.     country: { type: string(255), notnull: true }
  167.     user_profile_id: { type: integer, notnull: false }
  168.  
  169. Experience:
  170.   actAs: { Timestampable: ~ }
  171.   tableName: professional_experience
  172.   columns:
  173.     job_position_title: { type: string(255), notnull: true }
  174.     company_grade: { type: string(255), notnull: true }
  175.     company_size: { type: integer, notnull: true }
  176.     company_activity: { type: string(255), notnull: true }
  177.     company_city: { type: string(255), notnull: true }
  178.     company_country: { type: string(255), notnull: true }
  179.     start_date: { type: date, notnull: false }
  180.     end_date: { type: date, notnull: false }
  181.     start_year: { type: integer, notnull: true }
  182.     end_year: { type: integer, notnull: true }
  183.     job_position_summary: { type: string(255), notnull: true }
  184.     user_profile_id: { type: integer, notnull: false }
  185.  
  186. AcquiredSkill:
  187.   actAs: { Timestampable: ~ }
  188.   tableName: professional_acquired_skill
  189.   columns:
  190.     title: { type: string(255), notnull: true }
  191.     professional_experience_id: { type: integer, notnull: true }
  192.    
  193. Department:
  194.   actAs:
  195.     I18n:
  196.       fields: [title]
  197.   columns:
  198.     title: { type: string(255), notnull: true }
  199.  
  200. JobPosition:
  201.   actAs:
  202.     I18n:
  203.       fields: [title]
  204.   columns:
  205.     title: { type: string(255), notnull: true }
  206.     department_id: { type: integer, notnull: true }
  207.  
  208. Company:
  209.   actAs: { Timestampable: ~ }
  210.   tableName: company
  211.   columns:
  212.     commercial_name: { type: string(255), notnull: true }
  213.     corporate_name: { type: string(255), notnull: true }
  214.     website: { type: string(255), notnull: true }
  215.     phone: { type: string(255), notnull: true }
  216.     fax: { type: string(255), notnull: true }
  217.     email: { type: string(255), notnull: true }
  218.     skype: { type: string(255), notnull: true }
  219.     lang: { type: string(255), notnull: true }
  220.     address: { type: string(255), notnull: true }
  221.     zipcode: { type: string(255), notnull: true }
  222.     city: { type: string(255), notnull: true }
  223.     region: { type: string(255), notnull: true }
  224.     country: { type: string(255), notnull: true }
  225.     description: { type: text, notnull: true }
  226.     logo: { type: string(255), notnull: true }
  227.     law_form_id: { type: integer, notnull: false }
  228.     law_form: { type: string(255), notnull: false }
  229.     isin_code: { type: string(255), notnull: true }
  230.     siret: { type: string(255), notnull: true }
  231.     registration_date: { type: date, notnull: true }
  232.     workforce_id: { type: integer, notnull: true }
  233.     capital: { type: string(255), notnull: true }
  234.     user_id: { type: integer, notnull: true }
  235.     star_one: { type: boolean, notnull:true, default: false }
  236.   relations:
  237.     User:
  238.       local: user_id
  239.       foreign: id
  240.       type: one
  241.       foreignType: one    
  242.     LawForm:
  243.       class: LawForm
  244.       local: law_form_id
  245.       foreign: id
  246.       type: one
  247.       foreignType: one
  248.       class: LawForm
  249.     Workforce:
  250.       local: workforce_id
  251.       foreign: id
  252.       type: one
  253.       foreignType: one
  254.       class: Workforce
  255.     Turnovers:
  256.       local: id
  257.       foreign: company_id
  258.       type: many
  259.       class: Turnover
  260.     References:
  261.       class: Reference
  262.       local: id
  263.       foreign: company_id
  264.       type: many
  265.       foreignType: one
  266.     Certifications:
  267.       class: Certification
  268.       foreignAlias: Companies
  269.       refClass: CompanyCertification
  270.     Labels:
  271.       class: QualityLabel
  272.       foreignAlias: Companies
  273.       refClass: CompanyQualityLabel
  274.     Importations:
  275.       class: Importation
  276.       local: id
  277.       foreign: company_id
  278.       type: many
  279.       foreignType: one
  280.     Exportations:
  281.       class: Exportation
  282.       local: id
  283.       foreign: company_id
  284.       type: many
  285.       foreignType: one
  286.     Branches:
  287.       class: Branch
  288.       local: id
  289.       foreign: company_id
  290.       type: many
  291.       foreignType: one
  292.     BusinessTypes:
  293.       class: BusinessType
  294.       foreignAlias: BusinessTypes
  295.       refClass: CompanyBusinessType
  296.  
  297. CompanyCertification:
  298.   actAs: { Timestampable: ~ }
  299.   columns:
  300.     id: { type: integer(4), primary: true, autoincrement: true }
  301.     certification_id: { type: integer, primary: true }
  302.     company_id: { type: integer, primary: true }
  303.   relations:
  304.     Company:
  305.       foreignAlias: CompanyCertifications
  306.     Certification:
  307.       foreignAlias: CompanyCertifications
  308.  
  309. CompanyQualityLabel:
  310.   actAs: { Timestampable: ~ }
  311.   columns:
  312.     id: { type: integer(4), primary: true, autoincrement: true }
  313.     quality_label_id: { type: integer, primary: true }
  314.     company_id: { type: integer, primary: true }
  315.   relations:
  316.     Company:
  317.       foreignAlias: CompanyQualityLabels
  318.     Label:
  319.       class: QualityLabel
  320.       foreignAlias: CompanyQualityLabels
  321.   tableName: company_quality_label
  322.  
  323.  
  324. CompanyBusinessType:
  325.   actAs: { Timestampable: ~ }
  326.   columns:
  327.     id: { type: integer(4), primary: true, autoincrement: true }
  328.     business_type_id: { type: integer, primary: true }
  329.     company_id: { type: integer, primary: true }
  330.   relations:
  331.     Company:
  332.       foreignAlias: CompanyBusinessTypes
  333.     BusinessType:
  334.       class: BusinessType
  335.       foreignAlias: CompanyBusinessTypes
  336.  
  337. BusinessType:
  338.   actAs:
  339.     I18n:
  340.       fields: [title]
  341.   tableName: business_types
  342.   columns:
  343.     title: { type: string(255), notnull: true }
  344.  
  345. LawForm:
  346.   actAs:
  347.     I18n:
  348.       fields: [title]
  349.   tableName: law_form
  350.   columns:
  351.     title: { type: string(255), notnull: true }
  352.  
  353. Workforce:
  354.   columns:
  355.     title: { type: string(255), notnull: true }
  356.  
  357. Turnover:
  358.   actAs: { Timestampable: ~ }
  359.   tableName: company_turnover
  360.   columns:
  361.     fiscal_year: { type: integer, notnull: true }
  362.     to_value: { type: decimal, notnull: true }
  363.     to_currency: { type: string(2), notnull: false }
  364.     export_percentage: { type: decimal, notnull: true }
  365.     outcome_value: { type: decimal, notnull: true }
  366.     outcome_currency: { type: string(2), notnull: true }
  367.     company_id: { type: integer, notnull: true }
  368.  
  369. Reference:
  370.   actAs: { Timestampable: ~ }
  371.   tableName: company_reference
  372.   columns:
  373.     name: { type: string(255), notnull: true }
  374.     email: { type: string(255), notnull: true }
  375.     website: { type: string(255), notnull: true }
  376.     company_id: { type: integer, notnull: true }
  377.    
  378. Certification:
  379.   columns:
  380.     title: { type: string(255), notnull: true }
  381.        
  382. QualityLabel:
  383.   columns:
  384.     title: { type: string(255), notnull: true }
  385.  
  386. Importation:
  387.   actAs: { Timestampable: ~ }
  388.   tableName: company_importation
  389.   columns:
  390.     company_id: { type: integer, notnull: true }
  391.     country: { type: string(255), notnull: true }
  392.  
  393. Exportation:
  394.   actAs: { Timestampable: ~ }
  395.   tableName: company_exportation
  396.   columns:
  397.     company_id: { type: integer, notnull: true }
  398.     country: { type: string(255), notnull: true }
  399.  
  400. Branch:
  401.   actAs: { Timestampable: ~ }
  402.   tableName: company_branch
  403.   columns:
  404.     corporate_name: { type: string(255), notnull: true }
  405.     address: { type: string(255), notnull: true }
  406.     zipcode: { type: string(255), notnull: true }
  407.     city: { type: string(255), notnull: true }
  408.     region: { type: string(255), notnull: true }
  409.     country: { type: string(255), notnull: true }
  410.     company_id: { type: integer, notnull: true }
  411.  
  412. Label:
  413.   tableName: message_label
  414.   actAs:
  415.     I18n:
  416.       fields: [title]
  417.   columns:
  418.     title: { type: string(255), notnull: true }
  419.     img_name: { type: string(255), notnull: true }
  420.     background_img_name: { type: string(255), notnull: true }
  421.     border_color: { type: string(255), notnull: true }
  422.    
  423. Message:
  424.   columns:
  425.     sender_id: integer
  426.     title: { type: string(255), notnull: true }
  427.     content: { type: text, notnull: true }
  428.     sender_label: integer
  429.     response_to_message: integer
  430.     template_id: integer
  431.     deleted_by_sender: { type: boolean, default: 0 }
  432.   actAs: { Timestampable: ~ }
  433.   relations:
  434.     Sender:
  435.       class: User
  436.       local: sender_id
  437.       foreign: id
  438.       type: one
  439.       foreignType: many
  440.     ResponseToMessage:
  441.       class: Message
  442.       local: response_to_message
  443.       foreign: id
  444.       type: one
  445.       foreignType: many
  446.     Label:
  447.       local: sender_label
  448.       foreign: id
  449.       type: one
  450.       foreignType: many
  451.       class: Label
  452.     Recipients:
  453.       local: id
  454.       foreign: message_id
  455.       type: many
  456.       foreignType: one
  457.       class: Recipient
  458.    
  459. Recipient:
  460.   tableName: message_recipient
  461.   columns:
  462.     message_id: integer
  463.     user_id: integer
  464.     group_id: integer
  465.     label_id: integer
  466.     read: { type: boolean, default: 0 }
  467.     deleted_by_recipient: { type: boolean, default: 0 }
  468.   relations:
  469.     Message:
  470.       class: Message
  471.       local: message_id
  472.       foreign: id
  473.       type: one
  474.       foreignType: many
  475.    
  476. Template:
  477.   tableName: message_template
  478.   actAs:
  479.     I18n:
  480.       fields: [title, content]
  481.   columns:
  482.     title: { type: string(255), notnull: true }
  483.     content: { type: text, notnull: true }
  484.    
  485. Group:
  486.   tableName: user_group
  487.   columns:
  488.     user_id: { type: integer, notnull: true }
  489.     title: { type: string(255), notnull: true }
  490.    
  491. UserInGroup:
  492.   columns:
  493.     user_id: { type: integer, notnull: true }
  494.     group_id: { type: integer, notnull: true }
  495.     accepted: boolean
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!