An idea to help organize your music with extra metadata using a SQL Server Database. This repository searches through a folder and gathers metadata already in mp3 files to add to a database
Some tables have references to IDs from other tables. Add foreign key constraints to ensure the IDs in those tables actually match with IDs found in the table they intend to reference
Consider adding unique constraints to tables with auto-incrementing keys to all columns except for their keys
i.e. The data in the table should be unique not just because of the auto-increment, but because the "payload" data is actually different
UNIQUE constraints should only be used on "primary" tables. That is, tables that have real data in them, not just tables that map between other tables.
Some tables have references to IDs from other tables. Add foreign key constraints to ensure the IDs in those tables actually match with IDs found in the table they intend to reference
Consider adding unique constraints to tables with auto-incrementing keys to all columns except for their keys
UNIQUEconstraints should only be used on "primary" tables. That is, tables that have real data in them, not just tables that map between other tables.