wefound
Tables (9)
ANSWER
- ANSWER_ID — BIGINT — Primary key — NOT NULL
- CONTENT — TEXT — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- QUESTION_ID — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
COMMENT
- undefined_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- USER_ID — BIGINT — NOT NULL
- QUESTION_ID — BIGINT — Foreign key → QUESTION.QUESTION_ID
- ANSWER_ID — BIGINT — Foreign key → ANSWER.ANSWER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
FAVORITE
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- QUESTION_ID — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
FRIEND
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- FRIEND_USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
GRADE
- GRADE_ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.USER_ID — 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 — Foreign key → USER.USER_ID — NOT NULL
- QUESTION_ID — BIGINT — Foreign key → QUESTION.QUESTION_ID
- ANSWER_ID — BIGINT — Foreign key → ANSWER.ANSWER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
POINT
- POINT_ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- POINT — INT — NOT NULL
- REASON — VARCHAR(50) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
QUESTION
- QUESTION_ID — BIGINT — Primary key — NOT NULL
- TITLE — VARCHAR(255) — NOT NULL
- CONTENT — TEXT — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
USER
- USER_ID — BIGINT — Primary key — 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