h-you / branches / ddl / ProcessManagement.sql @ 147
履歴 | 表示 | アノテート | ダウンロード (117 KB)
| 1 | 84 | h-you | SET SESSION FOREIGN_KEY_CHECKS=0; |
|---|---|---|---|
| 2 | |||
| 3 | /* Drop Indexes */
|
||
| 4 | |||
| 5 | DROP INDEX ActionScheduleData_Index1 ON ActionScheduleData; |
||
| 6 | DROP INDEX ActionScheduleData_Index2 ON ActionScheduleData; |
||
| 7 | DROP INDEX ActionScheduleData_Index3 ON ActionScheduleData; |
||
| 8 | DROP INDEX AttendDaily_Index1 ON AttendanceDailyData; |
||
| 9 | DROP INDEX AttendDaily_Index2 ON AttendanceDailyData; |
||
| 10 | DROP INDEX BusinessTypeMaster_Index1 ON BusinessTypeMaster; |
||
| 11 | DROP INDEX ComponentLinkMaster_Index1 ON ComponentLinkMaster; |
||
| 12 | DROP INDEX ComponentLinkMaster_Index2 ON ComponentLinkMaster; |
||
| 13 | DROP INDEX ComponentMaster_Index1 ON ComponentMaster; |
||
| 14 | DROP INDEX ComponentToTypeMaster_Index1 ON ComponentToTypeMaster; |
||
| 15 | DROP INDEX ComponentToTypeMaster_Index2 ON ComponentToTypeMaster; |
||
| 16 | DROP INDEX BaseInfo_Index1 ON ConstructionBaseInfo; |
||
| 17 | DROP INDEX BaseInfo_Index2 ON ConstructionBaseInfo; |
||
| 18 | DROP INDEX BaseInfo_Index3 ON ConstructionBaseInfo; |
||
| 19 | DROP INDEX BaseInfo_Index4 ON ConstructionBaseInfo; |
||
| 20 | DROP INDEX BaseInfo_Index5 ON ConstructionBaseInfo; |
||
| 21 | DROP INDEX BaseInfoDetail_Idx1 ON ConstructionBaseInfoDetail; |
||
| 22 | DROP INDEX BaseInfoDetail_Idx2 ON ConstructionBaseInfoDetail; |
||
| 23 | DROP INDEX LedgerDetail_Index01 ON ConstructionLedgerDetail; |
||
| 24 | DROP INDEX LedgerDetail_Index02 ON ConstructionLedgerDetail; |
||
| 25 | DROP INDEX LedgerDetail_Index03 ON ConstructionLedgerDetail; |
||
| 26 | DROP INDEX LedgerExcute_Index1 ON ConstructionLedgerExcute; |
||
| 27 | DROP INDEX ConstructionLink_Index1 ON ConstructionLink; |
||
| 28 | DROP INDEX ConstructionLink_Index2 ON ConstructionLink; |
||
| 29 | DROP INDEX ConstructionLink_Index3 ON ConstructionLink; |
||
| 30 | DROP INDEX ConstructionSpecMaster_Index1 ON ConstructionSpecMaster; |
||
| 31 | DROP INDEX CostDataOfPerson_Index1 ON CostDataOfPerson; |
||
| 32 | DROP INDEX CostDataOfPerson_Index2 ON CostDataOfPerson; |
||
| 33 | DROP INDEX CostomerRegist_Index1 ON CostomerRegist; |
||
| 34 | DROP INDEX DailyDataConstruction_Index1 ON DailyDataConstruction; |
||
| 35 | DROP INDEX DailyDataConstruction_Index2 ON DailyDataConstruction; |
||
| 36 | DROP INDEX DailyDataConstruction_Index3 ON DailyDataConstruction; |
||
| 37 | DROP INDEX DailyDataDetail_Index ON DailyDataDetail; |
||
| 38 | DROP INDEX DailyDataField_Index ON DailyDataField; |
||
| 39 | DROP INDEX DailyDataMaterials_Index ON DailyDataMaterials; |
||
| 40 | DROP INDEX DailyDataSubcontractors_Index ON DailyDataSubcontractors; |
||
| 41 | DROP INDEX DailyDataVehicles_Index ON DailyDataVehicles; |
||
| 42 | DROP INDEX DepartmentMaster_index1 ON DepartmentMaster; |
||
| 43 | DROP INDEX EstimateData_Index1 ON EstimateData; |
||
| 44 | DROP INDEX EstimateDataBody_Index1 ON EstimateDataBody; |
||
| 45 | DROP INDEX EstimateDataDetail_Index1 ON EstimateDataDetail; |
||
| 46 | DROP INDEX HolidayCalender_Index1 ON HolidayCalenderMaster; |
||
| 47 | DROP INDEX HolidayCalenderMaster_Index2 ON HolidayCalenderMaster; |
||
| 48 | DROP INDEX HolidayCalenderMaster_Index3 ON HolidayCalenderMaster; |
||
| 49 | DROP INDEX InputSearchLogData_Index1 ON InputSearchLogData; |
||
| 50 | DROP INDEX MessageBoardData_Index1 ON MessageBoardData; |
||
| 51 | DROP INDEX MessageBoardData_Index2 ON MessageBoardData; |
||
| 52 | DROP INDEX MessageBoardTerget_Index1 ON MessageBoardTerget; |
||
| 53 | DROP INDEX PersonDepartmentMaster_Index1 ON PersonDepartmentMaster; |
||
| 54 | DROP INDEX PersonDepartmentMaster_Index2 ON PersonDepartmentMaster; |
||
| 55 | DROP INDEX PersonInChargeMaster_Index1 ON PersonInChargeMaster; |
||
| 56 | DROP INDEX PersonInChargeMaster_Index2 ON PersonInChargeMaster; |
||
| 57 | DROP INDEX PersonSalaryMaster_Index1 ON PersonSalaryMaster; |
||
| 58 | DROP INDEX PersonSalaryMaster_Index2 ON PersonSalaryMaster; |
||
| 59 | DROP INDEX ProcessExcuteMaster_Index1 ON ProcessExcuteMaster; |
||
| 60 | DROP INDEX ProcessExcuteMaster_Index2 ON ProcessExcuteMaster; |
||
| 61 | DROP INDEX POrderDetail_Index1 ON PurchaseOrderDetail; |
||
| 62 | DROP INDEX SalesGraphData_Idx1 ON SalesGraphData; |
||
| 63 | DROP INDEX SalesGraphData_idx2 ON SalesGraphData; |
||
| 64 | DROP INDEX SecurityMaster_Index1 ON SecurityMaster; |
||
| 65 | DROP INDEX SecurityMaster_Index2 ON SecurityMaster; |
||
| 66 | DROP INDEX SecurityMaster_Index3 ON SecurityMaster; |
||
| 67 | DROP INDEX SubContractorJobItem_Index1 ON SubContractorJobItem; |
||
| 68 | DROP INDEX SubContractorJobItem_Index2 ON SubContractorJobItem; |
||
| 69 | DROP INDEX SubContractorJobLink_Index1 ON SubContractorJobLink; |
||
| 70 | DROP INDEX SubContractorJobLink_Index2 ON SubContractorJobLink; |
||
| 71 | DROP INDEX SubContractorMaster_Index1 ON SubContractorMaster; |
||
| 72 | DROP INDEX TermMaster_Index1 ON TermMaster; |
||
| 73 | DROP INDEX TranceportDailyData_Index1 ON TranceportDailyData; |
||
| 74 | DROP INDEX UnitMaster_Index1 ON UnitMaster; |
||
| 75 | DROP INDEX VehicleScheduleData_Index1 ON VehicleScheduleData; |
||
| 76 | DROP INDEX VehicleScheduleData_Index2 ON VehicleScheduleData; |
||
| 77 | DROP INDEX VehicleScheduleData_Index3 ON VehicleScheduleData; |
||
| 78 | |||
| 79 | |||
| 80 | |||
| 81 | /* Drop Tables */
|
||
| 82 | |||
| 83 | DROP TABLE IF EXISTS ActionScheduleData; |
||
| 84 | DROP TABLE IF EXISTS ApprovalMaster; |
||
| 85 | DROP TABLE IF EXISTS AttendanceDailyData; |
||
| 86 | DROP TABLE IF EXISTS AttendanceData; |
||
| 87 | DROP TABLE IF EXISTS BK_ConstructionLedger; |
||
| 88 | DROP TABLE IF EXISTS BK_ConstructionLedgerDetail; |
||
| 89 | DROP TABLE IF EXISTS BK_ConstructionLedgerExcute; |
||
| 90 | DROP TABLE IF EXISTS BK_EstimateData; |
||
| 91 | DROP TABLE IF EXISTS BK_EstimateDataBody; |
||
| 92 | DROP TABLE IF EXISTS BK_EstimateDataDetail; |
||
| 93 | DROP TABLE IF EXISTS BusinessTypeMaster; |
||
| 94 | DROP TABLE IF EXISTS CommonCostLarge; |
||
| 95 | DROP TABLE IF EXISTS CommonCostLinkMS; |
||
| 96 | DROP TABLE IF EXISTS CommonCostMiddle; |
||
| 97 | DROP TABLE IF EXISTS CommonCostMiddleSearchWord; |
||
| 98 | DROP TABLE IF EXISTS ComponentLinkMaster; |
||
| 99 | DROP TABLE IF EXISTS ComponentMaster; |
||
| 100 | DROP TABLE IF EXISTS ComponentToTypeMaster; |
||
| 101 | DROP TABLE IF EXISTS ConstructionBaseInfo; |
||
| 102 | DROP TABLE IF EXISTS ConstructionBaseInfoDetail; |
||
| 103 | DROP TABLE IF EXISTS ConstructionBudget; |
||
| 104 | DROP TABLE IF EXISTS ConstructionBudgetDetail; |
||
| 105 | DROP TABLE IF EXISTS ConstructionItemMaster; |
||
| 106 | DROP TABLE IF EXISTS ConstructionLedger; |
||
| 107 | DROP TABLE IF EXISTS ConstructionLedgerDetail; |
||
| 108 | DROP TABLE IF EXISTS ConstructionLedgerExcute; |
||
| 109 | DROP TABLE IF EXISTS ConstructionLink; |
||
| 110 | DROP TABLE IF EXISTS ConstructionProgressDate; |
||
| 111 | DROP TABLE IF EXISTS ConstructionSpecMaster; |
||
| 112 | DROP TABLE IF EXISTS ConstructionSpecUnitPrice; |
||
| 113 | DROP TABLE IF EXISTS ConstructionTypeMaster; |
||
| 114 | DROP TABLE IF EXISTS CostDataOfPerson; |
||
| 115 | DROP TABLE IF EXISTS CostomerRegist; |
||
| 116 | DROP TABLE IF EXISTS DailyDataConstruction; |
||
| 117 | DROP TABLE IF EXISTS DailyDataDetail; |
||
| 118 | DROP TABLE IF EXISTS DailyDataField; |
||
| 119 | DROP TABLE IF EXISTS DailyDataMaterials; |
||
| 120 | DROP TABLE IF EXISTS DailyDataSubcontractors; |
||
| 121 | DROP TABLE IF EXISTS DailyDataVehicles; |
||
| 122 | 101 | h-you | DROP TABLE IF EXISTS DayMaster; |
| 123 | 84 | h-you | DROP TABLE IF EXISTS DepartmentExpensesMaster; |
| 124 | DROP TABLE IF EXISTS DepartmentMaster; |
||
| 125 | DROP TABLE IF EXISTS DivisionMaster; |
||
| 126 | DROP TABLE IF EXISTS EstimateBudget; |
||
| 127 | DROP TABLE IF EXISTS EstimateBudgetDetail; |
||
| 128 | DROP TABLE IF EXISTS EstimateData; |
||
| 129 | DROP TABLE IF EXISTS EstimateDataBody; |
||
| 130 | DROP TABLE IF EXISTS EstimateDataDetail; |
||
| 131 | DROP TABLE IF EXISTS HolidayCalenderMaster; |
||
| 132 | DROP TABLE IF EXISTS InputSearchLogData; |
||
| 133 | DROP TABLE IF EXISTS MessageBoardData; |
||
| 134 | DROP TABLE IF EXISTS MessageBoardTerget; |
||
| 135 | DROP TABLE IF EXISTS MessageBrowsingHistory; |
||
| 136 | 101 | h-you | DROP TABLE IF EXISTS MonthMaster; |
| 137 | 84 | h-you | DROP TABLE IF EXISTS OrderersMaster; |
| 138 | DROP TABLE IF EXISTS OrdersPriceData; |
||
| 139 | DROP TABLE IF EXISTS PersonApproval; |
||
| 140 | DROP TABLE IF EXISTS PersonApprovalComment; |
||
| 141 | DROP TABLE IF EXISTS PersonDepartmentMaster; |
||
| 142 | DROP TABLE IF EXISTS PersonInChargeMaster; |
||
| 143 | DROP TABLE IF EXISTS PersonSalaryMaster; |
||
| 144 | DROP TABLE IF EXISTS ProceedingsData; |
||
| 145 | DROP TABLE IF EXISTS ProceedingsDataAttend; |
||
| 146 | DROP TABLE IF EXISTS ProceedingsDataDetail; |
||
| 147 | DROP TABLE IF EXISTS ProcessApproval; |
||
| 148 | DROP TABLE IF EXISTS ProcessApprovalComment; |
||
| 149 | DROP TABLE IF EXISTS ProcessApprovalDetail; |
||
| 150 | DROP TABLE IF EXISTS ProcessExcuteMaster; |
||
| 151 | DROP TABLE IF EXISTS PurchaseOrder; |
||
| 152 | DROP TABLE IF EXISTS PurchaseOrderDetail; |
||
| 153 | DROP TABLE IF EXISTS SalesGraphData; |
||
| 154 | DROP TABLE IF EXISTS SecurityMaster; |
||
| 155 | DROP TABLE IF EXISTS SubConstrJobItemRegist; |
||
| 156 | DROP TABLE IF EXISTS SubConstrJobLinkRegist; |
||
| 157 | DROP TABLE IF EXISTS SubConstrRegist; |
||
| 158 | DROP TABLE IF EXISTS SubContractorItemMaster; |
||
| 159 | DROP TABLE IF EXISTS SubContractorJobCategory; |
||
| 160 | DROP TABLE IF EXISTS SubContractorJobItem; |
||
| 161 | DROP TABLE IF EXISTS SubContractorJobLink; |
||
| 162 | DROP TABLE IF EXISTS SubContractorMaster; |
||
| 163 | DROP TABLE IF EXISTS SuppliersMaster; |
||
| 164 | DROP TABLE IF EXISTS SystemExecute; |
||
| 165 | DROP TABLE IF EXISTS SystemMaster; |
||
| 166 | DROP TABLE IF EXISTS TermMaster; |
||
| 167 | DROP TABLE IF EXISTS TranceportDailyData; |
||
| 168 | DROP TABLE IF EXISTS TypeExpensesMaster; |
||
| 169 | DROP TABLE IF EXISTS UnitMaster; |
||
| 170 | DROP TABLE IF EXISTS VehicleMaster; |
||
| 171 | DROP TABLE IF EXISTS VehicleRecordData; |
||
| 172 | DROP TABLE IF EXISTS VehicleScheduleData; |
||
| 173 | 101 | h-you | DROP TABLE IF EXISTS YearMaster; |
| 174 | 84 | h-you | |
| 175 | |||
| 176 | |||
| 177 | |||
| 178 | /* Create Tables */
|
||
| 179 | |||
| 180 | -- 担当者行動予定データ
|
||
| 181 | CREATE TABLE ActionScheduleData |
||
| 182 | ( |
||
| 183 | TargetDate date NOT NULL COMMENT '対象日', |
||
| 184 | PersonCode decimal(8,0) NOT NULL COMMENT '担当者コード', |
||
| 185 | ActionSchedule varchar(30) COMMENT '行動予定', |
||
| 186 | TargetYear year(4) NOT NULL COMMENT '該当年', |
||
| 187 | TargetMonth year(2) NOT NULL COMMENT '該当月', |
||
| 188 | TargetDay year(2) NOT NULL COMMENT '該当日', |
||
| 189 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 190 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 191 | PRIMARY KEY (TargetDate, PersonCode) |
||
| 192 | ) COMMENT = '担当者行動予定データ'; |
||
| 193 | |||
| 194 | |||
| 195 | -- 承認経路マスタ
|
||
| 196 | CREATE TABLE ApprovalMaster |
||
| 197 | ( |
||
| 198 | ApprovalCode decimal(3,0) unsigned NOT NULL COMMENT '承認機能番号', |
||
| 199 | DepartmentCode decimal(5,0) unsigned NOT NULL COMMENT '部署コード', |
||
| 200 | SeqNo decimal(2) NOT NULL COMMENT '枝番', |
||
| 201 | DisplayOrder decimal(2) NOT NULL COMMENT '表示順', |
||
| 202 | ApprovalPerson decimal(8) unsigned NOT NULL COMMENT '承認者コード', |
||
| 203 | ApprovalAuthority decimal(1) NOT NULL COMMENT '承認権限区分', |
||
| 204 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 205 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 206 | PRIMARY KEY (ApprovalCode, DepartmentCode, SeqNo) |
||
| 207 | ) COMMENT = '承認経路マスタ'; |
||
| 208 | |||
| 209 | |||
| 210 | -- 出勤日報データ
|
||
| 211 | CREATE TABLE AttendanceDailyData |
||
| 212 | ( |
||
| 213 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '作成者コード', |
||
| 214 | AttendanceDate date NOT NULL COMMENT '日報作成日', |
||
| 215 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 216 | ActionResult varchar(30) NOT NULL COMMENT '行動実績', |
||
| 217 | OvertimeHours decimal(4,1) NOT NULL COMMENT '残業時間', |
||
| 218 | WorkingComment varchar(120) COMMENT 'コメント', |
||
| 219 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 220 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 221 | PRIMARY KEY (PersonCode, AttendanceDate, SeqNo) |
||
| 222 | ) COMMENT = '出勤日報データ'; |
||
| 223 | |||
| 224 | |||
| 225 | -- 出勤管理データ
|
||
| 226 | CREATE TABLE AttendanceData |
||
| 227 | ( |
||
| 228 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '作成者コード', |
||
| 229 | AttendanceMonth date NOT NULL COMMENT '出勤管理年月', |
||
| 230 | LastDays decimal(2) unsigned NOT NULL COMMENT '当月最終日', |
||
| 231 | AttendDayCount decimal(2) unsigned NOT NULL COMMENT '出勤日数', |
||
| 232 | TotalOverTimes decimal(4,1) NOT NULL COMMENT '残業時間数', |
||
| 233 | OrderDate date NOT NULL COMMENT '申請日', |
||
| 234 | OrderNo decimal(2) unsigned NOT NULL COMMENT '申請受付番号', |
||
| 235 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 236 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 237 | PRIMARY KEY (PersonCode, AttendanceMonth) |
||
| 238 | ) COMMENT = '出勤管理データ'; |
||
| 239 | |||
| 240 | |||
| 241 | -- 工事詳細台帳データ【退避用】
|
||
| 242 | CREATE TABLE BK_ConstructionLedger |
||
| 243 | ( |
||
| 244 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 245 | ConstructionPeriod decimal(4) unsigned NOT NULL COMMENT '事業期', |
||
| 246 | CreatorCode decimal(8,0) COMMENT '作成者コード', |
||
| 247 | CreatorName varchar(60) COMMENT '作成者名', |
||
| 248 | CreateDate date NOT NULL COMMENT '作成日', |
||
| 249 | ConstructionTimes decimal(5,2) NOT NULL COMMENT '工期（単位・月）', |
||
| 250 | ConstructionStart date NOT NULL COMMENT '契約工期開始', |
||
| 251 | ConstructionEnd date NOT NULL COMMENT '契約工期完了', |
||
| 252 | OrdersDecisionPrice decimal(14,0) NOT NULL COMMENT '税抜受注決定金額', |
||
| 253 | CompanyExpenses decimal(10,0) NOT NULL COMMENT '会社経費合計', |
||
| 254 | DepartmentExpenses decimal(10,0) NOT NULL COMMENT '部署経費合計', |
||
| 255 | SalesExpenses decimal(10,0) NOT NULL COMMENT '営業経費合計', |
||
| 256 | TotalPayment decimal(10,0) NOT NULL COMMENT '総支払額', |
||
| 257 | GrossProfit decimal(10,0) NOT NULL COMMENT '粗利', |
||
| 258 | Allowance decimal(10,0) NOT NULL COMMENT '給与', |
||
| 259 | NetProfit decimal(10,0) NOT NULL COMMENT '純利益', |
||
| 260 | ComplateFlg decimal(1) NOT NULL COMMENT '入力完了フラグ', |
||
| 261 | IntegrationFlg decimal(1) NOT NULL COMMENT '受注金額積算フラグ', |
||
| 262 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 263 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 264 | PRIMARY KEY (ConstructionCode) |
||
| 265 | ) COMMENT = '工事詳細台帳データ【退避用】'; |
||
| 266 | |||
| 267 | |||
| 268 | -- 工事詳細台帳明細データ【退避用】
|
||
| 269 | CREATE TABLE BK_ConstructionLedgerDetail |
||
| 270 | ( |
||
| 271 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 272 | GroupCount decimal(2,0) unsigned NOT NULL COMMENT 'グループ番号', |
||
| 273 | LineCount decimal(5) unsigned NOT NULL COMMENT '行番号', |
||
| 274 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 275 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 276 | FirstString varchar(120) COMMENT '項目名称', |
||
| 277 | SecondString varchar(120) COMMENT '工事内容', |
||
| 278 | CompanyType decimal(1) NOT NULL COMMENT '協力会社コードタイプ', |
||
| 279 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 280 | CompanyName varchar(120) COMMENT '協力会社名称', |
||
| 281 | EstimatePrice decimal(12,0) NOT NULL COMMENT '予算（見積）金額', |
||
| 282 | ExecutionAmount decimal(12,0) NOT NULL COMMENT '実行金額', |
||
| 283 | AmountConfigRate decimal(5,2) NOT NULL COMMENT '金額構成率', |
||
| 284 | PaymentBurden decimal(12,0) NOT NULL COMMENT '支払補填額', |
||
| 285 | FixDataFlg decimal(1) NOT NULL COMMENT '固定データフラグ', |
||
| 286 | IndependentFlg decimal(1) NOT NULL COMMENT '独立データフラグ', |
||
| 287 | FluctuationFlg decimal(1) NOT NULL COMMENT '増減データフラグ', |
||
| 288 | SalaryFlg decimal(1) NOT NULL COMMENT '給与振分区分', |
||
| 289 | SalaryDays decimal(4) NOT NULL COMMENT '給与振分日数', |
||
| 290 | OperatingFlg decimal(1) NOT NULL COMMENT '担当中フラグ', |
||
| 291 | SourceCode decimal(10) unsigned NOT NULL COMMENT '元工事番号', |
||
| 292 | JoinTitleFlg decimal(1) NOT NULL COMMENT '工事名称タイトル', |
||
| 293 | SalaryOnRegist decimal(12,0) NOT NULL COMMENT '登録時月額給与', |
||
| 294 | PurchaseOrderFlg decimal(2) NOT NULL COMMENT '注文書発行フラグ', |
||
| 295 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 296 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 297 | PRIMARY KEY (ConstructionCode, GroupCount, LineCount) |
||
| 298 | ) COMMENT = '工事詳細台帳明細データ【退避用】'; |
||
| 299 | |||
| 300 | |||
| 301 | -- 工事詳細台帳実行データ【退避用】
|
||
| 302 | CREATE TABLE BK_ConstructionLedgerExcute |
||
| 303 | ( |
||
| 304 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 305 | GroupCount decimal(2,0) unsigned NOT NULL COMMENT 'グループ番号', |
||
| 306 | LineCount decimal(5) unsigned NOT NULL COMMENT '行番号', |
||
| 307 | ColumnCount decimal(3) NOT NULL COMMENT '列番号', |
||
| 308 | PaymentAmount decimal(12,0) NOT NULL COMMENT '支払金額', |
||
| 309 | TargetMonth date NOT NULL COMMENT '対象年月', |
||
| 310 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 311 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 312 | PRIMARY KEY (ConstructionCode, GroupCount, LineCount, ColumnCount) |
||
| 313 | ) COMMENT = '工事詳細台帳実行データ【退避用】'; |
||
| 314 | |||
| 315 | |||
| 316 | -- 積算見積データ【退避用】
|
||
| 317 | CREATE TABLE BK_EstimateData |
||
| 318 | ( |
||
| 319 | SaveDate datetime NOT NULL COMMENT '退避日付', |
||
| 320 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 321 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 322 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 323 | FixedItemCode varchar(1) COMMENT '固定項目キー', |
||
| 324 | ItemName varchar(120) COMMENT '作業名称', |
||
| 325 | SpecName varchar(120) COMMENT '作業／品質・形状・寸法', |
||
| 326 | PriceValue decimal(14,0) NOT NULL COMMENT '金額', |
||
| 327 | note varchar(60) COMMENT '備考', |
||
| 328 | MyExpensesFlg decimal(1) NOT NULL COMMENT '自社経費フラグ', |
||
| 329 | InputFlg decimal(1) NOT NULL COMMENT '入力フラグ', |
||
| 330 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 331 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 332 | PRIMARY KEY (SaveDate, ConstructionCode, LineCount) |
||
| 333 | ) COMMENT = '積算見積データ【退避用】'; |
||
| 334 | |||
| 335 | |||
| 336 | -- 積算見積ページデータ【退避用】
|
||
| 337 | CREATE TABLE BK_EstimateDataBody |
||
| 338 | ( |
||
| 339 | SaveDate datetime NOT NULL COMMENT '退避日付', |
||
| 340 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 341 | PageCount decimal(4) unsigned NOT NULL COMMENT 'ページ番号', |
||
| 342 | Category decimal(1) NOT NULL COMMENT 'ページ区分', |
||
| 343 | UnionComponentCode decimal(5) unsigned NOT NULL COMMENT '所属構成キー', |
||
| 344 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 345 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 346 | SelectComponent decimal(5) unsigned NOT NULL COMMENT '選択構成キー', |
||
| 347 | PageTitle varchar(120) NOT NULL COMMENT 'ページ表示名', |
||
| 348 | DetailLineCount decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 349 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 350 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 351 | PRIMARY KEY (SaveDate, ConstructionCode, PageCount) |
||
| 352 | ) COMMENT = '積算見積ページデータ【退避用】'; |
||
| 353 | |||
| 354 | |||
| 355 | -- 積算見積データ明細【退避用】
|
||
| 356 | CREATE TABLE BK_EstimateDataDetail |
||
| 357 | ( |
||
| 358 | SaveDate datetime NOT NULL COMMENT '退避日付', |
||
| 359 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 360 | PageCount decimal(4) unsigned NOT NULL COMMENT 'ページ番号', |
||
| 361 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 362 | DataType decimal(1) NOT NULL COMMENT 'データ種別', |
||
| 363 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 364 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 365 | SpecCode decimal(5,0) unsigned NOT NULL COMMENT '作業キー', |
||
| 366 | ItemName varchar(120) COMMENT '作業名称', |
||
| 367 | SpecName varchar(120) COMMENT '作業／品質・形状・寸法', |
||
| 368 | Unitcount decimal(8,2) NOT NULL COMMENT '数量', |
||
| 369 | UnitName varchar(30) COMMENT '単位名称', |
||
| 370 | UnitPrice decimal(9,2) NOT NULL COMMENT '単価', |
||
| 371 | LineTotal decimal(12,0) NOT NULL COMMENT '金額', |
||
| 372 | note varchar(60) COMMENT '備考', |
||
| 373 | CompanyCode decimal(8) NOT NULL COMMENT '協力会社コード', |
||
| 374 | MyExpensesFlg decimal(1) NOT NULL COMMENT '自社経費フラグ', |
||
| 375 | InputFlg decimal(1) COMMENT '入力フラグ', |
||
| 376 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 377 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 378 | PRIMARY KEY (SaveDate, ConstructionCode, PageCount, LineCount) |
||
| 379 | ) COMMENT = '積算見積データ明細【退避用】'; |
||
| 380 | |||
| 381 | |||
| 382 | -- 法人格マスタ
|
||
| 383 | CREATE TABLE BusinessTypeMaster |
||
| 384 | ( |
||
| 385 | BusinessTypeCode decimal(5,0) unsigned NOT NULL COMMENT '法人格コード', |
||
| 386 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 387 | BusinessTypeName varchar(100) DEFAULT '' NOT NULL COMMENT '業種名', |
||
| 388 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 389 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 390 | PRIMARY KEY (BusinessTypeCode) |
||
| 391 | ) COMMENT = '法人格マスタ'; |
||
| 392 | |||
| 393 | |||
| 394 | -- 共通費大項目マスタ
|
||
| 395 | CREATE TABLE CommonCostLarge |
||
| 396 | ( |
||
| 397 | LargeCode decimal(5,0) unsigned NOT NULL COMMENT '大項目キー', |
||
| 398 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 399 | LargeName varchar(50) DEFAULT '' NOT NULL COMMENT '大項目名称', |
||
| 400 | CommentText varchar(120) COMMENT '説明書き', |
||
| 401 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 402 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 403 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 404 | PRIMARY KEY (LargeCode) |
||
| 405 | ) COMMENT = '共通費大項目マスタ'; |
||
| 406 | |||
| 407 | |||
| 408 | -- 共通費工種関連マスタ
|
||
| 409 | CREATE TABLE CommonCostLinkMS |
||
| 410 | ( |
||
| 411 | LargeCode decimal(5,0) unsigned NOT NULL COMMENT '大項目キー', |
||
| 412 | MiddleCode decimal(5,0) unsigned NOT NULL COMMENT '中項目キー', |
||
| 413 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 414 | EntryDate datetime COMMENT '登録日付', |
||
| 415 | UpdateDate datetime COMMENT '更新日付', |
||
| 416 | PRIMARY KEY (LargeCode, MiddleCode, ItemCode) |
||
| 417 | ) COMMENT = '共通費工種関連マスタ'; |
||
| 418 | |||
| 419 | |||
| 420 | -- 共通費中項目マスタ
|
||
| 421 | CREATE TABLE CommonCostMiddle |
||
| 422 | ( |
||
| 423 | LargeCode decimal(5,0) unsigned NOT NULL COMMENT '大項目キー', |
||
| 424 | MiddleCode decimal(5,0) unsigned NOT NULL COMMENT '中項目キー', |
||
| 425 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 426 | MiddleName varchar(50) DEFAULT '' NOT NULL COMMENT '中項目名称', |
||
| 427 | CommentText varchar(120) COMMENT '説明書き', |
||
| 428 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 429 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 430 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 431 | PRIMARY KEY (LargeCode, MiddleCode) |
||
| 432 | ) COMMENT = '共通費中項目マスタ'; |
||
| 433 | |||
| 434 | |||
| 435 | -- 共通費中項目キーマスタ
|
||
| 436 | CREATE TABLE CommonCostMiddleSearchWord |
||
| 437 | ( |
||
| 438 | LargeCode decimal(5,0) unsigned NOT NULL COMMENT '大項目キー', |
||
| 439 | MiddleCode decimal(5,0) unsigned NOT NULL COMMENT '中項目キー', |
||
| 440 | SeqNo decimal(5) unsigned NOT NULL COMMENT '順序', |
||
| 441 | SearchWord varchar(50) DEFAULT '' NOT NULL COMMENT '検索項目', |
||
| 442 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 443 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 444 | PRIMARY KEY (LargeCode, MiddleCode, SeqNo) |
||
| 445 | ) COMMENT = '共通費中項目キーマスタ'; |
||
| 446 | |||
| 447 | |||
| 448 | -- 構成工種関連マスタ
|
||
| 449 | CREATE TABLE ComponentLinkMaster |
||
| 450 | ( |
||
| 451 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 452 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 453 | DisplayOrder decimal(5) unsigned COMMENT '表示順', |
||
| 454 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 455 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 456 | PRIMARY KEY (ComponentCode, ItemCode) |
||
| 457 | ) COMMENT = '構成工種関連マスタ'; |
||
| 458 | |||
| 459 | |||
| 460 | -- 構成マスタ
|
||
| 461 | CREATE TABLE ComponentMaster |
||
| 462 | ( |
||
| 463 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 464 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 465 | ComponentName varchar(120) DEFAULT '' NOT NULL COMMENT '構成名称', |
||
| 466 | SubItemsFlg decimal(1) COMMENT '下位項目フラグ', |
||
| 467 | DirectInputFlg decimal(1) COMMENT '直接入力フラグ', |
||
| 468 | MyExpensesFlg decimal(1) COMMENT '自社経費フラグ', |
||
| 469 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 470 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 471 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 472 | PRIMARY KEY (ComponentCode) |
||
| 473 | ) COMMENT = '構成マスタ'; |
||
| 474 | |||
| 475 | |||
| 476 | -- 構成工事種別関連マスタ
|
||
| 477 | CREATE TABLE ComponentToTypeMaster |
||
| 478 | ( |
||
| 479 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 480 | TypeCode decimal(5,0) unsigned NOT NULL COMMENT '工事種別コード', |
||
| 481 | Dummy decimal(1) NOT NULL COMMENT 'ダミー項目', |
||
| 482 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 483 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 484 | PRIMARY KEY (ComponentCode, TypeCode) |
||
| 485 | ) COMMENT = '構成工事種別関連マスタ'; |
||
| 486 | |||
| 487 | |||
| 488 | -- 工事基本情報
|
||
| 489 | CREATE TABLE ConstructionBaseInfo |
||
| 490 | ( |
||
| 491 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 492 | TyingFlg decimal(1) NOT NULL COMMENT '紐付データフラグ', |
||
| 493 | JoinFlg decimal(1) NOT NULL COMMENT '結合契約工事フラグ', |
||
| 494 | ConstructionYear smallint unsigned NOT NULL COMMENT '工事年度', |
||
| 495 | ConstructionPeriod smallint unsigned NOT NULL COMMENT '工事期数', |
||
| 496 | RequestedDate date COMMENT '依頼受け日', |
||
| 497 | EstimatesSubmitDeadline date COMMENT '見積提出期限', |
||
| 498 | EstimatesSubmittedDate date COMMENT '見積提出日', |
||
| 499 | ProvisionalOrderDate date COMMENT '仮受注日', |
||
| 500 | OrderDate date COMMENT '受注日', |
||
| 501 | OrderStartingDate date COMMENT '開始予定日', |
||
| 502 | OrderCompletionDate date COMMENT '完了予定日', |
||
| 503 | PreparationStartDate date COMMENT '施工準備開始日', |
||
| 504 | ConstructionStartingDate date COMMENT '施工開始日', |
||
| 505 | ConstructionCompletionDate date COMMENT '施工完了日', |
||
| 506 | NonOrderDate date COMMENT '非受注日', |
||
| 507 | OrdersDecisionPrice decimal(12,0) NOT NULL COMMENT '税抜受注決定金額', |
||
| 508 | OrdersDecisionPriceInTax decimal(12,0) NOT NULL COMMENT '税込受注決定金額', |
||
| 509 | SalesPersonCode decimal(8,0) COMMENT '営業担当者名', |
||
| 510 | ConstructionPersonCode decimal(8,0) NOT NULL COMMENT '工事担当者', |
||
| 511 | ConstrSubPersonCode decimal(8,0) NOT NULL COMMENT '工事副担当者', |
||
| 512 | ConstructionInstructor decimal(8,0) NOT NULL COMMENT '工事指導員', |
||
| 513 | TransferConstruction decimal(8,0) NOT NULL COMMENT '工事移管先コード', |
||
| 514 | TransferConstructionDate date COMMENT '工事移管日', |
||
| 515 | OrderersDivision decimal(5) NOT NULL COMMENT '発注者区分', |
||
| 516 | OrderersCode decimal(5,0) unsigned NOT NULL COMMENT '発注者コード', |
||
| 517 | EstimatesExpirationDate date COMMENT '見積有効期限', |
||
| 518 | ConstructionPeriodStart date COMMENT '契約工期開始日', |
||
| 519 | ConstructionPeriodEnd date COMMENT '契約工期完了', |
||
| 520 | ConstructionPeriodStart2 date COMMENT '契約工期開始（延長時）', |
||
| 521 | ConstructionPeriodEnd2 date COMMENT '契約工期完了（延長時）', |
||
| 522 | StartDate date COMMENT '工事開始日', |
||
| 523 | EndDate date COMMENT '工事終了日', |
||
| 524 | PurchaseOrderMailingDate date COMMENT '注文書郵送日', |
||
| 525 | PurchaseOrderReturnDate date COMMENT '注文書返送日', |
||
| 526 | PurchaseOrderReturnCheckDate date COMMENT '注文書返送確認日', |
||
| 527 | ConsumptionTaxFlg decimal(1) NOT NULL COMMENT '消費税フラグ', |
||
| 528 | PrimeContractorFlg decimal(1) NOT NULL COMMENT '元請フラグ', |
||
| 529 | SalesCostFlg decimal(1) NOT NULL COMMENT '営業経費発生フラグ', |
||
| 530 | ConstructionStatusFlg decimal(2,0) NOT NULL COMMENT '工事状態フラグ', |
||
| 531 | ConstructionType decimal(5) NOT NULL COMMENT '工事種別コード', |
||
| 532 | EstimateType decimal(1) NOT NULL COMMENT '見積種別', |
||
| 533 | BillingStartDate date NOT NULL COMMENT '請求準備開始日', |
||
| 534 | BillingDate date NOT NULL COMMENT '請求日', |
||
| 535 | BillingSplitFlg decimal(1) NOT NULL COMMENT '請求回数フラグ', |
||
| 536 | BillingSendDate date COMMENT '請求書郵送/手渡し日', |
||
| 537 | LedgerComplateDate date NOT NULL COMMENT '工事詳細台帳入力完了日付', |
||
| 538 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 539 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 540 | PRIMARY KEY (ConstructionCode) |
||
| 541 | ) COMMENT = '工事基本情報'; |
||
| 542 | |||
| 543 | |||
| 544 | -- 工事基本情報明細
|
||
| 545 | CREATE TABLE ConstructionBaseInfoDetail |
||
| 546 | ( |
||
| 547 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 548 | DetailNo decimal(2) NOT NULL COMMENT '明細番号', |
||
| 549 | DetailString varchar(120) COMMENT '明細内容', |
||
| 550 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 551 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 552 | PRIMARY KEY (ConstructionCode, DetailNo) |
||
| 553 | ) COMMENT = '工事基本情報明細'; |
||
| 554 | |||
| 555 | |||
| 556 | -- 工事施工予算データ
|
||
| 557 | CREATE TABLE ConstructionBudget |
||
| 558 | ( |
||
| 559 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 560 | CreatorCode decimal(8,0) NOT NULL COMMENT '作成者コード', |
||
| 561 | CreatorName varchar(60) COMMENT '作成者名', |
||
| 562 | CreatorCosts decimal(11,0) NOT NULL COMMENT '作成者給与', |
||
| 563 | AssistantCode decimal(8,0) NOT NULL COMMENT '副担当者コード', |
||
| 564 | AssistantName varchar(60) COMMENT '副担当者名', |
||
| 565 | AssistantCosts decimal(11,0) NOT NULL COMMENT '副担当者給与', |
||
| 566 | InstructorCode decimal(8,0) NOT NULL COMMENT '工事指導員コード', |
||
| 567 | InstructorName varchar(60) COMMENT '工事指導員名', |
||
| 568 | InstructorCosts decimal(11,0) NOT NULL COMMENT '工事指導員給与', |
||
| 569 | CreateDate date NOT NULL COMMENT '作成日', |
||
| 570 | ConstructionTimes decimal(5,2) NOT NULL COMMENT '工期（単位・月）', |
||
| 571 | ConstructionStart date NOT NULL COMMENT '契約工期開始', |
||
| 572 | ConstructionEnd date NOT NULL COMMENT '契約工期完了', |
||
| 573 | InstructorTimes decimal(5,2) NOT NULL COMMENT '指導員稼働月数', |
||
| 574 | SalaryFlg decimal(1) NOT NULL COMMENT '給与振分区分', |
||
| 575 | SalaryDays decimal(4) NOT NULL COMMENT '振分日数', |
||
| 576 | A_SalaryFlg decimal(1) NOT NULL COMMENT '副担当者給与振分区分', |
||
| 577 | A_SalaryDays decimal(4) NOT NULL COMMENT '副担当者振分日数', |
||
| 578 | I_SalaryFlg decimal(1) NOT NULL COMMENT '指導員給与振分区分', |
||
| 579 | I_SalaryDays decimal(4) NOT NULL COMMENT '指導員振分日数', |
||
| 580 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 581 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 582 | PRIMARY KEY (ConstructionCode) |
||
| 583 | ) COMMENT = '工事施工予算データ'; |
||
| 584 | |||
| 585 | |||
| 586 | -- 工事施工予算データ明細
|
||
| 587 | CREATE TABLE ConstructionBudgetDetail |
||
| 588 | ( |
||
| 589 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 590 | GroupCount decimal(2,0) unsigned NOT NULL COMMENT 'グループ番号', |
||
| 591 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 592 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 593 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 594 | FirstString varchar(120) COMMENT '項目名称', |
||
| 595 | SecondString varchar(120) COMMENT '工事内容', |
||
| 596 | CompanyType decimal(1) NOT NULL COMMENT '協力会社コードタイプ', |
||
| 597 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 598 | CompanyName varchar(120) COMMENT '協力会社名称', |
||
| 599 | EstimatePrice decimal(12,0) NOT NULL COMMENT '積算時見積金額', |
||
| 600 | NegotiationPrice decimal(12,0) NOT NULL COMMENT '積算時交渉金額', |
||
| 601 | OrderDesiredAmount decimal(12,0) NOT NULL COMMENT '発注希望金額', |
||
| 602 | ExecutionAmount decimal(12,0) NOT NULL COMMENT '実行金額', |
||
| 603 | AmountConfigRate decimal(5,2) NOT NULL COMMENT '金額構成率', |
||
| 604 | NegotiateFlg decimal(1) NOT NULL COMMENT '協力業者交渉フラグ', |
||
| 605 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 606 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 607 | PRIMARY KEY (ConstructionCode, GroupCount, LineCount) |
||
| 608 | ) COMMENT = '工事施工予算データ明細'; |
||
| 609 | |||
| 610 | |||
| 611 | -- 工種マスタ
|
||
| 612 | CREATE TABLE ConstructionItemMaster |
||
| 613 | ( |
||
| 614 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 615 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 616 | ItemName varchar(120) DEFAULT '' NOT NULL COMMENT '工種名称', |
||
| 617 | SubItemsFlg decimal(1) COMMENT '下位項目フラグ', |
||
| 618 | MyExpensesFlg decimal(1) NOT NULL COMMENT '自社経費フラグ', |
||
| 619 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 620 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 621 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 622 | PRIMARY KEY (ItemCode) |
||
| 623 | ) COMMENT = '工種マスタ'; |
||
| 624 | |||
| 625 | |||
| 626 | -- 工事詳細台帳データ
|
||
| 627 | CREATE TABLE ConstructionLedger |
||
| 628 | ( |
||
| 629 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 630 | ConstructionPeriod decimal(4) unsigned NOT NULL COMMENT '事業期', |
||
| 631 | CreatorCode decimal(8,0) COMMENT '作成者コード', |
||
| 632 | CreatorName varchar(60) COMMENT '作成者名', |
||
| 633 | CreateDate date NOT NULL COMMENT '作成日', |
||
| 634 | ConstructionTimes decimal(5,2) NOT NULL COMMENT '工期（単位・月）', |
||
| 635 | ConstructionStart date NOT NULL COMMENT '契約工期開始', |
||
| 636 | ConstructionEnd date NOT NULL COMMENT '契約工期完了', |
||
| 637 | OrdersDecisionPrice decimal(14,0) NOT NULL COMMENT '税抜受注決定金額', |
||
| 638 | CompanyExpenses decimal(10,0) NOT NULL COMMENT '会社経費合計', |
||
| 639 | DepartmentExpenses decimal(10,0) NOT NULL COMMENT '部署経費合計', |
||
| 640 | SalesExpenses decimal(10,0) NOT NULL COMMENT '営業経費合計', |
||
| 641 | TotalPayment decimal(10,0) NOT NULL COMMENT '総支払額', |
||
| 642 | GrossProfit decimal(10,0) NOT NULL COMMENT '粗利', |
||
| 643 | Allowance decimal(10,0) NOT NULL COMMENT '給与', |
||
| 644 | NetProfit decimal(10,0) NOT NULL COMMENT '純利益', |
||
| 645 | ComplateFlg decimal(1) NOT NULL COMMENT '入力完了フラグ', |
||
| 646 | IntegrationFlg decimal(1) NOT NULL COMMENT '受注金額積算フラグ', |
||
| 647 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 648 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 649 | PRIMARY KEY (ConstructionCode) |
||
| 650 | ) COMMENT = '工事詳細台帳データ'; |
||
| 651 | |||
| 652 | |||
| 653 | -- 工事詳細台帳明細データ
|
||
| 654 | CREATE TABLE ConstructionLedgerDetail |
||
| 655 | ( |
||
| 656 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 657 | GroupCount decimal(2,0) unsigned NOT NULL COMMENT 'グループ番号', |
||
| 658 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 659 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 660 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 661 | FirstString varchar(120) COMMENT '項目名称', |
||
| 662 | SecondString varchar(120) COMMENT '工事内容', |
||
| 663 | CompanyType decimal(1) NOT NULL COMMENT '協力会社コードタイプ', |
||
| 664 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 665 | CompanyName varchar(120) COMMENT '協力会社名称', |
||
| 666 | EstimatePrice decimal(12,0) NOT NULL COMMENT '予算（見積）金額', |
||
| 667 | ExecutionAmount decimal(12,0) NOT NULL COMMENT '実行金額', |
||
| 668 | AmountConfigRate decimal(5,2) NOT NULL COMMENT '金額構成率', |
||
| 669 | PaymentBurden decimal(12,0) NOT NULL COMMENT '支払補填額', |
||
| 670 | FixDataFlg decimal(1) NOT NULL COMMENT '固定データフラグ', |
||
| 671 | IndependentFlg decimal(1) NOT NULL COMMENT '独立データフラグ', |
||
| 672 | FluctuationFlg decimal(1) NOT NULL COMMENT '増減データフラグ', |
||
| 673 | SalaryFlg decimal(1) NOT NULL COMMENT '給与振分区分', |
||
| 674 | SalaryDays decimal(4) NOT NULL COMMENT '給与振分日数', |
||
| 675 | OperatingFlg decimal(1) NOT NULL COMMENT '担当中フラグ', |
||
| 676 | SourceCode decimal(10) unsigned NOT NULL COMMENT '元工事番号', |
||
| 677 | JoinTitleFlg decimal(1) NOT NULL COMMENT '工事名称タイトル', |
||
| 678 | SalaryOnRegist decimal(12,0) NOT NULL COMMENT '登録時月額給与', |
||
| 679 | PurchaseOrderFlg decimal(2) NOT NULL COMMENT '注文書発行フラグ', |
||
| 680 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 681 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 682 | PRIMARY KEY (ConstructionCode, GroupCount, LineCount) |
||
| 683 | ) COMMENT = '工事詳細台帳明細データ'; |
||
| 684 | |||
| 685 | |||
| 686 | -- 工事詳細台帳実行データ
|
||
| 687 | CREATE TABLE ConstructionLedgerExcute |
||
| 688 | ( |
||
| 689 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 690 | GroupCount decimal(2,0) unsigned NOT NULL COMMENT 'グループ番号', |
||
| 691 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 692 | ColumnCount decimal(3) NOT NULL COMMENT '列番号', |
||
| 693 | PaymentAmount decimal(12,0) NOT NULL COMMENT '支払金額', |
||
| 694 | TargetMonth date NOT NULL COMMENT '対象年月', |
||
| 695 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 696 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 697 | PRIMARY KEY (ConstructionCode, GroupCount, LineCount, ColumnCount) |
||
| 698 | ) COMMENT = '工事詳細台帳実行データ'; |
||
| 699 | |||
| 700 | |||
| 701 | -- 工事リンク情報
|
||
| 702 | CREATE TABLE ConstructionLink |
||
| 703 | ( |
||
| 704 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 705 | FluctuationCode decimal(10,0) NOT NULL COMMENT '子工事番号', |
||
| 706 | LinkType decimal(1) NOT NULL COMMENT 'リンク種別', |
||
| 707 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 708 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 709 | PRIMARY KEY (ConstructionCode, FluctuationCode) |
||
| 710 | ) COMMENT = '工事リンク情報'; |
||
| 711 | |||
| 712 | |||
| 713 | -- 案件進捗日付データ
|
||
| 714 | CREATE TABLE ConstructionProgressDate |
||
| 715 | ( |
||
| 716 | ConstructionCode decimal(10,0) NOT NULL COMMENT '工事番号', |
||
| 717 | ConstructionStatusFlg decimal(2,0) NOT NULL COMMENT '設定工事状態', |
||
| 718 | PreviousStatusFlg decimal(2,0) COMMENT '変更前状態', |
||
| 719 | ChangeDate datetime NOT NULL COMMENT '設定日付', |
||
| 720 | ChangePersonCode decimal(8,0) NOT NULL COMMENT '設定担当者', |
||
| 721 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 722 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 723 | PRIMARY KEY (ConstructionCode, ConstructionStatusFlg) |
||
| 724 | ) COMMENT = '案件進捗日付データ'; |
||
| 725 | |||
| 726 | |||
| 727 | -- 作業マスタ
|
||
| 728 | CREATE TABLE ConstructionSpecMaster |
||
| 729 | ( |
||
| 730 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 731 | SpecCode decimal(5,0) unsigned NOT NULL COMMENT '作業キー', |
||
| 732 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 733 | ItemName varchar(120) DEFAULT '' COMMENT '作業名称', |
||
| 734 | SpecName varchar(120) COMMENT '作業名称', |
||
| 735 | UnitName varchar(30) COMMENT '単位名称', |
||
| 736 | UnitPrice decimal(9,2) NOT NULL COMMENT '単価', |
||
| 737 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 738 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 739 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 740 | PRIMARY KEY (ItemCode, SpecCode) |
||
| 741 | ) COMMENT = '作業マスタ'; |
||
| 742 | |||
| 743 | |||
| 744 | -- 作業単価マスタ
|
||
| 745 | CREATE TABLE ConstructionSpecUnitPrice |
||
| 746 | ( |
||
| 747 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 748 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 749 | SpecCode decimal(5,0) unsigned NOT NULL COMMENT '作業キー', |
||
| 750 | ConstructionTypeCode mediumint unsigned NOT NULL COMMENT '工事種別コード', |
||
| 751 | UnitPrice decimal(9,2) NOT NULL COMMENT '単価', |
||
| 752 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 753 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 754 | PRIMARY KEY (ComponentCode, ItemCode, SpecCode, ConstructionTypeCode) |
||
| 755 | ) COMMENT = '作業単価マスタ'; |
||
| 756 | |||
| 757 | |||
| 758 | -- 工事種別マスタ
|
||
| 759 | CREATE TABLE ConstructionTypeMaster |
||
| 760 | ( |
||
| 761 | TypeCode decimal(5,0) unsigned NOT NULL COMMENT '工事種別コード', |
||
| 762 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 763 | NameString varchar(100) DEFAULT '' NOT NULL COMMENT '名称', |
||
| 764 | PublicFlg decimal(1) NOT NULL COMMENT '工事種別フラグ', |
||
| 765 | SecRank decimal(1) NOT NULL COMMENT '保護区分ランク', |
||
| 766 | ExpensesLink decimal(1) NOT NULL COMMENT '経費使用区分', |
||
| 767 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 768 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 769 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 770 | PRIMARY KEY (TypeCode) |
||
| 771 | ) COMMENT = '工事種別マスタ'; |
||
| 772 | |||
| 773 | |||
| 774 | -- 担当者毎経費データ
|
||
| 775 | CREATE TABLE CostDataOfPerson |
||
| 776 | ( |
||
| 777 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 778 | ActionDate date NOT NULL COMMENT '対象日付', |
||
| 779 | DataType decimal(1) NOT NULL COMMENT 'データ区分', |
||
| 780 | DataAddCount decimal(5) unsigned NOT NULL COMMENT 'データ追加番号', |
||
| 781 | TargetMonth varchar(7) NOT NULL COMMENT '対象年月', |
||
| 782 | ConstructionCode decimal(10,0) unsigned COMMENT '工事コード', |
||
| 783 | SuppliersCode decimal(5) unsigned NOT NULL COMMENT '支払先コード', |
||
| 784 | SuppliersName varchar(120) COMMENT '支払先名称', |
||
| 785 | PaymentContent varchar(60) COMMENT '支払内容', |
||
| 786 | PaymentType decimal(1) NOT NULL COMMENT '支払方法フラグ', |
||
| 787 | EntryPrice decimal(12,0) NOT NULL COMMENT '金額（税抜）', |
||
| 788 | EntryPriceInTax decimal(12,0) NOT NULL COMMENT '金額（税込）', |
||
| 789 | SlipNumber varchar(12) COMMENT '伝票番号', |
||
| 790 | ComplateFlg decimal(1) NOT NULL COMMENT '引込済みフラグ', |
||
| 791 | ApprovalFlg decimal(1) NOT NULL COMMENT '承認フラグ', |
||
| 792 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 793 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 794 | PRIMARY KEY (PersonCode, ActionDate, DataType, DataAddCount) |
||
| 795 | ) COMMENT = '担当者毎経費データ'; |
||
| 796 | |||
| 797 | |||
| 798 | -- 発注者登録申請データ
|
||
| 799 | CREATE TABLE CostomerRegist |
||
| 800 | ( |
||
| 801 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '申請者番号', |
||
| 802 | CreateDate date NOT NULL COMMENT '作成日', |
||
| 803 | SeqNo decimal(2) NOT NULL COMMENT 'キー連番', |
||
| 804 | DataMode decimal(1) NOT NULL COMMENT 'データ区分', |
||
| 805 | SourceCotegory decimal(5) unsigned NOT NULL COMMENT '発注者区分', |
||
| 806 | SourceCode decimal(5) unsigned NOT NULL COMMENT '発注者コード', |
||
| 807 | PetitionPeriod decimal(4) unsigned NOT NULL COMMENT '事業期', |
||
| 808 | OrderFlg decimal(1) NOT NULL COMMENT '法人団体・個人フラグ', |
||
| 809 | CorporateStatusName varchar(100) COMMENT '法人格名称', |
||
| 810 | CorporateStatusPoint decimal(1) COMMENT '法人格名称位置', |
||
| 811 | OrderersName1 varchar(60) DEFAULT '' NOT NULL COMMENT '発注者名1', |
||
| 812 | OrderersName2 varchar(60) COMMENT '発注者名２', |
||
| 813 | DepartmentName varchar(60) COMMENT '部署名', |
||
| 814 | ChargePersonName varchar(60) COMMENT '担当者名', |
||
| 815 | ZipCode varchar(8) COMMENT '郵便番号', |
||
| 816 | Address1 varchar(60) COMMENT '住所１', |
||
| 817 | Address2 varchar(60) DEFAULT '' COMMENT '住所2', |
||
| 818 | Address3 varchar(60) COMMENT '住所3', |
||
| 819 | PhoneNumber varchar(13) DEFAULT '' COMMENT '電話番号', |
||
| 820 | FaxNumber varchar(13) DEFAULT '' COMMENT 'FAX番号', |
||
| 821 | MailAddress varchar(257) COMMENT 'メールアドレス', |
||
| 822 | Note varchar(300) DEFAULT '' COMMENT '備考', |
||
| 823 | OrderCotegory decimal(5,0) unsigned NOT NULL COMMENT '発注者区分', |
||
| 824 | OrderDate date NOT NULL COMMENT '申請日', |
||
| 825 | OrderNo decimal(2) unsigned NOT NULL COMMENT '申請受付番号', |
||
| 826 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 827 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 828 | PRIMARY KEY (PersonCode, CreateDate, SeqNo) |
||
| 829 | ) COMMENT = '発注者登録申請データ'; |
||
| 830 | |||
| 831 | |||
| 832 | -- 日報データ
|
||
| 833 | CREATE TABLE DailyDataConstruction |
||
| 834 | ( |
||
| 835 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 836 | DailyDataDate date NOT NULL COMMENT '日報作成日', |
||
| 837 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 838 | Weather varchar(60) COMMENT '天気', |
||
| 839 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 840 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 841 | PRIMARY KEY (PersonCode, DailyDataDate, ConstructionCode) |
||
| 842 | ) COMMENT = '日報データ'; |
||
| 843 | |||
| 844 | |||
| 845 | -- 日報データ (明細)
|
||
| 846 | CREATE TABLE DailyDataDetail |
||
| 847 | ( |
||
| 848 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 849 | DailyDataDate date NOT NULL COMMENT '日報作成日', |
||
| 850 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 851 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 852 | JobCategoryCode decimal(5,0) NOT NULL COMMENT '職種キー', |
||
| 853 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 854 | TodayHeadCount decimal(4,1) NOT NULL COMMENT '当日人員数', |
||
| 855 | TotalHeadCount decimal(5,1) NOT NULL COMMENT '累計人員数', |
||
| 856 | TodayWork varchar(100) COMMENT '当日作業内容', |
||
| 857 | NextdayWork varchar(100) COMMENT '翌日作業内容', |
||
| 858 | NextdayHeadCount decimal(4,1) NOT NULL COMMENT '翌日人員数', |
||
| 859 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 860 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 861 | PRIMARY KEY (PersonCode, DailyDataDate, ConstructionCode, SeqNo) |
||
| 862 | ) COMMENT = '日報データ (明細)'; |
||
| 863 | |||
| 864 | |||
| 865 | -- 日報データ (現場巡回)
|
||
| 866 | CREATE TABLE DailyDataField |
||
| 867 | ( |
||
| 868 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '作成者コード', |
||
| 869 | DailyDataDate date NOT NULL COMMENT '日報作成日', |
||
| 870 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 871 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 872 | PatrolTime datetime NOT NULL COMMENT '巡回時間', |
||
| 873 | ContentsText varchar(200) COMMENT '内容', |
||
| 874 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 875 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 876 | PRIMARY KEY (PersonCode, DailyDataDate, ConstructionCode, SeqNo) |
||
| 877 | ) COMMENT = '日報データ (現場巡回)'; |
||
| 878 | |||
| 879 | |||
| 880 | -- 日報データ (資材)
|
||
| 881 | CREATE TABLE DailyDataMaterials |
||
| 882 | ( |
||
| 883 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '作成者コード', |
||
| 884 | DailyDataDate date NOT NULL COMMENT '日報作成日', |
||
| 885 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 886 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 887 | Materials varchar(100) COMMENT '資材名', |
||
| 888 | Quantity varchar(100) COMMENT '数量', |
||
| 889 | Production varchar(100) COMMENT '制作会社', |
||
| 890 | Delivery varchar(100) COMMENT '納入業者', |
||
| 891 | QualityControl varchar(100) COMMENT '品質管理事項', |
||
| 892 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 893 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 894 | PRIMARY KEY (PersonCode, DailyDataDate, ConstructionCode, SeqNo) |
||
| 895 | ) COMMENT = '日報データ (資材)'; |
||
| 896 | |||
| 897 | |||
| 898 | -- 日報データ (協力業者指示)
|
||
| 899 | CREATE TABLE DailyDataSubcontractors |
||
| 900 | ( |
||
| 901 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '作成者コード', |
||
| 902 | DailyDataDate date NOT NULL COMMENT '日報作成日', |
||
| 903 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 904 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 905 | Attendee varchar(100) COMMENT '出席者', |
||
| 906 | ContentsText varchar(200) COMMENT '内容', |
||
| 907 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 908 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 909 | PRIMARY KEY (PersonCode, DailyDataDate, ConstructionCode, SeqNo) |
||
| 910 | ) COMMENT = '日報データ (協力業者指示)'; |
||
| 911 | |||
| 912 | |||
| 913 | -- 日報データ (車両)
|
||
| 914 | CREATE TABLE DailyDataVehicles |
||
| 915 | ( |
||
| 916 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '作成者コード', |
||
| 917 | DailyDataDate date NOT NULL COMMENT '日報作成日', |
||
| 918 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 919 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 920 | Model varchar(100) COMMENT '機種', |
||
| 921 | Performance varchar(100) COMMENT '性能', |
||
| 922 | Owner varchar(100) COMMENT '所有会社', |
||
| 923 | Driver varchar(100) COMMENT '当日運転者', |
||
| 924 | StartWorkingTime datetime NOT NULL COMMENT '作業時間開始', |
||
| 925 | EndWorkingTime datetime NOT NULL COMMENT '作業時間終了', |
||
| 926 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 927 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 928 | PRIMARY KEY (PersonCode, DailyDataDate, ConstructionCode, SeqNo) |
||
| 929 | ) COMMENT = '日報データ (車両)'; |
||
| 930 | |||
| 931 | |||
| 932 | 101 | h-you | -- 日マスタ
|
| 933 | CREATE TABLE DayMaster |
||
| 934 | ( |
||
| 935 | days smallint NOT NULL COMMENT '日' |
||
| 936 | ) COMMENT = '日マスタ'; |
||
| 937 | |||
| 938 | |||
| 939 | 84 | h-you | -- 部署経費率マスタ
|
| 940 | CREATE TABLE DepartmentExpensesMaster |
||
| 941 | ( |
||
| 942 | DepartmentCode decimal(5,0) unsigned NOT NULL COMMENT '部署コード', |
||
| 943 | ExpensesPeriod smallint NOT NULL COMMENT '事業期', |
||
| 944 | NameCode decimal(5,0) unsigned NOT NULL COMMENT '経費名称コード', |
||
| 945 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 946 | ExpensesRaito decimal(4,2) NOT NULL COMMENT '経費率', |
||
| 947 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 948 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 949 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 950 | PRIMARY KEY (DepartmentCode, ExpensesPeriod, NameCode) |
||
| 951 | ) COMMENT = '部署経費率マスタ'; |
||
| 952 | |||
| 953 | |||
| 954 | -- 部署マスタ
|
||
| 955 | CREATE TABLE DepartmentMaster |
||
| 956 | ( |
||
| 957 | DepartmentCode decimal(5,0) unsigned NOT NULL COMMENT '部署コード', |
||
| 958 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 959 | DepartmentString varchar(100) DEFAULT '' NOT NULL COMMENT '部署名', |
||
| 960 | ActionScheduleFlg decimal(1) NOT NULL COMMENT '行動予定表示フラグ', |
||
| 961 | StaffAssignFlg decimal(1) NOT NULL COMMENT '人員配置表示フラグ', |
||
| 962 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 963 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 964 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 965 | PRIMARY KEY (DepartmentCode) |
||
| 966 | ) COMMENT = '部署マスタ'; |
||
| 967 | |||
| 968 | |||
| 969 | -- 区分マスタ
|
||
| 970 | CREATE TABLE DivisionMaster |
||
| 971 | ( |
||
| 972 | DivisionCode decimal(5,0) unsigned NOT NULL COMMENT '区分コード', |
||
| 973 | NameCode decimal(5,0) unsigned NOT NULL COMMENT '名称コード', |
||
| 974 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 975 | NameString varchar(100) DEFAULT '' NOT NULL COMMENT '名称', |
||
| 976 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 977 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 978 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 979 | PRIMARY KEY (DivisionCode, NameCode) |
||
| 980 | ) COMMENT = '区分マスタ'; |
||
| 981 | |||
| 982 | |||
| 983 | -- 積算予算書データ
|
||
| 984 | CREATE TABLE EstimateBudget |
||
| 985 | ( |
||
| 986 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 987 | ConstructionTime decimal(5,2) unsigned NOT NULL COMMENT '工期', |
||
| 988 | IntegratedCode decimal(8) NOT NULL COMMENT '積算者', |
||
| 989 | DataCreateDate datetime NOT NULL COMMENT 'データ引込日', |
||
| 990 | RetValue1 decimal(12,0) NOT NULL COMMENT '予定価格', |
||
| 991 | RetValue2 decimal(12,0) NOT NULL COMMENT '直接工事費', |
||
| 992 | RetValue3 decimal(12,0) NOT NULL COMMENT '積み上げ共通仮設費', |
||
| 993 | RetValue4 decimal(12,0) NOT NULL COMMENT '積み上げ現場管理費', |
||
| 994 | RetPercent decimal(5,2) NOT NULL COMMENT '一般管理費率', |
||
| 995 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 996 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 997 | PRIMARY KEY (ConstructionCode) |
||
| 998 | ) COMMENT = '積算予算書データ'; |
||
| 999 | |||
| 1000 | |||
| 1001 | -- 積算予算内訳データ明細
|
||
| 1002 | CREATE TABLE EstimateBudgetDetail |
||
| 1003 | ( |
||
| 1004 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1005 | GroupCount decimal(2,0) unsigned NOT NULL COMMENT 'グループ番号', |
||
| 1006 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 1007 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 1008 | ItemCode decimal(5,0) unsigned COMMENT '工種キー', |
||
| 1009 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 1010 | FirstString varchar(120) COMMENT '大項目名称', |
||
| 1011 | SecondString varchar(120) COMMENT '工種名称・協力会社名', |
||
| 1012 | Content varchar(120) COMMENT '内容', |
||
| 1013 | EstimatePrice decimal(12,0) NOT NULL COMMENT '見積時金額', |
||
| 1014 | NegotiationPrice decimal(12,0) NOT NULL COMMENT '交渉時金額', |
||
| 1015 | Notes varchar(120) COMMENT '注意事項', |
||
| 1016 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1017 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1018 | PRIMARY KEY (ConstructionCode, GroupCount, LineCount) |
||
| 1019 | ) COMMENT = '積算予算内訳データ明細'; |
||
| 1020 | |||
| 1021 | |||
| 1022 | -- 積算見積データ
|
||
| 1023 | CREATE TABLE EstimateData |
||
| 1024 | ( |
||
| 1025 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1026 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 1027 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 1028 | FixedItemCode varchar(1) COMMENT '固定項目キー', |
||
| 1029 | ItemName varchar(120) COMMENT '作業名称', |
||
| 1030 | SpecName varchar(120) COMMENT '作業／品質・形状・寸法', |
||
| 1031 | PriceValue decimal(14,0) NOT NULL COMMENT '金額', |
||
| 1032 | note varchar(60) COMMENT '備考', |
||
| 1033 | MyExpensesFlg decimal(1) NOT NULL COMMENT '自社経費フラグ', |
||
| 1034 | InputFlg decimal(1) NOT NULL COMMENT '入力フラグ', |
||
| 1035 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1036 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1037 | PRIMARY KEY (ConstructionCode, LineCount) |
||
| 1038 | ) COMMENT = '積算見積データ'; |
||
| 1039 | |||
| 1040 | |||
| 1041 | -- 積算見積ページデータ
|
||
| 1042 | CREATE TABLE EstimateDataBody |
||
| 1043 | ( |
||
| 1044 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1045 | PageCount decimal(4) unsigned NOT NULL COMMENT 'ページ番号', |
||
| 1046 | Category decimal(1) NOT NULL COMMENT 'ページ区分', |
||
| 1047 | UnionComponentCode decimal(5) unsigned NOT NULL COMMENT '所属構成キー', |
||
| 1048 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 1049 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 1050 | SelectComponent decimal(5) unsigned NOT NULL COMMENT '選択構成キー', |
||
| 1051 | PageTitle varchar(120) NOT NULL COMMENT 'ページ表示名', |
||
| 1052 | DetailLineCount decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 1053 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1054 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1055 | PRIMARY KEY (ConstructionCode, PageCount) |
||
| 1056 | ) COMMENT = '積算見積ページデータ'; |
||
| 1057 | |||
| 1058 | |||
| 1059 | -- 積算見積データ明細
|
||
| 1060 | CREATE TABLE EstimateDataDetail |
||
| 1061 | ( |
||
| 1062 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1063 | PageCount decimal(4) unsigned NOT NULL COMMENT 'ページ番号', |
||
| 1064 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 1065 | DataType decimal(1) NOT NULL COMMENT 'データ種別', |
||
| 1066 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 1067 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 1068 | SpecCode decimal(5,0) unsigned NOT NULL COMMENT '作業キー', |
||
| 1069 | ItemName varchar(120) COMMENT '作業名称', |
||
| 1070 | SpecName varchar(120) COMMENT '作業／品質・形状・寸法', |
||
| 1071 | Unitcount decimal(8,2) NOT NULL COMMENT '数量', |
||
| 1072 | UnitName varchar(30) COMMENT '単位名称', |
||
| 1073 | UnitPrice decimal(9,2) NOT NULL COMMENT '単価', |
||
| 1074 | LineTotal decimal(12,0) NOT NULL COMMENT '金額', |
||
| 1075 | note varchar(60) COMMENT '備考', |
||
| 1076 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 1077 | MyExpensesFlg decimal(1) NOT NULL COMMENT '自社経費フラグ', |
||
| 1078 | InputFlg decimal(1) COMMENT '入力フラグ', |
||
| 1079 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1080 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1081 | PRIMARY KEY (ConstructionCode, PageCount, LineCount) |
||
| 1082 | ) COMMENT = '積算見積データ明細'; |
||
| 1083 | |||
| 1084 | |||
| 1085 | -- 会社休日マスタ
|
||
| 1086 | CREATE TABLE HolidayCalenderMaster |
||
| 1087 | ( |
||
| 1088 | Holiday date NOT NULL COMMENT '休日', |
||
| 1089 | BusinessYear smallint unsigned NOT NULL COMMENT '営業年度', |
||
| 1090 | TargetMonth tinyint unsigned NOT NULL COMMENT '該当月', |
||
| 1091 | TargetDay tinyint unsigned NOT NULL COMMENT '該当日', |
||
| 1092 | PRIMARY KEY (Holiday) |
||
| 1093 | ) COMMENT = '会社休日マスタ'; |
||
| 1094 | |||
| 1095 | |||
| 1096 | -- 入力時検索履歴
|
||
| 1097 | CREATE TABLE InputSearchLogData |
||
| 1098 | ( |
||
| 1099 | ConstructionCode decimal(10,0) NOT NULL COMMENT '工事コード', |
||
| 1100 | UsedProcessNo decimal(4,0) NOT NULL COMMENT '使用機能番号', |
||
| 1101 | DisplayOrder decimal(4) unsigned NOT NULL COMMENT '表示順', |
||
| 1102 | DataType decimal(1) NOT NULL COMMENT 'データ種別', |
||
| 1103 | InputCode decimal(10) COMMENT '入力コード', |
||
| 1104 | PRIMARY KEY (ConstructionCode, UsedProcessNo, DisplayOrder) |
||
| 1105 | ) COMMENT = '入力時検索履歴'; |
||
| 1106 | |||
| 1107 | |||
| 1108 | -- 掲示板メッセージ
|
||
| 1109 | CREATE TABLE MessageBoardData |
||
| 1110 | ( |
||
| 1111 | RecordNumber decimal(6) unsigned NOT NULL COMMENT 'レコード番号', |
||
| 1112 | BranchNumber decimal(3) unsigned NOT NULL COMMENT 'レコード枝番', |
||
| 1113 | FromCode decimal(8) unsigned NOT NULL COMMENT '書込み者コード', |
||
| 1114 | FromName varchar(60) NOT NULL COMMENT '書込み者', |
||
| 1115 | MessageTitile varchar(100) COMMENT '伝言タイトル', |
||
| 1116 | MessageContent varchar(1333) NOT NULL COMMENT '伝言内容', |
||
| 1117 | LinkType decimal(2) NOT NULL COMMENT 'リンク動作タイプ', |
||
| 1118 | LinkMessage varchar(200) COMMENT 'リンク文字列', |
||
| 1119 | LinkCode varchar(30) COMMENT 'リンクキー', |
||
| 1120 | WritingDate datetime NOT NULL COMMENT '書込み日時', |
||
| 1121 | PersonCode decimal(8,0) NOT NULL COMMENT '書込み担当者コード', |
||
| 1122 | ShareFlag decimal(2) NOT NULL COMMENT '管理者対象フラグ', |
||
| 1123 | MessageColor varchar(8) COMMENT '文字色', |
||
| 1124 | BackColor varchar(8) COMMENT 'バックカラー', |
||
| 1125 | MessageFlag decimal(1) NOT NULL COMMENT 'メッセージフラグ', |
||
| 1126 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1127 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1128 | PRIMARY KEY (RecordNumber, BranchNumber) |
||
| 1129 | ) COMMENT = '掲示板メッセージ'; |
||
| 1130 | |||
| 1131 | |||
| 1132 | -- 掲示板対象者テーブル
|
||
| 1133 | CREATE TABLE MessageBoardTerget |
||
| 1134 | ( |
||
| 1135 | RecordNumber decimal(6) unsigned NOT NULL COMMENT 'レコード番号', |
||
| 1136 | BranchNumber decimal(3) unsigned NOT NULL COMMENT 'レコード枝番', |
||
| 1137 | SeqNum decimal(3) unsigned NOT NULL COMMENT '順番', |
||
| 1138 | ToCode decimal(8) NOT NULL COMMENT '対象者コード', |
||
| 1139 | ToName varchar(60) NOT NULL COMMENT '対象者', |
||
| 1140 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1141 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1142 | PRIMARY KEY (RecordNumber, BranchNumber, SeqNum) |
||
| 1143 | ) COMMENT = '掲示板対象者テーブル'; |
||
| 1144 | |||
| 1145 | |||
| 1146 | -- 掲示板メッセージ閲覧履歴
|
||
| 1147 | CREATE TABLE MessageBrowsingHistory |
||
| 1148 | ( |
||
| 1149 | RecordNumber decimal(6) unsigned NOT NULL COMMENT 'レコード番号', |
||
| 1150 | BranchNumber decimal(3) unsigned NOT NULL COMMENT 'レコード枝番', |
||
| 1151 | SeqNum decimal(3) unsigned NOT NULL COMMENT '順番', |
||
| 1152 | BrowsingCode decimal(8) NOT NULL COMMENT '閲覧者コード', |
||
| 1153 | BrowsingDate datetime NOT NULL COMMENT '閲覧日付', |
||
| 1154 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1155 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1156 | PRIMARY KEY (RecordNumber, BranchNumber, SeqNum) |
||
| 1157 | ) COMMENT = '掲示板メッセージ閲覧履歴'; |
||
| 1158 | |||
| 1159 | |||
| 1160 | 101 | h-you | -- 月マスタ
|
| 1161 | CREATE TABLE MonthMaster |
||
| 1162 | ( |
||
| 1163 | month smallint NOT NULL COMMENT '月' |
||
| 1164 | ) COMMENT = '月マスタ'; |
||
| 1165 | |||
| 1166 | |||
| 1167 | 84 | h-you | -- 発注者マスタ
|
| 1168 | CREATE TABLE OrderersMaster |
||
| 1169 | ( |
||
| 1170 | OrderCotegory decimal(5,0) unsigned NOT NULL COMMENT '発注者区分', |
||
| 1171 | OrderersCode decimal(5,0) unsigned NOT NULL COMMENT '発注者コード', |
||
| 1172 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1173 | OrderFlg decimal(1) NOT NULL COMMENT '法人団体・個人フラグ', |
||
| 1174 | CorporateStatusName varchar(100) COMMENT '法人格名称', |
||
| 1175 | CorporateStatusPoint decimal(1) COMMENT '法人格名称位置', |
||
| 1176 | OrderersName1 varchar(60) DEFAULT '' NOT NULL COMMENT '発注者名1', |
||
| 1177 | OrderersName2 varchar(60) COMMENT '発注者名２', |
||
| 1178 | DepartmentName varchar(60) COMMENT '部署名', |
||
| 1179 | ChargePersonName varchar(60) COMMENT '担当者名', |
||
| 1180 | ZipCode varchar(8) COMMENT '郵便番号', |
||
| 1181 | Address1 varchar(60) COMMENT '住所１', |
||
| 1182 | Address2 varchar(60) DEFAULT '' COMMENT '住所2', |
||
| 1183 | Address3 varchar(60) COMMENT '住所3', |
||
| 1184 | PhoneNumber varchar(13) DEFAULT '' COMMENT '電話番号', |
||
| 1185 | FaxNumber varchar(13) DEFAULT '' COMMENT 'FAX番号', |
||
| 1186 | MailAddress varchar(257) COMMENT 'メールアドレス', |
||
| 1187 | Note varchar(300) DEFAULT '' COMMENT '備考', |
||
| 1188 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 1189 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1190 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1191 | PRIMARY KEY (OrderCotegory, OrderersCode) |
||
| 1192 | ) COMMENT = '発注者マスタ'; |
||
| 1193 | |||
| 1194 | |||
| 1195 | -- 受注金額データ
|
||
| 1196 | CREATE TABLE OrdersPriceData |
||
| 1197 | ( |
||
| 1198 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1199 | ChangeNo decimal(3) unsigned NOT NULL COMMENT '変更番号', |
||
| 1200 | ChangeDate date NOT NULL COMMENT '変更日', |
||
| 1201 | ChangePersonCode decimal(8) unsigned NOT NULL COMMENT '変更者コード', |
||
| 1202 | ChangePersonName varchar(60) COMMENT '変更者名', |
||
| 1203 | BeforeValue decimal(14,0) NOT NULL COMMENT '変更前税抜受注金額', |
||
| 1204 | BeforeValueInTax decimal(14,0) NOT NULL COMMENT '変更前税込受注金額', |
||
| 1205 | AfterValue decimal(14,0) NOT NULL COMMENT '変更後税抜受注金額', |
||
| 1206 | AfterValueInTax decimal(14,0) NOT NULL COMMENT '変更後税込受注金額', |
||
| 1207 | ChangeComment varchar(200) COMMENT '変更理由', |
||
| 1208 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1209 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1210 | PRIMARY KEY (ConstructionCode, ChangeNo) |
||
| 1211 | ) COMMENT = '受注金額データ'; |
||
| 1212 | |||
| 1213 | |||
| 1214 | -- 担当者承認データ
|
||
| 1215 | CREATE TABLE PersonApproval |
||
| 1216 | ( |
||
| 1217 | PersonCode decimal(8) unsigned NOT NULL COMMENT '担当者コード', |
||
| 1218 | ApprovalCode decimal(3,0) unsigned NOT NULL COMMENT '承認機能番号', |
||
| 1219 | OrderDate date NOT NULL COMMENT '受付日', |
||
| 1220 | OrderNo decimal(2,0) unsigned NOT NULL COMMENT '受付番号', |
||
| 1221 | SeqNo decimal(2) NOT NULL COMMENT '枝番', |
||
| 1222 | PersonCodeApproval decimal(8) unsigned NOT NULL COMMENT '申請・承認者コード', |
||
| 1223 | PetitionApprovalDate datetime NOT NULL COMMENT '申請・承認日付', |
||
| 1224 | ApprovalLimitDates datetime NOT NULL COMMENT '承認希望日', |
||
| 1225 | ApprovalStatus decimal(1) NOT NULL COMMENT '承認状態', |
||
| 1226 | InputComment varchar(300) COMMENT 'コメント', |
||
| 1227 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1228 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1229 | PRIMARY KEY (PersonCode, ApprovalCode, OrderDate, OrderNo, SeqNo) |
||
| 1230 | ) COMMENT = '担当者承認データ'; |
||
| 1231 | |||
| 1232 | |||
| 1233 | -- 担当者承認コメントデータ
|
||
| 1234 | CREATE TABLE PersonApprovalComment |
||
| 1235 | ( |
||
| 1236 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 1237 | ApprovalCode decimal(3,0) unsigned NOT NULL COMMENT '承認機能番号', |
||
| 1238 | OrderDate date NOT NULL COMMENT '受付日', |
||
| 1239 | OrderNo decimal(2,0) unsigned NOT NULL COMMENT '受付番号', |
||
| 1240 | CommentNo decimal(2) NOT NULL COMMENT 'コメント番号', |
||
| 1241 | ParentNo decimal(2) NOT NULL COMMENT '親コメント番号', |
||
| 1242 | ApproValComment varchar(300) COMMENT '指示・連絡コメント', |
||
| 1243 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1244 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1245 | PRIMARY KEY (PersonCode, ApprovalCode, OrderDate, OrderNo, CommentNo) |
||
| 1246 | ) COMMENT = '担当者承認コメントデータ'; |
||
| 1247 | |||
| 1248 | |||
| 1249 | -- 担当者対象部署マスタ
|
||
| 1250 | CREATE TABLE PersonDepartmentMaster |
||
| 1251 | ( |
||
| 1252 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 1253 | DepartmentCode decimal(5,0) unsigned NOT NULL COMMENT '部署コード', |
||
| 1254 | AffiliationFlg decimal(1) NOT NULL COMMENT '所属フラグ', |
||
| 1255 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1256 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1257 | PRIMARY KEY (PersonCode, DepartmentCode) |
||
| 1258 | ) COMMENT = '担当者対象部署マスタ'; |
||
| 1259 | |||
| 1260 | |||
| 1261 | -- 担当者マスタ
|
||
| 1262 | CREATE TABLE PersonInChargeMaster |
||
| 1263 | ( |
||
| 1264 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 1265 | DisplayOrder decimal(8) unsigned NOT NULL COMMENT '表示順', |
||
| 1266 | PersonName varchar(60) DEFAULT '' NOT NULL COMMENT '担当者名', |
||
| 1267 | StartDate date NOT NULL COMMENT '使用開始年月日', |
||
| 1268 | EndDate date COMMENT '使用終了年月日', |
||
| 1269 | PassWord varchar(16) COMMENT 'パスワード', |
||
| 1270 | SecurityManagement decimal(1) NOT NULL COMMENT '機密区分', |
||
| 1271 | SecCode decimal(2,0) unsigned NOT NULL COMMENT '保護区分番号', |
||
| 1272 | MsgBackColor varchar(8) COMMENT 'メッセージ背景色', |
||
| 1273 | DisplayString varchar(20) COMMENT '表示・印刷名称', |
||
| 1274 | DepartmentCode decimal(5,0) unsigned COMMENT '部署コード', |
||
| 1275 | MonthlySalary decimal(11,0) NOT NULL COMMENT '月給金額', |
||
| 1276 | YearSalary decimal(12,0) NOT NULL COMMENT '年俸金額', |
||
| 1277 | Qualification varchar(120) COMMENT '資格入力欄', |
||
| 1278 | SealPrintName varchar(5) COMMENT '印鑑表示名', |
||
| 1279 | EmployeeClassFlg decimal(1) NOT NULL COMMENT '社員区分', |
||
| 1280 | LedgerFlg decimal(1) NOT NULL COMMENT '台帳計算対象フラグ', |
||
| 1281 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 1282 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1283 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1284 | PRIMARY KEY (PersonCode) |
||
| 1285 | ) COMMENT = '担当者マスタ'; |
||
| 1286 | |||
| 1287 | |||
| 1288 | -- 担当者給与マスタ
|
||
| 1289 | CREATE TABLE PersonSalaryMaster |
||
| 1290 | ( |
||
| 1291 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 1292 | StartDate date NOT NULL COMMENT '使用開始年月日', |
||
| 1293 | MonthlySalary decimal(11,0) NOT NULL COMMENT '月給金額', |
||
| 1294 | YearSalary decimal(12,0) NOT NULL COMMENT '年俸金額', |
||
| 1295 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1296 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1297 | PRIMARY KEY (PersonCode, StartDate) |
||
| 1298 | ) COMMENT = '担当者給与マスタ'; |
||
| 1299 | |||
| 1300 | |||
| 1301 | -- 発注者打ち合わせ議事録データ
|
||
| 1302 | CREATE TABLE ProceedingsData |
||
| 1303 | ( |
||
| 1304 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1305 | ProceedingsDataDate date NOT NULL COMMENT '議事録作成日', |
||
| 1306 | StartMeetingTime decimal(4) unsigned NOT NULL COMMENT '会議時間開始', |
||
| 1307 | EndMeetingTime decimal(4) unsigned NOT NULL COMMENT '会議時間終了', |
||
| 1308 | CreatorCode decimal(8,0) NOT NULL COMMENT '作成者コード', |
||
| 1309 | PalceFlag decimal(1) NOT NULL COMMENT '現地フラグ', |
||
| 1310 | MeetingPalce varchar(120) COMMENT '打合せ場所', |
||
| 1311 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1312 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1313 | PRIMARY KEY (ConstructionCode, ProceedingsDataDate, StartMeetingTime) |
||
| 1314 | ) COMMENT = '発注者打ち合わせ議事録データ'; |
||
| 1315 | |||
| 1316 | |||
| 1317 | -- 発注者打ち合わせ議事録データ（出席者）
|
||
| 1318 | CREATE TABLE ProceedingsDataAttend |
||
| 1319 | ( |
||
| 1320 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1321 | ProceedingsDataDate date NOT NULL COMMENT '議事録作成日', |
||
| 1322 | StartMeetingTime decimal(4) unsigned NOT NULL COMMENT '会議時間開始', |
||
| 1323 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 1324 | Department varchar(20) COMMENT '出席者所属', |
||
| 1325 | AttendName varchar(10) COMMENT '出席者氏名', |
||
| 1326 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1327 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1328 | PRIMARY KEY (ConstructionCode, ProceedingsDataDate, StartMeetingTime, SeqNo) |
||
| 1329 | ) COMMENT = '発注者打ち合わせ議事録データ（出席者）'; |
||
| 1330 | |||
| 1331 | |||
| 1332 | -- 発注者打ち合わせ議事録データ（明細）
|
||
| 1333 | CREATE TABLE ProceedingsDataDetail |
||
| 1334 | ( |
||
| 1335 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1336 | ProceedingsDataDate date NOT NULL COMMENT '議事録作成日', |
||
| 1337 | StartMeetingTime decimal(4) unsigned NOT NULL COMMENT '会議時間開始', |
||
| 1338 | SeqNo decimal(3) unsigned NOT NULL COMMENT '明細行番号', |
||
| 1339 | TitleNo varchar(5) COMMENT '議題番号', |
||
| 1340 | Title varchar(20) COMMENT '議題', |
||
| 1341 | ContentsText varchar(50) COMMENT '内容', |
||
| 1342 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1343 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1344 | PRIMARY KEY (ConstructionCode, ProceedingsDataDate, StartMeetingTime, SeqNo) |
||
| 1345 | ) COMMENT = '発注者打ち合わせ議事録データ（明細）'; |
||
| 1346 | |||
| 1347 | |||
| 1348 | -- 承認データ
|
||
| 1349 | CREATE TABLE ProcessApproval |
||
| 1350 | ( |
||
| 1351 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1352 | ApprovalCode decimal(3,0) unsigned NOT NULL COMMENT '承認機能番号', |
||
| 1353 | OrderNo decimal(2,0) unsigned NOT NULL COMMENT '受付番号', |
||
| 1354 | SeqNo decimal(2) NOT NULL COMMENT '枝番', |
||
| 1355 | PersonCode decimal(8) unsigned NOT NULL COMMENT '申請・承認者コード', |
||
| 1356 | PetitionApprovalDate datetime NOT NULL COMMENT '申請・承認日付', |
||
| 1357 | ApprovalLimitDates datetime NOT NULL COMMENT '承認希望日', |
||
| 1358 | ApprovalStatus decimal(1) NOT NULL COMMENT '承認状態', |
||
| 1359 | InputComment varchar(300) COMMENT 'コメント', |
||
| 1360 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1361 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1362 | PRIMARY KEY (ConstructionCode, ApprovalCode, OrderNo, SeqNo) |
||
| 1363 | ) COMMENT = '承認データ'; |
||
| 1364 | |||
| 1365 | |||
| 1366 | -- 承認コメントデータ
|
||
| 1367 | CREATE TABLE ProcessApprovalComment |
||
| 1368 | ( |
||
| 1369 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1370 | ApprovalCode decimal(3,0) unsigned NOT NULL COMMENT '承認機能番号', |
||
| 1371 | OrderNo decimal(2,0) unsigned NOT NULL COMMENT '受付番号', |
||
| 1372 | CommentNo decimal(2) NOT NULL COMMENT 'コメント番号', |
||
| 1373 | ParentNo decimal(2) NOT NULL COMMENT '親コメント番号', |
||
| 1374 | ApproValComment varchar(300) COMMENT '指示・連絡コメント', |
||
| 1375 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1376 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1377 | PRIMARY KEY (ConstructionCode, ApprovalCode, OrderNo, CommentNo) |
||
| 1378 | ) COMMENT = '承認コメントデータ'; |
||
| 1379 | |||
| 1380 | |||
| 1381 | -- 承認明細データ
|
||
| 1382 | CREATE TABLE ProcessApprovalDetail |
||
| 1383 | ( |
||
| 1384 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1385 | ApprovalCode decimal(3,0) unsigned NOT NULL COMMENT '承認機能番号', |
||
| 1386 | OrderNo decimal(2,0) unsigned NOT NULL COMMENT '受付番号', |
||
| 1387 | SerialNo decimal(2) unsigned NOT NULL COMMENT '枝番', |
||
| 1388 | LinkCode decimal(10) NOT NULL COMMENT 'リンク情報', |
||
| 1389 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1390 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1391 | PRIMARY KEY (ConstructionCode, ApprovalCode, OrderNo, SerialNo) |
||
| 1392 | ) COMMENT = '承認明細データ'; |
||
| 1393 | |||
| 1394 | |||
| 1395 | -- 起動対象マスタ
|
||
| 1396 | CREATE TABLE ProcessExcuteMaster |
||
| 1397 | ( |
||
| 1398 | SecCode decimal(2,0) unsigned NOT NULL COMMENT '保護区分番号', |
||
| 1399 | ExecCode decimal(4,0) unsigned NOT NULL COMMENT '起動処理番号', |
||
| 1400 | EditFlg decimal(1) NOT NULL COMMENT '編集フラグ', |
||
| 1401 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1402 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1403 | PRIMARY KEY (SecCode, ExecCode) |
||
| 1404 | ) COMMENT = '起動対象マスタ'; |
||
| 1405 | |||
| 1406 | |||
| 1407 | -- 注文書データ
|
||
| 1408 | CREATE TABLE PurchaseOrder |
||
| 1409 | ( |
||
| 1410 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1411 | SeqNo decimal(3) unsigned NOT NULL COMMENT '注文書枝番', |
||
| 1412 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 1413 | CreateDate date COMMENT '作成日付', |
||
| 1414 | OrderPrice decimal(12,0) NOT NULL COMMENT '発注金額', |
||
| 1415 | LastRowStringDate date NOT NULL COMMENT '最終行表示日付', |
||
| 1416 | OrderSheetType decimal(1) NOT NULL COMMENT '簡易・本式フラグ', |
||
| 1417 | PaymentTerms decimal(1) NOT NULL COMMENT '支払い条件', |
||
| 1418 | CashRatio decimal(4,1) NOT NULL COMMENT '現金割合（％）', |
||
| 1419 | BillPeriod decimal(4) NOT NULL COMMENT '手形期間', |
||
| 1420 | PrePayments decimal(1) NOT NULL COMMENT '前金払', |
||
| 1421 | PrePaymentsDays decimal(3,0) NOT NULL COMMENT '前金払日数', |
||
| 1422 | PrePaymentsPrice decimal(12,0) NOT NULL COMMENT '前金払金額', |
||
| 1423 | PartialPayment decimal(1) NOT NULL COMMENT '部分払', |
||
| 1424 | PartialPaymentMounth decimal(2) unsigned NOT NULL COMMENT '部分払締切月', |
||
| 1425 | PartialPaymentDay1 decimal(2) unsigned NOT NULL COMMENT '部分払締切日', |
||
| 1426 | PartialPaymentDay2 decimal(2) unsigned NOT NULL COMMENT '部分払支払日', |
||
| 1427 | PartialPaymentPrice decimal(12,0) NOT NULL COMMENT '部分払金額', |
||
| 1428 | CompletionPayment decimal(1) NOT NULL COMMENT '引渡し時の支払', |
||
| 1429 | CompletionPaymentDays decimal(3) unsigned NOT NULL COMMENT '引渡し時の支払日数', |
||
| 1430 | CompletionPaymentPrice decimal(12,0) NOT NULL COMMENT '引渡し時の支払金額', |
||
| 1431 | LeadEngineerCode decimal(8,0) COMMENT '主任技術者コード', |
||
| 1432 | LeadEngineerName varchar(60) COMMENT 'LeadEngineerName', |
||
| 1433 | SafetyOfficerCode decimal(8) COMMENT '安全管理者コード', |
||
| 1434 | SafetyOfficerName varchar(60) COMMENT '安全管理者名', |
||
| 1435 | WorkersCount decimal(3) unsigned COMMENT '作業員数', |
||
| 1436 | PrintoutDate date NOT NULL COMMENT '印刷年月日', |
||
| 1437 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1438 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1439 | PRIMARY KEY (ConstructionCode, SeqNo) |
||
| 1440 | ) COMMENT = '注文書データ'; |
||
| 1441 | |||
| 1442 | |||
| 1443 | -- 注文書明細データ
|
||
| 1444 | CREATE TABLE PurchaseOrderDetail |
||
| 1445 | ( |
||
| 1446 | ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード', |
||
| 1447 | SeqNo decimal(3) unsigned NOT NULL COMMENT '注文書枝番', |
||
| 1448 | GroupCount decimal(1) NOT NULL COMMENT 'グループ番号', |
||
| 1449 | LineCount decimal(3) unsigned NOT NULL COMMENT '行番号', |
||
| 1450 | ComponentCode decimal(5,0) unsigned NOT NULL COMMENT '構成キー', |
||
| 1451 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 1452 | FirstString varchar(120) COMMENT '工種・品名', |
||
| 1453 | SecondString varchar(120) COMMENT '内容内訳', |
||
| 1454 | UnitCount decimal(8,2) NOT NULL COMMENT '数量', |
||
| 1455 | UnitName varchar(30) COMMENT '単位', |
||
| 1456 | UnitPrice decimal(10,0) NOT NULL COMMENT '単価', |
||
| 1457 | OrdersLinePrice decimal(12,0) COMMENT '金額', |
||
| 1458 | SourceCode decimal(10) unsigned NOT NULL COMMENT '予算作成時工事番号', |
||
| 1459 | 97 | h-you | SourceLineCnt decimal(3) unsigned NOT NULL COMMENT '注文書作成時台帳行番号', |
| 1460 | 84 | h-you | EntryDate datetime NOT NULL COMMENT '登録日付', |
| 1461 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1462 | PRIMARY KEY (ConstructionCode, SeqNo, GroupCount, LineCount) |
||
| 1463 | ) COMMENT = '注文書明細データ'; |
||
| 1464 | |||
| 1465 | |||
| 1466 | -- 売上グラフデータ
|
||
| 1467 | CREATE TABLE SalesGraphData |
||
| 1468 | ( |
||
| 1469 | GraphDataCode decimal(8) NOT NULL COMMENT 'グラフデータコード', |
||
| 1470 | ConstructionPeriod decimal(4) unsigned NOT NULL COMMENT '事業期', |
||
| 1471 | SalesDataDays date NOT NULL COMMENT '売上年月', |
||
| 1472 | DisplayOrder decimal(8) unsigned NOT NULL COMMENT '表示順', |
||
| 1473 | DataName varchar(100) NOT NULL COMMENT 'データ表示名称', |
||
| 1474 | SalesAmount decimal(10,0) NOT NULL COMMENT '売上データ', |
||
| 1475 | AdministrativeExpense decimal(10,0) NOT NULL COMMENT '販管・部署経費', |
||
| 1476 | GrossProfit decimal(10,0) NOT NULL COMMENT '粗利益', |
||
| 1477 | NetIncome decimal(10,0) NOT NULL COMMENT '純利益(損益)', |
||
| 1478 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1479 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1480 | PRIMARY KEY (GraphDataCode, ConstructionPeriod, SalesDataDays) |
||
| 1481 | ) COMMENT = '売上グラフデータ'; |
||
| 1482 | |||
| 1483 | |||
| 1484 | -- 保護区分マスタ
|
||
| 1485 | CREATE TABLE SecurityMaster |
||
| 1486 | ( |
||
| 1487 | SecCode decimal(2,0) unsigned NOT NULL COMMENT '保護区分番号', |
||
| 1488 | DisplayOrder decimal(2) NOT NULL COMMENT '表示順', |
||
| 1489 | SecName varchar(60) NOT NULL COMMENT '保護区分名称', |
||
| 1490 | SecRank decimal(1) NOT NULL COMMENT '保護区分ランク', |
||
| 1491 | SecRange decimal(1) NOT NULL COMMENT '保護区分範囲', |
||
| 1492 | GeneralAffairs decimal(1) NOT NULL COMMENT '総務業務フラグ', |
||
| 1493 | SelectBackColor varchar(8) NOT NULL COMMENT '選択背景色', |
||
| 1494 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1495 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1496 | PRIMARY KEY (SecCode) |
||
| 1497 | ) COMMENT = '保護区分マスタ'; |
||
| 1498 | |||
| 1499 | |||
| 1500 | -- 協力業者施工工種登録申請データ
|
||
| 1501 | CREATE TABLE SubConstrJobItemRegist |
||
| 1502 | ( |
||
| 1503 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '申請者番号', |
||
| 1504 | CreateDate date NOT NULL COMMENT '作成日', |
||
| 1505 | SeqNo decimal(2) unsigned NOT NULL COMMENT '申請連番', |
||
| 1506 | DisplayOrder decimal(8) unsigned NOT NULL COMMENT '表示順', |
||
| 1507 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 1508 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1509 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1510 | PRIMARY KEY (PersonCode, CreateDate, SeqNo, DisplayOrder) |
||
| 1511 | ) COMMENT = '協力業者施工工種登録申請データ'; |
||
| 1512 | |||
| 1513 | |||
| 1514 | -- 協力業者職種リンク登録申請データ
|
||
| 1515 | CREATE TABLE SubConstrJobLinkRegist |
||
| 1516 | ( |
||
| 1517 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '申請者番号', |
||
| 1518 | CreateDate date NOT NULL COMMENT '作成日', |
||
| 1519 | SeqNo decimal(2) unsigned NOT NULL COMMENT '申請連番', |
||
| 1520 | DisplayOrder decimal(8) unsigned NOT NULL COMMENT '表示順', |
||
| 1521 | JobCategoryCode decimal(5,0) NOT NULL COMMENT '職種キー', |
||
| 1522 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1523 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1524 | PRIMARY KEY (PersonCode, CreateDate, SeqNo, DisplayOrder) |
||
| 1525 | ) COMMENT = '協力業者職種リンク登録申請データ'; |
||
| 1526 | |||
| 1527 | |||
| 1528 | -- 協力業者登録申請データ
|
||
| 1529 | CREATE TABLE SubConstrRegist |
||
| 1530 | ( |
||
| 1531 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '申請者番号', |
||
| 1532 | CreateDate date NOT NULL COMMENT '作成日', |
||
| 1533 | SeqNo decimal(2) unsigned NOT NULL COMMENT '申請連番', |
||
| 1534 | DataMode decimal(1) COMMENT 'データ区分', |
||
| 1535 | SourceCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 1536 | PetitionPeriod decimal(4) unsigned NOT NULL COMMENT '申請年度', |
||
| 1537 | CorporateStatusName varchar(40) DEFAULT '' COMMENT '法人格名称', |
||
| 1538 | CorporateStatusPoint decimal(1) NOT NULL COMMENT '法人格名称位置', |
||
| 1539 | CompanyName varchar(100) DEFAULT '' NOT NULL COMMENT '協力会社名', |
||
| 1540 | CEOPositionName varchar(60) DEFAULT '' COMMENT '代表者役職名', |
||
| 1541 | CEOName varchar(60) DEFAULT '' COMMENT '代表者氏名', |
||
| 1542 | ContactPersonName varchar(60) COMMENT '担当者氏名', |
||
| 1543 | ZipCode varchar(8) COMMENT '郵便番号', |
||
| 1544 | Address1 varchar(60) COMMENT '住所１', |
||
| 1545 | Address2 varchar(60) DEFAULT '' COMMENT '住所2', |
||
| 1546 | Address3 varchar(60) COMMENT '住所3', |
||
| 1547 | CellPhoneNumber varchar(13) COMMENT '携帯電話番号', |
||
| 1548 | MailAddress varchar(257) COMMENT 'メールアドレス', |
||
| 1549 | PhoneNumber varchar(13) DEFAULT '' COMMENT '電話番号', |
||
| 1550 | FaxNumber varchar(13) DEFAULT '' COMMENT 'FAX番号', |
||
| 1551 | JapaneseSyllabary varchar(2) COMMENT '50音読み', |
||
| 1552 | StartDate date NOT NULL COMMENT '取引開始年月日', |
||
| 1553 | Note varchar(300) DEFAULT '' COMMENT '備考', |
||
| 1554 | labourKind decimal(1) NOT NULL COMMENT '支払い通常・手間区分', |
||
| 1555 | OrderDate date COMMENT '申請日', |
||
| 1556 | OrderNo decimal(2) unsigned NOT NULL COMMENT '申請受付番号', |
||
| 1557 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1558 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1559 | PRIMARY KEY (PersonCode, CreateDate, SeqNo) |
||
| 1560 | ) COMMENT = '協力業者登録申請データ'; |
||
| 1561 | |||
| 1562 | |||
| 1563 | -- 協力会社工種マスタ
|
||
| 1564 | CREATE TABLE SubContractorItemMaster |
||
| 1565 | ( |
||
| 1566 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 1567 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1568 | ItemName varchar(120) DEFAULT '' NOT NULL COMMENT '工種名称', |
||
| 1569 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 1570 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1571 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1572 | PRIMARY KEY (ItemCode) |
||
| 1573 | ) COMMENT = '協力会社工種マスタ'; |
||
| 1574 | |||
| 1575 | |||
| 1576 | -- 協力会社職種マスタ
|
||
| 1577 | CREATE TABLE SubContractorJobCategory |
||
| 1578 | ( |
||
| 1579 | JobCategoryCode decimal(5,0) NOT NULL COMMENT '職種キー', |
||
| 1580 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1581 | JobCategoryName varchar(120) DEFAULT '' NOT NULL COMMENT '職種名称', |
||
| 1582 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 1583 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1584 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1585 | PRIMARY KEY (JobCategoryCode) |
||
| 1586 | ) COMMENT = '協力会社職種マスタ'; |
||
| 1587 | |||
| 1588 | |||
| 1589 | -- 協力会社施工工種データ
|
||
| 1590 | CREATE TABLE SubContractorJobItem |
||
| 1591 | ( |
||
| 1592 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 1593 | ItemCode decimal(5,0) unsigned NOT NULL COMMENT '工種キー', |
||
| 1594 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1595 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1596 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1597 | PRIMARY KEY (CompanyCode, ItemCode) |
||
| 1598 | ) COMMENT = '協力会社施工工種データ'; |
||
| 1599 | |||
| 1600 | |||
| 1601 | -- 協力会社職種リンクマスタ
|
||
| 1602 | CREATE TABLE SubContractorJobLink |
||
| 1603 | ( |
||
| 1604 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 1605 | JobCategoryCode decimal(5,0) NOT NULL COMMENT '職種キー', |
||
| 1606 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1607 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1608 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1609 | PRIMARY KEY (CompanyCode, JobCategoryCode) |
||
| 1610 | ) COMMENT = '協力会社職種リンクマスタ'; |
||
| 1611 | |||
| 1612 | |||
| 1613 | -- 協力会社マスタ
|
||
| 1614 | CREATE TABLE SubContractorMaster |
||
| 1615 | ( |
||
| 1616 | CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード', |
||
| 1617 | DisplayOrder decimal(8) unsigned NOT NULL COMMENT '表示順', |
||
| 1618 | CorporateStatusName varchar(40) DEFAULT '' COMMENT '法人格名称', |
||
| 1619 | CorporateStatusPoint decimal(1) NOT NULL COMMENT '法人格名称位置', |
||
| 1620 | CompanyName varchar(100) DEFAULT '' NOT NULL COMMENT '協力会社名', |
||
| 1621 | CEOPositionName varchar(60) DEFAULT '' COMMENT '代表者役職名', |
||
| 1622 | CEOName varchar(60) DEFAULT '' COMMENT '代表者氏名', |
||
| 1623 | ContactPersonName varchar(60) COMMENT '担当者氏名', |
||
| 1624 | ZipCode varchar(8) COMMENT '郵便番号', |
||
| 1625 | Address1 varchar(60) COMMENT '住所１', |
||
| 1626 | Address2 varchar(60) DEFAULT '' COMMENT '住所2', |
||
| 1627 | Address3 varchar(60) COMMENT '住所3', |
||
| 1628 | CellPhoneNumber varchar(13) COMMENT '携帯電話番号', |
||
| 1629 | MailAddress varchar(257) COMMENT 'メールアドレス', |
||
| 1630 | PhoneNumber varchar(13) DEFAULT '' COMMENT '電話番号', |
||
| 1631 | FaxNumber varchar(13) DEFAULT '' COMMENT 'FAX番号', |
||
| 1632 | JapaneseSyllabary varchar(2) COMMENT '50音読み', |
||
| 1633 | StartDate date NOT NULL COMMENT '取引開始年月日', |
||
| 1634 | Note varchar(300) DEFAULT '' COMMENT '備考', |
||
| 1635 | labourKind decimal(1) NOT NULL COMMENT '支払い通常・手間区分', |
||
| 1636 | DeleteFlg decimal(1) DEFAULT 0 NOT NULL COMMENT '削除フラグ', |
||
| 1637 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1638 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1639 | PRIMARY KEY (CompanyCode) |
||
| 1640 | ) COMMENT = '協力会社マスタ'; |
||
| 1641 | |||
| 1642 | |||
| 1643 | -- 仕入先マスタ
|
||
| 1644 | CREATE TABLE SuppliersMaster |
||
| 1645 | ( |
||
| 1646 | SuppliersCode decimal(5,0) unsigned NOT NULL COMMENT '仕入先コード', |
||
| 1647 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1648 | SuppliersName1 varchar(60) DEFAULT '' NOT NULL COMMENT '仕入先名1', |
||
| 1649 | SuppliersName2 varchar(60) COMMENT '仕入先名２', |
||
| 1650 | ZipCode varchar(8) COMMENT '郵便番号', |
||
| 1651 | Address1 varchar(60) COMMENT '住所１', |
||
| 1652 | Address2 varchar(60) DEFAULT '' COMMENT '住所2', |
||
| 1653 | Address3 varchar(60) COMMENT '住所3', |
||
| 1654 | PhoneNumber varchar(13) DEFAULT '' COMMENT '電話番号', |
||
| 1655 | FaxNumber varchar(13) DEFAULT '' COMMENT 'FAX番号', |
||
| 1656 | Note varchar(300) DEFAULT '' COMMENT '備考', |
||
| 1657 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 1658 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1659 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1660 | PRIMARY KEY (SuppliersCode) |
||
| 1661 | ) COMMENT = '仕入先マスタ'; |
||
| 1662 | |||
| 1663 | |||
| 1664 | -- システム起動確認データ
|
||
| 1665 | CREATE TABLE SystemExecute |
||
| 1666 | ( |
||
| 1667 | PrimaryCode tinyint NOT NULL COMMENT 'キー項目', |
||
| 1668 | TargetDate date NOT NULL COMMENT '起動日付', |
||
| 1669 | SystemVersion int NOT NULL COMMENT '本体・環境バージョン', |
||
| 1670 | UpDateCopyVersion int NOT NULL COMMENT 'コピーバージョン', |
||
| 1671 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1672 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1673 | PRIMARY KEY (PrimaryCode) |
||
| 1674 | ) COMMENT = 'システム起動確認データ'; |
||
| 1675 | |||
| 1676 | |||
| 1677 | -- 管理マスタ
|
||
| 1678 | CREATE TABLE SystemMaster |
||
| 1679 | ( |
||
| 1680 | SystemCode decimal(3,0) unsigned NOT NULL COMMENT '会社コード', |
||
| 1681 | CompanyName1 varchar(60) DEFAULT '' NOT NULL COMMENT '会社名１', |
||
| 1682 | CompanyName2 varchar(60) DEFAULT '' COMMENT '会社名２', |
||
| 1683 | CEOName varchar(60) DEFAULT '' NOT NULL COMMENT '代表者氏名', |
||
| 1684 | CEOPositionName varchar(60) DEFAULT '' COMMENT '代表者役職名', |
||
| 1685 | ZipCode varchar(8) NOT NULL COMMENT '郵便番号', |
||
| 1686 | Address1 varchar(60) NOT NULL COMMENT '住所１', |
||
| 1687 | Address2 varchar(60) DEFAULT '' COMMENT '住所2', |
||
| 1688 | Address3 varchar(60) COMMENT '住所3', |
||
| 1689 | PhoneNumber varchar(13) DEFAULT '' NOT NULL COMMENT '電話番号', |
||
| 1690 | FaxNumber varchar(13) DEFAULT '' COMMENT 'FAX番号', |
||
| 1691 | ConstructionExpenses decimal(4,2) NOT NULL COMMENT '工事部経費', |
||
| 1692 | OfficeExpenses decimal(4,2) NOT NULL COMMENT '事務所経費', |
||
| 1693 | OperatingExpenses decimal(4,2) NOT NULL COMMENT '営業経費', |
||
| 1694 | ConsumptionTax decimal(4,2) NOT NULL COMMENT '消費税', |
||
| 1695 | CooperationRate decimal(4,2) NOT NULL COMMENT '協力金比率', |
||
| 1696 | ExcelSavePath varchar(120) COMMENT 'Excel保存パス', |
||
| 1697 | BusinessPeriod smallint NOT NULL COMMENT '現在営業期数', |
||
| 1698 | ConstructionYear smallint NOT NULL COMMENT '現在工事年度', |
||
| 1699 | BusinessBeginningDate varchar(5) NOT NULL COMMENT '営業期期首日', |
||
| 1700 | ConstructionBeginningDate varchar(5) NOT NULL COMMENT '工事年度期首日', |
||
| 1701 | ConstructionNoBase decimal(1) NOT NULL COMMENT '工事番号基準値', |
||
| 1702 | SloganString1 varchar(100) COMMENT '標語1', |
||
| 1703 | SloganString2 varchar(100) COMMENT '標語2', |
||
| 1704 | SloganString3 varchar(100) COMMENT '標語3', |
||
| 1705 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1706 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1707 | PRIMARY KEY (SystemCode) |
||
| 1708 | ) COMMENT = '管理マスタ'; |
||
| 1709 | |||
| 1710 | |||
| 1711 | -- 期限マスタ
|
||
| 1712 | CREATE TABLE TermMaster |
||
| 1713 | ( |
||
| 1714 | ConstructionStatusFlg decimal(2,0) NOT NULL COMMENT '工事状態フラグ', |
||
| 1715 | FieldNo decimal(2) NOT NULL COMMENT 'チェック対象フィールド番号', |
||
| 1716 | SeqNo decimal(2) NOT NULL COMMENT '枝番', |
||
| 1717 | DisplayOrder decimal(2) NOT NULL COMMENT '表示順', |
||
| 1718 | CheckSchdule decimal(1) NOT NULL COMMENT 'チェックタイミング', |
||
| 1719 | TermDays decimal(3) NOT NULL COMMENT '経過日', |
||
| 1720 | SendTitile varchar(100) COMMENT 'タイトル', |
||
| 1721 | SendMessage varchar(100) COMMENT 'メッセージ', |
||
| 1722 | BackColor varchar(8) COMMENT '背景色', |
||
| 1723 | ForeColor varchar(8) COMMENT '文字色', |
||
| 1724 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1725 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1726 | PRIMARY KEY (ConstructionStatusFlg, FieldNo, SeqNo) |
||
| 1727 | ) COMMENT = '期限マスタ'; |
||
| 1728 | |||
| 1729 | |||
| 1730 | -- 出勤交通費データ
|
||
| 1731 | CREATE TABLE TranceportDailyData |
||
| 1732 | ( |
||
| 1733 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '作成者コード', |
||
| 1734 | AttendanceDate date NOT NULL COMMENT '日報作成日', |
||
| 1735 | StartDistance decimal(7,1) NOT NULL COMMENT '当日出発キロ数', |
||
| 1736 | ComplateDistance decimal(7,1) NOT NULL COMMENT '当日終了キロ数', |
||
| 1737 | TotalDistance decimal(6,1) NOT NULL COMMENT '当日合計キロ数', |
||
| 1738 | OfficeGoFlg decimal(1) NOT NULL COMMENT '事務所出勤フラグ', |
||
| 1739 | OfficeOutFlg decimal(1) NOT NULL COMMENT '事務所帰宅フラグ', |
||
| 1740 | TrancePayGoFlg decimal(1) NOT NULL COMMENT '有料通勤出勤フラグ', |
||
| 1741 | TrancePayOutFlg decimal(1) NOT NULL COMMENT '有料通勤帰宅フラグ', |
||
| 1742 | WareHouseFlg decimal(1) NOT NULL COMMENT '資材置場フラグ', |
||
| 1743 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1744 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1745 | PRIMARY KEY (PersonCode, AttendanceDate) |
||
| 1746 | ) COMMENT = '出勤交通費データ'; |
||
| 1747 | |||
| 1748 | |||
| 1749 | -- 工事種別経費率マスタ
|
||
| 1750 | CREATE TABLE TypeExpensesMaster |
||
| 1751 | ( |
||
| 1752 | TypeCode decimal(5,0) unsigned NOT NULL COMMENT '工事種別コード', |
||
| 1753 | ExpensesPeriod smallint NOT NULL COMMENT '事業期', |
||
| 1754 | NameCode decimal(5,0) unsigned NOT NULL COMMENT '経費名称コード', |
||
| 1755 | ExpensesRaito decimal(4,2) NOT NULL COMMENT '経費率', |
||
| 1756 | DeleteFlg decimal(1) NOT NULL COMMENT '削除フラグ', |
||
| 1757 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1758 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1759 | PRIMARY KEY (TypeCode, ExpensesPeriod, NameCode) |
||
| 1760 | ) COMMENT = '工事種別経費率マスタ'; |
||
| 1761 | |||
| 1762 | |||
| 1763 | -- 単位マスタ
|
||
| 1764 | CREATE TABLE UnitMaster |
||
| 1765 | ( |
||
| 1766 | UnitKey decimal(5,0) unsigned NOT NULL COMMENT '単位キー', |
||
| 1767 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1768 | UnitName varchar(30) NOT NULL COMMENT '単位名称', |
||
| 1769 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1770 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1771 | PRIMARY KEY (UnitKey) |
||
| 1772 | ) COMMENT = '単位マスタ'; |
||
| 1773 | |||
| 1774 | |||
| 1775 | -- 車両マスタ
|
||
| 1776 | CREATE TABLE VehicleMaster |
||
| 1777 | ( |
||
| 1778 | VehicleCode decimal(5,0) unsigned NOT NULL COMMENT '車両コード', |
||
| 1779 | DisplayOrder decimal(5) unsigned NOT NULL COMMENT '表示順', |
||
| 1780 | VehicleName varchar(100) NOT NULL COMMENT '車両名称', |
||
| 1781 | RegistrationNumber varchar(30) COMMENT '登録番号', |
||
| 1782 | IdentificationNumber varchar(30) COMMENT '車体番号', |
||
| 1783 | ModelCode varchar(30) COMMENT '型式', |
||
| 1784 | DepartmentCode decimal(5) unsigned NOT NULL COMMENT '管理部署', |
||
| 1785 | VehicleScheduleFlg decimal(1) NOT NULL COMMENT '車両予約表示フラグ', |
||
| 1786 | PurchaseDate date COMMENT '購入日', |
||
| 1787 | PurchaseName varchar(30) COMMENT '購入先', |
||
| 1788 | PurchaseContactPersons varchar(30) COMMENT '購入先担当者', |
||
| 1789 | PurchasePhone varchar(13) COMMENT '購入先電話番号', |
||
| 1790 | LeaseDate date COMMENT 'リース開始日', |
||
| 1791 | LeaseDestination varchar(30) COMMENT 'リース先', |
||
| 1792 | LeaseContactPersons varchar(30) COMMENT 'リース先担当者', |
||
| 1793 | LeasePhone varchar(13) COMMENT 'リース先電話番号', |
||
| 1794 | InsuranceCompany varchar(30) COMMENT '任意保険会社', |
||
| 1795 | InsuranceContactPersons varchar(30) COMMENT '任意保険会社担当者', |
||
| 1796 | InsurancePhone varchar(13) COMMENT '任意保険会社電話番号', |
||
| 1797 | Note varchar(300) COMMENT '備考', |
||
| 1798 | EntryDate datetime COMMENT '登録日付', |
||
| 1799 | UpdateDate datetime COMMENT '更新日付', |
||
| 1800 | PRIMARY KEY (VehicleCode) |
||
| 1801 | ) COMMENT = '車両マスタ'; |
||
| 1802 | |||
| 1803 | |||
| 1804 | -- 車両記録データ
|
||
| 1805 | CREATE TABLE VehicleRecordData |
||
| 1806 | ( |
||
| 1807 | VehicleCode decimal(5,0) unsigned NOT NULL COMMENT '車両コード', |
||
| 1808 | DivisionCode decimal(2,0) unsigned NOT NULL COMMENT 'データ区分', |
||
| 1809 | SeqNo decimal(2) NOT NULL COMMENT '枝番', |
||
| 1810 | RecordDate date COMMENT '実地日', |
||
| 1811 | Mileage mediumint COMMENT '走行距離', |
||
| 1812 | Content varchar(100) COMMENT '内容', |
||
| 1813 | PaymentCost decimal(10,0) COMMENT '費用', |
||
| 1814 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1815 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1816 | PRIMARY KEY (VehicleCode, DivisionCode, SeqNo) |
||
| 1817 | ) COMMENT = '車両記録データ'; |
||
| 1818 | |||
| 1819 | |||
| 1820 | -- 車両予約データ
|
||
| 1821 | CREATE TABLE VehicleScheduleData |
||
| 1822 | ( |
||
| 1823 | TargetDate date NOT NULL COMMENT '対象日', |
||
| 1824 | VehicleCode decimal(5,0) unsigned NOT NULL COMMENT '車両コード', |
||
| 1825 | MorningAfternoon decimal(1) NOT NULL COMMENT '午前・午後', |
||
| 1826 | PersonCode decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', |
||
| 1827 | TargetYear year(4) NOT NULL COMMENT '該当年', |
||
| 1828 | TargetMonth tinyint unsigned NOT NULL COMMENT '該当月', |
||
| 1829 | TargetDay year(2) NOT NULL COMMENT '該当日', |
||
| 1830 | EntryDate datetime NOT NULL COMMENT '登録日付', |
||
| 1831 | UpdateDate datetime NOT NULL COMMENT '更新日付', |
||
| 1832 | PRIMARY KEY (TargetDate, VehicleCode, MorningAfternoon) |
||
| 1833 | ) COMMENT = '車両予約データ'; |
||
| 1834 | |||
| 1835 | |||
| 1836 | 101 | h-you | -- 年マスタ
|
| 1837 | CREATE TABLE YearMaster |
||
| 1838 | ( |
||
| 1839 | years smallint NOT NULL COMMENT '年' |
||
| 1840 | ) COMMENT = '年マスタ'; |
||
| 1841 | 84 | h-you | |
| 1842 | 101 | h-you | |
| 1843 | |||
| 1844 | 84 | h-you | /* Create Indexes */
|
| 1845 | |||
| 1846 | CREATE INDEX ActionScheduleData_Index1 ON ActionScheduleData (TargetYear ASC); |
||
| 1847 | CREATE INDEX ActionScheduleData_Index2 ON ActionScheduleData (TargetMonth ASC); |
||
| 1848 | CREATE INDEX ActionScheduleData_Index3 ON ActionScheduleData (TargetDay ASC); |
||
| 1849 | CREATE INDEX AttendDaily_Index1 ON AttendanceDailyData (ActionResult ASC); |
||
| 1850 | CREATE INDEX AttendDaily_Index2 ON AttendanceDailyData (AttendanceDate ASC); |
||
| 1851 | CREATE INDEX BusinessTypeMaster_Index1 ON BusinessTypeMaster (DisplayOrder ASC); |
||
| 1852 | CREATE INDEX ComponentLinkMaster_Index1 ON ComponentLinkMaster (ComponentCode ASC); |
||
| 1853 | CREATE INDEX ComponentLinkMaster_Index2 ON ComponentLinkMaster (ItemCode ASC); |
||
| 1854 | CREATE INDEX ComponentMaster_Index1 ON ComponentMaster (DisplayOrder ASC); |
||
| 1855 | CREATE INDEX ComponentToTypeMaster_Index1 ON ComponentToTypeMaster (ComponentCode ASC); |
||
| 1856 | CREATE INDEX ComponentToTypeMaster_Index2 ON ComponentToTypeMaster (TypeCode ASC); |
||
| 1857 | CREATE INDEX BaseInfo_Index1 ON ConstructionBaseInfo (ConstructionStatusFlg ASC); |
||
| 1858 | CREATE INDEX BaseInfo_Index2 ON ConstructionBaseInfo (EstimateType ASC); |
||
| 1859 | CREATE INDEX BaseInfo_Index3 ON ConstructionBaseInfo (SalesPersonCode ASC); |
||
| 1860 | CREATE INDEX BaseInfo_Index4 ON ConstructionBaseInfo (ConstructionPersonCode ASC); |
||
| 1861 | CREATE INDEX BaseInfo_Index5 ON ConstructionBaseInfo (ConstructionInstructor ASC); |
||
| 1862 | CREATE INDEX BaseInfoDetail_Idx1 ON ConstructionBaseInfoDetail (ConstructionCode ASC); |
||
| 1863 | CREATE INDEX BaseInfoDetail_Idx2 ON ConstructionBaseInfoDetail (DetailNo ASC); |
||
| 1864 | CREATE INDEX LedgerDetail_Index01 ON ConstructionLedgerDetail (ConstructionCode ASC); |
||
| 1865 | CREATE INDEX LedgerDetail_Index02 ON ConstructionLedgerDetail (GroupCount ASC); |
||
| 1866 | CREATE INDEX LedgerDetail_Index03 ON ConstructionLedgerDetail (SourceCode ASC); |
||
| 1867 | CREATE INDEX LedgerExcute_Index1 ON ConstructionLedgerExcute (ConstructionCode ASC, TargetMonth ASC, GroupCount ASC, LineCount ASC); |
||
| 1868 | CREATE INDEX ConstructionLink_Index1 ON ConstructionLink (ConstructionCode ASC); |
||
| 1869 | CREATE INDEX ConstructionLink_Index2 ON ConstructionLink (FluctuationCode ASC); |
||
| 1870 | CREATE INDEX ConstructionLink_Index3 ON ConstructionLink (LinkType ASC); |
||
| 1871 | CREATE INDEX ConstructionSpecMaster_Index1 ON ConstructionSpecMaster (DisplayOrder ASC); |
||
| 1872 | CREATE INDEX CostDataOfPerson_Index1 ON CostDataOfPerson (TargetMonth ASC); |
||
| 1873 | CREATE INDEX CostDataOfPerson_Index2 ON CostDataOfPerson (ConstructionCode ASC); |
||
| 1874 | CREATE INDEX CostomerRegist_Index1 ON CostomerRegist (PetitionPeriod ASC); |
||
| 1875 | CREATE INDEX DailyDataConstruction_Index1 ON DailyDataConstruction (PersonCode ASC); |
||
| 1876 | CREATE INDEX DailyDataConstruction_Index2 ON DailyDataConstruction (DailyDataDate ASC); |
||
| 1877 | CREATE INDEX DailyDataConstruction_Index3 ON DailyDataConstruction (ConstructionCode ASC); |
||
| 1878 | CREATE INDEX DailyDataDetail_Index ON DailyDataDetail (PersonCode ASC, DailyDataDate ASC, ConstructionCode ASC); |
||
| 1879 | CREATE INDEX DailyDataField_Index ON DailyDataField (PersonCode ASC, DailyDataDate ASC, ConstructionCode ASC); |
||
| 1880 | CREATE INDEX DailyDataMaterials_Index ON DailyDataMaterials (PersonCode ASC, DailyDataDate ASC, ConstructionCode ASC); |
||
| 1881 | CREATE INDEX DailyDataSubcontractors_Index ON DailyDataSubcontractors (PersonCode ASC, DailyDataDate ASC, ConstructionCode ASC); |
||
| 1882 | CREATE INDEX DailyDataVehicles_Index ON DailyDataVehicles (PersonCode ASC, DailyDataDate ASC, ConstructionCode ASC); |
||
| 1883 | CREATE INDEX DepartmentMaster_index1 ON DepartmentMaster (DisplayOrder ASC); |
||
| 1884 | CREATE INDEX EstimateData_Index1 ON EstimateData (ConstructionCode ASC, FixedItemCode ASC); |
||
| 1885 | CREATE INDEX EstimateDataBody_Index1 ON EstimateDataBody (ConstructionCode ASC, ComponentCode ASC, ItemCode ASC); |
||
| 1886 | CREATE INDEX EstimateDataDetail_Index1 ON EstimateDataDetail (ConstructionCode ASC, PageCount ASC); |
||
| 1887 | CREATE INDEX HolidayCalender_Index1 ON HolidayCalenderMaster (BusinessYear ASC); |
||
| 1888 | CREATE INDEX HolidayCalenderMaster_Index2 ON HolidayCalenderMaster (TargetMonth ASC); |
||
| 1889 | CREATE INDEX HolidayCalenderMaster_Index3 ON HolidayCalenderMaster (TargetDay ASC); |
||
| 1890 | CREATE INDEX InputSearchLogData_Index1 ON InputSearchLogData (ConstructionCode ASC, UsedProcessNo ASC, InputCode ASC); |
||
| 1891 | CREATE INDEX MessageBoardData_Index1 ON MessageBoardData (WritingDate ASC); |
||
| 1892 | CREATE INDEX MessageBoardData_Index2 ON MessageBoardData (MessageFlag ASC); |
||
| 1893 | CREATE INDEX MessageBoardTerget_Index1 ON MessageBoardTerget (RecordNumber ASC, BranchNumber ASC); |
||
| 1894 | CREATE INDEX PersonDepartmentMaster_Index1 ON PersonDepartmentMaster (PersonCode ASC); |
||
| 1895 | CREATE INDEX PersonDepartmentMaster_Index2 ON PersonDepartmentMaster (DepartmentCode ASC); |
||
| 1896 | CREATE INDEX PersonInChargeMaster_Index1 ON PersonInChargeMaster (StartDate ASC); |
||
| 1897 | CREATE INDEX PersonInChargeMaster_Index2 ON PersonInChargeMaster (DepartmentCode ASC); |
||
| 1898 | CREATE INDEX PersonSalaryMaster_Index1 ON PersonSalaryMaster (PersonCode ASC); |
||
| 1899 | CREATE INDEX PersonSalaryMaster_Index2 ON PersonSalaryMaster (StartDate ASC); |
||
| 1900 | CREATE INDEX ProcessExcuteMaster_Index1 ON ProcessExcuteMaster (SecCode ASC); |
||
| 1901 | CREATE INDEX ProcessExcuteMaster_Index2 ON ProcessExcuteMaster (ExecCode ASC); |
||
| 1902 | CREATE INDEX POrderDetail_Index1 ON PurchaseOrderDetail (SourceCode ASC); |
||
| 1903 | CREATE INDEX SalesGraphData_Idx1 ON SalesGraphData (DisplayOrder ASC); |
||
| 1904 | CREATE INDEX SalesGraphData_idx2 ON SalesGraphData (ConstructionPeriod ASC); |
||
| 1905 | CREATE INDEX SecurityMaster_Index1 ON SecurityMaster (DisplayOrder ASC); |
||
| 1906 | CREATE INDEX SecurityMaster_Index2 ON SecurityMaster (SecRank ASC); |
||
| 1907 | CREATE INDEX SecurityMaster_Index3 ON SecurityMaster (SecRange ASC); |
||
| 1908 | CREATE INDEX SubContractorJobItem_Index1 ON SubContractorJobItem (CompanyCode ASC); |
||
| 1909 | CREATE INDEX SubContractorJobItem_Index2 ON SubContractorJobItem (ItemCode ASC); |
||
| 1910 | CREATE INDEX SubContractorJobLink_Index1 ON SubContractorJobLink (CompanyCode ASC); |
||
| 1911 | CREATE INDEX SubContractorJobLink_Index2 ON SubContractorJobLink (JobCategoryCode ASC); |
||
| 1912 | CREATE INDEX SubContractorMaster_Index1 ON SubContractorMaster (JapaneseSyllabary ASC); |
||
| 1913 | CREATE INDEX TermMaster_Index1 ON TermMaster (DisplayOrder ASC); |
||
| 1914 | CREATE INDEX TranceportDailyData_Index1 ON TranceportDailyData (AttendanceDate ASC); |
||
| 1915 | CREATE INDEX UnitMaster_Index1 ON UnitMaster (DisplayOrder ASC); |
||
| 1916 | CREATE INDEX VehicleScheduleData_Index1 ON VehicleScheduleData (TargetYear ASC); |
||
| 1917 | CREATE INDEX VehicleScheduleData_Index2 ON VehicleScheduleData (TargetMonth ASC); |
||
| 1918 | CREATE INDEX VehicleScheduleData_Index3 ON VehicleScheduleData (TargetDay ASC); |
||
| 1919 | |||
| 1920 | |||
| 1921 | 106 | bit | -- 資材管理、請求管理関係のテーブル作成
|
| 1922 | 84 | h-you | |
| 1923 | 106 | bit | -- 銀行営業日マスタ
|
| 1924 | drop table if exists bankbusinessdaymaster cascade; |
||
| 1925 | |||
| 1926 | create table bankbusinessdaymaster ( |
||
| 1927 | YEARMONTH decimal(6,0) default '0' not null comment '年月' |
||
| 1928 | , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '銀行営業日' |
||
| 1929 | , NOTE varchar(120) comment '備考' |
||
| 1930 | , DELETEFLG decimal(1,0) comment '削除フラグ' |
||
| 1931 | , ENTRYDATE datetime comment '登録年月日' |
||
| 1932 | , UPDATEDATE datetime comment '更新年月日' |
||
| 1933 | , constraint bankbusinessdaymaster_PKC primary key (YEARMONTH,BANKBUSINESSDAY) |
||
| 1934 | ) comment '銀行営業日マスタ' ; |
||
| 1935 | |||
| 1936 | -- 業者請求データ
|
||
| 1937 | drop table if exists billingdata cascade; |
||
| 1938 | |||
| 1939 | create table billingdata ( |
||
| 1940 | COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード' |
||
| 1941 | , TARGETDATE decimal(6,0) default '0' not null comment '対象年月' |
||
| 1942 | , SEQNO decimal(3,0) default '0' not null comment '連番' |
||
| 1943 | , BILLPRICE decimal(10,0) comment '請求金額' |
||
| 1944 | , ENTRYDATE datetime comment '登録年月日' |
||
| 1945 | , UPDATEDATE datetime comment '更新年月日' |
||
| 1946 | , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO) |
||
| 1947 | ) comment '業者請求データ' ; |
||
| 1948 | |||
| 1949 | -- 業者請求明細データ
|
||
| 1950 | drop table if exists billingdatadetail cascade; |
||
| 1951 | |||
| 1952 | create table billingdatadetail ( |
||
| 1953 | COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード' |
||
| 1954 | , TARGETDATE decimal(6,0) default '0' not null comment '対象年月' |
||
| 1955 | , SEQNO decimal(3,0) default '0' not null comment '連番' |
||
| 1956 | , LINECOUNT decimal(3,0) default '0' not null comment '行番号' |
||
| 1957 | , CONSTRUCTIONCODE decimal(10,0) comment '工事番号' |
||
| 1958 | , FIELDNAME varchar(120) comment '現場名' |
||
| 1959 | , BILLPRICE decimal(10,0) comment '請求金額' |
||
| 1960 | , HIGHWPRICE decimal(10,0) comment '高速代' |
||
| 1961 | , HARDWPRICE decimal(10,0) comment '金物代' |
||
| 1962 | , INDSWASTETAX decimal(10,0) comment '産廃税' |
||
| 1963 | , NOTE varchar(120) comment '備考' |
||
| 1964 | , ENTRYDATE datetime comment '登録年月日' |
||
| 1965 | , UPDATEDATE datetime comment '更新年月日' |
||
| 1966 | , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT) |
||
| 1967 | ) comment '業者請求明細データ' ; |
||
| 1968 | |||
| 1969 | -- 業者請求支払サマリーデータ
|
||
| 1970 | drop table if exists billingpaymentsummary cascade; |
||
| 1971 | |||
| 1972 | create table billingpaymentsummary ( |
||
| 1973 | COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード' |
||
| 1974 | , TARGETDATE decimal(6,0) default '0' not null comment '対象年月' |
||
| 1975 | , CHARGEPAYMENTKIND decimal(1,0) default '0' not null comment '請求支払区分' |
||
| 1976 | , PAYDAY date comment '支払日' |
||
| 1977 | , BILLPRICESTOTAL decimal(10,0) comment '請求金額小計' |
||
| 1978 | , CONSUMPTIONTAXRATE decimal(6,3) comment '消費税率' |
||
| 1979 | , CONSUMPTIONTAXPRICE decimal(10,0) comment '消費税額' |
||
| 1980 | , HIGHWPRICESTOTAL decimal(10,0) comment '高速代小計' |
||
| 1981 | , HARDWPRICESTOTAL decimal(10,0) comment '金物代小計' |
||
| 1982 | , INDSWASTETAXSTOTAL decimal(10,0) comment '産廃税小計' |
||
| 1983 | , CNSTRPRICERATE decimal(6,3) comment '協力金比率' |
||
| 1984 | , CNSTRPRICESTOTAL decimal(10,0) comment '協力金小計' |
||
| 1985 | , BILLINGPRICETOTAL decimal(10,0) comment '請求金額合計' |
||
| 1986 | , ENTRYDATE datetime comment '登録年月日' |
||
| 1987 | , UPDATEDATE datetime comment '更新年月日' |
||
| 1988 | , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND) |
||
| 1989 | ) comment '業者請求支払サマリーデータ' ; |
||
| 1990 | |||
| 1991 | -- 工事資材情報
|
||
| 1992 | drop table if exists constructionmaterialinfo cascade; |
||
| 1993 | |||
| 1994 | create table constructionmaterialinfo ( |
||
| 1995 | CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '工事番号' |
||
| 1996 | , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '資材品目コード' |
||
| 1997 | , RENTCOUNT smallint(5) unsigned comment '貸出数' |
||
| 1998 | , REPAYCOUNT smallint(5) unsigned comment '返却数' |
||
| 1999 | , COMPLETEFLG tinyint(3) unsigned comment '完了フラグ' |
||
| 2000 | , ENTRYDATE datetime comment '登録日付' |
||
| 2001 | , UPDATEDATE datetime comment '更新日付' |
||
| 2002 | , constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE) |
||
| 2003 | ) comment '工事資材情報' ; |
||
| 2004 | |||
| 2005 | -- 締日マスタ
|
||
| 2006 | drop table if exists deadlinemaster cascade; |
||
| 2007 | |||
| 2008 | create table deadlinemaster ( |
||
| 2009 | LABOURKIND decimal(1,0) default '0' not null comment '手間業者区分' |
||
| 2010 | , DEADLINE decimal(2,0) comment '締日' |
||
| 2011 | , PAYDAY decimal(2,0) comment '支払日' |
||
| 2012 | , NOTE varchar(120) comment '備考' |
||
| 2013 | , DELETEFLG decimal(1,0) comment '削除フラグ' |
||
| 2014 | , ENTRYDATE datetime comment '登録日付' |
||
| 2015 | , UPDATEDATE datetime comment '更新日付' |
||
| 2016 | , constraint deadlinemaster_PKC primary key (LABOURKIND) |
||
| 2017 | ) comment '締日マスタ' ; |
||
| 2018 | |||
| 2019 | -- 入金確認承認データ
|
||
| 2020 | drop table if exists depositapprovalinfo cascade; |
||
| 2021 | |||
| 2022 | create table depositapprovalinfo ( |
||
| 2023 | ORDERERSDIVISION decimal(5,0) not null comment '発注者区分' |
||
| 2024 | , ORDERERSCODE decimal(5,0) not null comment '発注者コード' |
||
| 2025 | , TARGETDATE decimal(6,0) not null comment '対象年月' |
||
| 2026 | , SEQNO decimal(3,0) not null comment '連番' |
||
| 2027 | , LINECOUNT decimal(3,0) not null comment '行番号' |
||
| 2028 | , APPROVALNO decimal(3,0) not null comment '承認順序' |
||
| 2029 | , APPROVALPERSON decimal(8,0) comment '承認者コード' |
||
| 2030 | , APPROVALPERSONNAME varchar(20) comment '承認者名' |
||
| 2031 | , APPROVALAUTHORITY decimal(1,0) comment '承認権限区分' |
||
| 2032 | , APPROVALDATE date comment '承認日付' |
||
| 2033 | , ENTRYDATE datetime comment '登録日付' |
||
| 2034 | , UPDATEDATE datetime comment '更新日付' |
||
| 2035 | , constraint depositapprovalinfo_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO) |
||
| 2036 | ) comment '入金確認承認データ' ; |
||
| 2037 | |||
| 2038 | -- 入金データ
|
||
| 2039 | drop table if exists depositdata cascade; |
||
| 2040 | |||
| 2041 | create table depositdata ( |
||
| 2042 | ORDERERSDIVISION decimal(5,0) not null comment '発注者区分' |
||
| 2043 | , ORDERERSCODE decimal(5,0) not null comment '発注者コード' |
||
| 2044 | , TARGETDATE decimal(6,0) not null comment '対象年月' |
||
| 2045 | , SEQNO decimal(3,0) not null comment '連番' |
||
| 2046 | , BusinessPeriod decimal(4,0) comment '営業期' |
||
| 2047 | , DEPOSITDATE date comment '入金日' |
||
| 2048 | , DepositAmount decimal(12,0) comment '入金金額' |
||
| 2049 | , DEPOSITAMOUNTCASH decimal(10,0) comment '入金金額（現金）' |
||
| 2050 | , DEPOSITAMOUNTBILL decimal(10,0) comment '入金金額（手形）' |
||
| 2051 | , ENTRYDATE datetime comment '登録日付' |
||
| 2052 | , UPDATEDATE datetime comment '更新日付' |
||
| 2053 | , constraint depositdata_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO) |
||
| 2054 | ) comment '入金データ' ; |
||
| 2055 | |||
| 2056 | -- 入金明細データ
|
||
| 2057 | drop table if exists depositdatadetail cascade; |
||
| 2058 | |||
| 2059 | create table depositdatadetail ( |
||
| 2060 | ORDERERSDIVISION decimal(5,0) not null comment '発注者区分' |
||
| 2061 | , ORDERERSCODE decimal(5,0) not null comment '発注者コード' |
||
| 2062 | , TARGETDATE decimal(6,0) not null comment '対象年月' |
||
| 2063 | , SEQNO decimal(3,0) not null comment '連番' |
||
| 2064 | , LINECOUNT decimal(3,0) not null comment '行番号' |
||
| 2065 | , REQUESTNO decimal(10,0) comment '請求No' |
||
| 2066 | , ORDERNO decimal(2,0) comment '受付番号' |
||
| 2067 | , DEPOSITAMOUNT decimal(10,0) comment '入金金額' |
||
| 2068 | , DISCOUNTAMOUNT decimal(10,0) comment '値引き金額' |
||
| 2069 | , CNSTRPRICE decimal(10,0) comment '協力金' |
||
| 2070 | , FEES decimal(10,0) comment '手数料' |
||
| 2071 | , OTHERADJUSTMENTS decimal(10,0) comment 'その他調整' |
||
| 2072 | , CARRYAMOUNT decimal(10,0) comment '繰越金額' |
||
| 2073 | , APPROVALPERSONCODE decimal(8,0) comment '承認担当者コード' |
||
| 2074 | , APPROVALDATE date comment '担当者承認日付' |
||
| 2075 | , APPROVALENDFLG decimal(1,0) comment '承認完了フラグ' |
||
| 2076 | , ENTRYDATE datetime comment '登録日付' |
||
| 2077 | , UPDATEDATE datetime comment '更新日付' |
||
| 2078 | , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT) |
||
| 2079 | ) comment '入金明細データ' ; |
||
| 2080 | |||
| 2081 | -- 請求書データ
|
||
| 2082 | drop table if exists invoicedata cascade; |
||
| 2083 | |||
| 2084 | create table invoicedata ( |
||
| 2085 | INVOICENO decimal(9,0) not null comment '請求書No' |
||
| 2086 | , ORDERERSDIVISION decimal(5,0) not null comment '発注者区分' |
||
| 2087 | , ORDERERSCODE decimal(5,0) not null comment '発注者コード' |
||
| 2088 | , REQUESTMONTH decimal(6,0) not null comment '請求月' |
||
| 2089 | , SEQNO decimal(2,0) not null comment '連番' |
||
| 2090 | , CRETATEDATE date not null comment '作成日' |
||
| 2091 | , REQUESTDATE date not null comment '請求日' |
||
| 2092 | , REQUESTNAME varchar(120) comment '請求先名' |
||
| 2093 | , TOTALAMOUNT decimal(10,0) comment '税込み合計金額' |
||
| 2094 | , TAXAMOUNT decimal(10,0) comment '消費税金額' |
||
| 2095 | , COMMENT1 varchar(60) comment 'コメント1' |
||
| 2096 | , COMMENT2 varchar(60) comment 'コメント2' |
||
| 2097 | , COMMENT3 varchar(60) not null comment 'コメント3' |
||
| 2098 | , COMMENT4 varchar(60) not null comment 'コメント4' |
||
| 2099 | , COMMENT5 varchar(60) not null comment 'コメント5' |
||
| 2100 | , COMPLETEFLG decimal(1,0) default '0' not null comment '完了フラグ' |
||
| 2101 | , ENTRYDATE datetime not null comment '登録年月日' |
||
| 2102 | , UPDATEDATE datetime not null comment '更新年月日' |
||
| 2103 | , constraint invoicedata_PKC primary key (INVOICENO) |
||
| 2104 | ) comment '請求書データ' ; |
||
| 2105 | |||
| 2106 | alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ; |
||
| 2107 | |||
| 2108 | -- 資材情報
|
||
| 2109 | drop table if exists materialinfo cascade; |
||
| 2110 | |||
| 2111 | create table materialinfo ( |
||
| 2112 | MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '資材品目コード' |
||
| 2113 | , MATERIALCOUNT smallint(5) unsigned comment '資材数' |
||
| 2114 | , RENTCOUNT smallint(5) unsigned comment '貸出可能数' |
||
| 2115 | , DELETEFLG smallint(5) unsigned comment '削除フラグ' |
||
| 2116 | , ENTRYDATE datetime comment '登録日付' |
||
| 2117 | , UPDATEDATE datetime comment '更新日付' |
||
| 2118 | , constraint materialinfo_PKC primary key (MATERIALITEMCODE) |
||
| 2119 | ) comment '資材情報' ; |
||
| 2120 | |||
| 2121 | -- 資材品目マスタ
|
||
| 2122 | drop table if exists materialitemmaster cascade; |
||
| 2123 | |||
| 2124 | create table materialitemmaster ( |
||
| 2125 | MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '資材品目コード' |
||
| 2126 | , MATERIALKINDCODE smallint(5) unsigned comment '資材種類コード' |
||
| 2127 | , MATERIALITEMNAME varchar(40) comment '資材品目名称' |
||
| 2128 | , DISPLAYORDER smallint(5) unsigned comment '表示順' |
||
| 2129 | , DELETEFLG tinyint(3) unsigned comment '削除フラグ' |
||
| 2130 | , ENTRYDATE datetime comment '登録日付' |
||
| 2131 | , UPDATEDATE datetime comment '更新日付' |
||
| 2132 | , VERSIONNO decimal(8,0) not null default 0 comment 'バージョン番号' |
||
| 2133 | , constraint materialitemmaster_PKC primary key (MATERIALITEMCODE) |
||
| 2134 | ) comment '資材品目マスタ' ; |
||
| 2135 | |||
| 2136 | -- 資材種類マスタ
|
||
| 2137 | drop table if exists materialkindmaster cascade; |
||
| 2138 | |||
| 2139 | create table materialkindmaster ( |
||
| 2140 | MATERIALKINDCODE smallint(5) unsigned default 0 not null comment '資材種類コード' |
||
| 2141 | , MATERIALKINDNAME varchar(40) comment '資材種類名称' |
||
| 2142 | , DISPLAYORDER smallint(5) unsigned comment '表示順' |
||
| 2143 | , DELETEFLG tinyint(3) unsigned comment '削除フラグ' |
||
| 2144 | , ENTRYDATE datetime comment '登録日付' |
||
| 2145 | , UPDATEDATE datetime comment '更新日付' |
||
| 2146 | , constraint materialkindmaster_PKC primary key (MATERIALKINDCODE) |
||
| 2147 | ) comment '資材種類マスタ' ; |
||
| 2148 | |||
| 2149 | -- 資材履歴情報
|
||
| 2150 | drop table if exists materialrecordinfo cascade; |
||
| 2151 | |||
| 2152 | create table materialrecordinfo ( |
||
| 2153 | MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '資材品目コード' |
||
| 2154 | , PROCESSDATE date default '0000-00-00' not null comment '処理年月日' |
||
| 2155 | , SEQNO smallint(5) unsigned default 0 not null comment '連番' |
||
| 2156 | , RECKIND tinyint(3) unsigned comment 'レコード区分' |
||
| 2157 | , CONSTRUCTIONCODE int(10) unsigned comment '工事番号' |
||
| 2158 | , PERSONCODE int(10) unsigned comment '担当者コード' |
||
| 2159 | , MATERIALCOUNT smallint(5) unsigned comment '資材数' |
||
| 2160 | , REPAYPLANDATE date comment '返却予定年月日' |
||
| 2161 | , COMMENTTEXT varchar(80) comment 'コメント' |
||
| 2162 | , ENTRYDATE datetime comment '登録日付' |
||
| 2163 | , UPDATEDATE datetime comment '更新日付' |
||
| 2164 | , constraint materialrecordinfo_PKC primary key (MATERIALITEMCODE,PROCESSDATE,SEQNO) |
||
| 2165 | ) comment '資材履歴情報' ; |
||
| 2166 | |||
| 2167 | -- 支払承認情報データ
|
||
| 2168 | drop table if exists paymentapprovalinfo cascade; |
||
| 2169 | |||
| 2170 | create table paymentapprovalinfo ( |
||
| 2171 | COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード' |
||
| 2172 | , TARGETDATE decimal(6,0) default '0' not null comment '対象年月' |
||
| 2173 | , SEQNO decimal(3,0) default '0' not null comment '連番' |
||
| 2174 | , LINECOUNT decimal(3,0) default '0' not null comment '行番号' |
||
| 2175 | , APPROVALNO decimal(3,0) default '0' not null comment '承認順序' |
||
| 2176 | , APPROVALPERSON decimal(8,0) comment '承認者コード' |
||
| 2177 | , APPROVALPERSONNAME varchar(20) comment '承認者名' |
||
| 2178 | , APPROVALAUTHORITY decimal(1,0) comment '承認権限区分' |
||
| 2179 | , APPROVALDATE date comment '承認日付' |
||
| 2180 | , ENTRYDATE datetime comment '登録日付' |
||
| 2181 | , UPDATEDATE datetime comment '更新日付' |
||
| 2182 | , constraint paymentapprovalinfo_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO) |
||
| 2183 | ) comment '支払承認情報データ' ; |
||
| 2184 | |||
| 2185 | -- 支払明細データ
|
||
| 2186 | drop table if exists paymentdatadetail cascade; |
||
| 2187 | |||
| 2188 | create table paymentdatadetail ( |
||
| 2189 | COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード' |
||
| 2190 | , TARGETDATE decimal(6,0) default '0' not null comment '対象年月' |
||
| 2191 | , SEQNO decimal(3,0) default '0' not null comment '連番' |
||
| 2192 | , LINECOUNT decimal(3,0) default '0' not null comment '行番号' |
||
| 2193 | , BILLPRICE decimal(10,0) comment '請求金額' |
||
| 2194 | , DISCOUNTPRICE decimal(10,0) comment '値引き金額' |
||
| 2195 | , OFFSETPRICE decimal(10,0) comment '相殺金額' |
||
| 2196 | , NEXTCOPRICE decimal(10,0) comment '次回繰越' |
||
| 2197 | , HIGHWPRICE decimal(10,0) comment '高速代' |
||
| 2198 | , HARDWPRICE decimal(10,0) comment '金物代' |
||
| 2199 | , INDSWASTETAX decimal(10,0) comment '産廃税' |
||
| 2200 | , CNSTRPRICE decimal(10,0) comment '協力金' |
||
| 2201 | , CNSTRPRICEEXIST decimal(1,0) comment '協力金有無' |
||
| 2202 | , APPROVALPERSONCODE decimal(8,0) comment '承認担当者コード' |
||
| 2203 | , APPROVALDATE date comment '担当者承認日付' |
||
| 2204 | , APPROVALENDFLG decimal(1,0) comment '承認完了フラグ' |
||
| 2205 | , ENTRYDATE datetime comment '登録日付' |
||
| 2206 | , UPDATEDATE datetime comment '更新日付' |
||
| 2207 | , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT) |
||
| 2208 | ) comment '支払明細データ' ; |
||
| 2209 | |||
| 2210 | -- 請求データ
|
||
| 2211 | drop table if exists requestdata cascade; |
||
| 2212 | |||
| 2213 | create table requestdata ( |
||
| 2214 | REQUESTNO decimal(9,0) not null comment '請求No' |
||
| 2215 | , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '本工事番号' |
||
| 2216 | , CONSTRUCTIONNAME varchar(120) not null comment '工事件名' |
||
| 2217 | , CONTRACTAMOUNT decimal(10,0) not null comment '請負金額' |
||
| 2218 | , PAIDAMOUNT decimal(10,0) not null comment '請求済金額' |
||
| 2219 | , REQUESTAMOUNT0 decimal(10,0) not null comment '請求金額０' |
||
| 2220 | , REQUESTAMOUNT1 decimal(10,0) not null comment '請求金額１' |
||
| 2221 | , REQUESTAMOUNT2 decimal(10,0) comment '請求金額２' |
||
| 2222 | , REQUESTAMOUNT3 decimal(10,0) comment '請求金額３' |
||
| 2223 | , REQUESTAMOUNT4 decimal(10,0) comment '請求金額４' |
||
| 2224 | , REQUESTAMOUNT5 decimal(10,0) comment '請求金額５' |
||
| 2225 | , REQUESTAMOUNT6 decimal(10,0) comment '請求金額６' |
||
| 2226 | , UNCLAIMEDAMOUNT decimal(10,0) not null comment '請求残金額' |
||
| 2227 | , UNPAIDAMOUNT decimal(10,0) not null comment '未入金金額' |
||
| 2228 | , TAXAMOUNT decimal(10,0) not null comment '消費税' |
||
| 2229 | , NOTE varchar(120) not null comment '備考' |
||
| 2230 | , ENTRYDATE datetime not null comment '登録年月日' |
||
| 2231 | , UPDATEDATE datetime not null comment '更新年月日' |
||
| 2232 | , constraint requestdata_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE) |
||
| 2233 | ) comment '請求データ' ; |
||
| 2234 | |||
| 2235 | -- 請求データ明細
|
||
| 2236 | drop table if exists requestdatadetail cascade; |
||
| 2237 | |||
| 2238 | create table requestdatadetail ( |
||
| 2239 | REQUESTNO decimal(9,0) not null comment '請求No' |
||
| 2240 | , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '本工事番号' |
||
| 2241 | , CONSTRUCTIONCODE decimal(10,0) not null comment '工事番号' |
||
| 2242 | , CONSTRUCTIONKIND decimal(1,0) not null comment '工事区分' |
||
| 2243 | , REQUESTAMOUNT decimal(10,0) not null comment '請求金額' |
||
| 2244 | , TAXAMOUNT decimal(10,0) not null comment '消費税' |
||
| 2245 | , ENTRYDATE datetime not null comment '登録年月日' |
||
| 2246 | , UPDATEDATE datetime not null comment '更新年月日' |
||
| 2247 | , constraint requestdatadetail_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE,CONSTRUCTIONCODE,CONSTRUCTIONKIND) |
||
| 2248 | ) comment '請求データ明細' ; |
||
| 2249 | |||
| 2250 | -- 請求ヘッダ
|
||
| 2251 | drop table if exists requesthead cascade; |
||
| 2252 | |||
| 2253 | create table requesthead ( |
||
| 2254 | REQUESTNO decimal(9,0) not null comment '請求No' |
||
| 2255 | , REQCONSTRUCTIONCODE decimal(10,0) not null comment '請求工事番号' |
||
| 2256 | , ORDERNO decimal(2,0) not null comment '受付番号' |
||
| 2257 | , REQUESTMONTH decimal(6,0) not null comment '請求月' |
||
| 2258 | , ORDERERSDIVISION decimal(5,0) not null comment '発注者区分' |
||
| 2259 | , ORDERERSCODE decimal(5,0) not null comment '発注者コード' |
||
| 2260 | , ORDERERSNAME varchar(120) not null comment '発注者先名' |
||
| 2261 | , REQCONSTRUCTIONNAME varchar(120) not null comment '請求工事件名' |
||
| 2262 | , REQUESTTOTALAMOUNT decimal(10,0) not null comment '請求金額合計' |
||
| 2263 | , REQUESTAMOUNT decimal(10,0) not null comment '請求金額' |
||
| 2264 | , TAXAMOUNT decimal(10,0) not null comment '消費税' |
||
| 2265 | , UNPAIDAMOUNT decimal(10,0) comment '未入金' |
||
| 2266 | , NOTE varchar(120) comment '備考' |
||
| 2267 | , ASSIGNEDFLG decimal(1,0) comment '割当済フラグ' |
||
| 2268 | , INVOICENO decimal(9,0) not null comment '請求書No' |
||
| 2269 | , ENTRYDATE datetime not null comment '登録年月日' |
||
| 2270 | , UPDATEDATE datetime not null comment '更新年月日' |
||
| 2271 | , constraint requesthead_PKC primary key (REQUESTNO) |
||
| 2272 | ) comment '請求ヘッダ' ; |
||
| 2273 | |||
| 2274 | alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ; |
||
| 2275 | |||
| 2276 | |||
| 2277 | 109 | bit | -- データ投入
|
| 2278 | -- 銀行営業日マスタ
|
||
| 2279 | LOCK TABLES `bankbusinessdaymaster` WRITE; |
||
| 2280 | /*!40000 ALTER TABLE `bankbusinessdaymaster` DISABLE KEYS */;
|
||
| 2281 | 119 | bit | INSERT INTO `bankbusinessdaymaster` VALUES (201611,2,NULL,0,NULL,NULL),(201611,4,NULL,0,NULL,NULL),(201611,7,NULL,0,NULL,NULL),(201611,8,NULL,0,NULL,NULL),(201611,9,NULL,0,NULL,NULL),(201611,10,NULL,0,NULL,NULL),(201611,11,NULL,0,NULL,NULL),(201611,14,NULL,0,NULL,NULL),(201611,15,NULL,0,NULL,NULL),(201611,16,NULL,0,NULL,NULL),(201611,17,NULL,0,NULL,NULL),(201611,18,NULL,0,NULL,NULL),(201611,21,NULL,0,NULL,NULL),(201611,22,NULL,0,NULL,NULL),(201611,24,NULL,0,NULL,NULL),(201611,25,NULL,0,NULL,NULL),(201611,28,NULL,0,NULL,NULL),(201611,29,NULL,0,NULL,NULL),(201611,30,NULL,0,NULL,NULL),(201612,1,NULL,0,NULL,NULL),(201612,2,NULL,0,NULL,NULL),(201612,5,NULL,0,NULL,NULL),(201612,6,NULL,0,NULL,NULL),(201612,7,NULL,0,NULL,NULL),(201612,8,NULL,0,NULL,NULL),(201612,9,NULL,0,NULL,NULL),(201612,12,NULL,0,NULL,NULL),(201612,13,NULL,0,NULL,NULL),(201612,14,NULL,0,NULL,NULL),(201612,15,NULL,0,NULL,NULL),(201612,16,NULL,0,NULL,NULL),(201612,19,NULL,0,NULL,NULL),(201612,20,NULL,0,NULL,NULL),(201612,21,NULL,0,NULL,NULL),(201612,22,NULL,0,NULL,NULL),(201612,26,NULL,0,NULL,NULL),(201612,27,NULL,0,NULL,NULL),(201612,28,NULL,0,NULL,NULL),(201612,29,NULL,0,NULL,NULL),(201612,30,NULL,0,NULL,NULL),(201701,4,NULL,0,NULL,NULL),(201701,5,NULL,0,NULL,NULL),(201701,6,NULL,0,NULL,NULL),(201701,10,NULL,0,NULL,NULL),(201701,11,NULL,0,NULL,NULL),(201701,12,NULL,0,NULL,NULL),(201701,13,NULL,0,NULL,NULL),(201701,16,NULL,0,NULL,NULL),(201701,17,NULL,0,NULL,NULL),(201701,18,NULL,0,NULL,NULL),(201701,19,NULL,0,NULL,NULL),(201701,20,NULL,0,NULL,NULL),(201701,23,NULL,0,NULL,NULL),(201701,24,NULL,0,NULL,NULL),(201701,25,NULL,0,NULL,NULL),(201701,26,NULL,0,NULL,NULL),(201701,27,NULL,0,NULL,NULL),(201701,30,NULL,0,NULL,NULL),(201701,31,NULL,0,NULL,NULL),(201702,1,NULL,0,NULL,NULL),(201702,2,NULL,0,NULL,NULL),(201702,3,NULL,0,NULL,NULL),(201702,6,NULL,0,NULL,NULL),(201702,7,NULL,0,NULL,NULL),(201702,8,NULL,0,NULL,NULL),(201702,9,NULL,0,NULL,NULL),(201702,10,NULL,0,NULL,NULL),(201702,13,NULL,0,NULL,NULL),(201702,14,NULL,0,NULL,NULL),(201702,15,NULL,0,NULL,NULL),(201702,16,NULL,0,NULL,NULL),(201702,17,NULL,0,NULL,NULL),(201702,20,NULL,0,NULL,NULL),(201702,21,NULL,0,NULL,NULL),(201702,22,NULL,0,NULL,NULL),(201702,23,NULL,0,NULL,NULL),(201702,24,NULL,0,NULL,NULL),(201702,27,NULL,0,NULL,NULL),(201702,28,NULL,0,NULL,NULL),(201703,1,NULL,0,NULL,NULL),(201703,2,NULL,0,NULL,NULL),(201703,3,NULL,0,NULL,NULL),(201703,6,NULL,0,NULL,NULL),(201703,7,NULL,0,NULL,NULL),(201703,8,NULL,0,NULL,NULL),(201703,9,NULL,0,NULL,NULL),(201703,10,NULL,0,NULL,NULL),(201703,13,NULL,0,NULL,NULL),(201703,14,NULL,0,NULL,NULL),(201703,15,NULL,0,NULL,NULL),(201703,16,NULL,0,NULL,NULL),(201703,17,NULL,0,NULL,NULL),(201703,21,NULL,0,NULL,NULL),(201703,22,NULL,0,NULL,NULL),(201703,23,NULL,0,NULL,NULL),(201703,24,NULL,0,NULL,NULL),(201703,27,NULL,0,NULL,NULL),(201703,28,NULL,0,NULL,NULL),(201703,29,NULL,0,NULL,NULL),(201703,30,NULL,0,NULL,NULL),(201703,31,NULL,0,NULL,NULL),(201704,3,NULL,0,NULL,NULL),(201704,4,NULL,0,NULL,NULL),(201704,5,NULL,0,NULL,NULL),(201704,6,NULL,0,NULL,NULL),(201704,7,NULL,0,NULL,NULL),(201704,10,NULL,0,NULL,NULL),(201704,11,NULL,0,NULL,NULL),(201704,12,NULL,0,NULL,NULL),(201704,13,NULL,0,NULL,NULL),(201704,14,NULL,0,NULL,NULL),(201704,17,NULL,0,NULL,NULL),(201704,18,NULL,0,NULL,NULL),(201704,19,NULL,0,NULL,NULL),(201704,20,NULL,0,NULL,NULL),(201704,21,NULL,0,NULL,NULL),(201704,24,NULL,0,NULL,NULL),(201704,25,NULL,0,NULL,NULL),(201704,26,NULL,0,NULL,NULL),(201704,27,NULL,0,NULL,NULL),(201704,28,NULL,0,NULL,NULL),(201705,1,NULL,0,NULL,NULL),(201705,2,NULL,0,NULL,NULL),(201705,8,NULL,0,NULL,NULL),(201705,9,NULL,0,NULL,NULL),(201705,10,NULL,0,NULL,NULL),(201705,11,NULL,0,NULL,NULL),(201705,12,NULL,0,NULL,NULL),(201705,15,NULL,0,NULL,NULL),(201705,16,NULL,0,NULL,NULL),(201705,17,NULL,0,NULL,NULL),(201705,18,NULL,0,NULL,NULL),(201705,19,NULL,0,NULL,NULL),(201705,22,NULL,0,NULL,NULL),(201705,23,NULL,0,NULL,NULL),(201705,24,NULL,0,NULL,NULL),(201705,25,NULL,0,NULL,NULL),(201705,26,NULL,0,NULL,NULL),(201705,29,NULL,0,NULL,NULL),(201705,30,NULL,0,NULL,NULL),(201705,31,NULL,0,NULL,NULL),(201706,1,NULL,0,NULL,NULL),(201706,2,NULL,0,NULL,NULL),(201706,5,NULL,0,NULL,NULL),(201706,6,NULL,0,NULL,NULL),(201706,7,NULL,0,NULL,NULL),(201706,8,NULL,0,NULL,NULL),(201706,9,NULL,0,NULL,NULL),(201706,12,NULL,0,NULL,NULL),(201706,13,NULL,0,NULL,NULL),(201706,14,NULL,0,NULL,NULL),(201706,15,NULL,0,NULL,NULL),(201706,16,NULL,0,NULL,NULL),(201706,19,NULL,0,NULL,NULL),(201706,20,NULL,0,NULL,NULL),(201706,21,NULL,0,NULL,NULL),(201706,22,NULL,0,NULL,NULL),(201706,23,NULL,0,NULL,NULL),(201706,26,NULL,0,NULL,NULL),(201706,27,NULL,0,NULL,NULL),(201706,28,NULL,0,NULL,NULL),(201706,29,NULL,0,NULL,NULL),(201706,30,NULL,0,NULL,NULL),(201707,3,NULL,0,NULL,NULL),(201707,4,NULL,0,NULL,NULL),(201707,5,NULL,0,NULL,NULL),(201707,6,NULL,0,NULL,NULL),(201707,7,NULL,0,NULL,NULL),(201707,10,NULL,0,NULL,NULL),(201707,11,NULL,0,NULL,NULL),(201707,12,NULL,0,NULL,NULL),(201707,13,NULL,0,NULL,NULL),(201707,14,NULL,0,NULL,NULL),(201707,18,NULL,0,NULL,NULL),(201707,19,NULL,0,NULL,NULL),(201707,20,NULL,0,NULL,NULL),(201707,21,NULL,0,NULL,NULL),(201707,24,NULL,0,NULL,NULL),(201707,25,NULL,0,NULL,NULL),(201707,26,NULL,0,NULL,NULL),(201707,27,NULL,0,NULL,NULL),(201707,28,NULL,0,NULL,NULL),(201707,31,NULL,0,NULL,NULL),(201708,1,NULL,0,NULL,NULL),(201708,2,NULL,0,NULL,NULL),(201708,3,NULL,0,NULL,NULL),(201708,4,NULL,0,NULL,NULL),(201708,7,NULL,0,NULL,NULL),(201708,8,NULL,0,NULL,NULL),(201708,9,NULL,0,NULL,NULL),(201708,10,NULL,0,NULL,NULL),(201708,14,NULL,0,NULL,NULL),(201708,15,NULL,0,NULL,NULL),(201708,16,NULL,0,NULL,NULL),(201708,17,NULL,0,NULL,NULL),(201708,18,NULL,0,NULL,NULL),(201708,21,NULL,0,NULL,NULL),(201708,22,NULL,0,NULL,NULL),(201708,23,NULL,0,NULL,NULL),(201708,24,NULL,0,NULL,NULL),(201708,25,NULL,0,NULL,NULL),(201708,28,NULL,0,NULL,NULL),(201708,29,NULL,0,NULL,NULL),(201708,30,NULL,0,NULL,NULL),(201708,31,NULL,0,NULL,NULL),(201709,1,NULL,0,NULL,NULL),(201709,4,NULL,0,NULL,NULL),(201709,5,NULL,0,NULL,NULL),(201709,6,NULL,0,NULL,NULL),(201709,7,NULL,0,NULL,NULL),(201709,8,NULL,0,NULL,NULL),(201709,11,NULL,0,NULL,NULL),(201709,12,NULL,0,NULL,NULL),(201709,13,NULL,0,NULL,NULL),(201709,14,NULL,0,NULL,NULL),(201709,15,NULL,0,NULL,NULL),(201709,19,NULL,0,NULL,NULL),(201709,20,NULL,0,NULL,NULL),(201709,21,NULL,0,NULL,NULL),(201709,22,NULL,0,NULL,NULL),(201709,25,NULL,0,NULL,NULL),(201709,26,NULL,0,NULL,NULL),(201709,27,NULL,0,NULL,NULL),(201709,28,NULL,0,NULL,NULL),(201709,29,NULL,0,NULL,NULL),(201710,2,NULL,0,NULL,NULL),(201710,3,NULL,0,NULL,NULL),(201710,4,NULL,0,NULL,NULL),(201710,5,NULL,0,NULL,NULL),(201710,6,NULL,0,NULL,NULL),(201710,10,NULL,0,NULL,NULL),(201710,11,NULL,0,NULL,NULL),(201710,12,NULL,0,NULL,NULL),(201710,13,NULL,0,NULL,NULL),(201710,16,NULL,0,NULL,NULL),(201710,17,NULL,0,NULL,NULL),(201710,18,NULL,0,NULL,NULL),(201710,19,NULL,0,NULL,NULL),(201710,20,NULL,0,NULL,NULL),(201710,23,NULL,0,NULL,NULL),(201710,24,NULL,0,NULL,NULL),(201710,25,NULL,0,NULL,NULL),(201710,26,NULL,0,NULL,NULL),(201710,27,NULL,0,NULL,NULL),(201710,30,NULL,0,NULL,NULL),(201710,31,NULL,0,NULL,NULL),(201711,1,NULL,0,NULL,NULL),(201711,2,NULL,0,NULL,NULL),(201711,6,NULL,0,NULL,NULL),(201711,7,NULL,0,NULL,NULL),(201711,8,NULL,0,NULL,NULL),(201711,9,NULL,0,NULL,NULL),(201711,10,NULL,0,NULL,NULL),(201711,13,NULL,0,NULL,NULL),(201711,14,NULL,0,NULL,NULL),(201711,15,NULL,0,NULL,NULL),(201711,16,NULL,0,NULL,NULL),(201711,17,NULL,0,NULL,NULL),(201711,20,NULL,0,NULL,NULL),(201711,21,NULL,0,NULL,NULL),(201711,22,NULL,0,NULL,NULL),(201711,24,NULL,0,NULL,NULL),(201711,27,NULL,0,NULL,NULL),(201711,28,NULL,0,NULL,NULL),(201711,29,NULL,0,NULL,NULL),(201711,30,NULL,0,NULL,NULL),(201712,1,NULL,0,NULL,NULL),(201712,4,NULL,0,NULL,NULL),(201712,5,NULL,0,NULL,NULL),(201712,6,NULL,0,NULL,NULL),(201712,7,NULL,0,NULL,NULL),(201712,8,NULL,0,NULL,NULL),(201712,11,NULL,0,NULL,NULL),(201712,12,NULL,0,NULL,NULL),(201712,13,NULL,0,NULL,NULL),(201712,14,NULL,0,NULL,NULL),(201712,15,NULL,0,NULL,NULL),(201712,18,NULL,0,NULL,NULL),(201712,19,NULL,0,NULL,NULL),(201712,20,NULL,0,NULL,NULL),(201712,21,NULL,0,NULL,NULL),(201712,22,NULL,0,NULL,NULL),(201712,25,NULL,0,NULL,NULL),(201712,26,NULL,0,NULL,NULL),(201712,27,NULL,0,NULL,NULL),(201712,28,NULL,0,NULL,NULL),(201712,29,NULL,0,NULL,NULL); |
| 2282 | 109 | bit | /*!40000 ALTER TABLE `bankbusinessdaymaster` ENABLE KEYS */;
|
| 2283 | UNLOCK TABLES;
|
||
| 2284 | |||
| 2285 | 113 | bit | -- 締日マスタ
|
| 2286 | LOCK TABLES `deadlinemaster` WRITE; |
||
| 2287 | /*!40000 ALTER TABLE `deadlinemaster` DISABLE KEYS */;
|
||
| 2288 | INSERT INTO `deadlinemaster` VALUES (0,18,31,NULL,0,NULL,NULL),(1,8,10,NULL,0,NULL,NULL); |
||
| 2289 | /*!40000 ALTER TABLE `deadlinemaster` ENABLE KEYS */;
|
||
| 2290 | UNLOCK TABLES;
|