human.sql

来自「vfp数据库应用编程」· SQL 代码 · 共 92 行

CREATE TABLE dbo.HUMAN
(
   H_CODE VARCHAR(6) NULL,
   H_NAME VARCHAR(10) NULL,
   H_ENGNAME VARCHAR(20) NULL,
   H_SEX VARCHAR(2) NULL,
   H_BIRTH VARCHAR(8) NULL,
   H_NATION VARCHAR(10) NULL,
   H_ID VARCHAR(18) NULL,
   H_DPT VARCHAR(20) NULL,
   H_JOB VARCHAR(20) NULL,
   H_ADD VARCHAR(50) NULL,
   H_ZCODE VARCHAR(6) NULL,
   H_MARRY VARCHAR(4) NULL,
   H_TEL VARCHAR(15) NULL,
   H_TEL2 VARCHAR(25) NULL,
   H_QLFCT VARCHAR(10) NULL,
   H_BSALARY NUMERIC(7,1) NULL,
   H_HOLIDAY SMALLINT NULL,
   H_FROM VARCHAR(8) NULL,
   H_FORMAL VARCHAR(8) NULL,
   H_TO VARCHAR(8) NULL,
   H_HUKOU VARCHAR(30) NULL,
   H_PAPER VARCHAR(20) NULL,
   H_PNO VARCHAR(20) NULL,
   H_PHOTO VARCHAR(50) NULL,
   H_POLITY VARCHAR(8) NULL,
   P_TITLE VARCHAR(16) NULL,
   USETOTAL SMALLINT NULL,
   O_CODEB VARCHAR(20) NULL,
   O_CODEJ VARCHAR(6) NULL
)

GO

CREATE INDEX H_CODE ON dbo.HUMAN(H_CODE)

GO

CREATE INDEX H_NAME ON dbo.HUMAN(H_NAME)

GO

CREATE INDEX H_SEX ON dbo.HUMAN(H_SEX)

GO

CREATE INDEX H_BIRTH ON dbo.HUMAN(H_BIRTH)

GO

CREATE INDEX H_QLFCT ON dbo.HUMAN(H_QLFCT)

GO

CREATE INDEX P_TITLE ON dbo.HUMAN(P_TITLE)

GO

CREATE INDEX H_DPT ON dbo.HUMAN(H_DPT)

GO

CREATE INDEX H_JOB ON dbo.HUMAN(H_JOB)

GO

CREATE INDEX H_POLITY ON dbo.HUMAN(H_POLITY)

GO

CREATE INDEX H_MARRY ON dbo.HUMAN(H_MARRY)

GO

CREATE INDEX H_NATION ON dbo.HUMAN(H_NATION)

GO

CREATE INDEX H_FORMAL ON dbo.HUMAN(H_FORMAL)

GO

CREATE INDEX O_CODEB ON dbo.HUMAN(O_CODEB)

GO

CREATE INDEX O_CODEJ ON dbo.HUMAN(O_CODEJ)

END