ziemniak roman

-- Generated by Oracle SQL Developer Data Modeler 3.1.0.691
--   at:        2019-01-12 17:47:49 CET
--   site:      Oracle Database 11g
--   type:      Oracle Database 11g



CREATE TABLE CUSTOMER
    (
     CUSTOMER_ID NUMBER (6)  NOT NULL ,
     NAME VARCHAR2 (45) ,
     ADDRESS VARCHAR2 (40) ,
     CITY VARCHAR2 (30) ,
     STATE VARCHAR2 (2) ,
     ZIP_CODE VARCHAR2 (9) ,
     AREA_CODE NUMBER (3) ,
     PHONE_NUMBER NUMBER (7) ,
     SALESPERSON_ID NUMBER (4) ,
     CREDIT_LIMIT NUMBER (9,2) ,
     COMMENTS LONG
    )
;



ALTER TABLE CUSTOMER
    ADD CONSTRAINT CUSTOMER_CK0
    CHECK ( CUSTOMER_ID IS NOT NULL)
;


ALTER TABLE CUSTOMER
    ADD CONSTRAINT CUSTOMER_CK1
    CHECK ( STATE = UPPER(STATE))
;


ALTER TABLE CUSTOMER
    ADD CONSTRAINT CUSTOMER_CK1
    CHECK ( LENGTH(NVL(ZIP_CODE, '99999')) IN (5, 9))
;


ALTER TABLE CUSTOMER
    ADD CONSTRAINT CUSTOMER_CK0
    CHECK ( SALESPERSON_ID IS NOT NULL)
;


ALTER TABLE CUSTOMER
    ADD CONSTRAINT CUSTOMER_CK0
    CHECK (CUSTOMER_ID > 0)
;


COMMENT ON TABLE CUSTOMER IS 'Information on all U.S. customers and prospective customers.'
;

COMMENT ON COLUMN CUSTOMER.CUSTOMER_ID IS 'Unique 6 digit number assigned to all customers.  Number generated by the sequence CUSTOMER_ID.'
;

COMMENT ON COLUMN CUSTOMER.NAME IS 'Full store name of every customer (up to 45 characters).  Storing names in all caps is recommended but not required.'
;

COMMENT ON COLUMN CUSTOMER.ADDRESS IS 'Street address of customer.  CITY, STATE, and ZIP_CODE make up the rest of the address.'
;

COMMENT ON COLUMN CUSTOMER.CITY IS 'City name for address of customer.  Storing city names in all caps is recommended, but not required.'
;

COMMENT ON COLUMN CUSTOMER.STATE IS 'Two letter abbreviation for state name for address of customer.  Must be entered in all caps.'
;

COMMENT ON COLUMN CUSTOMER.ZIP_CODE IS 'Zip code of customer.  Supports both 5 and 9 digit zip codes.  Dashes should be omitted from 9 digit zips.'
;

COMMENT ON COLUMN CUSTOMER.AREA_CODE IS 'Area code of phone number for customer.'
;

COMMENT ON COLUMN CUSTOMER.PHONE_NUMBER IS 'Phone number of customer.  This field does not supports letters and spaces for mnemonics (7 numeric digits only).'
;

COMMENT ON COLUMN CUSTOMER.SALESPERSON_ID IS '''Employee number of sales representative handling customer''''s account.  Employee information can be found in the EMPLOYEE table.'''
;

COMMENT ON COLUMN CUSTOMER.CREDIT_LIMIT IS 'Credit limit of customer or prospective customer in U.S. dollars.'
;

COMMENT ON COLUMN CUSTOMER.COMMENTS IS 'Field can be used flexibly.  Suggestions for use include lists of action items or special considerations when dealing with the particular customer.'
;
CREATE UNIQUE INDEX I_CUSTOMER$CUSTOMER_ID ON CUSTOMER
    (
     CUSTOMER_ID ASC
    )
;

ALTER TABLE CUSTOMER
    ADD CONSTRAINT CUSTOMER_PK PRIMARY KEY ( CUSTOMER_ID ) ;


GRANT SELECT
    ON CUSTOMER TO "PUBLIC"
;


CREATE TABLE DEPARTMENT
    (
     DEPARTMENT_ID NUMBER (2)  NOT NULL ,
     NAME VARCHAR2 (14) ,
     LOCATION_ID NUMBER (3)
    )
;



