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