Index: ProcessManagement.sql
===================================================================
--- ProcessManagement.sql	(revision 486)
+++ ProcessManagement.sql	(revision 487)
@@ -1,5 +1,5 @@
 -- Project Name : noname
--- Date/Time    : 2020/01/25 17:17:05
+-- Date/Time    : 2020/08/17 9:32:32
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
@@ -71,6 +71,7 @@
   , OvertimeWA decimal(5,2) not null comment 'Žc‹Æ”F‰ÂŽžŠÔ'
   , WorkingComment varchar(120) comment 'ƒRƒ�ƒ“ƒg'
   , WorkKindFlg decimal(2,0) not null comment '�ì‹Æ‹æ•ªƒtƒ‰ƒO'
+  , WorkingCode decimal(3,0) unsigned not null comment '�A‹ÆƒR�[ƒh'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)
@@ -130,6 +131,7 @@
   , Note varchar(300) comment '”õ�l'
   , ApprovalDate decimal(6,0) unsigned not null comment '�³”F“ú'
   , ApprovalNo decimal(2,0) unsigned not null comment '�³”FŽó•t”Ô�†'
+  , WorkingCode decimal(3,0) unsigned not null comment '�A‹ÆƒR�[ƒh'
   , DeleteFlg decimal(1,0) unsigned not null comment '�í�œƒtƒ‰ƒO'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
@@ -136,6 +138,15 @@
   , constraint attendancenotice_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)
 ) comment '‹Î‘Ó“Í�oƒf�[ƒ^' ;
 
+create index AttendanceNotice_Index1
+  on attendancenotice(PersonCode);
+
+create index AttendanceNotice_Index2
+  on attendancenotice(AttendanceNo);
+
+create index AttendanceNotice_Index3
+  on attendancenotice(AttendanceMonth);
+
 -- ‹Î‘Ó“Í�o•R•t‚¯ƒf�[ƒ^
 --* BackupToTempTable
 drop table if exists attendancenoticelink cascade;
@@ -236,6 +247,38 @@
   , constraint beforecreatingledger_PKC primary key (ConstructionCode,GroupCount,TargetMonth)
 ) comment '�HŽ–�Ú�×‘ä’ �ì�¬‘Oƒf�[ƒ^' ;
 
