ATGN02_006_last_test
테이블 (10)
객실 (rooms)
- room_id — BIGINT — 기본 키 — NOT NULL
- hotel_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- capacity — TINYINT — NOT NULL
- floor — TINYINT — NOT NULL
- bathtub_flag — TINYINT(1) — NOT NULL
- view_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- hotel_id (hotel_id2) — BIGINT — 외래 키 → 호텔.hotel_id — NOT NULL
객실가격 (room_prices)
- room_price_id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — NOT NULL
- holiday_id — BIGINT
- season_type — VARCHAR(20) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- room_id (room_id2) — BIGINT — 외래 키 → 객실.room_id — NOT NULL
- holiday_id (holiday_id2) — BIGINT — 외래 키 → 휴일.holiday_id — NOT NULL
객실이미지 (room_images)
- image_id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — NOT NULL
- image_url — TEXT — NOT NULL
- room_id (room_id2) — BIGINT — 외래 키 → 객실.room_id — NOT NULL
예약 (reservations)
- reservation_id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- guest_count — TINYINT — NOT NULL
- reservation_code — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- room_id (room_id2) — BIGINT — 외래 키 → 객실.room_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → 유저.user_id — NOT NULL
유저 (users)
- user_id — BIGINT — 기본 키 — NOT NULL
- user_email — VARCHAR(200) — NOT NULL
- user_name — VARCHAR(60) — NOT NULL
- user_password — VARCHAR(200) — NOT NULL
- user_phonenumber — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- withdrawl_at — DATETIME
유저포인트 (user_points)
- point_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- point — INT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- expired_at — DATETIME — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → 유저.user_id — NOT NULL
호텔 (hotels)
- hotel_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- field — VARCHAR(255)
후기 (reviews)
- review_id — BIGINT — 기본 키 — NOT NULL
- reservation_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- rating — DECIMAL(2,1) — NOT NULL
- visible — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- reservation_id (reservation_id2) — BIGINT — 외래 키 → 예약.reservation_id — NOT NULL
후기이미지 (review_images)
- image_id — BIGINT — 기본 키 — NOT NULL
- review_id — BIGINT — NOT NULL
- image_url — TEXT — NOT NULL
- review_id (review_id2) — BIGINT — 외래 키 → 후기.review_id — NOT NULL
휴일 (holidays)
- holiday_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- date — DATE — NOT NULL