mpps

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pk int8 19 null
hl7psu_task.mpps_fk fklvjl0o0sdhht440wccag722e4R
ian_task.mpps_fk fks3re94tlv0dbd5go33mwdk6drR
accession_no varchar 255 null
accno_entity_id varchar 255 √ null
accno_entity_uid varchar 255 √ null
accno_entity_uid_type varchar 255 √ null
created_time timestamp 29,6 null
pps_start_date varchar 255 null
pps_start_time varchar 255 null
sop_iuid varchar 255 null
pps_status int2 5 null
study_iuid varchar 255 null
updated_time timestamp 29,6 null
version int8 19 √ null
dicomattrs_fk int8 19 null
dicomattrs.pk fknhstgtx2w1xd61u4iqbn731puR
discreason_code_fk int8 19 √ null
code.pk fk2m3l9bh173bmq88ukf81yd9owR
patient_fk int8 19 null
patient.pk fks7mb8qsr1mjijnw9bvx0dhqabR

Indexes

Constraint Name Type Sort Column(s)
mpps_pkey Primary key Asc pk
fk2m3l9bh173bmq88ukf81yd9ow Performance Asc discreason_code_fk
fks7mb8qsr1mjijnw9bvx0dhqab Performance Asc patient_fk
mpps_dicomattrs_fk_key Must be unique Asc dicomattrs_fk
mpps_sop_iuid_key Must be unique Asc sop_iuid

Check Constraints

Constraint Name Constraint
mpps_pps_status_check (((pps_status >= 0) AND (pps_status <= 2)))

Relationships

Close relationships within degrees of separation