Table transmart.i2b2demodata.set_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 131089
set_type_id int4 10
set_type.id fk_up_set_type_id R
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 + set_type_id Primary key Asc/Asc pk_up_upstatus_idsettypeid

Close relationships: