Tablename: tables_in_use
This table is an utility table and it contains a list of all the database tables which are used by Marina Mammal and Bird Web Application and which contain researcher's data. One row for each table.
This table is used to query the postgeress database and display online the list of fields, field types and field descriptions for those tables. All the rows were added manually.
The information about the tables listed in the tables_in_use table is stored in postgress system tables: pg_class, pg_description .
| Field name | Field type | Field length | Field description |
|---|---|---|---|
| table_id | integer | None | Unique record id number. | table_name | character varying | 50 | Table name. |