EB_BBS_1week__only_jsp
Tables (4)
Category (category)
- Category id (category_id) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(30) — NOT NULL
Comment (comment)
- Comment id (comment_id) — INT(11) — Primary key — NOT NULL
- Content (content) — VARCHAR(255) — NOT NULL
- Created at (created_at) — DATETIME — NOT NULL
- Modified at (modified_at) — DATETIME
- Post id (post_id) — INT(11) — Foreign key → Post.Post id — NOT NULL
File (file)
- File uuid (file_uuid) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
- blob — BLOB — NOT NULL
- Post id (post_id) — INT(11) — Foreign key → Post.Post id — NOT NULL
Post (post)
- Post id (post_id) — INT(11) — Primary key — NOT NULL
- Title (title) — VARCHAR(100) — NOT NULL
- Writer (writer) — VARCHAR(4) — NOT NULL
- Password (password) — VARCHAR(15) — NOT NULL
- View (view) — INT(11) — NOT NULL
- Content (content) — TEXT — NOT NULL
- Created at (created_at) — DATETIME — NOT NULL
- Modified at (modified_at) — DATETIME
- Category id (category_id) — INT(11) — Foreign key → Category.Category id — NOT NULL