<?xml version = '1.0' encoding = 'UTF-8'?>
<Table class="oracle.dbtools.crest.model.design.relational.Table" directorySegmentName="seg_0" id="F7A36117-18C8-CBB3-3896-7281CCBB19CA" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="ERX_STATUS">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>ERX_STATUS</sourceObjName>
<createdBy>jwandling</createdBy>
<createdTime>2016-03-17 17:52:13 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<ordsAlias>table_6</ordsAlias>
<allowColumnReorder>false</allowColumnReorder>
<existDependencyGenerateInDDl>true</existDependencyGenerateInDDl>
<parsed>true</parsed>
<columns itemClass="oracle.dbtools.crest.model.design.relational.Column">
<Column name="CODE" id="E0B6217D-099E-2887-9598-F9D337B098B6">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-17 17:52:13 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>4</dataTypeSize>
<ownDataTypeParameters>4,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="AUTO_CHECK" id="693C19EE-5D9E-7165-9AB0-7EBCF13C7468">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-17 18:38:42 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>A1AD9C56-2884-0F3B-5333-FA312FE54359</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="CODE_DESCRIPTION" id="31B4E95F-100A-D08F-599D-93957AA7D120">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-17 17:52:13 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>EF353603-2D76-4B4E-67D5-8CEE47AAADE4</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="UPDATED_DATE" id="4C307EBF-00D9-05DE-BF02-3363F01008B5">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-01 14:42:49 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>0FC4AF37-1118-1079-1AB1-071361FB8249</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="CREATED_DATE" id="660EC22D-97B7-A659-2CCE-B2C6B537D190">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-01 14:43:05 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>0FC4AF37-1118-1079-1AB1-071361FB8249</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
</columns>
<indexes itemClass="oracle.dbtools.crest.model.design.relational.Index">
<ind_PK_UK id="D79A1D69-9102-3BCD-8B4C-872361BEF5D7" name="ERX_STATUS_PK">
<createdBy>jwandling</createdBy>
<createdTime>2016-05-23 14:12:24 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<pk>true</pk>
<indexState>Primary Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="E0B6217D-099E-2887-9598-F9D337B098B6"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="CD183DF5-4605-3A38-C954-F4D506B55E08" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="ERX_STATUS_PK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>ERX_STATUS_PK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>9F791566-C00C-468E-4B4B-6222C35736D3</importedID>
<indexState>Unique Plain Index</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="E0B6217D-099E-2887-9598-F9D337B098B6"/>
</indexColumnUsage>
</ind_PK_UK>
</indexes>
</Table>