# config schema.yml
propel:
  mataajir_category:
    id:               ~
    name:             { type: varchar(255), required: true, index: unique }
    parent_id:        { type: integer, foreignTable: mataajir_category, foreignReference: id }
    is_activated:     { type: boolean, required: true, default: 1 }
    slug:         		{ type: varchar(255), required: true, index: unique }

  mataajir_country:
    id:               ~
    name:             { type: varchar(255), required: true, index: unique }
    abbreviation:     { type: varchar(5), required: true }
    web_address:      { type: varchar(255) }
    description:      { type: longvarchar, required: true }
    is_activated:     { type: boolean, required: true, default: 1 }
    slug:         		{ type: varchar(255), required: true, index: unique }

  mataajir_city:
    id:               ~
    name:             { type: varchar(255), required:true, index:unique }
    country_id:       { type: integer, foreignTable: mataajir_country, foreignReference: id, required: true }
    abbreviation:     { type: varchar(5), required: true }
    web_address:      { type: varchar(255) }
    description:      { type: longvarchar, required: true }
    is_activated:     { type: boolean, required: true, default: 1 }
    slug:        			{ type: varchar(255), required: true, index: unique }

  mataajir_store:
    id:               ~
    city_id:          { type: integer, foreignTable: mataajir_city, foreignReference: id, required: true }
    name:             { type: varchar(255), required: true, index: unique }
    logo:         		{ type: varchar(255) }
    web_address:      { type: varchar(255), index: unique }
    description:      { type: longvarchar, required: true }
    featured:         { type: boolean, required: true, default: 0 }
    street:           { type: varchar(200), required: true }
    city:             { type: varchar(200), required: true }
    country:          { type: varchar(200), required: true }
    zip_code:         { type: varchar(15), required: true }
    state:            { type: varchar(100), required: true }
    phone_number:     { type: varchar(30) }
    owner_username:   { type: varchar(150), required: true, index: unique }
    owner_password:   { type: varchar(20), required: true }
    owner_firstname:  { type: varchar(255) }
    owner_lastname:   { type: varchar(255) }
    owner_email:      { type: varchar(255) }
    expires_at:       { type: timestamp, required:true }
    created_at:       ~

  mataajir_log:
    id:               ~
    name:             { type: varchar(200), required: true }
    description:      { type: longvarchar, require: true }
    created_at:       ~

  mataajir_store_category:
    id:               ~
    store_id:         { type: integer, foreignTable: mataajir_store, foreignReference: id, required: true, primaryKey: true, onDelete: cascade }
    category_id:      { type: integer, foreignTable: mataajir_category, foreignReference: id, required: true, primaryKey: true, onDelete: cascade }