asdasdad

-- Generated by Oracle SQL Developer Data Modeler 17.3.0.261.1529
--   at:        2017-10-13 10:23:20 EEST
--   site:      Oracle Database 11g
--   type:      Oracle Database 11g



CREATE TABLE author_info (
    author_id       INTEGER NOT NULL,
    author_name     VARCHAR2(30),
    author_adress   VARCHAR2(100),
    authror_url     VARCHAR2(100)
);

ALTER TABLE author_info ADD CONSTRAINT author_info_pk PRIMARY KEY ( author_id );

CREATE TABLE billing (
    client_id                   INTEGER,
    shipping_options            VARCHAR2(100),
    credit_card_info            INTEGER,
    payment_info                VARCHAR2(100),
    shipping_adress             VARCHAR2(100),
    shopping_cart_id            INTEGER,
    clients_client_id           INTEGER NOT NULL,
    purchase_shopping_cart_id   INTEGER NOT NULL
);

CREATE TABLE book (
    book_id                       INTEGER NOT NULL,
    author_id                     INTEGER,
    publisher_id                  INTEGER,
    book_year                     INTEGER,
    price                         NUMBER(2),
    author_info_author_id         INTEGER NOT NULL,
    publisher_info_publisher_id   INTEGER NOT NULL
);

ALTER TABLE book ADD CONSTRAINT book_pk PRIMARY KEY ( book_id );

CREATE TABLE clients (
    client_id       INTEGER NOT NULL,
    clients_email   VARCHAR2(100),
    client_adress   VARCHAR2(100),
    client_phone    INTEGER
);

ALTER TABLE clients ADD CONSTRAINT clients_pk PRIMARY KEY ( client_id );

CREATE TABLE publisher_info (
    publisher_id       INTEGER NOT NULL,
    publisher_name     VARCHAR2(30),
    publisher_adress   VARCHAR2(60),
    publisher_phone    INTEGER,
    publisher_url      VARCHAR2(100)
);

ALTER TABLE publisher_info ADD CONSTRAINT publisher_info_pk PRIMARY KEY ( publisher_id );

CREATE TABLE purchase (
    shopping_cart_id    INTEGER NOT NULL,
    client_id           INTEGER,
    clients_client_id   INTEGER NOT NULL
);

ALTER TABLE purchase ADD CONSTRAINT purchase_pk PRIMARY KEY ( shopping_cart_id );

CREATE TABLE shopping (
    shopping_cart_id            INTEGER,
    book_id                     INTEGER,
    shopping_copies             INTEGER,
    book_book_id                INTEGER NOT NULL,
    purchase_shopping_cart_id   INTEGER NOT NULL
);

CREATE TABLE stocks (
    warehouse_id             INTEGER NOT NULL,
    book_id                  INTEGER,
    copies                   INTEGER,
    book_book_id             INTEGER NOT NULL,
    warehouse_warehouse_id   INTEGER NOT NULL
);

ALTER TABLE stocks ADD CONSTRAINT stocks_pk PRIMARY KEY ( warehouse_id );

CREATE TABLE warehouse (
    warehouse_id       INTEGER NOT NULL,
    warehouse_phone    INTEGER,
    warehouse_adress   VARCHAR2(100)
);

ALTER TABLE warehouse ADD CONSTRAINT warehouse_pk PRIMARY KEY ( warehouse_id );

ALTER TABLE billing
    ADD CONSTRAINT billing_clients_fk FOREIGN KEY ( clients_client_id )
        REFERENCES clients ( client_id );

ALTER TABLE billing
    ADD CONSTRAINT billing_purchase_fk FOREIGN KEY ( purchase_shopping_cart_id )
        REFERENCES purchase ( shopping_cart_id );

ALTER TABLE book
    ADD CONSTRAINT book_author_info_fk FOREIGN KEY ( author_info_author_id )
        REFERENCES author_info ( author_id );

ALTER TABLE book
    ADD CONSTRAINT book_publisher_info_fk FOREIGN KEY ( publisher_info_publisher_id )
        REFERENCES publisher_info ( publisher_id );

ALTER TABLE purchase
    ADD CONSTRAINT purchase_clients_fk FOREIGN KEY ( clients_client_id )
        REFERENCES clients ( client_id );

ALTER TABLE shopping
    ADD CONSTRAINT shopping_book_fk FOREIGN KEY ( book_book_id )
        REFERENCES book ( book_id );

ALTER TABLE shopping
    ADD CONSTRAINT shopping_purchase_fk FOREIGN KEY ( purchase_shopping_cart_id )
        REFERENCES purchase ( shopping_cart_id );

ALTER TABLE stocks
    ADD CONSTRAINT stocks_book_fk FOREIGN KEY ( book_book_id )
        REFERENCES book ( book_id );

ALTER TABLE stocks
    ADD CONSTRAINT stocks_warehouse_fk FOREIGN KEY ( warehouse_warehouse_id )
        REFERENCES warehouse ( warehouse_id );



-- Oracle SQL Developer Data Modeler Summary Report:
--
-- CREATE TABLE                             9
-- CREATE INDEX                             0
-- ALTER TABLE                             16
-- 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 COLLECTION TYPE                   0
-- CREATE STRUCTURED TYPE                   0
-- CREATE STRUCTURED TYPE BODY              0
-- CREATE CLUSTER                           0
-- CREATE CONTEXT                           0
-- CREATE DATABASE                          0
-- CREATE DIMENSION                         0
-- CREATE DIRECTORY                         0
-- CREATE DISK GROUP                        0
-- CREATE ROLE                              0
-- CREATE ROLLBACK SEGMENT                  0
-- CREATE SEQUENCE                          0
-- CREATE MATERIALIZED VIEW                 0
-- CREATE SYNONYM                           0
-- CREATE TABLESPACE                        0
-- CREATE USER                              0
--
-- DROP TABLESPACE                          0
-- DROP DATABASE                            0
--
-- REDACTION POLICY                         0
--
-- ORDS DROP SCHEMA                         0
-- ORDS ENABLE SCHEMA                       0
-- ORDS ENABLE OBJECT                       0
--
-- ERRORS                                   0
-- WARNINGS                                 0