EB_BBS_2week__servlet_model2
Tables (4)
Article (article)
- Artice id (article_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
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
- Post id (post_id) — INT(11) — Foreign key → Article.Artice id — NOT NULL
File (file)
- File uuid (file_uuid) — INT(11) — Primary key — NOT NULL
- Name on server (name_on_server) — VARCHAR(100)
- Name original (name_original) — VARCHAR(100) — NOT NULL
- File Path (file_path) — VARCHAR(200) — NOT NULL
- Post id (post_id) — INT(11) — NOT NULL