CREATE TABLE DHDB.dbo.Dh_Dimission\n(\nId INT PRIMARY KEY,\nSerialNo VARCHAR(50),\nTestForm INT,\nCustomName VARCHAR(50),\nFlowNumber VARCHAR(50),\nBossConfirm VARCHAR(50),\nBossConfirmTime DATETIME,\nApplyDate DATETIME,\nDateOut DATETIME,\nDateIn DATETIME,\nFillBy VARCHAR(50),\nFTel VARCHAR(50),\nApplicant VARCHAR(50),\nUserId INT,\nRecipient VARCHAR(50),\nRecipientName VARCHAR(50),\nRecipientDate DATETIME,\nDimissionType VARCHAR(50),\nProfile VARCHAR(50),\nJobName VARCHAR(50),\nTel VARCHAR(50),\nCellphone VARCHAR(50),\nEmail VARCHAR(50),\nDeptId INT,\nDeptName VARCHAR(50),\nCompanyCode VARCHAR(50),\nApplyLanguage VARCHAR(50),\nApprover1 VARCHAR(50),\nApprover1Date DATETIME,\nApprover2 VARCHAR(50),\nApprover3 VARCHAR(50),\nApprover4 VARCHAR(50),\nApprover5 VARCHAR(50),\nApprover6 VARCHAR(50),\nApprover7 VARCHAR(50),\nApprover8 VARCHAR(50),\nFinanceCashier VARCHAR(50),\nFinanceCashierDate DATETIME,\nFinanceManager VARCHAR(50),\nFinanceManagerDate DATETIME,\nConformity VARCHAR(50),\nConformityDate DATETIME,\nMIS VARCHAR(50),\nMISDate DATETIME,\nDescription VARCHAR(50),\nHrTraining INT,\nHrTrainingDate DATETIME,\nHrSocialSecurity INT,\nHrSocialSecurityDate DATETIME,\nHrAttendance INT,\nHrAttendanceDate DATETIME,\nAdminCard INT,\nAdminCardDate DATETIME,\nAdminDorm INT,\nAdminDormDate DATETIME,\nAdminClothing INT,\nAdminClothingDate DATETIME,\nAdminPermit INT,\nAdminPermitDate DATETIME,\nHrManager VARCHAR(50),\nHrManagerDate DATETIME,\nManaDeptManager VARCHAR(50),\nManaDeptManagerDate DATETIME,\nSex VARCHAR(50),\nJobGrade INT,\nComment VARCHAR(50),\nSortNo INT,\nRemark VARCHAR(50),\nDataStatus INT,\nCurrentUserId INT,\nCurrentUserName VARCHAR(50),\nCreateUserId INT,\nCreateTime DATETIME,\nUpdateUserId INT,\nUpdateTime DATETIME,\nIsRepeatEmployed INT,\nBand VARCHAR(50),\nSigningAgent INT,\nSigningAgentName VARCHAR(50)\n);

SQL建表语句:DHDB.dbo.Dh_Dimission 表结构定义

原文地址: https://www.cveoy.top/t/topic/qqRo 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录