-
Notifications
You must be signed in to change notification settings - Fork 0
Commit
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Merge remote-tracking branch 'origin/master'
- Loading branch information
Showing
64 changed files
with
2,343 additions
and
0 deletions.
There are no files selected for viewing
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,81 @@ | ||
-- Generated by Oracle SQL Developer Data Modeler 22.2.0.165.1149 | ||
-- at: 2022-11-26 16:31:42 CET | ||
-- site: Oracle Database 12cR2 | ||
-- type: Oracle Database 12cR2 | ||
|
||
-- predefined type, no DDL - MDSYS.SDO_GEOMETRY | ||
|
||
-- predefined type, no DDL - XMLTYPE | ||
|
||
CREATE TABLE attribute_types ( | ||
attribute_type_id VARCHAR2(50) | ||
CONSTRAINT nnc_attribute_types_attribute_type_id NOT NULL, | ||
attribute_type_name VARCHAR2(50), | ||
attirbute_type_category VARCHAR2(50) | ||
) | ||
LOGGING; | ||
|
||
ALTER TABLE attribute_types ADD CONSTRAINT attribute_types_pk PRIMARY KEY ( attribute_type_id ); | ||
|
||
CREATE TABLE attributes ( | ||
attribute_type_id VARCHAR2(50) NOT NULL, | ||
device_id VARCHAR2(50) NOT NULL, | ||
attribute_value VARCHAR2(50) | ||
) | ||
LOGGING; | ||
|
||
ALTER TABLE attributes ADD CONSTRAINT attributes_pk PRIMARY KEY ( device_id, | ||
attribute_type_id ); | ||
|
||
CREATE TABLE connections ( | ||
connection_from VARCHAR2(50) NOT NULL, | ||
connection_to VARCHAR2(50) NOT NULL | ||
) | ||
LOGGING; | ||
|
||
CREATE TABLE devices ( | ||
device_id VARCHAR2(50 CHAR) | ||
CONSTRAINT nnc_devices_device_id NOT NULL, | ||
device_name VARCHAR2(50 BYTE) | ||
CONSTRAINT nnc_devices_device_name NOT NULL, | ||
device_category VARCHAR2(50 BYTE), | ||
device_type VARCHAR2(50) | ||
CONSTRAINT nnc_devices_device_type NOT NULL | ||
) | ||
LOGGING; | ||
|
||
COMMENT ON COLUMN devices.device_id IS | ||
'universal device identity '; | ||
|
||
CREATE INDEX devices_id_parent_idx ON | ||
devices ( | ||
device_id | ||
ASC ) | ||
LOGGING; | ||
|
||
CREATE INDEX devices_name_idx ON | ||
devices ( | ||
device_name | ||
ASC ) | ||
LOGGING; | ||
|
||
ALTER TABLE devices ADD CONSTRAINT devices_pk PRIMARY KEY ( device_id ); | ||
|
||
ALTER TABLE attributes | ||
ADD CONSTRAINT attributes_attribute_types_fk FOREIGN KEY ( attribute_type_id ) | ||
REFERENCES attribute_types ( attribute_type_id ) | ||
NOT DEFERRABLE; | ||
|
||
ALTER TABLE attributes | ||
ADD CONSTRAINT attributes_devices_fk FOREIGN KEY ( device_id ) | ||
REFERENCES devices ( device_id ) | ||
NOT DEFERRABLE; | ||
|
||
CREATE TABLE logs ( | ||
id NUMBER NOT NULL, | ||
date DATE NOT NULL, | ||
logtype VARCHAR2(50), | ||
message VARCHAR2(4000) NOT NULL | ||
) | ||
LOGGING; | ||
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,7 @@ | ||
<?xml version = '1.0' encoding = 'UTF-8'?> | ||
<BusinessInfoDesign class="oracle.dbtools.crest.model.businessinfo.BusinessInfoDesign" name="Business Information" id="1A5615DF-9BFF-7B6B-90CD-3FC5F6BAF4AF"> | ||
<createdBy>karol</createdBy> | ||
<createdTime>2022-10-31 23:03:38 UTC</createdTime> | ||
<ownerDesignName>model</ownerDesignName> | ||
<shouldBeOpen>false</shouldBeOpen> | ||
</BusinessInfoDesign> |
10 changes: 10 additions & 0 deletions
10
sql/model/changerequest/7EE77817-B6AF-3157-D23A-006EC7E6A1DB.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,10 @@ | ||
<?xml version = '1.0' encoding = 'UTF-8'?> | ||
<ChangeRequest class="oracle.dbtools.crest.model.ChangeRequest" name="Request_1" id="7EE77817-B6AF-3157-D23A-006EC7E6A1DB"> | ||
<createdBy>karol</createdBy> | ||
<createdTime>2022-11-01 23:38:48 UTC</createdTime> | ||
<ownerDesignName>model</ownerDesignName> | ||
<engineerTo> | ||
<item key="65A71321-1988-4781-04DF-10C5D7C949D0" value="true"/> | ||
</engineerTo> | ||
<status>Proposed</status> | ||
</ChangeRequest> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,15 @@ | ||
<?xml version = '1.0' encoding = 'UTF-8'?> | ||
<DataTypesDesign class="oracle.dbtools.crest.model.design.datatypes.DataTypesDesign" name="DataTypes" id="2008E96F-2076-9AE9-02E0-70D22B3CBD72" mainViewID="F89E8BA5-7268-D044-42DC-4EB30699B932"> | ||
<createdBy>karol</createdBy> | ||
<createdTime>2022-10-31 23:03:38 UTC</createdTime> | ||
<ownerDesignName>model</ownerDesignName> | ||
<shouldBeOpen>false</shouldBeOpen> | ||
<collectionOfRefsPrefix>array_ref_</collectionOfRefsPrefix> | ||
<collectionPrefix>array_</collectionPrefix> | ||
<defaultArrayLimit>10</defaultArrayLimit> | ||
<defaultCollectionType_Kind>ARRAY</defaultCollectionType_Kind> | ||
<defaultCollectionType_Suffix>_Array</defaultCollectionType_Suffix> | ||
<embeddedStructuredTypePrefix>inst_</embeddedStructuredTypePrefix> | ||
<referencePrefix>ref_</referencePrefix> | ||
<useRoleInAssociationEndAsName>true</useRoleInAssociationEndAsName> | ||
</DataTypesDesign> |
10 changes: 10 additions & 0 deletions
10
sql/model/datatypes/structuredtype/seg_0/47E390DE-0671-C4B1-8428-0F45CBEE18F8.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,10 @@ | ||
<?xml version = '1.0' encoding = 'UTF-8'?> | ||
<StructuredType class="oracle.dbtools.crest.model.design.datatypes.StructuredType" name="SDO_GEOMETRY" directorySegmentName="seg_0" id="47E390DE-0671-C4B1-8428-0F45CBEE18F8"> | ||
<createdBy>karol</createdBy> | ||
<createdTime>2022-10-31 23:03:38 UTC</createdTime> | ||
<ownerDesignName>model</ownerDesignName> | ||
<visible>false</visible> | ||
<predefined>true</predefined> | ||
<final>false</final> | ||
<instantiable>true</instantiable> | ||
</StructuredType> |
10 changes: 10 additions & 0 deletions
10
sql/model/datatypes/structuredtype/seg_0/F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,10 @@ | ||
<?xml version = '1.0' encoding = 'UTF-8'?> | ||
<StructuredType class="oracle.dbtools.crest.model.design.datatypes.StructuredType" name="XMLTYPE" directorySegmentName="seg_0" id="F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1"> | ||
<createdBy>karol</createdBy> | ||
<createdTime>2022-10-31 23:03:38 UTC</createdTime> | ||
<ownerDesignName>model</ownerDesignName> | ||
<visible>false</visible> | ||
<predefined>true</predefined> | ||
<final>false</final> | ||
<instantiable>true</instantiable> | ||
</StructuredType> |
26 changes: 26 additions & 0 deletions
26
sql/model/datatypes/subviews/F89E8BA5-7268-D044-42DC-4EB30699B932.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,26 @@ | ||
<?xml version = '1.0' encoding = 'UTF-8'?> | ||
<Diagram class="oracle.dbtools.crest.swingui.datatypes.DPVDataTypes" id="F89E8BA5-7268-D044-42DC-4EB30699B932"> | ||
<createdBy>karol</createdBy> | ||
<modifiedBy>karol</modifiedBy> | ||
<createdTime>2022-10-31 23:03:38 UTC</createdTime> | ||
<autoRoute>false</autoRoute> | ||
<boxInbox>true</boxInbox> | ||
<showLegend>false</showLegend> | ||
<showLabels>true</showLabels> | ||
<showRelAttributes>false</showRelAttributes> | ||
<gridEnabled>false</gridEnabled> | ||
<showGrid>false</showGrid> | ||
<diagramColor>-1</diagramColor> | ||
<display>false</display> | ||
<notation>1</notation> | ||
<objectViews> | ||
<OView class="oracle.dbtools.crest.swingui.datatypes.TVStructuredType" oid="47E390DE-0671-C4B1-8428-0F45CBEE18F8" otype="StructuredType" vid="0DA82646-D273-E78C-1B78-554D14116EF1"> | ||
<hideElementsInCurrentOnly>false</hideElementsInCurrentOnly> | ||
<bounds x="20" y="20" width="100" height="100"/> | ||
</OView> | ||
<OView class="oracle.dbtools.crest.swingui.datatypes.TVStructuredType" oid="F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1" otype="StructuredType" vid="5F070800-0DC4-EFF6-B5C6-1D98A771C151"> | ||
<hideElementsInCurrentOnly>false</hideElementsInCurrentOnly> | ||
<bounds x="20" y="20" width="100" height="100"/> | ||
</OView> | ||
</objectViews> | ||
</Diagram> |
Oops, something went wrong.