Constraints

7 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
Employee.ReportsTo
Employee.EmployeeId
Restrict delete
Album.ArtistId
Artist.ArtistId
Restrict delete
PlaylistTrack.PlaylistId
PlaylistTrack.TrackId
Playlist.PlaylistId
Track.TrackId
Restrict delete
Customer.SupportRepId
Employee.EmployeeId
Restrict delete
InvoiceLine.InvoiceId
InvoiceLine.TrackId
Invoice.InvoiceId
Track.TrackId
Restrict delete
Invoice.CustomerId
Customer.CustomerId
Restrict delete
Track.AlbumId
Track.GenreId
Track.MediaTypeId
Album.AlbumId
Genre.GenreId
MediaType.MediaTypeId
Restrict delete

Check Constraints

Table Constraint Name Constraint