dmkrm.sql

tomcat最新安装程序

set current database krm;
CREATE TABLE "Birth_Card" (
    "User_Name" VARCHAR(20),
    "Send_UserName" VARCHAR(20),
    "Wish_Content" VARCHAR(200),
    "Create_Time" TIMESTAMP
);

CREATE TABLE "CM_AddressList" (
    "AL_ID" BIGINT  DEFAULT 0 NOT NULL,
    "ALT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AL_OwnerID" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "Dic_OccupID" LONGVARCHAR,
    "AL_Name" VARCHAR(20)   NOT NULL,
    "AL_Duty" VARCHAR(50),
    "AL_OfficeTel" VARCHAR(20),
    "AL_HomeTel" VARCHAR(20),
    "AL_MobileTel" VARCHAR(20),
    "AL_Mail" VARCHAR(50),
    "AL_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("AL_ID")
);

CREATE TABLE "CM_AddressListType" (
    "ALT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "ALT_Title" VARCHAR(50)   NOT NULL,
    "ALT_Owner" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "ALT_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("ALT_ID")
);

CREATE TABLE "CM_FileAccessories" (
    "FA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "FA_Flag" BIGINT  DEFAULT 0 NOT NULL,
    "FA_FileName" VARCHAR(50)   NOT NULL,
    "FA_Name" VARCHAR(50),
    "FA_Code" VARCHAR(10),
    "FA_Type" VARCHAR(50),
    "FA_Content" BLOB,
    PRIMARY KEY("FA_ID")
);

CREATE TABLE "CM_InformInfo" (
    "II_ID" BIGINT  DEFAULT 0 NOT NULL,
    "II_Title" VARCHAR(50)   NOT NULL,
    "IT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "II_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "II_SendID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "II_Sender" VARCHAR(20)   NOT NULL,
    "II_Accept" LONGVARCHAR   NOT NULL,
    "II_AcceptName" LONGVARCHAR,
    "II_Accepted" LONGVARCHAR,
    "II_AcceptedName" LONGVARCHAR,
    "II_Content" LONGVARCHAR,
    "II_Flag" CHAR(1)  DEFAULT '0' NOT NULL,
    "II_Accepting" LONGVARCHAR,
    PRIMARY KEY("II_ID")
);

CREATE TABLE "CM_InformType" (
    "IT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "IT_Title" VARCHAR(50)   NOT NULL,
    "IT_Memo" VARCHAR(200),
    "IT_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("IT_ID")
);

CREATE TABLE "CM_MailInfo" (
    "MI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MI_Title" VARCHAR(150)   NOT NULL,
    "MT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MI_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "MI_SendID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "MI_Sender" VARCHAR(20)   NOT NULL,
    "MI_Accept" LONGVARCHAR   NOT NULL,
    "MI_AcceptName" LONGVARCHAR,
    "MI_Accepted" LONGVARCHAR,
    "MI_AcceptedName" LONGVARCHAR,
    "MI_Content" LONGVARCHAR,
    "MI_Flag" CHAR(1)  DEFAULT '0' NOT NULL,
    PRIMARY KEY("MI_ID")
);

CREATE TABLE "CM_MailType" (
    "MT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "MT_Title" VARCHAR(50)   NOT NULL,
    "MT_Owner" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "MT_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("MT_ID")
);

CREATE TABLE "Card_File" (
    "UserName" VARCHAR(20),
    "Card_File" VARCHAR(20),
    "Card_Content" VARCHAR(60),
    "Birthday" DATE
);

CREATE TABLE "Card_Image" (
    "Card_ID" TINYINT,
    "Card_FileName" VARCHAR(20)
);

