delivery

Tables (4)

delivery (Untitled2)

  • delivery_id (Key) — bigint — Primary key — NOT NULL
  • id (key2) — bigint — Foreign key → menuCategory.id — NOT NULL
  • store_id (FK2) — bigint — Foreign key → menuCategory.store_id — NOT NULL
  • (Field)
  • id (key) — bigint — Foreign key → menuCategory.id — NOT NULL
  • store_id (FK) — bigint — Foreign key → menuCategory.store_id — NOT NULL

delivery_person (CopyOfUntitled2)

  • delivery_id (Key) — bigint — Primary key — NOT NULL
  • (Field)

menuCategory (Untitled)

  • id (key) — bigint — Primary key — NOT NULL
  • store_id (FK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • id (key2) — bigint — Foreign key → store.id — NOT NULL
  • owner_id (FK2) — bigint — Foreign key → store.owner_id — NOT NULL

store

  • id (key) — bigint — Primary key — NOT NULL
  • owner_id (FK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • address (Field2)
  • phone_number (Field3)
  • rating (Field4)
  • delivery_time (Field5)
  • operating_hours (Field6)
  • delivery_areas (Field7)