KONEST_App_Backend_ERD

Tables (15)

address

  • id — SERIAL — Primary key
  • road_address — VARCHAR(200)
  • lot_address — VARCHAR(200)
  • lat — DOUBLE
  • lng — DOUBLE
  • sub_area_id — SERIAL — Foreign key → sub_area.id

app_user

  • id — SERIAL — Primary key
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50)
  • created_at — TIMESTAMP

area

  • id — SERIAL — Primary key
  • name_kr — VARCHAR(100) — NOT NULL
  • name_jp — VARCHAR(100)
  • name_cn — VARCHAR(100)

bus_line

  • id — SERIAL — Primary key
  • name — VARCHAR(100)
  • direction — VARCHAR(50)

bus_line_stop

  • id — SERIAL — Primary key
  • stop_order — INT
  • bus_line_id — SERIAL — Foreign key → bus_line.id
  • bus_stop_id — SERIAL — Foreign key → bus_stop.id

bus_stop

  • id — SERIAL — Primary key
  • name — VARCHAR(100)
  • lat — DOUBLE
  • lng — DOUBLE

poi

  • id — SERIAL — Primary key
  • name — VARCHAR(100)
  • address_id — INT
  • lat — DOUBLE
  • lng — DOUBLE
  • description — TEXT
  • category_id — INT

poi_tag_map

  • id — SERIAL — Primary key
  • poi_id — INT
  • tag_id — INT

sub_area

  • id — SERIAL — Primary key
  • name_kr — VARCHAR(100) — NOT NULL
  • name_jp — VARCHAR(100)
  • name_cn — VARCHAR(100)
  • area_id — SERIAL — Foreign key → area.id

subway_line

  • id — SERIAL — Primary key
  • name — VARCHAR(100)
  • color_code — VARCHAR(10)

subway_station

  • id — SERIAL — Primary key
  • name — VARCHAR(100)
  • lat — DOUBLE
  • lng — DOUBLE
  • subway_line_id — SERIAL — Foreign key → subway_line.id

tag

  • id — SERIAL — Primary key
  • name — VARCHAR(50)

user_favorite_poi

  • id — SERIAL — Primary key
  • poi_id — INT — NOT NULL
  • created_at — TIMESTAMP
  • app_user_id — INT — Foreign key → app_user.id
  • app_favorite_folder_id — INT — Foreign key

weather_icon

  • id — SERIAL — Primary key
  • icon_code — INT — NOT NULL
  • description_kr — VARCHAR(100)
  • description_jp — VARCHAR(100)
  • description_cn — VARCHAR(100)

weather_info

  • id — SERIAL — Primary key
  • area_code — VARCHAR(20)
  • temperature — FLOAT
  • icon_code — INT
  • description_kr — VARCHAR(50)
  • description_jp — VARCHAR(50)
  • description_cn — VARCHAR(50)
  • updated_at — TIMESTAMP
  • address_id — SERIAL — Foreign key → address.id
  • weather_icon_id — SERIAL — Foreign key → weather_icon.id