1234

Tables (4)

article

  • no — INTEGER — Primary key
  • title — VARCHAR(100) — NOT NULL
  • thumbnail — longtext
  • description — longtext — NOT NULL
  • content — longtext — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • modify_date — TIMESTAMP — NOT NULL
  • like_count — INTEGER
  • hate_count — INTEGER
  • read_count — INTEGER
  • category — VARCHAR(50) — Foreign key → category.category

category

  • category — VARCHAR(50) — Primary key

member

  • id — VARCHAR(100) — Primary key
  • pass — VARCHAR(100) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

reply

  • no — INTEGER — Primary key
  • bbs_no — integer — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • writer — VARCHAR(100) — Foreign key → member.id
  • no (no2) — INTEGER — Foreign key → article.no