_

테이블 (6)

객실 (ROOM)

  • ROOM_NUMBER (객실번호)
  • ROOM_TYPE (객실타입)
  • ROOM_FLOOR (객실층수)
  • STAFF_ID (직원번호)

객실타입 (ROOM_TYPE)

  • Field

고객 (Customer)

  • CUSTOMER_ID (고객번호) — 기본 키
  • CUSTOMER_LAST_NAME (성)
  • CUSTOMER_FIRST_NAME (이름)
  • CUSTOMER_NATION (국가)
  • CUSTOMER_GENDER (성별)
  • CUSTOMER_BIRTHDATE (생년월일)
  • CUSTOMER_PHONE_NUMBER (핸드폰번호)
  • CUSTOMER_CAR_NUMBER (차번호)
  • CUSTOMER_RECORD (방문기록)

예약 (Reservation)

  • CUSTOMER_ID (고객번호) — key
  • CUSTOMER_NUMBER (고객수)
  • ROOM_NUMBER (객실번호)
  • ROOM_TYPE (객실타입)
  • CHECK_IN_DATE (체크인날짜)
  • CHECK_IN_TIME (체크인시간)
  • CHECK_OUT_DATE (체크아웃날짜)
  • PAYMENT_RECEIVED (결제여부)
  • PET (애완동물여부)

직원 (STAFF)

  • STAFF_ID (직원번호)
  • STAFF_TYPE (직원타입)
  • STAFF_POSITION (직원직급)

직원타입 (STAFF_TYPE)

  • FRONT (프론트)
  • PORTER (짐운반)