Travel
테이블 (8)
accommodation (숙소) (Untitled5)
- accommodation_id (Key) — Long — 기본 키 — NOT NULL
- category (Field) — varchar
- name (Field2) — varchar
- content (Field3) — varchar
- address (Field4) — varchar
- tel (Field6) — varchar
cart (장바구니) (Untitled4)
- cart_id (Key) — Long — 기본 키 — NOT NULL
- product_id (Key2) — Long — 기본 키 — NOT NULL
- room_id (Key3) — Long — 기본 키 — NOT NULL
- checkIn_date (Field4) — LocalDate
- checkOut_date (Field5) — LocalDate
- count (Field6) — int
- price (Field7) — int
member (회원) (Untitled)
- id (Key) — Long — 기본 키 — NOT NULL
- name (Field) — varchar
- loginId (Field2) — varchar
- password (Field3) — varchar
- tel (Field4) — varchar
notice (공지사항) (Untitled2)
- id (Field2) — Long — 기본 키
- name (Field) — varchar
- date (Field3) — LocalDate
- subject (Field4) — varchar
- content (Field5) — varchar
orders (주문정보) (Untitled8)
- order_id (Key) — Long — 기본 키 — NOT NULL
- room_id (Key2) — Long — 기본 키 — NOT NULL
- checkIn (Field) — LocalDate
- checkOut (Field2) — LocalDate
- count (Field3) — int
- price (Field4) — int
product (객실) (Untitled6)
- room_id (Key) — Long — 기본 키 — NOT NULL
- accommodation_id (Key2) — Long — 기본 키 — NOT NULL
- name (Field) — varchar
- count (Field2) — int
- checkIn (Field3) — LocalDate
- checkOut (Field4) — LocalDate
- count_min (Field5) — int
- count_max (Field6) — int
- bed_count (Field7) — int
product_info_per_night (1박) (Untitled7)
- room_id (Key) — Long — 기본 키 — NOT NULL
- date (Field) — LocalDate
- price (Field2) — int
review (상품리뷰) (Untitled3)
- accommodation_id (Key) — Long — 기본 키 — NOT NULL
- id (Key2) — Long — 기본 키 — NOT NULL
- content (Field) — varchar
- rating (Field2) — double
- date (Field3) — LocalDate