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)