책먹사 2
테이블 (7)
answers
- answer_id — INT
- quest_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — VARCHAR(255) — NOT NULL
- writingtime — DATETIME
- is_accepted — ENUM('Y','N')
category
- category_id — INT
- category — VARCHAR(255)
like
- like_id — BIGINT
- post_id — BIGINT
- question_id — INT
- user_id — INT — NOT NULL
post
- post_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255)
- writingtime — DATETIME
- booktitle — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- genre — VARCHAR(255)
- rating — DOUBLE
- view_count — INT
- reply_count — INT
questions
- quest_id — INT
- user_id — INT — NOT NULL
- category_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- status — ENUM('unsolved', 'solved')
- view_count — INT
- writingtime — DATETIME
- like_count — INT — NOT NULL
- answer_count — INT
reply
- reply_id — BIGINT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — VARCHAR(255) — NOT NULL
- writingtime — DATETIME
- comment — VARCHAR(255) — ARCHAR(255
- created_at — DATETIME(6)
- email — VARCHAR(255)
- password — VARCHAR(255)
users
- user_id — INT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- comment — VARCHAR(255) — ARCHAR(255