Table description:

TABLE s_customer
(id                         NUMBER(5) PRIMARY KEY,
 name                       VARCHAR2(30) NOT NULL,
 phone                      VARCHAR2(15),
 address                    VARCHAR2(200),
 city                       VARCHAR2(20),
 state                      VARCHAR2(20),
 country                    VARCHAR2(25),
 zip_code                   VARCHAR2(10),
 credit_rating              VARCHAR2(9),
 sales_rep_id               NUMBER(7),
 region_id                  NUMBER(7),
 comments                   VARCHAR2(255),
        CHECK (credit_rating IN ('EXCELLENT', 'GOOD', 'POOR'))
);

TABLE s_dept
(id                         NUMBER(7) PRIMARY KEY,
 name                       VARCHAR2(15) NOT NULL,
 region_id                  NUMBER(7),
     CONSTRAINT s_dept_name_region_id_uk UNIQUE (name, region_id)
);


TABLE s_emp
(id                         NUMBER(7) PRIMARY KEY,
 last_name                  VARCHAR2(15) NOT NULL,
 first_name                 VARCHAR2(15),
 userid                     VARCHAR2(8),
 start_date                 DATE,
 comments                   VARCHAR2(255),
 manager_id                 NUMBER(7),
 title                      VARCHAR2(25),
 dept_id                    NUMBER(7),
 salary                     NUMBER(11, 2),
 commission_pct             NUMBER(4, 2),
     UNIQUE (userid),
     CHECK (commission_pct IN (10, 12.5, 15, 17.5, 20))
);

TABLE s_inventory
(product_id                 NUMBER(7) NOT NULL,
 warehouse_id               NUMBER(7) NOT NULL,
 amount_in_stock            NUMBER(9),
 reorder_point              NUMBER(9),
 max_in_stock               NUMBER(9),
 out_of_stock_explanation   VARCHAR2(255),
 restock_date               DATE,
     PRIMARY KEY (product_id, warehouse_id)
);

TABLE s_item
(ord_id                     NUMBER(7) NOT NULL,
 item_id                    NUMBER(7) NOT NULL,
 product_id                 NUMBER(7) NOT NULL,
 price                      NUMBER(11, 2),
 quantity                   NUMBER(9),
 quantity_shipped           NUMBER(9),
     PRIMARY KEY (ord_id, item_id),
     UNIQUE (ord_id, product_id)
);

TABLE s_ord
(id                         NUMBER(7) PRIMARY KEY,
 customer_id                NUMBER(7) NOT NULL,
 date_ordered               DATE,
 date_shipped               DATE,
 total                      NUMBER(11, 2),
 payment_type               VARCHAR2(6),
 order_filled               VARCHAR2(1),
        CHECK (payment_type in ('CASH', 'CREDIT')),
        CHECK (order_filled in ('Y', 'N'))
);

TABLE s_product
(id                         NUMBER(7) PRIMARY KEY,
 name                       VARCHAR2(50) NOT NULL,
 short_desc                 VARCHAR2(255),
 suggested_whlsl_price      NUMBER(11, 2),
 whlsl_units                VARCHAR2(25),
     UNIQUE (name)
);

TABLE s_region
(id                         NUMBER(7) PRIMARY KEY,
 name                       VARCHAR2(50) NOT NULL,
     UNIQUE (name)
);

TABLE s_title
(title                      VARCHAR2(25) PRIMARY KEY
);

TABLE s_warehouse
(id                         NUMBER(7) PRIMARY KEY,
 region_id                  NUMBER(7) NOT NULL,
 address                    VARCHAR2(30),
 city                       VARCHAR2(30),
 state                      VARCHAR2(20),
 country                    VARCHAR2(30),
 zip_code                   VARCHAR2(15),
 phone                      VARCHAR2(25),
 manager_id                 NUMBER(7)
);


Foreign Key constraints:

TABLE s_dept
   FOREIGN KEY (region_id) REFERENCES s_region (id);

TABLE s_emp
   FOREIGN KEY (manager_id) REFERENCES s_emp (id);
TABLE s_emp
   FOREIGN KEY (dept_id) REFERENCES s_dept (id);
TABLE s_emp
   FOREIGN KEY (title) REFERENCES s_title (title);

TABLE s_customer
   FOREIGN KEY (sales_rep_id) REFERENCES s_emp (id);
TABLE s_customer
   FOREIGN KEY (region_id) REFERENCES s_region (id);

TABLE s_ord
   FOREIGN KEY (customer_id) REFERENCES s_customer (id);

TABLE s_item
   FOREIGN KEY (ord_id) REFERENCES s_ord (id);
TABLE s_item
   FOREIGN KEY (product_id) REFERENCES s_product (id);

TABLE s_warehouse
   FOREIGN KEY (manager_id) REFERENCES s_emp (id);
TABLE s_warehouse
   FOREIGN KEY (region_id) REFERENCES s_region (id);

TABLE s_inventory
   FOREIGN KEY (product_id) REFERENCES s_product (id);
TABLE s_inventory
   FOREIGN KEY (warehouse_id) REFERENCES s_warehouse (id);