1
Tables (4)
Accommodation_VO
- ACCOMM_SERIALNUM — VARCHAR2(20) — Primary key — NOT NULL
- ACCOMM_TYPE — NUMBER — NOT NULL
- ACCOMM_NAME — VARCHAR2(20)
- ACCOMM_PLACE — VARCHAR2(20)
- ACCOMM_ROOMTYPE — VARCHAR2(20)
- ACCOMM_PARKINGLOT — NUMBER
Hotel_VO
- ACCOMM_SERIALNUM — VARCHAR2(20) — Foreign key → Accommodation_VO.ACCOMM_SERIALNUM — NOT NULL
- HOTEL_GYM — VARCHAR2
- HOTEL_MT — VARCHAR2
Motel_VO
- ACCOMM_SERIALNUM — VARCHAR2(20) — Foreign key → Accommodation_VO.ACCOMM_SERIALNUM — NOT NULL
- MOTEL_DS — NUMBER
- MOTEL_EVENT — NUMBER
- MOTEL_OT — NUMBER
Resort_VO
- ACCOMM_SERIALNUM — VARCHAR2(20) — Foreign key → Accommodation_VO.ACCOMM_SERIALNUM — NOT NULL
- RESORT_COOK — NUMBER
- RESORT_PT — VARCHAR2