code

mail@pastecode.io avatar
unknown
apex
2 years ago
434 B
1
Indexable
Never
CREATE TABLE  "klasse" 
   (	"ID_KLASSE" NUMBER(10,0) NOT NULL ENABLE, 
	"ISIN" VARCHAR2(50) NOT NULL ENABLE, 
	"s_date" DATE NOT NULL ENABLE, 
	"currency" VARCHAR2(50) NOT NULL ENABLE, 
	"buy_fees" NUMBER NOT NULL ENABLE, 
	"sell_fees" NUMBER NOT NULL ENABLE, 
	"F_price" NUMBER(10,2) NOT NULL ENABLE, 
	 PRIMARY KEY ("ID_KLASSE")
  USING INDEX  ENABLE, 
	 CONSTRAINT "UN_AK" UNIQUE ("ISIN")
  USING INDEX  ENABLE
   )
/