This table contains information about how borrowing was done to produce year end species specific landings found in the COM_LANDS table. Real_ =strata that was expanded, Used_ were the strata borrowed from.
| name | value |
|---|---|
| name | [dbo].[COMP_EXPAND_DOCS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 20,924 |
| Size of data | 984 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 34 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | char | 4 | 4 | no | composite PK | no | ||||
| real_quarter | char | 1 | 1 | no | composite PK | no | quarter (1-4) in which fish were landed | |||
| real_live | char | 1 | 1 | no | composite PK | no | whether fish were landed live (Y or N) | |||
| real_mark_cat | char | 3 | 3 | no | composite PK | no | market category in which fish were landed | |||
| real_gear_grp | char | 3 | 3 | no | composite PK | no | gear group in which fish were landed | |||
| real_port_complex | char | 3 | 3 | no | composite PK | no | port complex where fish were landed | |||
| used_live | char | 1 | 1 | no | no | |||||
| used_mark_cat | char | 3 | 3 | no | no | |||||
| used_gear_grp | char | 3 | 3 | no | no | |||||
| used_port_complex | char | 3 | 3 | no | no | |||||
| used_quarter | char | 1 | 1 | no | no | |||||
| sample_count | int | 10 | 4 | no | no | number of samples used to expand this strata - refer to documentation on expansion process | ||||
| used_year | char | 4 | 4 | no | no |