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