Table pacsdb.public.code Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
pk int8 19
content_item.code_fk fk_gudw6viy7lrf5t5hetw7mbgh5 R
content_item.name_fk fk_pyrd1nhijag5ct0ee9xqq4h78 R
instance.srcode_fk fk_7w6f9bi2w91qr2abl6ddxnrwq R
mpps.discreason_code_fk fk_nrigpgue611m33rao03nnfe5l R
rejected_instance.reject_code_fk fk_iafiq2ugv5rd6fonwd0vd7xdx R
rel_study_pcode.pcode_fk fk_fryhnb2ppb6fcop3jrrfwvnfy R
rel_ups_perf_code.perf_code_fk fk_6asj28yy5se9mp443b6ryefd2 R
series.inst_code_fk fk_oiq81nulcmtg6p85iu31igtf5 R
ups.station_class_fk fk_ak183xmw0sai4jg9lib6m14o2 R
ups.station_location_fk fk_ox3hpmd042ywnww3yh33crcoj R
ups.station_name_fk fk_gd2hu9idxg6rd71g1i8r8wyjr R
ups.ups_code_fk fk_1retecpk22a2tysmi5o6xcpbh R
code_meaning varchar 255
code_value varchar 255
code_designator varchar 255
code_version varchar 255

Table contained 0 rows at Fri Dec 13 14:14 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc code_pkey
code_value + code_designator + code_version Must be unique Asc/Asc/Asc uk_sb4oc9lkns36wswku831c33w6

Close relationships  within of separation: