Table-NLPG_METADATA
Created by: Lester Caine, Last modification: 20 Aug 2008 (09:45 UTC)
Field | Type | NULL | Default | Description |
CONTENT_ID | Numeric(18,0) | Primary | ||
CUSTODIAN_NAME | Varchar(40) | NOT NULL | ||
CUSTODIAN_UPRN | Numeric(18,0) | NOT NULL | ||
CUSTODIAN_CODE | Char(4) | NOT NULL | ||
PROCESS_DATE | Timestamp | NOT NULL | NOW | |
VOLUME_NUMBER | Smallint | NOT NULL | ||
ENTRY_DATE | Date | NOT NULL | ||
TIME_STAMP | Date | NOT NULL | ||
DTF_VERSION | Double precision | NOT NULL | ||
FILE_TYPE | Char(1) | NOT NULL | ||
GAZ_NAME | Varchar(60) | NOT NULL | ||
GAZ_SCOPE | Varchar(60) | NOT NULL | ||
TER_OF_USE | Varchar(60) | NOT NULL | ||
LINKED_DATA | Varchar(100) | |||
GAZ_OWNER | Varchar(60) | NOT NULL | ||
NGAZ_FREQ | Char(1) | |||
CO_ORD_SYSTEM | Varchar(40) | |||
CO_ORD_UNIT | Varchar(10) | |||
META_DATE | Date | |||
CLASS_SCHEME | Varchar(40) | |||
GAZ_DATE | Date | |||
LANGUAGE | Char(3) | |||
CHARACTER_SET | Varchar(30) | |||
LAST_LPI_KEY | Char(14) | |||
LAST_PROV_KEY | Char(14) | |||
LAST_XREF_KEY | Char(14) | |||
LAST_UPDATE_DATE | Date | |||
LAST_TIME_STAMP | Timestamp |