ALTER TABLE DEPARTMENT
    ADD CONSTRAINT DEPARTMENT_CK0
    CHECK ( DEPARTMENT_ID IS NOT NULL)
;


COMMENT ON TABLE DEPARTMENT IS 'Department information for all U.S. operations.'
;

COMMENT ON COLUMN DEPARTMENT.DEPARTMENT_ID IS 'Department number: Unique 2-digit department number assigned to each department.'
;

COMMENT ON COLUMN DEPARTMENT.NAME IS 'Department name: Only the first 14 characters of a department name can be stored in the database.  Storing names in all caps is recommended but not required.'
;

COMMENT ON COLUMN DEPARTMENT.LOCATION_ID IS '''Department location: The code for where the department''''s central office is located.  (LOCATION)'''
;
CREATE UNIQUE INDEX I_DEPARTMENT$DEPARTMENT_ID ON DEPARTMENT
    (
     DEPARTMENT_ID ASC
    )
;

ALTER TABLE DEPARTMENT
    ADD CONSTRAINT DEPARTMENT_PK PRIMARY KEY ( DEPARTMENT_ID ) ;


GRANT SELECT
    ON DEPARTMENT TO "PUBLIC"
;


CREATE TABLE EMPLOYEE
    (
     EMPLOYEE_ID NUMBER (4)  NOT NULL ,
     LAST_NAME VARCHAR2 (15) ,
     FIRST_NAME VARCHAR2 (15) ,
     MIDDLE_INITIAL VARCHAR2 (1) ,
     JOB_ID NUMBER (3) ,
     MANAGER_ID NUMBER (4) ,
     HIRE_DATE DATE ,
     SALARY NUMBER (7,2) ,
     COMMISSION NUMBER (7,2) ,
     DEPARTMENT_ID NUMBER (2)
    )
;



ALTER TABLE EMPLOYEE
    ADD CONSTRAINT EMPLOYEE_CK0
    CHECK ( EMPLOYEE_ID IS NOT NULL)
;


ALTER TABLE EMPLOYEE
    ADD CONSTRAINT EMPLOYEE_CK0
    CHECK ( DEPARTMENT_ID IS NOT NULL)
;


COMMENT ON TABLE EMPLOYEE IS 'General information on all corporate employees.'
;

COMMENT ON COLUMN EMPLOYEE.EMPLOYEE_ID IS 'Employee Number: Unique 4-digit identification number assigned to every employee.'
;

COMMENT ON COLUMN EMPLOYEE.LAST_NAME IS 'Last name of employee.  Stored in all caps.'
;

COMMENT ON COLUMN EMPLOYEE.FIRST_NAME IS 'First name of employee.  Stored in all caps.'
;

COMMENT ON COLUMN EMPLOYEE.MIDDLE_INITIAL IS 'Middle initial (one character only).  Stored in all caps.'
;

COMMENT ON COLUMN EMPLOYEE.JOB_ID IS 'Job identification number.  See JOB for descriptions.'
;

COMMENT ON COLUMN EMPLOYEE.MANAGER_ID IS '''Manager: The employee number of this employee''''s manager.  If employee has no manager, value should be NULL.'''
;

COMMENT ON COLUMN EMPLOYEE.HIRE_DATE IS 'Date the employee was HIRED, not necessarily the day the employee STARTED.'
;

COMMENT ON COLUMN EMPLOYEE.SALARY IS 'Monthly salary for the employee in U.S. dollars.  Salary grade information can be found in the table SALARY_GRADE.'
;

COMMENT ON COLUMN EMPLOYEE.COMMISSION IS 'Commission (in U.S. dollars) earned last month.  This field should be NULL for non-commissioned employees.'
;

COMMENT ON COLUMN EMPLOYEE.DEPARTMENT_ID IS '''Employee''''s department number.  Further department information is available in the table DEPT.'''
;
CREATE UNIQUE INDEX I_EMPLOYEE$EMPLOYEE_ID ON EMPLOYEE
    (
     EMPLOYEE_ID ASC
    )
;

ALTER TABLE EMPLOYEE
    ADD CONSTRAINT EMPLOYEE_PK PRIMARY KEY ( EMPLOYEE_ID ) ;


GRANT SELECT
    ON EMPLOYEE TO "PUBLIC"
;


