dmkrm.sql

tomcat最新安装程序

    "PositionDate" DATE DEFAULT '1900-01-01',
    "StartDate" DATE DEFAULT '1900-01-01',
    "EndDate" DATE DEFAULT '1900-01-01',
    "Manager" VARCHAR(20),
    "Stuff" VARCHAR(255),
    PRIMARY KEY("User_ID")
);

CREATE TABLE "PE_Propost" (
    "P_ID" BIGINT,
    "P_Name" VARCHAR(20)
);

CREATE TABLE "PE_Retire" (
    "OUser_ID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "R_Name" VARCHAR(20)   NOT NULL,
    "R_Sex" CHAR(2),
    "R_Sequency" BIGINT  DEFAULT 0,
    "R_Born" DATE,
    "R_Native" VARCHAR(40),
    "R_WorkTime" DATE  DEFAULT '1900-01-01' NOT NULL,
    "R_RetireDate" DATE  DEFAULT '1900-01-01' NOT NULL,
    "R_OrigiOccup" VARCHAR(50),
    "R_Salary" VARCHAR(50)   NOT NULL,
    "R_Phone" VARCHAR(15),
    "R_Kind" VARCHAR(20),
    "R_Address" VARCHAR(50),
    "R_Healthy" VARCHAR(100),
    "R_Memo" VARCHAR(100),
    "R_RealDel" CHAR(1),
    PRIMARY KEY("OUser_ID")
);

CREATE TABLE "PE_RetireDOC" (
    "RD_ID" BIGINT  DEFAULT 0 NOT NULL,
    "RD_Date" DATE  DEFAULT '1900-01-01' NOT NULL,
    "RD_Content" LONGVARCHAR,
    "RD_RealDel" CHAR(1),
    PRIMARY KEY("RD_ID")
);

CREATE TABLE "PE_Train" (
    "T_ID" BIGINT  DEFAULT 0 NOT NULL,
    "User_ID" VARCHAR(20)  DEFAULT '0',
    "T_Kind" VARCHAR(10),
    "T_Content" LONGVARCHAR,
    "T_Date" DATE  DEFAULT '1900-01-01',
    "T_RealDel" CHAR(1),
    PRIMARY KEY("T_ID")
);

CREATE TABLE "PE_PersonDuty" (
  "UserID" BIGINT DEFAULT 0 NOT NULL,
  "Duty" VARCHAR(255) DEFAULT '',
  "Degree" CHAR(1) DEFAULT '0',
  "PercentValue" TINYINT DEFAULT 0
);

CREATE TABLE "RE_ApproveFlow" (
    "APF_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SCH_ID" BIGINT  DEFAULT 0 NOT NULL,
    "APF_ComeDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "APF_Step" INT  DEFAULT 0 NOT NULL,
    "APF_EAAID" VARCHAR(20)   NOT NULL,
    "APF_EAAName" VARCHAR(20)   NOT NULL,
    "APF_FactEAAID" VARCHAR(20),
    "APF_FactEAAName" VARCHAR(20),
    "APF_Mind" VARCHAR(100)   NOT NULL,
    "APF_EAAText" VARCHAR(200),
    "APF_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    PRIMARY KEY("APF_ID")
);

CREATE TABLE "RE_InformUser" (
    "SCI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "INU_InformPersonID" VARCHAR(20)   NOT NULL,
    "INU_InformPersontName" VARCHAR(20)   NOT NULL,
    "INU_Message" LONGVARCHAR   NOT NULL,
    "INU_InformDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "INU_IsRead" CHAR(1)  DEFAULT 'N' NOT NULL
);

CREATE TABLE "RE_SCHUserInfo" (
    "SCH_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SUI_AccompanyPersonrID" VARCHAR(20)   NOT NULL,
    "SUI_AccompanyPersonName" VARCHAR(20)   NOT NULL,
    "SUI_DutyTag" CHAR(1)   NOT NULL
);

CREATE TABLE "RE_Scheme" (
    "SCH_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TAS_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TEA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SCH_Name" VARCHAR(50)   NOT NULL,
    "SCH_VisitorEquest" LONGVARCHAR,
    "SCH_ReceptionPrincipalID" VARCHAR(20)   NOT NULL,
    "SCH_ReceptionPrincipallName" VARCHAR(20)   NOT NULL,
    "SCH_ReceptionProject" LONGVARCHAR,
    "SCH_OutlayOutgo" INT  DEFAULT 0 NOT NULL,
    "SCH_OutlayIncome" INT  DEFAULT 0 NOT NULL,
    "SCH_OutlayNetOutgo" INT  DEFAULT 0 NOT NULL,
    "SCH_IsAppend" CHAR(1)  DEFAULT 'N' NOT NULL,
    "SCH_Execute" CHAR(1)  DEFAULT 'N' NOT NULL,
    PRIMARY KEY("SCH_ID")
);

