Foodtype:
  connection: doctrine
  tableName: FoodType
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    name:
      type: string(255)
  attributes:
    export: all
    validate: true

ProviderFoodtype:
  connection: doctrine
  tableName: provider_foodtype
  columns:
    provider_id:
      type: integer(4)
      primary: true
    foodtype_id:
      type: integer(4)
      primary: true
  relations:
    Foodtype:
      foreignAlias: ProviderFoodtype
    Provider:
      foreignAlias: ProviderFoodtype

DeliveryRegion:
  connection: doctrine
  tableName: DeliveryRegion
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    name:
      type: string(255)
  attributes:
    export: all
    validate: true

ProviderDeliveryRegion:
  connection: doctrine
  tableName: provider_deliveryregion
  columns:
    provider_id:
      type: integer(4)
      primary: true
    deliveryregion_id:
      type: integer(4)
      primary: true
  relations:
    DeliveryRegion:
      foreignAlias: ProviderDeliveryRegion
    Provider:
      foreignAlias: ProviderDeliveryRegion

Provider:
  connection: doctrine
  tableName: Provider
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    name:
      type: string()
      notnull: true
    eng_name:
      type: string()
      notnull: true
    title:
      type: string()
      notnull: true
    description:
      type: string()
      notnull: true
    image:
      type: string()
      notnull: true
    delivery_time:
      type: string()
      notnull: true
    delivery_working_time:
      type: string()
      notnull: true
    delivery_minimal:
      type: string()
      notnull: true
    email:
      type: string()
      notnull: true
    password:
      type: string()
      notnull: true
    is_administrator:
      type: boolean
      notnull: false
  relations:
    FoodType:
      foreignAlias: Provider
      class: Foodtype
      refClass: ProviderFoodtype
    DeliveryRegion:
      foreignAlias: Provider
      class: DeliveryRegion
      refClass: ProviderDeliveryRegion