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