miniProject-MBTI
Tables (4)
board
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- imageName — VARCHAR(255)
- description — VARCHAR(255)
comment
- id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(255)
- createTime — DATETIME — NOT NULL
- modifiedDate — DATETIME — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
post
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(100)
- content — BLOB
- post_syntax — BIGINT — NOT NULL
- createTime — DATETIME — NOT NULL
- modifiedDate — DATETIME — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- board_id — BIGINT — Foreign key → board.id — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- createTime — DATETIME — NOT NULL
- modifiedDate — DATETIME — NOT NULL