CREATE TABLE "RE_SchemeInfo" (
    "SCI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SCH_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SCI_ReadyMind" VARCHAR(200)   NOT NULL,
    "SCI_ReadyPersonID" VARCHAR(20)   NOT NULL,
    "SCI_ReadyPersonName" VARCHAR(20)   NOT NULL,
    "SCI_ReadyDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "SCI_SendEAADate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "SCI_SendMode" CHAR(1)  DEFAULT 'N' NOT NULL,
    "SCI_CompleteDate" DATE,
    "SCI_FactIncome" INT,
    "SCI_FactOutgo" INT,
    "SCI_Summary" LONGVARCHAR,
    "SCI_Confirm" CHAR(1)  DEFAULT 'N' NOT NULL,
    "SCI_InformPrint" CHAR(1)  DEFAULT 'N' NOT NULL,
    "SCI_ProjectPrint" CHAR(1)  DEFAULT 'N' NOT NULL,
    "SCI_ReportPrint" CHAR(1)  DEFAULT 'N' NOT NULL,
    PRIMARY KEY("SCI_ID")
);

CREATE TABLE "RE_Task" (
    "TAS_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TAS_Name" VARCHAR(50)   NOT NULL,
    "TAS_BuildDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "TAS_BuilderPersonID" VARCHAR(20)   NOT NULL,
    "TAS_LinkmanID" VARCHAR(20)   NOT NULL,
    "TAS_LinkmanName" VARCHAR(20)   NOT NULL,
    "TAS_Summary" LONGVARCHAR,
    "TAS_CompleteDate" DATE,
    "TAS_Execute" CHAR(1)  DEFAULT 'N' NOT NULL,
    "TAS_Memo" VARCHAR(200),
    PRIMARY KEY("TAS_ID")
);

CREATE TABLE "RE_Team" (
    "TEA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TEA_Name" VARCHAR(50)   NOT NULL,
    "TEA_Unit" VARCHAR(50)   NOT NULL,
    "TEA_FurlDate" DATE,
    "TEA_Leader" VARCHAR(20)   NOT NULL,
    "TEA_VisitDate" DATE DEFAULT '1900-01-01' NOT NULL,
    "TEA_FemaleCount" INT  DEFAULT 0 NOT NULL,
    "TEA_MaleCount" INT  DEFAULT 0 NOT NULL,
    "TEA_VehicleNumber" VARCHAR(50),
    "TEA_LeaveDate" DATE,
    "TEA_Linkman" VARCHAR(20),
    "TEA_TEL" VARCHAR(20),
    "TEA_Order" VARCHAR(100)   NOT NULL,
    "TEA_BuilderPersonID" VARCHAR(100)   NOT NULL,
    "TEA_Memo" VARCHAR(200),
    PRIMARY KEY("TEA_ID")
);

CREATE TABLE "RE_Visitor" (
    "VIS_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TEA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "VIS_Unit" VARCHAR(50),
    "VIS_Name" VARCHAR(20)   NOT NULL,
    "VIS_Sex" CHAR(1)   NOT NULL,
    "VIS_Duty" VARCHAR(20)   NOT NULL,
    "VIS_Taxis" INT,
    "VIS_Memo" VARCHAR(100),
    PRIMARY KEY("VIS_ID")
);

CREATE TABLE "SM_AuthUnitGroup" (
    "AUG_GroupID" VARCHAR(20)   NOT NULL,
    "AUG_GroupName" VARCHAR(20),
    "AUG_AccessControl" VARCHAR(100),
    "AUG_ModuleID" VARCHAR(20),
    PRIMARY KEY("AUG_GroupID")
);

CREATE TABLE "SM_BasicAuthUnit" (
    "BAU_UnitID" VARCHAR(20)   NOT NULL,
    "BAU_UnitName" VARCHAR(20),
    "BAU_ModuleID" VARCHAR(20)
);

