WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
A person record must be defined first to relate a source with an organization even if the person is unknown because sources connect to organizations through a person.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| PersonID | Integer |
| Primary key identifier | |||
| PersonName | VarChar(255) | First and Last name of the person | |||||
| Address | VarChar(255) |
| The primary mailing address of the person, including street, city, state, zip, and country | ||||
| VarChar(255) |
| The primary email address of the person | |||||
| Phone | VarChar(50) |
| The primary phone number of the person | ||||
| PersonWebpage | VarChar(255) |
| A URL for the website for a person | ||||
| Position | VarChar(255) |
| Position of the person | ||||
| OrganizationID | Integer | Foreigh key identifier for an organization |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_People_Organizations | Metadata.Organizations | Metadata.People | OrganizationID | OrganizationID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |