Table CUSTOMER_TBL created.


Table COMMERCIAL_TBL created.

Table ORDER_TBL created.


Table PAYMENT_TBL created.


Table PAY_LINK_TBL created.

Table PRODUCT_TBL created.


Table PRODUCT_CATEGORY_TBL created.


Error starting at line : 70 in command -
CREATE TABLE product_category_link_tbl
(

category_id                      CONSTRAINT                           REFERENCES   product_category_tbl(category_id),
product_id                       CONSTRAINT                           REFERENCES   product_tbl(product_id),
                                 CONSTRAINT product_category_link_pk PRIMARY KEY (category_id, product_id)
)
Error report -
SQL Error: ORA-02253: constraint specification not allowed here
02253. 00000 -  "constraint specification not allowed here"
*Cause:    Constraint specification is not allowed here in the statement.
*Action:   Remove the constraint specification from the statement.
Table DELIVERY_TBL created.


Error starting at line : 86 in command -
CREATE TABLE order_item_tbl
(
order_quantity 	                 NUMBER(5)                            CONSTRAINT order_quantity_nn                       NOT NULL,
order_id                         CONSTRAINT                           REFERENCES order_tbl(order_id),
delivery_id                      CONSTRAINT                           REFERENCES delivery_tbl(delivery_id),
product_id                       CONSTRAINT                           REFERENCES product_tbl(product_id),
                                 CONSTRAINT   order_item_tbl_pk       PRIMARY KEY (order_id, delivery_id, product_id)
)
Error report -
SQL Error: ORA-02253: constraint specification not allowed here
02253. 00000 -  "constraint specification not allowed here"
*Cause:    Constraint specification is not allowed here in the statement.
*Action:   Remove the constraint specification from the statement.