Album

Description

Table Definition

CREATE TABLE [Album]
(
    [AlbumId] INTEGER  NOT NULL,
    [Title] NVARCHAR(160)  NOT NULL,
    [ArtistId] INTEGER  NOT NULL,
    CONSTRAINT [PK_Album] PRIMARY KEY  ([AlbumId]),
    FOREIGN KEY ([ArtistId]) REFERENCES [Artist] ([ArtistId]) 
        ON DELETE NO ACTION ON UPDATE NO ACTION
)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
AlbumId	INTEGER		false	Track
Title	NVARCHAR(160)		false
ArtistId	INTEGER		false		Artist

Constraints

Name	Type	Definition
AlbumId	PRIMARY KEY	PRIMARY KEY (AlbumId)
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (ArtistId) REFERENCES Artist (ArtistId) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE

Indexes

Name	Definition
IFK_AlbumArtistId	CREATE INDEX [IFK_AlbumArtistId] ON [Album] ([ArtistId])

Relations