LC Digital Repository Development and Support
NDLP Repository Data Tables -- DRAFT

ACCESS PROFILE

NU_ACCESS    NUMBER(9),    Access Profile ID
CD_ACCESS    VARCHAR2(4),    Access Type
NU_ROLE    NUMBER(4),    Related Role
DT_START    DT,    Activation date
DT_END    DT    Expiration date


AGENT

NU_AGENT    VARCHAR2(9),
NA_NAME    VARCHAR2(40),
TX_ADDR_LINE1    VARCHAR2(30),
TX_ADDR_LINE2    VARCHAR2(30),
TX_CITY    VARCHAR2(20),
CD_STATE    VARCHAR2(2),
CD_ZIP_CODE    VARCHAR2(10)


AGG_ITEM_ASSIGNMENT

NU_AGG    NUMBER(9),    Aggregate ID
NU_SOURCE    NUMBER(9),    Source Item ID
NU_ITEM    VARCHAR2(4),  Item Number in Aggregate
DT_ASSIGNED    DT,     Date Assigned (MMDDYYYY)
DT_REMOVED    DT     Date Assignment Removed (MMDDYYYY)


ASSOC_FILE

NU_ASSOC_FILE    NUMBER(9),    Associated File ID
CD_ASSOC_TYPE    VARCHAR2(4),    Associated File Type
NA_ASSOC_FILE    VARCHAR2(50)     Associated File Name


ASSOC_FILE_ASSIGNMENT

NU_CONTENT_HANDLE    NUMBER(_),    Digital Content ID
NU_ASSOC_FILE    NUMBER(9),    Associated File ID
DT_START    DT     Date Assignment Defined (MMDDYYYY)
DT_END    DT     Date Assignment Discontinued (MMDDYYYY)


CONTENT_RELATIONSHIP

NU_CONTENT_HANDLE    NUMBER(_),
CD_CONTENT_REL_TYPE    VARCHAR2(5),
TX_CONTENT_REL_VALUE    VARCHAR2(20)


DIGITAL_CONTENT

NU_CONTENT_HANDLE    NUMBER(_),
NU_DO_HANDLE    VARCHAR2(100),
QT_DATA_SIZE    NUMBER(10),
CD_DATA_TYPE    VARCHAR2(4),
TX_DESCRIPTION    VARCHAR2(60),
NU_ACCESS    NUMBER(9),
CD_CONTENT_STATUS    VARCHAR2(4),
DT_CONTENT_DEPOSIT    DATE,
TM_CONTENT_DEPOSIT    TIME,
CD_DATA_CONTENT_USE    VARCHAR2(2),
DT_CONTENT_LAST_REV    DATE,
TM_CONTENT_LAST_REV    TIME,
DT_CREATED    DATE,
TM_CREATED    TIME,
EQUIP_CREATED_BY    NUMBER(9),
CREATOR    NUMBER(9),
CONTENT    VARCHAR2(_____)


DIGITAL_OBJECT

NU_DO_HANDLE    VARCHAR2(100),
TX_DESCRIPTION    VARCHAR2(60),
NU_AGGREGATE    NUMBER(9),
CD_ORIG_CONTENT    VARCHAR2(4),
NU_RTS_PERMS    NUMBER(4),
NU_INSTANCE    NUMBER(3),
DT_DEPOSIT    DATE,
TM_DEPOSIT    TIME,
CD_DO_USE    VARCHAR2(3),
DT_LAST_REV    DATE,
TM_LAST_REV    TIME


NOTICE_PROFILE

NU_REQ_NOTICE    NUMBER(4),    Required Notice Profile ID
CD_NOTICE_TYPE    VARCHAR2(66),    Required Notice Type
NU_NOTICE    NUMBER(4),    Notice ID
DT_START  DATE,    Activation date
DT_END  DATE    Expiration Date


NOTICE_TEXT

NU_NOTICE    NUMBER(4),    Notice ID
TX_NOTICE    VARCHAR2(66)    Notice Text


PAGE_PROFILE

NU_CONTENT_HANDLE    NUMBER(15),
CD_PAGE    VARCHAR2(5),
TX_PAGE_VALUE    VARCHAR2(20)


PARENT_CHILD

NU_PARENT_DO_HANDLE    VARCHAR2(100),
NU_CHILD_DO_HANDLE    VARCHAR2(100),


PERM_PROFILE

NU_PERMISSION    NUMBER(9),    Permission Profile ID
CD_PERMISSION    VARCHAR2(4),    Permission Type
NU_ROLE    NUMBER(4),    Related Role
DT_START  DATE,    Activation date
DT_END  DATE    Expiration date


RESTRICTION_STATEMENT

NU_DO_HANDLE
NU_CONTENT_HANDLE
TX_RESTRICTION


RIGHTS_PERMS

NU_RIGHTS_PERMS    NUMBER(4),    Rights/Permissions ID
NU_ACCESS    NUMBER(9),    Access Profile ID
NU_NOTICE    NUMBER(9),    Notice Profile ID
NU_PERMISSION    NUMBER(9),    Permission Profile ID
NU_USE    NUMBER(9)    Use Profile ID


ROLE

CD_ROLE    VARCHAR2(4),
NU_DO_HANDLE    VARCHAR2(100),
NU_AGENT    NUMBER(9)


SOURCE_ITEM

NU_ITEM    NUMBER(9)  Source Item ID
CD_DESCRIPTION    VARCHAR2(2),  Descriptive Information Type
  (e.g., MARC, MINARET)
NU_DESCRIPTION    NUMBER(15)  Descriptive Information ID
CD_CONTENT    VARCHAR2(4), Content Type
  (same as Original Content Type for digital object)
CD_GENERATION    VARCHAR2(_),  Version used to digitize
CD_CONVERSION    VARCHAR2(_),  __
CD_FORMAT    VARCHAR2(_),  Physical Format
CD_CONDITION    VARCHAR2(_),  Physical Condition
CD_EXTENT    VARCHAR2(2),  Extent Type (e.g., dimensions, duration)
NU_EXTENT    NUMBER(11)  Extent Value
QT_CHROM_VALUE    VARCHAR2(2),  Chromatic Value
CD_SIDE    VARCHAR2(2),  Side of item digitized
NU_INVENTORY    NUMBER(11)  Inventory ID
NU_EXHIBIT    NUMBER(12)  Exhibit ID


USE PROFILE

NU_USE    NUMBER(9),    Use Profile ID
CD_USE    VARCHAR2(4),    Use Type
NU_ROLE    NUMBER(4),    Related Role
DT_STARTDATE,    Activation date
DT_ENDDATE    Expiration date


Go to:  Top of page  ,  Structural Metadata Dictionary.


Created: 11/20/97       Revised: 6/14/99
National Digital Library Program - Digital Repository Development Project
Comments: [email protected]