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