YHIM
Tables (12)
Untitled (User)
- Key (user_id) — INT — Primary key — NOT NULL
- Field (username) — VARCHAR(45) — NOT NULL
- Field (nickname) — VARCHAR(45) — NOT NULL
- Field2 (birth) — VARCHAR(45)
- Field (email) — VARCHAR(45) — NOT NULL
- Field2 (password) — VARCHAR(200) — NOT NULL
- Field (status) — VARCHAR(10) — NOT NULL — Active, Delete, Black
- Field (privacy_agreement) — TINYINT — NOT NULL — 개인정보 수집 동의
- Field2 (marketing_agreement) — TINYINT — NOT NULL — 마케팅 이메일 수신 동의
- Field (host_permission) — TINYINT — NOT NULL — 호스트인지 여부 (default : x)
- Field (oauth_provider) — ENUM — NOT NULL
- Field3 (created_at) — TIMESTAMP
- Field4 (updated_at) — TIMESTAMP
Untitled (Room)
- Key (room_id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL — host_id
- Field2 (roomname) — NOT NULL
- Field3 (address1) — 시(이름미정)
- Field (address2) — 구/읍/면(이름미정)
- Field6 (address3) — 동/리(이름미정)
- Field4 (latitude) — NOT NULL
- Field5 (longitude) — NOT NULL
- Field (price)
- Field2 (max_guest) — 최대인원수(이름미정)
- Field4 (max_pet) — 최대반려동물수(이름미정)
- Field3 (description) — TEXT
- Field (check_in_time)
- Field2 (check_out_time)
- Field3 (status)
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (updated_at) — TIMESTAMP — NOT NULL
Untitled (RoomImage)
- Key (room_image_id) — INT — Primary key — NOT NULL
- Key (room_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field2 (room_image_url)
Untitled (Reservation)
- Key (reservation_id) — INT — Primary key — NOT NULL
- Key (room_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (total_price) — INT
- Field (total_guest) — INT
- Field (start_date) — DATE — NOT NULL
- Field2 (end_date) — DATE — NOT NULL
- Field (status) — VARCHAR(10) — NOT NULL — Active, Delete
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (updated_at) — TIMESTAMP — NOT NULL
Untitled (Review)
- Key (review_id) — INT — Primary key — NOT NULL
- Key (reservation_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (score)
- Field (content) — TEXT
- Field (status)
- Field (created_at)
- Field2 (updated_at)
Untitled (ReviewImage)
- Key (review_image_id) — INT — Primary key — NOT NULL
- Key (review_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (review_image_url) — NOT NULL
Untitled (RoomCategory)
- Key (room_category_id) — INT — Primary key — NOT NULL
- Key (category_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (room_id) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (RoomAvailable)
- Key (room_available_id) — INT — Primary key — NOT NULL
- Key (room_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (available_day) — DATE — NOT NULL
- Field (isAvailable) — boolean — NOT NULL — Active, Inactive
Untitled (Facility)
- Key (facility_id) — Primary key — NOT NULL
- Field (facility_name)
- Field (facility_image_url)
Untitled (RoomFacility)
- Key (room_facility_id) — INT — Primary key — NOT NULL
- Key (room_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (facility_id) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (Category)
- Key (category_id) — INT — Primary key — NOT NULL
- Field (category_name) — VARCHAR(45) — NOT NULL
- Field2 (category_image) — TEXT — NOT NULL
Untitled2 (Favorite)
- Key (like_id) — INT — Primary key — NOT NULL
- Key (room_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (is_checked) — boolean
- Field