Table transmart.i2b2demodata.provider_dimension
Table that holds providers, e.g., physicians.

 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
provider_id varchar 50 Primary key.
provider_path varchar 700 Primary key. A path that identifies a provider.
name_char varchar 850  √  null The name of the provider.
provider_blob text 2147483647  √  null
update_date timestamp 29,6  √  null
download_date timestamp 29,6  √  null
import_date timestamp 29,6  √  null
sourcesystem_cd varchar 50  √  null
upload_id numeric 38  √  null
upload_status.upload_id Implied Constraint R

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
provider_path + provider_id Primary key Asc/Asc provider_dimension_pk
provider_id + name_char Performance Asc/Asc pd_idx_name_char
upload_id Performance Asc prod_uploadid_idx

Close relationships: