adofai.gg v2

Tables (25)

confirmation_token (Untitled6)

  • confirmation_token_id (Key) — BIGINT(20) — Primary key — NOT NULL
  • method_id (Field) — VARCHAR(100) — NOT NULL
  • token (Field2) — VARCHAR(100) — NOT NULL
  • expired (Field3) — BIT(1) — NOT NULL
  • expiration_date (Field4) — DATETIME(6) — NOT NULL
  • create_date (Field5) — DATETIME(6) — NOT NULL
  • last_modified_date (Field6) — DATETIME(6) — NOT NULL

content (Untitled5)

  • content_id (Key) — BIGINT(20) — Primary key — NOT NULL
  • content_type_id (Key2) — BIGINT(20) — Foreign key → content_type.content_type_id — NOT NULL
  • level_id (Key5) — BIGINT(20) — Foreign key → level.level_id — NOT NULL
  • world_id (Key3) — BIGINT(20) — Foreign key → world.world_id — NOT NULL
  • level_request_id (Key4) — BIGINT(20) — Foreign key → level_request.level_request_id — NOT NULL
  • comment_id (Key33) — BIGINT(20) — Foreign key → member_comment.comment_id — NOT NULL
  • program_id (Key32) — BIGINT(20) — Foreign key → program.program_id — NOT NULL
  • play_log_id (Key22) — BIGINT(20) — Foreign key → play_log.play_log_id — NOT NULL

content_tag (Untitled11)

  • content_id (Key) — BIGINT(20) — Foreign key → content.content_id — NOT NULL
  • tag_id (Key2) — BIGINT(20) — Foreign key → tag.tag_id — NOT NULL

content_type (Untitled24)

  • content_type_id (Key) — BIGINT(20) — Primary key — NOT NULL
  • name (Field) — VARCHAR(20) — NOT NULL

level (Untitled12)

  • level_id (Key) — BIGINT(20) — Primary key — NOT NULL
  • world_id (Key2) — BIGINT(20) — Foreign key → world.world_id — NOT NULL
  • music_id (Key22) — BIGINT(20) — Foreign key → music.song_id
  • metadata (Field4) — VARCHAR(100) — NOT NULL
  • file_name (Field) — VARCHAR(100) — NOT NULL
  • tile (Field8) — BIGINT(20) — NOT NULL
  • difficulty (Field2) — DOUBLE
  • tutorial_order (Field3) — BIGINT(20)
  • epilepsy_warning (Field5) — BIT(1) — NOT NULL
  • censored (Field6) — BIT(1) — NOT NULL
  • deleted (Field7) — BIT(1) — NOT NULL

