B-6 sikbbang

Tables (6)

challengejoin

  • Key — Primary key — NOT NULL
  • 참가한 유저 (joined_user) — int — Foreign key → user.Key — NOT NULL
  • 참가한 챌린지 (joined_challenge) — int — Foreign key → challenges.Key — NOT NULL
  • 완료여부 (complete) — boolean

challenges

  • Key — Primary key — NOT NULL
  • 작성자 (challenge_author) — int — Foreign key → user.Key — NOT NULL
  • 제목 (challenge_title) — varchar
  • 챌린지명 (challenge_name) — varchar
  • 도전 장르 (challenge_genre) — varchar
  • 내용 (challenge_content) — text
  • 이미지 (challenge_image) — image
  • 생성시간 (challenge_created_at) — datetime
  • 수정시간 (challenge_updated_at) — datetime

my_comment

  • Key — Primary key — NOT NULL
  • 댓글이 달린 챌린지 (comment_challenge) — int — Foreign key → challenges.Key — NOT NULL
  • 작성자 (comment_writer) — int — Foreign key → user.Key — NOT NULL
  • 작성시간 (comment_created_at) — datetime
  • 내용 (comment_content) — text
  • 이미지 (comment_image) — image

mypage

  • Key — Primary key — NOT NULL
  • user_key — int — Foreign key → user.Key — NOT NULL
  • qna_key — int — Foreign key → qna.Key — NOT NULL
  • challenge_key — int — Foreign key → challenges.Key — NOT NULL
  • comment_key — int — Foreign key → my_comment.Key — NOT NULL

qna

  • Key — Primary key — NOT NULL
  • 작성자 (client) — int — Foreign key → user.Key — NOT NULL
  • 제목 (qna_title) — varchar
  • 내용 (qna_content) — text
  • 작성시간 (qna_created_at) — datetime
  • 수정시간 (qna_updated_at) — datetime

user

  • Key — Primary key — NOT NULL
  • 유저이름 (username) — varchar
  • 이메일 (email) — email
  • 비밀번호 (password) — varchar
  • 가입일 (date_joined) — datetime