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

-- Project Name : noname

-- Author       : Horiuchi

-- RDBMS Type   : MySQL

-- Application  : A5:SQL Mk-2

-- ?S????s???\??f?[?^

create table actionscheduledata (

  TargetDate date not null comment '????'

  on actionscheduledata(TargetDay);

-- ???F?o?H?}?X?^

create table approvalmaster (

  ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

) comment '???F?o?H?}?X?^' ;

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

create table attendancedailydata (

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

  on attendancedailydata(AttendanceDate);

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

create table attendancedata (

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

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

-- ??s?c????}?X?^

create table bankbusinessdaymaster (

  YEARMONTH decimal(6,0) default '0' not null comment '?N??'

) comment '??s?c????}?X?^' ;

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

create table billingdata (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

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

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

create table billingdatadetail (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

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

-- ???????x???T?}???[?f?[?^

create table billingpaymentsummary (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

  , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND)

) comment '???????x???T?}???[?f?[?^' ;

-- ?H???????f?[?^?y???p?z

create table bk_constructionledger (

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

) comment '?H???????f?[?^?y???p?z' ;

-- ?H??????????f?[?^?y???p?z

create table bk_constructionledgerdetail (

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

) comment '?H??????????f?[?^?y???p?z' ;

-- ?H?????????s?f?[?^?y???p?z

create table bk_constructionledgerexcute (

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

) comment '?H?????????s?f?[?^?y???p?z' ;

-- ??Z????f?[?^?y???p?z

create table bk_estimatedata (

  SaveDate datetime not null comment '?????t'

) comment '??Z????f?[?^?y???p?z' ;

-- ??Z????y?[?W?f?[?^?y???p?z

create table bk_estimatedatabody (

  SaveDate datetime not null comment '?????t'

) comment '??Z????y?[?W?f?[?^?y???p?z' ;

-- ??Z????f?[?^????y???p?z

create table bk_estimatedatadetail (

  SaveDate datetime not null comment '?????t'

) comment '??Z????f?[?^????y???p?z' ;

-- ?@?l?i?}?X?^

create table businesstypemaster (

  BusinessTypeCode decimal(5,0) unsigned not null comment '?@?l?i?R?[?h'

  on businesstypemaster(DisplayOrder);

-- ????????}?X?^

create table commoncostlarge (

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

) comment '????????}?X?^' ;

-- ?????H???A?}?X?^

create table commoncostlinkms (

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

) comment '?????H???A?}?X?^' ;

-- ?????????}?X?^

create table commoncostmiddle (

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

) comment '?????????}?X?^' ;

-- ?????????L?[?}?X?^

create table commoncostmiddlesearchword (

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

) comment '?????????L?[?}?X?^' ;

-- ?\???H???A?}?X?^

create table componentlinkmaster (

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

  on componentlinkmaster(ItemCode);

-- ?\???}?X?^

create table componentmaster (

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

  on componentmaster(DisplayOrder);

-- ?\???H??????A?}?X?^

create table componenttotypemaster (

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

  on componenttotypemaster(TypeCode);

-- ?H????{???

create table constructionbaseinfo (

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

  on constructionbaseinfo(ConstructionPeriod);

-- ?H????{????

create table constructionbaseinfodetail (

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

  on constructionbaseinfodetail(DetailNo);

-- ?H???{?H?\?Z?f?[?^

create table constructionbudget (

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

) comment '?H???{?H?\?Z?f?[?^' ;

-- ?H???{?H?\?Z?f?[?^????

create table constructionbudgetdetail (

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

) comment '?H???{?H?\?Z?f?[?^????' ;

-- ?H??}?X?^

create table constructionitemmaster (

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

) comment '?H??}?X?^' ;

-- ?H???????f?[?^

create table constructionledger (

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

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

-- ?H??????????f?[?^

create table constructionledgerdetail (

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

  on constructionledgerdetail(DetailCount);

-- ?H?????????s?f?[?^

create table constructionledgerexcute (

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

  on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);

-- ?H???????N???

create table constructionlink (

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

  on constructionlink(LinkType);

-- ?H????????

create table constructionmaterialinfo (

  CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????'

) comment '?H????????' ;

-- ????i?????t?f?[?^

create table constructionprogressdate (

  ConstructionCode decimal(10,0) not null comment '?H?????'

) comment '????i?????t?f?[?^' ;

-- ???}?X?^

create table constructionspecmaster (

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  on constructionspecmaster(DisplayOrder);

-- ???P???}?X?^

create table constructionspecunitprice (

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

) comment '???P???}?X?^' ;

-- ?H?????}?X?^

create table constructiontypemaster (

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

) comment '?H?????}?X?^' ;

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

create table costdataofperson (

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

  on costdataofperson(ConstructionCode);

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

create table costomerregist (

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

  on costomerregist(PetitionPeriod);

-- ????f?[?^

create table dailydataconstruction (

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

  on dailydataconstruction(ConstructionCode);

-- ????f?[?^ (????)

create table dailydatadetail (

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

  on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (??????)

create table dailydatafield (

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

  on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (????)

create table dailydatamaterials (

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

  on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (??????w??)

create table dailydatasubcontractors (

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

  on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (???)

create table dailydatavehicles (

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

  on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);

-- ???}?X?^

create table daymaster (

  days smallint(6) not null comment '??'

  on daymaster(days);

-- ?????}?X?^

create table deadlinemaster (

  LABOURKIND decimal(1,0) default '0' not null comment '??????'

) comment '?????}?X?^' ;

-- ?????o???}?X?^

create table departmentexpensesmaster (

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

) comment '?????o???}?X?^' ;

-- ?????}?X?^

create table departmentmaster (

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

  on departmentmaster(DisplayOrder);

-- ?????m?F???F?f?[?^

create table depositapprovalinfo (

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

) comment '?????m?F???F?f?[?^' ;

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

create table depositdata (

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

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

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

create table depositdatadetail (

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

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

-- ???}?X?^

create table divisionmaster (

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

) comment '???}?X?^' ;

-- ??Z?\?Z???f?[?^

create table estimatebudget (

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

) comment '??Z?\?Z???f?[?^' ;

-- ??Z?\?Z????f?[?^????

create table estimatebudgetdetail (

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

) comment '??Z?\?Z????f?[?^????' ;

-- ??Z????f?[?^

create table estimatedata (

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

  on estimatedata(ConstructionCode,FixedItemCode);

-- ??Z????y?[?W?f?[?^

create table estimatedatabody (

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

  on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);

-- ??Z????f?[?^????

create table estimatedatadetail (

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

  on estimatedatadetail(ConstructionCode,PageCount);

-- ?o???}?X?^

create table expensesmaster (

  DivisionCode smallint(6) not null comment '?H?????R?[?h'

) comment '?o???}?X?^' ;

-- ???x???}?X?^

create table holidaycalendermaster (

  Holiday date not null comment '?x??'

  on holidaycalendermaster(TargetDay);

-- ?????????????

create table inputsearchlogdata (

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

  on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);

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

create table invoicedata (

  INVOICENO decimal(9,0) not null comment '??????No'

alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;

-- ??????

create table materialinfo (

  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

) comment '??????' ;

-- ????i??}?X?^

create table materialitemmaster (

  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

) comment '????i??}?X?^' ;

-- ??????}?X?^

create table materialkindmaster (

  MATERIALKINDCODE smallint(5) unsigned default 0 not null comment '??????R?[?h'

) comment '??????}?X?^' ;

-- ??????????

create table materialrecordinfo (

  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

) comment '??????????' ;

-- ?f??????b?Z?[?W

create table messageboarddata (

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

  on messageboarddata(MessageFlag);

-- ?f???????e?[?u??

create table messageboardterget (

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

  on messageboardterget(RecordNumber,BranchNumber);

-- ?f??????b?Z?[?W?{??????

create table messagebrowsinghistory (

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

) comment '?f??????b?Z?[?W?{??????' ;

-- ???}?X?^

create table monthmaster (

  month smallint(6) not null comment '??'

  on monthmaster(month);

-- ??????}?X?^

create table orderersmaster (

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

) comment '??????}?X?^' ;

-- ????z?f?[?^

create table orderspricedata (

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

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

-- ?x?????F???f?[?^

create table paymentapprovalinfo (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

) comment '?x?????F???f?[?^' ;

-- ?x??????f?[?^

create table paymentdatadetail (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

  on paymentdatadetail(APPROVALPERSONCODE);

-- ?H??????????f?[?^

create table periodavoidance (

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

  on periodavoidance(FieldNo);

-- ?S??????F?f?[?^

create table personapproval (

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

) comment '?S??????F?f?[?^' ;

-- ?S??????F?R?????g?f?[?^

create table personapprovalcomment (

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

) comment '?S??????F?R?????g?f?[?^' ;

-- ?S??????????}?X?^

create table persondepartmentmaster (

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

  on persondepartmentmaster(DepartmentCode);

-- ?S????}?X?^

create table personinchargemaster (

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

  on personinchargemaster(DepartmentCode);

-- ?S??????^?}?X?^

create table personsalarymaster (

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

  on personsalarymaster(StartDate);

-- ?w???????f?[?^

create table pointingoutcomment (

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

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

-- ?????????????c???^?f?[?^

create table proceedingsdata (

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

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

-- ?????????????c???^?f?[?^?i?o???j

create table proceedingsdataattend (

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

) comment '?????????????c???^?f?[?^?i?o???j' ;

-- ?????????????c???^?f?[?^?i????j

create table proceedingsdatadetail (

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

) comment '?????????????c???^?f?[?^?i????j' ;

-- ???F?f?[?^

create table processapproval (

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

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

-- ???F?R?????g?f?[?^

create table processapprovalcomment (

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

) comment '???F?R?????g?f?[?^' ;

-- ???F????f?[?^

create table processapprovaldetail (

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

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

-- ?N?????}?X?^

create table processexcutemaster (

  SecCode decimal(2,0) unsigned not null comment '???????'

  on processexcutemaster(ExecCode);

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

create table purchaseorder (

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

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

-- ?????????t?f?[?^

create table purchaseorderdate (

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

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

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

create table purchaseorderdetail (

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

  on purchaseorderdetail(SourceCode);

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

create table requestdata (

  REQUESTNO decimal(9,0) not null comment '????No'

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

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

create table requestdatadetail (

  REQUESTNO decimal(9,0) not null comment '????No'

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

-- ?????w?b?_

create table requesthead (

  REQUESTNO decimal(9,0) not null comment '????No'

alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;

-- ?????????t?f?[?^

create table requestorderdate (

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

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

-- ????O???t?f?[?^

create table salesgraphdata (

  GraphDataCode decimal(8,0) not null comment '?O???t?f?[?^?R?[?h'

  on salesgraphdata(ConstructionPeriod);

-- ?????}?X?^

create table securitymaster (

  SecCode decimal(2,0) unsigned not null comment '???????'

  on securitymaster(SecRange);

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

create table sfpdata (

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

  on sfpdata(RequestDate);

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

create table sfpdatadetail (

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

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

-- ??????{?H?H??o?^?\???f?[?^

create table subconstrjobitemregist (

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

) comment '??????{?H?H??o?^?\???f?[?^' ;

-- ??????E?????N?o?^?\???f?[?^

create table subconstrjoblinkregist (

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

) comment '??????E?????N?o?^?\???f?[?^' ;

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

create table subconstrregist (

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

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

-- ??????H??}?X?^

create table subcontractoritemmaster (

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

) comment '??????H??}?X?^' ;

-- ??????E??}?X?^

create table subcontractorjobcategory (

  JobCategoryCode decimal(5,0) not null comment '?E??L?['

) comment '??????E??}?X?^' ;

-- ??????{?H?H??f?[?^

create table subcontractorjobitem (

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

  on subcontractorjobitem(ItemCode);

-- ??????E?????N?}?X?^

create table subcontractorjoblink (

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

  on subcontractorjoblink(JobCategoryCode);

-- ??????}?X?^

create table subcontractormaster (

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

  on subcontractormaster(JapaneseSyllabary);

-- ?d????}?X?^

create table suppliersmaster (

  SuppliersCode decimal(5,0) unsigned not null comment '?d????R?[?h'

) comment '?d????}?X?^' ;

-- ?V?X?e???N???m?F?f?[?^

create table systemexecute (

  PrimaryCode tinyint(4) not null comment '?L?[????'

) comment '?V?X?e???N???m?F?f?[?^' ;

-- ????}?X?^

create table systemmaster (

  SystemCode decimal(3,0) unsigned not null comment '???R?[?h'

  , PhoneNumber varchar(13) not null comment '?d?b???'

  , FaxNumber varchar(13) comment 'FAX???'

  , HomePageURL varchar(120) comment '?z?[???y?[?WURL'

  , ConsumptionTax decimal(4,2) not null comment '?????'

  , CooperationRate decimal(4,2) not null comment '???????'

  , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'

  , AreaDistance decimal(5,2) not null comment '????u????????'

  , ExcelSavePath varchar(120) comment 'Excel????p?X'

  , BusinessPeriod smallint(6) not null comment '????c?????'

  , ConstructionNoBase decimal(1,0) not null comment '?H????????l'

  , SloganString1 varchar(100) comment '?W??1'

  , SloganString2 varchar(100) comment '?W??2'

) comment '????}?X?^' ;

-- ?????}?X?^

create table termmaster (

  ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'

  on termmaster(DisplayOrder);

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

create table tranceportdailydata (

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

  on tranceportdailydata(AttendanceDate);

-- ?H?????o???}?X?^

create table typeexpensesmaster (

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

) comment '?H?????o???}?X?^' ;

-- ?P??}?X?^

create table unitmaster (

  UnitKey decimal(5,0) unsigned not null comment '?P??L?['

  on unitmaster(DisplayOrder);

-- ????}?X?^

create table vehiclemaster (

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

) comment '????}?X?^' ;

-- ????L?^?f?[?^

create table vehiclerecorddata (

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

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

-- ????\??f?[?^

create table vehiclescheduledata (

  TargetDate date not null comment '????'

  on vehiclescheduledata(TargetDay);

-- ?N?}?X?^

create table yearmaster (

  years smallint(6) not null comment '?N'