연습
테이블 (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