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