Columns

Columns

Table	Type	Column	Type	Size	Nulls	Auto	Default	Comments
Artist	Table	ArtistId	int	4			null
Invoice	Table	InvoiceId	int	4			null
Employee	Table	BirthDate	datetime	16	√		null
Customer	Table	CustomerId	int	4			null
AlbumsArtists	View	album	nvarchar	320			null
Customer	Table	Company	nvarchar	160	√		null
Employee	Table	FirstName	nvarchar	40			null
InvoiceLine	Table	UnitPrice	numeric	12			null
Employee	Table	Fax	nvarchar	48	√		null
Customer	Table	State	nvarchar	80	√		null
Customer	Table	PostalCode	nvarchar	20	√		null
Track	Table	Composer	nvarchar	440	√		null
AlbumsArtists	View	artist	nvarchar	240	√		null
Employee	Table	HireDate	datetime	16	√		null
Employee	Table	Country	nvarchar	80	√		null
Customer	Table	City	nvarchar	80	√		null
Invoice	Table	BillingPostalCode	nvarchar	20	√		null
InvoiceLine	Table	InvoiceId	int	4			null
Track	Table	AlbumId	int	4	√		null
Employee	Table	PostalCode	nvarchar	20	√		null
Employee	Table	State	nvarchar	80	√		null
Employee	Table	Phone	nvarchar	48	√		null
Employee	Table	Address	nvarchar	140	√		null
Album	Table	AlbumId	int	4			null
Customer	Table	SupportRepId	int	4	√		null
Invoice	Table	InvoiceDate	datetime	16			null
Playlist	Table	Name	nvarchar	240	√		null
Track	Table	Name	nvarchar	400			null
Invoice	Table	BillingAddress	nvarchar	140	√		null
Track	Table	TrackId	int	4			null
Employee	Table	Title	nvarchar	60	√		null
Invoice	Table	BillingCountry	nvarchar	80	√		null
InvoiceLine	Table	Quantity	int	4			null
Employee	Table	ReportsTo	int	4	√		null
PlaylistTrack	Table	TrackId	int	4			null
Invoice	Table	CustomerId	int	4			null
InvoiceLine	Table	TrackId	int	4			null
Album	Table	ArtistId	int	4			null
Track	Table	MediaTypeId	int	4			null
Employee	Table	City	nvarchar	80	√		null
Customer	Table	FirstName	nvarchar	80			null
Customer	Table	LastName	nvarchar	40			null
Invoice	Table	BillingState	nvarchar	80	√		null
Employee	Table	EmployeeId	int	4			null
Invoice	Table	Total	numeric	12			null
Genre	Table	GenreId	int	4			null
Playlist	Table	PlaylistId	int	4			null
MediaType	Table	MediaTypeId	int	4			null
Genre	Table	Name	nvarchar	240	√		null
Customer	Table	Fax	nvarchar	48	√		null
Artist	Table	Name	nvarchar	240	√		null
Employee	Table	LastName	nvarchar	40			null
Track	Table	GenreId	int	4	√		null
Customer	Table	Phone	nvarchar	48	√		null
PlaylistTrack	Table	PlaylistId	int	4			null
Customer	Table	Country	nvarchar	80	√		null
MediaType	Table	Name	nvarchar	240	√		null
Track	Table	UnitPrice	numeric	12			null
Invoice	Table	BillingCity	nvarchar	80	√		null
Employee	Table	Email	nvarchar	120	√		null
Track	Table	Milliseconds	int	4			null
Customer	Table	Email	nvarchar	120			null
Track	Table	Bytes	int	4	√		null
Album	Table	Title	nvarchar	320			null
Customer	Table	Address	nvarchar	140	√		null
InvoiceLine	Table	InvoiceLineId	int	4			null