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