education.sql

这是一个人事管理系统

CREATE TABLE dbo.education
(
   H_CODE VARCHAR(6) NULL,
   E_SCHOOL VARCHAR(30) NULL,
   E_SUBJECT VARCHAR(16) NULL,
   E_FROM VARCHAR(8) NULL,
   E_TO VARCHAR(8) NULL,
   E_QLFCT VARCHAR(10) NULL,
   E_MEMO TEXT NULL
)

GO

CREATE INDEX E_FROM ON dbo.education(E_FROM)

GO

CREATE INDEX H_CODE ON dbo.education(H_CODE)

GO

CREATE INDEX E_SUBJECT ON dbo.education(E_SUBJECT)

GO

CREATE INDEX E_QLFCT ON dbo.education(E_QLFCT)

GO

CREATE INDEX CODETO ON dbo.education(H_CODE,E_TO)

END