Acknowledges the role of outside contributors within specific tables.

Table ID:
GBH_ACK     (28235)
Contents:
Acknowledges the role of outside contributors within specific tables.
Approx. number of rows:
21
Table type:
Documentation
Documentation Author:
Humphrey Southall

Notes:

  1. This table links tables, as identified in the 'gbh_tables' table, to contributors, as identified in the 'gbh_contrib' table. NB these relationships are many-to-many, necessitating this intermediate table.


Indices:

IndexTypeColumn(s) indexed
gbh_ack_idx Unique tab_name, contrib


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
gbh_ack_contrib_fkey Foreign Key Column(s) {2} link to table gbh_contrib, column(s) {1}.
gbh_ack_tab_name_fkey Foreign Key Column(s) {1} link to table gbh_tables, column(s) {1}.



Columns within table:

ColumnTypeContents
tab_name Text string (max.len.=24). Name of the table to which they have contributed.
contrib Text string (max.len.=24). Short form of contributor's name, as listed in the gbh_contrib table.
notes Long text. Nature of their contribution to the table, and any table-specific restrictions on access.