リビジョン 302
工事台帳明細データ明細番号追加
IOクラスInsert：StringBuilder化時のバグ修正
注文書作成処理不具合修正
サブフォーム表示時の本体での位置修正を削除
銀行営業日マスタ追加
| ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2017/10/05 15:29:38
|
|
| 2 |
-- Date/Time : 2017/12/12 10:48:17
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 615 | 615 |
create table constructionledgerdetail ( |
| 616 | 616 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
| 617 | 617 |
, GroupCount decimal(2,0) unsigned not null comment '?O???[?v???' |
| 618 |
, LineCount decimal(3,0) unsigned not null comment '?s???'
|
|
| 618 |
, LineCount decimal(4,0) unsigned not null comment '?s???'
|
|
| 619 | 619 |
, ComponentCode decimal(5,0) unsigned not null comment '?\???L?[' |
| 620 | 620 |
, ItemCode decimal(5,0) unsigned not null comment '?H??L?[' |
| 621 | 621 |
, FirstString varchar(120) comment '???????' |
| ... | ... | |
| 637 | 637 |
, JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??' |
| 638 | 638 |
, SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^' |
| 639 | 639 |
, PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O' |
| 640 |
, DetailCount decimal(4,0) unsigned not null comment '??????' |
|
| 640 | 641 |
, EntryDate datetime not null comment '?o?^???t' |
| 641 | 642 |
, UpdateDate datetime not null comment '?X?V???t' |
| 642 | 643 |
, constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount) |
| ... | ... | |
| 649 | 650 |
on constructionledgerdetail(GroupCount); |
| 650 | 651 |
|
| 651 | 652 |
create index LedgerDetail_Index03 |
| 653 |
on constructionledgerdetail(LineCount); |
|
| 654 |
|
|
| 655 |
create index LedgerDetail_Index04 |
|
| 652 | 656 |
on constructionledgerdetail(SourceCode); |
| 653 | 657 |
|
| 658 |
create index LedgerDetail_Index05 |
|
| 659 |
on constructionledgerdetail(DetailCount); |
|
| 660 |
|
|
| 654 | 661 |
-- ?H?????????s?f?[?^ |
| 655 | 662 |
drop table if exists constructionledgerexcute cascade; |
| 656 | 663 |
|
| 657 | 664 |
create table constructionledgerexcute ( |
| 658 | 665 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
| 659 | 666 |
, GroupCount decimal(2,0) unsigned not null comment '?O???[?v???' |
| 660 |
, LineCount decimal(3,0) unsigned not null comment '?s???'
|
|
| 667 |
, LineCount decimal(4,0) unsigned not null comment '?s???'
|
|
| 661 | 668 |
, ColumnCount decimal(3,0) not null comment '????' |
| 662 | 669 |
, PaymentAmount decimal(12,0) not null comment '?x?????z' |
| 663 | 670 |
, TargetMonth date not null comment '???N??' |
| ... | ... | |
| 1502 | 1509 |
, constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT) |
| 1503 | 1510 |
) comment '?x??????f?[?^' ; |
| 1504 | 1511 |
|
| 1512 |
-- ?H??????????f?[?^ |
|
| 1513 |
drop table if exists periodavoidance cascade; |
|
| 1514 |
|
|
| 1515 |
create table periodavoidance ( |
|
| 1516 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
| 1517 |
, ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O' |
|
| 1518 |
, FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???' |
|
| 1519 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 1520 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 1521 |
, constraint periodavoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo) |
|
| 1522 |
) comment '?H??????????f?[?^' ; |
|
| 1523 |
|
|
| 1524 |
create index PeriodAvoidance_Index1 |
|
| 1525 |
on periodavoidance(ConstructionCode); |
|
| 1526 |
|
|
| 1527 |
create index PeriodAvoidance_Index2 |
|
| 1528 |
on periodavoidance(ConstructionStatusFlg); |
|
| 1529 |
|
|
| 1530 |
create index PeriodAvoidance_Index3 |
|
| 1531 |
on periodavoidance(FieldNo); |
|
| 1532 |
|
|
| 1505 | 1533 |
-- ?S??????F?f?[?^ |
| 1506 | 1534 |
drop table if exists personapproval cascade; |
| 1507 | 1535 |
|
| ... | ... | |
| 1662 | 1690 |
, constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo) |
| 1663 | 1691 |
) comment '?????????????c???^?f?[?^?i?o???j' ; |
| 1664 | 1692 |
|
| 1665 |
-- ?????????????c???^?f?[?^?i?o???j |
|
| 1666 |
drop table if exists proceedingsdataattendee cascade; |
|
| 1667 |
|
|
| 1668 |
create table proceedingsdataattendee ( |
|
| 1669 |
PersonCode decimal(8,0) not null comment '????R?[?h' |
|
| 1670 |
, ProceedingsDataDate date not null comment '?c???^????' |
|
| 1671 |
, ConstructionCode int(11) not null comment '?H?????' |
|
| 1672 |
, SeqNo smallint(6) not null comment '?f?[?^?s???' |
|
| 1673 |
, Department varchar(100) comment '?o??????' |
|
| 1674 |
, AttendeeName varchar(100) comment '?o??????' |
|
| 1675 |
, EntryDate datetime not null comment '?o?^?N????' |
|
| 1676 |
, UpdateDate datetime not null comment '?X?V?N????' |
|
| 1677 |
, constraint proceedingsdataattendee_PKC primary key (PersonCode,ProceedingsDataDate,ConstructionCode,SeqNo) |
|
| 1678 |
) comment '?????????????c???^?f?[?^?i?o???j' ; |
|
| 1679 |
|
|
| 1680 | 1693 |
-- ?????????????c???^?f?[?^?i????j |
| 1681 | 1694 |
drop table if exists proceedingsdatadetail cascade; |
| 1682 | 1695 |
|
| ... | ... | |
| 1825 | 1838 |
, UnitName varchar(30) comment '?P??' |
| 1826 | 1839 |
, UnitPrice decimal(10,0) not null comment '?P??' |
| 1827 | 1840 |
, OrdersLinePrice decimal(12,0) comment '???z' |
| 1828 |
, SourceCode decimal(10,0) unsigned not null comment '?\?Z?????H?????' |
|
| 1829 |
, SourceLineCnt decimal(3,0) unsigned not null comment '?????????????s???' |
|
| 1841 |
, SourceCode decimal(10,0) unsigned not null comment '???H?????' |
|
| 1842 |
, SourceDetailCnt decimal(4,0) unsigned not null comment '????????' |
|
| 1843 |
, DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O' |
|
| 1830 | 1844 |
, EntryDate datetime not null comment '?o?^???t' |
| 1831 | 1845 |
, UpdateDate datetime not null comment '?X?V???t' |
| 1832 | 1846 |
, constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount) |
他の形式にエクスポート: Unified diff