mozzi
Tables (9)
comment
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- title — varchar(100)
- content — varchar(300)
- point — int
- user_social_id — varchar(100) — Foreign key → user.id — NOT NULL — 작성자를 위한 아이디
followers
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- follower_social_id — varchar(100) — Foreign key → user.id — NOT NULL
- following_user_id — varchar(100) — Foreign key → user.id — NOT NULL
hidden
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- title — varchar(100)
- content — varchar(300)
- point — int
- user_social_id — varchar(100) — Foreign key → user.id — NOT NULL — 작성자아이디
problem_solving
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- score — int
- time — date
- user_social_id — varchar(100) — Foreign key → user.id — NOT NULL
- question_id — varchar(100) — Foreign key → question.id — NOT NULL
question
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- question_content_1 — varchar(300)
- question_content_2 — varchar(300)
- question_content_3 — varchar(300)
- question_content_4 — varchar(300)
- question_content_5 — varchar(300)
- question_content_6 — varchar(300)
- question_content_7 — varchar(300)
- image_url — varchar(100)
- question_list_id — varchar(100) — Foreign key → question_list.id — NOT NULL
question_list
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- score — int
- time_limit — date
- user_social_id — varchar(100) — Foreign key → user.id — NOT NULL
reactions
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- user_social_id — varchar(100) — Foreign key → user.id — NOT NULL
- comment_id — varchar(100) — NOT NULL
report
- id — varchar(100) — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- type — COMMENT — 질문 신고인지, 댓글 신고인지 나타내는 타입
- user_social_id — varchar(100) — Foreign key → user.id — NOT NULL
- comment_id — varchar(100) — Foreign key → comment.id — NOT NULL
user
- id — varchar(100) — Primary key — NOT NULL
- email — varchar(30)
- nickname — varchar(30)
- cellphone — varchar(30)
- create_date — time
- modify_date — date