CREATE TABLE ITEM
    (
     ORDER_ID NUMBER (4)  NOT NULL ,
     ITEM_ID NUMBER (4)  NOT NULL ,
     PRODUCT_ID NUMBER (6) ,
     ACTUAL_PRICE NUMBER (8,2) ,
     QUANTITY NUMBER (8) ,
     TOTAL NUMBER (8,2) ,
     ID_PRODUCYT NUMBER (6) ,
     ID_MATERIALS NUMBER (6)
    )
;



ALTER TABLE ITEM
    ADD CONSTRAINT ITEM_CK0
    CHECK ( ORDER_ID IS NOT NULL)
;


ALTER TABLE ITEM
    ADD CONSTRAINT ITEM_CK0
    CHECK ( ITEM_ID IS NOT NULL)
;


COMMENT ON TABLE ITEM IS 'Items listed in sales orders.  Product information can be found in table PRODUCT.  Sales order information can be found in table SALES_ORDER.'
;

COMMENT ON COLUMN ITEM.ORDER_ID IS 'Sales order in which this item appears.  Sales order information can be found in table SALES_ORDER.'
;

COMMENT ON COLUMN ITEM.ITEM_ID IS 'Number of item within the sales order.'
;

COMMENT ON COLUMN ITEM.PRODUCT_ID IS 'Number of product (described in PRODUCT) that pertains to the line item.'
;

COMMENT ON COLUMN ITEM.ACTUAL_PRICE IS 'Price to be paid by the customer in U.S. dollars.  The standard price is PRICE.STANDARD_PRICE, but in some instances, discounts are given to as low as PRICE.MINIMUM_PRICE.'
;

COMMENT ON COLUMN ITEM.QUANTITY IS 'The amount of product to be ordered in this line item.'
;

COMMENT ON COLUMN ITEM.TOTAL IS 'The total price (in U.S. dollars) of this line item.  TOTAL = ACTUAL_PRICE * QUANTITY.'
;
CREATE UNIQUE INDEX I_ITEM ON ITEM
    (
     ORDER_ID ASC ,
     ITEM_ID ASC
    )
;

ALTER TABLE ITEM
    ADD CONSTRAINT ITEM_PK PRIMARY KEY ( ORDER_ID, ITEM_ID ) ;


GRANT SELECT
    ON ITEM TO "PUBLIC"
;


CREATE TABLE JOB
    (
     JOB_ID NUMBER (3)  NOT NULL ,
     FUNCTION VARCHAR2 (30)
    )
;



ALTER TABLE JOB
    ADD CONSTRAINT JOB_CK0
    CHECK ( JOB_ID IS NOT NULL)
;


ALTER TABLE JOB
    ADD CONSTRAINT JOB_CK0
    CHECK ( FUNCTION IS NOT NULL)
;


COMMENT ON TABLE JOB IS 'All valid job categories for personnel information.'
;

COMMENT ON COLUMN JOB.JOB_ID IS 'Unique 3-digit code for job function and title.'
;

COMMENT ON COLUMN JOB.FUNCTION IS 'Generic function class of job.'
;
CREATE UNIQUE INDEX I_JOB$JOB_ID ON JOB
    (
     JOB_ID ASC
    )
;

ALTER TABLE JOB
    ADD CONSTRAINT JOB_PK PRIMARY KEY ( JOB_ID ) ;


GRANT SELECT
    ON JOB TO "PUBLIC"
;


CREATE TABLE LOCATION
    (
     LOCATION_ID NUMBER (3)  NOT NULL ,
     REGIONAL_GROUP VARCHAR2 (20)
    )
;



ALTER TABLE LOCATION
    ADD CONSTRAINT LOCATION_CK0
    CHECK ( LOCATION_ID IS NOT NULL)
;


COMMENT ON TABLE LOCATION IS 'Location information for all U.S. departments and warehouses.'
;

COMMENT ON COLUMN LOCATION.LOCATION_ID IS 'Central location corporate location code.'
;

COMMENT ON COLUMN LOCATION.REGIONAL_GROUP IS 'Metropolitan center closest to location.'
;
CREATE UNIQUE INDEX I_LOCATION$LOCATION_ID ON LOCATION
    (
     LOCATION_ID ASC
    )
;

ALTER TABLE LOCATION
    ADD CONSTRAINT LOCATION_PK PRIMARY KEY ( LOCATION_ID ) ;


GRANT SELECT
    ON LOCATION TO "PUBLIC"
;


