shuiiingDB

Tables (17)

filter

  • filter — text — Primary key — NOT NULL

hashtag

  • hashtag — text — Primary key — NOT NULL
  • short_code — text — Primary key — NOT NULL

hashtag_place

  • city — text — Primary key — NOT NULL
  • hashtag — text — Primary key — NOT NULL
  • place_id — bigint — NOT NULL

hashtag_place_test

  • city — text — Primary key — NOT NULL
  • hashtag — text — Primary key — NOT NULL
  • place_id — bigint — NOT NULL

hashtag_test

  • hashtag — text — Primary key — NOT NULL
  • short_code — text — Primary key — NOT NULL
  • short_code (short_code2) — text — Foreign key → instagram.short_code — NOT NULL

instagram

  • short_code — text — Primary key — NOT NULL
  • date — date — NOT NULL
  • owner_id — bigint — NOT NULL
  • type — text — NOT NULL
  • caption — text — NOT NULL
  • hashtags — text — NOT NULL
  • likes — bigint — NOT NULL
  • comments — bigint — NOT NULL
  • video_views — bigint
  • first_comment — text — ext COLLATE pg_catalog."default

place

  • id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL
  • branch — text
  • category — text
  • phone — text
  • address — text
  • street — text
  • x — double
  • y — double
  • depth1 — text
  • depth2 — text
  • depth3 — text
  • display_name — text

place_test

  • id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL
  • branch — text
  • category — text
  • phone — text
  • address — text
  • street — text
  • x — double
  • y — double
  • depth1 — text
  • depth2 — text
  • depth3 — text
  • display_name — text

stopplace

  • place_id — bigint — Primary key — NOT NULL
  • reason — text

stopword

  • stopword — text — NOT NULL

stopword_busan

  • stopword — text — NOT NULL

stopword_changwon

  • stopword — text — NOT NULL

stopword_changwon_test

  • stopword — text — NOT NULL

stopword_daegu

  • stopword — text — NOT NULL

stopword_gyeongju

  • stopword — text — NOT NULL

stopword_jeju

  • stopword — text — NOT NULL

stopword_seoul

  • stopword — text — NOT NULL