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