Restaurant reservation
Tables (6)
DateFood (그날 메뉴)
- dateFoodId — Primary key — NOT NULL
- date
- type
DateMenuAssign (Untitled)
- dateMenuAssignId — Primary key — NOT NULL
- dateFoodId — Foreign key → DateFood.dateFoodId — NOT NULL
- MenuId — Foreign key → Menu.MenuId — NOT NULL
Department (부서)
- departmentId — Primary key — NOT NULL
- code
- name
Menu (메뉴)
- MenuId — Primary key — NOT NULL
- name
- Field
Reservation (예약)
- ReservationId — Primary key — NOT NULL
- userId — Foreign key → User.userId — NOT NULL
- dateFoodId — Foreign key → DateFood.dateFoodId — NOT NULL
User (회원)
- userId — Primary key — NOT NULL
- departmentId — Foreign key → Department.departmentId — NOT NULL
- username
- name
- password
- phone