-- Generated by Oracle SQL Developer Data Modeler 17.2.0.188.1059
--   at:        2018-01-18 09:09:46 CET
--   site:      SQL Server 2012
--   type:      SQL Server 2012



CREATE TABLE Auto
    (
     Vozidlo_Vozidlo_ID NUMERIC (28) NOT NULL ,
     Ridic_Ridic_ID NUMERIC (28) NOT NULL
    )
    ON "default"
GO

ALTER TABLE Auto ADD CONSTRAINT Auto_PK PRIMARY KEY CLUSTERED (Vozidlo_Vozidlo_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON ,
     ALLOW_ROW_LOCKS = ON )
     ON "default"
    GO

CREATE TABLE Motorka
    (
     Vozidlo_Vozidlo_ID NUMERIC (28) NOT NULL ,
     Ridic_Ridic_ID NUMERIC (28) NOT NULL
    )
    ON "default"
GO

ALTER TABLE Motorka ADD CONSTRAINT Motorka_PK PRIMARY KEY CLUSTERED (Vozidlo_Vozidlo_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON ,
     ALLOW_ROW_LOCKS = ON )
     ON "default"
    GO

-- Error while generating DDL for Ridic. See log file for details.

ALTER TABLE Ridic ADD CONSTRAINT Ridic_PK PRIMARY KEY CLUSTERED (Ridic_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON ,
     ALLOW_ROW_LOCKS = ON )
     ON "default"
    GO

-- Error while generating DDL for Vozidlo. See log file for details.

ALTER TABLE Vozidlo ADD CONSTRAINT Vozidlo_PK PRIMARY KEY CLUSTERED (Vozidlo_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON ,
     ALLOW_ROW_LOCKS = ON )
     ON "default"
    GO

ALTER TABLE Auto
    ADD CONSTRAINT Auto_Ridic_FK FOREIGN KEY
    (
     Ridic_Ridic_ID
    )
    REFERENCES Ridic
    (
     Ridic_ID
    )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
GO

ALTER TABLE Auto
    ADD CONSTRAINT Auto_Vozidlo_FK FOREIGN KEY
    (
     Vozidlo_Vozidlo_ID
    )
    REFERENCES Vozidlo
    (
     Vozidlo_ID
    )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
GO

ALTER TABLE Motorka
    ADD CONSTRAINT Motorka_Ridic_FK FOREIGN KEY
    (
     Ridic_Ridic_ID
    )
    REFERENCES Ridic
    (
     Ridic_ID
    )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
GO

ALTER TABLE Motorka
    ADD CONSTRAINT Motorka_Vozidlo_FK FOREIGN KEY
    (
     Vozidlo_Vozidlo_ID
    )
    REFERENCES Vozidlo
    (
     Vozidlo_ID
    )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
GO



-- Oracle SQL Developer Data Modeler Summary Report:
--
-- CREATE TABLE                             2
-- CREATE INDEX                             0
-- ALTER TABLE                              8
-- CREATE VIEW                              0
-- ALTER VIEW                               0
-- CREATE PACKAGE                           0
-- CREATE PACKAGE BODY                      0
-- CREATE PROCEDURE                         0
-- CREATE FUNCTION                          0
-- CREATE TRIGGER                           0
-- ALTER TRIGGER                            0
-- CREATE DATABASE                          0
-- CREATE DEFAULT                           0
-- CREATE INDEX ON VIEW                     0
-- CREATE ROLLBACK SEGMENT                  0
-- CREATE ROLE                              0
-- CREATE RULE                              0
-- CREATE SCHEMA                            0
-- CREATE SEQUENCE                          0
-- CREATE PARTITION FUNCTION                0
-- CREATE PARTITION SCHEME                  0
--
-- DROP DATABASE                            0
--
-- ERRORS                                   2
-- WARNINGS                                 0