CREATE TABLE MATERIALS
    (
     ID_MATERIALS NUMBER (6)  NOT NULL ,
     NAME VARCHAR2 (45) ,
     DESCRIPTION VARCHAR2 (45) ,
     ID_PRODUCYT NUMBER (6)  NOT NULL ,
     ID_MATERIALS1 NUMBER (6)  NOT NULL
    ) LOGGING
;



ALTER TABLE MATERIALS
    ADD CONSTRAINT "ID_MATERIALS PK" PRIMARY KEY ( ID_MATERIALS ) ;


CREATE TABLE MAT_PROD
    (
     ID_MATERIALS NUMBER (6)  NOT NULL ,
     ID_PRODUCYT NUMBER (6)  NOT NULL ,
     AMOUNT NUMBER (7,2) ,
     ID_MATERIALS1 NUMBER (6)  NOT NULL
    ) LOGGING
;



ALTER TABLE MAT_PROD
    ADD CONSTRAINT "MAT_PROD PK" PRIMARY KEY ( ID_PRODUCYT, ID_MATERIALS ) ;


CREATE TABLE PRICE
    (
     PRODUCT_ID NUMBER (6)  NOT NULL ,
     LIST_PRICE NUMBER (8,2) ,
     MIN_PRICE NUMBER (8,2) ,
     START_DATE DATE  NOT NULL ,
     END_DATE DATE ,
     ID_PRODUCYT NUMBER (6)  NOT NULL ,
     ID_MATERIALS NUMBER (6)  NOT NULL
    )
;



ALTER TABLE PRICE
    ADD CONSTRAINT PRICE_CK0
    CHECK ( PRODUCT_ID IS NOT NULL)
;


ALTER TABLE PRICE
    ADD CONSTRAINT PRICE_CK0
    CHECK ( START_DATE IS NOT NULL)
;


ALTER TABLE PRICE
    ADD CONSTRAINT PRICE_CK0
    CHECK (LIST_PRICE IS NULL OR MIN_PRICE IS NULL OR MIN_PRICE <= LIST_PRICE)
;


ALTER TABLE PRICE
    ADD CONSTRAINT PRICE_CK1
    CHECK (END_DATE IS NULL OR START_DATE <= END_DATE)
;


COMMENT ON TABLE PRICE IS 'Prices (both standard and minimum) of products.  Database tracks both effective dates and expiration dates for prices.'
;

COMMENT ON COLUMN PRICE.PRODUCT_ID IS 'Product number to which price applies.  Product name found in table PRICE.'
;

COMMENT ON COLUMN PRICE.LIST_PRICE IS 'Undiscounted price (in U.S. dollars).'
;

COMMENT ON COLUMN PRICE.MIN_PRICE IS 'Lowest price (in U.S. dollars) that can be offered.'
;

COMMENT ON COLUMN PRICE.START_DATE IS 'Date which standard and minimum prices go into effect.'
;

COMMENT ON COLUMN PRICE.END_DATE IS 'Date which standard and minimum price expire.  This value can be left NULL.'
;
CREATE UNIQUE INDEX I_PRICE ON PRICE
    (
     PRODUCT_ID ASC ,
     START_DATE ASC
    )
;

ALTER TABLE PRICE
    ADD CONSTRAINT PRICE_PK PRIMARY KEY ( PRODUCT_ID, ID_PRODUCYT, ID_MATERIALS, START_DATE ) ;


GRANT SELECT
    ON PRICE TO "PUBLIC"
;


CREATE TABLE PRODUCT
    (
     PRODUCT_ID NUMBER (6)  NOT NULL ,
     DESCRIPTION VARCHAR2 (30) ,
     ID_PRODUCYT NUMBER (6)  NOT NULL ,
     ID_MATERIALS NUMBER (6)  NOT NULL
    )
;



ALTER TABLE PRODUCT
    ADD CONSTRAINT PRODUCT_CK0
    CHECK ( PRODUCT_ID IS NOT NULL)
;


COMMENT ON TABLE PRODUCT IS 'Products in catalog.  Pricing information can be found in table PRICE.'
;

COMMENT ON COLUMN PRODUCT.PRODUCT_ID IS 'Unique 6 digit number assigned to all products.  Number generated by sequence PRODUCT_ID.'
;

COMMENT ON COLUMN PRODUCT.DESCRIPTION IS 'Full product name (up to 30 characters).  Storing product names in all caps is recommended but not required.'
;
CREATE UNIQUE INDEX I_PRODUCT$PRODUCT_ID ON PRODUCT
    (
     PRODUCT_ID ASC
    )
