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