standardized_tables_track

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	INT	10		√	null

|

| | | imported_date | DATETIME | 19 | √ | | NULL |

|

| | | name | VARCHAR | 255 | | | '' |

|

|

name of standardized tables such as RXNORM

| | revision_version | VARCHAR | 255 | | | '' |

|

|

revision of standardized tables that were imported

| | revision_date | DATETIME | 19 | √ | | NULL |

|

|

revision of standardized tables that were imported

| | file_checksum | VARCHAR | 32 | | | '' |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id

Relationships

Close relationships within degrees of separation