Board

Tables (6)

account

  • account_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • PASSWORD — VARCHAR(255) — NOT NULL
  • user_id — VARCHAR(255) — NOT NULL
  • active (Field) — TINYINT(1) — NOT NULL
  • created_date (Field2) — DATETIME — NOT NULL
  • last_modified_date (Field3) — DATETIME — NOT NULL

article

  • article_id — BIGINT — Primary key — NOT NULL
  • account_id (account_id2) — BIGINT — Foreign key → account.account_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • views (Field) — BIGINT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • last_modified_date — DATETIME — NOT NULL

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • article_id (article_id2) — BIGINT — Foreign key → article.article_id — NOT NULL
  • content — BIGINT — NOT NULL
  • account_id (article_id) — BIGINT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • last_modified_date — DATETIME — NOT NULL

image (Untitled2)

  • image_id (Key) — BIGINT — Primary key — NOT NULL
  • article_id — BIGINT — Foreign key → article.article_id — NOT NULL
  • url (Field2) — VARCAHR(255) — NOT NULL

reply

  • reply_id — BIGINT — Primary key — NOT NULL
  • comment_id (comment_id2) — BIGINT — Foreign key → comment.comment_id — NOT NULL
  • content — LONGTEXT — NOT NULL
  • account_id (comment_id) — BIGINT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • last_modified_date — DATETIME — NOT NULL

view (Untitled)

  • view_id (Key) — BIGINT — Primary key — NOT NULL
  • article_id — BIGINT — Foreign key → article.article_id — NOT NULL
  • account_id (Field2) — BIGINT — NOT NULL
  • view_date (Field3) — DATETIME — NOT NULL