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