Database
Database overview
Below you find a database diagram of the physical tables in the NetarchiveSuite database.
- attachment:Database_Overview.gif
Table and Column Descriptions
Description of the individual tables and their columns can be now found in the Derby SQL create script [https://gforge.statsbiblioteket.dk/plugins/scmsvn/viewcvs.php/*checkout*/trunk/scripts/sql/createfullhddb.sql?root=netarchivesuite createfullhddb.sql]. Note that Derby automatically generates indexes for unique columns, other types of databases may need to set these indices manually.
The table and column descriptions is given on form:
<ALL> :== <AREA_WITH_TABLES>* <AREA_WITH_TABLES> :== --************************************************-- -- Area: <Area Name> -- <Area description> --************************************************-- <TABLE_DEFINITION>* <TABLE_DEFINITION> :== ---------------------------------------------------- -- Name: <Table name> -- Descr.: <Table description> [-- Purpose: <Purpose description>] [-- Expected entry count: <Exp. count description>] <SQL_CREATE_TABLE_DEF> <Sql create index def>* <Sql insert data def>* <SQL_CREATE_TABLE_DEF> :== create table <Table name>( <COLUMN_DEF>+ [<Primary key definition over more columns>] ); <COLUMN_DEF> :== <Sql column def> -- <Column description>