1 | | == Structure of ARSF database == |
| 1 | == Structure of current ARSF Database == |
| 2 | |
| 3 | The database is made up of 9 tables, joined together by relations. See below for a diagram of the database tables and relations |
| 4 | |
| 5 | The 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 == |