sys_roles_agent.sql

vfp数据库应用编程

CREATE TABLE dbo.SYS_ROLES_AGENT
(
   ROLE_ID VARCHAR(12) NOT NULL,
   AGENT VARCHAR(20) NOT NULL,
   START_DATE VARCHAR(8) NOT NULL,
   START_TIME VARCHAR(6) NOT NULL,
   END_DATE VARCHAR(8) NOT NULL,
   END_TIME VARCHAR(6) NOT NULL,
   PAR_AGENT VARCHAR(4) NULL,
   REMARK VARCHAR(254) NULL,
   UPDATE_USER VARCHAR(20) NULL,
   UPDATE_DATE VARCHAR(8) NULL,
   UPDATE_TIME VARCHAR(6) NULL,
   SYSFLAG VARCHAR(1) NULL,
   LASTUPDATEDATETIME VARCHAR(14) NULL,
   PRIMARY KEY(ROLE_ID,AGENT,START_DATE,START_TIME)
)

END