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 |