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