hotel
Tables (4)
hotels (호텔)
- hotel_id (호텔아이디) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(100) — NOT NULL
member (멤버)
- member_id (회원 아이디) — VARCHAR(30) — Primary key — NOT NULL
- pwd (비밀번호) — VARCHAR(255) — NOT NULL
reservation (예약)
- resevationId (예약아이디) — BIGINT — Primary key — NOT NULL
- id (회원 아이디) — VARCHAR(30) — Foreign key → member.member_id — NOT NULL
- Room_id (방아이디) — BIGINT — Foreign key → rooms.room_id — NOT NULL
- check_in_date (체크인날짜) — DATE — NOT NULL
- check_out_date (체크아웃날짜) — DATE — NOT NULL
rooms (방)
- room_id (방아이디) — BIGINT — Primary key — NOT NULL
- hotel_id (호텔아이디) — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
- name (이름) — VARCHAR(100) — NOT NULL
- capacity (수용량) — TINYINT — NOT NULL
- bathtub_flag — TINYINT(1) — NOT NULL
- view_type — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL