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 (예약 가능)