This table contains an inventory of all of the otoliths are in our collection. Note that some otoliths are stored in coin envelopes, while others are stored in trays. Those stored in trays give us the ability to track down otoltihs for a specific fish.
| name | value |
|---|---|
| name | [dbo].[OTOLITH_INVENTORY] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 16,386 |
| Size of data | 1,536 kb |
| Size of indexes | 792 kb |
| Maximum size of a single row | 206 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| Temp_primary_key | int identity (1,1) | 10 | 4 | no | yes | no | This column inserted for MS Access compatability. It resolves a data retrieval bug. It will be removed in the future when all otoliths have been moved to tray biens. | |||
| year | varchar | 5 | 5 | no | no | |||||
| species | varchar | 4 | 4 | no | no | |||||
| box_no | varchar | 15 | 15 | yes | no | This is the box in which the coin envelopes are stored. | ||||
| tray_no | int | 10 | 4 | yes | no | This is the Tray Bien number. If null, then otoliths are stored in coin envelopes. | ||||
| source | varchar | 50 | 50 | no | no | Used for Coin envelopes (RES, REC, COM) are possible values. | ||||
| total | int | 10 | 4 | no | no | Total number of otoliths. | ||||
| sample_no | varchar | 25 | 25 | yes | no | If not null then sample # on Tray Biens; otherwise otoliths are in coin envelopes. | ||||
| clust_haul_no | varchar | 3 | 3 | yes | no | If a Commercial sample, then it is cluster number, if Research, it is haul number. | ||||
| start_fish_no | int | 10 | 4 | yes | no | If otoliths in trays, it is the first number of the sample and clust/haul in the group. | ||||
| end_fish_no | int | 10 | 4 | yes | no | |||||
| start_cell_no | int | 10 | 4 | yes | no | Start cell number in the Tray Bien for this group. | ||||
| end_cell_no | int | 10 | 4 | yes | no | The last cell number in the tray for this group. | ||||
| aged | char | 1 | 1 | yes | no | This field is not reliable and may be discontinued. | ||||
| location | varchar | 25 | 25 | yes | no | Where the otoliths are stored (typically Santa Cruz). | ||||
| loan_info | varchar | 50 | 50 | yes | no | Who these otoliths are on loan to. |
| name | object type | level |
|---|