MissingYou - 2024-04-15 08:25:29
예선 ERD
테이블 (7)
BOOKMARK
- id — BIGINT — 기본 키 — NOT NULL
- id (member_id) — BIGINT — 외래 키 — NOT NULL
- id (post_id) — BIGINT — 외래 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
COMMENT
- id — BIGINT — 기본 키 — NOT NULL
- id (post_id) — BIGINT — 외래 키 — NOT NULL
- id (member_id) — BIGINT — 외래 키 — NOT NULL
- id (location_id) — BIGINT — 외래 키 — NOT NULL
- details — TEXT
- clothes — VARCHAR(255)
- discovered_at — DATETIME(6)
- accuracy — DOUBLE
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
IMAGE
- id — BIGINT — 기본 키 — NOT NULL
- id (post_id) — BIGINT — 외래 키
- id (comment_id) — BIGINT — 외래 키
- url — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_represent (order) — INT — NOT NULL
- is_gen_image — BIT — NOT NULL
LOCATION
- id — BIGINT — 기본 키 — NOT NULL
- address — VARCHAR(255)
- longitude — DOUBLE
- latitude — DOUBLE
MEMBER
- id — BIGINT — 기본 키 — NOT NULL
- role — ENUM — NOT NULL
- platform — ENUM — NOT NULL
- profile — VARCHAR(255)
- name — VARCHAR(20) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- updated_at — DATETIME(6)
- created_at — DATETIME(6)
REFRESH_TOKEN
- id — BIGINT — 기본 키 — NOT NULL
- id (member_id) — BIGINT — 외래 키 — NOT NULL
- hashed_token — VARCHAR(255) — NOT NULL
- updated_at — DATETIME(6)
- created_at — DATETIME(6)
실종신고 글 (POST)
- id — BIGINT — 기본 키 — NOT NULL
- id (member_id) — BIGINT — 외래 키 — NOT NULL
- id (location_id) — BIGINT — 외래 키 — NOT NULL
- missing_name — VARCHAR(20) — NOT NULL
- details — TEXT
- clothes — VARCHAR(40) — NOT NULL
- disappeared_at — DATETIME(6) — NOT NULL
- missing_weight — INT
- missing_height — INT
- missing_gender — TINYINT — NOT NULL
- missing_age — INT — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)