tripJPA

테이블 (5)

날짜별 객실 제고 상황 (ROOM_INVENTORY)

  • ROOD_INVENTORY_ID (Key) — INT — 기본 키 — NOT NULL
  • DATE (Field2) — DATETIME
  • PRCIE (Field3) — INT
  • STOCKQUANTITY (Field4) — INT
  • ROOM_TYPE_ID (Key2) — INT — 외래 키 → 룸타입.ROOM_TYPE_ID — NOT NULL

룸타입 (ROOM_TYPE)

  • ROOM_TYPE_ID (Key) — INT — 기본 키 — NOT NULL
  • NAME (Field2) — VARCHAR
  • HOTEL_ID (Key3) — INT — 외래 키 → 호텔.HOTEL_ID — NOT NULL

예약 (BOOKING)

  • BOOKING_ID (Key) — INT — 기본 키 — NOT NULL
  • PRICE (Field3) — INT
  • QUANTITY (Field4) — INT
  • CREATED_AT (Field5) — DATE
  • STATUS (Field6) — VARCHAR
  • CHECKIN_DATE (Field7) — DATETIEM
  • CHECKOUT_DATE (Field8) — DATETIEM
  • MEMBER_ID (Key2) — INT — 외래 키 → 회원.MEMBER_ID — NOT NULL
  • HOTEL_ID (Key3) — INT — 외래 키 → 호텔.HOTEL_ID — NOT NULL
  • ROOM_TYPE_ID (Key4) — INT — 외래 키 → 룸타입.ROOM_TYPE_ID — NOT NULL

호텔 (HOTEL)

  • HOTEL_ID (Key) — INT — 기본 키 — NOT NULL
  • NAME (Field) — VARCHAR
  • LOCATION (Field2) — VARCHAR

회원 (MEMBER)

  • MEMBER_ID (Key) — INT — 기본 키 — NOT NULL
  • NAME (Field) — VARCHAR
  • EMAIL (Field2) — VARCHAR
  • PASSWORD (Field3) — VARCHAR