Table = taxa +-----------------+----------+--------+----------+-----+ | Field | Type | Length | Not Null | Key | +-----------------+----------+--------+----------+-----+ | spec_id | char | 32 | Y | Y | | tax_order | char | 30 | N | N | | family | char | 30 | N | N | | genus | char | 30 | Y | N | | species | char | 30 | Y | N | | authority | char | 30 | N | N | | comname | char | 70 | N | N | | image_url | char | 80 | N | N | +-----------------+----------+--------+----------+-----+
Additional text fields:
Table = taxa_loc +-----------------+----------+--------+----------+-----+ | Field | Type | Length | Not Null | Key | +-----------------+----------+--------+----------+-----+ | loc_id | char | 32 | Y | Y | | ul_lat | char | 10 | N | N | | ul_lon | char | 10 | N | N | | lr_lat | char | 10 | N | N | | lr_lon | char | 10 | N | N | | loc_name | char | 80 | N | N | | loc_url | char | 120 | N | N | | habitat | char | 80 | N | N | +-----------------+----------+--------+----------+-----+
Additional text fields:
Table = taxa_obs +-----------------+----------+--------+----------+-----+ | Field | Type | Length | Not Null | Key | +-----------------+----------+--------+----------+-----+ | obs_id | char | 32 | Y | Y | | spec_id | char | 32 | N | N | | loc_id | char | 32 | N | N | | citation | char | 200 | N | N | | observer | char | 70 | N | N | | obs_date | char | 8 | N | N | | habitat | char | 120 | N | N | | abundance | char | 20 | N | N | +-----------------+----------+--------+----------+-----+
Additional text fields: