Transact-SQL Reference
roysched
| Column_name | Data type | Nullable | Default | Check | Key/index |
|---|---|---|---|---|---|
| title_id | tid | no | FK titles(title_id) | ||
| lorange | int | yes | |||
| hirange | int | yes | |||
| royalty | int | yes |
This table shows the contents of the roysched table.
| title_id | lorange | hirange | royalty |
|---|---|---|---|
| BU1032 | 0 | 5000 | 10 |
| BU1032 | 5001 | 50000 | 12 |
| PC1035 | 0 | 2000 | 10 |
| PC1035 | 2001 | 3000 | 12 |
| PC1035 | 3001 | 4000 | 14 |
| PC1035 | 4001 | 10000 | 16 |
| PC1035 | 10001 | 50000 | 18 |
| BU2075 | 0 | 1000 | 10 |
| BU2075 | 1001 | 3000 | 12 |
| BU2075 | 3001 | 5000 | 14 |
| BU2075 | 5001 | 7000 | 16 |
| BU2075 | 7001 | 10000 | 18 |
| BU2075 | 10001 | 12000 | 20 |
| BU2075 | 12001 | 14000 | 22 |
| BU2075 | 14001 | 50000 | 24 |
| PS2091 | 0 | 1000 | 10 |
| PS2091 | 1001 | 5000 | 12 |
| PS2091 | 5001 | 10000 | 14 |
| PS2091 | 10001 | 50000 | 16 |
| PS2106 | 0 | 2000 | 10 |
| PS2106 | 2001 | 5000 | 12 |
| PS2106 | 5001 | 10000 | 14 |
| PS2106 | 10001 | 50000 | 16 |
| MC3021 | 0 | 1000 | 10 |
| MC3021 | 1001 | 2000 | 12 |
| MC3021 | 2001 | 4000 | 14 |
| MC3021 | 4001 | 6000 | 16 |
| MC3021 | 6001 | 8000 | 18 |
| MC3021 | 8001 | 10000 | 20 |
| MC3021 | 10001 | 12000 | 22 |
| MC3021 | 12001 | 50000 | 24 |
| TC3218 | 0 | 2000 | 10 |
| TC3218 | 2001 | 4000 | 12 |
| TC3218 | 4001 | 6000 | 14 |
| TC3218 | 6001 | 8000 | 16 |
| TC3218 | 8001 | 10000 | 18 |
| TC3218 | 10001 | 12000 | 20 |
| TC3218 | 12001 | 14000 | 22 |
| TC3218 | 14001 | 50000 | 24 |
| PC8888 | 0 | 5000 | 10 |
| PC8888 | 5001 | 10000 | 12 |
| PC8888 | 10001 | 15000 | 14 |
| PC8888 | 15001 | 50000 | 16 |
| PS7777 | 0 | 5000 | 10 |
| PS7777 | 5001 | 50000 | 12 |
| PS3333 | 0 | 5000 | 10 |
| PS3333 | 5001 | 10000 | 12 |
| PS3333 | 10001 | 15000 | 14 |
| PS3333 | 15001 | 50000 | 16 |
| BU1111 | 0 | 4000 | 10 |
| BU1111 | 4001 | 8000 | 12 |
| BU1111 | 8001 | 10000 | 14 |
| BU1111 | 12001 | 16000 | 16 |
| BU1111 | 16001 | 20000 | 18 |
| BU1111 | 20001 | 24000 | 20 |
| BU1111 | 24001 | 28000 | 22 |
| BU1111 | 28001 | 50000 | 24 |
| MC2222 | 0 | 2000 | 10 |
| MC2222 | 2001 | 4000 | 12 |
| MC2222 | 4001 | 8000 | 14 |
| MC2222 | 8001 | 12000 | 16 |
| MC2222 | 12001 | 20000 | 18 |
| MC2222 | 20001 | 50000 | 20 |
| TC7777 | 0 | 5000 | 10 |
| TC7777 | 5001 | 15000 | 12 |
| TC7777 | 15001 | 50000 | 14 |
| TC4203 | 0 | 2000 | 10 |
| TC4203 | 2001 | 8000 | 12 |
| TC4203 | 8001 | 16000 | 14 |
| TC4203 | 16001 | 24000 | 16 |
| TC4203 | 24001 | 32000 | 18 |
| TC4203 | 32001 | 40000 | 20 |
| TC4203 | 40001 | 50000 | 22 |
| BU7832 | 0 | 5000 | 10 |
| BU7832 | 5001 | 10000 | 12 |
| BU7832 | 10001 | 15000 | 14 |
| BU7832 | 15001 | 20000 | 16 |
| BU7832 | 20001 | 25000 | 18 |
| BU7832 | 25001 | 30000 | 20 |
| BU7832 | 30001 | 35000 | 22 |
| BU7832 | 35001 | 50000 | 24 |
| PS1372 | 0 | 10000 | 10 |
| PS1372 | 10001 | 20000 | 12 |
| PS1372 | 20001 | 30000 | 14 |
| PS1372 | 30001 | 40000 | 16 |
| PS1372 | 40001 | 50000 | 18 |