MySQL 数据表 Dh_Dimission 创建语句

CREATE TABLE Dh_Dimission ( Id INT(11) NOT NULL, SerialNo VARCHAR(50) DEFAULT NULL, TestForm TINYINT(1) NOT NULL, CustomName VARCHAR(200) DEFAULT NULL, FlowNumber VARCHAR(100) DEFAULT NULL, BossConfirm CHAR(1) DEFAULT NULL, BossConfirmTime DATETIME DEFAULT NULL, ApplyDate VARCHAR(100) DEFAULT NULL, DateOut VARCHAR(100) DEFAULT NULL, DateIn VARCHAR(100) DEFAULT NULL, FillBy VARCHAR(100) DEFAULT NULL, FTel VARCHAR(100) DEFAULT NULL, Applicant VARCHAR(100) DEFAULT NULL, UserId VARCHAR(100) DEFAULT NULL, Recipient VARCHAR(100) DEFAULT NULL, RecipientName VARCHAR(100) DEFAULT NULL, RecipientDate VARCHAR(100) DEFAULT NULL, DimissionType VARCHAR(100) DEFAULT NULL, Profile VARCHAR(100) DEFAULT NULL, JobName VARCHAR(100) DEFAULT NULL, Tel VARCHAR(100) DEFAULT NULL, Cellphone VARCHAR(100) DEFAULT NULL, Email VARCHAR(100) DEFAULT NULL, DeptId VARCHAR(100) DEFAULT NULL, DeptName VARCHAR(100) DEFAULT NULL, CompanyCode VARCHAR(20) DEFAULT NULL, ApplyLanguage VARCHAR(100) DEFAULT NULL, Approver1 VARCHAR(100) DEFAULT NULL, Approver1Date VARCHAR(100) DEFAULT NULL, Approver2 VARCHAR(100) DEFAULT NULL, Approver3 VARCHAR(100) DEFAULT NULL, Approver4 VARCHAR(100) DEFAULT NULL, Approver5 VARCHAR(100) DEFAULT NULL, Approver6 VARCHAR(100) DEFAULT NULL, Approver7 VARCHAR(100) DEFAULT NULL, Approver8 VARCHAR(100) DEFAULT NULL, FinanceCashier VARCHAR(100) DEFAULT NULL, FinanceCashierDate VARCHAR(100) DEFAULT NULL, FinanceManager VARCHAR(100) DEFAULT NULL, FinanceManagerDate VARCHAR(100) DEFAULT NULL, Conformity VARCHAR(100) DEFAULT NULL, ConformityDate VARCHAR(100) DEFAULT NULL, MIS VARCHAR(100) DEFAULT NULL, MISDate VARCHAR(100) DEFAULT NULL, Description TEXT DEFAULT NULL, HrTraining TEXT DEFAULT NULL, HrTrainingDate TEXT DEFAULT NULL, HrSocialSecurity TEXT DEFAULT NULL, HrSocialSecurityDate TEXT DEFAULT NULL, HrAttendance TEXT DEFAULT NULL, HrAttendanceDate TEXT DEFAULT NULL, AdminCard TEXT DEFAULT NULL, AdminCardDate TEXT DEFAULT NULL, AdminDorm TEXT DEFAULT NULL, AdminDormDate TEXT DEFAULT NULL, AdminClothing TEXT DEFAULT NULL, AdminClothingDate TEXT DEFAULT NULL, AdminPermit TEXT DEFAULT NULL, AdminPermitDate TEXT DEFAULT NULL, HrManager TEXT DEFAULT NULL, HrManagerDate TEXT DEFAULT NULL, ManaDeptManager TEXT DEFAULT NULL, ManaDeptManagerDate TEXT DEFAULT NULL, Sex VARCHAR(10) DEFAULT NULL, JobGrade VARCHAR(10) DEFAULT NULL, Comment TEXT DEFAULT NULL, SortNo INT(11) DEFAULT NULL, Remark TEXT DEFAULT NULL, DataStatus INT(11) NOT NULL, CurrentUserId VARCHAR(100) DEFAULT NULL, CurrentUserName VARCHAR(100) DEFAULT NULL, CreateUserId VARCHAR(100) DEFAULT NULL, CreateTime DATETIME NOT NULL, UpdateUserId VARCHAR(100) DEFAULT NULL, UpdateTime DATETIME DEFAULT NULL, IsRepeatEmployed VARCHAR(50) DEFAULT NULL, Band VARCHAR(50) DEFAULT NULL, SigningAgent VARCHAR(100) DEFAULT NULL, SigningAgentName VARCHAR(100) DEFAULT NULL, PRIMARY KEY (Id) );