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

-- ?H?????E?\???????N?}?X?^

drop table if exists componenttotypemaster cascade;

create table componenttotypemaster (

  TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

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

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

  , constraint componenttotypemaster_PKC primary key (TypeCode, ComponentCode)

) comment '?H?????E?\???????N?}?X?^' ;

create index ComponentToTypeMaster_Index1

  on componenttotypemaster(TypeCode);

create index ComponentToTypeMaster_Index2

  on componenttotypemaster(ComponentCode);