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