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