erd 게시판
테이블 (10)
ANSWER
- ANSWER_ID — BIGINT — NOT NULL
- CONTENT — TEXT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- QUESTION_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
COMMENT
- undefined_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- QUESTION_ID — BIGINT
- ANSWER_ID — BIGINT
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
FAVORITE
- USER_ID — BIGINT — NOT NULL
- QUESTION_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
FRIEND
- USER_ID — BIGINT — NOT NULL
- FRIEND_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
GRADE
- GRADE_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- GRADE_NAME — VARCHAR(50) — NOT NULL
- MIN_POINT — INT — NOT NULL
- MAX_POINT — INT — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
LIKE
- USER_ID — BIGINT — NOT NULL
- QUESTION_ID — BIGINT
- ANSWER_ID — BIGINT
- CREATED_AT — TIMESTAMP — NOT NULL
POINT
- POINT_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- POINT — INT — NOT NULL
- REASON — VARCHAR(50) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
QUESTION
- QUESTION_ID — BIGINT — NOT NULL
- TITLE — VARCHAR(255) — NOT NULL
- CONTENT — TEXT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
USER
- USER_ID — BIGINT — NOT NULL
- EMAIL — VARCHAR(255) — NOT NULL
- PASSWORD — VARCHAR(255) — NOT NULL
- NICKNAME — VARCHAR(50) — NOT NULL
- ROLE — VARCHAR(20) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
Untitled
- Key — 기본 키 — NOT NULL
- Field