adofaigg revised
Tables (25)
artist (Untitled2)
- artist_id (Key) — Long — Foreign key → member.member_id — NOT NULL
- verification_status (Field) — Enum — NOT NULL
- verification_comment (Field2) — String
- links (Field3) — String — NOT NULL
content (Untitled5)
- content_id (Key) — Long — Primary key — NOT NULL
- content_type (Field) — Enum — NOT NULL
creator (Untitled3)
- creator_id (Key) — Long — Foreign key → member.member_id — NOT NULL
- steam_link (Field) — String
- youtube_link (Field2) — String
developer (Untitled4)
- developer_id (Key) — Long — Foreign key → member.member_id — NOT NULL
- git_links (Field) — String
individual_map_review (CopyOfUntitled19)
- map_review_id (Key) — Long — Foreign key → map_review.map_review_id — NOT NULL
- staff_id (Key2) — Long — Foreign key → staff.staff_id — NOT NULL
- difficulty (Field) — Decimal(3, 1) — NOT NULL
- comment (Field2) — String
- date (Field3) — Date — NOT NULL
login (Untitled20)
- login_id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- date (Field) — Date — NOT NULL
- ip (Field2) — Int — NOT NULL
map (Untitled6)
- map_id (Key) — Long — Foreign key → content.content_id — NOT NULL
- music_id (Key2) — Long — Foreign key → music.music_id — NOT NULL
- description (Field) — Text
- tiles (Field2) — Int — NOT NULL
- video (Field3) — URL — NOT NULL
- file (Field4) — Blob — NOT NULL
- workshop (Field5) — URL
- upload_date (Field6) — Date — NOT NULL
- last_update (Field7) — Date — NOT NULL
- epilepsy_warning (Field8) — Bool — NOT NULL
- length_meta (Field9) — Enum("Short", "Full")
- difficulty_meta (Field10) — Enum("Nerfed", "Super Nerfed", "Ultra Nerfed", "ex", "ex+")
- part_meta (Field11) — Int
- remake_meta (Field12) — Enum("Remake", "Low Detail")
- verified (Field13) — Bool
map_creator (Untitled16)
- map_id (Key) — Long — Foreign key → map.map_id — NOT NULL
- creator_id (Key2) — Long — Foreign key → creator.creator_id — NOT NULL
map_review (Untitled17)
- map_review_id (Key) — Long — Primary key — NOT NULL
- map_id (Key2) — Long — Foreign key → map.map_id — NOT NULL
- requester_id (Key3) — Long — Foreign key → member.member_id — NOT NULL
- expected_difficulty (Field) — Decimal(3, 1)
- final_difficulty (Field2) — Decimal(3, 1)
- review_reason (Field3) — String
- date (Field4) — Date — NOT NULL
map_tag (Untitled18)
- map_id (Key) — Long — Foreign key → map.map_id — NOT NULL
- tag_id (Key2) — Long — Foreign key → tag.tag_id — NOT NULL
mapset (Untitled24)
- mapset_id (Key) — Long — Foreign key → content.content_id — NOT NULL
- parent_id (Key2) — Long — Foreign key → mapset.mapset_id
- Field
member (Untitled)
- member_id (Key) — Long — Primary key — NOT NULL
- id (Field) — String — NOT NULL
- username (Field2) — String
- password (Field3) — String — NOT NULL
- profile_img (Field4) — Image
- description (Field5) — String
- date (Field6) — Date — NOT NULL
- discord_name (Field7) — String
- discord_tag (Field8) — Decimal(4)
member_comment (Untitled7)
- comment_id (Key3) — Long — Primary key — NOT NULL
- content_id (Key) — Long — Foreign key → content.content_id — NOT NULL
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- parent_id (Key32) — Long — Foreign key → member_comment.comment_id
- comment (Field) — String — NOT NULL
- date (Field2) — Date — NOT NULL
- ip (Field3) — Int — NOT NULL
- deleted (Field4) — Bool — NOT NULL
member_like (Untitled23)
- member_id (Key) — Long — Foreign key → member.member_id — NOT NULL
- content_id (Key2) — Long — Foreign key → content.content_id — NOT NULL
- is_dislike (Field) — Bool — NOT NULL
member_view (Untitled22)
- member_id (Key) — Long — Foreign key → member.member_id — NOT NULL
- content_id (Key2) — Long — Foreign key → content.content_id — NOT NULL
music (Untitled10)
- music_id (Key) — Long — Foreign key → content.content_id — NOT NULL
- name (Field) — String — NOT NULL
- min_bpm (Field2) — Double
- max_bpm (Field3) — Double
music_artist (Untitled15)
- music_id (Key) — Long — Foreign key → music.music_id — NOT NULL
- artist_id (Key2) — Long — Foreign key → artist.artist_id — NOT NULL
permission (Untitled12)
- permission_id (Key) — Long — Primary key — NOT NULL
- label (Field) — String — NOT NULL
- inherits (Key2) — Long — Foreign key → permission.permission_id
play (Untitled8)
- play_id (Key) — Long — Foreign key → content.content_id — NOT NULL
- map_id (Key2) — Long — Foreign key → map.map_id — NOT NULL
- player_id (Key3) — Long — Foreign key → member.member_id — NOT NULL
- date (Field) — Date — NOT NULL
- speed (Field2) — Decimal(4, 2) — NOT NULL
- accuracy (Field3) — Decimal(5, 2) — NOT NULL
- pp (Field4) — Int — NOT NULL
- video (Field5) — URL — NOT NULL
- description (Field6) — String
- verified (Field7) — Bool
play_verify (Untitled19)
- play_id (Key) — Long — Foreign key → play.play_id — NOT NULL
- staff_id (Key2) — Long — Foreign key → staff.staff_id — NOT NULL
program (Untitled9)
- program_id (Key) — Long — Foreign key → content.content_id — NOT NULL
- latest_update (Key2) — Long — Foreign key → program_update.program_update_Id
- is_mod (Field) — Bool — NOT NULL
- source_link (Field2) — String — NOT NULL
- description (Field3) — String
- date (Field4) — Date — NOT NULL
program_developer (Untitled14)
- program_id (Key) — Long — Foreign key → program.program_id — NOT NULL
- developer_id (Key2) — Long — Foreign key → developer.developer_id — NOT NULL
- contribution (Field) — String
program_update (Untitled13)
- program_update_Id (Key) — Long — Primary key — NOT NULL
- program_id (Key2) — Long — Foreign key → program.program_id — NOT NULL
- version (Field) — String — NOT NULL
- changelog (Field2) — String
- file (Field3) — Blob — NOT NULL
- date (Field4) — Date — NOT NULL
staff (Untitled11)
- staff_id (Key) — Long — Foreign key → member.member_id — NOT NULL
- privilege (Key2) — Long — Foreign key → permission.permission_id — NOT NULL
tag (Untitled21)
- tag_id (Key) — Long — Primary key — NOT NULL
- icon (Field) — Blob — NOT NULL
- name (Field2) — String — NOT NULL
- description (Field3) — String