CREATE TABLE "DM_AcceptDocumentInfo" (
    "ADI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "ADI_Title" VARCHAR(100)   NOT NULL,
    "ADI_Secrecy" VARCHAR(20)   NOT NULL,
    "ADI_Urgent" VARCHAR(20)   NOT NULL,
    "ADI_TransactionType" VARCHAR(20)   NOT NULL,
    "ADI_SecrecyTime" VARCHAR(20)   NOT NULL,
    "ADI_SendOrgan" VARCHAR(100)   NOT NULL,
    "ADI_SendOrganFlag" VARCHAR(100),
    "ADI_OrganSeal" LONGVARCHAR,
    "ADI_Type" VARCHAR(20)   NOT NULL,
    "ADI_Kind" VARCHAR(20)   NOT NULL,
    "ADI_SN" VARCHAR(50)   NOT NULL,
    "ADI_Signer" VARCHAR(20)   NOT NULL,
    "ADI_SignerSeal" LONGVARCHAR,
    "ADI_FirstOrgan" VARCHAR(200)   NOT NULL,
    "ADI_SecondOrgan" VARCHAR(200),
    "ADI_ThirdOrgan" VARCHAR(200),
    "ADI_Content" LONGVARCHAR,
    "ADI_SubScrible" BLOB,
    "ADI_Date" DATE  DEFAULT '1900-01-01' NOT NULL,
    "ADI_Memo" LONGVARCHAR,
    "ADI_Theme" LONGVARCHAR,
    "ADI_PrintOrgan" VARCHAR(200),
    "ADI_PrintDate" DATE  DEFAULT '1900-01-01',
    "ADI_PrintPiece" BIGINT,
    "ADI_Pigeonhole" CHAR(1)  DEFAULT '0' NOT NULL,
    "ADI_AcceptDate" DATE  DEFAULT '1900-01-01' NOT NULL,
    PRIMARY KEY("ADI_ID")
);

CREATE TABLE "DM_AcceptRegister" (
    "AR_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AR_AcceptDate" DATE  DEFAULT '1900-01-01' NOT NULL,
    "AR_SN" VARCHAR(50)   NOT NULL,
    "CO_ID" VARCHAR(200)   NOT NULL,
    "DUD_ID" VARCHAR(20)   NOT NULL,
    "AR_TimeLimit" VARCHAR(20),
    "DSR_ID" VARCHAR(20)   NOT NULL,
    "ADI_ID" VARCHAR(20)   NOT NULL,
    "AR_Content" LONGVARCHAR,
    "AR_SendDate" TIMESTAMP,
    "AR_AcceptOrgan" VARCHAR(200),
    "AR_ReturnDate" TIMESTAMP,
    "AR_AccepterID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "AR_Accepter" VARCHAR(20)   NOT NULL,
    PRIMARY KEY("AR_ID")
);

CREATE TABLE "DM_ComeOrgan" (
    "CO_ID" BIGINT  DEFAULT 0 NOT NULL,
    "CO_Name" VARCHAR(50)   NOT NULL,
    "CO_SubjectionOrgan" VARCHAR(50)   NOT NULL,
    "OA_ID" BIGINT  DEFAULT 0,
    "CO_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("CO_ID")
);

CREATE TABLE "DM_DefaultMind" (
    "DM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DM_Name" VARCHAR(100)   NOT NULL,
    PRIMARY KEY("DM_ID")
);

CREATE TABLE "DM_DocAccessories" (
    "DA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DA_DocID" BIGINT  DEFAULT 0 NOT NULL,
    "DA_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    "DA_FileName" VARCHAR(200)   NOT NULL,
    "DA_Name" VARCHAR(200),
    "DA_Code" VARCHAR(50)   NOT NULL,
    "DA_Type" CHAR(1)   NOT NULL,
    PRIMARY KEY("DA_ID")
);

CREATE TABLE "DM_DocFlowName" (
    "DFN_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DFN_Doc" VARCHAR(10)   NOT NULL,
    "DFN_Name" VARCHAR(100)   NOT NULL,
    "DFN_Taxis" BIGINT  DEFAULT 0 NOT NULL,
    "FND_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DFN_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    "DFN_Modify" INT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("DFN_ID")
);

CREATE TABLE "DM_DocKind" (
    "DK_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DK_Name" VARCHAR(20)   NOT NULL,
    "DK_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("DK_ID")
);

