Back to Openemr

ccda_table_mapping

Documentation/EHI_Export/docs/tables/ccda_table_mapping.html

latest868 B
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idINT10null

|

| | | ccda_component | VARCHAR | 100 | √ | | NULL |

|

| | | ccda_component_section | VARCHAR | 100 | √ | | NULL |

|

| | | form_dir | VARCHAR | 100 | √ | | NULL |

|

| | | form_type | SMALLINT | 5 | √ | | NULL |

|

| | | form_table | VARCHAR | 100 | √ | | NULL |

|

| | | user_id | INT | 10 | √ | | NULL |

|

| | | deleted | TINYINT | 3 | | | 0 |

|

| | | timestamp | TIMESTAMP | 19 | | | current_timestamp() |

|

| |

Indexes

Constraint NameTypeSortColumn(s)
PRIMARYPrimary keyAscid

Relationships

Close relationships within degrees of separation