level_registration (Untitled19)

    level_request (Untitled17)

    • level_request_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • level_id (Key2) — BIGINT(20) — Foreign key → level.level_id — NOT NULL
    • requester_id (Key3) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • expect_difficulty (Field) — DOUBLE
    • final_difficulty (Field2) — DOUBLE
    • reason (Field3) — VARCHAR(1000) — NOT NULL
    • date (Field4) — DATETIME(6) — NOT NULL

    level_review (CopyOfUntitled19)

    • level_request_id (Key) — BIGINT(20) — Foreign key → level_request.level_request_id — NOT NULL
    • reviewer_id (Key3) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • difficulty (Field) — DOUBLE — NOT NULL

    login_log (Untitled20)

    • login_log_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • member_id (Key2) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • date (Field) — DATETIME(6) — NOT NULL
    • ip (Field2) — BIGINT(20) — NOT NULL

    member (Untitled)

    • member_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • name (Field2) — VARCHAR(100) — NOT NULL
    • email (Field) — VARCHAR(50)
    • password (Field3) — VARCHAR(200)
    • description (Field5) — VARCHAR(1000) — NOT NULL
    • total_pp (Field8) — DOUBLE — NOT NULL
    • best_play_log_id (Key2) — BIGINT(20) — Foreign key → play_log.play_log_id
    • registration_date (Field6) — DATETIME(6) — NOT NULL
    • discord_name (Field7) — VARCHAR(50)
    • steam_url (Field9) — VARCHAR(100)
    • youtube_url (Field10) — VARCHAR(100)
    • github_url (Field11) — VARCHAR(100)
    • artist_verification_status (Field4) — VARCHAR(20)

    member_comment (Untitled7)

    • comment_id (Key3) — BIGINT(20) — Primary key — NOT NULL
    • content_id (Key) — BIGINT(20) — Foreign key → content.content_id — NOT NULL
    • member_id (Key2) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • text (Field) — VARCHAR(200) — NOT NULL
    • date (Field2) — DATETIME(6) — NOT NULL
    • ip (Field3) — BIGINT(20) — NOT NULL
    • deleted (Field4) — BIT(1) — NOT NULL

    member_like (Untitled23)

    • member_id (Key) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • content_id (Key2) — BIGINT(20) — Foreign key → content.content_id — NOT NULL
    • is_like (Field) — BIT(1) — NOT NULL

    member_permission (Untitled3)

    • member_id (Key) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • permission_id (Key2) — BIGINT(20) — Foreign key → permission.permission_id — NOT NULL

    member_view (Untitled22)

    • member_view_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • member_id (Key3) — BIGINT(20) — Foreign key → member.member_id
    • content_id (Key2) — BIGINT(20) — Foreign key → content.content_id — NOT NULL
    • ip (Field) — BIGINT(20) — NOT NULL

    music (Untitled10)

    • song_id (Key2) — BIGINT(20) — Primary key — NOT NULL
    • name (Field) — VARCHAR(100) — NOT NULL
    • min_bpm (Field2) — DOUBLE — NOT NULL
    • max_bpm (Field3) — DOUBLE — NOT NULL

    music_artist (Untitled15)

    • music_id (Key22) — BIGINT(20) — Foreign key → music.song_id — NOT NULL
    • artist_id (Key) — BIGINT(20) — Foreign key → member.member_id — NOT NULL

    permission (Untitled4)

    • permission_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • name (Field) — VARCHAR(20) — NOT NULL

    play_log (Untitled8)

    • play_log_id (Key2) — BIGINT(20) — Primary key — NOT NULL
    • player_id (Key3) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • level_id (Key4) — BIGINT(20) — Foreign key → level.level_id
    • world_update_id (Key) — BIGINT(20) — Foreign key → world_update.world_update_id — NOT NULL
    • date (Field) — DATETIME(6) — NOT NULL
    • speed (Field2) — BIGINT(20) — NOT NULL
    • accuracy (Field3) — DOUBLE
    • playPoint (Field4) — DOUBLE — NOT NULL
    • video (Field5) — VARCHAR(100) — NOT NULL
    • description (Field6) — VARCHAR(1000) — NOT NULL
    • verified (Field7) — BIT(1) — NOT NULL

    program (Untitled9)

    • program_id (Key3) — BIGINT(20) — Primary key — NOT NULL
    • latest_update_id (Key2) — BIGINT(20) — Foreign key → program_update.program_update_Id — NOT NULL
    • uploader_id (Key) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • name (Field5) — VARCHAR(100) — NOT NULL
    • simple_description (Field) — VARCHAR(255) — NOT NULL
    • description (Field3) — VARCHAR(1000) — NOT NULL
    • source_url (Field2) — VARCHAR(100)
    • upload_date (Field4) — DATETIME(6) — NOT NULL

    program_developer (Untitled14)

    • program_id (Key3) — BIGINT(20) — Foreign key → program.program_id — NOT NULL
    • developer_id (Key2) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • contribution (Field) — VARCHAR(50) — NOT NULL

    program_update (Untitled13)

    • program_update_Id (Key) — BIGINT(20) — Primary key — NOT NULL
    • program_id (Key3) — BIGINT(20) — Foreign key → program.program_id — NOT NULL
    • version (Field) — VARCHAR(20) — NOT NULL
    • description (Field2) — VARCHAR(1000) — NOT NULL
    • file_name (Field3) — VARCHAR(100) — NOT NULL
    • date (Field4) — DATETIME(6) — NOT NULL

    tag (Untitled21)

    • tag_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • content_type_id (Key2) — BIGINT(20) — Foreign key → content_type.content_type_id — NOT NULL
    • name (Field2) — VARCHAR(20) — NOT NULL

    world (Untitled2)

    • world_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • lastest_update_id (Key3) — BIGINT(20) — Foreign key → world_update.world_update_id
    • title (Field) — VARCHAR(100) — NOT NULL
    • description (Field2) — VARCHAR(1000) — NOT NULL
    • video (Field3) — VARCHAR(100) — NOT NULL
    • download (Field10) — VARCHAR(100) — NOT NULL
    • workshop (Field4) — VARCHAR(100)
    • censored (Field6) — BIT(1) — NOT NULL
    • deleted (Field7) — BIT(1) — NOT NULL
    • upload_date (Field8) — DATETIME(6) — NOT NULL
    • update_date (Field9) — DATETIME(6) — NOT NULL

    world_creator (Untitled16)

    • creator_id (Key) — BIGINT(20) — Foreign key → member.member_id — NOT NULL
    • world_id (Key2) — BIGINT(20) — Foreign key → world.world_id — NOT NULL

    world_update (Untitled18)

    • world_update_id (Key) — BIGINT(20) — Primary key — NOT NULL
    • world_id (Key2) — BIGINT(20) — Foreign key → world.world_id — NOT NULL
    • update_date (Field) — DATETIME(6) — NOT NULL
    • file_name (Field2) — VARCHAR(100) — NOT NULL