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