Changes between Version 2 and Version 3 of statusdatabase


Ignore:
Timestamp:
Aug 8, 2014 9:41:55 AM (5 years ago)
Author:
tec
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • statusdatabase

    v2 v3  
    1 == Structure of ARSF database ==
     1== Structure of current ARSF Database ==
     2
     3The database is made up of 9 tables, joined together by relations. See below for a diagram of the database tables and relations
     4
     5The PI table is made up of the PI's name, address and their email address. The table has and internal field called 'id' which is filled in automatically and is referred to whenever a PI is linked to a project code.
     6||||||||||||= PI Table =||
     7||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
     8|| Primary Key || id || Integer(4 Bytes) || Required || Value is automatically generated ||
     9||  || pi_name || Text (variable length) || Required ||  ||
     10||  || address || Text (variable length) ||  || Not required as may not be known at time of entry. ||
     11||  || email || Text (variable length) ||  || Not required as may not be known at time of entry. ||
     12
     13
     14
     15
     16
     17
     18
     19
     20
     21
     22
     23
     24
     25
     26
     27
     28
     29
     30
     31
     32
     33
     34
     35
     36
     37
     38
     39
     40
     41
     42
     43
     44
     45
     46== Structure of old ARSF ID-Key-Value database ==
    247
    348For furture maintenance.