USER

Tables (8)

Copy Of user (CopyOf회원)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • UK (login_id) — VARCHAR(50) — Primary key
  • Field (password_hash) — VARCHAR(255)
  • Field (created_at) — DATETIME
  • Field (nickname) — VARCHAR(50)
  • Field (interests) — JSON
  • Field (updated_at) — TIMESTAMP

building (학교 건물)

  • Key (id) — TINYINT — Primary key — NOT NULL
  • Field (location) — GEOGRAPHY(POINT, 4326)

favorite_building (자주 방문하는 건물)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → user.PK — NOT NULL
  • FK (building_id) — TINYINT — Foreign key → building.Key — NOT NULL
  • Field (priority) — TINYINT

internal_review (학생 작성 리뷰)

  • PK (id) — BIGINT — Primary key
  • FK (user_id) — BIGINT — Foreign key → user.PK — NOT NULL
  • FK (room_id) — BIGINT — Foreign key → room.Key — NOT NULL
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP
  • Field (rating) — TINYINT
  • Field (text) — TEXT
  • Field (image_url_1) — VARCHAR(255)
  • Field (image_url_2) — VARCHAR(255)
  • Field (image_url_3) — VARCHAR(255)

room (방)

  • Key (id) — BIGINT — Primary key — NOT NULL

user (회원)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • UK (login_id) — VARCHAR(50) — Primary key
  • Field (password_hash) — VARCHAR(255)
  • Field (created_at) — DATETIME
  • Field (nickname) — VARCHAR(50)
  • Field (interests) — JSON
  • Field (updated_at) — TIMESTAMP

wishlist (즐겨찾기 목록)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → user.PK — NOT NULL
  • Field (name) — VARCHAR(100)
  • Field (is_public) — BOOLEAN

wishlist_room (중간 엔티티)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (room_id) — BIGINT — Foreign key → room.Key — NOT NULL
  • FK (wishlist_id) — BIGINT — Foreign key → wishlist.PK — NOT NULL
  • Field (added_at) — TIMESTAMP