Changes between Version 6 and Version 7 of AdvancedDatabaseDevelopment

Timestamp:

02/12/26 18:02:57 (2 weeks ago)

Author:

231136

Comment:

--

AdvancedDatabaseDevelopment

@@ -8 +8 @@
 {{{
 CREATE TABLE daily_top_albums (
-    day DATE,
-    album_id BIGINT NULL,
+    day DATE PRIMARY KEY,
+    album_id BIGINT NULL REFERENCES albums(id),
     play_count BIGINT
 );
 
 CREATE TABLE daily_top_artists (
-    day DATE,
-    artist_id BIGINT NULL,
+    day DATE PRIMARY KEY ,
+    artist_id BIGINT NULL REFERENCES artists(user_id),
     play_count BIGINT
 );
 
 CREATE TABLE daily_top_songs (
-    day DATE,
-    song_id BIGINT NULL,
+    day DATE PRIMARY KEY ,
+    song_id BIGINT NULL REFERENCES songs(id),
     play_count BIGINT
 );