dmkrm.sql

tomcat最新安装程序

    "P_Delete" CHAR(1),
    "P_Check" TINYINT DEFAULT 0,
    PRIMARY KEY("P_ID")
);

CREATE TABLE "TA_DEProblem" (
    "P_ID" BIGINT  DEFAULT 0 NOT NULL,
    "P_Title" LONGVARCHAR,
    "P_Content" LONGVARCHAR,
    "P_SendDate" DATE,
    "P_Reply" LONGVARCHAR,
    "P_ReplyDate" DATE,
    "P_CT" VARCHAR(20),
    "D_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "P_Code" VARCHAR(50),
    "P_Delete" CHAR(1),
    "Create_UserID" VARCHAR(20)   NOT NULL,
    "Reply_UserID" VARCHAR(20)   NOT NULL,
    "Flow_ID" BIGINT  DEFAULT 0 NOT NULL,
    "Action_ID" BIGINT  DEFAULT 0 NOT NULL,
    "P_Type" CHAR(1),
    PRIMARY KEY("P_ID")
);

CREATE TABLE "TA_DEProccess" (
    "P_ID" BIGINT  DEFAULT 0 NOT NULL,
    "P_FinishDate" DATE,
    "P_Brief" LONGVARCHAR,
    "P_Desc" LONGVARCHAR,
    "P_Memo" LONGVARCHAR,
    "D_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "P_Code" VARCHAR(50),
    "P_Delete" CHAR(1),
    PRIMARY KEY("P_ID")
);

CREATE TABLE "TA_DeInforAttachment" (
    "DI_AttachmentID" BIGINT  DEFAULT 0 NOT NULL,
    "DI_AttachmentName" VARCHAR(60)   NOT NULL,
    "DI_AttachmentPath" VARCHAR(60)   NOT NULL,
    "A_TypeID" BIGINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("DI_AttachmentID")
);

CREATE TABLE "TA_Detail" (
    "D_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "D_Topic" VARCHAR(100)   NOT NULL,
    "D_Content" LONGVARCHAR   NOT NULL,
    "D_Begin" DATE  DEFAULT '1900-01-01' NOT NULL,
    "D_End" DATE  DEFAULT '1900-01-01' NOT NULL,
    "User_ID" VARCHAR(20)   NOT NULL,
    "Dept_ID" VARCHAR(20)   NOT NULL,
    "D_Distribution" VARCHAR(50),
    "P_Content" LONGVARCHAR,
    "D_Process" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "D_IsDistribute" CHAR(1)  DEFAULT 'n',
    "D_IsAccept" CHAR(1)  DEFAULT 'n',
    "D_IsCheck" CHAR(1)  DEFAULT 'n',
    "D_IsLookcCheck" CHAR(1)  DEFAULT 'n',
    "D_FinishTime" DATE  DEFAULT '1900-01-01',
    "D_Conlusion" VARCHAR(100),
    "D_IsImport" CHAR(1),
    "D_Memo" LONGVARCHAR,
    "D_Importance" VARCHAR(20)   NOT NULL,
    "D_ImportTime" DATE  DEFAULT '1900-01-01',
    "P_Code" VARCHAR(50)  DEFAULT '0' NOT NULL,
    "D_IsWeek" CHAR(1),
    "D_Cancellation" CHAR(1),
    "D_CheckContent" LONGVARCHAR,
    "A_Serial" VARCHAR(50),
    "P_Serial" VARCHAR(50),
    "D_Num" VARCHAR(20),
    "D_IntendPerson" LONGVARCHAR,
    "D_SelfExplainMark" VARCHAR(10)  DEFAULT '0%',
    "D_PublicExplainMark" VARCHAR(10)  DEFAULT '0%',
    "D_WantMoney" FLOAT  DEFAULT 0.0000,
    "D_PreMoney" FLOAT,
    "D_ContactMoney" FLOAT,
    "D_Mark" VARCHAR(10),
    "D_AidPerson" VARCHAR(20),
    "D_ManagerID" VARCHAR(20),
    "D_ManagerName" VARCHAR(20),
    "D_Income" FLOAT  DEFAULT 0.0000,
    "D_yingzhi" FLOAT  DEFAULT 0.0000,
    "D_Goalcount" BIGINT  DEFAULT 0,
    "D_Plancount" BIGINT  DEFAULT 0,
    PRIMARY KEY("D_Serial")
);

