I wanted to create tables and establish relationships between them, so I worked on it a bit. Although I didn’t detect any errors in the code I wrote, I still haven’t been able to resolve the issue. I’m stuck on this error and haven’t been able to fix it in any way. Please help.

CREATE TABLE Suppliers ( 
    SupplierID NUMBER PRIMARY KEY NOT NULL,
    CompanyName VARCHAR2(255) NOT NULL,
    ContactFName VARCHAR2(255) NOT NULL,
    ContactLName VARCHAR2(255) NOT NULL,
    ContactTitle VARCHAR2(255) NOT NULL,
    Address1 VARCHAR2(255) NOT NULL,
    Address2 VARCHAR2(255),
    City VARCHAR2(255) NOT NULL,
    State VARCHAR2(255) NOT NULL,
    PostalCode VARCHAR2(255) NOT NULL,
    Country VARCHAR2(255) NOT NULL,
    Phone VARCHAR2(11) NOT NULL,
    Fax VARCHAR2(255) NOT NULL,
    Email VARCHAR2(255) NOT NULL,
    URL VARCHAR2(255) NOT NULL,
    PaymentMethds VARCHAR2(255) NOT NULL,
    DiscountType VARCHAR2(255) NOT NULL,
    TypeGoods VARCHAR2(255) NOT NULL,
    Notes VARCHAR2(255) NOT NULL,
    DiscountAvailable VARCHAR2(255) NOT NULL,
    CurrentOrder VARCHAR2(255) NOT NULL,
    Logo VARCHAR2(255) NOT NULL,
    CustomerID NUMBER NOT NULL,
    SizeURL VARCHAR2(255)
);

CREATE TABLE Payments ( 
    PaymentID NUMBER NOT NULL PRIMARY KEY,
    PaymentType VARCHAR2(255) NOT NULL,
    Allowed NUMBER(1,0) NOT NULL
);

CREATE TABLE Shippers ( 
    ShipperID NUMBER NOT NULL PRIMARY KEY,
    CompanyName VARCHAR2(255) NOT NULL,
    Phone VARCHAR2(11) NOT NULL
);

CREATE TABLE Customers (
    CustomerID NUMBER NOT NULL PRIMARY KEY,
    FirstName VARCHAR2(255) NOT NULL,
    LastName VARCHAR2(255) NOT NULL,
    Class VARCHAR2(255) NOT NULL,
    Room VARCHAR2(255) NOT NULL,
    Building VARCHAR2(255) NOT NULL,
    AddressOne VARCHAR2(255) NOT NULL,
    AddressTwo VARCHAR2(255) NOT NULL,
    City VARCHAR2(255) NOT NULL,
    State VARCHAR2(255) NOT NULL,
    PostalCode VARCHAR2(255) NOT NULL,
    Country VARCHAR2(255) NOT NULL,
    Phone VARCHAR2(11) NOT NULL,
    Email VARCHAR2(255) NOT NULL,
    VoiceMail VARCHAR2(255) NOT NULL,
    Password VARCHAR2(255) NOT NULL,
    CreditCard VARCHAR2(255) NOT NULL,
    CreditCardTypeId VARCHAR2(255) NOT NULL,
    CardExpMo VARCHAR2(255) NOT NULL,
    BillingAddress VARCHAR2(255) NOT NULL,
    BillingCity VARCHAR2(255) NOT NULL,
    BillingRegion VARCHAR2(255) NOT NULL,
    BillingPostalCode NUMBER NOT NULL,
    BillingCountry VARCHAR2(255) NOT NULL,
    ShipAddress VARCHAR2(255) NOT NULL,
    ShipCity VARCHAR2(255) NOT NULL,
    ShipRegion VARCHAR2(255) NOT NULL,
    ShipPostalCode NUMBER NOT NULL,
    ShipCountry VARCHAR2(255) NOT NULL,
    DateEntered VARCHAR2(255) NOT NULL
);


CREATE TABLE Category ( 
    CategoryID NUMBER PRIMARY KEY NOT NULL,
    CategoryName VARCHAR2(255) NOT NULL,
    Description VARCHAR2(255) NOT NULL,
    Picture VARCHAR2(255) NOT NULL,
    Active NUMBER(1,0)
);


