Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2009-05-26 12:16:32 →
Size: 1507
Editor: KaareChristiansen
Comment: Created by the PackagePages action.
← Revision 2 as of 2010-08-16 10:25:01 → ⇥
Size: 1513
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 4: Line 4:
[[Action(edit)]] <<Action(edit)>>
Line 9: Line 9:
 attachment:Database_Overview.gif  {{attachment:Database_Overview.gif}}
Line 12: Line 12:
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. 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.

Database

edit

Database overview

Below you find a database diagram of the physical tables in the NetarchiveSuite database.

  • 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 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>

System Design 3.10/Database (last edited 2010-08-16 10:25:01 by localhost)