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

-- Project Name : noname

-- Author       : Horiuchi

-- RDBMS Type   : MySQL

-- Application  : A5:SQL Mk-2

*/

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

drop table if exists actionscheduledata cascade;

create table actionscheduledata (

  TargetDate date not null comment '????'

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

  on actionscheduledata(TargetDay);

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

drop table if exists approvalmaster cascade;

create table approvalmaster (

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

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

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

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

drop table if exists attendancedailydata cascade;

create table attendancedailydata (

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

  , AttendanceDate date not null comment '???????'

  on attendancedailydata(AttendanceDate);

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

drop table if exists attendancedata cascade;

create table attendancedata (

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

  , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'

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

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

drop table if exists attendancenotice cascade;

create table attendancenotice (

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

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

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

-- ????o?R?t???f?[?^

drop table if exists attendancenoticelink cascade;

create table attendancenoticelink (

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

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

  on attendancenoticelink(SeqNo);

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

drop table if exists attnoticeconstrction cascade;

create table attnoticeconstrction (

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

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

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

-- ?L???x??????R?t?f?[?^

drop table if exists attnpaidholidyalink cascade;

create table attnpaidholidyalink (

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

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

) comment '?L???x??????R?t?f?[?^' ;

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

drop table if exists bankbusinessdaymaster cascade;

create table bankbusinessdaymaster (

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

  , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '??s?c???'

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

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

drop table if exists billingdata cascade;

create table billingdata (

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

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

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

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

drop table if exists billingdatadetail cascade;

create table billingdatadetail (

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

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

  on billingdatadetail(CONSTRUCTIONCOLCNT);

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

drop table if exists billingpaymentsummary cascade;

create table billingpaymentsummary (

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

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

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

-- ?^?c?????????

drop table if exists bizperiodhistory cascade;

create table bizperiodhistory (

  PeriodYear smallint(6) not null comment '?c??????E?H???N?x'

  , PeriodFlag smallint(1) not null comment '?c??????E?H???N?x?t???O'

) comment '?^?c?????????' ;

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

drop table if exists bk_constructionledger cascade;

create table bk_constructionledger (

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

  , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'

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

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

drop table if exists bk_constructionledgerdetail cascade;

create table bk_constructionledgerdetail (

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

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

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

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

drop table if exists bk_constructionledgerexcute cascade;

create table bk_constructionledgerexcute (

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

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

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

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

drop table if exists bk_estimatedata cascade;

create table bk_estimatedata (

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

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

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

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

drop table if exists bk_estimatedatabody cascade;

create table bk_estimatedatabody (

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

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

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

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

drop table if exists bk_estimatedatadetail cascade;

create table bk_estimatedatadetail (

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

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

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

-- ?\?Z???W?v?R?[?h?}?X?^

drop table if exists budgetsumcode cascade;

create table budgetsumcode (

  BlockCode decimal(2,0) unsigned not null comment '?u???b?N???'

  , GroupCode decimal(2,0) unsigned not null comment '?O???[?v???'

) comment '?\?Z???W?v?R?[?h?}?X?^' ;

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

drop table if exists businesstypemaster cascade;

create table businesstypemaster (

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

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

  on businesstypemaster(DisplayOrder);

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

drop table if exists chgchargedep cascade;

create table chgchargedep (

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

  , StartDate date not null comment '?J?n?N????'

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

-- ?H???S????X?????f?[?^

drop table if exists chgconstrcharge cascade;

create table chgconstrcharge (

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

  , Division decimal(1,0) not null comment '????'

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

-- Web-EDI??????f?[?^

drop table if exists closingdateofmonth cascade;

create table closingdateofmonth (

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

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

) comment 'Web-EDI??????f?[?^' ;

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

drop table if exists commoncostlarge cascade;

create table commoncostlarge (

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

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

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

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

drop table if exists commoncostlinkms cascade;

create table commoncostlinkms (

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

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

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

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

drop table if exists commoncostmiddle cascade;

create table commoncostmiddle (

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

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

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

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

drop table if exists commoncostmiddlesearchword cascade;

create table commoncostmiddlesearchword (

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

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

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

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

drop table if exists componentlinkmaster cascade;

create table componentlinkmaster (

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

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

  on componentlinkmaster(ItemCode);

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

drop table if exists componentmaster cascade;

create table componentmaster (

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

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

  on componentmaster(DisplayOrder);

-- ?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?['

  on componenttotypemaster(ComponentCode);

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

drop table if exists constrledgerexpenses cascade;

create table constrledgerexpenses (

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

  , SeqNo decimal(5,0) not null comment '?}??'

  on constrledgerexpenses(NameCode);

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

drop table if exists constructionbaseinfo cascade;

create table constructionbaseinfo (

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

  , TyingFlg decimal(1,0) not null comment '?R?t?f?[?^?t???O'

  on constructionbaseinfo(ConstructionPeriod);

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

drop table if exists constructionbaseinfodetail cascade;

create table constructionbaseinfodetail (

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

  , DetailNo decimal(3,0) not null comment '??????'

  on constructionbaseinfodetail(DetailNo);

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

drop table if exists constructionbudget cascade;

create table constructionbudget (

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

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

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

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

drop table if exists constructionbudgetdetail cascade;

create table constructionbudgetdetail (

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

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

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

-- ?H??}?X?^

drop table if exists constructionitemmaster cascade;

create table constructionitemmaster (

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

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

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

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

drop table if exists constructionledger cascade;

create table constructionledger (

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

  , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'

  on constructionledger(ConstructionEnd);

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

drop table if exists constructionledgerdetail cascade;

create table constructionledgerdetail (

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

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

  on constructionledgerdetail(CompanyCode);

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

drop table if exists constructionledgerexcute cascade;

create table constructionledgerexcute (

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

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

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

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

drop table if exists constructionlink cascade;

create table constructionlink (

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

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

  on constructionlink(LinkType);

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

drop table if exists constructionmaterialinfo cascade;

create table constructionmaterialinfo (

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

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

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

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

drop table if exists constructionprogressdate cascade;

create table constructionprogressdate (

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

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

  on constructionprogressdate(ChangeDate);

-- ???}?X?^

drop table if exists constructionspecmaster cascade;

create table constructionspecmaster (

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

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

  on constructionspecmaster(DisplayOrder);

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

drop table if exists constructionspecunitprice cascade;

create table constructionspecunitprice (

  ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h'

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

  on constructionspecunitprice(ConstructionTypeCode,ComponentCode,ItemCode);

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

drop table if exists constructiontypemaster cascade;

create table constructiontypemaster (

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

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

  , RepairFlg decimal(1,0) not null comment '?V?z?E???C?t???O'

  , SecRank decimal(1,0) not null comment '?????????N'

  , ExpensesLink decimal(1,0) not null comment '?o??g?p??'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

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

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

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

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

drop table if exists consumptiontax cascade;

create table consumptiontax (

  StartDate date not null comment '?g?p?J?n?N????'

  , ComplateDate date comment '?g?p?I???N????'

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

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

drop table if exists costdataofdepartment cascade;

create table costdataofdepartment (

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

  , ConstrYear smallint(5) unsigned not null comment '?H???????E?N??'

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

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

drop table if exists costdataofperson cascade;

create table costdataofperson (

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

  , ActionDate date not null comment '?????t'

  on costdataofperson(ConstructionCode);

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

drop table if exists costomerregist cascade;

create table costomerregist (

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

  , CreateDate date not null comment '????'

  on costomerregist(CreateDepartmentCode);

-- ????f?[?^

drop table if exists dailydataconstruction cascade;

create table dailydataconstruction (

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

  , DailyDataDate date not null comment '???????'

  on dailydataconstruction(ConstructionCode);

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

drop table if exists dailydatadetail cascade;

create table dailydatadetail (

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

  , DailyDataDate date not null comment '???????'

  on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);

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

drop table if exists dailydatafield cascade;

create table dailydatafield (

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

  , DailyDataDate date not null comment '???????'

  on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);

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

drop table if exists dailydatamaterials cascade;

create table dailydatamaterials (

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

  , DailyDataDate date not null comment '???????'

  on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);

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

drop table if exists dailydatasubcontractors cascade;

create table dailydatasubcontractors (

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

  , DailyDataDate date not null comment '???????'

  on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);

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

drop table if exists dailydatavehicles cascade;

create table dailydatavehicles (

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

  , DailyDataDate date not null comment '???????'

  on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);

-- ???}?X?^

drop table if exists daymaster cascade;

create table daymaster (

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

  , constraint daymaster_PKC primary key (days)

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

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

drop table if exists deadlinemaster cascade;

create table deadlinemaster (

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

  , DEADLINE decimal(2,0) comment '????'

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

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

drop table if exists departmentexpensesmaster cascade;

create table departmentexpensesmaster (

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

  , ExpensesPeriod smallint(6) not null comment '?????'

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

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

drop table if exists departmentmaster cascade;

create table departmentmaster (

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

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

  on departmentmaster(DisplayOrder);

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

drop table if exists depositapprovalinfo cascade;

create table depositapprovalinfo (

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

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

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

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

drop table if exists depositdata cascade;

create table depositdata (

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

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

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

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

drop table if exists depositdatadetail cascade;

create table depositdatadetail (

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

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

  on depositdatadetail(ORDERERSDIVISION,ORDERERSCODE,DEPOSITMONTH,SEQNO);

-- ???}?X?^

drop table if exists divisionmaster cascade;

create table divisionmaster (

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

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

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

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

drop table if exists estimatebudget cascade;

create table estimatebudget (

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

  , ConstructionTime decimal(5,2) unsigned not null comment '?H??'

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

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

drop table if exists estimatebudgetdetail cascade;

create table estimatebudgetdetail (

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

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

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

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

drop table if exists estimatedata cascade;

create table estimatedata (

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

  , LineCount decimal(3,0) unsigned not null comment '?s???'

  on estimatedata(ConstructionCode,FixedItemCode);

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

drop table if exists estimatedatabody cascade;

create table estimatedatabody (

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

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

  on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);

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

drop table if exists estimatedatadetail cascade;

create table estimatedatadetail (

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

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

  on estimatedatadetail(ConstructionCode,PageCount);

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

drop table if exists expensesmaster cascade;

create table expensesmaster (

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

  , NameCode smallint(6) not null comment '?o????R?[?h'

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

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

drop table if exists holidaycalendermaster cascade;

create table holidaycalendermaster (

  Holiday date not null comment '?x??'

  , BusinessYear smallint(5) unsigned not null comment '?c??N?x'

  on holidaycalendermaster(TargetDay);

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

drop table if exists inputbillingdata cascade;

create table inputbillingdata (

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

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

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

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

drop table if exists inputbillingdatadetail cascade;

create table inputbillingdatadetail (

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

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

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

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

drop table if exists inputbillingstatus cascade;

create table inputbillingstatus (

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

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

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

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

drop table if exists inputsearchlogdata cascade;

create table inputsearchlogdata (

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

  , UsedProcessNo decimal(4,0) not null comment '?g?p?@?\???'

  on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);

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

drop table if exists invoicedata cascade;

create table invoicedata (

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

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

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

-- ???[???R???e???c?}?X?^

drop table if exists mailcontentsmaster cascade;

create table mailcontentsmaster (

  MailDelivery decimal(3,0) not null comment '???M??????'

  , MailTitle varchar(30) comment '???[???^?C?g??'

  , MailContent varchar(400) comment '???[???{??'

  , constraint mailcontentsmaster_PKC primary key (MailDelivery)

) comment '???[???R???e???c?}?X?^' ;

-- ??????

drop table if exists materialinfo cascade;

create table materialinfo (

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

  , MATERIALCOUNT smallint(5) unsigned comment '?????'

) comment '??????' ;

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

drop table if exists materialitemmaster cascade;

create table materialitemmaster (

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

  , MATERIALKINDCODE smallint(5) unsigned comment '??????R?[?h'

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

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

drop table if exists materialkindmaster cascade;

create table materialkindmaster (

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

  , MATERIALKINDNAME varchar(40) comment '?????????'

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

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

drop table if exists materialrecordinfo cascade;

create table materialrecordinfo (

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

  , PROCESSDATE date default '0000-00-00' not null comment '?????N????'

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

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

drop table if exists messageboarddata cascade;

create table messageboarddata (

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

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

  on messageboarddata(MessageFlag);

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

drop table if exists messageboardterget cascade;

create table messageboardterget (

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

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

  on messageboardterget(RecordNumber,BranchNumber);

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

drop table if exists messagebrowsinghistory cascade;

create table messagebrowsinghistory (

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

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

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

-- ???}?X?^

drop table if exists monthmaster cascade;

create table monthmaster (

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

  , constraint monthmaster_PKC primary key (month)

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

-- ???m?????

drop table if exists notificationmessage cascade;

create table notificationmessage (

  MessageDate datetime not null comment '?\???N????'

  , SeqNo decimal(3,0) unsigned not null comment '?A??'

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

-- ???m???{?????

drop table if exists notificationmessagebrowsing cascade;

create table notificationmessagebrowsing (

  MessageDate datetime not null comment '?\???N????'

  , SeqNo decimal(4,0) unsigned not null comment '?A??'

  on notificationmessagebrowsing(CompanyCode);

-- ???m???????I?????

drop table if exists notificationmessageselect cascade;

create table notificationmessageselect (

  MessageDate datetime not null comment '?\???N????'

  , SeqNo decimal(4,0) unsigned not null comment '?A??'

) comment '???m???????I?????' ;

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

drop table if exists orderersmaster cascade;

create table orderersmaster (

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

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

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

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

drop table if exists orderspricedata cascade;

create table orderspricedata (

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

  , ChangeNo decimal(3,0) unsigned not null comment '??X???'

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

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

drop table if exists paymentapprovalinfo cascade;

create table paymentapprovalinfo (

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

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

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

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

drop table if exists paymentdatadetail cascade;

create table paymentdatadetail (

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

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

  on paymentdatadetail(APPROVALPERSONCODE);

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

drop table if exists periodavoidance cascade;

create table periodavoidance (

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

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

  on periodavoidance(FieldNo);

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

drop table if exists personapproval cascade;

create table personapproval (

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

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

  on personapproval(PersonCodeApproval);

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

drop table if exists personapprovalcomment cascade;

create table personapprovalcomment (

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

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

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

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

drop table if exists persondepartmentmaster cascade;

create table persondepartmentmaster (

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

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

  on persondepartmentmaster(DepartmentCode);

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

drop table if exists personinchargemaster cascade;

create table personinchargemaster (

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

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

  on personinchargemaster(DepartmentCode);

-- ?S??????i?f?[?^

drop table if exists personqualification cascade;

create table personqualification (

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

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

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

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

drop table if exists personsalarymaster cascade;

create table personsalarymaster (

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

  , StartDate date not null comment '?g?p?J?n?N????'

  on personsalarymaster(MonthlySalary);

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

drop table if exists pointingoutcomment cascade;

create table pointingoutcomment (

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

  , ProcessNo smallint(6) not null comment '????????i??????j'

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

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

drop table if exists proceedingsdata cascade;

create table proceedingsdata (

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

  , ProceedingsDataDate date not null comment '?c???^????'

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

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

drop table if exists proceedingsdataattend cascade;

create table proceedingsdataattend (

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

  , ProceedingsDataDate date not null comment '?c???^????'

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

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

drop table if exists proceedingsdatadetail cascade;

create table proceedingsdatadetail (

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

  , ProceedingsDataDate date not null comment '?c???^????'

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

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

drop table if exists processapproval cascade;

create table processapproval (

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

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

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

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

drop table if exists processapprovalcomment cascade;

create table processapprovalcomment (

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

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

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

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

drop table if exists processapprovaldetail cascade;

create table processapprovaldetail (

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

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

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

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

drop table if exists processexcutemaster cascade;

create table processexcutemaster (

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

  , ExecCode decimal(4,0) unsigned not null comment '?N?????????'

  on processexcutemaster(ExecCode);

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

drop table if exists purchaseorder cascade;

create table purchaseorder (

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

  , SeqNo decimal(3,0) unsigned not null comment '???????}??'

  , RePrintFlag decimal(1,0) default '0' not null comment '??????\?t???O?i???g?p?j'

  , OrderDate date not null comment '??E?L?????Z???N????'

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

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

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

  , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)

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

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

drop table if exists purchaseorderdate cascade;

create table purchaseorderdate (

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

  , SeqNo decimal(3,0) unsigned not null comment '???????}??'

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

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

drop table if exists purchaseorderdetail cascade;

create table purchaseorderdetail (

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

  , SeqNo decimal(3,0) unsigned not null comment '???????}??'

  on purchaseorderdetail(SourceCode);

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

drop table if exists qualificationmaster cascade;

create table qualificationmaster (

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

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

  on qualificationmaster(DisplayOrder);

-- ???R?[?h??????

drop table if exists recordkey cascade;

create table recordkey (

  KeyNo decimal(2,0) unsigned not null comment '?L?[?R?[?h'

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

) comment '???R?[?h??????' ;

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

drop table if exists reminvoicedata cascade;

create table reminvoicedata (

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

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