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