_
테이블 (6)
객실 (ROOM)
- ROOM_NUMBER (객실번호)
- ROOM_TYPE (객실타입)
- ROOM_FLOOR (객실층수)
- STAFF_ID (직원번호)
고객 (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 (직원직급)