this table contains all species codes used in the CALCOM database
| name | value |
|---|---|
| name | [dbo].[SPECIES_CODES] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 197 |
| Size of data | 32 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 100 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| species | varchar | 4 | 4 | no | yes | no | ||||
| cdfg_code | varchar | 5 | 5 | yes | no | codes used by CDFW (generally numeric), these are not used by CALCOM | ||||
| pacfin_code | char | 4 | 4 | yes | no | PacFIN codes for the species - nearly identical to codes used by CALCOM | ||||
| common_name | char | 30 | 30 | no | no | |||||
| sci_name | char | 38 | 38 | no | no | |||||
| comp_use | char | 1 | 1 | yes | no | used by expansion program | ||||
| species_grp | char | 15 | 15 | yes | no | |||||
| all_comm | char | 1 | 1 | yes | no | for internal use only | ||||
| age_comp | char | 1 | 1 | yes | no | for internal use only | ||||
| len_comp | char | 1 | 1 | yes | no | for internal use only |