Table transmart.tm_cz.patient_dimension_release 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
patient_num int8 19  √  null
vital_status_cd varchar 50  √  null
birth_date timestamp 29,6  √  null
death_date timestamp 29,6  √  null
sex_cd varchar 50  √  null
age_in_years_num int8 19  √  null
language_cd varchar 50  √  null
race_cd varchar 50  √  null
marital_status_cd varchar 50  √  null
religion_cd varchar 50  √  null
zip_cd varchar 50  √  null
statecityzip_path varchar 700  √  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 int8 19  √  null
patient_blob text 2147483647  √  null
release_study varchar 50  √  null

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