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