databaseSystem_homework#1

Tables (8)

Customer (customer)

  • customer_num (Key) — int — Primary key — NOT NULL
  • customer_name (Field) — varchar(100)
  • customer_phone (Field2) — varchar(100)
  • customer_address (Field3) — varchar(100)
  • customer_email (Field4) — varchar(100)

Employee (Untitled2)

  • employee_num (Key) — int — Primary key — NOT NULL
  • employee_name (Field) — varchar(100)
  • employee_position (Field2) — varchar(100)
  • employee_working_day (Field3) — date
  • employee_phone (Field4) — varchar(100)

Menu (Untitled)

  • menu_id (Key) — int — Primary key — NOT NULL
  • menu_name (Field) — varchar(100)
  • menu_description (Field2) — varchar(1000)
  • menu_price (Field3) — int
  • menu_category (Field4) — varchar(100)

Menu_Order (Untitled7)

  • menu_id (Key) — int — Foreign key → Menu.menu_id — NOT NULL
  • order_num (Key2) — int — Foreign key → OrderDetail.order_num — NOT NULL

Order (Untitled5)

  • order_num (Key) — int — Primary key — NOT NULL
  • order_date (Field) — date
  • order_price (Field3) — int
  • customer_num (Key2) — int — Foreign key → Customer.customer_num — NOT NULL
  • employee_num (Key3) — int — Foreign key → Employee.employee_num — NOT NULL

OrderDetail (Untitled6)

  • order_num (Key) — int — Foreign key → Order.order_num — NOT NULL
  • order_menu_count (Field) — int

Reservation (Untitled4)

  • reservation_num (Key) — int — Primary key — NOT NULL
  • reservation_date (Field) — date
  • reservation_customer_count (Field2) — int
  • customer_num (Key2) — int — Foreign key → Customer.customer_num — NOT NULL
  • seat_num (Key3) — int — Foreign key → Seat.seat_num — NOT NULL

Seat (Untitled3)

  • seat_num (Key) — int — Primary key — NOT NULL
  • seat_count (Field) — int