<?xml version = '1.0' encoding = 'UTF-8'?>
<Table class="oracle.dbtools.crest.model.design.relational.Table" directorySegmentName="seg_0" id="6F5794BC-A11C-1E41-CA7C-2B6518C33BD4" schemaObject="65D26282-39A6-4EC5-5E14-A3DD24F2CC11" name="prsn">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<comment>This a base for the Doctors and Patients </comment>
<commentInRDBMS>This a base for the Doctors and Patients </commentInRDBMS>
<generatorID>1636C01E-DE30-3646-E64B-707119BDA7C1</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<ordsEnable>true</ordsEnable>
<abbreviation>prsn</abbreviation>
<allowColumnReorder>false</allowColumnReorder>
<existDependencyGenerateInDDl>true</existDependencyGenerateInDDl>
<parsed>true</parsed>
<columns itemClass="oracle.dbtools.crest.model.design.relational.Column">
<Column name="pid" id="86AD98FA-B7FB-0F77-03DA-0F3D70E9BB1C">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<comment>personal identifier is a number that uniqly identify a person all across the system</comment>
<commentInRDBMS>personal identifier is a number that uniqly identify a person all across the system</commentInRDBMS>
<generatorID>8F3B1B52-74FD-6AFD-98D4-2F8D4570F203</generatorID>
<notes>personal identifier is a number that uniqly identify a person all across the system</notes>
<ownerDesignName>CDM</ownerDesignName>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>2018A11C-9475-9826-9DBF-064F55F52439</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
<notNullConstraintName>NNC_prsn_prsn_pi</notNullConstraintName>
</Column>
<Column name="first_name" id="959E44E6-D449-9D57-6D67-E7225BF276BE">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>C3E74EB7-BBAE-DFDA-0CB8-1D6A2951292F</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>A3A3C77D-0366-9768-FF89-1C25E56881C8</logicalDatatype>
<domain>A6E023AB-2D2D-4D9F-2406-60DA8CAC13D2</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="father_name" id="37C161C4-9326-D0C7-B744-AF634655E247">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>9542A9DD-5830-991A-4A69-6647CB5D9E81</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>A3A3C77D-0366-9768-FF89-1C25E56881C8</logicalDatatype>
<domain>A6E023AB-2D2D-4D9F-2406-60DA8CAC13D2</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="family_name" id="7B1423C7-FB2F-D3FB-66B0-9F6DAB423725">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>F7A8A9DF-1006-327E-27EB-27DCA4D6DCEC</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>A3A3C77D-0366-9768-FF89-1C25E56881C8</logicalDatatype>
<domain>A6E023AB-2D2D-4D9F-2406-60DA8CAC13D2</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="mother_name" id="9CEA424C-1AEC-4B13-7580-772D5358A623">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>F6CED95B-46F1-0563-5FCB-B038D17BBD69</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>A3A3C77D-0366-9768-FF89-1C25E56881C8</logicalDatatype>
<domain>A6E023AB-2D2D-4D9F-2406-60DA8CAC13D2</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="mother_family_name" id="228BEE7E-2A15-15DC-6FC4-0FB29E438C45">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>13C20477-08D4-6156-AA67-7E8D95138621</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>A3A3C77D-0366-9768-FF89-1C25E56881C8</logicalDatatype>
<domain>A6E023AB-2D2D-4D9F-2406-60DA8CAC13D2</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="birth_place" id="BBF949EC-1AB2-3C97-7CC6-AEFDA3458DE9">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>979C3F31-DC50-3605-7FC3-F3CC5A5E42C6</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>A3A3C77D-0366-9768-FF89-1C25E56881C8</logicalDatatype>
<domain>13E299FC-EFD7-76F5-3D7A-8E149723B694</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="birth_date" id="E9C497D2-4FA3-7900-14E8-463A4CB0DF95">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>9E67518B-62E8-053D-4F20-04229016E537</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<constraintName>CK_prsn_prsn_birth_date</constraintName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C7E6966A-84FC-33F5-E123-A5ECDB510B8C</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="prsn_type" id="7A69825C-4ECB-64E3-7D74-583C14CEDF81">
<createdBy>ali</createdBy>
<createdTime>2016-04-04 08:10:46 UTC</createdTime>
<ownerDesignName>CDM</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT025</logicalDatatype>
<dataTypeSize>4 CHAR</dataTypeSize>
<ownDataTypeParameters>4 CHAR,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
</columns>
<indexes itemClass="oracle.dbtools.crest.model.design.relational.Index">
<ind_PK_UK id="1A472E81-2792-0BAC-E979-9D581B42BA4F" name="prsn_PK">
<createdBy>ali</createdBy>
<createdTime>2016-04-02 10:44:31 UTC</createdTime>
<generatorID>C4687723-F483-9343-7854-55E6089F61DF</generatorID>
<ownerDesignName>CDM</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<pk>true</pk>
<indexState>Primary Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="86AD98FA-B7FB-0F77-03DA-0F3D70E9BB1C"/>
</indexColumnUsage>
</ind_PK_UK>
</indexes>
</Table>