Hotel
Tables (5)
Guest_information (투숙자정보1)
- guestcode (게스트코드) — varchar2 — Primary key — NOT NULL
- roominfo (객실정보) — varchar2 — Foreign key → Room_information.객실정보 — NOT NULL
- guestinfo (숙박객정보) — varchar2
- name (이름) — varchar2
- tel (연락처) — varchar2
- person (실 사용자) — varchar2
- startday (입실일) — varchar2
- endday (퇴실일) — varchar2
- Field
Hotel_information (예약정보)
- guestinfo (숙박객정보) — varchar2 — Primary key — NOT NULL
- userinfo (사용자정보) — varchar2 — Foreign key → User_information.userinfo — NOT NULL
- roominfo (객실정보) — varchar2 — Foreign key → Guest_information.roominfo — NOT NULL
- Key — Foreign key → Guest_information.guestcode — NOT NULL
- hotelname (호텔이름) — varchar2
- manager (담당자) — varchar2
- hotelinfo (호텔정보) — varchar2
- Field
Hotel_lotto (로또추첨)
- lottonum (로또번호) — varchar2 — Primary key — NOT NULL
- userinfo (사용자정보) — varchar2
Room_information (객실정보)
- 객실정보 (roominfo) — varchar2 — Primary key — NOT NULL
- 객실요금 (pay) — varchar2
- 객실분류 (roomkind) — varchar2
- Field
User_information (사원정보)
- userinfo (사용자정보) — varchar2 — Primary key — NOT NULL
- name (이름) — varchar2
- busa (부서) — varchar2
- joinday (최초입사일) — varchar2
- sabun (사번) — varchar2