nhn-exam-hotel
테이블 (3)
Untitled (hotel)
- Key (hotel_id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(100) — NOT NULL
Untitled2 (room)
- Key (room_id) — bigint — 기본 키 — NOT NULL
- Key (hotel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (capacity) — tinyint — NOT NULL
- Field (floor) — tinyint — NOT NULL
- Field2 (bathtub_flag) — tinyint(1) — NOT NULL
- Field3 (view_type) — tinyint — NOT NULL
- Field4 (created_at) — datetime — NOT NULL
예약 (reservation)
- 예약 키 (reservation_id) — bigint — 기본 키 — NOT NULL
- Field (check_in) — date — NOT NULL
- Field2 (check_out) — date — NOT NULL
- Field3 (people_count) — int — NOT NULL
- Key (room_id) — bigint — 외래 키 → Untitled2.Key — NOT NULL
- Field (user_id) — bigint — NOT NULL