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