Skip to content

Instantly share code, notes, and snippets.

@jonBarcus
Created December 10, 2021 16:55
Show Gist options
  • Save jonBarcus/c24e584a60180065db19c2831e0064c1 to your computer and use it in GitHub Desktop.
Save jonBarcus/c24e584a60180065db19c2831e0064c1 to your computer and use it in GitHub Desktop.
Commodity_Updates table
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