CREATE TABLE Products ( 
    ProductID NUMBER NOT NULL PRIMARY KEY,
    SKU VARCHAR2(255) NOT NULL,
    IDSKU VARCHAR2(255) NOT NULL,
    VendorProductID NUMBER NOT NULL,
    ProductName VARCHAR2(255) NOT NULL,
    ProductDescription VARCHAR2(255) NOT NULL,
    SupplierID NUMBER NOT NULL,
    CategoryID NUMBER NOT NULL,
    QuantityPerUnit VARCHAR2(255) NOT NULL,
    UnitPrice NUMBER NOT NULL,
    MSRP NUMBER NOT NULL,
    AvailableSize VARCHAR2(255),
    AvailableColors VARCHAR2(255) NOT NULL,
    Size NUMBER NOT NULL,
    Color VARCHAR2(255) NOT NULL,
    Discount VARCHAR2(255) NOT NULL,
    UnitWeight VARCHAR2(255) NOT NULL,
    UnitsInStock VARCHAR2(255) NOT NULL,
    UnitsInOrder VARCHAR2(255) NOT NULL,
    ReorderLevel VARCHAR2(255) NOT NULL,
    ProductAvailable NUMBER NOT NULL,
    DiscountAvailable NUMBER NOT NULL,
    CurrentOrder VARCHAR2(255) NOT NULL,
    Picture VARCHAR2(255) NOT NULL,
    Ranking NUMBER NOT NULL,
    Note VARCHAR2(255),
    CONSTRAINT fksup FOREIGN KEY (SupplierID) REFERENCES Suppliers(SupplierID),
    CONSTRAINT catsup FOREIGN KEY (CategoryID) REFERENCES Category(CategoryID)
);

CREATE TABLE OrderDetails( 
    OrderID NUMBER NOT NULL,
    ProductID NUMBER NOT NULL,
    OrderNumber NUMBER NOT NULL,
    Price NUMBER NOT NULL,
    Quantity NUMBER NOT NULL,
    Discount NUMBER NOT NULL,
    Total NUMBER NOT NULL,
    IDSKU NUMBER NOT NULL,
    Size NUMBER NOT NULL,
    Color VARCHAR2(255) NOT NULL,
    FullFilled VARCHAR2(255),
    ShipDate DATE NOT NULL,
    OrderDetailID NUMBER NOT NULL PRIMARY KEY,
    BillDate DATE NOT NULL,
    CONSTRAINT uruncekme FOREIGN KEY (ProductID) REFERENCES Products(ProductID)
);

CREATE TABLE Orders ( OrderID NUMBER NOT NULL PRIMARY KEY,
    CustomerID NUMBER NOT NULL,
    OrderNumber NUMBER NOT NULL,
    PaymentID NUMBER NOT NULL,
    OrderDate NUMBER NOT NULL,
    ShipDate DATE NOT NULL,
    RequiredDate DATE NOT NULL,
    ShipperID NUMBER NOT NULL,
    Freight VARCHAR2(255) NOT NULL,
    SalesTax VARCHAR2(255) ,
    TimeStamp VARCHAR2(255) ,
    TransactStatus NUMBER(1,0) NOT NULL,
    ErrLoc VARCHAR2(255),
    ErrMsg VARCHAR2(255),
    Fulfilled VARCHAR2(255),
    Deleted NUMBER(1,0) NOT NULL,
    Paid VARCHAR2(255) NOT NULL,
    PaymentDate DATE NOT NULL,
    CONSTRAINT siparisdetay FOREIGN KEY (OrderID) REFERENCES OrderDetails(OrderID),
    CONSTRAINT odemedetay FOREIGN KEY (PaymentID) REFERENCES Payments(PaymentID),
    CONSTRAINT shipperdetay FOREIGN KEY (ShipperID) REFERENCES Shippers(ShipperID),
    CONSTRAINT musteridetay FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);

ERROR

Table SUPPLIERS created.


Table PAYMENTS created.


Table SHIPPERS created.


Table CUSTOMERS created.


Table CATEGORY created.


