options:
  collate: utf8_unicode_ci
  charset: utf8


Supplier:
  columns:
    id:              { type: integer, primary: true, autoincrement: true }
    name:            { type: string(100) }
    template_report: { type: clob }
    code:            { type: string(20) }
    tax_code:        { type: string(20) }
    address_street:  { type: string(200) }
    address_city:    { type: string(200) }
    address_zipcode: { type: string(20) }

  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Supplier_state_def:
  columns:
    id:              { type: integer, primary: true, autoincrement: true }
    supplier_id:     { type: integer, notnull: true }
    name:            { type: string(100) }
    costs_percent:   { type: integer }
    costs_price:     { type: decimal(10), scale: 2 }
    is_default:      { type: boolean, default: false }
  relations:
    Supplier:
      local: supplier_id
      foreign: id
      foreignAlias: State_defs
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"
          

Card:
  columns:
    id:                   { type: integer, primary: true, autoincrement: true}
    user_id:              { type: integer, notnull: false }
    
    state:                { type: string(50), notnull: false, default: null }
    state_date:           { type: timestamp }
    supplier_id:          { type: integer, notnull: true }

    days_to_solve:        { type: integer, notnull: true, default: 30 }
    due_day:              { type: integer(2) }
    refund_numbers:       { type: string(100) }
    user_finished:        { type: boolean, default: false }

    salary_percent:       { type: integer(2) }

    case_end_date:        { type: date }
    case_income:          { type: decimal(10), scale: 2 }
    case_penalty:         { type: decimal(10), scale: 2 }

    regal_connected:      { type: boolean, default: false }
    regal_note:           { type: clob }

    client_code:          { type: string(20) }
    client_name:          { type: string(255) }
    
    cell:                 { type: string(20) }
    phone:                { type: string(20) }
    phone_note:           { type: clob }

    address_street:       { type: string(200) }
    address_city:         { type: string(200) }
    address_zipcode:      { type: string(200) }
    address_cell:         { type: string(200) }
    address_phone:        { type: string(200) }
    address_phone2:       { type: string(200) }
    altaddress_street:    { type: string(200) }
    altaddress_city:      { type: string(200) }
    altaddress_zipcode:   { type: string(200) }
    altaddress_cell:      { type: string(200) }
    altaddress_phone:     { type: string(200) }
    altaddress_phone2:    { type: string(200) }

    income:               { type: decimal(10), scale: 2 }
    income_other:         { type: decimal(10), scale: 2 }
    income_partner:       { type: decimal(10), scale: 2 }

    employer:             { type: string(255) }
    employer_position:    { type: string(200) }
    employer_phone:       { type: string(200) }
    employer_street:      { type: string(200) }
    employer_city:        { type: string(200) }
    employer_zipcode:     { type: string(200) }

  relations:
    Supplier:
      local: supplier_id
      foreign: id
      foreignAlias: Cards
    Card_state_type:
      local: state_type_id
      foreign: id
    User:
      local: user_id
      foreign: id
      type: many
      foreignType: one
      foreignAlias: Cards
      onDelete: CASCADE
      class: sfGuardUserProfile

      
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"



Attachment:
  columns:
    id:            { type: integer, primary: true, autoincrement: true }
    card_id:       { type: integer, notnull: true }

    supplier_code:        { type: string(50) }
    contract_type:        { type: integer(4) }
    logic_state:          { type: string(2) }
    logic_state_date:     { type: timestamp }
    refund_type:          { type: string(50) }



    item:                 { type: string(255) }
    dealer_name:          { type: string(255) }
    color:                { type: string(200) }
    price:                { type: decimal(10), scale: 2 }
    numberplate:          { type: string(200) }
    serialnumber:         { type: string(200) }
    vintage:              { type: integer(4) }
    cert_info:            { type: string(200) }
    cert_taken:           { type: boolean, default: false }
    deposit:              { type: decimal(10), scale: 2 }
    price_funding:        { type: decimal(10), scale: 2 }
    price_payment:        { type: decimal(10), scale: 2 }
    lease_period:         { type: integer(4) }
    lease_date:           { type: date }
    requisition_date:     { type: date }
    update_date:          { type: date }

    agency_name:          { type: string(255) }
    agency_person:          { type: string(255) }

    guarantee_code:                 { type: string(200) }
    guarantee_name:                 { type: string(255) }
    guarantee_cell:                 { type: string(200) }
    guarantee_address_street:       { type: string(200) }
    guarantee_address_city:         { type: string(200) }
    guarantee_address_zipcode:      { type: string(200) }
    guarantee_address_cell:         { type: string(200) }
    guarantee_address_phone:        { type: string(200) }
    guarantee_address_phone2:       { type: string(200) }
    guarantee_altaddress_street:    { type: string(200) }
    guarantee_altaddress_city:      { type: string(200) }
    guarantee_altaddress_zipcode:   { type: string(200) }
    guarantee_altaddress_cell:      { type: string(200) }
    guarantee_altaddress_phone:     { type: string(200) }
    guarantee_altaddress_phone2:    { type: string(200) }

  relations:
    Card:
      local: card_id
      foreign: id
      foreignAlias: Attachments
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Debt:
  columns:
    id:            { type: integer, primary: true, autoincrement: true }
    attachment_id: { type: integer, notnull: true }
    update_date:   { type: date }
    penalty:       { type: decimal(10), scale: 2 }
    balance:       { type: decimal(10), scale: 2 }
    payment:       { type: decimal(10), scale: 2 }
    insurance:     { type: decimal(10), scale: 2 }
    fee:           { type: decimal(10), scale: 2 }
    payed:         { type: decimal(10), scale: 2 }
  relations:
    Attachment:
      local: attachment_id
      foreign: id
      foreignAlias: Debts
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Payment:
  columns:
    id:            { type: integer, primary: true, autoincrement: true }
    attachment_id: { type: integer, notnull: true }
    update_date:   { type: date }
    price:         { type: decimal(10), scale: 2 }
    code:          { type: string(50) }
    bank_code:     { type: string(50) }
    payment_date:  { type: date }
    payment_type:  { type: string(50) }
    handover_date: { type: date }
    note:          { type: clob }
  relations:
    Attachment:
      local: attachment_id
      foreign: id
      foreignAlias: Payments
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"
  indexes:
    one_price_per_day:
      fields: [ attachment_id, price, bank_code, payment_date, payment_type ]
      type: unique

