Board-TermProject
Tables (7)
board
- id — BIGINT — Primary key — NOT NULL
- createtime — DATETIME(6) — NOT NULL
- modifiedDate — DATETIME(6) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- likes — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
boardlike
- id — BIGINT — Primary key — NOT NULL
- createTime — DATETIME(6) — NOT NULL
- modifiedDate — DATETIME(6) — NOT NULL
- boardId — BIGINT — Foreign key → board.id — NOT NULL
- userId — BIGINT — Foreign key → user.id — NOT NULL
comment
- id — BIGINT — Primary key — NOT NULL
- createTime — DATETIME(6) — NOT NULL
- modifiedDate — DATETIME(6) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- likes — INT — NOT NULL
- boardId — BIGINT — Foreign key → board.id — NOT NULL
commentlike
- id — BIGINT — Primary key — NOT NULL
- createTime — DATETIME(6) — NOT NULL
- modifiedDate — DATETIME(6) — NOT NULL
- commentId — BIGINT — Foreign key → comment.id — NOT NULL
- userId — BIGINT — Foreign key → user.id — NOT NULL
recomment
- id — BIGINT — Primary key — NOT NULL
- createTime — DATETIME(6) — NOT NULL
- modifiedDate — DATETIME(6) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- likes — INT — NOT NULL
- commentId — BIGINT — Foreign key → comment.id — NOT NULL
recommentlike
- id — BIGINT — Primary key — NOT NULL
- recommentId — BIGINT — Foreign key → recomment.id — NOT NULL
- userId — BIGINT — Foreign key → user.id — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- createTime — DATETIME(6) — NOT NULL
- modifiedDate — DATETIME(6) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL