-- 工事種別・構成リンクマスタ
drop table if exists componenttotypemaster cascade;

create table componenttotypemaster (
  TypeCode decimal(5,0) unsigned not null comment '工事種別コード'
  , ComponentCode decimal(5,0) unsigned not null comment '構成キー'
  , DisplayOrder decimal(5,0) unsigned not null comment '表示順'
  , EntryDate datetime not null comment '登録日付'
  , UpdateDate datetime not null comment '更新日付'
  , constraint componenttotypemaster_PKC primary key (TypeCode, ComponentCode)
) comment '工事種別・構成リンクマスタ' ;

create index ComponentToTypeMaster_Index1
  on componenttotypemaster(TypeCode);

create index ComponentToTypeMaster_Index2
  on componenttotypemaster(ComponentCode);