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)