+-- ‹ÆŽÒ�¿‹�•”���o”[ƒŠƒ“ƒNƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists billingcostdatalink cascade;
+
+--* RestoreFromTempTable
+create table billingcostdatalink (
+  CompanyCode decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , TargetDate decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
+  , SeqNoB decimal(3,0) default '0' not null comment '˜A”Ô'
+  , LineCount decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , LabourKind decimal(1,0) not null comment 'Žx•¥‚¢’Ê�í�EŽèŠÔ‹æ•ª'
+  , LinkType decimal(1,0) not null comment 'ƒŠƒ“ƒN�æƒf�[ƒ^ƒ^ƒCƒv'
+  , YearNumber smallint(5) unsigned not null comment '”N“x'
+  , CostType decimal(1,0) not null comment '�o”[ƒ^ƒCƒvƒtƒ‰ƒO'
+  , TargetType decimal(1,0) not null comment '‘Î�Û�æƒR�[ƒhƒ^ƒCƒv'
+  , TargetCode decimal(10,0) not null comment '‘Î�Û�æƒR�[ƒh'
+  , SeqNoC decimal(3,0) not null comment 'ƒf�[ƒ^”Ô�†'
+  , PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  , ActionDate date not null comment '‘Î�Û“ú•t'
+  , DataType decimal(1,0) not null comment 'ƒf�[ƒ^‹æ•ª'
+  , DataAddCount decimal(5,0) unsigned not null comment 'ƒf�[ƒ^’Ç‰Á”Ô�†'
+  , EntryDate datetime comment '“o˜^”NŒŽ“ú'
+  , UpdateDate datetime comment '�X�V”NŒŽ“ú'
+  , constraint billingcostdatalink_PKC primary key (CompanyCode,TargetDate,SeqNoB,LineCount,LabourKind)
+) comment '‹ÆŽÒ�¿‹�•”���o”[ƒŠƒ“ƒNƒf�[ƒ^' ;
+
+create index BillingCostDataLink_Index1
+  on billingcostdatalink(YearNumber,CostType,TargetType,TargetCode,SeqNoC);
+
+create index BillingCostDataLink_Index2
+  on billingcostdatalink(PersonCode,ActionDate,DataType,DataAddCount);
+
 -- ‹ÆŽÒ�¿‹�ƒf�[ƒ^
 --* BackupToTempTable
 drop table if exists billingdata cascade;
@@ -477,7 +520,7 @@
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
   , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
-  , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
+  , LineCount decimal(4,0) unsigned not null comment '�s”Ô�†'
   , DataType decimal(1,0) not null comment 'ƒf�[ƒ^Ží•Ê'
   , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -530,6 +573,29 @@
 create index BusinessTypeMaster_Index1
   on businesstypemaster(DisplayOrder);
 
+-- ŒvŽZŒW�”•ÛŽ�ƒe�[ƒuƒ‹
+--* BackupToTempTable
+drop table if exists calccoefficient cascade;
+
+--* RestoreFromTempTable
+create table calccoefficient (
+  TypeCode decimal(2,0) unsigned not null comment 'ŒW�”ƒ^ƒCƒvƒR�[ƒh'
+  , SeqNo decimal(2,0) unsigned not null comment '�‡�˜'
+  , CalcCoefficient01 decimal(15,5) not null comment 'ŒW�”’l1'
+  , CalcCoefficient02 decimal(15,5) not null comment 'ŒW�”’l2'
+  , CalcCoefficient03 decimal(15,5) not null comment 'ŒW�”’l3'
+  , CalcCoefficient04 decimal(15,5) not null comment 'ŒW�”’l4'
+  , CalcCoefficient05 decimal(15,5) not null comment 'ŒW�”’l5'
+  , CalcCoefficient06 decimal(15,5) not null comment 'ŒW�”’l6'
+  , CalcCoefficient07 decimal(15,5) not null comment 'ŒW�”’l7'
+  , CalcCoefficient08 decimal(15,5) not null comment 'ŒW�”’l8'
+  , CalcCoefficient09 decimal(15,5) not null comment 'ŒW�”’l9'
+  , CalcCoefficient10 decimal(15,5) not null comment 'ŒW�”’l10'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint calccoefficient_PKC primary key (TypeCode,SeqNo)
+) comment 'ŒvŽZŒW�”•ÛŽ�ƒe�[ƒuƒ‹' ;
+
 -- ’S“–ŽÒ•”��—š—ðƒf�[ƒ^
 --* BackupToTempTable
 drop table if exists chgchargedep cascade;
@@ -793,6 +859,7 @@
   , InspectExecuteDate date not null comment 'ŒŸ�¸ŽÀ�s“ú'
   , RevCompleteDate date not null comment 'ŒŸ�¸�¥�³Š®—¹“ú'
   , ExpectedOrder decimal(3,0) not null comment 'Žó’�Šú‘Ò“x'
+  , EvaluationScore decimal(5,2) unsigned not null comment '•]‰¿“_�”'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
@@ -1026,6 +1093,21 @@
 create index LedgerExcute_Index1
   on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);
 
+create index LedgerExcute_Index2
+  on constructionledgerexcute(ConstructionCode);
+
+create index LedgerExcute_Index3
+  on constructionledgerexcute(GroupCount);
+
+create index LedgerExcute_Index4
+  on constructionledgerexcute(LineCount);
+
+create index LedgerExcute_Index5
+  on constructionledgerexcute(ColumnCount);
+
+create index LedgerExcute_Index6
+  on constructionledgerexcute(TargetMonth);
+
 -- �HŽ–ƒŠƒ“ƒN�î•ñ
 --* BackupToTempTable
 drop table if exists constructionlink cascade;
@@ -1170,6 +1252,53 @@
 
 -- •”���o”[ƒf�[ƒ^
 --* BackupToTempTable
+drop table if exists costdataofcompensation cascade;
+
+--* RestoreFromTempTable
+create table costdataofcompensation (
+  YearNumber smallint(5) unsigned not null comment '”N“x'
+  , CostType decimal(1,0) not null comment '�o”[ƒ^ƒCƒvƒtƒ‰ƒO'
+  , TargetType decimal(1,0) not null comment '‘Î�Û�æƒR�[ƒhƒ^ƒCƒv'
+  , TargetCode decimal(10,0) not null comment '‘Î�Û�æƒR�[ƒh'
+  , SeqNo decimal(3,0) not null comment 'ƒf�[ƒ^”Ô�†'
+  , PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , FromCodeType decimal(1,0) not null comment '�o”[Œ³ƒR�[ƒhƒ^ƒCƒv'
+  , FromCode decimal(10,0) not null comment '�o”[Œ³ƒR�[ƒh'
+  , SendDate date not null comment '‘Î�Û“ú•t'
+  , LinkCode decimal(10,0) not null comment 'ƒŠƒ“ƒN�æ�HŽ–ƒR�[ƒh'
+  , EntryPrice decimal(10,0) not null comment '‹àŠz�i�Å”²�j'
+  , EntryTax decimal(10,0) not null comment '‹àŠz�i�Å�ž�j'
+  , Content varchar(120) comment 'Žx•¥“à—e'
+  , BikoComment varchar(120) comment '”õ�l'
+  , LockFlg decimal(1,0) not null comment 'ƒf�[ƒ^ƒ�ƒbƒN'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint costdataofcompensation_PKC primary key (YearNumber,CostType,TargetType,TargetCode,SeqNo)
+) comment '•”���o”[ƒf�[ƒ^' ;
+
+create index CostDataOfCompensation_Index1
+  on costdataofcompensation(YearNumber);
+
+create index CostDataOfCompensation_Index2
+  on costdataofcompensation(CostType);
+
+create index CostDataOfCompensation_Index3
+  on costdataofcompensation(TargetType);
+
+create index CostDataOfCompensation_Index4
+  on costdataofcompensation(TargetCode);
+
+create index CostDataOfCompensation_Index5
+  on costdataofcompensation(PersonCode);
+
+create index CostDataOfCompensation_Index6
+  on costdataofcompensation(FromCode);
+
+create index CostDataOfCompensation_Index7
+  on costdataofcompensation(SendDate);
+
+-- •”���o”[ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists costdataofdepartment cascade;
 
 --* RestoreFromTempTable
@@ -1223,6 +1352,49 @@
 create index CostDataOfPerson_Index2
   on costdataofperson(ConstructionCode);
 
+-- �o”[‘Î�ÛŒo”ï‘Î‰žƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists costdatatargettypeexpenses cascade;
+
+--* RestoreFromTempTable
+create table costdatatargettypeexpenses (
+  CostType decimal(1,0) not null comment '�o”[ƒ^ƒCƒvƒtƒ‰ƒO'
+  , TargetType decimal(1,0) not null comment '�o”[�æƒR�[ƒhƒ^ƒCƒv'
+  , ExpensesCode decimal(6,0) not null comment '‘Î�ÛŒo”ïƒR�[ƒh'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint costdatatargettypeexpenses_PKC primary key (CostType,TargetType,ExpensesCode)
+) comment '�o”[‘Î�ÛŒo”ï‘Î‰žƒ}ƒXƒ^' ;
+
+create index CostDataTargetTypeExpenses_Index1
+  on costdatatargettypeexpenses(CostType);
+
+create index CostDataTargetTypeExpenses_Index2
+  on costdatatargettypeexpenses(TargetType);
+
+create index CostDataTargetTypeExpenses_Index3
+  on costdatatargettypeexpenses(ExpensesCode);
+
+-- �o”[ƒ^ƒCƒv–¼�Ìƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists costdatatype cascade;
+
+--* RestoreFromTempTable
+create table costdatatype (
+  CostType decimal(1,0) not null comment '�o”[ƒ^ƒCƒvƒR�[ƒh'
+  , TargetType decimal(1,0) not null comment '�o”[�æƒR�[ƒhƒ^ƒCƒv'
+  , CostDataTypeName varchar(60) comment '�o”[ƒ^ƒCƒv–¼�Ì'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint costdatatype_PKC primary key (CostType,TargetType)
+) comment '�o”[ƒ^ƒCƒv–¼�Ìƒ}ƒXƒ^' ;
+
+create index CostDataType_Index1
+  on costdatatype(CostType);
+
+create index CostDataType_Index2
+  on costdatatype(TargetType);
+
 -- ”­’�ŽÒ“o˜^�\�¿ƒf�[ƒ^
 --* BackupToTempTable
 drop table if exists costomerregist cascade;
@@ -1276,24 +1448,21 @@
 
 --* RestoreFromTempTable
 create table dailydataconstruction (
-  PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
-  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , Weather varchar(60) comment '“V‹C'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint dailydataconstruction_PKC primary key (PersonCode,DailyDataDate,ConstructionCode)
+  , constraint dailydataconstruction_PKC primary key (ConstructionCode,DailyDataDate,PersonCode)
 ) comment '“ú•ñƒf�[ƒ^' ;
 
 create index DailyDataConstruction_Index1
-  on dailydataconstruction(PersonCode);
+  on dailydataconstruction(ConstructionCode);
 
 create index DailyDataConstruction_Index2
   on dailydataconstruction(DailyDataDate);
 
-create index DailyDataConstruction_Index3
-  on dailydataconstruction(ConstructionCode);
-
 -- “ú•ñƒf�[ƒ^ (–¾�×)
 --* BackupToTempTable
 drop table if exists dailydatadetail cascade;
@@ -1300,9 +1469,9 @@
 
 --* RestoreFromTempTable
 create table dailydatadetail (
-  PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
-  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
   , JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
   , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -1313,11 +1482,11 @@
   , NextdayHeadCount decimal(4,1) not null comment '—‚“ú�lˆõ�”'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint dailydatadetail_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+  , constraint dailydatadetail_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
 ) comment '“ú•ñƒf�[ƒ^ (–¾�×)' ;
 
 create index DailyDataDetail_Index
-  on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
+  on dailydatadetail(ConstructionCode,DailyDataDate,PersonCode);
 
 -- “ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)
 --* BackupToTempTable
@@ -1325,19 +1494,19 @@
 
 --* RestoreFromTempTable
 create table dailydatafield (
-  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
-  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
   , PatrolTime datetime not null comment '�„‰ñŽžŠÔ'
   , ContentsText varchar(200) comment '“à—e'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint dailydatafield_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+  , constraint dailydatafield_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
 ) comment '“ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)' ;
 
 create index DailyDataField_Index
-  on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
+  on dailydatafield(ConstructionCode,DailyDataDate);
 
 -- “ú•ñƒf�[ƒ^ (Ž‘�Þ)
 --* BackupToTempTable
@@ -1345,9 +1514,9 @@
 
 --* RestoreFromTempTable
 create table dailydatamaterials (
-  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
-  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
   , Materials varchar(100) comment 'Ž‘�Þ–¼'
   , Quantity varchar(100) comment '�”—Ê'
@@ -1356,11 +1525,11 @@
   , QualityControl varchar(100) comment '•iŽ¿ŠÇ—�Ž–�€'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint dailydatamaterials_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+  , constraint dailydatamaterials_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
 ) comment '“ú•ñƒf�[ƒ^ (Ž‘�Þ)' ;
 
 create index DailyDataMaterials_Index
-  on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
+  on dailydatamaterials(ConstructionCode,DailyDataDate);
 
 -- “ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)
 --* BackupToTempTable
@@ -1368,19 +1537,19 @@
 
 --* RestoreFromTempTable
 create table dailydatasubcontractors (
-  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
-  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
   , Attendee varchar(100) comment '�o�ÈŽÒ'
   , ContentsText varchar(200) comment '“à—e'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint dailydatasubcontractors_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+  , constraint dailydatasubcontractors_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
 ) comment '“ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)' ;
 
 create index DailyDataSubcontractors_Index
-  on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
+  on dailydatasubcontractors(ConstructionCode,DailyDataDate);
 
 -- “ú•ñƒf�[ƒ^ (ŽÔ—¼)
 --* BackupToTempTable
@@ -1388,9 +1557,9 @@
 
 --* RestoreFromTempTable
 create table dailydatavehicles (
-  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
-  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
   , Model varchar(100) comment '‹@Ží'
   , Performance varchar(100) comment '�«”\'
@@ -1400,11 +1569,11 @@
   , EndWorkingTime datetime not null comment '�ì‹ÆŽžŠÔ�I—¹'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint dailydatavehicles_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+  , constraint dailydatavehicles_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
 ) comment '“ú•ñƒf�[ƒ^ (ŽÔ—¼)' ;
 
 create index DailyDataVehicles_Index
-  on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
+  on dailydatavehicles(ConstructionCode,DailyDataDate);
 
 -- “úƒ}ƒXƒ^
 --* BackupToTempTable
@@ -1668,7 +1837,7 @@
 create table estimatedatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
-  , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
+  , LineCount decimal(4,0) unsigned not null comment '�s”Ô�†'
   , DataType decimal(1,0) not null comment 'ƒf�[ƒ^Ží•Ê'
   , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -1675,9 +1844,9 @@
   , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
   , ItemName varchar(120) comment '�ì‹Æ–¼�Ì'
   , SpecName varchar(120) comment '�ì‹Æ�^•iŽ¿�EŒ`�ó�E�¡–@'
-  , Unitcount decimal(8,2) not null comment '�”—Ê'
+  , Unitcount decimal(9,3) not null comment '�”—Ê'
   , UnitName varchar(30) comment '’PˆÊ–¼�Ì'
-  , UnitPrice decimal(9,2) not null comment '’P‰¿'
+  , UnitPrice decimal(11,2) not null comment '’P‰¿'
   , LineTotal decimal(12,0) not null comment '‹àŠz'
   , note varchar(60) comment '”õ�l'
   , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -1831,6 +2000,7 @@
   , COMMENT4 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg4'
   , COMMENT5 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg5'
   , COMPLETEFLG decimal(1,0) default '0' not null comment 'Š®—¹ƒtƒ‰ƒO'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
   , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
   , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
   , constraint invoicedata_PKC primary key (INVOICENO)
@@ -1838,6 +2008,22 @@
 
 alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
 
+-- ƒ�ƒOƒCƒ“—š—ð
+--* BackupToTempTable
+drop table if exists loginlog cascade;
+
+--* RestoreFromTempTable
+create table loginlog (
+  PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  , TargetMonth decimal(6,0) unsigned not null comment '‘Î�Û”NŒŽ'
+  , LastLogin datetime not null comment 'ŒŽ“à�Å�Iƒ�ƒOƒCƒ“ŽžŠÔ'
+  , LastLogout datetime not null comment 'ŒŽ“à�Å�Iƒ�ƒOƒAƒEƒgŽžŠÔ'
+  , TotalTime decimal(10,0) not null comment '—ÝŒvƒ�ƒOƒCƒ“ŽžŠÔ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint loginlog_PKC primary key (PersonCode,TargetMonth)
+) comment 'ƒ�ƒOƒCƒ“—š—ð' ;
+
 -- ƒ��[ƒ‹ƒRƒ“ƒeƒ“ƒcƒ}ƒXƒ^
 --* BackupToTempTable
 drop table if exists mailcontentsmaster cascade;
@@ -2068,6 +2254,7 @@
   , Address3 varchar(60) comment '�Z�Š3'
   , PhoneNumber varchar(13) comment '“d˜b”Ô�†'
   , FaxNumber varchar(13) comment 'FAX”Ô�†'
+  , JapaneseSyllabary varchar(2) comment '50‰¹“Ç‚Ý'
   , MailAddress varchar(257) comment 'ƒ��[ƒ‹ƒAƒhƒŒƒX'
   , Note varchar(300) comment '”õ�l'
   , PersonCode decimal(8,0) not null comment '“o˜^’S“–ŽÒƒR�[ƒh'
@@ -2077,6 +2264,9 @@
   , constraint orderersmaster_PKC primary key (OrderCotegory,OrderersCode)
 ) comment '”­’�ŽÒƒ}ƒXƒ^' ;
 
+create index orderersmaster_Index1
+  on orderersmaster(JapaneseSyllabary);
+
 -- Žó’�‹àŠzƒf�[ƒ^
 --* BackupToTempTable
 drop table if exists orderspricedata cascade;
@@ -2473,6 +2663,9 @@
   , constraint processapprovaldetail_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SerialNo)
 ) comment '�³”F–¾�×ƒf�[ƒ^' ;
 
+create index processapprovaldetail_Index1
+  on processapprovaldetail(ConstructionCode,ApprovalCode,LinkCode);
+
 -- ‹N“®‘Î�Ûƒ}ƒXƒ^
 --* BackupToTempTable
 drop table if exists processexcutemaster cascade;
@@ -2479,7 +2672,7 @@
 
 --* RestoreFromTempTable
 create table processexcutemaster (
-  SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
+  SecCode decimal(4,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
   , ExecCode decimal(4,0) unsigned not null comment '‹N“®�ˆ—�”Ô�†'
   , EditFlg decimal(1,0) not null comment '•Ò�Wƒtƒ‰ƒO'
   , EntryDate datetime not null comment '“o˜^“ú•t'
@@ -2608,6 +2801,68 @@
 create index QualificationMaster_Index3
   on qualificationmaster(DisplayOrder);
 
+-- ‚S”¼Šú•Ê”„�ãƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists quarterlysales cascade;
+
+--* RestoreFromTempTable
+create table quarterlysales (
+  YearCode decimal(5,0) unsigned not null comment '‘Î�Û”N“x'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , OrderNo decimal(4,0) unsigned not null comment 'ƒf�[ƒ^�‡'
+  , ConstructionStart date comment 'Œ_–ñ�HŠúŠJŽn“ú'
+  , ConstructionEnd date comment 'Œ_–ñ�HŠúŠ®—¹'
+  , OrdersPrice decimal(12,0) not null comment '�Å”²Žó’�‹àŠz'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint quarterlysales_PKC primary key (YearCode,ConstructionCode,OrderNo)
+) comment '‚S”¼Šú•Ê”„�ãƒf�[ƒ^' ;
+
+create index QuarterlySales_Index1
+  on quarterlysales(YearCode);
+
+create index QuarterlySales_Index2
+  on quarterlysales(ConstructionCode);
+
+create index QuarterlySales_Index3
+  on quarterlysales(OrderNo);
+
+-- ‚S”¼Šú•Ê”„�ã–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists quarterlysalesdetail cascade;
+
+--* RestoreFromTempTable
+create table quarterlysalesdetail (
+  YearCode decimal(5,0) unsigned not null comment '‘Î�Û”N“x'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , OrderNo decimal(4,0) unsigned not null comment 'ƒf�[ƒ^�‡'
+  , SeqNo decimal(2,0) not null comment 'ƒf�[ƒ^”Ô�†'
+  , DataType decimal(1,0) unsigned not null comment 'ƒf�[ƒ^ƒ^ƒCƒv'
+  , DataYM decimal(6,0) unsigned not null comment '‘Î�Û”NŒŽ'
+  , PriceValue decimal(12,0) not null comment '‘Î�Û‹àŠz'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint quarterlysalesdetail_PKC primary key (YearCode,ConstructionCode,OrderNo,SeqNo,DataType)
+) comment '‚S”¼Šú•Ê”„�ã–¾�×ƒf�[ƒ^' ;
+
+create index QuarterlySalesDetail_Index1
+  on quarterlysalesdetail(YearCode);
+
+create index QuarterlySalesDetail_Index2
+  on quarterlysalesdetail(ConstructionCode);
+
+create index QuarterlySalesDetail_Index3
+  on quarterlysalesdetail(OrderNo);
+
+create index QuarterlySalesDetail_Index4
+  on quarterlysalesdetail(SeqNo);
+
+create index QuarterlySalesDetail_Index5
+  on quarterlysalesdetail(DataType);
+
+create index QuarterlySalesDetail_Index6
+  on quarterlysalesdetail(DataYM);
+
 -- ƒŒƒR�[ƒh”Ô�†ŠÇ—�
 --* BackupToTempTable
 drop table if exists recordkey cascade;
@@ -2775,6 +3030,7 @@
   , INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
   , BILLINGDATE datetime not null comment '�¿‹�“ú'
   , BILLCONFIRMDATE datetime not null comment '�¿‹�Šm”F“ú'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
   , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
   , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
   , constraint requesthead_PKC primary key (REQUESTNO)
@@ -2828,13 +3084,14 @@
 
 --* RestoreFromTempTable
 create table securitymaster (
-  SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
-  , DisplayOrder decimal(2,0) not null comment '•\Ž¦�‡'
+  SecCode decimal(4,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
+  , DisplayOrder decimal(4,0) not null comment '•\Ž¦�‡'
   , SecName varchar(60) not null comment '•ÛŒì‹æ•ª–¼�Ì'
   , SecRank decimal(1,0) not null comment '•ÛŒì‹æ•ªƒ‰ƒ“ƒN'
   , SecRange decimal(1,0) not null comment '•ÛŒì‹æ•ª”ÍˆÍ'
   , GeneralAffairs decimal(1,0) not null comment '‘�–±‹Æ–±ƒtƒ‰ƒO'
   , SelectBackColor varchar(8) not null comment '‘I‘ð”wŒi�F'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint securitymaster_PKC primary key (SecCode)
@@ -3201,6 +3458,10 @@
   , SloganString2 varchar(100) comment '•WŒê2'
   , SloganString3 varchar(100) comment '•WŒê3'
   , OperationFlg decimal(2,0) unsigned not null comment '�³”F‰^—pƒtƒ‰ƒO'
+  , SystemOpenTime datetime not null comment '‰^—pŠJŽnŽžŠÔ'
+  , SystemCloseTime datetime not null comment '‰^—p�I—¹ŽžŠÔ'
+  , PesrsonCost1 decimal(7,0) unsigned not null comment 'ŒÅ’è�lŒ�”ï‚P�iŽw“±ˆõƒRƒXƒg�j'
+  , PesrsonCost2 decimal(7,0) unsigned not null comment 'ŒÅ’è�lŒ�”ï‚Q�i•›’S“–ŽÒƒRƒXƒg�j'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint systemmaster_PKC primary key (SystemCode)
