PlaylistTrack

Description

Table Definition

CREATE TABLE [PlaylistTrack]
(
    [PlaylistId] INTEGER  NOT NULL,
    [TrackId] INTEGER  NOT NULL,
    CONSTRAINT [PK_PlaylistTrack] PRIMARY KEY  ([PlaylistId], [TrackId]),
    FOREIGN KEY ([PlaylistId]) REFERENCES [Playlist] ([PlaylistId]) 
        ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY ([TrackId]) REFERENCES [Track] ([TrackId]) 
        ON DELETE NO ACTION ON UPDATE NO ACTION
)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
PlaylistId	INTEGER		false		Playlist
TrackId	INTEGER		false		Track

Constraints

Name	Type	Definition
PlaylistId	PRIMARY KEY	PRIMARY KEY (PlaylistId)
TrackId	PRIMARY KEY	PRIMARY KEY (TrackId)
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (TrackId) REFERENCES Track (TrackId) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (PlaylistId) REFERENCES Playlist (PlaylistId) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
sqlite_autoindex_PlaylistTrack_1	PRIMARY KEY	PRIMARY KEY (PlaylistId, TrackId)

Indexes

Name	Definition
IFK_PlaylistTrackTrackId	CREATE INDEX [IFK_PlaylistTrackTrackId] ON [PlaylistTrack] ([TrackId])
sqlite_autoindex_PlaylistTrack_1	PRIMARY KEY (PlaylistId, TrackId)

Relations