roysched Table

The roysched table contains title ID, royalty percentage, and other information about title royalties.

roysched is defined as:

create table roysched
title_id tid not null
    references titles(title_id),
lorange int null,
hirange int null,
royalty int null)

Its nonclustered index for the title_id column is defined as:

create nonclustered index titleidind
on roysched (title_id)