リビジョン 277
IOクラスコメント行修正（Oracle->MySQL)
工事資材テーブル変更
資材管理修正
| ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2017/09/27 8:32:51
|
|
| 2 |
-- Date/Time : 2017/10/05 15:29:38
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 62 | 62 |
, constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo) |
| 63 | 63 |
) comment '?o?????f?[?^' ; |
| 64 | 64 |
|
| 65 |
create index AttendDaily_Index1 |
|
| 66 |
on attendancedailydata(ConstructionCode); |
|
| 67 |
|
|
| 68 |
create index AttendDaily_Index2 |
|
| 69 |
on attendancedailydata(AttendanceDate); |
|
| 70 |
|
|
| 65 | 71 |
-- ?o?????f?[?^ |
| 66 | 72 |
drop table if exists attendancedata cascade; |
| 67 | 73 |
|
| ... | ... | |
| 690 | 696 |
create table constructionmaterialinfo ( |
| 691 | 697 |
CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????' |
| 692 | 698 |
, MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h' |
| 699 |
, PROCESSDATE datetime default '0000-00-00 00:00:00' not null comment '?????N????' |
|
| 693 | 700 |
, RENTCOUNT smallint(5) unsigned comment '??o??' |
| 694 | 701 |
, REPAYCOUNT smallint(5) unsigned comment '??p??' |
| 702 |
, JUNKCOUNT smallint(5) unsigned comment '?j????' |
|
| 695 | 703 |
, COMPLETEFLG tinyint(3) unsigned comment '?????t???O' |
| 696 | 704 |
, ENTRYDATE datetime comment '?o?^???t' |
| 697 | 705 |
, UPDATEDATE datetime comment '?X?V???t' |
| 698 |
, constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE) |
|
| 706 |
, constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE,PROCESSDATE)
|
|
| 699 | 707 |
) comment '?H????????' ; |
| 700 | 708 |
|
| 701 | 709 |
-- ????i?????t?f?[?^ |
| ... | ... | |
| 1654 | 1662 |
, constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo) |
| 1655 | 1663 |
) comment '?????????????c???^?f?[?^?i?o???j' ; |
| 1656 | 1664 |
|
| 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 |
|
|
| 1657 | 1680 |
-- ?????????????c???^?f?[?^?i????j |
| 1658 | 1681 |
drop table if exists proceedingsdatadetail cascade; |
| 1659 | 1682 |
|
| ... | ... | |
| 1761 | 1784 |
, CompletionPaymentDays decimal(3,0) unsigned not null comment '???n??????x??????' |
| 1762 | 1785 |
, CompletionPaymentPrice decimal(12,0) not null comment '???n??????x?????z' |
| 1763 | 1786 |
, LeadEngineerCode decimal(8,0) comment '??C?Z?p??R?[?h' |
| 1764 |
, LeadEngineerName varchar(60) comment 'LeadEngineerName'
|
|
| 1787 |
, LeadEngineerName varchar(60) comment '??C?Z?p???'
|
|
| 1765 | 1788 |
, SafetyOfficerCode decimal(8,0) comment '???S?????R?[?h' |
| 1766 | 1789 |
, SafetyOfficerName varchar(60) comment '???S??????' |
| 1767 | 1790 |
, WorkersCount decimal(3,0) unsigned comment '??????' |
他の形式にエクスポート: Unified diff