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)