Attachment_file:
  columns:
    id:            { type: integer, primary: true, autoincrement: true }
    attachment_id: { type: integer, notnull: true }
    file_name:      { type: string(255) }
    name:          { type: string(255) }
  relations:
    Attachment:
      local: attachment_id
      foreign: id
      foreignAlias: Files
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Message:
  columns:
    id:            { type: integer, primary: true, autoincrement: true }
    card_id:       { type: integer, notnull: true }
    description:   { type: clob, notnull: true}
    state:         { type: string(50) }
  relations:
    Card:
      local: card_id
      foreign: id
      foreignAlias: Messages
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Message_file:
  columns:
    id:            { type: integer, primary: true, autoincrement: true }
    message_id: { type: integer, notnull: true }
    file_name:      { type: string(255) }
    name:          { type: string(255) }
  relations:
    Message:
      local: message_id
      foreign: id
      foreignAlias: Files
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Regal:
  columns:
    id:           { type: integer, primary: true, autoincrement: true }
    name:         { type: string(100) }
    surname:      { type: string(100) }
    code:         { type: string(20) }
    company:      { type: string(100) }
    company_code: { type: string(20) }
    city:         { type: string(200) }
    street:       { type: string(200) }
    zipcode:      { type: string(10) }
    phone:        { type: string(20) }
    description:  { type: clob }
    serialnumber:     { type: string(100) }
    note:         { type: clob }
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Regal_file:
  columns:
    id:            { type: integer, primary: true, autoincrement: true }
    regal_id:      { type: integer, notnull: true }
    file_name:     { type: string(255) }
    name:          { type: string(255) }
  relations:
    Regal:
      local: regal_id
      foreign: id
      foreignAlias: Files
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Card_regal:
  columns:
    id:           { type: integer, primary: true, autoincrement: true }
    card_id:      { type: integer }
    regal_id:     { type: integer }
    column_match: { type: string(50) }
  relations:
    Card:
      local: card_id
      foreign: id
      foreignAlias: Regal
    Regal:
      local: regal_id
      foreign: id
  indexes:
    unique_one:
      fields: [ card_id, regal_id, column_match ]
      type: unique
  actAs:
    Timestampable:


Invoice:
  columns:
    id:           { type: integer, primary: true, autoincrement: true }
    supplier_id:  { type: integer }
    code:            { type: string(20) }
    tax_code:        { type: string(20) }
    address_street:  { type: string(200) }
    address_city:    { type: string(200) }
    address_zipcode: { type: string(20) }
    note:            { type: clob }
  relations:
    Supplier:
      local: supplier_id
      foreign: id
      foreignAlias: Invoices
  actAs:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getGuardUser()->id"

Invoice_item:
  columns:
    id:           { type: integer, primary: true, autoincrement: true }
    invoice_id:   { type: integer }
    card_id:      { type: integer }
    price:        { type: decimal(10), scale: 2 }
    has_removal:      { type: boolean }
    has_own:          { type: boolean }
    has_registration: { type: boolean }
    costs:        { type: decimal(10), scale: 2 }
    costs_note:   { type: string(255) }
  relations:
    Invoice:
      local: invoice_id
      foreign: id
      foreignAlias: Items
    Card:
      local: card_id
      foreign: id
      foreignAlias: Invoice_item


sfGuardUserProfile:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    user_id:     { type: integer(4), notnull: true }
    first_name:  { type: string(200) }
    last_name:   { type: string(200) }
    email:       { type: string(255), email: true }
    pass_plain:  { type: string(200) }
    salary_percent: { type: integer(3), notnull: false, default: 50 }
  relations:
    sfGuardUser:
      local: user_id
      foreign: id
      type: one
      foreignType: one
      foreignAlias: Profile
      onDelete: CASCADE

Statistic:
  columns:
    attachment_id:		{ type: integer, primary: true }
    card_id:          { type: integer(4), notnull: true }
    supplier_id:      { type: integer(4), notnull: true }
    user_id:          { type: integer(4), notnull: true }
    user_first_name:	{ type: string(200) }
    user_last_name: 	{ type: string(200) }
    contract_type:		{ type: integer(4) }
    supplier:         { type: string(200) }
    supplier_code:  	{ type: string(200) }
    client:           { type: string(200) }
    start_date:       { type: date }
    end_date:         { type: date }
    case_days:        { type: integer(4) }
    state:            { type: string(200) }
    sum_supplier:     { type: decimal(10), scale: 2 }
    sum_payment:      { type: decimal(10), scale: 2 }
    case_penalty:     { type: decimal(10), scale: 2 }
    cert_taken:       { type: boolean, default: false }
    case_income:      { type: decimal(10), scale: 2 }
    user_finished:		{ type: boolean }