options:
  type: INNODB
  collate: utf8_unicode_ci
  charset: utf8

AdminTable:
  columns:
    jmeno: {type: string(128), notnull: true}
    heslo: {type: string(128), notnull: true}

PharmalinkZakaznik:
  actAs: { Timestampable: ~ }
  columns:
    sf_guard_user_id: integer(4)
    nazev: { type: string(255), notnull: true}
    text_dpp: { type: text }
  relations:
    User:
      class: sfGuardUser
      foreignType: one


PharmalinkKampan:
  actAs: { Timestampable: ~ }
  columns:
    zakaznik_id:  { type: integer, notnull: true }
    nazev: { type: string(255), notnull: true, unique: true }
    text_popis: { type: string(4000)}
    logo:     { type: string(255) }
    barva:    { type: string(7) }
    is_active:    { type: boolean, notnull: true, default: true }
  relations:
    PharmalinkZakaznik: { onDelete: CASCADE, local: zakaznik_id, foreign: id, foreignAlias: Kampane }
    

PharmalinkOtazka:
  columns:
    kampan_id:  { type: integer, notnull: true }
    typ:  { type: string(255), values: [radio, checkbox], notnull: true, default: radio }
    min_odpovedi: { type: integer, notnull: true, default: 1 }
    max_odpovedi: { type: integer, notnull: true, default: 0 }
    text_otazky: { type: string(4000), notnull: true}
    vedlesebe: { type: boolean, notnull: true, default: false }
  relations:
    PharmalinkKampan: {onDelete: CASCADE, local: kampan_id, foreign: id, foreignAlias: Otazky }

PharmalinkDoktor:
  actAs:
    Timestampable: ~
    Sluggable:
      unique: true
      fields: [potvrzeni_kod]
      canUpdate: true
  columns:
    kampan_id:  { type: integer }
    titul_pred: { type: string(255) }
    jmeno: { type: string(255), notnull: true}
    prijmeni: { type: string(255), notnull: true}
    titul_za: { type: string(255) }
    rc: { type: string(255), notnull: true }
    adresa: { type: string(255), notnull: true}
    mesto: { type: string(255), notnull: true}
    psc: { type: integer, notnull: true}
    misto_narozeni: { type: string(255)}
    statni_obcanstvi: { type: string(255)}
    narodnost: { type: string(255)}
    stav: { type: string(255)}
    cislo_uctu: { type: string(255), notnull: true}
    email: { type: string(255), notnull: true, email: true}
    cena: {type: integer }
    cena_slovy: { type: string(255) }
    dpp_pocet_hodin: { type: float }
    kod:   {type: string(255)}
    potvrzeni_dateTime: {type: datetime}
    potvrzeni_ip: {type: string(255)}
    potvrzeni_kod: {type: string(255)}
    vytvoreno_z_admina: {type: integer}
    rodne_prijmeni: { type: string(255), notnull: true}
    zdravotni_pojistovna: { type: string(255), notnull: true}
  relations:
    PharmalinkKampan: { onDelete: CASCADE, local: kampan_id, foreign: id, foreignAlias: Doktori }

PharmalinkOdpoved:
  columns:
    otazka_id:  { type: integer, notnull: true }
    text_odpovedi: { type: string(4000), notnull: true}
  relations:
    PharmalinkOtazka: { onDelete: CASCADE, local: otazka_id, foreign: id, foreignAlias: odpovedi}

PharmalinkDoktor_odpoved:
  columns:
    doktor_id:  { type: integer}
    odpoved_id:  { type: integer, notnull: false}
    otazka_id:  { type: integer, notnull: true }
    text_free:   {type: string(255)}
  relations:
    PharmalinkDoktor:  { onDelete: CASCADE, local: doktor_id, foreign: id }
    PharmalinkOdpoved: { onDelete: CASCADE, local: odpoved_id, foreign: id }

PharmalinkDoktor_subodpoved:
  columns:
    doktor_odpoved_id:  { type: integer, notnull: true}
    odpoved_id:         { type: integer, notnull: true}
  relations:
    PharmalinkDoktor_odpoved:  { onDelete: CASCADE, local: doktor_odpoved_id, foreign: id, foreignAlias: subodpovedi }
    PharmalinkOdpoved: { onDelete: CASCADE, local: odpoved_id, foreign: id }  

PharmalinkVoucher:
   columns:
     kampan_id:  { type: integer, notnull: true }
     kod:   {type: string(255), notnull: true, unique: true}
     popis: {type: string(255), notnull: true}
     cena: {type: integer, notnull: true}
     cena_slovy: { type: string(255)}
     dpp_pocet_hodin: { type: float, notnull: true}
   relations:
     PharmalinkKampan: { onDelete: CASCADE, local: kampan_id, foreign: id }