CREATE TABLE "TA_MonthCheck" (
    "mpid" INT  DEFAULT 0 NOT NULL,
    "mp_num" VARCHAR(20),
    "mp_mission" LONGVARCHAR   NOT NULL,
    "mp_user" VARCHAR(100),
    "mp_overtime" VARCHAR(40),
    "mp_overcircs" LONGVARCHAR,
    "insert_time" DATE  DEFAULT '1900-01-01',
    "update_time" DATE  DEFAULT '1900-01-01',
    "uid" INT  DEFAULT 0,
    "username" VARCHAR(40),
    "mp_dept" VARCHAR(20),
    "class" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "plan_year" VARCHAR(4),
    "plan_mon" CHAR(2),
    "plan_time" VARCHAR(40),
    "dept_charge" VARCHAR(50),
    "dept_self" LONGVARCHAR,
    "checkmonth" LONGVARCHAR,
    "leadercheck" LONGVARCHAR,
    PRIMARY KEY("mpid")
);

CREATE TABLE "TA_NENews" (
    "N_ID" BIGINT  DEFAULT 0 NOT NULL,
    "N_HappenDate" DATE,
    "N_Content" LONGVARCHAR,
    "D_Serial" VARCHAR(50),
    "N_Cancellation" CHAR(1),
    "W_ID" BIGINT,
    PRIMARY KEY("N_ID")
);

CREATE TABLE "TA_NEWeekImport" (
    "W_ID" BIGINT  DEFAULT 0 NOT NULL,
    "User_ID" VARCHAR(20),
    "W_Content" LONGVARCHAR,
    "W_Import" CHAR(1),
    "D_Serial" VARCHAR(50),
    "W_Cancellation" CHAR(1),
    "W_Date" DATE,
    PRIMARY KEY("W_ID")
);

CREATE TABLE "TA_Plan" (
    "P_Code" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "P_Content" LONGVARCHAR,
    "P_Topic" VARCHAR(100)   NOT NULL,
    "P_MakeMan" VARCHAR(20)   NOT NULL,
    "P_Dept" VARCHAR(20)   NOT NULL,
    "P_Process" VARCHAR(50)   NOT NULL,
    "P_Importance" VARCHAR(20)   NOT NULL,
    "P_Serial" VARCHAR(50),
    "A_Serial" VARCHAR(50),
    "P_Cancellation" CHAR(1),
    "P_PlanTopic" VARCHAR(100),
    PRIMARY KEY("P_Code")
);

CREATE TABLE "TA_Project" (
    "P_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "P_Topic" VARCHAR(100)   NOT NULL,
    "A_Topic" VARCHAR(100)   NOT NULL,
    "P_MakeMan" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "P_MainDept" VARCHAR(20)   NOT NULL,
    "P_OtherDept" LONGVARCHAR   NOT NULL,
    "P_Process" VARCHAR(50)   NOT NULL,
    "P_Importance" VARCHAR(20)   NOT NULL,
    "A_Serial" VARCHAR(50),
    "P_Cancellation" CHAR(1),
    PRIMARY KEY("P_Serial")
);

CREATE TABLE "TA_ReplyEndAction" (
    "EA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "EA_FlowID" BIGINT  DEFAULT 0 NOT NULL,
    "EA_ActionID" BIGINT  DEFAULT 0 NOT NULL,
    "EA_Flag" BIGINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("EA_ID")
);

CREATE TABLE "TA_ReplyFlow" (
    "RF_ID" BIGINT  DEFAULT 0 NOT NULL,
    "RF_Name" VARCHAR(50)   NOT NULL,
    "RF_Flag" CHAR(1)  DEFAULT '0' NOT NULL,
    PRIMARY KEY("RF_ID")
);

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

CREATE TABLE "TA_ReplyTransfer" (
    "RT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "RT_PID" BIGINT  DEFAULT 0 NOT NULL,
    "RT_CreateUserID" VARCHAR(20)   NOT NULL,
    "RT_ActionID" BIGINT  DEFAULT 0 NOT NULL,
    "RT_ReplyerID" VARCHAR(20)   NOT NULL,
    "RT_ReplyDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "RT_ReplyMind" LONGVARCHAR,
    "RT_Finished" CHAR(1)   NOT NULL,
    "RT_ApplyUserID" VARCHAR(20)   NOT NULL,
    "RT_Type" CHAR(1),
    PRIMARY KEY("RT_ID")
);


