OSSW
Tables (4)
Analysis (analysis_table)
- f_id — INT — Primary key — NOT NULL
- fname — VARCHAR(256)
- extname — VARCHAR(10)
- fsize — BIGINT
- f_width — SMALLINT
- f_height — SMALLINT
- f_data — LONGBLOB
Article (article_table)
- article_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(20) — Foreign key → User.user_id — NOT NULL
- date — DATE
- title — VARCHAR(256)
- summary — TEXT
- cloud — INT — Foreign key → Cloud.f_id — NOT NULL
- analysis — INT — Foreign key → Analysis.f_id — NOT NULL
- leanings — VARCHAR(50)
- company — VARCHAR(100)
- color — CHAR(6)
- isscrape — BOOLEAN
Cloud (cloud_table)
- f_id — INT — Primary key — NOT NULL
- fname — VARCHAR(256)
- extname — VARCHAR(10)
- fsize — BIGINT
- f_width — SMALLINT
- f_height — SMALLINT
- f_data — LONGBLOB
User (user_table)
- user_id — VARCHAR(20) — Primary key — NOT NULL
- gender — BOOL
- age — INT