community

Tables (4)

Article (article)

  • id (PK) — INT — Primary key — NOT NULL
  • board_id (PK2) — INT — Foreign key → Board.id — NOT NULL
  • title (Title) — VARCHAR(255)
  • content (Content) — VARCHAR(255)

Board (board)

  • id (PK) — INT — Primary key — NOT NULL
  • title (Title) — VARCHAR(255)
  • description (Description) — VARCHAR(255)
  • createTime (CreatTime) — TIMESTAMP
  • type (Type) — VARCHAR(10)

Comment (comment)

  • id (PK) — INT — Primary key — NOT NULL
  • aritcle_id (FK) — INT — Foreign key → Article.id — NOT NULL
  • board_id (FK2) — INT — Foreign key → Article.board_id — NOT NULL
  • content (Content) — VARCHAR(255)

Reply (reply)

  • id (PK) — INT — Primary key — NOT NULL
  • aritcle_id (FK) — INT — Foreign key → Comment.aritcle_id — NOT NULL
  • board_id (FK2) — INT — Foreign key → Comment.board_id — NOT NULL
  • comment_id (FK3) — INT — Foreign key → Comment.id — NOT NULL
  • content (Content) — VARCHAR(255)