modulation.sql

这是一个人事管理系统

CREATE TABLE dbo.modulation
(
   H_CODE VARCHAR(6) NULL,
   M_FROM NUMERIC(8,2) NULL,
   M_TO NUMERIC(8,2) NULL,
   M_DATE VARCHAR(8) NULL,
   M_REASON VARCHAR(10) NULL,
   M_MEMO TEXT NULL
)

GO

CREATE INDEX H_CODE ON dbo.modulation(H_CODE)

GO

CREATE INDEX M_DATE ON dbo.modulation(M_DATE)

GO

CREATE INDEX CODEDATE ON dbo.modulation(H_CODE,M_DATE)

END