Constraints

11 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_EmployeeReportsTo
Employee.ReportsTo
Employee.EmployeeId
Restrict delete
FK_AlbumArtistId
Album.ArtistId
Artist.ArtistId
Restrict delete
FK_PlaylistTrackTrackId
PlaylistTrack.TrackId
Track.TrackId
Restrict delete
FK_PlaylistTrackPlaylistId
PlaylistTrack.PlaylistId
Playlist.PlaylistId
Restrict delete
FK_CustomerSupportRepId
Customer.SupportRepId
Employee.EmployeeId
Restrict delete
FK_InvoiceCustomerId
Invoice.CustomerId
Customer.CustomerId
Restrict delete
FK_InvoiceLineInvoiceId
InvoiceLine.InvoiceId
Invoice.InvoiceId
Restrict delete
FK_InvoiceLineTrackId
InvoiceLine.TrackId
Track.TrackId
Restrict delete
FK_TrackMediaTypeId
Track.MediaTypeId
MediaType.MediaTypeId
Restrict delete
FK_TrackAlbumId
Track.AlbumId
Album.AlbumId
Restrict delete
FK_TrackGenreId
Track.GenreId
Genre.GenreId
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected