Data Models


Table TAXA

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

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

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: