---
options:
  collate: utf8_unicode_ci
  charset: utf8

Generic_product:
  columns:
    parent_id:         { type: integer, notnull: false }
    equipment_id:      { type: integer, notnull: true }
    type_note:         { type: string(255) }
    balance:           { type: float }
    gear:              { type: string(255) }
    diameter_disc:     { type: float }
    diameter:          { type: float }
    diameter_str:      { type: string(255) }
    board:             { type: string(255) }
    cutting_width:     { type: float }
    length:            { type: float }
    length_fracture:   { type: float }
    application:       { type: string(255) }
    cooling:           { type: string(255) }
    material:          { type: string(255) }
    diameter_in:       { type: float }
    diameter_out:      { type: float }
    width:             { type: float }
    # sirka drazky
    line_width:        { type: float }
    # zavit
    whorl:             { type: string(255) }
    # rozsah
    extensity:         { type: string(255) }

    profile:           { type: string(255) }
    height:            { type: float }
    length_str:        { type: string(255) }

    tonnage_str:       { type: string(255) }
    tonnage:           { type: float }
    tonnage_couple:    { type: float }

    min_height:        { type: float }
    max_height:        { type: float }
    # svetlost
    gap:               { type: float }
    compression:       { type: float }
    medium:            { type: string(255) }
    # tesnivo
    gasket:            { type: string(255) }
    # zdvih
    uplift:            { type: float }
    uplift_str:        { type: string(255) }
    year:              { type: integer }
    price:             { type: float }
    producer:          { type: string(255) }

    tonnage_car:       { type: float }
    width_prong_car:   { type: float }
    weight_prong_car:  { type: float }
    length_prong_car:  { type: float }
    width_mesh:        { type: float }
    size:              { type: float }
    moto_hours:        { type: float }

    operative_height:  { type: float }

    #nove 28.12.09
    dipper_size:       { type: string(100) } #velikost lopaty
    wheel_diameter:    { type: float }     #prumer kola
    desk_size:         { type: string(100) } #velikost stolu
    desk_iso:          { type: integer }     #ISO typ nosne desky
    loading_area:      { type: string(100) } #lozna plocha
    drift_width:       { type: float }     #sirka posuvu
    length_extended_prong_car:  { type: float } #delka prodlouzene vidle
    
    # Pro dopravu
    weight:            { type: float }
    extra_price:       { type: float }
    extra_price_note:  { type: clob }
    
    modifications:    { type: string(255) }
    snow_capacity:    { type: float }
    water_capacity:   { type: float }
    cut_depth:        { type: float }

    code:              { type: string(255) }
    stock:             { type: integer, default: 0 }
  relations:
    Equipment:         { onDelete: CASCADE, local: equipment_id, foreign: id, foreignAlias: Products, type: one, foreignType: many }

Product:
  inheritance:
    extends: Generic_product
    type: concrete
  actAs:
    Timestampable: ~
    Sluggable:
      fields: [name]
      unique: true
    Versionable: ~
  columns:
    name:              { type: string(255), notnull: true }
    description:       { type: clob}
    # metas
    meta_desc:     { type: string(255) }
    meta_kw:       { type: string(255) }

Request:
  inheritance:
    extends: Generic_product
    type: concrete
  actAs:
    Timestampable: ~
  relations:
    Communication:     { onDelete: CASCADE, local: communication_id, foreign: id, type: one }
  columns:
    person_company:
      type: string(255)
      notnull: true
    person_name:
      type: string(255)
      notnull: true
    person_place:
      type: string(255)
      notnull: true
    person_email:
      type: string(255)
    person_phone:
      type: string(255)
    person_note:
      type: clob
    communication_id:
      type: integer
    status:
      type: integer

Request_product:
  actAs:
    Timestampable: ~
    RelationWithVersion:
      Product:
        class: Product
        local: product_id
        local_version: product_version
        foreign: id
        foreign_version: version
  relations:
    Equipment:         { onDelete: CASCADE, local: equipment_id, foreign: id, type: one }
    Communication:     { onDelete: CASCADE, local: communication_id, foreign: id, type: one }
  columns:
    person_company:
      type: string(255)
      notnull: true
    person_name:
      type: string(255)
      notnull: true
    person_email:
      type: string(255)
    person_phone:
      type: string(255)
    person_note:
      type: clob
    equipment_id:
      type: integer
    communication_id:
      type: integer
    product_id:
      type: integer
    status:
      type: integer


Communication:
  actAs:
    Timestampable: ~
  columns:
    hash: { type: string(20), notnull: true }
  
