⇤ ← Revision 1 as of 2009-11-17 08:17:10
1507
Comment: Generated the documentation branch for 3.12
|
← Revision 2 as of 2010-08-16 10:24:45 ⇥
1513
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
Database overview
Below you find a database diagram of the physical tables in the NetarchiveSuite database.
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>