This repository has been archived by the owner on Oct 15, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
RIALTO Derivative Database Data Model
Justin Coyne edited this page Aug 30, 2018
·
3 revisions
All entity tables have the following fields:
| Field | Expected Data Type | Cardinality | Definition |
|---|---|---|---|
id |
Integer | 1 | The identifier of the row |
uri |
URI | 1 | The canonical URI identifying the resource represented by the row |
created_at |
Timestamp | 1 | When the row was created |
updated_at |
Timestamp | 1 | When the row was last updated |
metadata |
JSONB | 1 | Metadata about the resource represented by the row |
| Field | Expected Data Type | Cardinality | Definition |
|---|---|---|---|
metadata/name
|
String | 1 | Name of the person |
metadata/department
|
URI | 1 | Identifier of the department with which the person is affiliated |
metadata/institutionalAffiliation
|
URI | 1 | Identifier of the institution with which the person is affiliated |
Publication metadata is unspecified at the moment.
| Field | Expected Data Type | Cardinality | Definition |
|---|---|---|---|
metadata/name
|
String | 1 | Name of the organization |
metadata/type
|
String | 1 | Type of organization (w/in an organization hierarchy) |
metadata/country
|
String, ISO-3166-1 alpha-3 | 1 | Three letter country code the organization is within |
| Field | Expected Data Type | Cardinality | Definition |
|---|---|---|---|
person_id |
Integer | 1 | Foreign key to Person table |
publication_id |
Integer | 1 | Foreign key to Publication table |