Identifiers linking to one or more external contributions to the statistical database

Table ID:
G_CREDIT     (57953)
Contents:
Identifiers linking to one or more external contributions to the statistical database
Approx. number of rows:
10
Table type:
Documentation
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Notes:

  1. Rows in this table identify bundles of one or more specific contributions to the statistical database, the actual contributions being defined in the g_credit_ack table. The identifiers held here are the only part of the 'credits' sub-system to be directly referenced in the very large g_data table, so they are deliberately kept minimal, all the details being held in other more easily-updated parts of the sub-system.


Indices:

IndexTypeColumn(s) indexed
g_credit_pkey Primary key g_credit


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
g_credit_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
g_credit Text string (max.len.=28). Identifier for the credit.
g_seq Integer number. Sequence number, automatically inserted.
where_clause Long text. Optionally, the text of the SQL 'where clause' used when inserting the credit into the data table.
notes Long text. Comments, not intended for public display.