핀업
테이블 (9)
alarm
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- is_read — TINYINT — NOT NULL
- message — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
article
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id
- image_url — VARCHAR(255)
- title — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
book_mark
- id — BIGINT — 기본 키 — NOT NULL
- place_id — BIGINT — 외래 키 → place.id — NOT NULL
- member_id — BIGINT — 외래 키 → member.id
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
friend_request
- id — BIGINT — 기본 키 — NOT NULL
- sender_id — BIGINT — 외래 키 → member.id — NOT NULL
- receiver_id — BIGINT — 외래 키 → member.id — NOT NULL
- friend_request_status — ENUM('ACCEPTED','PENDING','REJECTED')
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
friend_ship
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- friend_id — BIGINT — 외래 키 → member.id — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
member
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(12)
- role — ENUM('ROLE_ADMIN','ROLE_USER')
- bio — VARCHAR(150)
- login_type — ENUM('GOOGLE','KAKAO','NAVER')
- profile_image_url — VARCHAR(255)
- status — VARCHAR(1)
- terms_of_marketing — VARCHAR(1)
- last_nickname_update_date — DATETIME(6)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
place
- id — BIGINT — 기본 키 — NOT NULL
- kakao_place_id (카카오맵에서 부여된 장소 ID) — VARCHAR(255)
- name (장소명) — VARCHAR(255)
- address (주소) — VARCHAR(255)
- road_address — VARCHAR(255)
- default_img_url (장소 기본 이미지) — VARCHAR(255)
- latitude (위도) — VARCHAR(255)
- longitude (경도) — VARCHAR(255)
- status (상태) — VARCHAR(255)
- place_category — ENUM('ACADEMY','ACCOMMODATION','ALL','ATTRACTION','BANK','BROKERAGE','CAFE','CULTURAL_FACILITY','ETC','GAS_STATION','HOSPITAL','KINDERGARTEN','MART','PARKING_LOT','PHARMACY','PUBLIC_OFFICE','RESTAURANT','SCHOOL','STORE','SUBWAY')
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
review
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- place_id — BIGINT — 외래 키 → place.id — NOT NULL
- content — VARCHAR(200) — NOT NULL
- star_rating — double — NOT NULL
- visited_date — VARCHAR(255)
- type — ENUM('PHOTO','TEXT')
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
review_image
- id — BIGINT — 기본 키 — NOT NULL
- review_id — BIGINT — 외래 키 → review.id — NOT NULL
- url (이미지 URL) — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)