jpaRestaurant

Tables (7)

<Value Type>CustomerInfo (고객 정보)

  • phone (전화번호) — String — Primary key — NOT NULL
  • carnum (차량 번호) — String

Customer (고객)

  • customer_id (아이디) — long — Primary key — NOT NULL
  • name (이름) — String
  • customerinfo (고객 정보) — customerInfo

Menu (메뉴)

  • menu_id (Key) — Long — Primary key — NOT NULL
  • name (코스 이름) — String
  • price (가격) — int

Reservateion_Menu (예약 메뉴)

  • Key — Primary key — NOT NULL
  • reservation_id (아이디) — Long — Foreign key → Reservation.reservation_id — NOT NULL
  • menu_id (Key2) — Long — Foreign key → Menu.menu_id — NOT NULL
  • isPaid (결제 상태)
  • quantity (개수) — int

Reservation (예약)

  • reservation_id (아이디) — Long — Primary key — NOT NULL
  • customer_id (아이디2) — long — Foreign key → Customer.customer_id — NOT NULL
  • table (양방향) — List<table>
  • headcount (인원수) — int
  • status (예약 상태)

cooking (요리)

  • cooking_id (id) — Long — Primary key — NOT NULL
  • menu_id (Key) — Long — Foreign key → Menu.menu_id — NOT NULL
  • cookingname (요리 이름) — String

seat (테이블)

  • seat_id (아이디) — Long — Primary key — NOT NULL
  • reservation_id (아이디2) — Long — Foreign key → Reservation.reservation_id — NOT NULL
  • capacity (수용인원) — int
  • isAvailable (예약 가능)