dockthru

Tables (9)

challenge

  • challenge_pk (Key) — INT — Primary key — NOT NULL
  • user_pk (ID값) — INT — Foreign key → user.USER — NOT NULL
  • challenge_request_pk (ID값2) — INT — Foreign key → challenge_request.challenge_request_pk — NOT NULL
  • title (제목) — varchar
  • source_url (원문 URL) — varchar
  • field (분야) — varchar
  • doc_type (공식문서/블로그) — INT
  • deadline_at (마감일자) — datetime
  • max_participants (최대 참여인원) — INT
  • content (본문) — varchar
  • challenge_status (진행중/마감) — INT
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

challenge_deletion (챌린지 삭제)

  • challenge_deletions_pk (Key) — INT — Primary key — NOT NULL
  • challenge_pk (Key2) — INT — Foreign key → challenge.challenge_pk — NOT NULL
  • reason (text) — varchar
  • created_at (생성일자) — datetime

challenge_participant (챌린지 참여 신청)

  • challenge_participant_pk (Key) — INT — Primary key — NOT NULL
  • user_pk (ID값) — INT — Foreign key → user.USER — NOT NULL
  • challenge_pk (Key2) — INT — Foreign key → challenge.challenge_pk — NOT NULL
  • participant_status (참여 상태) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

challenge_request (챌린지 생성 신청)

  • challenge_request_pk (ID값) — INT — Primary key — NOT NULL
  • user_pk (ID값2) — INT — Foreign key → user.USER — NOT NULL
  • title (제목) — varchar
  • source_url (URL) — varchar
  • field (분야) — varchar
  • doc_type (0-1) — INT
  • deadline_at (마감일자) — datetime
  • max_participants (최대참여인원) — INT
  • content (본문) — varchar
  • request_status (신청중/거절/취소) — INT
  • admin_reason (어드민 거절 이유) — varchar
  • processed_at (어드민 처리 시각) — datetime
  • created_at (생성일자) — datetime
  • updtaed_at (수정일자) — datetime

feedback

  • feedback_pk (Key2) — INT — Primary key — NOT NULL
  • user_pk (ID값) — INT — Foreign key → user.USER — NOT NULL
  • work_pk (Key) — INT — Foreign key → work.Work_id — NOT NULL
  • content (내용) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

like

  • user_pk (ID값) — INT — Foreign key → user.USER — NOT NULL
  • work_pk (Key) — INT — Foreign key → work.Work_id — NOT NULL
  • created_at (생성일자) — datetime

notiffication (알림)

  • notiffication_pk (Key) — INT — Primary key — NOT NULL
  • user_pk (ID값) — INT — Foreign key → user.USER — NOT NULL
  • challenge_pk (Key2) — INT — Foreign key → challenge.challenge_pk — NOT NULL
  • work_pk (Key3) — INT — Foreign key → work.Work_id — NOT NULL
  • type (알림 타입) — INT
  • message (내용) — varchar
  • created_at (생성일자) — datetime
  • read_at (읽은시간) — datetime

user

  • USER (id) — Int — Primary key — NOT NULL
  • 이메일 (email) — Varchar
  • 비밀번호 (password) — Varchar
  • 닉네임 (nickname) — Varchar
  • 프로필 이미지 (profileImage) — varchar
  • 역할 (role) — INT
  • 등급 (grade) — INT
  • 생성일자 (createdAt) — DateTime
  • 수정일자 (updatedAt) — DateTime

work (작업물/임시저장)

  • Work_id (id) — Int — Primary key — NOT NULL
  • 챌린지 ID (challenge_id) — Int — Foreign key → challenge.challenge_pk — NOT NULL
  • 유저 ID (user_id) — Int — Foreign key → user.USER — NOT NULL
  • 제목 (title) — Text
  • 내용 (content) — Text
  • 원문 URL (orignal_url) — Varchar
  • 작업물 상태 (work_status) — INT — NOT NULL
  • 생성일자 (createdAt) — Datetime — NOT NULL
  • 수정일자 (updatedAt) — Datetime — NOT NULL
  • 제출일자 (submittedAt) — Datetime