;

ALTER TABLE PRODUCT
    ADD CONSTRAINT PRODUCT_PK PRIMARY KEY ( PRODUCT_ID, ID_PRODUCYT, ID_MATERIALS ) ;


GRANT SELECT
    ON PRODUCT TO "PUBLIC"
;


CREATE TABLE SALARY_GRADE
    (
     GRADE_ID NUMBER (3)  NOT NULL ,
     LOWER_BOUND NUMBER (7,2) ,
     UPPER_BOUND NUMBER (7,2)
    )
;



ALTER TABLE SALARY_GRADE
    ADD CONSTRAINT SALARY_GRADE_CK0
    CHECK ( GRADE_ID IS NOT NULL)
;


ALTER TABLE SALARY_GRADE
    ADD CONSTRAINT SALARY_GRADE_CK0
    CHECK ((LOWER_BOUND IS NULL AND UPPER_BOUND IS NOT NULL) OR (LOWER_BOUND IS NOT NULL AND UPPER_BOUND IS NULL) OR (LOWER_BOUND <= UPPER_BOUND))
;


COMMENT ON TABLE SALARY_GRADE IS 'Salary grade levels.  Used to classify monthly salary information in U.S. dollars, as found in EMP.SAL.'
;

COMMENT ON COLUMN SALARY_GRADE.GRADE_ID IS 'Number used to grade salaries.  Higher salary grade numbers denote higher salaries.'
;

COMMENT ON COLUMN SALARY_GRADE.LOWER_BOUND IS 'The lowest monthly salary (rounded to the nearest U.S. dollar) that applies to a particular salary grade. (i.e. the condition ROUND(EMP.SAL) >= LOWER_BOUND must be met.)'
;

COMMENT ON COLUMN SALARY_GRADE.UPPER_BOUND IS 'The highest monthly salary (rounded to the nearest U.S. dollar) that applies to a particular salary grade. (i.e. the condition ROUND(EMP.SAL) <= UPPER_BOUND must be met.)'
;
CREATE UNIQUE INDEX I_SALARY_GRADE$GRADE_ID ON SALARY_GRADE
    (
     GRADE_ID ASC
    )
;

ALTER TABLE SALARY_GRADE
    ADD CONSTRAINT SALARY_GRADE_PK PRIMARY KEY ( GRADE_ID ) ;


GRANT SELECT
    ON SALARY_GRADE TO "PUBLIC"
;


CREATE TABLE SALES_ORDER
    (
     ORDER_ID NUMBER (4)  NOT NULL ,
     ORDER_DATE DATE ,
     CUSTOMER_ID NUMBER (6) ,
     SHIP_DATE DATE ,
     TOTAL NUMBER (8,2)
    )
;



ALTER TABLE SALES_ORDER
    ADD CONSTRAINT SALES_ORDER_CK0
    CHECK ( ORDER_ID IS NOT NULL)
;


ALTER TABLE SALES_ORDER
    ADD CONSTRAINT SALES_ORDER_CK0
    CHECK ( CUSTOMER_ID IS NOT NULL)
;


ALTER TABLE SALES_ORDER
    ADD CONSTRAINT SALES_ORDER_CK0
    CHECK ( TOTAL >= 0)
;


COMMENT ON TABLE SALES_ORDER IS 'Sales order for a customer.  Items in the order can be found in the table ITEM.'
;

COMMENT ON COLUMN SALES_ORDER.ORDER_ID IS 'Unique 4 digit number assigned to all orders.  Number generated by sequence ORDER_ID.'
;

COMMENT ON COLUMN SALES_ORDER.ORDER_DATE IS 'Date sales order logged (not necessarily when order was fulfilled.)'
;

COMMENT ON COLUMN SALES_ORDER.CUSTOMER_ID IS 'Customer ordering the goods.  Further information can be found in the table CUSTOMER.'
;

COMMENT ON COLUMN SALES_ORDER.SHIP_DATE IS 'Date order fulfilled and invoice sent (not necessarily date payment received).'
;

COMMENT ON COLUMN SALES_ORDER.TOTAL IS 'Total of all items totals in the order.  (i.e. the value of TOTAL for order N should contain: SELECT SUM(TOTAL) FROM ITEM WHERE ORDER_ID=N)'
;
CREATE UNIQUE INDEX I_SALES_ORDER$ORDER_ID ON SALES_ORDER
    (
     ORDER_ID ASC
    )
