ERD

ERD

[User] (사용자)
- id (PK)
- name
- nickname: unique
- email
- login_id: unique
- password
- phone
- role(GUEST / HOST / ADMIN)
- created_at
- updated_at
- deleted_at

[RefreshToken] 
- id (PK)
- login_id
- refresh
- expiration

[Space]
- id (PK)
- host_id (FK → User)
- name
- space_category (CAFE / RESTAURANT / COOKING / LEATHER / COSTUME / ART)
- use_category (MEETING / COOKING / BARISTA / FLEA_MARKET / FILMING / ETC)
- max_capacity
- address
- detail_address
- price_per_hour
- thumbnail_url
- latitude
- longitude
- avg_rating
- created_at
- updated_at
- deleted_at

[Like] → 찜 기능
- id (PK)
- user_id (FK → User) 
- space_id (FK → Space) → user_id, space_id 조합 unique 제약
- created_at
- updated_at
- deleted_at

[Description]
- id (PK)
- space_id (FK)
- description
- price_guide
- facility_notice
- notice
- location_description
- refund_policy

[Tag]
- id (PK)
- space_id (FK)
- contents

[Available_times]
- id (PK)
- space_id (FK)
- date
- start_time
- end_time
- deleted_at

[SpaceImage]
- id (PK)
- space_id (FK)
- image_url
- deleted_at

[Reservation]
- id (PK)
- space_id (FK → Space)
- guest_id (FK → User)
- host_id (FK → User)
- status (PENDING / ACCEPTED / REJECTED / COMPLETED)
- usage_purpose (GRUOP_MEETING, COOKING_PRACTICE, BARISTA_TRAINING, FLEA_MARKET, FILMING, OTHER)
- request_message
- date
- start_time
- end_time
- price
- guest_count
- created_at
- updated_at
- deleted_at

[Review]
- id (PK)
- reservation_id (FK → Reservation)
- space_id (FK → Space)
- guest_id (FK → User)
- rating (1~5)
- content
- created_at
- updated_at
- deleted_at

[reviewImage]
- id (PK)
- review_id (FK)
- image_url

[ReviewComment]
- id (PK)
- review_id (FK → Review)
- user_id (FK → User)
- content
- created_at
- updated_at
- deleted_at

[Banner]
- id (PK)
- image_url
- link_url
- title
- is_active
- display_order
- start_date
- end_date
- created_at
- updated_at
- deleted_at