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