teamPro

Tables (3)

Category (Untitled3)

  • category_id (Key) — NOT NULL — Primary key — NOT NULL
  • title (Field) — NOT NULL
  • status (Field4) — NOT NULL
  • created_at (Field2) — NOT NULL
  • updated_at (Field3) — NOT NULL

Comment (Untitled2)

  • comment_id (Key) — NOT NULL — Primary key — NOT NULL
  • content (VARCHAR(255)) — NOT NULL
  • created_at (Field) — NOT NULL
  • status (VARCHAR(50)) — NOT NULL
  • post_id — NOT NULL — Foreign key → Post.post_id — NOT NULL
  • parent_id (Key2) — Foreign key → Comment.comment_id — NOT NULL

Post (Untitled)

  • post_id — NOT NULL — Primary key — NOT NULL
  • title — NOT NULL
  • content — NOT NULL
  • viewd_cnt — NOT NULL
  • visibility (Field) — NOT NULL
  • status (Field2) — NOT NULL
  • created_at (Field3) — NOT NULL
  • updated_at (Field4) — NOT NULL
  • category_id (Key) — NOT NULL — Foreign key → Category.category_id — NOT NULL