MiniTest

Tables (4)

Accommodation (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 (Hotel_VO)

  • 일련 번호 (ACCOMM_SERIALNUM) — VARCHAR2(20) — Foreign key → Accommodation.일련 번호 — NOT NULL
  • 헬스장 (HOTEL_GYM) — VARCHAR2
  • 회의실 (HOTEL_MT) — VARCHAR2

Motel (Motel_VO)

  • 일련 번호 (ACCOMM_SERIALNUM) — VARCHAR2(20) — Foreign key → Accommodation.일련 번호 — NOT NULL
  • 대실 (MOTEL_DS) — NUMBER
  • 이벤트 (MOTEL_EVENT) — NUMBER
  • 일회용품 (MOTEL_OT) — NUMBER

Resort (Resort_VO)

  • 일련 번호 (ACCOMM_SERIALNUM) — VARCHAR2(20) — Foreign key → Accommodation.일련 번호 — NOT NULL
  • 취사 (RESORT_COOK) — NUMBER
  • 놀이시설 (RESORT_PT) — VARCHAR2