Bernd-L/exDateMan

View on GitHub
draft/ERD/edm_erd/rel/0F7C9347-04E5BA347187/table/seg_0/0603AC3B-A1CC-5288-683F-2F67B3A3B709.xml

Summary

Maintainability
Test Coverage
<?xml version = '1.0' encoding = 'UTF-8'?>
<Table class="oracle.dbtools.crest.model.design.relational.Table" directorySegmentName="seg_0" id="0603AC3B-A1CC-5288-683F-2F67B3A3B709" name="ThingCategory">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:35:58 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<ordsAlias>table_8</ordsAlias>
<allowColumnReorder>false</allowColumnReorder>
<existDependencyGenerateInDDl>true</existDependencyGenerateInDDl>
<parsed>true</parsed>
<columns itemClass="oracle.dbtools.crest.model.design.relational.Column">
<Column name="id" id="674CCC1A-4306-A9B8-85DD-87F99CB587B5">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:36:20 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="position" id="A9836834-7654-81A8-89FA-4D4496C669B3">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:36:50 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="Category_id" id="BD4D286C-E415-370E-339B-7C1370E14E96">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:37:11 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<previousColumn>false</previousColumn>
<autoIncrementCycle>false</autoIncrementCycle>
<associations>
<colAssociation fkAssociation="BFCE49EF-179C-AEFC-E73C-3F99BC5A6B4B" referredColumn="0283E073-0AF5-DF93-B36C-05351BC755BE"/>
</associations>
</Column>
<Column name="Thing_id" id="76CBBD20-0175-4A0E-AE0F-B6A7AB60BD99">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:37:19 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<previousColumn>false</previousColumn>
<autoIncrementCycle>false</autoIncrementCycle>
<associations>
<colAssociation fkAssociation="4AAFCE55-A150-9F83-5C27-B3F2F2729D20" referredColumn="0C1FDAE0-BEF8-6F55-AF21-716F6C76C6DA"/>
</associations>
</Column>
</columns>
<indexes itemClass="oracle.dbtools.crest.model.design.relational.Index">
<ind_PK_UK id="A9570994-BD83-00AC-1848-99492EA3BB7B" name="ThingCategory_PK">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:36:20 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<pk>true</pk>
<indexState>Primary Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="674CCC1A-4306-A9B8-85DD-87F99CB587B5"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="D6EA02BD-8F5A-3008-934C-C09767015B4F" name="ThingCategory_Category_FK">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:37:11 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<indexState>Foreign Key</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="BD4D286C-E415-370E-339B-7C1370E14E96"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="EC658567-1C70-A8B2-B525-F9335FEC22D4" name="ThingCategory_Thing_FK">
<createdBy>bernd</createdBy>
<createdTime>2019-08-10 19:37:19 UTC</createdTime>
<ownerDesignName>edm_erd</ownerDesignName>
<indexState>Foreign Key</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="76CBBD20-0175-4A0E-AE0F-B6A7AB60BD99"/>
</indexColumnUsage>
</ind_PK_UK>
</indexes>
</Table>