연습

테이블 (9)

Customer

  • Customer_ID — INT — 기본 키 — NOT NULL — Primary Key
  • User_ID — VARCHAR — NOT NULL — User_ID
  • User_Password — VARCHAR — NOT NULL — User_Password
  • Fname (Field3) — VARCHAR — NOT NULL
  • Lname (Field4) — VARCHAR — NOT NULL
  • email (Field5) — VARCHAR — NOT NULL
  • phone1 (Field10) — VARCHAR — NOT NULL — 집
  • phone2 (Field12) — VARCHAR — 회사
  • phone3 (Field11) — VARCHAR — NOT NULL — 개인전화
  • address1 (Field6) — VARCHAR — NOT NULL — 도, 특별시
  • address2 (Field7) — VARCHAR — NOT NULL — 시, 군
  • address3 (Field) — VARCHAR — NOT NULL — 읍, 면, 동
  • address4 — VARCHAR — NOT NULL — 도로명 주소
  • address5 (Field8) — VARCHAR — NOT NULL — 상세주소
  • gender (Field9) — INT — 0 => man 1 => woman
  • membership (Field2) — BOOL — NOT NULL — 멤버쉽 회원 유무
  • sms (Field13) — BOOL — NOT NULL — SMS 수신 동의 여부

Department

  • Department_ID (Key) — INT — 기본 키 — NOT NULL
  • department_name (Field) — VARCHAR
  • job (Field2) — VARCHAR

Employee

  • Employee_ID (Customer_ID) — INT — 기본 키 — NOT NULL — Primary Key
  • Department_ID (Key) — INT — 외래 키 → Department.Department_ID — NOT NULL
  • rank (Field13) — VARCHAR — NOT NULL — SMS 수신 동의 여부
  • Fname (Field3) — VARCHAR — NOT NULL
  • Lname (Field4) — VARCHAR — NOT NULL
  • email (Field5) — VARCHAR — NOT NULL
  • phone1 (Field10) — VARCHAR — NOT NULL — 집
  • phone2 (Field11) — VARCHAR — NOT NULL — 개인전화
  • address1 (Field6) — VARCHAR — NOT NULL — 도, 특별시
  • address2 (Field7) — VARCHAR — NOT NULL — 시, 군
  • address3 (Field) — VARCHAR — NOT NULL — 읍, 면, 동
  • address4 — VARCHAR — NOT NULL — 도로명 주소
  • address5 (Field8) — VARCHAR — NOT NULL — 상세주소
  • gender (Field9) — INT — 0 => man 1 => woman
  • salary (Field2) — INT

Reservation (Untitled3)

  • Reservation_ID (Key2) — INT — 기본 키 — NOT NULL
  • Customer_ID — INT — 외래 키 → Customer.Customer_ID — NOT NULL — Primary Key
  • Room_ID (Key) — INT — 외래 키 → Room.Room_ID — NOT NULL
  • res_number (Field) — VARCHAR
  • payment_method (Field2) — VARCHAR — Card or Cash
  • due (Field3) — DATE

Room (Untitled2)

  • Room_ID (Key) — INT — 기본 키 — NOT NULL
  • cleaning (Field5) — BOOL — 청소상태 유무
  • checkin (Field3) — BOOL
  • checkout (Field4) — BOOL

RoomService (Untitled4)

  • RoomService_ID (Key) — INT — 기본 키 — NOT NULL
  • Room_ID (Key2) — INT — 외래 키 → Room.Room_ID — NOT NULL
  • Employee_ID (Customer_ID) — INT — 외래 키 → Employee.Employee_ID — NOT NULL — Primary Key
  • order_food (Field) — VARCHAR
  • order_service (Field2) — VARCHAR
  • order_item (Field3) — VARCHAR

RoomType (Untitled6)

  • Room_ID (Key) — INT — 외래 키 → Room.Room_ID — NOT NULL
  • floor (Field4) — INT
  • room_number (Field5) — INT
  • level (Field) — VARCHAR
  • smoking (Field2) — BOOL
  • price (Field3) — INT

payment (Untitled)

  • Customer_ID — INT — 외래 키 → Customer.Customer_ID — NOT NULL — Primary Key
  • card_number (Field) — INT
  • validity (Field3) — DATE(MM-YY)
  • CVC (Field4) — INT
  • bank_name (Field2) — VARCHAR
  • card_password (Field5) — INT

refund (Untitled5)

  • Refund_ID (Key) — INT — 기본 키 — NOT NULL
  • Customer_ID — INT — 외래 키 → Customer.Customer_ID — NOT NULL — Primary Key
  • Reservation_ID (Key2) — INT — 외래 키 → Reservation.Reservation_ID — NOT NULL
  • reaseon (Field) — VARCHAR
  • refund_account_number (Field2) — VARCHAR
  • refund_account_bank (Field3) — VARCHAR