CommunicationMessage:
  actAs:
    Timestampable: ~
  relations:
    Communication:         { onDelete: CASCADE, local: Communication_id, foreign: id, type: one }
  columns:
    text:
      type: clob
    typeOfMessage:
      type: integer
    communication_id:
      type: integer

Equipment:
  actAs:
    Timestampable: ~
    Sluggable:
      fields: [name]
      unique: true
    Versionable: ~
  columns:
    parent_id:     { type: integer }
    name:          { type: string(255), notnull: true }
    description:   { type: clob }
    main:          { type: boolean, default: false, notnull: true }
    priority:      { type: integer, default: 0, notnull: true }
    permission:    { type: string(255) }
    request_emails: { type: clob }
    indent_emails:  { type: clob }
    meta_desc:     { type: string(255) }
    meta_kw:       { type: string(255) }
    
Image:
  actAs:
    Timestampable: ~
  columns:
    product_id:   { type: integer, notnull: true }
    filename:     { type: string(255), notnull: true }
    main:         { type: boolean, default: false, notnull: true }
  relations:
    Product:      { onDelete: CASCADE, local: product_id, foreign: id, foreignAlias: Images, type: one, foreignType: many }

File:
  actAs:
    Timestampable: ~
  columns:
    product_id:   { type: integer, notnull: true }
    name:         { type: string(255), notnull: true }
    filename:     { type: string(255), notnull: true }
    size:         { type: integer, notnull: true }
  relations:
    Product:      { onDelete: CASCADE, local: product_id, foreign: id, foreignAlias: Files, type: one, foreignType: many }


# ---- Objednávky ----------
Indent:
  actAs:
    Timestampable: ~
  columns:
    tel:                    { type: string(255), notnull: true }
    mail:                   { type: string(255), notnull: true }
    delivery_first_name:    { type: string(255), notnull: true }
    delivery_last_name:     { type: string(255), notnull: true }
    delivery_company:       { type: string(255) }
    delivery_street:        { type: string(255), notnull: true }
    delivery_city:          { type: string(255), notnull: true }
    delivery_zip:           { type: string(255), notnull: true }
    delivery_country:       { type: string(255), notnull: true }
    delivery_ic:            { type: string(255) }
    delivery_dic:           { type: string(255) }
    invoice_first_name:     { type: string(255), notnull: true }
    invoice_last_name:      { type: string(255), notnull: true }
    invoice_company:        { type: string(255) }
    invoice_street:         { type: string(255), notnull: true }
    invoice_city:           { type: string(255), notnull: true }
    invoice_zip:            { type: string(255), notnull: true }
    invoice_country:        { type: string(255), notnull: true }
    invoice_ic:             { type: string(255) }
    invoice_dic:            { type: string(255) }
    shipping:               { type: string(255) }
    shipping_price:         { type: decimal, scale: 2, notnull: true, default: 0 }
    payment:                { type: string(255) }
    payment_price:          { type: decimal, scale: 2, notnull: true, default: 0 }
    pack:                   { type: string(255) }
    pack_price:             { type: decimal, scale: 2, notnull: true, default: 0 }
    pack_arra:              { type: decimal, scale: 2, notnull: true, default: 0 }
    note:                   { type: clob }
    total_price:
      type: decimal
      scale: 2
    status_indent:
      type: enum
      values: [inserted,accepted,adjustment,expirated,storno]
      default: inserted
    communication_id:
      type: integer

Indent_item:
  actAs:
    RelationWithVersion:
      Product:
        class: Product
        local: product_id
        local_version: product_version
        foreign: id
        foreign_version: version
  columns:
    product_id:       { type: integer, notnull: true }
    indent_id:        { type: integer, notnull: true }
    count:            { type: integer, notnull: true }
  relations:
    Indent:           { onDelete: CASCADE, local: indent_id, foreign: id, foreignAlias: Items, type: many, foreignType: many }
  

# ---- Statické stránky ----
Page:
  actAs:
    Timestampable: ~
    Sluggable:
      fields: [title]
      unique: true
    Versionable: ~
  columns:
    parent_id:    { type: integer }
    in_menu:      { type: boolean, default: false, notnull: true }
    title:        { type: string(255), notnull: true }
    introduction: { type: clob }
    body:         { type: clob }
    permission:   { type: string(255) }
    priority:     { type: integer, notnull: true }
    # metas
    description:  { type: clob }
    meta_kw:      { type: string(255) }
  relations:
    Page:     { onDelete: CASCADE, local: parent_id, foreign: id, foreignAlias: Children, type: one, foreignType: many }


# ---- SimpleContactForm ----
Form:
  actAs:
    Timestampable: ~
  columns:
    mail:         { type: string(255) }
    name_form:    { type:string(255) }
    result:       { type: clob }
    form:         { type: object }