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

Table ID:

G_CREDIT     (1247777)

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

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:

Index	Type	Column(s) indexed
g_credit_pkey	Primary key	g_credit

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
g_credit_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
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.