Table transmart.i2b2demodata.upload_status 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
upload_id numeric 38  √  nextval('i2b2demodata.sq_uploadstatus_uploadid'::regclass)
archive_observation_fact.upload_id Implied Constraint R
code_lookup.upload_id Implied Constraint R
encounter_mapping.upload_id Implied Constraint R
observation_fact.upload_id Implied Constraint R
patient_dimension.upload_id Implied Constraint R
patient_mapping.upload_id Implied Constraint R
provider_dimension.upload_id Implied Constraint R
visit_dimension.upload_id Implied Constraint R
upload_label varchar 500
user_id varchar 100
source_cd varchar 50
source_master.source_cd Implied Constraint R
no_of_record numeric 131089  √  null
loaded_record numeric 131089  √  null
deleted_record numeric 131089  √  null
load_date timestamp 29,6
end_date timestamp 29,6  √  null
load_status varchar 100  √  null
message text 2147483647  √  null
input_file_name text 2147483647  √  null
log_file_name text 2147483647  √  null
transform_name varchar 500  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
upload_id Primary key Asc pk_up_upstatus_uploadid

Close relationships: