Relationship, 189 (ver5.0.0)
Relationship records for family Management. This table, along with the Person table, will help define Family Management information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 5.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 5.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Person_ID | 5.0.0 | Number(10,0) | The ID of the Person with whom this record is associated. Indexed. |
ReciprocalRelationship_ID | 5.0.0 | Number(10,0) | Bi-directional link for the Person record in this table. This field will provide the ability to search for all relations to the Student as well as all other relationships to the associated Person_ID (and thus to be able to discern relationships such as brothers and sisters, etc.). ID of the related Relationship record. Indexed. |
RelatedPerson_ID | 5.0.0 | Number(10,0) | The ID of the Person related to the Person_ID in this record. Indexed. |