数据表:T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位)

T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位):描述

名称

T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位)

代码

T_BAS_ALLOCATECYCLEFORWEEK

注释

 

模型

BOS

主键

PK_ALLOCATECYCLEFORWEEK


T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位):列规格定义

名称

代码

数据类型

长度

强制

注释

内码

FWEEKID

int

 

TRUE

 

主表内码

FID

int

 

TRUE

 

星期一

FMONDAY

char(1)

1

FALSE

 

星期二

FTUESDAY

char(1)

1

FALSE

 

星期三

FWEDNESDAY

char(1)

1

FALSE

 

星期四

FTHURSDAY

char(1)

1

FALSE

 

星期五

FFRILDAY

char(1)

1

FALSE

 

星期六

FSATURDAY

char(1)

1

FALSE

 

星期天

FSUNDAY

char(1)

1

FALSE

 

间隔时间

FREPEATINTERVAL

int

 

FALSE

 


T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位):脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_BAS_ALLOCATECYCLEFORWEEK')
and name = 'IDX_BAS_ALLOCATECYCLEFORWEEK'
and indid > 0
and indid < 255)
drop index T_BAS_ALLOCATECYCLEFORWEEK.IDX_BAS_ALLOCATECYCLEFORWEEK
go

if exists (select 1
from sysobjects
where id = object_id('T_BAS_ALLOCATECYCLEFORWEEK')
and type = 'U')
drop table T_BAS_ALLOCATECYCLEFORWEEK
go

/*==============================================================*/
/* Table: T_BAS_ALLOCATECYCLEFORWEEK */
/*==============================================================*/
create table T_BAS_ALLOCATECYCLEFORWEEK (
FWEEKID int not null default 0,
FID int not null default 0,
FMONDAY char(1) null,
FTUESDAY char(1) null,
FWEDNESDAY char(1) null,
FTHURSDAY char(1) null,
FFRILDAY char(1) null,
FSATURDAY char(1) null,
FSUNDAY char(1) null,
FREPEATINTERVAL int null,
constraint PK_BAS_ALLOCATECYCLEFORWEEK primary key (FWEEKID)
)
go

/*==============================================================*/
/* Index: IDX_BAS_ALLOCATECYCLEFORWEEK */
/*==============================================================*/
create index IDX_BAS_ALLOCATECYCLEFORWEEK on T_BAS_ALLOCATECYCLEFORWEEK (
FWEEKID ASC,
FID ASC
)
go


T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位):键值定义

名称

代码

主要的

PK_ALLOCATECYCLEFORWEEK

PK_ALLOCATECYCLEFORWEEK

TRUE


T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_BAS_ALLOCATECYCLEFORWEEK

IDX_BAS_ALLOCATECYCLEFORWEEK

FALSE

FALSE

FALSE

FALSE

FALSE

T_BAS_ALLOCATECYCLEFORWEEK (分配周期以周为单位)