C#.NET通用权限管理在DB2数据库上运行的脚本参考 - 建表脚本参考

左手的ㄟ右手 2022-01-17 10:51 75阅读 0赞

[为什么80%的码农都做不了架构师？>>> ][80_] ![hot3.png][]

C\#.NET通用权限管理在DB2数据库上运行，表脚本参考如下：

CREATE TABLE "ITEMS\_YESNO" (  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_WORKINGPROPERTY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_WORKFLOWCATEGORIES"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(50) ,  
"ITEMNAME" VARCHAR(200) ,  
"ITEMVALUE" VARCHAR(200) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(800) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_WORKCATEGORY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_WED"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_UNITS"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_TRUEFALSE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_TITLE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_TABLEPERMISSIONSCOPE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_SENDCATEGORY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_SECURITYLEVEL"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_SALARYITEMCATEGORY"(  
"ID" VARCHAR(40) NOT NULL,  
"PARENTID" VARCHAR(40) ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_ROLECATEGORY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(50) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_POSTCATEGORY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_PAYCATEGORY"(  
"ID" BIGINT NOT NULL,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(50) NOT NULL,  
"ITEMNAME" VARCHAR(50) NOT NULL,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_PATTERN"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_PARTY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_ORGANIZECATEGORY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_ONSALE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_NEWSCATEGORY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_NATIONALITY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(500) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_MEMBERSHIPLEVELS"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_LINKS"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_HOUSEHOLD"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_GENDER"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_EXPRESS"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(50) NOT NULL,  
"ITEMNAME" VARCHAR(50) NOT NULL,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER ,  
"ALLOWEDIT" INTEGER ,  
"ALLOWDELETE" INTEGER ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_ENABLED"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_EDUCATION"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_DUTY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_DISABILITY"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_DELETIONSTATECODE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_DEGREE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_CONDITION"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_AUDITSTATUS"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_AREA"(  
"ID" INTEGER NOT NULL,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(50) NOT NULL,  
"ITEMNAME" VARCHAR(50) NOT NULL,  
"ITEMVALUE" VARCHAR(100) ,  
"POSTAGEFEE" INTEGER NOT NULL,  
"DELIVERYPOSTAGEFEE" INTEGER NOT NULL,  
"ENABLED" INTEGER ,  
"ALLOWEDIT" INTEGER ,  
"ALLOWDELETE" INTEGER ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_ALLOWEDIT"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMS\_ALLOWDELETE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(40) ,  
"ITEMNAME" VARCHAR(100) ,  
"ITEMVALUE" VARCHAR(100) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "ITEMDETAILS"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"ITEMCODE" VARCHAR(50) ,  
"ITEMNAME" VARCHAR(200) ,  
"ITEMVALUE" VARCHAR(200) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(800) ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_USERROLE"(  
"ID" BIGINT NOT NULL ,  
"USERID" INTEGER ,  
"ROLEID" INTEGER NOT NULL,  
"SORTCODE" INTEGER ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_USERORGANIZE"(  
"ID" BIGINT NOT NULL ,  
"USERID" INTEGER ,  
"COMPANYID" INTEGER ,  
"DEPARTMENTID" INTEGER ,  
"WORKGROUPID" INTEGER ,  
"ROLEID" INTEGER ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER ,  
"DESCRIPTION" VARCHAR(800) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_USERADDRESS"(  
"ID" BIGINT NOT NULL ,  
"USERID" VARCHAR(50) ,  
"REALNAME" VARCHAR(50) ,  
"PROVINCE" VARCHAR(50) ,  
"PROVINCEID" VARCHAR(50) ,  
"CITY" VARCHAR(50) ,  
"CITYID" VARCHAR(50) ,  
"AREA" VARCHAR(50) ,  
"AREAID" VARCHAR(50) ,  
"ADDRESS" VARCHAR(400) ,  
"POSTCODE" VARCHAR(50) ,  
"PHONE" VARCHAR(50) ,  
"MOBILE" VARCHAR(50) ,  
"FAX" VARCHAR(50) ,  
"EMAIL" VARCHAR(200) ,  
"DELIVERCATEGORY" VARCHAR(50) ,  
"SORTCODE" INTEGER ,  
"DELETIONSTATECODE" INTEGER ,  
"ENABLED" INTEGER ,  
"DESCRIPTION" VARCHAR(50) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_USER"(  
"ID" BIGINT NOT NULL ,  
"CODE" VARCHAR(50) ,  
"USERNAME" VARCHAR(50) ,  
"REALNAME" VARCHAR(50) ,  
"ROLEID" INTEGER ,  
"SECURITYLEVEL" INTEGER ,  
"USERFROM" VARCHAR(50) ,  
"COMPANYID" VARCHAR(50) ,  
"COMPANYNAME" VARCHAR(50) ,  
"DEPARTMENTID" VARCHAR(50) ,  
"DEPARTMENTNAME" VARCHAR(50) ,  
"WORKGROUPID" VARCHAR(50) ,  
"WORKGROUPNAME" VARCHAR(50) ,  
"WORKCATEGORY" VARCHAR(50) ,  
"USERPASSWORD" VARCHAR(100) ,  
"CHANGEPASSWORDDATE" TIMESTAMP,  
"COMMUNICATIONPASSWORD" VARCHAR(100) ,  
"SIGNEDPASSWORD" VARCHAR(100) ,  
"PUBLICKEY" VARCHAR(200) ,  
"DUTY" VARCHAR(50) ,  
"TITLE" VARCHAR(50) ,  
"EMAIL" VARCHAR(100) ,  
"LANG" VARCHAR(50) ,  
"GENDER" VARCHAR(50) ,  
"BIRTHDAY" VARCHAR(50) ,  
"MOBILE" VARCHAR(50) ,  
"OICQ" VARCHAR(50) ,  
"HOMEADDRESS" VARCHAR(200) ,  
"THEME" VARCHAR(50) ,  
"ALLOWSTARTTIME" TIMESTAMP,  
"ALLOWENDTIME" TIMESTAMP,  
"LOCKSTARTDATE" TIMESTAMP,  
"LOCKENDDATE" TIMESTAMP,  
"FIRSTVISIT" TIMESTAMP,  
"PREVIOUSVISIT" TIMESTAMP,  
"LASTVISIT" TIMESTAMP,  
"LOGONCOUNT" INTEGER NOT NULL WITH DEFAULT 0,  
"ISSTAFF" INTEGER NOT NULL WITH DEFAULT 0,  
"USERONLINE" INTEGER NOT NULL WITH DEFAULT 0,  
"ISVISIBLE" INTEGER NOT NULL WITH DEFAULT 1,  
"OPENID" VARCHAR(50) ,  
"IPADDRESS" VARCHAR(50) ,  
"MACADDRESS" VARCHAR(50) ,  
"QUESTION" VARCHAR(50) ,  
"ANSWERQUESTION" VARCHAR(200) ,  
"USERADDRESSID" INTEGER ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"AUDITSTATUS" VARCHAR(50) ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_TABLECOLUMNS"(  
"ID" BIGINT NOT NULL ,  
"TABLECODE" VARCHAR(200) ,  
"COLUMNCODE" VARCHAR(200) ,  
"COLUMNNAME" VARCHAR(50) ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"USECONSTRAINT" INTEGER NOT NULL,  
"DATATYPE" VARCHAR(50) ,  
"TARGETTABLE" VARCHAR(400) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(800) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_STAFFORGANIZE"(  
"ID" VARCHAR(50) NOT NULL,  
"STAFFID" VARCHAR(50) ,  
"ORGANIZEID" VARCHAR(50) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER ,  
"SORTCODE" VARCHAR(40) ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_STAFF"(  
"ID" BIGINT NOT NULL ,  
"CODE" VARCHAR(50) ,  
"USERID" INTEGER ,  
"USERNAME" VARCHAR(50) ,  
"REALNAME" VARCHAR(50) ,  
"COMPANYID" INTEGER ,  
"DEPARTMENTID" INTEGER ,  
"WORKGROUPID" INTEGER ,  
"DUTYID" VARCHAR(50) ,  
"GENDER" VARCHAR(50) ,  
"BIRTHDAY" VARCHAR(50) ,  
"AGE" VARCHAR(50) ,  
"IDENTIFICATIONCODE" VARCHAR(50) ,  
"IDCARD" VARCHAR(50) ,  
"NATION" VARCHAR(50) ,  
"EDUCATION" VARCHAR(50) ,  
"SCHOOL" VARCHAR(200) ,  
"DEGREE" VARCHAR(50) ,  
"TITLEID" VARCHAR(50) ,  
"TITLEDATE" VARCHAR(50) ,  
"TITLELEVEL" VARCHAR(50) ,  
"WORKINGDATE" VARCHAR(50) ,  
"JOININDATE" VARCHAR(50) ,  
"OFFICEZIPCODE" VARCHAR(50) ,  
"OFFICEADDRESS" VARCHAR(200) ,  
"OFFICEFAX" VARCHAR(50) ,  
"OFFICEPHONE" VARCHAR(50) ,  
"HOMEZIPCODE" VARCHAR(50) ,  
"HOMEADDRESS" VARCHAR(50) ,  
"HOMEFAX" VARCHAR(50) ,  
"HOMEPHONE" VARCHAR(50) ,  
"EMAIL" VARCHAR(100) ,  
"MOBILE" VARCHAR(50) ,  
"SHORTNUMBER" VARCHAR(50) ,  
"TELEPHONE" VARCHAR(50) ,  
"OICQ" VARCHAR(50) ,  
"DIMISSIONDATE" VARCHAR(50) ,  
"DIMISSIONCAUSE" VARCHAR(50) ,  
"NATIVEPLACE" VARCHAR(100) ,  
"BANKCODE" VARCHAR(50) ,  
"PARTY" VARCHAR(50) ,  
"NATIONALITY" VARCHAR(50) ,  
"MAJOR" VARCHAR(50) ,  
"WORKINGPROPERTY" VARCHAR(50) ,  
"COMPETENCY" VARCHAR(50) ,  
"ISDIMISSION" VARCHAR(50) ,  
"DIMISSIONWHITHER" VARCHAR(50) ,  
"DELETIONSTATECODE" VARCHAR(50) NOT NULL,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_SEQUENCE"(  
"ID" VARCHAR(50) NOT NULL,  
"FULLNAME" VARCHAR(50) NOT NULL,  
"PREFIX" VARCHAR(50) ,  
"SEPARATOR" VARCHAR(50) ,  
"SEQUENCE" INTEGER NOT NULL,  
"REDUCTION" INTEGER NOT NULL,  
"STEP" INTEGER NOT NULL,  
"DESCRIPTION" VARCHAR(800) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_ROLE"(  
"ID" BIGINT NOT NULL ,  
"SYSTEMID" VARCHAR(50) ,  
"ORGANIZEID" INTEGER ,  
"CODE" VARCHAR(50) ,  
"REALNAME" VARCHAR(200) ,  
"CATEGORY" VARCHAR(50) ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DESCRIPTION" VARCHAR(500) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_PROJECT"(  
"ID" BIGINT NOT NULL ,  
"CODE" VARCHAR(50) ,  
"REALNAME" VARCHAR(200) ,  
"CATEGORY" VARCHAR(50) ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DESCRIPTION" VARCHAR(500) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_PERMISSIONSCOPE"(  
"ID" BIGINT NOT NULL ,  
"RESOURCEID" VARCHAR(50) ,  
"RESOURCECATEGORY" VARCHAR(50) ,  
"TARGETID" VARCHAR(50) ,  
"TARGETCATEGORY" VARCHAR(50) ,  
"PERMISSIONID" INTEGER ,  
"PERMISSIONCONSTRAINT" VARCHAR(200) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_PERMISSIONITEM"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"CODE" VARCHAR(100) ,  
"FULLNAME" VARCHAR(200) ,  
"SORTCODE" INTEGER ,  
"ISSCOPE" INTEGER NOT NULL,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"LASTCALL" TIMESTAMP,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_PERMISSION"(  
"ID" BIGINT NOT NULL ,  
"RESOURCEID" VARCHAR(50) ,  
"RESOURCECATEGORY" VARCHAR(50) ,  
"PERMISSIONID" VARCHAR(50) ,  
"PERMISSIONCONSTRAINT" VARCHAR(200) ,  
"ENABLED" INTEGER ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_PARAMETER"(  
"ID" VARCHAR(40) NOT NULL,  
"CATEGORYID" VARCHAR(40) ,  
"PARAMETERID" VARCHAR(40) ,  
"PARAMETERCODE" VARCHAR(40) ,  
"PARAMETERCONTENT" VARCHAR(2000) ,  
"WORKED" INTEGER NOT NULL,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_ORGANIZE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"CODE" VARCHAR(50) ,  
"FULLNAME" VARCHAR(50) ,  
"SHORTNAME" VARCHAR(50) ,  
"CATEGORY" VARCHAR(50) ,  
"OUTERPHONE" VARCHAR(100) ,  
"INNERPHONE" VARCHAR(100) ,  
"FAX" VARCHAR(50) ,  
"POSTALCODE" VARCHAR(50) ,  
"ADDRESS" VARCHAR(50) ,  
"WEB" VARCHAR(50) ,  
"BANK" VARCHAR(50) ,  
"BANKACCOUNT" VARCHAR(50) ,  
"MANAGER" VARCHAR(50) ,  
"LAYER" INTEGER ,  
"ASSISTANTMANAGER" VARCHAR(50) ,  
"ISINNERORGANIZE" INTEGER NOT NULL,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"DELETIONSTATECODE" INTEGER ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_NEWS"(  
"ID" VARCHAR(50) NOT NULL,  
"FOLDERID" VARCHAR(50) ,  
"TITLE" VARCHAR(200) ,  
"FILEPATH" VARCHAR(500) ,  
"CATEGORYCODE" VARCHAR(50) ,  
"SOURCE" VARCHAR(200) ,  
"INTRODUCTION" VARCHAR(500) ,  
"KEYWORDS" VARCHAR(500) ,  
"CONTENTS" CLOB,  
"READCOUNT" INTEGER NOT NULL,  
"FILESIZE" INTEGER NOT NULL,  
"IMAGEURL" VARCHAR(200) ,  
"HOMEPAGE" INTEGER ,  
"AUDITSTATUS" VARCHAR(20) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" VARCHAR(40) ,  
"DESCRIPTION" VARCHAR(100) ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_MODULE"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"CODE" VARCHAR(100) ,  
"FULLNAME" VARCHAR(100) ,  
"CATEGORYID" VARCHAR(50) ,  
"NAVIGATEURL" VARCHAR(200) ,  
"IMAGEINDEX" VARCHAR(50) ,  
"SELECTEDIMAGEINDEX" VARCHAR(50) ,  
"TARGET" VARCHAR(100) ,  
"SORTCODE" INTEGER NOT NULL,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"ISPUBLIC" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ISMENU" INTEGER NOT NULL,  
"EXPAND" INTEGER NOT NULL,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_MESSAGE"(  
"ID" VARCHAR(50) NOT NULL,  
"PARENTID" VARCHAR(50) ,  
"FUNCTIONID" VARCHAR(50) ,  
"CATEGORYID" VARCHAR(50) ,  
"OBJECTID" VARCHAR(50) ,  
"RECEIVERID" VARCHAR(50) ,  
"RECEIVERREALNAME" VARCHAR(50) ,  
"TITLE" VARCHAR(50) ,  
"CONTENT" CLOB,  
"ISNEW" INTEGER NOT NULL WITH DEFAULT 1,  
"READCOUNT" INTEGER NOT NULL WITH DEFAULT 0,  
"READDATE" TIMESTAMP,  
"IPADDRESS" VARCHAR(50) ,  
"TARGETURL" VARCHAR(400) ,  
"DESCRIPTION" VARCHAR(200) ,  
"DELETIONSTATECODE" INTEGER ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_LOG"(  
"LOGID" INTEGER NOT NULL,  
"PROCESSID" VARCHAR(50) ,  
"PROCESSNAME" VARCHAR(50) ,  
"METHODID" VARCHAR(50) ,  
"METHODNAME" VARCHAR(50) ,  
"PARAMETERS" VARCHAR(200) ,  
"USERID" VARCHAR(50) NOT NULL,  
"USERREALNAME" VARCHAR(50) ,  
"IPADDRESS" VARCHAR(50) NOT NULL,  
"URLREFERRER" VARCHAR(800) ,  
"WEBURL" VARCHAR(800) ,  
"DESCRIPTION" VARCHAR(800) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"MODIFIEDON" TIMESTAMP  
);

CREATE TABLE "BASE\_LEAVE"(  
"ID" VARCHAR(40) NOT NULL,  
"COMPANYID" INTEGER ,  
"COMPANYNAME" VARCHAR(50) ,  
"DEPARTMENTID" INTEGER ,  
"DEPARTMENTNAME" VARCHAR(50) ,  
"WORKGROUPID" INTEGER ,  
"WORKGROUPNAME" VARCHAR(50) ,  
"STARTTIME" TIMESTAMP,  
"ENDTIME" TIMESTAMP,  
"HOURS" INTEGER ,  
"CATEGORY" VARCHAR(50) ,  
"REASON" VARCHAR(200) ,  
"SORTCODE" INTEGER,  
"DELETIONSTATECODE" INTEGER WITH DEFAULT 0 ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_ITEMS"(  
"ID" BIGINT NOT NULL ,  
"PARENTID" BIGINT ,  
"CODE" VARCHAR(50) ,  
"FULLNAME" VARCHAR(100) ,  
"TARGETTABLE" VARCHAR(50) ,  
"ISTREE" INTEGER NOT NULL,  
"USEITEMCODE" VARCHAR(50) NOT NULL,  
"USEITEMNAME" VARCHAR(50) NOT NULL,  
"USEITEMVALUE" VARCHAR(50) NOT NULL,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWEDIT" INTEGER NOT NULL WITH DEFAULT 1 ,  
"ALLOWDELETE" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(800) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_FOLDER"(  
"ID" VARCHAR(40) NOT NULL,  
"PARENTID" VARCHAR(40) ,  
"FOLDERNAME" VARCHAR(200) NOT NULL,  
"STATECODE" VARCHAR(40) ,  
"SORTCODE" INTEGER NOT NULL,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_FILE"(  
"ID" VARCHAR(40) NOT NULL,  
"FOLDERID" VARCHAR(40) ,  
"FILENAME" VARCHAR(200) ,  
"FILEPATH" VARCHAR(500) ,  
"CATEGORY" VARCHAR(50) ,  
"FILECONTENT" CLOB,  
"READCOUNT" INTEGER NOT NULL WITH DEFAULT 0,  
"FILESIZE" INTEGER NOT NULL WITH DEFAULT 0,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(100) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_CONTACTDETAILS"(  
"ID" VARCHAR(40) NOT NULL,  
"CONTACTID" VARCHAR(40) ,  
"CATEGORY" VARCHAR(40) ,  
"RECEIVERID" VARCHAR(40) ,  
"RECEIVERREALNAME" VARCHAR(40) ,  
"ISNEW" INTEGER NOT NULL WITH DEFAULT 1,  
"NEWCOMMENT" INTEGER NOT NULL WITH DEFAULT 0,  
"LASTVIEWIP" VARCHAR(40) ,  
"LASTVIEWDATE" VARCHAR(40) ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0,  
"SORTCODE" INTEGER ,  
"DESCRIPTION" VARCHAR(200) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_CONTACT"(  
"ID" VARCHAR(40) NOT NULL,  
"PARENTID" VARCHAR(40) ,  
"TITLE" VARCHAR(100) ,  
"CONTENT" VARCHAR(400) ,  
"PRIORITY" VARCHAR(40) ,  
"SENDCOUNT" INTEGER NOT NULL WITH DEFAULT 0,  
"READCOUNT" INTEGER NOT NULL WITH DEFAULT 0,  
"ISOPEN" INTEGER NOT NULL WITH DEFAULT 0,  
"COMMENTUSERID" VARCHAR(40) ,  
"COMMENTUSERREALNAME" VARCHAR(40) ,  
"COMMENTDATE" TIMESTAMP,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1,  
"DESCRIPTION" VARCHAR(200) ,  
"SORTCODE" INTEGER ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_COMMENT"(  
"ID" VARCHAR(40) NOT NULL,  
"PARENTID" VARCHAR(50) ,  
"CATEGORYID" VARCHAR(50) ,  
"OBJECTID" VARCHAR(50) ,  
"TITLE" VARCHAR(50) ,  
"WORKED" INTEGER NOT NULL WITH DEFAULT 0,  
"CONTENT" CLOB,  
"IMPORTANT" INTEGER NOT NULL WITH DEFAULT 0,  
"PRIORITYID" VARCHAR(20) ,  
"IPADDRESS" VARCHAR(50) ,  
"TARGETURL" VARCHAR(400) ,  
"DESCRIPTION" VARCHAR(200) ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"SORTCODE" INTEGER ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_BUSINESSCARD"(  
"ID" VARCHAR(40) NOT NULL,  
"FULLNAME" VARCHAR(40) ,  
"COMPANY" VARCHAR(200) ,  
"TITLE" VARCHAR(40) ,  
"PHONE" VARCHAR(40) ,  
"POSTALCODE" VARCHAR(40) ,  
"MOBILE" VARCHAR(40) ,  
"ADDRESS" VARCHAR(40) ,  
"EMAIL" VARCHAR(40) ,  
"OFFICEPHONE" VARCHAR(40) ,  
"QQ" VARCHAR(40) ,  
"FAX" VARCHAR(40) ,  
"WEB" VARCHAR(40) ,  
"BANKNAME" VARCHAR(40) ,  
"BANKACCOUNT" VARCHAR(40) ,  
"TAXACCOUNT" VARCHAR(40) ,  
"DESCRIPTION" VARCHAR(800) ,  
"PERSONAL" INTEGER NOT NULL WITH DEFAULT 1,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0,  
"SORTCODE" INTEGER ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

CREATE TABLE "BASE\_WORKREPORT"(  
"ID" VARCHAR(40) NOT NULL,  
"COMPANYID" VARCHAR(40) ,  
"DEPARTMENTID" VARCHAR(40) ,  
"STAFFID" VARCHAR(40) ,  
"CATEGORYID" VARCHAR(40) ,  
"WORKDATE" VARCHAR(40) ,  
"CONTENT" VARCHAR(800) ,  
"MANHOUR" NUMERIC(18, 1) NOT NULL,  
"PROJECTID" VARCHAR(40) ,  
"SCORE" INTEGER NOT NULL,  
"AUDITSTAFFID" VARCHAR(40) ,  
"AUDITSTAFFFULLNAME" VARCHAR(40) ,  
"DESCRIPTION" VARCHAR(40) ,  
"STATECODE" INTEGER ,  
"ENABLED" INTEGER NOT NULL WITH DEFAULT 1 ,  
"DELETIONSTATECODE" INTEGER NOT NULL WITH DEFAULT 0 ,  
"SORTCODE" VARCHAR(40) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"MODIFIEDON" TIMESTAMP ,  
"MODIFIEDUSERID" VARCHAR(20) ,  
"MODIFIEDBY" VARCHAR(20)  
);

32个页数的，表空间需要重新创建。

CREATE TABLE "JIRIGALA"."BASE\_EXCEPTION"(  
"LOGID" VARCHAR(40) NOT NULL,  
"EVENTID" INTEGER ,  
"CATEGORY" VARCHAR(64) ,  
"PRIORITY" INTEGER ,  
"SEVERITY" VARCHAR(32) ,  
"TITLE" VARCHAR(256) ,  
"TIMESTAMP" TIMESTAMP,  
"MACHINENAME" VARCHAR(32) ,  
"IPADDRESS" VARCHAR(40) ,  
"APPDOMAINNAME" VARCHAR(2000) ,  
"PROCESSID" VARCHAR(256) ,  
"PROCESSNAME" VARCHAR(2000) ,  
"THREADNAME" VARCHAR(2000) ,  
"WIN32THREADID" VARCHAR(128) ,  
"MESSAGE" VARCHAR(2000) ,  
"FORMATTEDMESSAGE" CLOB,  
"CREATEUSERID" VARCHAR(20) ,  
"CREATEBY" VARCHAR(20) ,  
"CREATEON" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP  
) IN "USERSPACE\_UCV36";

转载于:https://my.oschina.net/iwenr/blog/227963

[80_]: https://my.oschina.net/u/2663968/blog/3051541
[hot3.png]: /images/20220117/c220fbbcbd0a4841981b8b80fd6e685a.png