Created
December 10, 2021 16:55
-
-
Save jonBarcus/c24e584a60180065db19c2831e0064c1 to your computer and use it in GitHub Desktop.
Commodity_Updates table
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE "COMMODITY_UPDATES" | |
( "ID" NUMBER GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE, | |
"COMMODITY_ID" NUMBER NOT NULL ENABLE, | |
"PRICE" NUMBER NOT NULL ENABLE, | |
"LOCATION_ID" NUMBER NOT NULL ENABLE, | |
"TRANSACTION_TYPE_ID" NUMBER NOT NULL ENABLE, | |
"OVER_UNDER_STOCK_TYPE_ID" NUMBER, | |
"SC_VERSION_ID" NUMBER NOT NULL ENABLE, | |
CONSTRAINT "COMMODITY_UPDATES_PK" PRIMARY KEY ("ID") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment