Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r7f87fad7bfc9af859c24f15a04ac2b8e1a6d43d9 -r0ff93a746c6441fbc64c0507914d0db00fea9623 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 7f87fad7bfc9af859c24f15a04ac2b8e1a6d43d9) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 0ff93a746c6441fbc64c0507914d0db00fea9623) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 01-Nov-2016 10:01:47 AM */ +/* Created On : 01-Nov-2016 11:06:06 AM */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -183,6 +183,9 @@ DROP TABLE IF EXISTS 'StabilityPointStructureEntity' ; +DROP TABLE IF EXISTS 'StabilityPointStructuresOutputEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -1185,6 +1188,20 @@ ) ; +CREATE TABLE 'StabilityPointStructuresOutputEntity' +( + 'StabilityPointStructuresOutputEntity' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'Probability' REAL, + 'Reliability' REAL, + 'FactorOfSafety' REAL, + CONSTRAINT 'FK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity' FOREIGN KEY ('StabilityPointStructuresCalculationEntityId') REFERENCES 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructuresCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_StabilityPointStructuresCalculationEntity' UNIQUE ('StabilityPointStructuresCalculationEntityId') +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity' @@ -1506,3 +1523,7 @@ CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity' ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC) ; + +CREATE INDEX 'IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity' + ON 'StabilityPointStructuresOutputEntity' ('StabilityPointStructuresCalculationEntityId' ASC) +;