Error starting at line : 89 in command -
CREATE TABLE Products ( 
    ProductID NUMBER NOT NULL PRIMARY KEY,
    SKU VARCHAR2(255) NOT NULL,
    IDSKU VARCHAR2(255) NOT NULL,
    VendorProductID NUMBER NOT NULL,
    ProductName VARCHAR2(255) NOT NULL,
    ProductDescription VARCHAR2(255) NOT NULL,
    SupplierID NUMBER NOT NULL,
    CategoryID NUMBER NOT NULL,
    QuantityPerUnit VARCHAR2(255) NOT NULL,
    UnitPrice NUMBER NOT NULL,
    MSRP NUMBER NOT NULL,
    AvailableSize VARCHAR2(255),
    AvailableColors VARCHAR2(255) NOT NULL,
    Size NUMBER NOT NULL,
    Color VARCHAR2(255) NOT NULL,
    Discount VARCHAR2(255) NOT NULL,
    UnitWeight VARCHAR2(255) NOT NULL,
    UnitsInStock VARCHAR2(255) NOT NULL,
    UnitsInOrder VARCHAR2(255) NOT NULL,
    ReorderLevel VARCHAR2(255) NOT NULL,
    ProductAvailable NUMBER NOT NULL,
    DiscountAvailable NUMBER NOT NULL,
    CurrentOrder VARCHAR2(255) NOT NULL,
    Picture VARCHAR2(255) NOT NULL,
    Ranking NUMBER NOT NULL,
    Note VARCHAR2(255),
    CONSTRAINT fksup FOREIGN KEY (SupplierID) REFERENCES Suppliers(SupplierID),
    CONSTRAINT catsup FOREIGN KEY (CategoryID) REFERENCES Category(CategoryID)
)
Error report -
ORA-00904: : invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:

Error starting at line : 121 in command -
CREATE TABLE OrderDetails( 
    OrderID NUMBER NOT NULL,
    ProductID NUMBER NOT NULL,
    OrderNumber NUMBER NOT NULL,
    Price NUMBER NOT NULL,
    Quantity NUMBER NOT NULL,
    Discount NUMBER NOT NULL,
    Total NUMBER NOT NULL,
    IDSKU NUMBER NOT NULL,
    Size NUMBER NOT NULL,
    Color VARCHAR2(255) NOT NULL,
    FullFilled VARCHAR2(255),
    ShipDate DATE NOT NULL,
    OrderDetailID NUMBER NOT NULL PRIMARY KEY,
    BillDate DATE NOT NULL,
    CONSTRAINT uruncekme FOREIGN KEY (ProductID) REFERENCES Products(ProductID)
)
Error report -
ORA-00904: : invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:

Error starting at line : 140 in command -
CREATE TABLE Orders ( OrderID NUMBER NOT NULL PRIMARY KEY,
    CustomerID NUMBER NOT NULL,
    OrderNumber NUMBER NOT NULL,
    PaymentID NUMBER NOT NULL,
    OrderDate NUMBER NOT NULL,
    ShipDate DATE NOT NULL,
    RequiredDate DATE NOT NULL,
    ShipperID NUMBER NOT NULL,
    Freight VARCHAR2(255) NOT NULL,
    SalesTax VARCHAR2(255) ,
    TimeStamp VARCHAR2(255) ,
    TransactStatus NUMBER(1,0) NOT NULL,
    ErrLoc VARCHAR2(255),
    ErrMsg VARCHAR2(255),
    Fulfilled VARCHAR2(255),
    Deleted NUMBER(1,0) NOT NULL,
    Paid VARCHAR2(255) NOT NULL,
    PaymentDate DATE NOT NULL,
    CONSTRAINT siparisdetay FOREIGN KEY (OrderID) REFERENCES OrderDetails(OrderID),
    CONSTRAINT odemedetay FOREIGN KEY (PaymentID) REFERENCES Payments(PaymentID),
    CONSTRAINT shipperdetay FOREIGN KEY (ShipperID) REFERENCES Shippers(ShipperID),
    CONSTRAINT musteridetay FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
)
Error report -
ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

I reviewed the code from scratch and did some research, but I couldn’t find a solution.