TrueDev
Tables (5)
Article (article)
- article_id (Key) — INTEGER — Primary key — NOT NULL
- article_title (Field) — VARCHAR — NOT NULL
- article_text (Field2) — TEXT — NOT NULL
- article_created_at (Field3) — DATETIME — NOT NULL
- view_count (Field6) — INTEGER — NOT NULL
- user_id (Key2) — INTEGER — Foreign key → User.user_id — NOT NULL
- article_edited_at (Field8) — TIMESTAMP
- article_is_deleted (Field9) — BOOLEAN
- like_count (Field5) — INTEGER
- comment_count (Field7) — INTEGER
- isVerified (Field4) — BOOLEAN — NOT NULL
- aiMessage (Field10) — TEXT
- image (Field11) — VARCHAR
- category (Field12) — VARCHAR — NOT NULL
Comment (comment)
- comment_id (Key) — INTEGER — Primary key — NOT NULL
- comment_created_at (Field) — DATETIME — NOT NULL
- comment_text (Field2) — VARCHAR — NOT NULL
- article_id (Key2) — INTEGER — Foreign key → Article.article_id — NOT NULL
- user_id (Key3) — INTEGER — Foreign key → User.user_id — NOT NULL
- comment_edited_at (Field3) — TIMESTAMP
- comment_is_delete (Field4) — BOOLEAN
- isVerified (Field5) — BOOLEAN — NOT NULL
- aiMessage (Field6) — TEXT
Like (like)
- user_id (Key) — INTEGER — Foreign key → User.user_id — NOT NULL
- article_id (Key2) — INTEGER — Foreign key → Article.article_id — NOT NULL
- liked_at (Field) — TIMESTAMP — NOT NULL
- liked_is_deleted (Field2) — BOOLEAN
Source (source)
- source_id (Key) — INTEGER — Primary key — NOT NULL
- source (Field) — VARCHAR — NOT NULL
- article_id (FK) — INTEGER — Foreign key → Article.article_id — NOT NULL
- source_type (Field2) — VARCHAR — NOT NULL
- source_is_deleted (Field3) — BOOLEAN
- source_mime_type (Field5) — VARCHAR — NOT NULL
- is_cover (Field6) — BOOLEAN
User (user)
- user_id (Key) — INTEGER — Primary key — NOT NULL
- user_email (Field2) — VARCHAR(UNIQUE) — NOT NULL
- user_password_hash (Field3) — VARBINARY — NOT NULL
- user_name (Field) — VARCHAR — NOT NULL
- user_is_delete (Field4) — BOOLEAN
- user_created_at (Field5) — DATETIME — NOT NULL
- user_updated_at (Field6) — TIMESTAMP
- authority (Field7) — VARCHAR — NOT NULL
- profile_image (Field8) — VARCHAR