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