Spotify MBTI test DB

Tables (7)

answer (Untitled3)

  • Key (idx) — INT — Primary key — NOT NULL
  • Key (user_idx) — INT — Foreign key → user.Key — NOT NULL
  • Key (question_idx) — INT — Foreign key → question.Key — NOT NULL
  • (content) — BOOLEAN — NOT NULL
  • (created_at) — TIMESTAMP — NOT NULL

mbti (Untitled5)

  • Key (idx) — INT — Primary key — NOT NULL
  • (type) — VARCHAR — NOT NULL

music_MBTI (Untitled6)

  • Key (idx) — INT — Primary key — NOT NULL
  • Key (MBTI) — VARCHAR — Foreign key → mbti.Key — NOT NULL
  • (library_idx) — VARCHAR — NOT NULL
  • (track_idx) — VARCHAR — NOT NULL

music_saved (Untitled7)

  • Key (idx) — INT — Primary key — NOT NULL
  • Key (user_idx) — INT — Foreign key → user.Key — NOT NULL
  • Key (idx2) — INT — Foreign key → user.Key — NOT NULL
  • (library_idx) — VARCHAR — NOT NULL
  • (added_to_spotify) — BOOLEAN — NOT NULL
  • (created_at) — TIMESTAMP — NOT NULL

question (Untitled2)

  • Key (idx) — INT — Primary key — NOT NULL
  • (content) — TEXT — NOT NULL

result (Untitled4)

  • Key (idx) — INT — Primary key — NOT NULL
  • Key (user_idx) — INT — Foreign key → user.Key — NOT NULL
  • Key (MBTI) — VARCHAR — Foreign key → mbti.Key — NOT NULL
  • (created_at) — TIMESTAMP — NOT NULL

user (Untitled)

  • Key (idx) — INT — Primary key — NOT NULL
  • Key (MBTI) — VARCHAR — Foreign key → mbti.Key
  • Field (nickname) — VARCHAR(10) — NOT NULL
  • Field (spotify_linked) — BOOLEAN — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL