asdf
Tables (11)
booking
- booking_no — int(11) — Primary key — NOT NULL
- room_no — int(11) — NOT NULL
- customer_id — varchar(255) — NOT NULL
- use_people — int(11) — NOT NULL
- booking_state — enum('전','후','리뷰완료') — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
complain
- complain_no — int(11) — Primary key — NOT NULL
- booking_no — int(11) — NOT NULL
- complain_type — enum('비위생적','불친절','옵션 미일치') — NOT NULL
- complain_state — enum('접수','처리중','처리완료') — NOT NULL
- complain_content — text — NOT NULL
- complain_answer — text
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
customer
- customer_id — varchar(255) — Primary key — NOT NULL
- customer_pw — varchar(16) — NOT NULL
- customer_email — varchar(255) — NOT NULL
- customer_name — varchar(255) — NOT NULL
- customer_birth — date — NOT NULL
- customer_phone — varchar(20) — NOT NULL
- customer_gender — enum('M','F') — NOT NULL
- customer_grade — enum('0','1') — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
customer_pw_history
- customer_id — varchar(255) — Primary key — NOT NULL
- customer_pw — varchar(16) — Primary key — NOT NULL
- create_date — datetime — NOT NULL
emp
- emp_no — int(11) — Primary key — NOT NULL
- emp_name — varchar(255) — NOT NULL
- emp_pw — varchar(16) — NOT NULL
- emp_phone — varchar(20) — NOT NULL
- emp_birth — date — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
emp_pw_history
- emp_no — int(11) — Primary key — NOT NULL
- emp_pw — varchar(16) — Primary key — NOT NULL
- create_date — datetime — NOT NULL
oneday_price
- room_no — int(11) — Primary key — NOT NULL
- room_date — date — Primary key — NOT NULL
- room_price — int(11) — NOT NULL
- room_state — enum('예약 가능','예약 완료') — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
revenue_status
- booking_no — int(11) — Primary key — NOT NULL
- revenue — int(11) — NOT NULL
- create_date — datetime — NOT NULL
review
- booking_no — int(11) — Primary key — NOT NULL
- rating — int(11) — NOT NULL
- review_content — text — NOT NULL
- create_date — datetime — NOT NULL
room
- room_no — int(11) — Primary key — NOT NULL
- customer_id — varchar(255) — NOT NULL
- room_name — varchar(255) — NOT NULL
- room_theme — varchar(255) — NOT NULL
- room_address — varchar(255) — NOT NULL
- operation_start — date — NOT NULL
- operation_end — date — NOT NULL
- max_people — int(11) — NOT NULL
- room_content — text — NOT NULL
- room_category — enum('펜션','호텔','리조트','카라반','글램핑','한옥') — NOT NULL
- approve_state — enum('미승인','승인','반려','재승인') — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
room_img
- room_img — varchar(255) — Primary key — NOT NULL
- room_no — int(11) — NOT NULL