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