VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
«previous | 31 | page 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Party | Middle Name | middleName | no | varchar (50) | n/a | no | One's middle name or initial, if any. |
Party | Surname | surName | no | varchar (50) | n/a | no | Name shared in common to identify the members of a family, as distinguished from each member's given name. |
Party | Organization Name | organizationName | no | varchar (100) | n/a | no | Name of an organization. |
Party | Current Name | currentName_ID | no | Integer | FK | no | Recursive foreign key to current name of this party. |
Party | Contact Instructions | contactInstructions | no | text | n/a | no | Instructions for contacting a party. |
Party | Accession Code | accessionCode | no | varchar (100) | n/a | no | Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number). |
Party | Party Type | partyType | no | varchar (40) | n/a | closed | The type of party this is. |
Party Member | Party Member ID | partyMember_ID | required | serial | PK | no | Database generated number to uniquely identify this record of this table. |
Party Member | Main Party | parentParty_ID | required | Integer | FK | no | Link to the parent party to whom the child party here belongs. |
Party Member | Sub-Party | childParty_ID | required | Integer | FK | no | Link to the child party who belongs to the parent listed in parentParty_ID. |