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