WhereAreYou_ver0.0.1

Tables (7)

Bookmark (북마크)

  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
  • post_id (PK) — BIGINT — Foreign key → Post.post_id — NOT NULL

Comment (제보글)

  • comment_id — PK — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
  • post_id (PK) — BIGINT — Foreign key → Post.post_id — NOT NULL
  • location_id (실종자위치) — LONG — Foreign key → Location.location_id — NOT NULL
  • clothes (Field)
  • details (추가 설명) — TEXT
  • accuracy (일치율)
  • createdAt (작성 시각) — NOT NULL
  • updatedAt (수정 시각)
  • discoveredAt (발견시각) — DATETIME

Location (장소)

  • location_id (PK) — LONG — Primary key — NOT NULL
  • latitude (위도) — NOT NULL
  • longitude (경도) — NOT NULL
  • address (주소) — String — NOT NULL

Login (리프레시토큰관리)

  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
  • refresh_token (해시된 refreshToken) — NOT NULL
  • CreatedAt (생성시간) — DATETIME — NOT NULL
  • UpdatedAt (수정시간) — DATETIME

Member (사용자)

  • member_id — BIGINT — Primary key — NOT NULL
  • platform (플랫폼) — NOT NULL
  • email (Field) — NOT NULL
  • name (Field2) — NOT NULL
  • profile (Field3)
  • CreatedAt (생성시간) — DATETIME — NOT NULL
  • UpdatedAt (수정시간) — DATETIME

Photo (사진)

  • photo_id — BIG INT — Primary key — NOT NULL
  • uuid (사진 이름)
  • url (사진 url)
  • CreatedAt (생성 시각) — NOT NULL
  • comment_id — FK — Foreign key → Comment.comment_id
  • post_id — FK — Foreign key → Post.post_id

Post (신고글)

  • post_id (PK) — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
  • location_id (마지막위치) — LONG — Foreign key → Location.location_id — NOT NULL
  • isDone (종료여부) — NOT NULL
  • missingName (실종자이름) — NOT NULL
  • missingGender (실종자 성별) — NOT NULL
  • missingBirthDate (실종자생년월일) — DATE — NOT NULL
  • missingHeight (실종자키)
  • missingWeight (실종자 몸무게)
  • clothes (옷차림)
  • detail (추가 설명) — TEXT
  • disappearedAt (실종시각) — DATETIME
  • createdAt (생성시간) — DATETIME — NOT NULL
  • updatedAt (수정시간) — DATETIME