NOA Database ERD
Tables (6)
congestion_data
- id — SERIAL — Primary key
- area_cd — VARCHAR(50) — Foreign key → seoul_spots.area_cd
- congestion_level — VARCHAR(20)
- updated_at — TIMESTAMP
likes
- id — SERIAL — Primary key
- social_id — VARCHAR(255) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- area_cd — VARCHAR(50) — Foreign key → seoul_spots.area_cd
- created_at — TIMESTAMP
seoul_spots
- area_cd — VARCHAR(50) — Primary key
- name — VARCHAR(255)
- category — VARCHAR(50)
spot_mapping
- id — SERIAL — Primary key
- area_cd — VARCHAR(50) — Foreign key → seoul_spots.area_cd
- content_id — VARCHAR(50) — Foreign key → tour_spots.content_id
- area_cd (area_cd2) — VARCHAR(50) — Foreign key → seoul_spots.area_cd
tour_spots
- content_id — VARCHAR(50) — Primary key
- name — VARCHAR(255)
- image_url — TEXT
- description — TEXT
- address — TEXT
- mapx — NUMERIC(10,7)
- mapy — NUMERIC(10,7)
users
- id — SERIAL — Primary key
- social_id — VARCHAR(255) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(100)
- created_at — TIMESTAMP