## page was renamed from Developer Manual 3.8/Database
== Database ==

<<Action(edit)>>

=== 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>
}}}