404wefound_2
Tables (6)
Answer
- answerId — BIGINT
- questionId — BIGINT — NOT NULL
- userId — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
AnswerComment
- answerCommentId — BIGINT
- answerId — BIGINT — NOT NULL
- userId — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Comment
- commentId — BIGINT
- questionId — BIGINT — NOT NULL
- userId — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
Point
- pointId — BIGINT
- userId — BIGINT — NOT NULL
- point — BIGINT
- reason — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
Question
- questionId — BIGINT
- userId — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
User
- userId — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- grade — VARCHAR(20)
- point — BIGINT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL