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