CREATE TABLE "TA_TaskActivity" (
    "TA_ID" BIGINT   NOT NULL,
    "TA_TaskID" BIGINT   NOT NULL,
    "TA_Name" VARCHAR(100)   NOT NULL,
    "TA_Content" VARCHAR(255)   NOT NULL,
    "TA_Place" VARCHAR(100),
"TA_ExecutorID" VARCHAR(255),
"TA_Executor" VARCHAR(255),
    "TA_Date" DATE   NOT NULL,
    "TA_StartTime" VARCHAR(10)   NOT NULL,
    "TA_EndTime" VARCHAR(10)   NOT NULL,
    "TA_UserID" BIGINT   NOT NULL,
    PRIMARY KEY("TA_ID")
);

CREATE TABLE "TA_TaskCheck" 
(
"TC_ID" BIGINT NOT NULL,
"TC_TaskID" BIGINT NOT NULL,
"TC_Process" TINYINT,
"TC_Date" DATE NOT NULL,
"TC_Remark" VARCHAR(255),
"TC_CheckerID" BIGINT NOT NULL,
"TC_Checker" VARCHAR(10) NOT NULL,
"TC_CheckDate" DATE,
"TC_CheckMemo" VARCHAR(255),
"TC_Flag" 
VARCHAR(20),
PRIMARY KEY("TC_ID")
);

CREATE TABLE "TA_TaskFileAttach" (
    "TFA_ID" BIGINT   NOT NULL,
    "TFA_TaskID" BIGINT   NOT NULL,
    "TFA_FileName" VARCHAR(50)   NOT NULL,
    "TFA_Code" VARCHAR(50)   NOT NULL,
    PRIMARY KEY("TFA_ID")
);

CREATE TABLE "TA_TaskImportance" (
    "ID_ID" BIGINT   NOT NULL,
    "ID_Name" VARCHAR(20),
    PRIMARY KEY("ID_ID")
);

CREATE TABLE "TA_TaskInfo" 
(
"TI_ID" BIGINT NOT NULL,
"TI_Num" VARCHAR(20) NOT NULL,
"TI_Name" VARCHAR(100) NOT NULL,
"TI_Content" LONGVARCHAR NOT NULL,
"TI_SelfProcess" TINYINT NOT NULL,
"TI_CheckProcess" TINYINT NOT NULL,
"TI_Type" VARCHAR(20) NOT NULL,
"TI_Urgence" VARCHAR(20) NOT NULL,
"TI_Importance" VARCHAR(20) NOT NULL,
"TI_StartDate" DATE DEFAULT '1900-01-01' NOT NULL,
"TI_EndDate" DATE DEFAULT '1900-01-01' NOT NULL,
"TI_DeptID" BIGINT NOT NULL,
"TI_DeptName" VARCHAR(50) NOT NULL,
"TI_PrincipalID" BIGINT NOT NULL,
"TI_Principal" VARCHAR(10) NOT NULL,
"TI_AttendeeID" VARCHAR(255),
"TI_Attendee" VARCHAR(255),
"TI_UserID" BIGINT NOT NULL,
"TI_UserName" VARCHAR(10) NOT NULL,
"TI_Date" TIMESTAMP(6) DEFAULT '1900-01-01 00:00:00' NOT NULL,
"TI_AppraiserID" BIGINT,
"TI_Appraiser" VARCHAR(10),
"TI_AppraiseMark" INTEGER,
"TI_AppraiseMind" VARCHAR(255),
"TI_AppraiseDate" DATE,
"TI_CheckerID" BIGINT NOT NULL,
"TI_Checker" VARCHAR(10) NOT NULL,
"TI_CheckDate" DATE,
"TI_CheckResult" CHAR(1),
"TI_CheckMind" VARCHAR(255),
"TI_RecheckerID" BIGINT,
"TI_Rechecker" VARCHAR(10),
"TI_RecheckDate" DATE,
"TI_RecheckMind" VARCHAR(255),
"TI_RecheckMark" INTEGER,
"TI_Status" CHAR(1) NOT NULL,
"TI_ParentTaskID" BIGINT,
"TI_DetailID" BIGINT,
"TI_Kind" CHAR(1) NOT NULL,
"TI_TaskLevel" BIGINT,
"TI_TaskRoot" BIGINT,
"TI_TaskOrders" BIGINT,
PRIMARY KEY("TI_ID")
);

