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