newREALs

Tables (8)

Accounts

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — String
  • Field2 (profile)
  • Field3 (point) — int
  • Field4 (attendanceList) — boolean[]

Category

  • Key (id) — Primary key — NOT NULL
  • Field (name) — String

Keyword

  • Key (id) — int — Primary key — NOT NULL
  • Key (subCategoryID) — Category — Foreign key → SubCategory.Key — NOT NULL
  • Field2 (name) — String

Quiz

  • Field2 (quiz)
  • Field3 (answer)
  • Field4 (comment)
  • Key (basenewsID) — int — Foreign key → baseNews.Key — NOT NULL

SubCategory

  • Key (id) — Primary key — NOT NULL
  • Key (category) — Category — Foreign key → Category.Key — NOT NULL
  • Field (name) — String

ThoughtComment

  • Key (id) — int — Primary key — NOT NULL
  • Key (basenewsID) — int — Foreign key → baseNews.Key — NOT NULL
  • Field2 (topic)
  • Field3 (AIComment)
  • Field4 (pros)
  • Field5 (cons)
  • Field6 (neutral)

UserKeyword (Untitled)

  • Key (userID) — int — Foreign key → Accounts.Key — NOT NULL
  • Key (keywordID) — int — Foreign key → Keyword.Key — NOT NULL
  • Key (subCategoryID) — Category — Foreign key → Keyword.Key — NOT NULL

baseNews (BaseNews)

  • Key (id) — int — Primary key — NOT NULL
  • Field4 (uploadDate)
  • Field (title)
  • Field2 (summary)
  • Field3 (description)
  • Field4 (newsUrl)
  • Field5 (term) — List<HashMap<String,String>>
  • Field (scrap) — boolean
  • Field (isDailyNews) — int
  • Key (categoryID) — Foreign key → Category.Key — NOT NULL
  • Key (subCategoryID) — Foreign key → SubCategory.Key — NOT NULL
  • Key (keywordID) — int — Foreign key → Keyword.Key — NOT NULL
  • Field (likeArray) — int[]