crudproject

Tables (7)

account

  • account_id — bigint — Primary key — NOT NULL
  • user_id — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp — NOT NULL
  • active — tinyint(1) — NOT NULL

article

  • article_id — bigint — Primary key — NOT NULL
  • account_id — bigint — Foreign key → account.account_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • last_modified_date — timestamp — NOT NULL
  • created_date — timestamp — NOT NULL
  • active — tinyint(1) — NOT NULL

comment

  • Key (comment_id) — bigint — Primary key — NOT NULL
  • content — clob — NOT NULL
  • account_id — bigint — Foreign key → account.account_id — NOT NULL
  • article_id — bigint — Foreign key → article.article_id — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp — NOT NULL
  • active — tinyint(1) — NOT NULL

image

  • Key (image_id) — bigint — Primary key — NOT NULL
  • article_id — bigint — Foreign key → article.article_id — NOT NULL
  • capacity — bigint — NOT NULL
  • filename — varchar(255) — NOT NULL
  • url — varchar(255) — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp — NOT NULL
  • active — tinyint(1) — NOT NULL

reply

  • Key (reply_id) — bitint — Primary key — NOT NULL
  • content — clob — NOT NULL
  • account_id — bigint — Foreign key → account.account_id — NOT NULL
  • Key (comment_id) — bigint — Foreign key → comment.Key — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp — NOT NULL
  • active — tinyint(1) — NOT NULL

view

  • Key (view_id) — bigint — Primary key — NOT NULL
  • article_id — bigint — Foreign key → article.article_id — NOT NULL
  • count — bigint — NOT NULL
  • created_date — timestamp — NOT NULL

views

  • Key (views_id) — bigint — Primary key — NOT NULL
  • Key (view_id) — bigint — Foreign key → view.Key — NOT NULL
  • created_date — timestamp
  • account_id — bigint — Foreign key → account.account_id — NOT NULL