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

drop table if exists SFPData cascade;

-- ???S?p?g???[???f?[?^

create table SFPData (

  ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '?H???R?[?h'

  , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'

  , RequestDate datetime not null comment '?p?g???[???v??????'

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

  , StringValue varchar(300) COMMENT '?R?????g'

  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'

  , EntryDate datetime NOT NULL COMMENT '?o?^???t'

  , UpdateDate datetime NOT NULL COMMENT '?X?V???t'

  , constraint SFPData_PKC primary key (ConstructionCode, DataCount)

) comment '???S?p?g???[???f?[?^' ;

create index SFPData_Index1

  on SFPData(RequestDate);

drop table if exists SFPDataDetail cascade;

-- ???S?p?g???[??????f?[?^

create table SFPDataDetail (

  ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '?H???R?[?h'

  , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'

  , SeqNo decimal(2,0) unsigned not null comment '?f?[?^?}??'

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

  , EntryDate datetime NOT NULL COMMENT '?o?^???t'

  , UpdateDate datetime NOT NULL COMMENT '?X?V???t'

  , constraint SFPDataDetail_PKC primary key (ConstructionCode, DataCount, SeqNo)

) comment '???S?p?g???[??????f?[?^' ;