CREATE TABLE ENTP_USER_ADD_DET 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO NUMBER(3,0) NOT NULL ENABLE, 
	USER_LIC_TYPE CHAR(1), 
	LIC_USERS_BEFORE NUMBER(4,0), 
	LIC_USERS_ADD NUMBER(4,0), 
	LIC_USERS_AFTER NUMBER(4,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SYSPARM 
   (	VAR_NAME VARCHAR2(30) NOT NULL ENABLE, 
	VAR_TYPE CHAR(1) NOT NULL ENABLE, 
	VAR_VALUE VARCHAR2(1200), 
	DESCR VARCHAR2(120), 
	VAR_SUBS NUMBER(5,0), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE IMPORT_ORDER_ITEM_INFO 
   (	TRAN_ID VARCHAR2(20) NOT NULL ENABLE, 
	DOC_ID CHAR(20), 
	DOC_NAME VARCHAR2(120), 
	MODIFY_ITEM_CODE CHAR(20), 
	MODIFY_ITEM_DESCR VARCHAR2(130), 
	EXTRACTED_DESCR VARCHAR2(130), 
	VECTOR_ITEM_CODE CHAR(20), 
	VECTOR_ITEM_DESCR VARCHAR2(130), 
	LOOKUP_ITEM_CODE CHAR(20), 
	LOOKUP_ITEM_DESCR VARCHAR2(130), 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_TERM VARCHAR2(15) NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TRANSPORTER_BILL_CHGS 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	CHARGE_CODE CHAR(5), 
	CHARGE_TYPE CHAR(1), 
	AMOUNT NUMBER(18,3), 
	TAX_CLASS CHAR(5), 
	TAX_CHAP CHAR(10), 
	TAX_ENV CHAR(10), 
	TAX_AMT NUMBER(18,3), 
	NET_AMT NUMBER(18,3), 
	CHARGE_BASE_VALUE NUMBER(18,3), 
	CHARGE_RATE NUMBER(14,3), 
	STD_CHARGE_AMT NUMBER(18,3), 
	VARIANCE_AMT NUMBER(18,3)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USER_TASKS 
   (	TRAN_ID VARCHAR2(10) NOT NULL ENABLE, 
	TRAN_DATE DATE, 
	USER_ID CHAR(10), 
	TASK_DESCR VARCHAR2(250), 
	TASK_TYPE CHAR(3), 
	TASK_DOMAIN CHAR(5), 
	TASK_CODE CHAR(15), 
	USER_ID__ASSIGNED CHAR(10), 
	EXP_COMPL_DATE DATE, 
	CURR_STATUS CHAR(1), 
	STATUS_DATE DATE, 
	COMPL_REMARKS VARCHAR2(100), 
	ADD_DATE DATE, 
	ADD_USER CHAR(10), 
	ADD_TERM VARCHAR2(300), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(300), 
	REF_SER CHAR(6), 
	REF_ID VARCHAR2(60)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USERTYPE_LIC_CHRGS 
   (	USER_LIC_TYPE CHAR(1) NOT NULL ENABLE, 
	CHRG_AMT NUMBER(14,3), 
	REMARKS VARCHAR2(60), 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_TERM CHAR(15) NOT NULL ENABLE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM CHAR(15) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE WO_OBSRV_DET 
   (	TRAN_ID CHAR(10), 
	LINE_NO NUMBER(3,0), 
	SEQ_NO NUMBER(3,0), 
	OBSERV_DATA XMLTYPE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS 
 XMLTYPE COLUMN OBSERV_DATA STORE AS SECUREFILE BINARY XML (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES ) ALLOW NONSCHEMA DISALLOW ANYSCHEMA;
CREATE TABLE ENTP_SUBS_RENEW 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	ENTERPRISE VARCHAR2(10) NOT NULL ENABLE, 
	RENEW_PRD CHAR(2) NOT NULL ENABLE, 
	VALID_UPTO DATE NOT NULL ENABLE, 
	RENEW_AMT NUMBER(14,3) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ENTP_USER_ADD 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	ENTERPRISE VARCHAR2(10) NOT NULL ENABLE, 
	EFF_FROM DATE NOT NULL ENABLE, 
	LIC_AMT NUMBER(14,3), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM CHAR(10) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE GSTN_TEMP 
   (	CODE CHAR(10) NOT NULL ENABLE, 
	GSTIN VARCHAR2(15), 
	USER_NAME VARCHAR2(15), 
	EMAIL_ID VARCHAR2(70), 
	ORG_NAME VARCHAR2(80), 
	ADDRESS VARCHAR2(80), 
	CITY VARCHAR2(20), 
	GST_CODE CHAR(2), 
	CONTACT_NO VARCHAR2(15), 
	SITE_CODE CHAR(5)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE IFSC 
   (	IFSC_CODE VARCHAR2(60) NOT NULL ENABLE, 
	BANK_NAME VARCHAR2(100), 
	ADDR1 VARCHAR2(40), 
	ADDR2 VARCHAR2(40), 
	ADDR3 VARCHAR2(40), 
	CITY VARCHAR2(20), 
	STATE_CODE CHAR(5), 
	PIN VARCHAR2(10), 
	STD_CODE CHAR(5), 
	TELE1 VARCHAR2(15), 
	TELE2 VARCHAR2(15), 
	TELE3 VARCHAR2(15), 
	BRANCH VARCHAR2(150), 
	FULL_ADDRESS VARCHAR2(200), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM CHAR(15), 
	STATE_DESCR VARCHAR2(40)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE COURSE_CHAPTERS 
   (	COURSE_CHAPTER CHAR(10), 
	COURSE_CODE CHAR(10), 
	DESCR VARCHAR2(120), 
	CHAPTER_NO NUMBER(4,0), 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	CHG_DATE DATE DEFAULT SYSDATE NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_TERM VARCHAR2(15) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USERS_GEOFENCE 
   (	USER_ID VARCHAR2(10), 
	GEO_FENCE_ENABLE CHAR(1), 
	GEO_FENCE_OPTION CHAR(1), 
	GEO_FENCE_STARTTIME VARCHAR2(5), 
	GEO_FENCE_ENDTIME VARCHAR2(5), 
	CHG_DATE DATE, 
	CHG_USER VARCHAR2(10), 
	CHG_TERM VARCHAR2(20), 
	TRAN_ID VARCHAR2(20) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TNC_IGNORE 
   (	TRAN_ID CHAR(10), 
	USER_CODE VARCHAR2(10), 
	TNC_CODE CHAR(10), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM CHAR(15) NOT NULL ENABLE, 
	DATE_IGNORE DATE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ENT_EXT_API_KEY 
   (	ENTERPRISE VARCHAR2(10) NOT NULL ENABLE, 
	API_NAME VARCHAR2(30) NOT NULL ENABLE, 
	EFF_FROM DATE NOT NULL ENABLE, 
	VALID_UPTO DATE, 
	API_TYPE CHAR(1), 
	API_KEY VARCHAR2(120), 
	API_URL VARCHAR2(120), 
	API_PROVIDER VARCHAR2(120), 
	API_PURPOSE VARCHAR2(120), 
	API_SCOPE CHAR(1), 
	REMARKS VARCHAR2(120), 
	ADD_TERM VARCHAR2(15) NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_DATE DATE NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	API_RESP_TYPE VARCHAR2(15), 
	API_AUTH_TYPE CHAR(1), 
	API_LOGIN_PARAMETER VARCHAR2(4000), 
	HISTORY_COUNT NUMBER(3,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE STD_PK_COLUMNS 
   (	OWNER VARCHAR2(30) NOT NULL ENABLE, 
	CONSTRAINT_NAME VARCHAR2(128) NOT NULL ENABLE, 
	TABLE_NAME VARCHAR2(128) NOT NULL ENABLE, 
	COLUMN_NAME VARCHAR2(4000), 
	POSITION NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RPT_PRINT_LOG 
   (	TRAN_ID CHAR(12) NOT NULL ENABLE, 
	REPORT_NAME VARCHAR2(60), 
	PARAMETER_VAL VARCHAR2(100), 
	USER_ID__PRINT CHAR(10), 
	REPRINT_ON DATE, 
	REPRINT_CNT NUMBER(2,0), 
	TRAN_ID__CTRL CHAR(12)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA;

-- No of Rows = 17
