InvoiceLine


Columns

Column Type Size Nulls Auto Default Children Parents Comments
InvoiceLineId int 4 null
InvoiceId int 4 null
Invoice.InvoiceId FK_InvoiceLineInvoiceId R
TrackId int 4 null
Track.TrackId FK_InvoiceLineTrackId R
UnitPrice numeric 12,2 null
Quantity int 4 null

Table contained 2240 rows

Indexes

Constraint Name Type Sort Column(s)
PK_InvoiceLine Primary key Asc InvoiceLineId
IFK_InvoiceLineInvoiceId Performance Asc InvoiceId
IFK_InvoiceLineTrackId Performance Asc TrackId

Relationships

Close relationships within degrees of separation