propel:
  countries:
    _attributes: { phpName: Country }
    id: ~
    name: { type: VARCHAR, size: 50, required: true }
    
  accounts:
    _attributes: { phpName: Account }
    id: ~
    name: { type: VARCHAR, size: 100, required: true }
    url: { type: VARCHAR, size: 100, required: true }
    filename: { type: VARCHAR, size: 100 }
    
  departments:
    _attributes: { phpName: Department }
    id: ~
    name: { type: VARCHAR, size: 100, required: true }
    
  users_accounts:
    _attributes: { phpName: UserAccount }
    id: ~
    user_id: { type: integer, required: true, foreignTable: users, foreignReference: id, onDelete: cascade }
    account_id: { type: integer, required: true, foreignTable: users_rols_accounts, foreignReference: account_id, onDelete: cascade }
    region_id: { type: integer, required: true, primaryKey: true, foreignTable: regions, foreignReference: id, onDelete: cascade }
    rol_id: { type: integer, required: true, foreignTable: users_rols_accounts, foreignReference: rol_id, onDelete: cascade }
    deleted_at: { type: timestamp }
    created_at: ~
    
  users_rols_accounts:
    _attributes: { phpName: UserRolAccount }
    rol_id: { type: integer, required: true, primaryKey: true }
    account_id: { type: integer, required: true, primaryKey: true, foreignTable: accounts, foreignReference: id, onDelete: cascade }
    name: { type: varchar, size: 100, required: true }
    
  regions:
    _attributes: { phpName: Region }
    id: ~
    account_id: { type: integer, required: true, foreignTable: accounts, foreignReference: id, onDelete: cascade, primaryKey: true }
    name: { type: varchar, size: 100, required: true }
    
  nodes_regions:
    _attributes: { phpName: NodeRegion }
    node_id: { type: integer, required: true, foreignTable: nodes, foreignReference: id, onDelete: cascade, primaryKey: true }
    region_id: { type: integer, required: true, foreignTable: regions, foreignReference: id, onDelete: cascade, primaryKey: true }
    account_id: { type: integer, required: true, foreignTable: accounts, foreignReference: id, onDelete: cascade, primaryKey: true }
    
  users: 
    _attributes: { phpName: User }
    id: ~
    username: { type: VARCHAR, size: 50, required: true, index: unique }
    password: { type: VARCHAR, size: 50, required: true, index: unique }
    name: { type: VARCHAR, size: 100, required: true }
    lastname: { type: VARCHAR, size: 100, required: true }
    dni: { type: VARCHAR, size: 100 }
    cuil: { type: VARCHAR, size: 100 }
    email: { type: VARCHAR, size: 100 }
    phone: { type: VARCHAR, size: 100 }
    phone_tmt: { type: VARCHAR, size: 100 }
    gender: { type: integer }
      #1 = Masculino
      #2 = Femenino
    status: { type: integer }
      # 1 = Soltero
      # 2 = Casado
      # 3 = Separado
      # 4 = Divorciado
      # 5 = Viudo
      # 6 = Concubinato
    filename: { type: varchar, size: 150 }
    department_id: { type: integer, foreignTable: departments, foreignReference: id }
    city_id: { type: integer, foreignTable: cities, foreignReference: id }
    address: { type: varchar, size: 150 }
    birthday: { type: timestamp }
    joined_at: { type: timestamp }
    health_book_date: { type: timestamp }
    legajo: { type: varchar, size: 70 }
    coorp: { type: varchar, size: 100 }
    is_admin: { type: boolean, default: 0 }
      # privilegios para acceder al core
    hierarchy: { type: integer, default: 0 }
      # 0: readonly
      # 1: full privileges
    shirt_size: { type: VARCHAR, size: 100 }  
    coat_size: { type: VARCHAR, size: 100 }  
    foot_size: { type: VARCHAR, size: 100 }  
    belt_size: { type: VARCHAR, size: 100 }  
    pant_size: { type: VARCHAR, size: 100 }  
    region_id: { type: integer, default: NULL }
    deleted_by: { type: integer, foreignTable: users, foreignReference: id }
    deleted_at: { type: timestamp }
    updated_by: { type: integer, foreignTable: users, foreignReference: id }
    updated_at: ~
    created_by: { type: integer, foreignTable: users, foreignReference: id }
    created_at: ~
  
  user_supervisors:
    _attributes: { phpName: UserSupervisor }
    id: ~
    account_id: { type: integer, foreignTable: accounts, foreignReference: id, onDelete: cascade, primaryKey: true }
    user_id: { type: integer, required: true, foreignTable: users, foreignReference: id }
    supervisor_id: { type: integer, required: true, foreignTable: users, foreignReference: id }
    
  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 }
    
  chains:
    _attributes: { phpName: Chain }
    id: ~
    name: { type: varchar, size: 100, required: true }
    icon: { type: varchar, size: 250 }
        
  # bocas
  nodes:
    _attributes: { phpName: Node }
    id: ~
    name: { type: varchar, size: 150, required: true }
    address: { type: varchar, size: 150, required: true }
    city_id: { type: integer, required: true, foreignTable: cities, foreignReference: id }
    cp: { type: varchar, size: 100 }
    lat: { type: varchar, size: 200 }
    lng: { type: varchar, size: 200 }
    channel_id: { type: integer, foreignTable: channels, foreignReference: id }
    chain_id: { type: integer, foreignTable: chains, foreignReference: id }
    comercial_name: { type: varchar, size: 150 }
    filename: { type: varchar, size: 250, required: true }
    phone: { type: varchar, size: 100 }
    mail: { type: varchar, size: 100 }
    manager: { type: varchar, size: 100 }
    deleted_at: { type: timestamp }
    created_at: ~
    
  menu_items:
    _attributes: { phpName: MenuItem }
    id: ~
    menu_item_id: { type: integer, foreignTable: menu_items, foreignReference: id, onDelete: cascade }
    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 }
    
  routes:
    _attributes: { phpName: Route }
    id: ~
    account_id: { type: integer, required: true, primaryKey: true, foreignTable: accounts, foreignReference: id, onDelete: cascade }
    name: { type: varchar, size: 100, required: true }
    frequency: { type: integer, default: 1, required: true }
      # 1: Semanal
      # 2: Personalizada
    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: ~
    account_id: { type: integer, required: true, primaryKey: true, foreignTable: accounts, foreignReference: id, onDelete: cascade }
    route_id: { type: integer, foreignTable: routes, foreignReference: id, onDelete: cascade }
    day: { type: integer, required: true }
    date: { type: timestamp }
    
  route_nodes:
    _attributes: { phpName: RouteNode }
    id: ~
    account_id: { type: integer, required: true, primaryKey: true, foreignTable: accounts, foreignReference: id, onDelete: cascade }
    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: ~
    account_id: { type: integer, required: true, primaryKey: true, foreignTable: accounts, foreignReference: id, onDelete: cascade }
    user_id: { type: integer, foreignTable: users, foreignReference: id, onDelete: cascade }
    route_id: { type: integer, foreignTable: routes, foreignReference: id, onDelete: cascade }
    
  checkouts:
    _attributes: { phpName: Checkout }
    id: ~
    account_id: { type: integer, required: true, primaryKey: true, foreignTable: accounts, foreignReference: id, onDelete: cascade }
    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: boolean, default: false }
    json: { type: varchar, size: 200 }
    is_mobile: { type: boolean, default: false }
    visited_at: { type: timestamp }
    left_at: { type: timestamp }
    created_at: ~
    
  documents_categories:
    _attributes: { phpName: DocumentCategory }
    id: ~
    name: { type: VARCHAR, size: 100, required: true }
    
  documents:
    _attributes: { phpName: Document }
    id: ~
    title: { type: VARCHAR, size: 100, required: true }
    description: { type: VARCHAR, required: true }
    filename: { type: VARCHAR, size: 100 }
    document_category_id: { type: integer, foreignTable: documents_categories, foreignReference: id, onDelete: cascade }
    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: ~
    
  documents_users:
    _attributes: { phpName: DocumentUser }
    document_id: { type: integer, foreignTable: documents, foreignReference: id, onDelete: cascade, primaryKey: true }
    user_id: { type: integer, foreignTable: users, foreignReference: id, onDelete: cascade, primaryKey: true }
    
  supervisor_route:
    _attributes: { phpName: SupervisorRoutes }
    id: ~
    name: { type: VARCHAR, size: 100, required: true }
    user_id: { type: integer, required: true, primaryKey: true, foreignTable: users, foreignReference: id, onDelete: cascade }
    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: ~

  supervisor_checkouts:
    _attributes: { phpName: SupervisorCheckout }
    id: ~
    node_id: { type: integer, required: true, primaryKey: true, foreignTable: nodes, foreignReference: id, onDelete: cascade }
    user_id: { type: integer, required: true, primaryKey: true, foreignTable: users, foreignReference: id, onDelete: cascade }
    supervisor_route_id: { type: integer, required: true, primaryKey: true, foreignTable: supervisor_route, foreignReference: id, onDelete: cascade }
    lat: { type: VARCHAR, size: 100, required: true }
    lng: { type: VARCHAR, size: 100, required: true }
    json: { type: VARCHAR, size: 100, required: true }
    visited_at: { type: timestamp }
    created_at: ~
#  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: ~