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