CREATE TABLE "SM_DataAuthInfo" (
    "DAI_Index" VARCHAR(20)   NOT NULL,
    "DAI_MasterRoleID" VARCHAR(20),
    "DAI_ClientRoleID" VARCHAR(20),
    "DAI_BasicUnitID" VARCHAR(20),
    "DAI_OperationType" VARCHAR(20),
    "DAI_OperationValue" VARCHAR(20),
    PRIMARY KEY("DAI_Index")
);

CREATE TABLE "SM_DataAuthRole" (
    "DAR_RoleID" VARCHAR(20)   NOT NULL,
    "DAR_RoleName" VARCHAR(20),
    "DAR_UserGroupID" VARCHAR(20),
    "DAR_DeptID" VARCHAR(20),
    "DAR_AccessControl" LONGVARCHAR   NOT NULL,
    PRIMARY KEY("DAR_RoleID")
);

CREATE TABLE "SM_DepartmentInfo" (
    "DI_DepartmentID" VARCHAR(20)   NOT NULL,
    "DI_DepartmentName" VARCHAR(20),
    PRIMARY KEY("DI_DepartmentID")
);

CREATE TABLE "SM_ModuleInfo" (
    "MI_ModuleID" VARCHAR(20)   NOT NULL,
    "MI_ModuleName" VARCHAR(20),
    PRIMARY KEY("MI_ModuleID")
);

CREATE TABLE "SM_OperationInfo" (
    "OI_Index" VARCHAR(20)   NOT NULL,
    "OI_UserID" VARCHAR(20),
    "OI_Time" TIMESTAMP,
    "OI_IP" VARCHAR(20),
    "OI_OperationRecord" VARCHAR(100),
    "OI_Common" VARCHAR(100),
    PRIMARY KEY("OI_Index")
);

CREATE TABLE "SM_Unitoption" (
    "UNIT_ID" INT  DEFAULT 0 NOT NULL,
    "UNIT_Name" VARCHAR(20),
    "UNIT_OptionID" INT  DEFAULT 0 NOT NULL,
    "UNIT_OptionName" VARCHAR(20),
    "UNIT_OptionStatus" INT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("UNIT_ID","UNIT_OptionID")
);

CREATE TABLE "SM_UserGroupInfo" (
    "UGI_UserGroupID" VARCHAR(20)   NOT NULL,
    "UGI_UserGroupName" VARCHAR(20),
    "UGI_AccessControl" LONGVARCHAR   NOT NULL,
    "UGI_DepartmentID" VARCHAR(20),
    PRIMARY KEY("UGI_UserGroupID")
);

CREATE TABLE "SM_UserInfo" (
    "UI_UserID" VARCHAR(20)   NOT NULL,
    "UI_UserName" VARCHAR(20),
    "UI_Password" VARCHAR(24),
    "UI_AccessControl" LONGVARCHAR   NOT NULL,
    "UI_IP" VARCHAR(20),
    "UI_RoleID" VARCHAR(20),
    "UI_PrivateKey" LONGVARCHAR   NOT NULL,
    "UI_PublicKey" LONGVARCHAR   NOT NULL,
    PRIMARY KEY("UI_UserID")
);

CREATE TABLE "SM_UserLogInfo" (
    "ULI_Index" VARCHAR(20)   NOT NULL,
    "ULI_UserID" VARCHAR(20),
    "ULI_Time" TIMESTAMP,
    "ULI_IP" VARCHAR(20),
    "ULI_Common" VARCHAR(100),
    PRIMARY KEY("ULI_Index")
);

CREATE TABLE "TA_ApplyDEAim" (
    "A_ApplyID" BIGINT  DEFAULT 0 NOT NULL,
    "A_ApplyName" LONGVARCHAR   NOT NULL,
    "A_ApplyRecycle" LONGVARCHAR,
    "A_ApplyQuarlity" LONGVARCHAR,
    "A_ApplyCost" VARCHAR(50),
    "D_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "P_Code" VARCHAR(50),
    "A_ApplyDelete" CHAR(1),
    PRIMARY KEY("A_ApplyID")
);

CREATE TABLE "TA_ApplyDEPlan" (
    "P_ApplyID" BIGINT  DEFAULT 0 NOT NULL,
    "P_ApplyDate" DATE,
    "P_ApplyStartDate" DATE DEFAULT '1900-01-01' NOT NULL,
    "P_ApplyGrade" BIGINT,
    "P_ApplyBrief" LONGVARCHAR,
    "P_ApplyDetail" LONGVARCHAR,
    "P_ApplyChargeMan" VARCHAR(20),
    "P_ApplyMemo" LONGVARCHAR,
    "D_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "P_Code" VARCHAR(50),
    "P_ApplyDelete" CHAR(1),
    PRIMARY KEY("P_ApplyID")
);