CREATE TABLE "TA_TaskLevel" (
    "O_ID" BIGINT,
    "O_Name" VARCHAR(20)
);

CREATE TABLE "TA_TaskPlanInfo" (
    "TPI_ID" BIGINT   NOT NULL,
    "TPI_TaskID" BIGINT   NOT NULL,
    "TPI_Title" VARCHAR(100)   NOT NULL,
    "TPI_Content" VARCHAR(255),
    "TPI_StartDate" DATE  DEFAULT '1900-01-01' NOT NULL,
    "TPI_EndDate" DATE  DEFAULT '1900-01-01' NOT NULL,
    "TPI_Date" DATE  DEFAULT '1900-01-01' NOT NULL,
    "TPI_UserID" BIGINT   NOT NULL,
    "TPI_UserName" VARCHAR(50) NOT NULL,
    PRIMARY KEY("TPI_ID")    
);

CREATE TABLE "TA_TaskProcess" (
    "TP_ID" BIGINT   NOT NULL,
    "TP_TaskID" BIGINT   NOT NULL,
    "TP_Process" TINYINT   NOT NULL,
    "TP_Remark" VARCHAR(255)   NOT NULL,
    "TP_Date" DATE   NOT NULL,
    "TP_UserID" BIGINT   NOT NULL,
    PRIMARY KEY("TP_ID")
);

CREATE TABLE "TA_TaskSchedule" (
    "TS_ID" BIGINT   NOT NULL,
    "TS_TaskID" BIGINT   NOT NULL,
    "TS_Name" VARCHAR(100)   NOT NULL,
    "TS_Content" VARCHAR(255),
    "TS_ExecutorID" BIGINT   NOT NULL,
    "TS_Executor" VARCHAR(10)   NOT NULL,
    "TS_Date" DATE   NOT NULL,
    "TS_StartTime" VARCHAR(10)   NOT NULL,
    "TS_EndTime" VARCHAR(10)   NOT NULL,
    PRIMARY KEY("TS_ID")
);
CREATE TABLE "TA_TaskType" (
    "TT_ID" BIGINT   NOT NULL,
    "TT_Name" VARCHAR(20)   NOT NULL,
    "TT_Symbol" VARCHAR(20)   NOT NULL,
    PRIMARY KEY("TT_ID")
);
CREATE TABLE "TA_TaskUrgence" (
    "UD_ID" BIGINT   NOT NULL,
    "UD_Name" VARCHAR(20)   NOT NULL,
    PRIMARY KEY("UD_ID")
);

CREATE TABLE "TA_YearAim" (
    "A_Serial" VARCHAR(50)  DEFAULT 0 NOT NULL,
    "A_Topic" VARCHAR(100)   NOT NULL,
    "A_Year" VARCHAR(5)   NOT NULL,
    "A_OperatePeroid" VARCHAR(50)   NOT NULL,
    "A_IsProject" CHAR(1)   NOT NULL,
    "A_Cancellation" CHAR(1),
    "A_Content" LONGVARCHAR,
    "A_Person" VARCHAR(20)   NOT NULL,
    PRIMARY KEY("A_Serial")
);

CREATE TABLE "TypeID" (
    "ID" BIGINT  DEFAULT 0 NOT NULL,
    "ID_type" VARCHAR(20),
    "ID_Num" BIGINT DEFAULT 1 NOT NULL,
    PRIMARY KEY("ID")
);

CREATE TABLE "U_TotalDiary" (
    "User_ID" VARCHAR(20),
    "I_Name" VARCHAR(20),
    "Total_Date" DATE,
    "Dept_Name" VARCHAR(20)
);

CREATE TABLE "VM_InsuranceInfo" (
    "II_Index" VARCHAR(20)   NOT NULL,
    "II_UserID" VARCHAR(20),
    "II_VehicleID" VARCHAR(20),
    "II_Time" DATE,
    "II_Item" VARCHAR(50),
    "II_Company" VARCHAR(100),
    "II_Money" BIGINT,
    "II_Comment" LONGVARCHAR,
    PRIMARY KEY("II_Index")
);

CREATE TABLE "VM_MaintenanceInfo" (
    "MI_Index" VARCHAR(20)   NOT NULL,
    "MI_UserID" VARCHAR(20),
    "MI_VehicleID" VARCHAR(20),
    "MI_Time" DATE,
    "MI_Item" VARCHAR(50),
    "MI_Factory" VARCHAR(100),