test02

Tables (16)

Card-Company Table (CopyOfUntitled4)

  • Front_Card_num (Key) — VARCHAR(4) — Primary key — NOT NULL
  • Card_num (Key2) — VARCHAR(20) — Foreign key — NOT NULL
  • Card_Company (Field) — VARCHAR(45)

Card_Table (Untitled4)

  • Card_num (Key) — VARCHAR(20) — Primary key — NOT NULL
  • Card_CVC (Field) — INT
  • Card_Validty (Field2) — DATE
  • Card_PW (Field3) — INT

Customer_Table (Untitled3)

  • Customer_ID (손님 ID) — INT — Primary key — NOT NULL
  • Inform_ID (Key) — INT — Foreign key → Information_Table.Inform_ID — NOT NULL
  • Membership_ID (membership id) — INT — Foreign key → Membership_Table.Membership_ID — NOT NULL
  • Card_num (Key2) — VARCHAR(20) — Foreign key → Card_Table.Card_num — NOT NULL
  • Login_ID (로그인아이디) — INT
  • Login_PW (로그인비밀번호) — INT
  • Point (포인트) — INT

Facilities (CopyOfUntitled42)

  • Facility_ID (Key) — INT — Primary key — NOT NULL
  • Hotel_ID (호텔 ID) — INT — Foreign key → Hotel_Table.Hotel_ID — NOT NULL
  • Facility_Type (Field) — INT

Hotel_Address_Table (\)

  • Zip (우편번호) — VARCHAR(15) — Primary key — NOT NULL
  • Street_Number (도로번호) — INT
  • Street_Name (도로명) — VARCHAR(45)
  • city (호텔 도시) — VARCHAR(15)
  • State (주) — VARCHAR(15)

Hotel_Table (/)

  • Hotel_ID (호텔 ID) — INT — Primary key — NOT NULL
  • Zip (우편번호) — VARCHAR(15) — Foreign key → Hotel_Address_Table.Zip — NOT NULL
  • Hotel_Name (호텔 이름) — VARCHAR(20)
  • Hotel_Tel (호텔 전화번호) — VARCHAR(45)

Inform_Address_Table (CopyOfUntitled22)

  • Zip (우편) — VARCHAR(15) — Primary key — NOT NULL
  • Street_Number (도로번호) — INT
  • Street_Name (도로명) — VARCHAR(45)
  • City (도시) — VARCHAR(15)
  • State (주) — VARCHAR(15)

Information_Table (.)

  • Inform_ID (Key) — INT — Primary key — NOT NULL
  • Zip (우편) — VARCHAR(15) — Foreign key → Inform_Address_Table.Zip — NOT NULL
  • First_Name (이름) — VARCHAR(45)
  • Last_Name (성) — VARCHAR(45)
  • E-Mail (이메일) — VARCHAR(45)
  • Fax (팩스) — VARCHAR(45)
  • Birthday (생년월일) — Date
  • Nationality (국적) — VARCHAR(45)
  • Phone_Number (Field) — VARCHAR(45)

Membership_Table (CopyOfUntitled3)

  • Membership_ID (membership id) — INT — Primary key — NOT NULL
  • RANK (멤버십등급) — VARCHAR(20)
  • Accumulation Rate (적립률) — INT
  • Discount Rate (할인율) — INT
  • Price (가격) — INT

Order_Table (CopyOfUntitled2)

  • Order_id (주문 번호) — INT — Primary key — NOT NULL
  • Reservation_ID (Key) — INT — Foreign key → Reservation.Reservation_ID — NOT NULL
  • Cleaning (청소요청) — BOOLEAN
  • Bed (침대추가) — INT
  • Pillow (베개) — INT
  • Breakfast (아침식사) — BOOLEAN
  • Order_time (주문시간) — TIME

Parking Lot (CopyOfCopyOfUntitled42)

  • Parking_lot_ID (Key) — INT — Primary key — NOT NULL
  • Facility_ID (Key2) — INT — Foreign key → Facilities.Facility_ID — NOT NULL
  • Parking_Area (Field) — INT
  • Statue (Field2) — TEXT
  • Car_Num (Field3) — INT
  • Parking_Time (Field4) — TIME

Reservation (CopyOfUntitled)

  • Reservation_ID (Key) — INT — Primary key — NOT NULL
  • Room_ID (방 ID) — INT — Foreign key → Room_Table.Room_ID — NOT NULL
  • Customer_ID (손님 ID) — INT — Foreign key → Customer_Table.Customer_ID — NOT NULL
  • RoomTypeID (방 유형 ID) — INT — Foreign key → Room_Table.RoomTypeID — NOT NULL
  • Check-in (Field) — DATE
  • Check-Out (Field2) — Date
  • Adult (Field3) — INT
  • Child (Field4) — INT
  • PayDate (Field5) — cc
  • PayType (Field6) — asdasd
  • Price (Field7) — INT

Restaurant (CopyOfCopyOfCopyOfUntitled42)

  • Restaurant_ID (Key) — INT — Primary key — NOT NULL
  • Facility_ID (Key2) — INT — Foreign key → Facilities.Facility_ID — NOT NULL
  • Restaurant_Name (Field) — VARCHAR(20)
  • OPEN_TIME (Field2) — TIME
  • CLOSE_TIME (Field3) — TIME
  • COURSE (Field4) — TEXT
  • PRICE (Field5) — INT

Room_Table (Untitled2)

  • Room_ID (방 ID) — INT — Primary key — NOT NULL
  • RoomTypeID (방 유형 ID) — INT — Foreign key → Room_Type_Table.RoomTypeID — NOT NULL
  • Room_Statue (방 상태) — Text
  • Room.Tel. (방 내선번호) — VARCHAR(45)

Room_Type_Table (룸 유형)

  • RoomTypeID (방 유형 ID) — INT — Primary key — NOT NULL
  • RoomType (방 유형) — VARCHAR(20)
  • Beds (침대) — INT
  • Pillow (베개) — INT
  • Size (크기) — INT
  • Price (가격) — Price

Staff_Table (Untitled)

  • Staff_ID (Key) — INT — Primary key — NOT NULL
  • Inform_ID (Key2) — INT — Foreign key → Information_Table.Inform_ID — NOT NULL
  • Password (Field) — INT
  • Salary (Field2) — INT
  • regDate (Field3) — Date
  • isWorking (Field4) — Boolean
  • Statue (Field5) — Text