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