pre-project
Tables (8)
answer
- id (answer_id) — Primary key — NOT NULL
- 작성자 ID (user_id) — int — Foreign key
- 질문 ID (question_id) — int — Foreign key
- 내용 (body) — varchar — NOT NULL
- 작성일 (created_at) — date — NOT NULL
comment
- id (comment_id) — Primary key — NOT NULL
- 질문 ID (question_id) — int — Foreign key — NOT NULL
- 답변 ID (answer_id) — int — Foreign key
- 작성자 ID (user_id) — int — Foreign key — NOT NULL
- 내용 (body) — varchar(255) — NOT NULL
like
- id (like_id) — int — Primary key — NOT NULL
- 질문 ID (question_id) — int — NOT NULL
- 댓글 ID (comment_id) — int
- 추천수 (count) — int — NOT NULL
like_user
- id (like_user_id) — int — Primary key — NOT NULL
- 추천 ID (like_id) — int — Foreign key
- 유저 ID (user_id) — int — Foreign key
question
- id — int — Primary key — NOT NULL
- 제목 (title) — varchar(100) — NOT NULL
- 내용 (body) — varchar(255) — NOT NULL
- 작성일 (created_at) — date — NOT NULL
- 작성자 ID (user_id) — int — Foreign key — NOT NULL
question_tag
- id (question_tag_id) — int — Primary key — NOT NULL
- 질문 ID (question_id) — int — Foreign key
- 태그 ID (tag_id) — int — Foreign key
tag
- id (tag_id) — int — Primary key — NOT NULL
- 이름 (name) — varchar(20)
- 설명 (description) — varchar(255)
user
- id (user_id) — int — Primary key — NOT NULL
- 이름 (name) — varchar(50) — NOT NULL
- 패스워드 (password) — varchar(20) — NOT NULL
- 이메일 (email) — varchar(20) — NOT NULL
- 가입일 (created_at) — date — NOT NULL
- 자기소개 (description) — varchar