핀업

테이블 (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)