;

ALTER TABLE SALES_ORDER
    ADD CONSTRAINT SALES_ORDER_PK PRIMARY KEY ( ORDER_ID ) ;


GRANT SELECT
    ON SALES_ORDER TO "PUBLIC"
;



ALTER TABLE CUSTOMER
    ADD CONSTRAINT CUSTOMER_FK0 FOREIGN KEY
    (
     SALESPERSON_ID
    )
    REFERENCES EMPLOYEE
    (
     EMPLOYEE_ID
    )
    ON DELETE SET NULL
    NOT DEFERRABLE
;


ALTER TABLE DEPARTMENT
    ADD CONSTRAINT DEPARTMENT_FK0 FOREIGN KEY
    (
     LOCATION_ID
    )
    REFERENCES LOCATION
    (
     LOCATION_ID
    )
    ON DELETE SET NULL
    NOT DEFERRABLE
;


ALTER TABLE EMPLOYEE
    ADD CONSTRAINT EMPLOYEE_FK0 FOREIGN KEY
    (
     JOB_ID
    )
    REFERENCES JOB
    (
     JOB_ID
    )
    ON DELETE SET NULL
    NOT DEFERRABLE
;


-- Error - Foreign Key EMPLOYEE_FK1 has no columns

ALTER TABLE EMPLOYEE
    ADD CONSTRAINT EMPLOYEE_FK2 FOREIGN KEY
    (
     DEPARTMENT_ID
    )
    REFERENCES DEPARTMENT
    (
     DEPARTMENT_ID
    )
    ON DELETE SET NULL
    NOT DEFERRABLE
;


ALTER TABLE ITEM
    ADD CONSTRAINT ITEM_FK0 FOREIGN KEY
    (
     ORDER_ID
    )
    REFERENCES SALES_ORDER
    (
     ORDER_ID
    )
    NOT DEFERRABLE
;


ALTER TABLE ITEM
    ADD CONSTRAINT ITEM_FK1 FOREIGN KEY
    (
     PRODUCT_ID,
     ID_PRODUCYT,
     ID_MATERIALS
    )
    REFERENCES PRODUCT
    (
     PRODUCT_ID,
     ID_PRODUCYT,
     ID_MATERIALS
    )
    ON DELETE SET NULL
    NOT DEFERRABLE
;


ALTER TABLE PRICE
    ADD CONSTRAINT PRICE_FK0 FOREIGN KEY
    (
     PRODUCT_ID,
     ID_PRODUCYT,
     ID_MATERIALS
    )
    REFERENCES PRODUCT
    (
     PRODUCT_ID,
     ID_PRODUCYT,
     ID_MATERIALS
    )
    NOT DEFERRABLE
;


ALTER TABLE PRODUCT
    ADD CONSTRAINT Relation_10 FOREIGN KEY
    (
     ID_PRODUCYT,
     ID_MATERIALS
    )
    REFERENCES MAT_PROD
    (
     ID_PRODUCYT,
     ID_MATERIALS
    )
    NOT DEFERRABLE
;


ALTER TABLE MATERIALS
    ADD CONSTRAINT Relation_13 FOREIGN KEY
    (
     ID_PRODUCYT,
     ID_MATERIALS1
    )
    REFERENCES MAT_PROD
    (
     ID_PRODUCYT,
     ID_MATERIALS
    )
    NOT DEFERRABLE
;


ALTER TABLE SALES_ORDER
    ADD CONSTRAINT SALES_ORDER_FK0 FOREIGN KEY
    (
     CUSTOMER_ID
    )
    REFERENCES CUSTOMER
    (
     CUSTOMER_ID
    )
    ON DELETE SET NULL
    NOT DEFERRABLE
;

--  ERROR: Invalid View SALES
















-- Oracle SQL Developer Data Modeler Summary Report:
--
-- CREATE TABLE                            12
-- CREATE INDEX                            10
-- ALTER TABLE                             45
-- CREATE VIEW                              0
-- CREATE PACKAGE                           0
-- CREATE PACKAGE BODY                      0
-- CREATE PROCEDURE                         0
-- CREATE FUNCTION                          0
-- CREATE TRIGGER                           0
-- ALTER TRIGGER                            0
-- CREATE STRUCTURED TYPE                   0
-- CREATE COLLECTION TYPE                   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
--
-- ERRORS                                   2
-- WARNINGS                                 0