adofai.gg v3

테이블 (13)

content (Untitled5)

  • content_id (Key) — BIGINT(20) — 기본 키 — NOT NULL

content_comment (Untitled6)

  • content_comment_id (Key) — BIGINT(20) — 기본 키 — NOT NULL
  • content_id (Key4) — BIGINT(20) — 외래 키 → content.content_id — NOT NULL
  • parent_content_comment_id (Key2) — BIGINT(20) — 외래 키 → content_comment.content_comment_id
  • content (Field) — TEXT — NOT NULL
  • created_by (Key3) — BIGINT(20) — 외래 키 → member.member_id — NOT NULL
  • created_at (Field2) — TIMESTAMP(6) — NOT NULL

file_metadata (Untitled9)

  • file_id (Key) — BIGINT(20) — 기본 키 — NOT NULL
  • name (Key2) — NOT NULL
  • size (Key4) — NOT NULL
  • extension (Key3) — NOT NULL
  • s3_object_key (Field) — NOT NULL

level (Untitled12)

  • level_id (Key) — BIGINT(20) — 기본 키 — NOT NULL
  • appending_title (Field3) — TEXT
  • creator_alias (Field9)
  • music_id (Key22) — BIGINT(20) — 외래 키 → music.music_id
  • difficulty (Field2) — NUMBER
  • pending (Field4) — BOOL — NOT NULL
  • quality (Field) — ENUM
  • file_id (Key2) — BIGINT(20) — 외래 키 → file_metadata.file_id — NOT NULL
  • thumbnail_id (Key3) — BIGINT(20) — 외래 키 → file_metadata.file_id
  • video_url (Field11)
  • download_url (Field5) — TEXT
  • workshop_url (Field10) — TEXT
  • min_bpm (Field6) — NUMBER
  • max_bpm (Field7) — NUMBER
  • length_ms (Field8) — NUMBER

level_creator (Untitled16)

  • level_id (Key2) — BIGINT(20) — 외래 키 → level.level_id — NOT NULL
  • member_id (Key) — BIGINT(20) — 외래 키 → member.member_id — NOT NULL

level_rating (Untitled17)

  • level_rating_id (Key) — BIGINT(20) — 기본 키 — NOT NULL
  • level_id (Key2) — BIGINT(20) — 외래 키 → level.level_id — NOT NULL
  • content_id (Key4) — BIGINT(20) — 외래 키 → content.content_id — NOT NULL
  • expect_difficulty (Field) — NUMBER
  • final_difficulty (Field2) — NUMBER
  • final_quality (Field9) — ENUM
  • reason (Field3) — VARCHAR(1000) — NOT NULL
  • completed (Field7) — BOOL — NOT NULL
  • requires_discussion (Field8) — BOOL
  • difficulty_range (Field6) — ENUM — NOT NULL
  • created_at (Field4) — DATETIME(6) — NOT NULL
  • created_by (Key3) — BIGINT(20) — 외래 키 → member.member_id — NOT NULL

level_rating_review (CopyOfUntitled19)

  • level_request_id (Key) — BIGINT(20) — 외래 키 → level_rating.level_rating_id — NOT NULL
  • member_id (Key3) — BIGINT(20) — 외래 키 → member.member_id — NOT NULL
  • difficulty (Field) — NUMBER — in java, double
  • quality (Field2) — ENUM

level_tag (Untitled8)

  • level_tag (Key) — ENUM — 기본 키 — NOT NULL
  • level_id (Key2) — BIGINT(20) — 외래 키 → level.level_id — NOT NULL

member (Untitled)

  • member_id (Key) — BIGINT(20) — 기본 키 — NOT NULL
  • email (Field) — VARCHAR(50)
  • name (Field2) — VARCHAR(100) — NOT NULL
  • display_name (Field3) — VARCHAR(100)
  • auth_user_id (Field4) — UUID

member_role (Untitled3)

  • role_id (Key2) — ENUM — 기본 키 — NOT NULL
  • member_id (Key) — BIGINT(20) — 외래 키 → member.member_id — NOT NULL

music (Untitled10)

  • music_id (Key2) — BIGINT(20) — 기본 키 — NOT NULL
  • alias (Field4) — TEXT
  • name (Field) — VARCHAR(100) — NOT NULL

music_artist (Untitled15)

  • music_id (Key22) — BIGINT(20) — 외래 키 → music.music_id — NOT NULL
  • member_id (Key) — BIGINT(20) — 외래 키 → member.member_id — NOT NULL

멤버 책정자 난도대 (member_level_rater_difficulty_range)

  • difficulty_range (Key2) — 기본 키 — NOT NULL
  • member_id (Key) — BIGINT(20) — 외래 키 → member.member_id — NOT NULL