mozziERD
Tables (11)
attainment
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- point — int — 사용자_달성_포인트
- social_id — bigint — Foreign key → user.id — NOT NULL
- hidden_id — bigint — Foreign key → hidden.id — NOT NULL
comment
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- title — varchar(100)
- content — varchar(300)
- point — int
- modify_id — varchar(100)
- create_id — varchar(100)
followers
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- follower_social_id — bigint — Foreign key → user.id — NOT NULL
- following_user_id — bigint — Foreign key → user.id — NOT NULL
hidden
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- title — varchar(100)
- content — varchar(300)
- point — int
mileage
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- point — bigint
- social_id — bigint — Foreign key → user.id — NOT NULL
problem_solving
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- score — int
- time — date
- social_id — bigint — Foreign key → user.id — NOT NULL
- questionlist_id — bigint — Foreign key → question_list.id — NOT NULL
question
- id — bigint — 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 — bigint — Foreign key → question_list.id — NOT NULL
question_list
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- score — int
- time_limit — date
- social_id — bigint — Foreign key → user.id — NOT NULL
- modify_id — varchar(100)
- create_id — varchar(100)
reaction
- id — bigint — Primary key — NOT NULL
- comment_id — bigint — Foreign key → comment.id — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- social_id — bigint — Foreign key → user.id — NOT NULL
report
- id — bigint — Primary key — NOT NULL
- create_date — time
- modify_date — date
- delete_yn — varchar(2)
- type — varchar(50) — 질문 신고인지, 댓글 신고인지 나타내는 타입
- social_id — bigint — Foreign key → user.id — NOT NULL
- comment_id — bigint — Foreign key → comment.id — NOT NULL
- modify_id — varchar(100)
- create_id — varchar(100)
user
- id — bigint — Primary key — NOT NULL
- email — varchar(30)
- nickname — varchar(30)
- cellphone — varchar(30)
- create_date — time
- modify_date — date