WhatSong

Tables (4)

Untitled (tournament_items)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (draw) — INT — Primary key — NOT NULL
  • Field (round) — INT — Primary key — NOT NULL
  • Key (tournament_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (music_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (is_won) — INT — NOT NULL

Untitled (genre)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(255) — NOT NULL

Untitled (music)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(255) — NOT NULL
  • Field (cover) — VARCHAR(255) — NOT NULL
  • Field (youtube_link) — VARCHAR(255) — NOT NULL
  • Field (spotify_link) — VARCHAR(255) — NOT NULL
  • Field (apple_link) — VARCHAR(255) — NOT NULL
  • Field (artist) — VARCHAR(255) — NOT NULL
  • Key (genre_id) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled2 (tournaments)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (genre_id) — INT — Foreign key → Untitled.Key — NOT NULL