1

테이블 (4)

HOTEL (TB_HOTEL)

  • ROOM_NUM — NUMBER — 기본 키
  • ROOM_NAME
  • ROON_INFO — VARCHAR2(2000)

RESERVATIONS (TB_RESERVATIONS)

  • RESERV_NO — NUMBER — 기본 키 — NOT NULL
  • REG_DATE — DATE
  • RESERV_DATE — DATE — NOT NULL
  • UER__ID — NUMBER — 외래 키 → USER.UER__ID
  • ROOM_NUM — NUMBER — 외래 키 → HOTEL.ROOM_NUM

USER (TB_USER)

  • UER__ID — NUMBER — 기본 키
  • USER_PW — VARCHAR2(10)
  • USER_NAME — VARCHAR2(50)
  • USER_PHONE — VARCHAR2(13)

예약 (RESERVATIONS)

  • 예약번호 (RESERVATION_ID) — NUMBER — 기본 키 — NOT NULL — auto_increment
  • 고객이름 (GUEST_NAME) — VARCHAR2(50) — NOT NULL
  • 방번호 (ROOM_NUMBER) — NUMBER
  • 고객번호 (CONTACT_NUMBER) — VARCHAR2(50)
  • 예약날짜 (RESERVATION_DATE) — DATE — DEFAULT_GENERATED