工事管理システム製品化対応

-- ?o?????f?[?^

drop table if exists attendancedailydata cascade;

create table attendancedailydata (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , AttendanceDate date not null comment '???????'

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , ActionResult varchar(30) not null comment '?s??????'

  , StartTime datetime comment '?J?n????'

  , CompTime datetime comment '?I??????'

  , DayTimes decimal(4,1) not null comment '????????v????'

  , WorkingComment varchar(120) comment '?R?????g'

  , NightFlg decimal(1,0) not null comment '?????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)

) comment '?o?????f?[?^' ;

create index AttendDaily_Index1

  on attendancedailydata(ConstructionCode);

create index AttendDaily_Index2

  on attendancedailydata(AttendanceDate);