Yeogidam

Tables (10)

media

  • id — BIGINT — Primary key — NOT NULL
  • media_shortcode — VARCHAR(64) — NOT NULL
  • caption — TEXT
  • thumbnail_url — VARCHAR(2048)
  • author — VARCHAR(100)
  • extraction_status — VARCHAR(20) — NOT NULL
  • failure_reason — VARCHAR(40)
  • extraction_version — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL

media_places

  • id — BIGINT — Primary key — NOT NULL
  • media_id — BIGINT — Foreign key → media.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL

members

  • id — BIGINT — Primary key — NOT NULL
  • oauth_provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARBINARY(255) — NOT NULL
  • nickname — VARCHAR(255)
  • email — VARCHAR(320)
  • image_url — VARCHAR(512)
  • created_at — TIMESTAMP — NOT NULL

place_candidates

  • id — BIGINT — Primary key — NOT NULL
  • shared_media_id — BIGINT — Foreign key → shared_media.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • decision_status — VARCHAR(20) — NOT NULL
  • decided_at — TIMESTAMP

places

  • id — BIGINT — Primary key — NOT NULL
  • kakao_place_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100)
  • land_lot_address — VARCHAR(255) — NOT NULL
  • road_address — VARCHAR(255)
  • latitude — DECIMAL(13, 10) — NOT NULL
  • longitude — DECIMAL(13, 10) — NOT NULL
  • kakao_place_url — VARCHAR(512)
  • telephone — VARCHAR(30)
  • thumbnail_url — VARCHAR(2048)
  • thumbnail_source — VARCHAR(30)
  • thumbnail_attribution — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

refresh_sessions

  • id — BIGINT — Primary key — NOT NULL
  • session_id — CHAR(36) — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • token_hash — CHAR(64) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked — BOOLEAN — NOT NULL

saved_places

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • last_saved_at — TIMESTAMP — NOT NULL

shared_media

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • media_id — BIGINT — Foreign key → media.id — NOT NULL
  • shared_url — VARCHAR(512) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

shared_media_reports

  • id — BIGINT — Primary key — NOT NULL
  • shared_media_id — BIGINT — Foreign key → shared_media.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

shared_media_saved_places

  • id — BIGINT — Primary key — NOT NULL
  • saved_place_id — BIGINT — Foreign key → saved_places.id — NOT NULL
  • shared_media_id — BIGINT — Foreign key → shared_media.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL