jhjhhj

Tables (9)

instagram_media

  • id — BIGINT — Primary key — NOT NULL
  • media_shortcode — VARCHAR(64) — NOT NULL
  • caption — VARCHAR(2200)
  • thumbnail_url — VARCHAR(512)
  • author — VARCHAR(100)
  • extraction_status — VARCHAR(20) — NOT NULL
  • failure_reason — VARCHAR(40)
  • processing_version — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

media_place

  • id — BIGINT — Primary key — NOT NULL
  • media_id — BIGINT — Foreign key → instagram_media.id — NOT NULL
  • place_id — BIGINT — Foreign key → place.id — NOT NULL
  • position — INT — NOT NULL

media_share

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

media_share_report

  • id — BIGINT — Primary key — NOT NULL
  • share_id — BIGINT — Foreign key → media_share.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • oauth_provider — VARCHAR(20) — NOT NULL
  • oauth_provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

place

  • id — BIGINT — Primary key — NOT NULL
  • kakao_place_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100)
  • 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(512)
  • thumbnail_source — VARCHAR(30)
  • photo_attribution — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

saved_place

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • place_id — BIGINT — Foreign key → place.id — NOT NULL
  • first_saved_at — TIMESTAMP — NOT NULL
  • last_saved_at — TIMESTAMP — NOT NULL

saved_place_share

  • id — BIGINT — Primary key — NOT NULL
  • saved_place_id — BIGINT — Foreign key → saved_place.id — NOT NULL
  • share_id — BIGINT — Foreign key → media_share.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

share_place

  • id — BIGINT — Primary key — NOT NULL
  • share_id — BIGINT — Foreign key → media_share.id — NOT NULL
  • place_id — BIGINT — Foreign key → place.id — NOT NULL
  • position — INT — NOT NULL
  • decision_status — VARCHAR(20) — NOT NULL
  • decided_at — TIMESTAMP