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.reject_code_fk fk_6pnwsvi69g5ypye6gjo26vn7e R
instance.srcode_fk fk_7w6f9bi2w91qr2abl6ddxnrwq R
mpps.discreason_code_fk fk_nrigpgue611m33rao03nnfe5l R
rel_study_pcode.pcode_fk fk_fryhnb2ppb6fcop3jrrfwvnfy R
series.inst_code_fk fk_oiq81nulcmtg6p85iu31igtf5 R
code_meaning varchar 255
code_value varchar 255
code_designator varchar 255
code_version varchar 255

Table contained 0 rows at Thu Dec 21 12:28 CET 2017

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: