sql.txt

-- Generated by Oracle SQL Developer Data Modeler 3.1.0.691
--   at:        2018-04-17 18:13:34 CEST
--   site:      SQL Server 2005
--   type:      SQL Server 2005






CREATE TABLE Comments 
    (
     Comment_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Comment_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Subscriber_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Publication_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     CONSTRAINT "Comments PK" PRIMARY KEY CLUSTERED (Comment_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    



CREATE TABLE Information_Database 
    (
     Information_Content_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Information_Content_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Information_Updates_Information_Update_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     CONSTRAINT Information_Database_PK PRIMARY KEY CLUSTERED (Information_Content_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    



CREATE TABLE Information_Sources 
    (
     Information_Source_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Information_Source_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     CONSTRAINT Information_Sources_PK PRIMARY KEY CLUSTERED (Information_Source_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    



CREATE TABLE Information_Updates 
    (
     Information_Update_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Information_Update_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Information_Sources_Information_Source_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     CONSTRAINT Information_Updates_PK PRIMARY KEY CLUSTERED (Information_Update_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    



CREATE TABLE Publications 
    (
     Publication_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Publication_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Information_Database_Information_Content_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     CONSTRAINT Publications_PK PRIMARY KEY CLUSTERED (Publication_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    



CREATE TABLE Rate 
    (
     Rate_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Rate_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Subscriber_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Publication_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     CONSTRAINT "Rate PK" PRIMARY KEY CLUSTERED (Rate_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    



CREATE TABLE Subscribers 
    (
     Subscriber_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Subscriber_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     CONSTRAINT Subscribers_PK PRIMARY KEY CLUSTERED (Subscriber_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    



CREATE TABLE Subscriptions 
    (
     Subscription_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    NOT NULL , 
     Start_Date UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     End_Date UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Other_Details UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Publications_Publication_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     Subscribers_Subscriber_ID UNKNOWN 
--  ERROR: Datatype UNKNOWN is not allowed 
                    , 
     CONSTRAINT Subscriptions_PK PRIMARY KEY CLUSTERED (Subscription_ID)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
     ON "default" 
    )
    ON "default"
GO 

    


ALTER TABLE Information_Database 
    ADD CONSTRAINT Information_Database_Information_Updates_FK FOREIGN KEY 
    ( 
     Information_Updates_Information_Update_ID
    ) 
    REFERENCES Information_Updates 
    ( 
     Information_Update_ID 
    ) 
GO 



ALTER TABLE Information_Updates 
    ADD CONSTRAINT Information_Updates_Information_Sources_FK FOREIGN KEY 
    ( 
     Information_Sources_Information_Source_ID
    ) 
    REFERENCES Information_Sources 
    ( 
     Information_Source_ID 
    ) 
GO 



ALTER TABLE Publications 
    ADD CONSTRAINT Publications_Information_Database_FK FOREIGN KEY 
    ( 
     Information_Database_Information_Content_ID
    ) 
    REFERENCES Information_Database 
    ( 
     Information_Content_ID 
    ) 
GO 



ALTER TABLE Comments 
    ADD CONSTRAINT Relation_6 FOREIGN KEY 
    ( 
     Subscriber_ID
    ) 
    REFERENCES Subscribers 
    ( 
     Subscriber_ID 
    ) 
GO 



ALTER TABLE Rate 
    ADD CONSTRAINT Relation_7 FOREIGN KEY 
    ( 
     Subscriber_ID
    ) 
    REFERENCES Subscribers 
    ( 
     Subscriber_ID 
    ) 
GO 



ALTER TABLE Rate 
    ADD CONSTRAINT Relation_8 FOREIGN KEY 
    ( 
     Publication_ID
    ) 
    REFERENCES Publications 
    ( 
     Publication_ID 
    ) 
GO 



ALTER TABLE Comments 
    ADD CONSTRAINT Relation_9 FOREIGN KEY 
    ( 
     Publication_ID
    ) 
    REFERENCES Publications 
    ( 
     Publication_ID 
    ) 
GO 



ALTER TABLE Subscriptions 
    ADD CONSTRAINT Subscriptions_Publications_FK FOREIGN KEY 
    ( 
     Publications_Publication_ID
    ) 
    REFERENCES Publications 
    ( 
     Publication_ID 
    ) 
GO 



ALTER TABLE Subscriptions 
    ADD CONSTRAINT Subscriptions_Subscribers_FK FOREIGN KEY 
    ( 
     Subscribers_Subscriber_ID
    ) 
    REFERENCES Subscribers 
    ( 
     Subscriber_ID 
    ) 
GO 











-- Oracle SQL Developer Data Modeler Summary Report: 
-- 
-- CREATE TABLE                             8
-- CREATE INDEX                             0
-- ALTER TABLE                              9
-- CREATE 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 PARTITION FUNCTION                0
-- CREATE PARTITION SCHEME                  0
-- 
-- DROP DATABASE                            0
-- 
-- ERRORS                                  27
-- WARNINGS                                 0