propel:
  countries:
    _attributes: { phpName: Country }
    id: ~
    name: { type: VARCHAR, size: 50, required: true }
    
  regions:
    _attributes: { phpName: Region }
    id: ~
    name: { type: VARCHAR, size: 50, required: true }
    
  user_rols:
    _attributes: { phpName: UserRol }
    id: ~
    name: { type: VARCHAR, size: 100, required: true }

  users: 
    _attributes: { phpName: User }
    id: ~
    username: { type: VARCHAR, size: 50, required: true, index: unique }
    name: { type: VARCHAR, size: 100, required: true }
    lastname: { type: VARCHAR, size: 100, required: true }
    email: { type: VARCHAR, size: 100, required: true }
    phone: { type: VARCHAR, size: 100, required: true }
    gender: { type: integer }
      #1 = Masculino
      #2 = Femenino
    status: { type: integer }
      # 1 = Soltero
      # 2 = Casado
      # 3 = Separado
      # 4 = Divorciado
      # 5 = Viudo
    couple: { type: varchar, size: 100 }
    has_kids: { type: boolean, default: false }
    filename: { type: varchar, size: 150 }
    city_id: { type: integer, foreignTable: cities, foreignReference: id }
    address: { type: varchar, size: 150 }
    description: { type: longvarchar }
    password: { type: VARCHAR, size: 32, required: true, default: <?php echo md5('1234') ?> }
    joined_at: { type: timestamp }
    birthday: { type: timestamp }
    football_team: { type: varchar, size: 100 }
    shirt_size: { type: varchar, size: 5 }
      # XS - S - M - L - XL - XXL
    pant_size: { type: integer }
    foot_size: { type: integer }
    legajo: { type: varchar, size: 70 }
    coorp: { type: varchar, size: 100 }
    device_model: { type: varchar, size: 100 }
    device_imei: { type: varchar, size: 20 }
    android_version: { type: varchar, size: 20 }
    app_version: { type: varchar, size: 20 }
    rol_id: { type: integer, required: true, foreignTable: user_rols, foreignReference: id }
    region_id: { type: integer, required: true, foreignTable: regions, foreignReference: id }
    is_admin: { type: integer, required: true, default: 0 }
    deleted_at: { type: timestamp }
    updated_at: ~
    created_at: ~
  
  user_supervisors:
    _attributes: { phpName: UserSupervisor }
    id: ~
    user_id: { type: integer, required: true, foreignTable: users, foreignReference: id }
    supervisor_id: { type: integer, required: true, foreignTable: users, foreignReference: id }
    
  user_log:
    _attributes: { phpName: UserLog }
    id: ~
    user_id: { type: integer, required: true, foreignTable: users, foreignReference: id, onDelete: cascade }
    ip: { type: varchar, size: 50 }
    login_at: { type: timestamp }
    logout_at: { type: timestamp }
    
  provinces:
    _attributes: { phpName: Province }
    id: ~
    name: { type: varchar, size: 100, required: true }
    country_id: { type: integer, required: true, foreignTable: countries, foreignReference: id }
  
  cities:
    _attributes: { phpName: City }
    id: ~
    name: { type: varchar, size: 100, required: true }
    cp: { type: integer, size: 4, required: true }
    province_id: { type: integer, foreignTable: provinces, foreignReference: id, default: 0 }
    
  channels:
    _attributes: { phpName: Channel }
    id: ~
    name: { type: varchar, size: 100, required: true }
    
  channel_formats:
    _attributes: { phpName: Format }
    id: ~
    channel_id: { type: integer, foreignTable: channels, foreignReference: id, onDelete: cascade }
    name: { type: varchar, size: 100 }
    
  chains:
    _attributes: { phpName: Chain }
    id: ~
    name: { type: varchar, size: 100, required: true }
    icon: { type: varchar, size: 250 }
    mail: { type: varchar, size: 100 }
    
  suppliers:
    _attributes: { phpName: Supplier }
    id: ~
    name: { type: varchar, size: 100, required: true }
    mail: { type: varchar, size: 100, required: true }
        
  # bocas
  nodes:
    _attributes: { phpName: Node }
    id: ~
    custom_id: { type: integer }
    address: { type: varchar, size: 150, required: true }
    city_id: { type: integer, required: true, foreignTable: cities, foreignReference: id }
    region_id: { type: integer, required: true, foreignTable: regions, foreignReference: id }
    lat: { type: varchar, size: 200 }
    lng: { type: varchar, size: 200 }
    channel_id: { type: integer, foreignTable: channels, foreignReference: id }
    channel_format_id: { type: integer, foreginTable: channel_formats, foreignReference: id }
    cluster_id: { type: integer, foreignTable: clusters, foreignReference: id }
    chain_id: { type: integer, foreignTable: chains, foreignReference: id }
    comercial_name: { type: varchar, size: 150 }
    name: { type: varchar, size: 150, required: true }
    filename: { type: varchar, size: 250, required: true }
    phone: { type: varchar, size: 100 }
    mail: { type: varchar, size: 100 }
    mail_executive: { type: varchar, size: 100 }
    manager: { type: varchar, size: 100 }
    branch: { type: integer }
    weight: { type: double }
    window: { type: integer, default: 0 }
      # 1 = No
      # 2 = Dermo
      # 3 = Masivo
    has_perfumery_exhibitor: { type: boolean, default: false }
    supplier_id: { type: integer, foreignTable: suppliers, foreignReference: id }
    sellers: { type: integer, default: 0 }
    backlight: { type: integer, default: 0 }
      # 1 = No
      # 2 = Dermo
      # 3 = Masivo
    has_gondola: { type: boolean, default: false }
    deleted_at: { type: timestamp }
    created_at: ~
    
  node_targets:
    _attributes: { phpName: NodeTarget }
    id: ~
    node_id: { type: integer, foreignTable: nodes, foreignReference: id, required: true }
    user_id: { type: integer, foreignTable: users, foreignReference: id }
    name: { type: varchar, size: 150, required: true }
    value: { type: integer, foreignTable: node_target_values, foreignReference: id }
    completed: { type: timestamp }
    created_by: { type: integer, foreignTable: users, foreignReference: id, required: true }
    expire_at: { type: timestamp }
    created_at: ~
    
  node_target_values:
    _attributes: { phpName: NodeTargetValue }
    id: ~
    name: { type: varchar, size: 100, required: true }
    
  node_images:
    _attributes: { phpName: NodeImage }
    id: ~
    node_id: { type: integer, foreignTable: nodes, foreignReference: id, required: true }
    title: { type: varchar, size: 100, required: true }
    filename: { type: varchar, size: 100, required: true }
    created_at: ~
    
  form_types:
    _attributes: { phpName: FormType }
    id: ~
    name: { type: varchar, size: 100, required: true }
    
  form_conditions:
    _attributes: { phpName: FormCondition }
    id: ~
    name: { type: varchar, size: 100, required: true }
    description: { type: varchar, size: 255, required: true }
  # 1 : Normal
  # 2 : 1xUsuario_PDV_Semana
  # 3 : 1xUsuario_PDV_Quincena
  # 4 : 1xUsuario_PDV_Mes
  # 5 : 1xUsuario_PDV
    
  forms:
    _attributes: { phpName: Form }
    id: ~
    name: { type: varchar, size: 100, required: true }
    type_id: { type: integer, foreignTable: form_types, foreignReference: id, required: true }
    condition_id: { type: integer, foreignTable: form_conditions, foreignReference: id, required: true }
    deleted_at: { type: timestamp }
    ordering: { type: integer, default: 0 }
    estimated: { type: integer, default: 0 }
      # minutes
    has_report: { type: boolean, default: false }
    updated_at: ~
    created_at: ~
    
  form_planification:
    _attributes: { phpName: FormPlanification }
    id: ~
    form_id: { type: integer, foreignTable: forms, foreignReference: id, required: true }
    date: { type: timestamp }
    
  form_rols:
    _attributes: { phpName: FormRol }
    id: ~
    form_id: { type: integer, foreignTable: forms, foreignReference: id, required: true, onDelete: cascade }
    rol_id: { type: integer, foreignTable: user_rols, foreignReference: id, required: true, onDelete: cascade }
    
  categories:
    _attributes: { phpName: Category }
    id: ~
    name: { type: varchar, size: 100, required: true }
    deleted_at: { type: timestamp }
    
  subcategories:
    _attributes: { phpName: Subcategory }
    id: ~
    name: { type: varchar, size: 100, required: true }
    category_id: { type: integer, foreignTable: categories, foreignReference: id }
    deleted_at: { type: timestamp }
    
  brands:
    _attributes: { phpName: Brand }
    id: ~
    name: { type: varchar, size: 100, required: true }
    
  manufacturers:
    _attributes: { phpName: Manufacturer }
    id: ~
    name: { type: varchar, size: 100, required: true }
    
  tags:
    _attributes: { phpName: Tag }
    id: ~
    name: { type: varchar, size: 100, required: true }
    subcategory_id: { type: integer, foreignTable: subcategories, foreignReference: id }
    ean: { type: varchar, size: 100 }
    brand_id: { type: integer, foreignTable: brands, foreignReference: id }
    manufacturer_id: { type: integer, foreignTable: manufacturers, foreignReference: id }
    focus: { type: boolean, default: false }
    deleted_at: { type: timestamp }
    
  suppliers_tags:
    _attributes: { phpName: SupplierTag }
    id: ~
    supplier_id: { type: integer, foreignTable: suppliers, foreignReference: id, onDelete: cascade }
    tag_id: { type: integer, foreignTable: tags, foreignReference: id, onDelete: cascade }
    
  forms_tags:
    _attributes: { phpName: FormTag }
    id: ~
    form_id: { type: integer, foreignTable: forms, foreignReference: id, required: true, onDelete: cascade }
    tag_id: { type: integer, foreignTable: tags, foreignReference: id, required: true, onDelete: cascade }
    max_value: { type: double }
    min_value: { type: double }
    ordering: { type: integer, default: 0 }
    
  form_custom_values:
    _attributes: { phpName: FormCustomValue }
    id: ~
    name: { type: varchar, size: 100, required: true }
    form_id: { type: integer, foreignTable: forms, foreignReference: id, required: true, onDelete: cascade }
    
  node_forms:
    _attributes: { phpName: NodeForm }
    id: ~
    node_id: { type: integer, foreignTable: nodes, foreignReference: id, onDelete: cascade }
    form_id: { type: integer, foreignTable: forms, foreignReference: id, required: true, onDelete: cascade }
    
  node_inactive_tags:
    _attributes: { phpName: NodeInactiveTag }
    id: ~
    node_id: { type: integer, foreignTable: nodes, foreignReference: id, onDelete: cascade }
    tag_id: { type: integer, foreignTable: tags, foreignReference: id, required: true, onDelete: cascade }
    
  checkouts:
    _attributes: { phpName: Checkout }
    id: ~
    node_id: { type: integer, foreignTable: nodes, foreignReference: id, onDelete: cascade }
    user_id: { type: integer, foreignTable: users, foreignReference: id, onDelete: cascade }
    route_id: { type: integer, foreignTable: routes, foreignReference: id, onDelete: cascade }
    lat: { type: varchar, size: 200 }
    lng: { type: varchar, size: 200 }
    complete: { type: integer, default: 0 }
    json: { type: varchar, size: 200 }
    is_mobile: { type: boolean, default: false }
    visited_at: { type: timestamp }
    left_at: { type: timestamp }
    created_at: ~
    
  checkout_data:
    _attributes: { phpName: CheckoutData }
    id: ~
    checkout_id: { type: integer, foreignTable: checkouts, foreignReference: id, onDelete: cascade }
    form_id: { type: integer, foreignTable: forms, foreignReference: id, onDelete: cascade }
    tag_id: { type: integer, foreignTable: tags, foreignReference: id, onDelete: cascade }
    value: { type: double, default: 0 }
    text: { type: longvarchar }
    filename: { type: varchar, size: 255 }
    created_at: ~
    active: { type: boolean, default: true }
    
  routes:
    _attributes: { phpName: Route }
    id: ~
    name: { type: varchar, size: 100, required: true }
    frequency: { type: integer, default: 1, required: true }
      # 1: Semanal
      # 2: Personalizada
    completed: { type: boolean, default: false }
    date_from: { type: timestamp, required: true }
    date_to: { type: timestamp, required: true }
    deleted_by: { type: integer, foreignTable: users, foreignReference: id, onDelete: cascade }
    deleted_at: { type: timestamp }
    updated_by: { type: integer, foreignTable: users, foreignReference: id, onDelete: cascade }
    updated_at: ~
    created_by: { type: integer, foreignTable: users, foreignReference: id, onDelete: cascade }
    created_at: ~
    
  route_planification:
    _attributes: { phpName: RoutePlanification }
    id: ~
    route_id: { type: integer, foreignTable: routes, foreignReference: id, onDelete: cascade }
    day: { type: integer, required: true }
    date: { type: timestamp }
    
  route_nodes:
    _attributes: { phpName: RouteNode }
    id: ~
    node_id: { type: integer, foreignTable: nodes, foreignReference: id, onDelete: cascade }
    route_id: { type: integer, foreignTable: routes, foreignReference: id, onDelete: cascade }
    from_hour: { type: float } 
      # time
    to_hour: { type: float }
      # time
    
  route_users:
    _attributes: { phpName: RouteUser }
    id: ~
    user_id: { type: integer, foreignTable: users, foreignReference: id, onDelete: cascade }
    route_id: { type: integer, foreignTable: routes, foreignReference: id, onDelete: cascade }
    
  alerts:
    _attributes: { phpName: Alert }
    id: ~
    subject: { type: varchar, size: 100 }
    body: { type: longvarchar }
    # autor
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    created_at: ~
    
  alert_users:
    _attributes: { phpName: AlertUser }
    id: ~
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    alert_id : { type: integer, foreignTable: alerts, foreignReference: id, required: true, onDelete: cascade }
    readed_at: { type: timestamp }
    
  news:
    _attributes: { phpName: News }
    id: ~
    title: { type: varchar, size: 100, required: true }
    body: { type: longvarchar }
    filename: { type: varchar, size: 100 }
    # autor
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    created_at: ~
    
  elearning:
    _attributes: { phpName: Elearning }
    id: ~
    title: { type: varchar, size: 150, required: true }
    description: { type: longvarchar }
    # autor
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    youtube: { type: varchar, size: 100 }
    filename1: { type: varchar, size: 100 }
    filename2: { type: varchar, size: 100 }
    filename3: { type: varchar, size: 100 }
    filename4: { type: varchar, size: 100 }
    filename5: { type: varchar, size: 100 }
    created_at: ~
    
  elearning_users:
    _attributes: { phpName: ElearningUser }
    id: ~
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    elearning_id: { type: integer, foreignTable: elearning, foreignReference: id, required: true, onDelete: cascade }
    
  elearning_answers:
    _attributes: { phpName: ElearningAnswer }
    id: ~
    description: { type: varchar, size: 150 }
    question_id: { type: integer, foreignTable: elearning_questions, foreignReference: id, required: true, onDelete: cascade }

  elearning_questions:
    _attributes: { phpName: ElearningQuestion }
    id: ~
    description: { type: varchar, size: 150, required: true }
    elearning_id: { type: integer, foreignTable: elearning, foreignReference: id, required: true, onDelete: cascade }
    answer_id: { type: integer }
    created_at: ~
  
  elearning_checkouts:
    _attributes: { phpName: ElearningCheckout }
    id: ~
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    question_id: { type: integer, foreignTable: elearning_questions, foreignReference: id, required: true, onDelete: cascade }
    answer_id: { type: integer, foreignTable: elearning_answers, foreignReference: id, required: true, onDelete: cascade }
    
  exhibitors:
    _attributes: { phpName: Exhibitor }
    id: ~
    name: { type: varchar, size: 150, required: true }
    channel_id: { type: integer, foreignTable: channels, foreignReference: id, required: true, onDelete: cascade }
    created_at: ~
    deleted_at: { type: timestamp }
    
  exhibitor_nodes:
    _attributes: { phpName: ExhibitorNode }
    id: ~
    node_id: { type: integer, foreignTable: nodes, foreignReference: id, onDelete: cascade }
    exhibitor_id: { type: integer, foreignTable: exhibitors, foreignReference: id, onDelete: cascade }
    state_id: { type: integer }
    value: { type: integer, default: 0 }
    updated_by: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    updated_at: ~
    created_at: ~
    deleted_at: { type: timestamp }
    
  exhibitor_states:
    _attributes: { phpName: ExhibitorState }
    id: ~
    name: { type: varchar, size: 100 }
    
  clusters:
    _attributes: { phpName: Cluster }
    id: ~
    name: { type: varchar, size: 100 }
    
  channel_formats_clusters:
    _attributes: { phpName: ChannelFormatCluster }
    id: ~
    channel_format_id: { type: integer, foreignTable: channel_formats, foreignReference: id, required: true, onDelete: cascade }
    cluster_id: { type: integer, foreignTable: clusters, foreignReference: id, required: true, onDelete: cascade }
    
  menu_items:
    _attributes: { phpName: MenuItem }
    id: ~
    menu_item_id: { type: integer, foreignTable: menu_items, foreignReference: id, onDelete: cascade }
    user_rol_id: { type: integer, foreignTable: user_rols, foreignReference: id, required: true }
    name: { type: varchar, size: 100, required: true }
    url: { type: varchar, size: 100, required: true }
    module: { type: varchar, size: 100, required: true }
    action: { type: varchar, size: 100, required: true }
    has_submenu: { type: boolean, default: false }
    icon: { type: varchar, size: 100, required: true }
    ordering: { type: integer, default: 0 }
    active: { type: boolean, default: true }
    
  user_presenteeism:
    _attributes: { phpName: UserPresenteeism }
    id: ~
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    value: { type: integer }
    date: { type: timestamp }
    comments: { type: varchar, size: 250 }
    created_at: ~
    
  user_replacement:
    _attributes: { phpName: UserReplacement }
    id: ~
    user_id: { type: integer, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    user_presenteeism_id: { type: integer, foreignTable: user_presenteeism, foreignReference: id, required: true, onDelete: cascade }
    value: { type: integer }
    covered_hours: { type: double }
    created_at: ~