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)