リビジョン 276
出勤日報データ項目追加
| branches/ddl/20170926_SQL.txt | ||
|---|---|---|
| 1 |
-- ?o?????f?[?^ |
|
| 2 |
drop table if exists attendancedailydata cascade; |
|
| 3 |
|
|
| 4 |
create table attendancedailydata ( |
|
| 5 |
PersonCode decimal(8,0) unsigned not null comment '????R?[?h' |
|
| 6 |
, AttendanceDate date not null comment '???????' |
|
| 7 |
, SeqNo decimal(3,0) unsigned not null comment '????s???' |
|
| 8 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
| 9 |
, ActionResult varchar(30) not null comment '?s??????' |
|
| 10 |
, StartTime datetime comment '?J?n????' |
|
| 11 |
, CompTime datetime comment '?I??????' |
|
| 12 |
, DayTimes decimal(4,1) not null comment '????????v????' |
|
| 13 |
, WorkingComment varchar(120) comment '?R?????g' |
|
| 14 |
, NightFlg decimal(1,0) not null comment '?????t???O' |
|
| 15 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 16 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 17 |
, constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo) |
|
| 18 |
) comment '?o?????f?[?^' ; |
|
| 19 |
|
|
| 20 |
create index AttendDaily_Index1 |
|
| 21 |
on attendancedailydata(ConstructionCode); |
|
| 22 |
|
|
| 23 |
create index AttendDaily_Index2 |
|
| 24 |
on attendancedailydata(AttendanceDate); |
|
| branches/ddl/ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2017/09/16 11:05:22
|
|
| 2 |
-- Date/Time : 2017/09/27 8:32:51
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 50 | 50 |
PersonCode decimal(8,0) unsigned not null comment '????R?[?h' |
| 51 | 51 |
, AttendanceDate date not null comment '???????' |
| 52 | 52 |
, SeqNo decimal(3,0) unsigned not null comment '????s???' |
| 53 |
, ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
| 53 | 54 |
, ActionResult varchar(30) not null comment '?s??????' |
| 54 | 55 |
, StartTime datetime comment '?J?n????' |
| 55 | 56 |
, CompTime datetime comment '?I??????' |
| ... | ... | |
| 61 | 62 |
, constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo) |
| 62 | 63 |
) comment '?o?????f?[?^' ; |
| 63 | 64 |
|
| 64 |
create index AttendDaily_Index1 |
|
| 65 |
on attendancedailydata(ActionResult); |
|
| 66 |
|
|
| 67 |
create index AttendDaily_Index2 |
|
| 68 |
on attendancedailydata(AttendanceDate); |
|
| 69 |
|
|
| 70 | 65 |
-- ?o?????f?[?^ |
| 71 | 66 |
drop table if exists attendancedata cascade; |
| 72 | 67 |
|
| ... | ... | |
| 1659 | 1654 |
, constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo) |
| 1660 | 1655 |
) comment '?????????????c???^?f?[?^?i?o???j' ; |
| 1661 | 1656 |
|
| 1662 |
-- ?????????????c???^?f?[?^?i?o???j |
|
| 1663 |
drop table if exists proceedingsdataattendee cascade; |
|
| 1664 |
|
|
| 1665 |
create table proceedingsdataattendee ( |
|
| 1666 |
PersonCode decimal(8,0) not null comment '????R?[?h' |
|
| 1667 |
, ProceedingsDataDate date not null comment '?c???^????' |
|
| 1668 |
, ConstructionCode int(11) not null comment '?H?????' |
|
| 1669 |
, SeqNo smallint(6) not null comment '?f?[?^?s???' |
|
| 1670 |
, Department varchar(100) comment '?o??????' |
|
| 1671 |
, AttendeeName varchar(100) comment '?o??????' |
|
| 1672 |
, EntryDate datetime not null comment '?o?^?N????' |
|
| 1673 |
, UpdateDate datetime not null comment '?X?V?N????' |
|
| 1674 |
, constraint proceedingsdataattendee_PKC primary key (PersonCode,ProceedingsDataDate,ConstructionCode,SeqNo) |
|
| 1675 |
) comment '?????????????c???^?f?[?^?i?o???j' ; |
|
| 1676 |
|
|
| 1677 | 1657 |
-- ?????????????c???^?f?[?^?i????j |
| 1678 | 1658 |
drop table if exists proceedingsdatadetail cascade; |
| 1679 | 1659 |
|
| ... | ... | |
| 2372 | 2352 |
|
| 2373 | 2353 |
create index year_Index1 |
| 2374 | 2354 |
on yearmaster(years); |
| 2375 |
|
|
他の形式にエクスポート: Unified diff