ADOFAI Forum viewer
Tables (23)
comments (Untitled)
- comment_id (Key) — Long — Primary key — NOT NULL
- location (Field5) — Text — NOT NULL
- location_id (Field6) — Long — NOT NULL
- member_id (Key22) — Long — Foreign key → member.member_id — NOT NULL
- parent_id (Key3) — Long — Foreign key → comments.comment_id
- text (Field) — Text — NOT NULL
- date (Field2) — Date — NOT NULL
- likes (Field3) — Int — NOT NULL
- dislikes (Field4) — Int — NOT NULL
- ip (Field7) — IP — NOT NULL
- deleted (Field8) — Bool — NOT NULL
level (CopyOfUntitled4)
- level_id (Key) — Long — Primary key — NOT NULL
- song_id (Key2) — Long — Foreign key → song.song_id — NOT NULL
- title (Field8) — Text — NOT NULL
- description (Field7) — Text — NOT NULL
- difficulty (Field6) — Double — NOT NULL
- detail_difficulty (Field16) — Double — NOT NULL
- tile (Field) — Long — NOT NULL
- epilepsy_warning (Field2) — Bool — NOT NULL
- video (Field3) — Text — NOT NULL
- file (Field4) — Blob — NOT NULL
- workshop (Field5) — Text
- is_shown (Field9) — Bool — NOT NULL
- date (Field10) — Date — NOT NULL
- last_update (Field11) — Date — NOT NULL
- look (Field12) — Int — NOT NULL
- likes (Field13) — Int — NOT NULL
- dislikes (Field14) — Int — NOT NULL
- comment (Field15) — Int — NOT NULL
level_creator (Untitled15)
- level_creator_id (Key) — Long — Primary key — NOT NULL
- level_id (Key2) — Long — Foreign key → level.level_id — NOT NULL
- person_id (Key3) — Long — Foreign key → person.person_id — NOT NULL
level_request (Untitled17)
- level_request_id (Key) — Long — Primary key — NOT NULL
- level_id (Key3) — Long — Foreign key → level.level_id — NOT NULL
- person_id (Key2) — Long — Foreign key → person.person_id — NOT NULL
- expect_difficulty (Field) — Double
- comment (Field2) — Text — NOT NULL
- date (Field3) — Date — NOT NULL
level_set (Untitled18)
- level_set_id (Key) — Long — Primary key — NOT NULL
- level_request_id (Key3) — Long — Foreign key → level_request.level_request_id — NOT NULL
- person_id (Key2) — Long — Foreign key → person.person_id — NOT NULL
- set_difficulty (Field) — Double — NOT NULL
likes (Untitled2)
- likes_id (Key) — Long — Primary key — NOT NULL
- location (Field) — Text — NOT NULL
- location_id (Field3) — Long — NOT NULL
- is_like (Field2) — Bool — NOT NULL
- member_id (Key22) — Long — Foreign key → member.member_id — NOT NULL
- ip (Field4) — IP — NOT NULL
login_log (Untitled4)
- login_log_id (Key) — Long — Primary key — NOT NULL
- member_id (Key22) — Foreign key → member.member_id — NOT NULL
- date (Field) — Date — NOT NULL
- ip (Field2) — IP — NOT NULL
- way (Field3) — Text — NOT NULL
member (Untitled10)
- member_id (Key2) — Long — Primary key — NOT NULL
- person_id (Key) — Long — Foreign key → person.person_id — NOT NULL
- id (Field) — Text — NOT NULL
- password (Field2) — Text — NOT NULL
- profile (Field3) — Blob
- description (Field4) — Text — NOT NULL
- date (Field5) — Date — NOT NULL
member_permission (Untitled12)
- member_permission_id (Key) — Primary key — NOT NULL
- permission_id (Key2) — Long — Foreign key → permission.permission_id — NOT NULL
- member_id (Key22) — Foreign key → member.member_id — NOT NULL
permission (Untitled11)
- permission_id (Key) — Long — Primary key — NOT NULL
- name (Field) — Text — NOT NULL
person (CopyOfUntitled)
- person_id (Key) — Long — Primary key — NOT NULL
- name (Field) — text — NOT NULL
- discord (Field2) — text
play_log (CopyOfUntitled8)
- play_log_id (Key2) — Long — Primary key — NOT NULL
- level_id (Key) — Long — Foreign key → level.level_id — NOT NULL
- person_id (Key3) — Long — Foreign key → person.person_id — NOT NULL
- date (Field5) — Date — NOT NULL
- speed (Field) — Int — NOT NULL
- accuracy (Field2) — Double — NOT NULL
- playPoint (Field3) — Double — NOT NULL
- url (Field4) — Text — NOT NULL
- description (Field6) — Text — NOT NULL
- accept (Field7) — Bool — NOT NULL
- look (Field10) — Int — NOT NULL
- likes (Field8) — Int — NOT NULL
- dislikes (Field9) — Int — NOT NULL
program (Untitled19)
- program_id (Key) — Long — Primary key — NOT NULL
- title (Field) — Text — NOT NULL
- simple_description (Field2) — Text — NOT NULL
- description (Field3) — Text — NOT NULL
- date (Field4) — Date — NOT NULL
- last_edit (Field5) — Date — NOT NULL
- look (Field6) — Int — NOT NULL
- likes (Field7) — Int — NOT NULL
- dislikes (Field8) — Int — NOT NULL
- comments (Field9) — Int — NOT NULL
program_creator (Untitled20)
- program_creator_id (Key) — Long — Primary key — NOT NULL
- program_id (Key2) — Long — Foreign key → program.program_id — NOT NULL
- member_id (Key22) — Long — Foreign key → member.member_id — NOT NULL
program_file (Untitled23)
- program_file_id (Key) — Long — Primary key — NOT NULL
- program_update_id (Key2) — Long — Foreign key → program_update.program_update_id — NOT NULL
- file (Field) — Blob — NOT NULL
program_update (Untitled21)
- program_update_id (Key2) — Long — Primary key — NOT NULL
- program_id (Key) — Long — Foreign key → program.program_id — NOT NULL
- version (Field) — Text — NOT NULL
- description (Field2) — Text — NOT NULL
- date (Field3) — Date — NOT NULL
- likes (Field4) — Int — NOT NULL
- dislikes (Field5) — Int — NOT NULL
song (CopyOfUntitled2)
- song_id (Key) — Long — Primary key — NOT NULL
- name (Field) — Text — NOT NULL
- min_bpm (Field2) — Double — NOT NULL
- max_bpm (Field3) — Double — NOT NULL
song_artist (Untitled13)
- song_artist_id (Key3) — Long — Primary key — NOT NULL
- person_id (Key) — Long — Foreign key → person.person_id — NOT NULL
- song_id (Key2) — Long — Foreign key → song.song_id — NOT NULL
standard_level (Untitled3)
- standard_level_id (Key2) — Long — Primary key — NOT NULL
- level_id (Key) — Long — Foreign key → level.level_id — NOT NULL
- easiest_level (Field) — Bool — NOT NULL
- difficulty (Field2) — Double — NOT NULL
- idx (Field3) — Int — NOT NULL
tag (Untitled14)
- tag_id (Key) — Long — Primary key — NOT NULL
- type (Field2) — Text — NOT NULL
- name (Field) — Text — NOT NULL
- priority (Field3) — Long — NOT NULL
tags (Untitled5)
- tags_id (Key) — Long — Primary key — NOT NULL
- location (Field) — Text — NOT NULL
- location_id (Field2) — Long — NOT NULL
- tag_id (Key2) — Long — Foreign key → tag.tag_id — NOT NULL
verify_email (Untitled6)
- verify_id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR — NOT NULL
- code (Field3) — VARCHAR — NOT NULL
- expiry_date (Field2) — DATETIME — NOT NULL
views (CopyOfUntitled22)
- views_id (Key) — Long — Primary key — NOT NULL
- location (Field) — Text — NOT NULL
- location_id (Field3) — Long — NOT NULL
- member_id (Key22) — Long — Foreign key → member.member_id
- date (Field2) — Time — NOT NULL
- ip (Field4) — IP — NOT NULL