-- 出勤日報データ
drop table if exists attendancedailydata cascade;

create table attendancedailydata (
  PersonCode decimal(8,0) unsigned not null comment '作成者コード'
  , AttendanceDate date not null comment '日報作成日'
  , SeqNo decimal(3,0) unsigned not null comment '明細行番号'
  , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
  , ActionResult varchar(30) not null comment '行動実績'
  , StartTime datetime comment '開始時間'
  , CompTime datetime comment '終了時間'
  , DayTimes decimal(4,1) not null comment '日稼働合計時間'
  , WorkingComment varchar(120) comment 'コメント'
  , WorkKindFlg decimal(2,0) not null comment '作業区分フラグ'
  , EntryDate datetime not null comment '登録日付'
  , UpdateDate datetime not null comment '更新日付'
  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)
) comment '出勤日報データ' ;

create index AttendDaily_Index1
  on attendancedailydata(ConstructionCode); 

create index AttendDaily_Index2
  on attendancedailydata(AttendanceDate);