CREATE TABLE "DM_DocPigeonhole" (
    "DP_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DP_DocID" BIGINT  DEFAULT 0 NOT NULL,
    "DP_Date" DATE  DEFAULT '1900-01-01' NOT NULL,
    "DP_Location" VARCHAR(255)  DEFAULT '0' NOT NULL,
    "DP_HandlersID" VARCHAR(20)   NOT NULL,
    "DP_Handlers" VARCHAR(20)   NOT NULL,
    "DP_Remark" VARCHAR(255)   NOT NULL,
    PRIMARY KEY("DP_ID")
);

CREATE TABLE "DM_DocSecrecyRank" (
    "DSR_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DSR_Name" VARCHAR(20)   NOT NULL,
    "DSR_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("DSR_ID")
);

CREATE TABLE "DM_DocTransactionType" (
    "DTT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DTT_Name" VARCHAR(20)   NOT NULL,
    "DTT_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("DTT_ID")
);

CREATE TABLE "DM_DocTransfer" (
    "DT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DT_Flag" CHAR(1)  DEFAULT '0' NOT NULL,
    "DT_DocID" BIGINT  DEFAULT 0 NOT NULL,
    "DFN_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DT_HandlersID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "DT_Handlers" VARCHAR(20)   NOT NULL,
    "DT_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "DT_Finish" CHAR(1)  DEFAULT '0' NOT NULL,
    "DT_NextHandlersID" BIGINT  DEFAULT 0 NOT NULL,
    "DT_NextHandlers" VARCHAR(20)   NOT NULL,
    "DT_TimeLimit" DATE,
    PRIMARY KEY("DT_ID")
);

CREATE TABLE "DM_DocType" (
    "DT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DT_Name" VARCHAR(20)   NOT NULL,
    "DT_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("DT_ID")
);

CREATE TABLE "DM_DocUrgentDegree" (
    "DUD_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DUD_Name" VARCHAR(20)   NOT NULL,
    "DUD_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("DUD_ID")
);

CREATE TABLE "DM_FlowNameDiscerner" (
    "FND_ID" BIGINT  DEFAULT 0 NOT NULL,
    "FND_Name" VARCHAR(20)   NOT NULL,
    PRIMARY KEY("FND_ID")
);

CREATE TABLE "DM_OrganAddress" (
    "OA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "OA_Province" VARCHAR(10),
    "OA_City" VARCHAR(10),
    "OA_County" VARCHAR(10),
    "OA_Street" VARCHAR(10),
    "OA_Doorplate" VARCHAR(10),
    "OA_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("OA_ID")
);

CREATE TABLE "DM_OrganSeal" (
    "Dept_ID" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "OS_Seal" LONGVARCHAR,
    "OS_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("Dept_ID")
);

CREATE TABLE "DM_SearchCondition" (
    "SC_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SC_SearchID" BIGINT  DEFAULT 0 NOT NULL,
    "SC_Key" VARCHAR(50)   NOT NULL,
    "SC_Value" VARCHAR(200)   NOT NULL,
    "SC_Opt" VARCHAR(10)   NOT NULL,
    "SC_GroupID" INT  DEFAULT 0 NOT NULL,
    "SC_Table" VARCHAR(50),
    PRIMARY KEY("SC_ID")
);

CREATE TABLE "DM_SearchEngine" (
    "SE_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SE_Name" VARCHAR(50)   NOT NULL,
    "SE_UserID" VARCHAR(20)   NOT NULL,
    "SE_Type" INT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("SE_ID")
);

