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