MinGyuErd
테이블 (19)
JailBreak
- challenge_id — bigint — 외래 키 → challenge.challenge_id — NOT NULL
- situation — VARCHAR(255)
- secret — code`
- scoring_manner — VARCHAR(255)
challenge
- challenge_id — bigint — 기본 키 — NOT NULL
- type — VARCHAR(255)
- level — VARCHAR(255)
- date — DATE
- title — VARCHAR(255)
- content — VARCHAR(255)
challenge_working
- user_id — bigint — 외래 키 → 유저.user_id — NOT NULL
- challenge_id — bigint — 외래 키 → challenge.challenge_id — NOT NULL
- date — DATE
- submission_date — DATE
code
- challenge_id — bigint — 외래 키 → challenge.challenge_id — NOT NULL
- time_limit — VARCHAR(255)
- memory_limit — VARCHAR(255)
- description — VARCHAR(255)
- input_example — VARCHAR(255)
- output_example — VARCHAR(255)
- clear_rate — VARCHAR(255)
code_challenge_creation
- creation_id — VARCHAR(255) — 외래 키 → 챌린지 생성물.creation_id — NOT NULL
code_testcase
- challenge_id — bigint — 외래 키 → code.challenge_id — NOT NULL
- input — VARCHAR(255)
- output — VARCHAR(255)
image
- challenge_id — bigint — 외래 키 → challenge.challenge_id — NOT NULL
- description — VARCHAR(255)
jailbreak_challenge_creation3
- creation_id — VARCHAR(255) — 외래 키 → 챌린지 생성물.creation_id — NOT NULL
- Field — VARCHAR(255)
movie
- challenge_id — bigint — 외래 키 → challenge.challenge_id — NOT NULL
- description — VARCHAR(255)
reference_image
- challenge_id — bigint — 외래 키 → image.challenge_id — NOT NULL
- reference_image — VARCHAR(255)
reference_video
- challenge_id — bigint — 외래 키 → movie.challenge_id — NOT NULL
- reference_image — VARCHAR(255)
게시판 (Untitled)
- post_id — bigint — 기본 키 — NOT NULL
- title — VARCHAR(255)
- board_category — VARCHAR(255)
- challenge_category — VARCHAR(255)
- writer — VARCHAR(255)
- content — VARCHAR(255)
- comment_number — VARCHAR(255)
- like_number — VARCHAR(255)
- creation_date — DATE
- user_id — bigint — 외래 키 → 유저.user_id — NOT NULL
댓글 (comment)
- post_id — bigint — 외래 키 → 게시판.post_id — NOT NULL
- comment — TEXT
- creation_date — DATE
- like_number — INT
- user_id — bigint — 외래 키 → 유저.user_id — NOT NULL
영상챌린지생성물 (video_challenge_creation)
- creation_id — VARCHAR(255) — 외래 키 → 챌린지 생성물.creation_id — NOT NULL
- Field — VARCHAR(255)
유저 (user)
- user_id — bigint — 기본 키 — NOT NULL
- nickname — VARCHAR
- password — VARCHAR
- introduction — VARCHAR
- email — VARCHAR
- signed_date — DATE
유저 관심분야 (user_interested)
- user_id — bigint — 외래 키 → 유저.user_id — NOT NULL
- back — boolean
- front — boolean
- design — boolean
- prompt_engineer — boolean
- pm — boolean
- ps — boolean
이미지챌린지생성물 (image_challenge_creation)
- creation_id — VARCHAR(255) — 외래 키 → 챌린지 생성물.creation_id — NOT NULL
- Field — VARCHAR(255)
챌린지 생성물 (challenge_creation)
- creation_id — VARCHAR(255) — 기본 키 — NOT NULL
- challenge_id — bigint — 외래 키 → challenge.challenge_id — NOT NULL
- user_id — bigint — 외래 키 → 유저.user_id — NOT NULL
- input_prompt — VARCHAR(255)
- output_prompt — VARCHAR(255)
- creation_date — VARCHAR(255)
챌린지 좋아요 (challenge_like)
- creation_id — VARCHAR(255) — 외래 키 → 챌린지 생성물.creation_id — NOT NULL
- like_user_id — VARCHAR(255)
- like_flag — VARCHAR(255)