solvewithus
Tables (9)
comments (문제에 대한 comment들)
- ID — pk — Primary key — NOT NULL
- CONTENTS (내용) — NOT NULL
- Field
- CREATOR_ID (ID3) — fk — Foreign key → user.ID — NOT NULL
- PROBLEM_ID (ID2) — fk — Foreign key → problems_static.ID — NOT NULL
hashtag (문제 해시 태그)
- ID (해시태그아이디) — pk — Primary key — NOT NULL
- tag (해시태그내용) — NOT NULL
- PROBLEM_ID (문제 아이디) — fk — Foreign key → problems_static.ID — NOT NULL
problems_content_c (문제와 답_객관식)
- PROBLEM_ID (ID) — pk,fk — Foreign key → problems_static.ID — NOT NULL
- QUESTION (문제) — NOT NULL
- ANSWER (답) — NOT NULL
- P_TYPE (문제 종류) — NOT NULL
- CHOICES (선택지들) — NOT NULL
problems_content_e (문제와 답_주관식)
- PROBLEM_ID (ID) — pk,fk — Foreign key → problems_static.ID — NOT NULL
- QUESTION (문제) — NOT NULL
- ANSWER (답) — NOT NULL
- P_TYPE (문제 종류) — NOT NULL
problems_static (문제에 대한 통계)
- ID — pk — Primary key — NOT NULL
- LIKE_COUNT (좋아요 수) — default(0)
- STORE_COUNT (저장한 사람 수) — default(0)
- SOLVED_COUNT (푼 사람 수) — default(0)
- COMMENT_COUNT (댓글 수) — default(0)
- CREATOR_ID (ID2) — fk — Foreign key → user.ID — NOT NULL
- TITLE (문제 제목) — NOT NULL
user (사용자)
- ID — pk — Primary key — NOT NULL
- NAME — NOT NULL
- EMAIL — NOT NULL
- PHONE — NOT NULL
- NICKNAME — NULL — NOT NULL
- INTRO (간단한 자기소개) — NULL
- major (전공) — NULL
- profileImg (프로필이미지) — NULL
- Field
user_like_list (사용자가 좋아요(저장)한 문제)
- USER_ID (ID) — pk,fk — Foreign key → user.ID — NOT NULL
- PROBLEM_ID (ID2) — pk,fk — Foreign key → problems_static.ID — NOT NULL
user_select_interest (사용자 흥미 분야 테이블)
- ID — pk — Primary key — NOT NULL
- interest1 (흥미1) — NULL
- interest2 (흥미2) — NULL
- interest3 (흥미3) — NULL
- interest4 (흥미4) — NULL
- interest5 (흥미5) — NULL
- UserID (사용자아이디) — pk — Foreign key → user.ID — NOT NULL
user_solved_list (사용자가 푼 문제)
- USER_ID (ID) — pk,fk — Foreign key → user.ID — NOT NULL
- PROBLEM_ID (ID2) — pk,fk — Foreign key → problems_static.ID — NOT NULL
- GRADE (문제 점수) — default(0)
- P_COUNT (문제 푼 횟수) — default(0)