リビジョン 487
製品版対応
| ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2020/01/25 17:17:05
|
|
| 2 |
-- Date/Time : 2020/08/17 9:32:32
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 71 | 71 |
, OvertimeWA decimal(5,2) not null comment '?c??F?????' |
| 72 | 72 |
, WorkingComment varchar(120) comment '?R?????g' |
| 73 | 73 |
, WorkKindFlg decimal(2,0) not null comment '?????t???O' |
| 74 |
, WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h' |
|
| 74 | 75 |
, EntryDate datetime not null comment '?o?^???t' |
| 75 | 76 |
, UpdateDate datetime not null comment '?X?V???t' |
| 76 | 77 |
, constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo) |
| ... | ... | |
| 130 | 131 |
, Note varchar(300) comment '???l' |
| 131 | 132 |
, ApprovalDate decimal(6,0) unsigned not null comment '???F??' |
| 132 | 133 |
, ApprovalNo decimal(2,0) unsigned not null comment '???F??t???' |
| 134 |
, WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h' |
|
| 133 | 135 |
, DeleteFlg decimal(1,0) unsigned not null comment '???t???O' |
| 134 | 136 |
, EntryDate datetime not null comment '?o?^???t' |
| 135 | 137 |
, UpdateDate datetime not null comment '?X?V???t' |
| 136 | 138 |
, constraint attendancenotice_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo) |
| 137 | 139 |
) comment '????o?f?[?^' ; |
| 138 | 140 |
|
| 141 |
create index AttendanceNotice_Index1 |
|
| 142 |
on attendancenotice(PersonCode); |
|
| 143 |
|
|
| 144 |
create index AttendanceNotice_Index2 |
|
| 145 |
on attendancenotice(AttendanceNo); |
|
| 146 |
|
|
| 147 |
create index AttendanceNotice_Index3 |
|
| 148 |
on attendancenotice(AttendanceMonth); |
|
| 149 |
|
|
| 139 | 150 |
-- ????o?R?t???f?[?^ |
| 140 | 151 |
--* BackupToTempTable |
| 141 | 152 |
drop table if exists attendancenoticelink cascade; |
| ... | ... | |
| 236 | 247 |
, constraint beforecreatingledger_PKC primary key (ConstructionCode,GroupCount,TargetMonth) |
| 237 | 248 |
) comment '?H?????????O?f?[?^' ; |
| 238 | 249 |
|
| 250 |
-- ???????????o?[?????N?f?[?^ |
|
| 251 |
--* BackupToTempTable |
|
| 252 |
drop table if exists billingcostdatalink cascade; |
|
| 253 |
|
|
| 254 |
--* RestoreFromTempTable |
|
| 255 |
create table billingcostdatalink ( |
|
| 256 |
CompanyCode decimal(8,0) default '0' not null comment '??????R?[?h' |
|
| 257 |
, TargetDate decimal(6,0) default '0' not null comment '???N??' |
|
| 258 |
, SeqNoB decimal(3,0) default '0' not null comment '?A??' |
|
| 259 |
, LineCount decimal(3,0) default '0' not null comment '?s???' |
|
| 260 |
, LabourKind decimal(1,0) not null comment '?x???????E????' |
|
| 261 |
, LinkType decimal(1,0) not null comment '?????N??f?[?^?^?C?v' |
|
| 262 |
, YearNumber smallint(5) unsigned not null comment '?N?x' |
|
| 263 |
, CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O' |
|
| 264 |
, TargetType decimal(1,0) not null comment '????R?[?h?^?C?v' |
|
| 265 |
, TargetCode decimal(10,0) not null comment '????R?[?h' |
|
| 266 |
, SeqNoC decimal(3,0) not null comment '?f?[?^???' |
|
| 267 |
, PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h' |
|
| 268 |
, ActionDate date not null comment '?????t' |
|
| 269 |
, DataType decimal(1,0) not null comment '?f?[?^??' |
|
| 270 |
, DataAddCount decimal(5,0) unsigned not null comment '?f?[?^??????' |
|
| 271 |
, EntryDate datetime comment '?o?^?N????' |
|
| 272 |
, UpdateDate datetime comment '?X?V?N????' |
|
| 273 |
, constraint billingcostdatalink_PKC primary key (CompanyCode,TargetDate,SeqNoB,LineCount,LabourKind) |
|
| 274 |
) comment '???????????o?[?????N?f?[?^' ; |
|
| 275 |
|
|
| 276 |
create index BillingCostDataLink_Index1 |
|
| 277 |
on billingcostdatalink(YearNumber,CostType,TargetType,TargetCode,SeqNoC); |
|
| 278 |
|
|
| 279 |
create index BillingCostDataLink_Index2 |
|
| 280 |
on billingcostdatalink(PersonCode,ActionDate,DataType,DataAddCount); |
|
| 281 |
|
|
| 239 | 282 |
-- ???????f?[?^ |
| 240 | 283 |
--* BackupToTempTable |
| 241 | 284 |
drop table if exists billingdata cascade; |
| ... | ... | |
| 477 | 520 |
SaveDate datetime not null comment '?????t' |
| 478 | 521 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
| 479 | 522 |
, PageCount decimal(4,0) unsigned not null comment '?y?[?W???' |
| 480 |
, LineCount decimal(3,0) unsigned not null comment '?s???'
|
|
| 523 |
, LineCount decimal(4,0) unsigned not null comment '?s???'
|
|
| 481 | 524 |
, DataType decimal(1,0) not null comment '?f?[?^???' |
| 482 | 525 |
, ComponentCode decimal(5,0) unsigned not null comment '?\???L?[' |
| 483 | 526 |
, ItemCode decimal(5,0) unsigned not null comment '?H??L?[' |
| ... | ... | |
| 530 | 573 |
create index BusinessTypeMaster_Index1 |
| 531 | 574 |
on businesstypemaster(DisplayOrder); |
| 532 | 575 |
|
| 576 |
-- ?v?Z?W??????e?[?u?? |
|
| 577 |
--* BackupToTempTable |
|
| 578 |
drop table if exists calccoefficient cascade; |
|
| 579 |
|
|
| 580 |
--* RestoreFromTempTable |
|
| 581 |
create table calccoefficient ( |
|
| 582 |
TypeCode decimal(2,0) unsigned not null comment '?W???^?C?v?R?[?h' |
|
| 583 |
, SeqNo decimal(2,0) unsigned not null comment '????' |
|
| 584 |
, CalcCoefficient01 decimal(15,5) not null comment '?W???l1' |
|
| 585 |
, CalcCoefficient02 decimal(15,5) not null comment '?W???l2' |
|
| 586 |
, CalcCoefficient03 decimal(15,5) not null comment '?W???l3' |
|
| 587 |
, CalcCoefficient04 decimal(15,5) not null comment '?W???l4' |
|
| 588 |
, CalcCoefficient05 decimal(15,5) not null comment '?W???l5' |
|
| 589 |
, CalcCoefficient06 decimal(15,5) not null comment '?W???l6' |
|
| 590 |
, CalcCoefficient07 decimal(15,5) not null comment '?W???l7' |
|
| 591 |
, CalcCoefficient08 decimal(15,5) not null comment '?W???l8' |
|
| 592 |
, CalcCoefficient09 decimal(15,5) not null comment '?W???l9' |
|
| 593 |
, CalcCoefficient10 decimal(15,5) not null comment '?W???l10' |
|
| 594 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 595 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 596 |
, constraint calccoefficient_PKC primary key (TypeCode,SeqNo) |
|
| 597 |
) comment '?v?Z?W??????e?[?u??' ; |
|
| 598 |
|
|
| 533 | 599 |
-- ?S????????????f?[?^ |
| 534 | 600 |
--* BackupToTempTable |
| 535 | 601 |
drop table if exists chgchargedep cascade; |
| ... | ... | |
| 793 | 859 |
, InspectExecuteDate date not null comment '???????s??' |
| 794 | 860 |
, RevCompleteDate date not null comment '??????????????' |
| 795 | 861 |
, ExpectedOrder decimal(3,0) not null comment '?????x' |
| 862 |
, EvaluationScore decimal(5,2) unsigned not null comment '?]???_??' |
|
| 796 | 863 |
, EntryDate datetime not null comment '?o?^???t' |
| 797 | 864 |
, UpdateDate datetime not null comment '?X?V???t' |
| 798 | 865 |
, constraint constructionbaseinfo_PKC primary key (ConstructionCode) |
| ... | ... | |
| 1026 | 1093 |
create index LedgerExcute_Index1 |
| 1027 | 1094 |
on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount); |
| 1028 | 1095 |
|
| 1096 |
create index LedgerExcute_Index2 |
|
| 1097 |
on constructionledgerexcute(ConstructionCode); |
|
| 1098 |
|
|
| 1099 |
create index LedgerExcute_Index3 |
|
| 1100 |
on constructionledgerexcute(GroupCount); |
|
| 1101 |
|
|
| 1102 |
create index LedgerExcute_Index4 |
|
| 1103 |
on constructionledgerexcute(LineCount); |
|
| 1104 |
|
|
| 1105 |
create index LedgerExcute_Index5 |
|
| 1106 |
on constructionledgerexcute(ColumnCount); |
|
| 1107 |
|
|
| 1108 |
create index LedgerExcute_Index6 |
|
| 1109 |
on constructionledgerexcute(TargetMonth); |
|
| 1110 |
|
|
| 1029 | 1111 |
-- ?H???????N??? |
| 1030 | 1112 |
--* BackupToTempTable |
| 1031 | 1113 |
drop table if exists constructionlink cascade; |
| ... | ... | |
| 1170 | 1252 |
|
| 1171 | 1253 |
-- ?????o?[?f?[?^ |
| 1172 | 1254 |
--* BackupToTempTable |
| 1255 |
drop table if exists costdataofcompensation cascade; |
|
| 1256 |
|
|
| 1257 |
--* RestoreFromTempTable |
|
| 1258 |
create table costdataofcompensation ( |
|
| 1259 |
YearNumber smallint(5) unsigned not null comment '?N?x' |
|
| 1260 |
, CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O' |
|
| 1261 |
, TargetType decimal(1,0) not null comment '????R?[?h?^?C?v' |
|
| 1262 |
, TargetCode decimal(10,0) not null comment '????R?[?h' |
|
| 1263 |
, SeqNo decimal(3,0) not null comment '?f?[?^???' |
|
| 1264 |
, PersonCode decimal(8,0) unsigned not null comment '????R?[?h' |
|
| 1265 |
, FromCodeType decimal(1,0) not null comment '?o?[???R?[?h?^?C?v' |
|
| 1266 |
, FromCode decimal(10,0) not null comment '?o?[???R?[?h' |
|
| 1267 |
, SendDate date not null comment '?????t' |
|
| 1268 |
, LinkCode decimal(10,0) not null comment '?????N??H???R?[?h' |
|
| 1269 |
, EntryPrice decimal(10,0) not null comment '???z?i????j' |
|
| 1270 |
, EntryTax decimal(10,0) not null comment '???z?i????j' |
|
| 1271 |
, Content varchar(120) comment '?x?????e' |
|
| 1272 |
, BikoComment varchar(120) comment '???l' |
|
| 1273 |
, LockFlg decimal(1,0) not null comment '?f?[?^???b?N' |
|
| 1274 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 1275 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 1276 |
, constraint costdataofcompensation_PKC primary key (YearNumber,CostType,TargetType,TargetCode,SeqNo) |
|
| 1277 |
) comment '?????o?[?f?[?^' ; |
|
| 1278 |
|
|
| 1279 |
create index CostDataOfCompensation_Index1 |
|
| 1280 |
on costdataofcompensation(YearNumber); |
|
| 1281 |
|
|
| 1282 |
create index CostDataOfCompensation_Index2 |
|
| 1283 |
on costdataofcompensation(CostType); |
|
| 1284 |
|
|
| 1285 |
create index CostDataOfCompensation_Index3 |
|
| 1286 |
on costdataofcompensation(TargetType); |
|
| 1287 |
|
|
| 1288 |
create index CostDataOfCompensation_Index4 |
|
| 1289 |
on costdataofcompensation(TargetCode); |
|
| 1290 |
|
|
| 1291 |
create index CostDataOfCompensation_Index5 |
|
| 1292 |
on costdataofcompensation(PersonCode); |
|
| 1293 |
|
|
| 1294 |
create index CostDataOfCompensation_Index6 |
|
| 1295 |
on costdataofcompensation(FromCode); |
|
| 1296 |
|
|
| 1297 |
create index CostDataOfCompensation_Index7 |
|
| 1298 |
on costdataofcompensation(SendDate); |
|
| 1299 |
|
|
| 1300 |
-- ?????o?[?f?[?^ |
|
| 1301 |
--* BackupToTempTable |
|
| 1173 | 1302 |
drop table if exists costdataofdepartment cascade; |
| 1174 | 1303 |
|
| 1175 | 1304 |
--* RestoreFromTempTable |
| ... | ... | |
| 1223 | 1352 |
create index CostDataOfPerson_Index2 |
| 1224 | 1353 |
on costdataofperson(ConstructionCode); |
| 1225 | 1354 |
|
| 1355 |
-- ?o?[???o?????}?X?^ |
|
| 1356 |
--* BackupToTempTable |
|
| 1357 |
drop table if exists costdatatargettypeexpenses cascade; |
|
| 1358 |
|
|
| 1359 |
--* RestoreFromTempTable |
|
| 1360 |
create table costdatatargettypeexpenses ( |
|
| 1361 |
CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O' |
|
| 1362 |
, TargetType decimal(1,0) not null comment '?o?[??R?[?h?^?C?v' |
|
| 1363 |
, ExpensesCode decimal(6,0) not null comment '???o??R?[?h' |
|
| 1364 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 1365 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 1366 |
, constraint costdatatargettypeexpenses_PKC primary key (CostType,TargetType,ExpensesCode) |
|
| 1367 |
) comment '?o?[???o?????}?X?^' ; |
|
| 1368 |
|
|
| 1369 |
create index CostDataTargetTypeExpenses_Index1 |
|
| 1370 |
on costdatatargettypeexpenses(CostType); |
|
| 1371 |
|
|
| 1372 |
create index CostDataTargetTypeExpenses_Index2 |
|
| 1373 |
on costdatatargettypeexpenses(TargetType); |
|
| 1374 |
|
|
| 1375 |
create index CostDataTargetTypeExpenses_Index3 |
|
| 1376 |
on costdatatargettypeexpenses(ExpensesCode); |
|
| 1377 |
|
|
| 1378 |
-- ?o?[?^?C?v????}?X?^ |
|
| 1379 |
--* BackupToTempTable |
|
| 1380 |
drop table if exists costdatatype cascade; |
|
| 1381 |
|
|
| 1382 |
--* RestoreFromTempTable |
|
| 1383 |
create table costdatatype ( |
|
| 1384 |
CostType decimal(1,0) not null comment '?o?[?^?C?v?R?[?h' |
|
| 1385 |
, TargetType decimal(1,0) not null comment '?o?[??R?[?h?^?C?v' |
|
| 1386 |
, CostDataTypeName varchar(60) comment '?o?[?^?C?v????' |
|
| 1387 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 1388 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 1389 |
, constraint costdatatype_PKC primary key (CostType,TargetType) |
|
| 1390 |
) comment '?o?[?^?C?v????}?X?^' ; |
|
| 1391 |
|
|
| 1392 |
create index CostDataType_Index1 |
|
| 1393 |
on costdatatype(CostType); |
|
| 1394 |
|
|
| 1395 |
create index CostDataType_Index2 |
|
| 1396 |
on costdatatype(TargetType); |
|
| 1397 |
|
|
| 1226 | 1398 |
-- ??????o?^?\???f?[?^ |
| 1227 | 1399 |
--* BackupToTempTable |
| 1228 | 1400 |
drop table if exists costomerregist cascade; |
| ... | ... | |
| 1276 | 1448 |
|
| 1277 | 1449 |
--* RestoreFromTempTable |
| 1278 | 1450 |
create table dailydataconstruction ( |
| 1279 |
PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
|
|
| 1451 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1280 | 1452 |
, DailyDataDate date not null comment '???????' |
| 1281 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1453 |
, PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
|
|
| 1282 | 1454 |
, Weather varchar(60) comment '?V?C' |
| 1283 | 1455 |
, EntryDate datetime not null comment '?o?^???t' |
| 1284 | 1456 |
, UpdateDate datetime not null comment '?X?V???t' |
| 1285 |
, constraint dailydataconstruction_PKC primary key (PersonCode,DailyDataDate,ConstructionCode)
|
|
| 1457 |
, constraint dailydataconstruction_PKC primary key (ConstructionCode,DailyDataDate,PersonCode)
|
|
| 1286 | 1458 |
) comment '????f?[?^' ; |
| 1287 | 1459 |
|
| 1288 | 1460 |
create index DailyDataConstruction_Index1 |
| 1289 |
on dailydataconstruction(PersonCode);
|
|
| 1461 |
on dailydataconstruction(ConstructionCode);
|
|
| 1290 | 1462 |
|
| 1291 | 1463 |
create index DailyDataConstruction_Index2 |
| 1292 | 1464 |
on dailydataconstruction(DailyDataDate); |
| 1293 | 1465 |
|
| 1294 |
create index DailyDataConstruction_Index3 |
|
| 1295 |
on dailydataconstruction(ConstructionCode); |
|
| 1296 |
|
|
| 1297 | 1466 |
-- ????f?[?^ (????) |
| 1298 | 1467 |
--* BackupToTempTable |
| 1299 | 1468 |
drop table if exists dailydatadetail cascade; |
| 1300 | 1469 |
|
| 1301 | 1470 |
--* RestoreFromTempTable |
| 1302 | 1471 |
create table dailydatadetail ( |
| 1303 |
PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
|
|
| 1472 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1304 | 1473 |
, DailyDataDate date not null comment '???????' |
| 1305 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1474 |
, PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
|
|
| 1306 | 1475 |
, SeqNo decimal(3,0) unsigned not null comment '????s???' |
| 1307 | 1476 |
, JobCategoryCode decimal(5,0) not null comment '?E??L?[' |
| 1308 | 1477 |
, CompanyCode decimal(8,0) not null comment '??????R?[?h' |
| ... | ... | |
| 1313 | 1482 |
, NextdayHeadCount decimal(4,1) not null comment '?????l????' |
| 1314 | 1483 |
, EntryDate datetime not null comment '?o?^???t' |
| 1315 | 1484 |
, UpdateDate datetime not null comment '?X?V???t' |
| 1316 |
, constraint dailydatadetail_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
|
|
| 1485 |
, constraint dailydatadetail_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
|
|
| 1317 | 1486 |
) comment '????f?[?^ (????)' ; |
| 1318 | 1487 |
|
| 1319 | 1488 |
create index DailyDataDetail_Index |
| 1320 |
on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
|
|
| 1489 |
on dailydatadetail(ConstructionCode,DailyDataDate,PersonCode);
|
|
| 1321 | 1490 |
|
| 1322 | 1491 |
-- ????f?[?^ (??????) |
| 1323 | 1492 |
--* BackupToTempTable |
| ... | ... | |
| 1325 | 1494 |
|
| 1326 | 1495 |
--* RestoreFromTempTable |
| 1327 | 1496 |
create table dailydatafield ( |
| 1328 |
PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1497 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1329 | 1498 |
, DailyDataDate date not null comment '???????' |
| 1330 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1499 |
, PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1331 | 1500 |
, SeqNo decimal(3,0) unsigned not null comment '????s???' |
| 1332 | 1501 |
, PatrolTime datetime not null comment '?????' |
| 1333 | 1502 |
, ContentsText varchar(200) comment '???e' |
| 1334 | 1503 |
, EntryDate datetime not null comment '?o?^???t' |
| 1335 | 1504 |
, UpdateDate datetime not null comment '?X?V???t' |
| 1336 |
, constraint dailydatafield_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
|
|
| 1505 |
, constraint dailydatafield_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
|
|
| 1337 | 1506 |
) comment '????f?[?^ (??????)' ; |
| 1338 | 1507 |
|
| 1339 | 1508 |
create index DailyDataField_Index |
| 1340 |
on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
|
|
| 1509 |
on dailydatafield(ConstructionCode,DailyDataDate);
|
|
| 1341 | 1510 |
|
| 1342 | 1511 |
-- ????f?[?^ (????) |
| 1343 | 1512 |
--* BackupToTempTable |
| ... | ... | |
| 1345 | 1514 |
|
| 1346 | 1515 |
--* RestoreFromTempTable |
| 1347 | 1516 |
create table dailydatamaterials ( |
| 1348 |
PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1517 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1349 | 1518 |
, DailyDataDate date not null comment '???????' |
| 1350 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1519 |
, PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1351 | 1520 |
, SeqNo decimal(3,0) unsigned not null comment '????s???' |
| 1352 | 1521 |
, Materials varchar(100) comment '?????' |
| 1353 | 1522 |
, Quantity varchar(100) comment '????' |
| ... | ... | |
| 1356 | 1525 |
, QualityControl varchar(100) comment '?i?????????' |
| 1357 | 1526 |
, EntryDate datetime not null comment '?o?^???t' |
| 1358 | 1527 |
, UpdateDate datetime not null comment '?X?V???t' |
| 1359 |
, constraint dailydatamaterials_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
|
|
| 1528 |
, constraint dailydatamaterials_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
|
|
| 1360 | 1529 |
) comment '????f?[?^ (????)' ; |
| 1361 | 1530 |
|
| 1362 | 1531 |
create index DailyDataMaterials_Index |
| 1363 |
on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
|
|
| 1532 |
on dailydatamaterials(ConstructionCode,DailyDataDate);
|
|
| 1364 | 1533 |
|
| 1365 | 1534 |
-- ????f?[?^ (??????w??) |
| 1366 | 1535 |
--* BackupToTempTable |
| ... | ... | |
| 1368 | 1537 |
|
| 1369 | 1538 |
--* RestoreFromTempTable |
| 1370 | 1539 |
create table dailydatasubcontractors ( |
| 1371 |
PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1540 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1372 | 1541 |
, DailyDataDate date not null comment '???????' |
| 1373 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1542 |
, PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1374 | 1543 |
, SeqNo decimal(3,0) unsigned not null comment '????s???' |
| 1375 | 1544 |
, Attendee varchar(100) comment '?o???' |
| 1376 | 1545 |
, ContentsText varchar(200) comment '???e' |
| 1377 | 1546 |
, EntryDate datetime not null comment '?o?^???t' |
| 1378 | 1547 |
, UpdateDate datetime not null comment '?X?V???t' |
| 1379 |
, constraint dailydatasubcontractors_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
|
|
| 1548 |
, constraint dailydatasubcontractors_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
|
|
| 1380 | 1549 |
) comment '????f?[?^ (??????w??)' ; |
| 1381 | 1550 |
|
| 1382 | 1551 |
create index DailyDataSubcontractors_Index |
| 1383 |
on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
|
|
| 1552 |
on dailydatasubcontractors(ConstructionCode,DailyDataDate);
|
|
| 1384 | 1553 |
|
| 1385 | 1554 |
-- ????f?[?^ (???) |
| 1386 | 1555 |
--* BackupToTempTable |
| ... | ... | |
| 1388 | 1557 |
|
| 1389 | 1558 |
--* RestoreFromTempTable |
| 1390 | 1559 |
create table dailydatavehicles ( |
| 1391 |
PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1560 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1392 | 1561 |
, DailyDataDate date not null comment '???????' |
| 1393 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
|
|
| 1562 |
, PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
|
|
| 1394 | 1563 |
, SeqNo decimal(3,0) unsigned not null comment '????s???' |
| 1395 | 1564 |
, Model varchar(100) comment '?@??' |
| 1396 | 1565 |
, Performance varchar(100) comment '???\' |
| ... | ... | |
| 1400 | 1569 |
, EndWorkingTime datetime not null comment '??????I??' |
| 1401 | 1570 |
, EntryDate datetime not null comment '?o?^???t' |
| 1402 | 1571 |
, UpdateDate datetime not null comment '?X?V???t' |
| 1403 |
, constraint dailydatavehicles_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
|
|
| 1572 |
, constraint dailydatavehicles_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
|
|
| 1404 | 1573 |
) comment '????f?[?^ (???)' ; |
| 1405 | 1574 |
|
| 1406 | 1575 |
create index DailyDataVehicles_Index |
| 1407 |
on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
|
|
| 1576 |
on dailydatavehicles(ConstructionCode,DailyDataDate);
|
|
| 1408 | 1577 |
|
| 1409 | 1578 |
-- ???}?X?^ |
| 1410 | 1579 |
--* BackupToTempTable |
| ... | ... | |
| 1668 | 1837 |
create table estimatedatadetail ( |
| 1669 | 1838 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
| 1670 | 1839 |
, PageCount decimal(4,0) unsigned not null comment '?y?[?W???' |
| 1671 |
, LineCount decimal(3,0) unsigned not null comment '?s???'
|
|
| 1840 |
, LineCount decimal(4,0) unsigned not null comment '?s???'
|
|
| 1672 | 1841 |
, DataType decimal(1,0) not null comment '?f?[?^???' |
| 1673 | 1842 |
, ComponentCode decimal(5,0) unsigned not null comment '?\???L?[' |
| 1674 | 1843 |
, ItemCode decimal(5,0) unsigned not null comment '?H??L?[' |
| 1675 | 1844 |
, SpecCode decimal(5,0) unsigned not null comment '???L?[' |
| 1676 | 1845 |
, ItemName varchar(120) comment '??????' |
| 1677 | 1846 |
, SpecName varchar(120) comment '???^?i???E?`??E???@' |
| 1678 |
, Unitcount decimal(8,2) not null comment '????'
|
|
| 1847 |
, Unitcount decimal(9,3) not null comment '????'
|
|
| 1679 | 1848 |
, UnitName varchar(30) comment '?P?????' |
| 1680 |
, UnitPrice decimal(9,2) not null comment '?P??'
|
|
| 1849 |
, UnitPrice decimal(11,2) not null comment '?P??'
|
|
| 1681 | 1850 |
, LineTotal decimal(12,0) not null comment '???z' |
| 1682 | 1851 |
, note varchar(60) comment '???l' |
| 1683 | 1852 |
, CompanyCode decimal(8,0) not null comment '??????R?[?h' |
| ... | ... | |
| 1831 | 2000 |
, COMMENT4 varchar(60) not null comment '?R?????g4' |
| 1832 | 2001 |
, COMMENT5 varchar(60) not null comment '?R?????g5' |
| 1833 | 2002 |
, COMPLETEFLG decimal(1,0) default '0' not null comment '?????t???O' |
| 2003 |
, DELETEFLG decimal(1,0) comment '???t???O' |
|
| 1834 | 2004 |
, ENTRYDATE datetime not null comment '?o?^?N????' |
| 1835 | 2005 |
, UPDATEDATE datetime not null comment '?X?V?N????' |
| 1836 | 2006 |
, constraint invoicedata_PKC primary key (INVOICENO) |
| ... | ... | |
| 1838 | 2008 |
|
| 1839 | 2009 |
alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ; |
| 1840 | 2010 |
|
| 2011 |
-- ???O?C?????? |
|
| 2012 |
--* BackupToTempTable |
|
| 2013 |
drop table if exists loginlog cascade; |
|
| 2014 |
|
|
| 2015 |
--* RestoreFromTempTable |
|
| 2016 |
create table loginlog ( |
|
| 2017 |
PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h' |
|
| 2018 |
, TargetMonth decimal(6,0) unsigned not null comment '???N??' |
|
| 2019 |
, LastLogin datetime not null comment '??????I???O?C??????' |
|
| 2020 |
, LastLogout datetime not null comment '??????I???O?A?E?g????' |
|
| 2021 |
, TotalTime decimal(10,0) not null comment '??v???O?C??????' |
|
| 2022 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 2023 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 2024 |
, constraint loginlog_PKC primary key (PersonCode,TargetMonth) |
|
| 2025 |
) comment '???O?C??????' ; |
|
| 2026 |
|
|
| 1841 | 2027 |
-- ???[???R???e???c?}?X?^ |
| 1842 | 2028 |
--* BackupToTempTable |
| 1843 | 2029 |
drop table if exists mailcontentsmaster cascade; |
| ... | ... | |
| 2068 | 2254 |
, Address3 varchar(60) comment '?Z??3' |
| 2069 | 2255 |
, PhoneNumber varchar(13) comment '?d?b???' |
| 2070 | 2256 |
, FaxNumber varchar(13) comment 'FAX???' |
| 2257 |
, JapaneseSyllabary varchar(2) comment '50?????' |
|
| 2071 | 2258 |
, MailAddress varchar(257) comment '???[???A?h???X' |
| 2072 | 2259 |
, Note varchar(300) comment '???l' |
| 2073 | 2260 |
, PersonCode decimal(8,0) not null comment '?o?^?S????R?[?h' |
| ... | ... | |
| 2077 | 2264 |
, constraint orderersmaster_PKC primary key (OrderCotegory,OrderersCode) |
| 2078 | 2265 |
) comment '??????}?X?^' ; |
| 2079 | 2266 |
|
| 2267 |
create index orderersmaster_Index1 |
|
| 2268 |
on orderersmaster(JapaneseSyllabary); |
|
| 2269 |
|
|
| 2080 | 2270 |
-- ????z?f?[?^ |
| 2081 | 2271 |
--* BackupToTempTable |
| 2082 | 2272 |
drop table if exists orderspricedata cascade; |
| ... | ... | |
| 2473 | 2663 |
, constraint processapprovaldetail_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SerialNo) |
| 2474 | 2664 |
) comment '???F????f?[?^' ; |
| 2475 | 2665 |
|
| 2666 |
create index processapprovaldetail_Index1 |
|
| 2667 |
on processapprovaldetail(ConstructionCode,ApprovalCode,LinkCode); |
|
| 2668 |
|
|
| 2476 | 2669 |
-- ?N?????}?X?^ |
| 2477 | 2670 |
--* BackupToTempTable |
| 2478 | 2671 |
drop table if exists processexcutemaster cascade; |
| 2479 | 2672 |
|
| 2480 | 2673 |
--* RestoreFromTempTable |
| 2481 | 2674 |
create table processexcutemaster ( |
| 2482 |
SecCode decimal(2,0) unsigned not null comment '???????'
|
|
| 2675 |
SecCode decimal(4,0) unsigned not null comment '???????'
|
|
| 2483 | 2676 |
, ExecCode decimal(4,0) unsigned not null comment '?N?????????' |
| 2484 | 2677 |
, EditFlg decimal(1,0) not null comment '??W?t???O' |
| 2485 | 2678 |
, EntryDate datetime not null comment '?o?^???t' |
| ... | ... | |
| 2608 | 2801 |
create index QualificationMaster_Index3 |
| 2609 | 2802 |
on qualificationmaster(DisplayOrder); |
| 2610 | 2803 |
|
| 2804 |
-- ?S?????????f?[?^ |
|
| 2805 |
--* BackupToTempTable |
|
| 2806 |
drop table if exists quarterlysales cascade; |
|
| 2807 |
|
|
| 2808 |
--* RestoreFromTempTable |
|
| 2809 |
create table quarterlysales ( |
|
| 2810 |
YearCode decimal(5,0) unsigned not null comment '???N?x' |
|
| 2811 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
| 2812 |
, OrderNo decimal(4,0) unsigned not null comment '?f?[?^??' |
|
| 2813 |
, ConstructionStart date comment '?_??H???J?n??' |
|
| 2814 |
, ConstructionEnd date comment '?_??H??????' |
|
| 2815 |
, OrdersPrice decimal(12,0) not null comment '???????z' |
|
| 2816 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 2817 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 2818 |
, constraint quarterlysales_PKC primary key (YearCode,ConstructionCode,OrderNo) |
|
| 2819 |
) comment '?S?????????f?[?^' ; |
|
| 2820 |
|
|
| 2821 |
create index QuarterlySales_Index1 |
|
| 2822 |
on quarterlysales(YearCode); |
|
| 2823 |
|
|
| 2824 |
create index QuarterlySales_Index2 |
|
| 2825 |
on quarterlysales(ConstructionCode); |
|
| 2826 |
|
|
| 2827 |
create index QuarterlySales_Index3 |
|
| 2828 |
on quarterlysales(OrderNo); |
|
| 2829 |
|
|
| 2830 |
-- ?S???????????f?[?^ |
|
| 2831 |
--* BackupToTempTable |
|
| 2832 |
drop table if exists quarterlysalesdetail cascade; |
|
| 2833 |
|
|
| 2834 |
--* RestoreFromTempTable |
|
| 2835 |
create table quarterlysalesdetail ( |
|
| 2836 |
YearCode decimal(5,0) unsigned not null comment '???N?x' |
|
| 2837 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
| 2838 |
, OrderNo decimal(4,0) unsigned not null comment '?f?[?^??' |
|
| 2839 |
, SeqNo decimal(2,0) not null comment '?f?[?^???' |
|
| 2840 |
, DataType decimal(1,0) unsigned not null comment '?f?[?^?^?C?v' |
|
| 2841 |
, DataYM decimal(6,0) unsigned not null comment '???N??' |
|
| 2842 |
, PriceValue decimal(12,0) not null comment '?????z' |
|
| 2843 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 2844 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 2845 |
, constraint quarterlysalesdetail_PKC primary key (YearCode,ConstructionCode,OrderNo,SeqNo,DataType) |
|
| 2846 |
) comment '?S???????????f?[?^' ; |
|
| 2847 |
|
|
| 2848 |
create index QuarterlySalesDetail_Index1 |
|
| 2849 |
on quarterlysalesdetail(YearCode); |
|
| 2850 |
|
|
| 2851 |
create index QuarterlySalesDetail_Index2 |
|
| 2852 |
on quarterlysalesdetail(ConstructionCode); |
|
| 2853 |
|
|
| 2854 |
create index QuarterlySalesDetail_Index3 |
|
| 2855 |
on quarterlysalesdetail(OrderNo); |
|
| 2856 |
|
|
| 2857 |
create index QuarterlySalesDetail_Index4 |
|
| 2858 |
on quarterlysalesdetail(SeqNo); |
|
| 2859 |
|
|
| 2860 |
create index QuarterlySalesDetail_Index5 |
|
| 2861 |
on quarterlysalesdetail(DataType); |
|
| 2862 |
|
|
| 2863 |
create index QuarterlySalesDetail_Index6 |
|
| 2864 |
on quarterlysalesdetail(DataYM); |
|
| 2865 |
|
|
| 2611 | 2866 |
-- ???R?[?h?????? |
| 2612 | 2867 |
--* BackupToTempTable |
| 2613 | 2868 |
drop table if exists recordkey cascade; |
| ... | ... | |
| 2775 | 3030 |
, INVOICENO decimal(9,0) not null comment '??????No' |
| 2776 | 3031 |
, BILLINGDATE datetime not null comment '??????' |
| 2777 | 3032 |
, BILLCONFIRMDATE datetime not null comment '?????m?F??' |
| 3033 |
, DELETEFLG decimal(1,0) comment '???t???O' |
|
| 2778 | 3034 |
, ENTRYDATE datetime not null comment '?o?^?N????' |
| 2779 | 3035 |
, UPDATEDATE datetime not null comment '?X?V?N????' |
| 2780 | 3036 |
, constraint requesthead_PKC primary key (REQUESTNO) |
| ... | ... | |
| 2828 | 3084 |
|
| 2829 | 3085 |
--* RestoreFromTempTable |
| 2830 | 3086 |
create table securitymaster ( |
| 2831 |
SecCode decimal(2,0) unsigned not null comment '???????'
|
|
| 2832 |
, DisplayOrder decimal(2,0) not null comment '?\????'
|
|
| 3087 |
SecCode decimal(4,0) unsigned not null comment '???????'
|
|
| 3088 |
, DisplayOrder decimal(4,0) not null comment '?\????'
|
|
| 2833 | 3089 |
, SecName varchar(60) not null comment '????????' |
| 2834 | 3090 |
, SecRank decimal(1,0) not null comment '?????????N' |
| 2835 | 3091 |
, SecRange decimal(1,0) not null comment '???????' |
| 2836 | 3092 |
, GeneralAffairs decimal(1,0) not null comment '????????t???O' |
| 2837 | 3093 |
, SelectBackColor varchar(8) not null comment '?I??w?i?F' |
| 3094 |
, DeleteFlg decimal(1,0) not null comment '???t???O' |
|
| 2838 | 3095 |
, EntryDate datetime not null comment '?o?^???t' |
| 2839 | 3096 |
, UpdateDate datetime not null comment '?X?V???t' |
| 2840 | 3097 |
, constraint securitymaster_PKC primary key (SecCode) |
| ... | ... | |
| 3201 | 3458 |
, SloganString2 varchar(100) comment '?W??2' |
| 3202 | 3459 |
, SloganString3 varchar(100) comment '?W??3' |
| 3203 | 3460 |
, OperationFlg decimal(2,0) unsigned not null comment '???F?^?p?t???O' |
| 3461 |
, SystemOpenTime datetime not null comment '?^?p?J?n????' |
|
| 3462 |
, SystemCloseTime datetime not null comment '?^?p?I??????' |
|
| 3463 |
, PesrsonCost1 decimal(7,0) unsigned not null comment '???l????P?i?w?????R?X?g?j' |
|
| 3464 |
, PesrsonCost2 decimal(7,0) unsigned not null comment '???l????Q?i???S????R?X?g?j' |
|
| 3204 | 3465 |
, EntryDate datetime not null comment '?o?^???t' |
| 3205 | 3466 |
, UpdateDate datetime not null comment '?X?V???t' |
| 3206 | 3467 |
, constraint systemmaster_PKC primary key (SystemCode) |
他の形式にエクスポート: Unified diff