dmkrm.sql

tomcat最新安装程序

    "FA_Roles" LONGVARCHAR,
    PRIMARY KEY("FA_ID")
);

CREATE TABLE "FM_ApprovalKind" (
    "AK_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AK_Name" VARCHAR(50)   NOT NULL,
    "AK_Flag" CHAR(1),
    "AK_Loan" CHAR(1)  DEFAULT 0,
    "AK_Stat" CHAR(1)  DEFAULT 1 NOT NULL,
    PRIMARY KEY("AK_ID")
);

CREATE TABLE "FM_ApprovalTransfer" (
    "AT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AT_AcountID" 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 "FM_ExpenseAccountInfo" (
    "EI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "EI_UserID" VARCHAR(20)   NOT NULL,
    "EI_DeptID" VARCHAR(20)   NOT NULL,
    "EI_FlowID" BIGINT  DEFAULT 0 NOT NULL,
    "EI_ItemID" BIGINT  DEFAULT 0 NOT NULL,
    "EI_ApprovalKindID" BIGINT  DEFAULT 0 NOT NULL,
    "EI_ApplyDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "EI_ApproveDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "EI_MoneySum" FLOAT  DEFAULT 0.00 NOT NULL,
    "EI_BillSum" INT  DEFAULT 0 NOT NULL,
    "EI_Approved" CHAR(1)  DEFAULT '0' NOT NULL,
    "EI_ItemName" VARCHAR(100),
    "EI_SerialNum" BIGINT  DEFAULT 0 NOT NULL,
    "EI_Flag" CHAR(1)  DEFAULT '0',
    "EI_ProcessDate" TIMESTAMP,
    "EI_Status" CHAR(1)  DEFAULT '0',
    PRIMARY KEY("EI_ID")
);

CREATE TABLE "FM_ExpenseType" (
    "ET_ID" BIGINT  DEFAULT 0 NOT NULL,
    "ET_Name" VARCHAR(50)   NOT NULL,
    "ET_Flag" TINYINT,
    PRIMARY KEY("ET_ID")
);

CREATE TABLE "FM_FlowActionRelation" (
    "FAR_ID" BIGINT  DEFAULT 0 NOT NULL,
    "FAR_PreActionID" BIGINT  DEFAULT 0 NOT NULL,
    "FAR_NextActionID" BIGINT  DEFAULT 0 NOT NULL,
    "FAR_FlowID" BIGINT  DEFAULT 0 NOT NULL,
    "FAR_PreActionName" VARCHAR(50)   NOT NULL,
    "FAR_NextActionName" VARCHAR(50)   NOT NULL,
    PRIMARY KEY("FAR_ID")
);

CREATE TABLE "FM_IncomePast" (
    "IP_ID" BIGINT  DEFAULT 0 NOT NULL,
    "IP_TaskID" BIGINT  DEFAULT 0 NOT NULL,
    "IP_TaskName" VARCHAR(100)   NOT NULL,
    "IP_Money" FLOAT  DEFAULT 0.00 NOT NULL,
    "IP_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "IP_Handler" BIGINT  DEFAULT 0 NOT NULL,
    "IP_Remark" VARCHAR(255),
    PRIMARY KEY("IP_ID")
);

CREATE TABLE "FM_LoanInfo" (
    "LI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "LI_UserID" BIGINT  DEFAULT 0 NOT NULL,
    "LI_Money" FLOAT  DEFAULT 0.00 NOT NULL,
    "LI_Date" DATE  DEFAULT '1900-01-01' NOT NULL,
    "LI_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    "LI_AccountID" BIGINT  DEFAULT 0 NOT NULL,
    "LI_TaskName" VARCHAR(100)   NOT NULL,
    "LI_SerialNum" BIGINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("LI_ID")
);

CREATE TABLE "FM_ProcessInfo" (
    "PI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "PI_AccountID" BIGINT  DEFAULT 0 NOT NULL,
    "PI_TaskID" BIGINT  DEFAULT 0 NOT NULL,
    "PI_Money" FLOAT  DEFAULT 0.00 NOT NULL,
    "PI_Payout" CHAR(1)   NOT NULL,
    "PI_Standoff" CHAR(1)   NOT NULL,
    "PI_Remark" VARCHAR(255),
    "PI_AppKind" BIGINT  DEFAULT 0 NOT NULL,
    "PI_ApproveDate" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    PRIMARY KEY("PI_ID")
);

CREATE TABLE "FM_ReportData" (
    "RD_ID" BIGINT  DEFAULT 0 NOT NULL,
    "RD_Date" DATE  DEFAULT '1900-01-01' NOT NULL,
    "RD_PreBudget" FLOAT  DEFAULT 0,
    "RD_AddBudget" FLOAT  DEFAULT 0,
    "RD_Pexpence" FLOAT  DEFAULT 0,
    "RD_Hexpence" FLOAT  DEFAULT 0,
    "RD_Rexpence" FLOAT  DEFAULT 0,
    "RD_Analysis" LONGVARCHAR,
    PRIMARY KEY("RD_ID","RD_Date")
);

CREATE TABLE "FM_TaskIncome" (
    "TI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TI_TaskID" BIGINT  DEFAULT 0 NOT NULL,
    "TI_TaskName" VARCHAR(100)   NOT NULL,
    "TI_Money" FLOAT  DEFAULT 0.00 NOT NULL,
    "TI_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "TI_Handler" BIGINT  DEFAULT 0 NOT NULL,
    "TI_Remark" VARCHAR(255),
    PRIMARY KEY("TI_ID")
);

CREATE TABLE "Feast_Date" (
    "Feast_ID" VARCHAR(10),
    "Feast_Name" VARCHAR(20),
    "Feast_Date" DATE
);

CREATE TABLE "GM_TimeBook" (
    "TIM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TIM_start" TIME  DEFAULT '00:00:00' NOT NULL,
    "TIM_end" TIME  DEFAULT '00:00:00' NOT NULL,
    "TIM_dateStart" DATE  DEFAULT '1900-01-01' NOT NULL,
    "TIM_dateEnd" DATE,
    "TIM_delSign" CHAR(1)   NOT NULL,
    PRIMARY KEY("TIM_ID")
);

CREATE TABLE "GM_TimeOutGoing" (
    "OUT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "User_ID" VARCHAR(20)   NOT NULL,
    "OUT_start" DATE  DEFAULT '1900-01-01' NOT NULL,
    "OUT_end" DATE  DEFAULT '1900-01-01' NOT NULL,
    "OUT_type" VARCHAR(4)   NOT NULL,
    "OUT_content" VARCHAR(20)   NOT NULL,
    "OUT_memo" LONGVARCHAR,
    PRIMARY KEY("OUT_ID")
);

CREATE TABLE "GM_TimeRecord" (
    "REC_ID" BIGINT  DEFAULT 0 NOT NULL,
    "User_ID" VARCHAR(20)   NOT NULL,
    "REC_date" DATE  DEFAULT '1900-01-01' NOT NULL,
    "REC_amArrive" TIME,
    "REC_amLeave" TIME,
    "REC_pmArrive" TIME,
    "REC_pmLeave" TIME,
    "REC_nightArrive" TIME,
    "REC_nightLeave" TIME,
    PRIMARY KEY("REC_ID")
);

CREATE TABLE "KM_RecordAttachment" (
    "RA_AttachmentName" VARCHAR(200)   NOT NULL,
    "RA_AttachmentPath" VARCHAR(200)   NOT NULL,
    "RA_AttachmentID" BIGINT  DEFAULT 0 NOT NULL,
    "RI_ID" BIGINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("RA_AttachmentID")
);

CREATE TABLE "KM_RecordGroupInfo" (
    "RGI_GroupInfo" CHAR(2)  DEFAULT '1' NOT NULL,
    "RGI_CategoryName" VARCHAR(40)   NOT NULL,
    "RGI_CategoryID" BIGINT  DEFAULT 0 NOT NULL,
    "RGI_CategoryDescrible" VARCHAR(200),
    "RGI_CategoryBelong" VARCHAR(4)  DEFAULT 'in' NOT NULL,
    PRIMARY KEY("RGI_CategoryID")
);

CREATE TABLE "KM_RecordInfo" (
    "RI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "RI_RecordNumber" VARCHAR(20)   NOT NULL,
    "RI_RecordName" VARCHAR(80)   NOT NULL,
    "RI_PublishTime" DATE  DEFAULT '1900-01-01' NOT NULL,
    "RI_PublishCompany" VARCHAR(60),
    "RI_RegisterTime" DATE  DEFAULT '1900-01-01' NOT NULL,
    "RI_Comment" VARCHAR(200),
    "RGI_CategoryID" BIGINT  DEFAULT 0 NOT NULL,
    "RI_Transfer" BIGINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("RI_ID","RI_RecordNumber")
);

CREATE TABLE "MM_MeetingApprovation" (
    "MM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MA_Reason" LONGVARCHAR,
    "MA_Leader" VARCHAR(100),
    "MA_LeaderID" BIGINT,
    "MA_Advice" LONGVARCHAR,
    "MA_Document" LONGVARCHAR,
    "MA_Time" TIMESTAMP,
    "MA_Applicant" VARCHAR(100),
    "MA_ApplicantID" BIGINT,
    PRIMARY KEY("MM_ID")
);

CREATE TABLE "MM_MeetingDetail" (
    "MM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MD_Name" VARCHAR(200)   NOT NULL,
    "MD_Subject" VARCHAR(200),
    "MD_PreAddress" VARCHAR(200),
    "MD_PreTime" TIMESTAMP,
    "MD_Attendance" LONGVARCHAR,
    "MD_Record" LONGVARCHAR,
    "MD_Address" LONGVARCHAR,
    "MD_BeginTime" TIMESTAMP,
    "MD_EndTime" TIMESTAMP,
    "MD_Master" VARCHAR(100),
    "MD_MasterID" BIGINT,
    "MD_Recorder" VARCHAR(100),
    "MD_RecorderID" BIGINT,
    "MD_IsOpen" CHAR(1)  DEFAULT 0,
    PRIMARY KEY("MM_ID","MD_Name")
);

CREATE TABLE "MM_MeetingInform" (
    "MM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MI_InfoTime" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "MI_SendUser" VARCHAR(20)   NOT NULL,
    "MI_MeetTime" TIMESTAMP,
    "MI_MeetName" VARCHAR(200),
    "MI_MeetSubject" VARCHAR(200),
    "MI_MeetAddress" VARCHAR(200),
    "MI_IsValid" CHAR(1)  DEFAULT '1',
    PRIMARY KEY("MM_ID","MI_InfoTime")
);

CREATE TABLE "MM_MeetingPreparation" (
    "MM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MP_Leader" VARCHAR(100),
    "MP_LeaderID" BIGINT,
    "MP_Command" LONGVARCHAR,
    "MP_Person" VARCHAR(100),
    "MP_PersonID" BIGINT,
    "MP_Division" VARCHAR(200),
    PRIMARY KEY("MM_ID")
);

CREATE TABLE "MM_MeetingStaff" (
    "MM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MS_Person" VARCHAR(100)   NOT NULL,
    "MS_NoticeTime" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "MS_IsKnow" CHAR(1)  DEFAULT '0',
    "MS_IsLeave" CHAR(1)  DEFAULT '0',
    "MS_IsAttend" CHAR(1)  DEFAULT '0',
    "MS_LeftReason" LONGVARCHAR,
    PRIMARY KEY("MM_ID","MS_Person","MS_NoticeTime")
);

CREATE TABLE "MM_Netmeetinginform" (
    "NM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "NM_MeetMemo" LONGVARCHAR   NOT NULL,
    "NM_SendUser" VARCHAR(20)   NOT NULL,
    "NM_MeetTime" TIMESTAMP  DEFAULT '1900-01-01 00:00:00',
    "NM_MeetName" VARCHAR(200),
    "NM_MeetSubject" VARCHAR(200),
    "NM_MeetMen" LONGVARCHAR,
    "NM_IPAddress" VARCHAR(20),
    "NM_IsValid" CHAR(1)  DEFAULT '1',
    PRIMARY KEY("NM_ID")
);

CREATE TABLE "ObjectID" (
    "ID" BIGINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("ID")
);

CREATE TABLE "PE_Auth" (
    "A_ID" BIGINT,
    "A_Name" VARCHAR(20)
);

CREATE TABLE "PE_Authorization" (
    "A_ID" BIGINT  DEFAULT 0 NOT NULL,
    "Dept_ID" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "A_Career" BIGINT  DEFAULT 0 NOT NULL,
    "A_Admin" BIGINT  DEFAULT 0 NOT NULL,
    "A_RealDel" CHAR(1),
    PRIMARY KEY("A_ID")
);

CREATE TABLE "PE_Clan" (
    "C_ID" BIGINT,
    "C_Name" VARCHAR(20)
);

CREATE TABLE "PE_Degree" (
    "P_ID" BIGINT,
    "P_Degree" VARCHAR(20)
);

CREATE TABLE "PE_DeptInfo" (
    "Dept_ID" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "D_Name" VARCHAR(50)   NOT NULL,
    "D_Desc" LONGVARCHAR,
    "D_Sequency" BIGINT  DEFAULT 0 NOT NULL,
    "D_RealDel" CHAR(1),
    PRIMARY KEY("Dept_ID")
);

CREATE TABLE "PE_Folk" (
    "F_ID" BIGINT,
    "F_Name" VARCHAR(20)
);

CREATE TABLE "PE_Level" (
    "L_OccupID" BIGINT,
    "L_Occup" VARCHAR(20),
    "L_Sequency" BIGINT
);

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

CREATE TABLE "PE_Occupation" (
    "O_ID" BIGINT  DEFAULT 0 NOT NULL,
    "Dept_ID" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "L_OccupID" BIGINT  DEFAULT 0,
    "O_IsLeader" CHAR(1),
    "O_Total" BIGINT  DEFAULT 0,
    "O_RealDel" CHAR(1),
    "O_Sheng" BIGINT  DEFAULT 0,
    "O_TingLeader" BIGINT  DEFAULT 0,
    "O_TingNLeader" BIGINT  DEFAULT 0,
    "O_FTingLeader" BIGINT  DEFAULT 0,
    "O_FTingNLeader" BIGINT  DEFAULT 0,
    "O_ChuLeader" BIGINT  DEFAULT 0,
    "O_ChuNLeader" BIGINT  DEFAULT 0,
    "O_FChuLeader" BIGINT  DEFAULT 0,
    "O_FChuNLeader" BIGINT  DEFAULT 0,
    PRIMARY KEY("O_ID")
);

CREATE TABLE "PE_PersonImage" (
    "PE_ImageID" VARCHAR(20),
    "PE_Name" VARCHAR(20),
    "PE_ImageFile" VARCHAR(20)
);

CREATE TABLE "PE_PersonInfo"
(
    "User_ID" VARCHAR(20) DEFAULT '0' NOT NULL,
    "I_Name" VARCHAR(20) NOT NULL,
    "I_Sex" CHAR(2) NOT NULL,
    "I_Racil" VARCHAR(30) NOT NULL,
    "I_RacilName" VARCHAR(16),
    "I_Native" VARCHAR(40) NOT NULL,
    "Dept_ID" VARCHAR(20) NOT NULL,
    "L_OccupID" BIGINT DEFAULT 0 NOT NULL,
    "L_OccupName" VARCHAR(20),
    "O_ID" BIGINT DEFAULT 0 NOT NULL,
    "I_Born" DATE DEFAULT '1900-01-01' NOT NULL,
    "I_Party" VARCHAR(20),
    "I_PartyName" VARCHAR(20),
    "I_PartyDate" DATE,
    "I_WorkDate" DATE DEFAULT '1900-01-01' NOT NULL,
    "I_Education" VARCHAR(50),
    "I_EducationName" VARCHAR(12),
    "I_Graduate" VARCHAR(50),
    "I_Degree" VARCHAR(50),
    "I_DegreeName" VARCHAR(20),
    "I_LevelDate" DATE,
    "I_OccupyDate" DATE,
    "I_EnterDate" DATE DEFAULT '1900-01-01' NOT NULL,
    "I_Memo" LONGVARCHAR,
    "I_Sequency" BIGINT DEFAULT 0 NOT NULL,
    "I_Authorization" VARCHAR(50),
    "I_AuthorizationName" VARCHAR(20),
    "I_IsLeader" CHAR(1),
    "I_RealDel" CHAR(1),
    "I_Worker" CHAR(1) NOT NULL,
    "L_Name" VARCHAR(50),
    "I_Mobile" BIGINT DEFAULT 0,
    "I_IsRetire" CHAR(1) DEFAULT 'n',
    "I_IsNotUse" CHAR(1) DEFAULT 'n',
    "N_Addr" VARCHAR(100) DEFAULT ' ',
    "ISMarry" CHAR(1) DEFAULT '0',
    "I_PersonID" VARCHAR(18),
    "A_Addr" VARCHAR(100),
    "HousePhone" VARCHAR(15) DEFAULT '0',
    "Address" VARCHAR(100) DEFAULT ' ',
    "Degree" VARCHAR(8),
    "WorkMemo" TEXT,
    "UseStatus" CHAR(1) DEFAULT '1',