common.relationships

Field Type Null Default Key Extra Comment
rlsp_id int(11) NO PRI auto_increment
rlsp_code varchar(10) NO UNI
rlsp_hl7_code varchar(20) YES
rlsp_desc varchar(50) NO
rlsp_family tinyint(1) NO 0 1 FOR family type relationship
rlsp_snomed_codes varchar(45) YES
rlsp_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
rlsp_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
rlsp_code
TableColumn
_1.patient_next_of_kinpnk_rlsp_code
_1188.patient_next_of_kinpnk_rlsp_code
_1218.patient_next_of_kinpnk_rlsp_code
_1548.patient_next_of_kinpnk_rlsp_code
_435.patient_next_of_kinpnk_rlsp_code
_436.patient_next_of_kinpnk_rlsp_code
_436_archive_testing.patient_next_of_kinpnk_rlsp_code
_437.patient_next_of_kinpnk_rlsp_code
_8.patient_next_of_kinpnk_rlsp_code
_81.patient_next_of_kinpnk_rlsp_code
_999.patient_next_of_kinpnk_rlsp_code
rlsp_id
TableColumn
_1.patients_relatives_mapprm_rlsp_id
_1188.patients_relatives_mapprm_rlsp_id
_1218.patients_relatives_mapprm_rlsp_id
_1548.patients_relatives_mapprm_rlsp_id
_435.patients_relatives_mapprm_rlsp_id
_436.patients_relatives_mapprm_rlsp_id
_436_archive_testing.patients_relatives_mapprm_rlsp_id
_437.patients_relatives_mapprm_rlsp_id
_8.patients_relatives_mapprm_rlsp_id
_81.patients_relatives_mapprm_rlsp_id
_999.patients_relatives_mapprm_rlsp_id