게시판
테이블 (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