CREATE TABLE "DM_SendDocumentInfo" (
    "SDI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SDI_Title" VARCHAR(50)   NOT NULL,
    "DSR_Name" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "DUD_Name" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "SDI_SecrecyTime" VARCHAR(10)   NOT NULL,
    "SDI_SendOrgan" VARCHAR(100)   NOT NULL,
    "SDI_No" VARCHAR(20)   NOT NULL,
    "SDI_SignerID" VARCHAR(20),
    "SDI_FirstOrgan" VARCHAR(50)   NOT NULL,
    "SDI_SecondOrgan" VARCHAR(50),
    "SDI_ThirdOrgan" VARCHAR(50),
    "SDI_Date" DATE  DEFAULT '1900-01-01',
    "SDI_Memo" VARCHAR(50),
    "SDI_Theme" VARCHAR(100),
    "SDI_PrintOrgan" VARCHAR(50),
    "SDI_PrintDate" DATE  DEFAULT '1900-01-01',
    "SDI_PrintPiece" VARCHAR(20),
    "SDI_Pigeonhole" CHAR(1)  DEFAULT '0' NOT NULL,
    PRIMARY KEY("SDI_ID")
);

CREATE TABLE "DM_SendOrgan" (
    "SO_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SO_Name" VARCHAR(50)   NOT NULL,
    "SO_AB" VARCHAR(50)   NOT NULL,
    "SO_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("SO_ID")
);

CREATE TABLE "DM_SendRegister" (
    "SR_ID" BIGINT  DEFAULT 0 NOT NULL,
    "SR_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    "SR_SenderID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "SR_Sender" VARCHAR(20)   NOT NULL,
    "SR_SendDeptID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "SR_SendDept" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "SR_DocID" BIGINT  DEFAULT 0 NOT NULL,
    PRIMARY KEY("SR_ID")
);

CREATE TABLE "DM_SignerSeal" (
    "User_ID" VARCHAR(20)  DEFAULT 0 NOT NULL,
    "SS_Seal" LONGVARCHAR,
    "SS_Flag" CHAR(1)  DEFAULT 0 NOT NULL,
    PRIMARY KEY("User_ID")
);

CREATE TABLE "DM_TempletInfo" (
    "TI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TI_Name" VARCHAR(200)   NOT NULL,
    PRIMARY KEY("TI_ID")
);

CREATE TABLE "DM_TransferMind" (
    "TM_ID" BIGINT  DEFAULT 0 NOT NULL,
    "Doc_ID" BIGINT  DEFAULT 0 NOT NULL,
    "DT_ID" BIGINT  DEFAULT 0 NOT NULL,
    "TM_NextDFN" VARCHAR(20)  DEFAULT '0',
    "TM_HandlersID" VARCHAR(20)  DEFAULT '0' NOT NULL,
    "TM_Handlers" VARCHAR(20)   NOT NULL,
    "TM_Mind" LONGVARCHAR,
    "TM_Signer" BLOB,
    "TM_Date" TIMESTAMP  DEFAULT '1900-01-01 00:00:00' NOT NULL,
    PRIMARY KEY("TM_ID")
);

CREATE TABLE "FM_AccountItem" (
    "AI_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AI_AccountID" BIGINT  DEFAULT 0 NOT NULL,
    "AI_ExpenseTypeID" BIGINT  DEFAULT 0 NOT NULL,
    "AI_Money" FLOAT  DEFAULT 0.00 NOT NULL,
    "AI_BillCount" INT  DEFAULT 0 NOT NULL,
    "AI_Remark" VARCHAR(255),
    "AI_DiaryDate" VARCHAR(10),
    PRIMARY KEY("AI_ID")
);

CREATE TABLE "FM_ApprovalAccessories" (
    "AA_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AA_AcountID" BIGINT  DEFAULT 0 NOT NULL,
    "AA_FileName" VARCHAR(50)   NOT NULL,
    "AA_Code" VARCHAR(50)   NOT NULL,
    "AA_Content" BLOB   NOT NULL,
    PRIMARY KEY("AA_ID")
);

CREATE TABLE "FM_ApprovalFlow" (
    "AF_ID" BIGINT  DEFAULT 0 NOT NULL,
    "AF_Name" VARCHAR(50)   NOT NULL,
    "AF_Flag" CHAR(1),
    PRIMARY KEY("AF_ID")
);

CREATE TABLE "FM_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_Type" TINYINT  DEFAULT 0,