Diff for "System Design 3.14/Database"

Differences between revisions 3 and 4

Database

Description of the individual tables and their columns can be now found in the Derby SQL create script createfullhddb.sql.

System Design 3.14/Database (last edited 2011-05-09 09:10:29 by MikisSethSorensen)

-  ⇤ ← Revision 3 as of 2010-10-15 08:36:45 → 
  Size: 1520
  Editor: TueLarsen
  Comment:
+   ← Revision 4 as of 2011-05-09 09:08:54 → ⇥
  Size: 254
  Editor: MikisSethSorensen
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
-## page was renamed from Developer Manual 3.14/Database
-Line 4:
+Line 3:
-<<Action(edit)>>

=== Database overview ===
Below you find a database diagram of the physical tables in the !NetarchiveSuite database.

 {{attachment:Database_Overview_3.14.0.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>
}}}
+Description of the individual tables and their columns can be now found in the Derby SQL create script [[https://sbforge.org/fisheye/browse/~raw,r=HEAD/NetarchiveSuite/branches/3.14/scripts/sql/createfullhddb.sql|createfullhddb.sql]].