exam-hotel
Tables (9)
hotels (호텔)
- 호텔아이디 (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(100) — NOT NULL
member (멤버)
- 멤버아이디 (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(45) — NOT NULL
- 비밀번호 (password) — VARCHAR(255) — NOT NULL
- 이메일 (email) — VARCHAR(255) — NOT NULL
- 전화번호 (phone_number) — VARCHAR(20) — NOT NULL
- 생일 (birth) — DATE — NOT NULL
- (created_at) — DATETIME(6) — NOT NULL
- Field (updated_at) — DATETIME(6)
- Field (deleted_at) — DATETIME(6)
point (포인트)
- 포인트아이디 (id) — BIGINT — Primary key — NOT NULL
- 포인트정책아이디 (id2) — BIGINT — Foreign key → point_policy.포인트정책아이디 — NOT NULL
- 멤버아이디 (id3) — BIGINT — Foreign key → member.멤버아이디 — NOT NULL
- (created_at) — DATETIME — NOT NULL
- Field (updated_at) — DATETIME
- Field (deleted_at) — DATETIME
point_policy (포인트정책)
- 포인트정책아이디 (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(255) — NOT NULL
- 타입 (type) — VARCHAR(45) — NOT NULL
- 적립량 (amount) — INT — NOT NULL
- 만료일 (expired_at) — VARCHAR(255) — NOT NULL
reservation (예약)
- 예약아이디 (id) — BIGINT — Primary key — NOT NULL
- 방아이디 (id2) — BIGINT — Foreign key → rooms.방아이디 — NOT NULL
- 멤버아이디 (id3) — BIGINT — Foreign key → member.멤버아이디 — NOT NULL
- 호텔아이디 (id22) — BIGINT — Foreign key → rooms.호텔아이디 — NOT NULL
- 체크인 (check_in) — DATE — NOT NULL
- 체크아웃 (check_out) — DATE — NOT NULL
- 인원수 (personnel) — INT — NOT NULL
- 예약번호 (number) — INT — NOT NULL
- 예약상태 (status) — VARCHAR(45) — NOT NULL
- Field (created_at) — DATETIME(6) — NOT NULL
- Field (updated_at) — DATETIME(6)
- Field (deleted_at) — DAATETIME(6)
review (리뷰)
- 리뷰아이디 (id) — BIGINT — Primary key — NOT NULL
- 방아이디 (id2) — BIGINT — Foreign key → rooms.방아이디 — NOT NULL
- 호텔아이디 (id22) — BIGINT — Foreign key → rooms.호텔아이디 — NOT NULL
- 이름 (name) — VARCHAR(255) — NOT NULL
- 내용 (text) — TEXT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (updated_at)
review_image (리뷰이미지)
- 리뷰이미지아이디 (id) — BIGINT — Primary key — NOT NULL
- 리뷰아이디 (id2) — BIGINT — Foreign key → review.리뷰아이디 — NOT NULL
- 방아이디 (id22) — BIGINT — Foreign key → review.방아이디 — NOT NULL
- 호텔아이디 (id222) — BIGINT — Foreign key → review.호텔아이디 — NOT NULL
- 이미지주소 (url) — VARCHAR(400) — NOT NULL
room_image (방이미지)
- 방사진아이디 (id) — BIGINT — Primary key — NOT NULL
- 방아이디 (id2) — BIGINT — Foreign key → rooms.방아이디 — NOT NULL
- 호텔아이디 (id22) — BIGINT — Foreign key → rooms.호텔아이디 — NOT NULL
- 이미지주소 (url) — VARCHAR(255) — NOT NULL
rooms (방)
- 방아이디 (id) — BIGINT — Primary key — NOT NULL
- 호텔아이디 (id2) — BIGINT — Foreign key → hotels.호텔아이디 — NOT NULL
- 이름 (name) — VARCHAR(100) — NOT NULL
- 수용인원 (capacity) — TINYINT — NOT NULL
- 층 (floor) — TINYINT — NOT NULL
- 욕조여부 (bathtub_flag) — TINYINT(1) — NOT NULL
- 뷰타입 (view_type) — TINYINT
- Field (created_at) — DATETIME — NOT NULL
- 상태 (status) — TINYINT(1) — NOT NULL