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)