Z-Archive » Maybank Projects » M2U UPASS Project

DROP TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."M2U_USER" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."TICKETING_USER" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."IBCC_ADMIN_USER" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."STOCK_USER" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."IM2U_USER" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."CLIENT_APP" cascade constraints;

DROP TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" cascade constraints;

--  DDL for Table M2U_USER

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."M2U_USER" ( 

"USER_ID" NUMBER(10,0) PRIMARY KEY,

"IBPAN" VARCHAR2(20 CHAR), 

"IBPAN2" VARCHAR2(20 CHAR)

);

--------------------------------------------------------

--  DDL for Table TICKETING_USER

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."TICKETING_USER" ( 

"USER_ID" NUMBER(10,0) PRIMARY KEY,

"FULL_NAME" VARCHAR2(200 CHAR), 

"FIRST_NAME" VARCHAR2(200 CHAR), 

"LAST_NAME" VARCHAR2(200 CHAR), 

"PAYEE_CODE" VARCHAR2(20 CHAR)

);

--------------------------------------------------------

--  DDL for Table IBCC_PUBLIC_USER

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" ( 

"USER_ID" NUMBER(10,0) PRIMARY KEY,

"PAN_CC" VARCHAR2(20 CHAR)

);

--------------------------------------------------------

--  DDL for Table IBCC_ADMIN_USER

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."IBCC_ADMIN_USER" ( 

"USER_ID" NUMBER(10,0) PRIMARY KEY

);

--------------------------------------------------------

--  DDL for Table STOCK_USER

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."STOCK_USER" ( 

"USER_ID" NUMBER(10,0) PRIMARY KEY,

"HIGH_NET_WORTH_ATTR" CHAR(1 CHAR),

"CUST_TYPE" NUMBER(10,0),

"ID_NO" VARCHAR2(20 CHAR),

"ACTIVE_ATTR" CHAR(1 CHAR),

"ST_ACCOUNT_NO" VARCHAR2(20 CHAR), 

"PAL_ACCOUNT_NO" VARCHAR2(20 CHAR)

);

--------------------------------------------------------

--  DDL for Table IM2U_USER

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."IM2U_USER" ( 

"USER_ID" NUMBER(10,0) PRIMARY KEY,

"WS_FLAG" CHAR(1 CHAR),

"WS_IDENT_CODE" VARCHAR2(100 CHAR), 

"WS_MY_SG_ID" VARCHAR2(20 CHAR), 

"WS_REG_TIMESTAMP" TIMESTAMP

);

--------------------------------------------------------

--  DDL for Table CLIENT_APP

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."CLIENT_APP" ( 

"APP_ID" NUMBER(10,0) PRIMARY KEY,

"APP_NAME" VARCHAR2(100 CHAR)

);

--------------------------------------------------------

--  Constraints for Table CLIENT_APP

--------------------------------------------------------

  ALTER TABLE "M2U_UPASS_CI"."CLIENT_APP" MODIFY ("APP_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."CLIENT_APP" MODIFY ("APP_NAME" NOT NULL ENABLE);

--------------------------------------------------------

--  DDL for Table USER_APP_ACCESS

--------------------------------------------------------

CREATE TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" ( 

"USER_ID" NUMBER(10,0) ,

"APP_ID" NUMBER(10,0),

"ACCESS_TYPE" CHAR(1 CHAR),

"REGISTRATION_TIME" TIMESTAMP,

CONSTRAINT PK_USER_APP_ACCESS PRIMARY KEY ( USER_ID , APP_ID )

);

--------------------------------------------------------

--  Constraints for Table USER_APP_ACCESS

--------------------------------------------------------

  ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("USER_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("APP_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("ACCESS_TYPE" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("REGISTRATION_TIME" NOT NULL ENABLE);

--------------------------------------------------------

  ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("OID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."M2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."TICKETING_USER" MODIFY ("USER_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" MODIFY ("USER_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."IBCC_ADMIN_USER" MODIFY ("USER_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."STOCK_USER" MODIFY ("USER_ID" NOT NULL ENABLE);

  ALTER TABLE "M2U_UPASS_CI"."IM2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE)