delivery
Tables (8)
Untitled (CUSTOMER)
- Key (customer_id) — VARCHAR(255) — Primary key — NOT NULL
- Key (address_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (delivery_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (restaurant_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (owner_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (auth) — VARCHAR(255) — NOT NULL
- Field (phone_num) — VARCHAR(255) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (updated_at) — DATETIME — NOT NULL
- Field (grade) — VARCHAR(255) — NOT NULL
Untitled (ADDRESS)
- Key (address_id) — VARCHAR(255) — Primary key — NOT NULL
- Key (delivery_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (restaurant_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (owner_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (city_name) — VARCHAR(100) — NOT NULL
- Field (road_name) — VARCHAR(100) — NOT NULL
- Field (zipcode) — VARCHAR(5) — NOT NULL
- Field (home) — TYPEINT(1) — NOT NULL
- Field (detailed_address) — VARCHAR(255) — NOT NULL
Untitled (RESTAURANT)
- Key (restaurant_id) — VARCHAR(255) — Primary key — NOT NULL
- Key (owner_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (restaurant_name) — VARCHAR(255) — NOT NULL
- Field (delivery_type) — VARCHAR(255) — NOT NULL
- Field (tel) — VARCHAR(255) — NOT NULL
- Field (info) — VARCHAR(255) — NOT NULL
- Field (biz_number) — VARCHAR(255) — NOT NULL
- Field (min_pay) — VARCHAR(255) — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (updated_at) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(255) — NOT NULL
- Field (is_work_hour) — VARCHAR(255) — NOT NULL
- Field (order_type) — VARCHAR(255)
- Field (category) — VARCHAR(255)
Untitled (Hours)
- Key (hour_id) — VARCAHR(255) — Primary key — NOT NULL
- Key (restaurant_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (owner_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (start_hour) — TIMESTAMP — NOT NULL
- Field (end_hour) — TIMESTAMP — NOT NULL
Untitled (MENU)
- Key (menu_id) — VARCHAR(255) — Primary key — NOT NULL
- Key (group_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (owner_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (price) — VARCHAR(255) — NOT NULL
- Field (category) — VARCHAR(255) — NOT NULL
- Field (photo) — VARCHAR(255) — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP — NOT NULL
- Field (availability) — VARCHAR(255) — NOT NULL
- Field (info) — VARCHAR(255) — NOT NULL
- Field (priority) — INT(11) — NOT NULL
Untitled (MENU_GROUP)
- Key (group_id) — VARCHAR(255) — Primary key — NOT NULL
- Key (restaurant_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (owner_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (content) — VARCHAR(255) — NOT NULL
- Field (status) — VARCHAR(255) — NOT NULL
Untitled (DELIVERY_LOCATION)
- Key (delivery_id) — VARCHAR(255) — Primary key — NOT NULL
- Key (restaurant_id) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- Key (owner_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field
Untitled (OWNER)
- Key (owner_id) — INT — Primary key — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field2 (tel) — VARCHAR(255) — NOT NULL
- Field3 (status) — VARCHAR(255) — NOT NULL