test1

Tables (7)

codecontext

  • context_key — int4 — NOT NULL
  • vgroup_key — int4 — vgroup_key
  • context_id — varchar(64) — NOT NULL — context_id
  • context_name — varchar(256) — NOT NULL — context_name
  • created_dttm — timestamptz(6) — NOT NULL — created_dttm
  • updated_dttm — timestamptz(6) — NOT NULL — updated_dttm

dcmstudymetadata

  • dcm_study_key — int4 — NOT NULL
  • metadata_json — json — NOT NULL — metadata_json

docsetuser

  • docset_user_key — int4 — NOT NULL
  • docset_key — int4 — NOT NULL — docset_key
  • user_key — int4 — NOT NULL — user_key
  • event_tag — varchar(64) — event_tag
  • created_dttm — timestamptz(6) — NOT NULL — created_dttm

documentpurgequeue

  • queue_key — int4 — NOT NULL
  • vgroup_id — varchar(64) — NOT NULL — vgroup_id
  • vgroup_id_type — varchar(16) — NOT NULL — vgroup_id_type
  • document_uid — varchar(64) — NOT NULL — document_uid
  • repository_uid — varchar(64) — NOT NULL — repository_uid
  • location_type — varchar(4) — NOT NULL — location_type
  • location_root — varchar(256) — NOT NULL — location_root
  • location_path — varchar(256) — NOT NULL — location_path
  • document_size — int8 — NOT NULL — document_size
  • document_hash — varchar(256) — NOT NULL — document_hash
  • patient_id — personid_t — NOT NULL — patient_id
  • patient_name — varchar(256) — NOT NULL — patient_name
  • created_dttm — timestamptz(6) — NOT NULL — created_dttm
  • deleted_dttm — timestamptz(6) — deleted_dttm

xdsdocsetprocessrule

  • process_rule_key — int4 — NOT NULL
  • vgroup_key — int4 — vgroup_key
  • patient_id_value — varchar(64) — patient_id_value
  • source_id — varchar(64) — source_id
  • content_type_code — codepair_t — content_type_code
  • docset_status — varchar(1) — docset_status
  • process_key — int4 — NOT NULL — process_key
  • created_dttm — timestamptz(6) — NOT NULL — created_dttm
  • updated_dttm — timestamptz(6) — NOT NULL — updated_dttm
  • deleted_dttm — timestamptz(6) — deleted_dttm

xdsdocumenteventcode

  • xds_document_key — int4 — NOT NULL
  • code_value — varchar(64) — NOT NULL — code_value
  • coding_scheme — varchar(64) — NOT NULL — coding_scheme
  • code_meaning — varchar(256) — code_meaning

xdsdocumentreferenceid

  • xds_document_key — int4 — NOT NULL
  • id_value — varchar(64) — NOT NULL — id_value
  • issuer_id — varchar(64) — issuer_id
  • issuer_id_type — varchar(16) — issuer_id_type
  • id_type — varchar(64) — NOT NULL — id_type
  • id_type_meaning — varchar(256) — id_type_meaning
  • home_community_id — varchar(64) — home_community_id