CREATE TABLE "TA_ApplyDetail" (
    "AD_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "AD_Topic" VARCHAR(100)   NOT NULL,
    "AD_Content" LONGVARCHAR   NOT NULL,
    "AD_Begin" DATE  DEFAULT '1900-01-01' NOT NULL,
    "AD_End" DATE  DEFAULT '1900-01-01' NOT NULL,
    "User_ID" VARCHAR(20)   NOT NULL,
    "Dept_ID" VARCHAR(20)   NOT NULL,
    "AD_Memo" LONGVARCHAR,
    "AD_Importance" VARCHAR(20)   NOT NULL,
    "P_Code" VARCHAR(50)  DEFAULT '0' NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "AD_ManagerID" VARCHAR(20),
    "AD_ManagerName" VARCHAR(20),
    "AD_IntendPerson" LONGVARCHAR,
    "AD_WantMoney" FLOAT  DEFAULT 0.0 NOT NULL,
    "AD_PreMoney" FLOAT  DEFAULT 0.0 NOT NULL,
    "AD_ContactMoney" FLOAT  DEFAULT 0.0 NOT NULL,
    "AD_AidPerson" VARCHAR(20),
    "AD_ApplyUser" BIGINT  DEFAULT 0 NOT NULL,
    "AD_ApplyTime" TIMESTAMP,
    "AD_Approved" CHAR(1),
    "AD_ApproveTime" TIMESTAMP,
    "A_Topic" VARCHAR(255),
    PRIMARY KEY("AD_Serial")
);

CREATE TABLE "TA_ApprovalAccessories" (
    "AA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AA_DetailID" BIGINT  DEFAULT 0 NOT NULL,
    "AA_FileName" VARCHAR(50)   NOT NULL,
    "AA_Code" VARCHAR(50)   NOT NULL,
    PRIMARY KEY("AA_ID")
);

CREATE TABLE "TA_ApprovalFlowAction" (
    "FA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "FA_Name" VARCHAR(50)   NOT NULL,
    "FA_FlowID" BIGINT  DEFAULT 0 NOT NULL,
    "FA_Flag" CHAR(1),
    "FA_Roles" LONGVARCHAR,
    "FA_Type" TINYINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("FA_ID")
);

CREATE TABLE "TA_ApprovalTransfer" (
    "AT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AT_DetailID" BIGINT  DEFAULT 0 NOT NULL,
    "AT_ActionID" BIGINT  DEFAULT 0 NOT NULL,
    "AT_ApproverID" VARCHAR(20)   NOT NULL,
    "AT_ApproveDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "AT_ApproveMind" VARCHAR(255),
    "AT_Finished" CHAR(1)   NOT NULL,
    "AT_ApplierID" VARCHAR(20)   NOT NULL,
    PRIMARY KEY("AT_ID")
);

CREATE TABLE "TA_DEAim" (
    "A_ID" BIGINT  DEFAULT 0 NOT NULL,
    "A_Name" LONGVARCHAR   NOT NULL,
    "A_Recycle" LONGVARCHAR,
    "A_Quarlity" LONGVARCHAR,
    "A_Cost" VARCHAR(50),
    "D_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "P_Code" VARCHAR(50),
    "A_Delete" CHAR(1),
    PRIMARY KEY("A_ID")
);

CREATE TABLE "TA_DEAttach" (
    "A_ID" BIGINT  DEFAULT 0 NOT NULL,
    "A_Name" VARCHAR(100),
    "A_Content" BLOB,
    "A_Size" BIGINT,
    "A_Date" DATE,
    "D_Serial" VARCHAR(50)  DEFAULT '0' NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "P_Code" VARCHAR(50),
    "A_Delete" CHAR(1),
    PRIMARY KEY("A_ID")
);

CREATE TABLE "TA_DEPlan" (
    "P_ID" BIGINT  DEFAULT 0 NOT NULL,
    "P_StartDate" DATE DEFAULT '1900-01-01' NOT NULL,
    "P_Date" DATE,      
    "P_Grade" BIGINT,
    "P_Brief" LONGVARCHAR,
    "P_Detail" LONGVARCHAR,
    "P_ChargeMan" VARCHAR(20),
    "P_Memo" LONGVARCHAR,
    "D_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "P_Code" VARCHAR(50),