BKMS2022S_finalPrj

Tables (7)

baws01 (User)

  • user_id (Key) — int — Primary key — NOT NULL
  • screen_name (Field3) — varchar
  • account_lang (Field2) — varchar
  • account_created_at (Field) — date
  • verified (Field4) — bool

baws02 (UserDate)

  • created_at (Key22) — date — Primary key — NOT NULL
  • user_id (Key21) — int — Foreign key → baws01.user_id — NOT NULL
  • followers_count (Field) — int
  • friends_count (Field4) — int

baws03 (Tweet)

  • status_id (Key) — int — Primary key — NOT NULL
  • user_id (Key21) — int — Foreign key → baws02.user_id — NOT NULL
  • created_at (Key22) — date — Foreign key → baws02.created_at — NOT NULL
  • text — varchar
  • source — varchar
  • reply_to_status_id (reply1) — int
  • reply_to_user_id (relpy2) — int
  • reply_to_screen_name (reply3) — varchar
  • is_quote (quote) — bool
  • is_retweet (retweet) — bool
  • retweet_count (reCnt) — int
  • favourites_count (favCnt) — int
  • lang — varchar
  • place_id (Key2) — int — Foreign key → baws08.place_id — NOT NULL
  • retweet_to_screen_name (Field) — varchar
  • sentiment (Field2) — varchar

baws04 (Mention)

  • status_id (Key) — Foreign key → baws03.status_id — NOT NULL
  • mention (Field)

baws05 (Link)

  • status_id (Key) — Foreign key → baws03.status_id — NOT NULL
  • link (Field)

baws06 (Hashtag)

  • status_id (Key) — Foreign key → baws03.status_id — NOT NULL
  • hashtag (Field)

baws08 (Place)

  • place_id (Key) — int8 — Primary key — NOT NULL
  • country_code (Field) — varchar
  • place_full_name (Field2) — varchar
  • place_type (Field3) — varchar