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[]