게시판

테이블 (3)

guest_user (예약고객)

  • user_idx (PK) — int — 기본 키 — NOT NULL
  • user_name (아이디) — varchar(40) — NOT NULL
  • user_password (비밀번호) — varchar(255) — NOT NULL
  • user_nickname (닉네임) — varchar(40) — NOT NULL
  • user_date (가입시기) — timestamp — NOT NULL
  • user_phone (전화번호) — varchar(15) — NOT NULL
  • user_email (이메일) — varchar(255) — NOT NULL

reservation (예약)

  • reservation_id (PK) — int — 기본 키 — NOT NULL
  • user_idx (PK2) — int — 외래 키 → guest_user.user_idx — NOT NULL
  • reservation_start (입실일) — date — NOT NULL
  • reservation_end (퇴실일) — date — NOT NULL
  • reservation_people (예약인원) — int — NOT NULL
  • reservation_date (예약날짜) — Datetime — NOT NULL
  • reservation_service (예약서비스) — varchar(50) — NOT NULL

room (객실)

  • room_id (Pk) — int — 기본 키 — NOT NULL
  • reservation_id (PK) — int — 외래 키 → reservation.reservation_id — NOT NULL
  • user_idx (PK2) — int — 외래 키 → reservation.user_idx — NOT NULL
  • room_people (수용인원) — int
  • room_type (객실타입) — varchar(100)
  • room_price (객실비용) — int — NOT NULL
  • room_available (예약가능여부) — TINYINT(1) — NOT NULL