database_

Tables (4)

Address (Untitled2)

  • Key (user_id) — INT — Primary key — NOT NULL
  • Field (adress_address) — VARCHAR(40)
  • Field (adress_details)

Order (Untitled3)

  • Key (user_id) — INT — Primary key — NOT NULL
  • Key (adress_id) — INT — Primary key — NOT NULL
  • Field (order_date) — DATE
  • Field (order_total_cost) — VARCHAR(20)
  • Field

Restaurant (Untitled)

  • Key (restaurant_id) — INT — Primary key — NOT NULL
  • Field (restaurant_name) — VARCHAR(20)
  • Field2 (restaurant_address) — VARCHAR(40)
  • Field3 (restaurant_phone_number) — VARCHAR(20)
  • Field4 (restaurant_status) — VARCHAR(20)
  • Field5 (retsaurant_min_cost)

Untitled (User)

  • Key (user_id) — INT — Primary key — NOT NULL
  • Field (user_name) — VARCHAR(20)
  • Field2 (user_nickname) — VARCHAR(20)
  • Field (user_password) — VARCHAR(20)
  • Field3 (user_birth) — DATE
  • Field4 (user_phone_number) — VARCHAR(20)