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