/trunk/ddl/ProcessManagement.sql - アノテート - 工事管理システム製品化対応 - Redmine

379

bit

-- Project Name : noname

2

-- Date/Time    : 2018/08/06 8:37:19

3

-- Author       : Horiuchi

4

-- RDBMS Type   : MySQL

5

-- Application  : A5:SQL Mk-2

6

7

/*

8

  BackupToTempTable, RestoreFromTempTable?^????????t????????????B

9

  ???????Adrop table, create table ????f?[?^???c?????B

10

  ????@?\????I?? $$TableName ???????e?[?u????????????B

11

*/

12

13

-- ?S????s???\??f?[?^

14

--* BackupToTempTable

15

drop table if exists actionscheduledata cascade;

16

17

--* RestoreFromTempTable

18

create table actionscheduledata (

19

  TargetDate date not null comment '????'

20

  , PersonCode decimal(8,0) not null comment '?S????R?[?h'

21

  , ActionSchedule varchar(30) comment '?s???\??'

22

  , TargetYear year(4) not null comment '?Y???N'

23

  , TargetMonth year(4) not null comment '?Y????'

24

  , TargetDay year(4) not null comment '?Y????'

25

  , EntryDate datetime not null comment '?o?^???t'

26

  , UpdateDate datetime not null comment '?X?V???t'

27

  , constraint actionscheduledata_PKC primary key (TargetDate,PersonCode)

28

) comment '?S????s???\??f?[?^' ;

29

30

create index ActionScheduleData_Index1

31

  on actionscheduledata(TargetYear);

32

33

create index ActionScheduleData_Index2

34

  on actionscheduledata(TargetMonth);

35

36

create index ActionScheduleData_Index3

37

  on actionscheduledata(TargetDay);

38

39

-- ???F?o?H?}?X?^

40

--* BackupToTempTable

41

drop table if exists approvalmaster cascade;

42

43

--* RestoreFromTempTable

44

create table approvalmaster (

45

  ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

46

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

47

  , SeqNo decimal(2,0) not null comment '?}??'

48

  , DisplayOrder decimal(2,0) not null comment '?\????'

49

  , ApprovalPerson decimal(8,0) unsigned not null comment '???F??R?[?h'

50

  , ApprovalAuthority decimal(1,0) not null comment '???F??????'

51

  , EntryDate datetime not null comment '?o?^???t'

52

  , UpdateDate datetime not null comment '?X?V???t'

53

  , constraint approvalmaster_PKC primary key (ApprovalCode,DepartmentCode,SeqNo)

54

) comment '???F?o?H?}?X?^' ;

55

56

-- ?o?????f?[?^

57

--* BackupToTempTable

58

drop table if exists attendancedailydata cascade;

59

60

--* RestoreFromTempTable

61

create table attendancedailydata (

62

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

63

  , AttendanceDate date not null comment '???????'

64

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

65

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

66

  , ActionResult varchar(30) not null comment '?s??????'

67

  , StartTime datetime comment '?J?n????'

68

  , CompTime datetime comment '?I??????'

69

  , DayTimes decimal(4,1) not null comment '????????v????'

70

  , WorkingComment varchar(120) comment '?R?????g'

71

  , WorkKindFlg decimal(1,0) not null comment '?????t???O'

72

  , EntryDate datetime not null comment '?o?^???t'

73

  , UpdateDate datetime not null comment '?X?V???t'

74

  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)

75

) comment '?o?????f?[?^' ;

76

77

create index AttendDaily_Index1

78

  on attendancedailydata(ConstructionCode);

79

80

create index AttendDaily_Index2

81

  on attendancedailydata(AttendanceDate);

82

83

-- ?o?????f?[?^

84

--* BackupToTempTable

85

drop table if exists attendancedata cascade;

86

87

--* RestoreFromTempTable

88

create table attendancedata (

89

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

90

  , AttendanceMonth date not null comment '?o?????N??'

91

  , LastDays decimal(2,0) unsigned not null comment '??????I??'

92

  , AttendDayCount decimal(2,0) unsigned not null comment '?o?????'

93

  , TotalOverTimes decimal(4,1) not null comment '?c??????'

94

  , OrderDate date not null comment '?\????'

95

  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'

96

  , EntryDate datetime not null comment '?o?^???t'

97

  , UpdateDate datetime not null comment '?X?V???t'

98

  , constraint attendancedata_PKC primary key (PersonCode,AttendanceMonth)

99

) comment '?o?????f?[?^' ;

100

101

-- ??s?c????}?X?^

102

--* BackupToTempTable

103

drop table if exists bankbusinessdaymaster cascade;

104

105

--* RestoreFromTempTable

106

create table bankbusinessdaymaster (

107

  YEARMONTH decimal(6,0) default '0' not null comment '?N??'

108

  , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '??s?c???'

109

  , NOTE varchar(120) comment '???l'

110

  , DELETEFLG decimal(1,0) comment '???t???O'

111

  , ENTRYDATE datetime comment '?o?^?N????'

112

  , UPDATEDATE datetime comment '?X?V?N????'

113

  , constraint bankbusinessdaymaster_PKC primary key (YEARMONTH,BANKBUSINESSDAY)

114

) comment '??s?c????}?X?^' ;

115

116

-- ???????f?[?^

117

--* BackupToTempTable

118

drop table if exists billingdata cascade;

119

120

--* RestoreFromTempTable

121

create table billingdata (

122

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

123

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

124

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

125

  , BILLPRICE decimal(10,0) comment '???????z'

126

  , ENTRYDATE datetime comment '?o?^?N????'

127

  , UPDATEDATE datetime comment '?X?V?N????'

128

  , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)

129

) comment '???????f?[?^' ;

130

131

-- ??????????f?[?^

132

--* BackupToTempTable

133

drop table if exists billingdatadetail cascade;

134

135

--* RestoreFromTempTable

136

create table billingdatadetail (

137

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

138

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

139

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

140

  , LINECOUNT decimal(3,0) default '0' not null comment '?s???'

141

  , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'

142

  , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '?s???'

143

  , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '????'

144

  , FIELDNAME varchar(120) comment '????'

145

  , BILLPRICE decimal(10,0) comment '???????z'

146

  , HIGHWPRICE decimal(10,0) comment '??????'

147

  , HARDWPRICE decimal(10,0) comment '??????'

148

  , INDSWASTETAX decimal(10,0) comment '?Y?p??'

149

  , NOTE varchar(120) comment '???l'

150

  , ENTRYDATE datetime comment '?o?^?N????'

151

  , UPDATEDATE datetime comment '?X?V?N????'

152

  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)

153

) comment '??????????f?[?^' ;

154

155

-- ???????x???T?}???[?f?[?^

156

--* BackupToTempTable

157

drop table if exists billingpaymentsummary cascade;

158

159

--* RestoreFromTempTable

160

create table billingpaymentsummary (

161

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

162

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

163

  , CHARGEPAYMENTKIND decimal(1,0) default '0' not null comment '?????x????'

164

  , PAYDAY date comment '?x????'

165

  , BILLPRICESTOTAL decimal(10,0) comment '???????z???v'

166

  , CONSUMPTIONTAXRATE decimal(6,3) comment '??????'

167

  , CONSUMPTIONTAXPRICE decimal(10,0) comment '?????z'

168

  , HIGHWPRICESTOTAL decimal(10,0) comment '???????v'

169

  , HARDWPRICESTOTAL decimal(10,0) comment '???????v'

170

  , INDSWASTETAXSTOTAL decimal(10,0) comment '?Y?p????v'

171

  , CNSTRPRICERATE decimal(6,3) comment '???????'

172

  , CNSTRPRICESTOTAL decimal(10,0) comment '????????v'

173

  , BILLINGPRICETOTAL decimal(10,0) comment '???????z???v'

174

  , ENTRYDATE datetime comment '?o?^?N????'

175

  , UPDATEDATE datetime comment '?X?V?N????'

176

  , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND)

177

) comment '???????x???T?}???[?f?[?^' ;

178

179

-- ?^?c?????????

180

--* BackupToTempTable

181

drop table if exists bizperiodhistory cascade;

182

183

--* RestoreFromTempTable

184

create table bizperiodhistory (

185

  PeriodYear smallint(6) not null comment '?c??????E?H???N?x'

186

  , PeriodFlag smallint(1) not null comment '?c??????E?H???N?x?t???O'

187

  , BeginDate datetime not null comment '?????'

188

  , CompleteDate datetime not null comment '??????'

189

  , EntryDate datetime not null comment '?o?^???t'

190

  , UpdateDate datetime not null comment '?X?V???t'

191

  , constraint bizperiodhistory_PKC primary key (PeriodYear,PeriodFlag)

192

) comment '?^?c?????????' ;

193

194

-- ?H???????f?[?^?y???p?z

195

--* BackupToTempTable

196

drop table if exists bk_constructionledger cascade;

197

198

--* RestoreFromTempTable

199

create table bk_constructionledger (

200

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

201

  , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'

202

  , CreatorCode decimal(8,0) comment '????R?[?h'

203

  , CreatorName varchar(60) comment '?????'

204

  , CreateDate date not null comment '????'

205

  , ConstructionTimes decimal(5,2) not null comment '?H???i?P??E???j'

206

  , ConstructionStart date not null comment '?_??H???J?n'

207

  , ConstructionEnd date not null comment '?_??H??????'

208

  , OrdersDecisionPrice decimal(14,0) not null comment '??????????z'

209

  , CompanyExpenses decimal(10,0) not null comment '???o???v'

210

  , DepartmentExpenses decimal(10,0) not null comment '?????o???v'

211

  , SalesExpenses decimal(10,0) not null comment '?c??o???v'

212

  , TotalPayment decimal(10,0) not null comment '???x???z'

213

  , GrossProfit decimal(10,0) not null comment '?e??'

214

  , Allowance decimal(10,0) not null comment '???^'

215

  , NetProfit decimal(10,0) not null comment '?????v'

216

  , ComplateFlg decimal(1,0) not null comment '????????t???O'

217

  , IntegrationFlg decimal(1,0) not null comment '????z??Z?t???O'

218

  , EntryDate datetime not null comment '?o?^???t'

219

  , UpdateDate datetime not null comment '?X?V???t'

220

  , constraint bk_constructionledger_PKC primary key (ConstructionCode)

221

) comment '?H???????f?[?^?y???p?z' ;

222

223

-- ?H??????????f?[?^?y???p?z

224

--* BackupToTempTable

225

drop table if exists bk_constructionledgerdetail cascade;

226

227

--* RestoreFromTempTable

228

create table bk_constructionledgerdetail (

229

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

230

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

231

  , LineCount decimal(5,0) unsigned not null comment '?s???'

232

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

233

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

234

  , FirstString varchar(120) comment '???????'

235

  , SecondString varchar(120) comment '?H?????e'

236

  , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'

237

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

238

  , CompanyName varchar(120) comment '?????????'

239

  , EstimatePrice decimal(12,0) not null comment '?\?Z?i????j???z'

240

  , ExecutionAmount decimal(12,0) not null comment '???s???z'

241

  , AmountConfigRate decimal(5,2) not null comment '???z?\????'

242

  , PaymentBurden decimal(12,0) not null comment '?x????U?z'

243

  , FixDataFlg decimal(1,0) not null comment '???f?[?^?t???O'

244

  , IndependentFlg decimal(1,0) not null comment '????f?[?^?t???O'

245

  , FluctuationFlg decimal(1,0) not null comment '?????f?[?^?t???O'

246

  , SalaryFlg decimal(1,0) not null comment '???^?U????'

247

  , SalaryDays decimal(4,0) not null comment '???^?U??????'

248

  , OperatingFlg decimal(1,0) not null comment '?S?????t???O'

249

  , SourceCode decimal(10,0) unsigned not null comment '???H?????'

250

  , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'

251

  , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'

252

  , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'

253

  , EntryDate datetime not null comment '?o?^???t'

254

  , UpdateDate datetime not null comment '?X?V???t'

255

  , constraint bk_constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

256

) comment '?H??????????f?[?^?y???p?z' ;

257

258

-- ?H?????????s?f?[?^?y???p?z

259

--* BackupToTempTable

260

drop table if exists bk_constructionledgerexcute cascade;

261

262

--* RestoreFromTempTable

263

create table bk_constructionledgerexcute (

264

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

265

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

266

  , LineCount decimal(5,0) unsigned not null comment '?s???'

267

  , ColumnCount decimal(3,0) not null comment '????'

268

  , PaymentAmount decimal(12,0) not null comment '?x?????z'

269

  , TargetMonth date not null comment '???N??'

270

  , EntryDate datetime not null comment '?o?^???t'

271

  , UpdateDate datetime not null comment '?X?V???t'

272

  , constraint bk_constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)

273

) comment '?H?????????s?f?[?^?y???p?z' ;

274

275

-- ??Z????f?[?^?y???p?z

276

--* BackupToTempTable

277

drop table if exists bk_estimatedata cascade;

278

279

--* RestoreFromTempTable

280

create table bk_estimatedata (

281

  SaveDate datetime not null comment '?????t'

282

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

283

  , LineCount decimal(3,0) unsigned not null comment '?s???'

284

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

285

  , FixedItemCode varchar(1) comment '?????L?['

286

  , ItemName varchar(120) comment '??????'

287

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

288

  , PriceValue decimal(14,0) not null comment '???z'

289

  , note varchar(60) comment '???l'

290

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

291

  , InputFlg decimal(1,0) not null comment '????t???O'

292

  , EntryDate datetime not null comment '?o?^???t'

293

  , UpdateDate datetime not null comment '?X?V???t'

294

  , constraint bk_estimatedata_PKC primary key (SaveDate,ConstructionCode,LineCount)

295

) comment '??Z????f?[?^?y???p?z' ;

296

297

-- ??Z????y?[?W?f?[?^?y???p?z

298

--* BackupToTempTable

299

drop table if exists bk_estimatedatabody cascade;

300

301

--* RestoreFromTempTable

302

create table bk_estimatedatabody (

303

  SaveDate datetime not null comment '?????t'

304

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

305

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

306

  , Category decimal(1,0) not null comment '?y?[?W??'

307

  , UnionComponentCode decimal(5,0) unsigned not null comment '?????\???L?['

308

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

309

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

310

  , SelectComponent decimal(5,0) unsigned not null comment '?I???\???L?['

311

  , PageTitle varchar(120) not null comment '?y?[?W?\????'

312

  , DetailLineCount decimal(3,0) unsigned not null comment '????s???'

313

  , EntryDate datetime not null comment '?o?^???t'

314

  , UpdateDate datetime not null comment '?X?V???t'

315

  , constraint bk_estimatedatabody_PKC primary key (SaveDate,ConstructionCode,PageCount)

316

) comment '??Z????y?[?W?f?[?^?y???p?z' ;

317

318

-- ??Z????f?[?^????y???p?z

319

--* BackupToTempTable

320

drop table if exists bk_estimatedatadetail cascade;

321

322

--* RestoreFromTempTable

323

create table bk_estimatedatadetail (

324

  SaveDate datetime not null comment '?????t'

325

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

326

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

327

  , LineCount decimal(3,0) unsigned not null comment '?s???'

328

  , DataType decimal(1,0) not null comment '?f?[?^???'

329

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

330

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

331

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

332

  , ItemName varchar(120) comment '??????'

333

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

334

  , Unitcount decimal(8,2) not null comment '????'

335

  , UnitName varchar(30) comment '?P?????'

336

  , UnitPrice decimal(9,2) not null comment '?P??'

337

  , LineTotal decimal(12,0) not null comment '???z'

338

  , note varchar(60) comment '???l'

339

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

340

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

341

  , InputFlg decimal(1,0) comment '????t???O'

342

  , EntryDate datetime not null comment '?o?^???t'

343

  , UpdateDate datetime not null comment '?X?V???t'

344

  , constraint bk_estimatedatadetail_PKC primary key (SaveDate,ConstructionCode,PageCount,LineCount)

345

) comment '??Z????f?[?^????y???p?z' ;

346

347

-- ?\?Z???W?v?R?[?h?}?X?^

348

--* BackupToTempTable

349

drop table if exists budgetsumcode cascade;

350

351

--* RestoreFromTempTable

352

create table budgetsumcode (

353

  BlockCode decimal(2,0) unsigned not null comment '?u???b?N???'

354

  , GroupCode decimal(2,0) unsigned not null comment '?O???[?v???'

355

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

356

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

357

  , ElementsName varchar(100) not null comment '?v?f????'

358

  , EntryDate datetime not null comment '?o?^???t'

359

  , UpdateDate datetime not null comment '?X?V???t'

360

  , constraint budgetsumcode_PKC primary key (BlockCode,GroupCode,ComponentCode,ItemCode)

361

) comment '?\?Z???W?v?R?[?h?}?X?^' ;

362

363

-- ?@?l?i?}?X?^

364

--* BackupToTempTable

365

drop table if exists businesstypemaster cascade;

366

367

--* RestoreFromTempTable

368

create table businesstypemaster (

369

  BusinessTypeCode decimal(5,0) unsigned not null comment '?@?l?i?R?[?h'

370

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

371

  , BusinessTypeName varchar(100) not null comment '???'

372

  , EntryDate datetime not null comment '?o?^???t'

373

  , UpdateDate datetime not null comment '?X?V???t'

374

  , constraint businesstypemaster_PKC primary key (BusinessTypeCode)

375

) comment '?@?l?i?}?X?^' ;

376

377

create index BusinessTypeMaster_Index1

378

  on businesstypemaster(DisplayOrder);

379

380

-- ?S????????????f?[?^

381

--* BackupToTempTable

382

drop table if exists chgchargedep cascade;

383

384

--* RestoreFromTempTable

385

create table chgchargedep (

386

  PersonCode decimal(8,0) not null comment '?S????R?[?h'

387

  , StartDate date not null comment '?J?n?N????'

388

  , CompDate date not null comment '?I???N????'

389

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

390

  , DepartmentName varchar(60) comment '??????'

391

  , EntryDate datetime not null comment '?o?^???t'

392

  , UpdateDate datetime not null comment '?X?V???t'

393

  , constraint chgchargedep_PKC primary key (PersonCode,StartDate)

394

) comment '?S????????????f?[?^' ;

395

396

-- ?H???S????X?????f?[?^

397

--* BackupToTempTable

398

drop table if exists chgconstrcharge cascade;

399

400

--* RestoreFromTempTable

401

create table chgconstrcharge (

402

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

403

  , Division decimal(1,0) not null comment '????'

404

  , SeqNo smallint(5) unsigned not null comment '?A??'

405

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

406

  , PersonCode decimal(8,0) not null comment '?S????R?[?h'

407

  , StartDate date comment '?S???J?n?N????'

408

  , CompDate date comment '?S???I???N????'

409

  , SourceCode decimal(10,0) unsigned not null comment '???H???R?[?h'

410

  , DeleteFlg decimal(1,0) not null comment '???t???O'

411

  , EntryDate datetime not null comment '?o?^???t'

412

  , UpdateDate datetime not null comment '?X?V???t'

413

  , constraint chgconstrcharge_PKC primary key (ConstructionCode,Division,SeqNo)

414

) comment '?H???S????X?????f?[?^' ;

415

416

-- ????????}?X?^

417

--* BackupToTempTable

418

drop table if exists commoncostlarge cascade;

419

420

--* RestoreFromTempTable

421

create table commoncostlarge (

422

  LargeCode decimal(5,0) unsigned not null comment '????L?['

423

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

424

  , LargeName varchar(50) not null comment '???????'

425

  , CommentText varchar(120) comment '????????'

426

  , DeleteFlg decimal(1,0) not null comment '???t???O'

427

  , EntryDate datetime not null comment '?o?^???t'

428

  , UpdateDate datetime not null comment '?X?V???t'

429

  , constraint commoncostlarge_PKC primary key (LargeCode)

430

) comment '????????}?X?^' ;

431

432

-- ?????H???A?}?X?^

433

--* BackupToTempTable

434

drop table if exists commoncostlinkms cascade;

435

436

--* RestoreFromTempTable

437

create table commoncostlinkms (

438

  LargeCode decimal(5,0) unsigned not null comment '????L?['

439

  , MiddleCode decimal(5,0) unsigned not null comment '??????L?['

440

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

441

  , EntryDate datetime comment '?o?^???t'

442

  , UpdateDate datetime comment '?X?V???t'

443

  , constraint commoncostlinkms_PKC primary key (LargeCode,MiddleCode,ItemCode)

444

) comment '?????H???A?}?X?^' ;

445

446

-- ?????????}?X?^

447

--* BackupToTempTable

448

drop table if exists commoncostmiddle cascade;

449

450

--* RestoreFromTempTable

451

create table commoncostmiddle (

452

  LargeCode decimal(5,0) unsigned not null comment '????L?['

453

  , MiddleCode decimal(5,0) unsigned not null comment '??????L?['

454

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

455

  , MiddleName varchar(50) not null comment '?????????'

456

  , CommentText varchar(120) comment '????????'

457

  , DeleteFlg decimal(1,0) not null comment '???t???O'

458

  , EntryDate datetime not null comment '?o?^???t'

459

  , UpdateDate datetime not null comment '?X?V???t'

460

  , constraint commoncostmiddle_PKC primary key (LargeCode,MiddleCode)

461

) comment '?????????}?X?^' ;

462

463

-- ?????????L?[?}?X?^

464

--* BackupToTempTable

465

drop table if exists commoncostmiddlesearchword cascade;

466

467

--* RestoreFromTempTable

468

create table commoncostmiddlesearchword (

469

  LargeCode decimal(5,0) unsigned not null comment '????L?['

470

  , MiddleCode decimal(5,0) unsigned not null comment '??????L?['

471

  , SeqNo decimal(5,0) unsigned not null comment '????'

472

  , SearchWord varchar(50) not null comment '????????'

473

  , EntryDate datetime not null comment '?o?^???t'

474

  , UpdateDate datetime not null comment '?X?V???t'

475

  , constraint commoncostmiddlesearchword_PKC primary key (LargeCode,MiddleCode,SeqNo)

476

) comment '?????????L?[?}?X?^' ;

477

478

-- ?\???H???A?}?X?^

479

--* BackupToTempTable

480

drop table if exists componentlinkmaster cascade;

481

482

--* RestoreFromTempTable

483

create table componentlinkmaster (

484

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

485

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

486

  , DisplayOrder decimal(5,0) unsigned comment '?\????'

487

  , EntryDate datetime not null comment '?o?^???t'

488

  , UpdateDate datetime not null comment '?X?V???t'

489

  , constraint componentlinkmaster_PKC primary key (ComponentCode,ItemCode)

490

) comment '?\???H???A?}?X?^' ;

491

492

create index ComponentLinkMaster_Index1

493

  on componentlinkmaster(ComponentCode);

494

495

create index ComponentLinkMaster_Index2

496

  on componentlinkmaster(ItemCode);

497

498

-- ?\???}?X?^

499

--* BackupToTempTable

500

drop table if exists componentmaster cascade;

501

502

--* RestoreFromTempTable

503

create table componentmaster (

504

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

505

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

506

  , ComponentName varchar(120) not null comment '?\??????'

507

  , SubItemsFlg decimal(1,0) comment '???????t???O'

508

  , DirectInputFlg decimal(1,0) comment '???????t???O'

509

  , MyExpensesFlg decimal(1,0) comment '????o??t???O'

510

  , DeleteFlg decimal(1,0) not null comment '???t???O'

511

  , EntryDate datetime not null comment '?o?^???t'

512

  , UpdateDate datetime not null comment '?X?V???t'

513

  , constraint componentmaster_PKC primary key (ComponentCode)

514

) comment '?\???}?X?^' ;

515

516

create index ComponentMaster_Index1

517

  on componentmaster(DisplayOrder);

518

519

-- ?\???H??????A?}?X?^

520

--* BackupToTempTable

521

drop table if exists componenttotypemaster cascade;

522

523

--* RestoreFromTempTable

524

create table componenttotypemaster (

525

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

526

  , TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'

527

  , Dummy decimal(1,0) not null comment '?_?~?[????'

528

  , EntryDate datetime not null comment '?o?^???t'

529

  , UpdateDate datetime not null comment '?X?V???t'

530

  , constraint componenttotypemaster_PKC primary key (ComponentCode,TypeCode)

531

) comment '?\???H??????A?}?X?^' ;

532

533

create index ComponentToTypeMaster_Index1

534

  on componenttotypemaster(ComponentCode);

535

536

create index ComponentToTypeMaster_Index2

537

  on componenttotypemaster(TypeCode);

538

539

-- ?H???????o??f?[?^

540

--* BackupToTempTable

541

drop table if exists constrledgerexpenses cascade;

542

543

--* RestoreFromTempTable

544

create table constrledgerexpenses (

545

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

546

  , SeqNo decimal(5,0) not null comment '?}??'

547

  , NameCode decimal(5,0) unsigned not null comment '?o??R?[?h'

548

  , ExpensesRaito decimal(4,2) not null comment '?o??'

549

  , ExpensesValue decimal(10,0) not null comment '?o????z'

550

  , EntryDate datetime not null comment '?o?^???t'

551

  , UpdateDate datetime not null comment '?X?V???t'

552

  , constraint constrledgerexpenses_PKC primary key (ConstructionCode,SeqNo,NameCode)

553

) comment '?H???????o??f?[?^' ;

554

555

create index ConstrLedgerExpenses_Index1

556

  on constrledgerexpenses(ConstructionCode);

557

558

create index ConstrLedgerExpenses_Index2

559

  on constrledgerexpenses(SeqNo);

560

561

create index ConstrLedgerExpenses_Index3

562

  on constrledgerexpenses(NameCode);

563

564

-- ?H????{???

565

--* BackupToTempTable

566

drop table if exists constructionbaseinfo cascade;

567

568

--* RestoreFromTempTable

569

create table constructionbaseinfo (

570

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

571

  , TyingFlg decimal(1,0) not null comment '?R?t?f?[?^?t???O'

572

  , JoinFlg decimal(1,0) not null comment '?????_??H???t???O'

573

  , ConstructionYear smallint(5) unsigned not null comment '?H???N?x'

574

  , ConstructionPeriod smallint(5) unsigned not null comment '?H??????'

575

  , RequestedDate date comment '??????'

576

  , EstimatesSubmitDeadline date comment '?????o????'

577

  , EstimatesSubmittedDate date comment '?????o??'

578

  , ProvisionalOrderDate date comment '?????'

579

  , OrderDate date comment '???'

580

  , OrderStartingDate date comment '?J?n?\???'

581

  , OrderCompletionDate date comment '?????\???'

582

  , PreparationStartDate date comment '?{?H?????J?n??'

583

  , ConstructionStartingDate date comment '?{?H?J?n??'

584

  , ConstructionCompletionDate date comment '?{?H??????'

585

  , NonOrderDate date comment '????'

586

  , OrdersDecisionPrice decimal(12,0) not null comment '??????????z'

587

  , OrdersDecisionPriceInTax decimal(12,0) not null comment '??????????z'

588

  , SalesDepCode decimal(5,0) unsigned not null comment '?c??S????????R?[?h'

589

  , SalesPersonCode decimal(8,0) unsigned not null comment '?c??S????R?[?h'

590

  , SalesSubDepCode decimal(5,0) unsigned not null comment '?c????S????????R?[?h'

591

  , SalesSubPersonCode decimal(8,0) unsigned not null comment '?c????S????R?[?h'

592

  , ConstrDepCode decimal(5,0) unsigned not null comment '?H???S????????R?[?h'

593

  , ConstructionPersonCode decimal(8,0) not null comment '?H???S????R?[?h'

594

  , ConstrSubDepCode decimal(5,0) unsigned not null comment '?H?????S????????R?[?h'

595

  , ConstrSubPersonCode decimal(8,0) not null comment '?H?????S????R?[?h'

596

  , ConstrInstrDepCode decimal(5,0) unsigned not null comment '?H???w?????????R?[?h'

597

  , ConstructionInstructor decimal(8,0) not null comment '?H???w?????R?[?h'

598

  , TransferConstruction decimal(8,0) not null comment '?H??????R?[?h'

599

  , TransferConstructionDate date comment '?H??????'

600

  , OrderersDivision decimal(5,0) not null comment '????????R?[?h'

601

  , OrderersCode decimal(5,0) unsigned not null comment '??????R?[?h'

602

  , EstimatesExpirationDate date comment '????L??????'

603

  , ConstructionPeriodStart date comment '?_??H???J?n??'

604

  , ConstructionPeriodEnd date comment '?_??H??????'

605

  , ConstructionPeriodStart2 date comment '?_??H???J?n?i???????j'

606

  , ConstructionPeriodEnd2 date comment '?_??H???????i???????j'

607

  , StartDate date comment '?H???J?n??'

608

  , EndDate date comment '?H???I????'

609

  , PurchaseOrderMailingDate date comment '???????X????'

610

  , PurchaseOrderReturnDate date comment '???????????'

611

  , PurchaseOrderReturnCheckDate date comment '??????????m?F??'

612

  , ConsumptionTaxFlg decimal(1,0) not null comment '?????t???O'

613

  , PrimeContractorFlg decimal(1,0) not null comment '?????t???O'

614

  , SalesCostFlg decimal(1,0) not null comment '?c??o?????t???O'

615

  , ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'

616

  , ConstructionType decimal(5,0) not null comment '?H?????R?[?h'

617

  , EstimateType decimal(1,0) not null comment '??????'

618

  , BillingStartDate date not null comment '?????????J?n??'

619

  , BillingDate date not null comment '??????'

620

  , BillingSplitFlg decimal(1,0) not null comment '??????t???O'

621

  , BillingSendDate date comment '???????X??/??n????'

622

  , LedgerComplateDate date not null comment '?H????????????????t'

623

  , InspectPlanningDate date not null comment '?????\???'

624

  , InspectExecuteDate date not null comment '???????s??'

625

  , RevCompleteDate date not null comment '??????????????'

626

  , EntryDate datetime not null comment '?o?^???t'

627

  , UpdateDate datetime not null comment '?X?V???t'

628

  , constraint constructionbaseinfo_PKC primary key (ConstructionCode)

629

) comment '?H????{???' ;

630

631

create index BaseInfo_Index1

632

  on constructionbaseinfo(ConstructionStatusFlg);

633

634

create index BaseInfo_Index2

635

  on constructionbaseinfo(EstimateType);

636

637

create index BaseInfo_Index3

638

  on constructionbaseinfo(SalesPersonCode);

639

640

create index BaseInfo_Index4

641

  on constructionbaseinfo(ConstructionPersonCode);

642

643

create index BaseInfo_Index5

644

  on constructionbaseinfo(ConstructionInstructor);

645

646

create index BaseInfo_Index6

647

  on constructionbaseinfo(ConstructionPeriod);

648

649

-- ?H????{????

650

--* BackupToTempTable

651

drop table if exists constructionbaseinfodetail cascade;

652

653

--* RestoreFromTempTable

654

create table constructionbaseinfodetail (

655

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

656

  , DetailNo decimal(3,0) not null comment '??????'

657

  , DetailString varchar(300) comment '??????e'

658

  , EntryDate datetime not null comment '?o?^???t'

659

  , UpdateDate datetime not null comment '?X?V???t'

660

  , constraint constructionbaseinfodetail_PKC primary key (ConstructionCode,DetailNo)

661

) comment '?H????{????' ;

662

663

create index BaseInfoDetail_Idx1

664

  on constructionbaseinfodetail(ConstructionCode);

665

666

create index BaseInfoDetail_Idx2

667

  on constructionbaseinfodetail(DetailNo);

668

669

-- ?H???{?H?\?Z?f?[?^

670

--* BackupToTempTable

671

drop table if exists constructionbudget cascade;

672

673

--* RestoreFromTempTable

674

create table constructionbudget (

675

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

676

  , CreatorCode decimal(8,0) not null comment '????R?[?h'

677

  , CreatorName varchar(60) comment '?????'

678

  , CreatorCosts decimal(11,0) not null comment '??????^'

679

  , AssistantCode decimal(8,0) not null comment '???S????R?[?h'

680

  , AssistantName varchar(60) comment '???S?????'

681

  , AssistantCosts decimal(11,0) not null comment '???S??????^'

682

  , InstructorCode decimal(8,0) not null comment '?H???w?????R?[?h'

683

  , InstructorName varchar(60) comment '?H???w??????'

684

  , InstructorCosts decimal(11,0) not null comment '?H???w???????^'

685

  , CreateDate date not null comment '????'

686

  , ConstructionTimes decimal(5,2) not null comment '?H???i?P??E???j'

687

  , ConstructionStart date not null comment '?_??H???J?n'

688

  , ConstructionEnd date not null comment '?_??H??????'

689

  , InstructorTimes decimal(5,2) not null comment '?w???????????'

690

  , SalaryFlg decimal(1,0) not null comment '???^?U????'

691

  , SalaryDays decimal(4,0) not null comment '?U??????'

692

  , A_SalaryFlg decimal(1,0) not null comment '???S??????^?U????'

693

  , A_SalaryDays decimal(4,0) not null comment '???S????U??????'

694

  , I_SalaryFlg decimal(1,0) not null comment '?w???????^?U????'

695

  , I_SalaryDays decimal(4,0) not null comment '?w?????U??????'

696

  , OrdersDecisionPrice decimal(12,0) not null comment '??????????z'

697

  , EntryDate datetime not null comment '?o?^???t'

698

  , UpdateDate datetime not null comment '?X?V???t'

699

  , constraint constructionbudget_PKC primary key (ConstructionCode)

700

) comment '?H???{?H?\?Z?f?[?^' ;

701

702

-- ?H???{?H?\?Z?f?[?^????

703

--* BackupToTempTable

704

drop table if exists constructionbudgetdetail cascade;

705

706

--* RestoreFromTempTable

707

create table constructionbudgetdetail (

708

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

709

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

710

  , LineCount decimal(3,0) unsigned not null comment '?s???'

711

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

712

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

713

  , FirstString varchar(120) comment '???????'

714

  , SecondString varchar(120) comment '?H?????e'

715

  , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'

716

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

717

  , CompanyName varchar(120) comment '?????????'

718

  , EstimatePrice decimal(12,0) not null comment '??Z????????z'

719

  , NegotiationPrice decimal(12,0) not null comment '??Z????????z'

720

  , OrderDesiredAmount decimal(12,0) not null comment '??????]???z'

721

  , ExecutionAmount decimal(12,0) not null comment '???s???z'

722

  , AmountConfigRate decimal(5,2) not null comment '???z?\????'

723

  , NegotiateFlg decimal(1,0) not null comment '?????????t???O'

724

  , EntryDate datetime not null comment '?o?^???t'

725

  , UpdateDate datetime not null comment '?X?V???t'

726

  , constraint constructionbudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

727

) comment '?H???{?H?\?Z?f?[?^????' ;

728

729

-- ?H??}?X?^

730

--* BackupToTempTable

731

drop table if exists constructionitemmaster cascade;

732

733

--* RestoreFromTempTable

734

create table constructionitemmaster (

735

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

736

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

737

  , ItemName varchar(120) not null comment '?H????'

738

  , SubItemsFlg decimal(1,0) comment '???????t???O'

739

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

740

  , DeleteFlg decimal(1,0) not null comment '???t???O'

741

  , EntryDate datetime not null comment '?o?^???t'

742

  , UpdateDate datetime not null comment '?X?V???t'

743

  , constraint constructionitemmaster_PKC primary key (ItemCode)

744

) comment '?H??}?X?^' ;

745

746

-- ?H???????f?[?^

747

--* BackupToTempTable

748

drop table if exists constructionledger cascade;

749

750

--* RestoreFromTempTable

751

create table constructionledger (

752

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

753

  , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'

754

  , CreatorCode decimal(8,0) comment '????R?[?h'

755

  , CreatorName varchar(60) comment '?????'

756

  , CreateDate date not null comment '????'

757

  , ConstructionTimes decimal(5,2) not null comment '?H???i?P??E???j'

758

  , ConstructionStart date not null comment '?_??H???J?n'

759

  , ConstructionEnd date not null comment '?_??H??????'

760

  , OrdersDecisionPrice decimal(14,0) not null comment '??????????z'

761

  , CompanyExpenses decimal(10,0) not null comment '???o???v'

762

  , DepartmentExpenses decimal(10,0) not null comment '?????o???v'

763

  , SalesExpenses decimal(10,0) not null comment '?c??o???v'

764

  , TotalPayment decimal(10,0) not null comment '???x???z'

765

  , GrossProfit decimal(10,0) not null comment '?e??'

766

  , Allowance decimal(10,0) not null comment '???^'

767

  , NetProfit decimal(10,0) not null comment '?????v'

768

  , ComplateFlg decimal(1,0) not null comment '????????t???O'

769

  , IntegrationFlg decimal(1,0) not null comment '????z??Z?t???O'

770

  , EntryDate datetime not null comment '?o?^???t'

771

  , UpdateDate datetime not null comment '?X?V???t'

772

  , constraint constructionledger_PKC primary key (ConstructionCode)

773

) comment '?H???????f?[?^' ;

774

775

create index constructionledger_Index1

776

  on constructionledger(ConstructionStart);

777

778

create index constructionledger_Index2

779

  on constructionledger(ConstructionEnd);

780

781

-- ?H??????????f?[?^

782

--* BackupToTempTable

783

drop table if exists constructionledgerdetail cascade;

784

785

--* RestoreFromTempTable

786

create table constructionledgerdetail (

787

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

788

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

789

  , LineCount decimal(4,0) unsigned not null comment '?s???'

790

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

791

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

792

  , FirstString varchar(120) comment '???????'

793

  , SecondString varchar(120) comment '?H?????e'

794

  , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'

795

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

796

  , CompanyName varchar(120) comment '?????????'

797

  , EstimatePrice decimal(12,0) not null comment '?\?Z?i????j???z'

798

  , ExecutionAmount decimal(12,0) not null comment '???s???z'

799

  , AmountConfigRate decimal(5,2) not null comment '???z?\????'

800

  , PaymentBurden decimal(12,0) not null comment '?x????U?z'

801

  , FixDataFlg decimal(1,0) not null comment '???f?[?^?t???O'

802

  , IndependentFlg decimal(1,0) not null comment '????f?[?^?t???O'

803

  , FluctuationFlg decimal(1,0) not null comment '?????f?[?^?t???O'

804

  , SalaryFlg decimal(1,0) not null comment '???^?U????'

805

  , SalaryDays decimal(4,0) not null comment '???^?U??????'

806

  , OperatingFlg decimal(1,0) not null comment '?S?????t???O'

807

  , SourceCode decimal(10,0) unsigned not null comment '???H?????'

808

  , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'

809

  , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'

810

  , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'

811

  , DetailCount decimal(4,0) unsigned not null comment '??????'

812

  , EntryDate datetime not null comment '?o?^???t'

813

  , UpdateDate datetime not null comment '?X?V???t'

814

  , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

815

) comment '?H??????????f?[?^' ;

816

817

create index LedgerDetail_Index01

818

  on constructionledgerdetail(ConstructionCode);

819

820

create index LedgerDetail_Index02

821

  on constructionledgerdetail(GroupCount);

822

823

create index LedgerDetail_Index03

824

  on constructionledgerdetail(LineCount);

825

826

create index LedgerDetail_Index04

827

  on constructionledgerdetail(SourceCode);

828

829

create index LedgerDetail_Index05

830

  on constructionledgerdetail(DetailCount);

831

832

create index LedgerDetail_Index06

833

  on constructionledgerdetail(SalaryFlg);

834

835

create index LedgerDetail_Index07

836

  on constructionledgerdetail(CompanyCode);

837

838

-- ?H?????????s?f?[?^

839

--* BackupToTempTable

840

drop table if exists constructionledgerexcute cascade;

841

842

--* RestoreFromTempTable

843

create table constructionledgerexcute (

844

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

845

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

846

  , LineCount decimal(4,0) unsigned not null comment '?s???'

847

  , ColumnCount decimal(3,0) not null comment '????'

848

  , PaymentAmount decimal(12,0) not null comment '?x?????z'

849

  , TargetMonth date not null comment '???N??'

850

  , EntryDate datetime not null comment '?o?^???t'

851

  , UpdateDate datetime not null comment '?X?V???t'

852

  , constraint constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)

853

) comment '?H?????????s?f?[?^' ;

854

855

create index LedgerExcute_Index1

856

  on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);

857

858

-- ?H???????N???

859

--* BackupToTempTable

860

drop table if exists constructionlink cascade;

861

862

--* RestoreFromTempTable

863

create table constructionlink (

864

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

865

  , FluctuationCode decimal(10,0) not null comment '?q?H?????'

866

  , LinkType decimal(1,0) not null comment '?????N???'

867

  , EntryDate datetime not null comment '?o?^???t'

868

  , UpdateDate datetime not null comment '?X?V???t'

869

  , constraint constructionlink_PKC primary key (ConstructionCode,FluctuationCode)

870

) comment '?H???????N???' ;

871

872

create index ConstructionLink_Index1

873

  on constructionlink(ConstructionCode);

874

875

create index ConstructionLink_Index2

876

  on constructionlink(FluctuationCode);

877

878

create index ConstructionLink_Index3

879

  on constructionlink(LinkType);

880

881

-- ?H????????

882

--* BackupToTempTable

883

drop table if exists constructionmaterialinfo cascade;

884

885

--* RestoreFromTempTable

886

create table constructionmaterialinfo (

887

  CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????'

888

  , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

889

  , PROCESSDATE datetime default '0000-00-00 00:00:00' not null comment '?????N????'

890

  , RENTCOUNT smallint(5) unsigned comment '??o??'

891

  , REPAYCOUNT smallint(5) unsigned comment '??p??'

892

  , JUNKCOUNT smallint(5) unsigned comment '?j????'

893

  , COMPLETEFLG tinyint(3) unsigned comment '?????t???O'

894

  , ENTRYDATE datetime comment '?o?^???t'

895

  , UPDATEDATE datetime comment '?X?V???t'

896

  , constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE,PROCESSDATE)

897

) comment '?H????????' ;

898

899

-- ????i?????t?f?[?^

900

--* BackupToTempTable

901

drop table if exists constructionprogressdate cascade;

902

903

--* RestoreFromTempTable

904

create table constructionprogressdate (

905

  ConstructionCode decimal(10,0) not null comment '?H?????'

906

  , ConstructionStatusFlg decimal(2,0) not null comment '???H?????'

907

  , PreviousStatusFlg decimal(2,0) comment '??X?O???'

908

  , ChangeDate datetime not null comment '?????t'

909

  , ChangePersonCode decimal(8,0) not null comment '???S????'

910

  , EntryDate datetime not null comment '?o?^???t'

911

  , UpdateDate datetime not null comment '?X?V???t'

912

  , constraint constructionprogressdate_PKC primary key (ConstructionCode,ChangeDate)

913

) comment '????i?????t?f?[?^' ;

914

915

create index ConstrProg_Index1

916

  on constructionprogressdate(ConstructionCode);

917

918

create index ConstrProg_Index2

919

  on constructionprogressdate(ConstructionStatusFlg);

920

921

create index ConstrProg_Index3

922

  on constructionprogressdate(ChangeDate);

923

924

-- ???}?X?^

925

--* BackupToTempTable

926

drop table if exists constructionspecmaster cascade;

927

928

--* RestoreFromTempTable

929

create table constructionspecmaster (

930

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

931

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

932

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

933

  , ItemName varchar(120) comment '??????'

934

  , SpecName varchar(120) comment '??????'

935

  , UnitName varchar(30) comment '?P?????'

936

  , UnitPrice decimal(9,2) not null comment '?P??'

937

  , DeleteFlg decimal(1,0) not null comment '???t???O'

938

  , EntryDate datetime not null comment '?o?^???t'

939

  , UpdateDate datetime not null comment '?X?V???t'

940

  , constraint constructionspecmaster_PKC primary key (ItemCode,SpecCode)

941

) comment '???}?X?^' ;

942

943

create index ConstructionSpecMaster_Index1

944

  on constructionspecmaster(DisplayOrder);

945

946

-- ???P???}?X?^

947

--* BackupToTempTable

948

drop table if exists constructionspecunitprice cascade;

949

950

--* RestoreFromTempTable

951

create table constructionspecunitprice (

952

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

953

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

954

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

955

  , ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h'

956

  , UnitPrice decimal(9,2) not null comment '?P??'

957

  , EntryDate datetime not null comment '?o?^???t'

958

  , UpdateDate datetime not null comment '?X?V???t'

959

  , constraint constructionspecunitprice_PKC primary key (ComponentCode,ItemCode,SpecCode,ConstructionTypeCode)

960

) comment '???P???}?X?^' ;

961

962

-- ?H?????}?X?^

963

--* BackupToTempTable

964

drop table if exists constructiontypemaster cascade;

965

966

--* RestoreFromTempTable

967

create table constructiontypemaster (

968

  TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'

969

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

970

  , NameString varchar(100) not null comment '????'

971

  , PublicFlg decimal(1,0) not null comment '?????t???O'

972

  , RepairFlg decimal(1,0) not null comment '?V?z?E???C?t???O'

973

  , SecRank decimal(1,0) not null comment '?????????N'

974

  , ExpensesLink decimal(1,0) not null comment '?o??g?p??'

975

  , DeleteFlg decimal(1,0) not null comment '???t???O'

976

  , EntryDate datetime not null comment '?o?^???t'

977

  , UpdateDate datetime not null comment '?X?V???t'

978

  , constraint constructiontypemaster_PKC primary key (TypeCode)

979

) comment '?H?????}?X?^' ;

980

981

-- ?????o?[?f?[?^

982

--* BackupToTempTable

983

drop table if exists costdataofdepartment cascade;

984

985

--* RestoreFromTempTable

986

create table costdataofdepartment (

987

  DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

988

  , ConstrYear smallint(5) unsigned not null comment '?H???????E?N??'

989

  , SeqNo decimal(5,0) unsigned not null comment '?f?[?^???'

990

  , CostDate date not null comment '?????t'

991

  , DepartmentName varchar(100) not null comment '??????'

992

  , SuppliersCode decimal(8,0) unsigned not null comment '?o?[??R?[?h'

993

  , SuppliersName varchar(120) comment '?o?[??'

994

  , PaymentContent varchar(100) comment '?o?[???e'

995

  , SendReceiveFlg decimal(1,0) not null comment '?o?[?t???O'

996

  , EntryPrice decimal(12,0) not null comment '???z?i????j'

997

  , EntryTax decimal(12,0) not null comment '???z?i????j'

998

  , Coment varchar(100) comment '???l'

999

  , EntryDate datetime not null comment '?o?^???t'

1000

  , UpdateDate datetime not null comment '?X?V???t'

1001

  , constraint costdataofdepartment_PKC primary key (DepartmentCode,ConstrYear,SeqNo)

1002

) comment '?????o?[?f?[?^' ;

1003

1004

-- ?S??????o??f?[?^

1005

--* BackupToTempTable

1006

drop table if exists costdataofperson cascade;

1007

1008

--* RestoreFromTempTable

1009

create table costdataofperson (

1010

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1011

  , ActionDate date not null comment '?????t'

1012

  , DataType decimal(1,0) not null comment '?f?[?^??'

1013

  , DataAddCount decimal(5,0) unsigned not null comment '?f?[?^??????'

1014

  , TargetMonth varchar(7) not null comment '???N??'

1015

  , ConstructionCode decimal(10,0) unsigned comment '?H???R?[?h'

1016

  , SuppliersCode decimal(5,0) unsigned not null comment '?x????R?[?h'

1017

  , SuppliersName varchar(120) comment '?x??????'

1018

  , PaymentContent varchar(60) comment '?x?????e'

1019

  , PaymentType decimal(1,0) not null comment '?x?????@?t???O'

1020

  , EntryPrice decimal(12,0) not null comment '???z?i????j'

1021

  , EntryPriceInTax decimal(12,0) not null comment '???z?i????j'

1022

  , SlipNumber varchar(12) comment '?`?[???'

1023

  , ComplateFlg decimal(1,0) not null comment '???????t???O'

1024

  , ApprovalFlg decimal(1,0) not null comment '???F?t???O'

1025

  , EntryDate datetime not null comment '?o?^???t'

1026

  , UpdateDate datetime not null comment '?X?V???t'

1027

  , constraint costdataofperson_PKC primary key (PersonCode,ActionDate,DataType,DataAddCount)

1028

) comment '?S??????o??f?[?^' ;

1029

1030

create index CostDataOfPerson_Index1

1031

  on costdataofperson(TargetMonth);

1032

1033

create index CostDataOfPerson_Index2

1034

  on costdataofperson(ConstructionCode);

1035

1036

-- ??????o?^?\???f?[?^

1037

--* BackupToTempTable

1038

drop table if exists costomerregist cascade;

1039

1040

--* RestoreFromTempTable

1041

create table costomerregist (

1042

  CreatePersonCode decimal(8,0) unsigned not null comment '?\??????'

1043

  , CreateDate date not null comment '????'

1044

  , SeqNo decimal(2,0) not null comment '?L?[?A??'

1045

  , DataMode decimal(1,0) not null comment '?f?[?^??'

1046

  , SourceCotegory decimal(5,0) unsigned not null comment '???????'

1047

  , SourceCode decimal(5,0) unsigned not null comment '??????R?[?h'

1048

  , PetitionPeriod decimal(4,0) unsigned not null comment '?????'

1049

  , OrderFlg decimal(1,0) not null comment '?@?l?c??E??l?t???O'

1050

  , CorporateStatusName varchar(100) comment '?@?l?i????'

1051

  , CorporateStatusPoint decimal(1,0) comment '?@?l?i?????u'

1052

  , OrderersName1 varchar(60) not null comment '???????1'

1053

  , OrderersName2 varchar(60) comment '????????Q'

1054

  , DepartmentName varchar(60) comment '??????'

1055

  , PersonName varchar(60) comment '?S?????'

1056

  , ZipCode varchar(8) comment '?X????'

1057

  , Address1 varchar(60) comment '?Z???P'

1058

  , Address2 varchar(60) comment '?Z??2'

1059

  , Address3 varchar(60) comment '?Z??3'

1060

  , PhoneNumber varchar(13) comment '?d?b???'

1061

  , FaxNumber varchar(13) comment 'FAX???'

1062

  , MailAddress varchar(257) comment '???[???A?h???X'

1063

  , Note varchar(300) comment '???l'

1064

  , OrderCotegory decimal(5,0) unsigned not null comment '???????'

1065

  , OrderDate date not null comment '?\????'

1066

  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'

1067

  , CreateDepartmentCode decimal(5,0) unsigned not null comment '?\???????R?[?h'

1068

  , CreateDepartmentName varchar(60) comment '?\????????'

1069

  , EntryDate datetime not null comment '?o?^???t'

1070

  , UpdateDate datetime not null comment '?X?V???t'

1071

  , constraint costomerregist_PKC primary key (CreatePersonCode,CreateDate,SeqNo)

1072

) comment '??????o?^?\???f?[?^' ;

1073

1074

create index CostomerRegist_Index1

1075

  on costomerregist(PetitionPeriod);

1076

1077

create index CostomerRegist_Index2

1078

  on costomerregist(CreatePersonCode);

1079

1080

create index CostomerRegist_Index3

1081

  on costomerregist(CreateDepartmentCode);

1082

1083

-- ????f?[?^

1084

--* BackupToTempTable

1085

drop table if exists dailydataconstruction cascade;

1086

1087

--* RestoreFromTempTable

1088

create table dailydataconstruction (

1089

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1090

  , DailyDataDate date not null comment '???????'

1091

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1092

  , Weather varchar(60) comment '?V?C'

1093

  , EntryDate datetime not null comment '?o?^???t'

1094

  , UpdateDate datetime not null comment '?X?V???t'

1095

  , constraint dailydataconstruction_PKC primary key (PersonCode,DailyDataDate,ConstructionCode)

1096

) comment '????f?[?^' ;

1097

1098

create index DailyDataConstruction_Index1

1099

  on dailydataconstruction(PersonCode);

1100

1101

create index DailyDataConstruction_Index2

1102

  on dailydataconstruction(DailyDataDate);

1103

1104

create index DailyDataConstruction_Index3

1105

  on dailydataconstruction(ConstructionCode);

1106

1107

-- ????f?[?^ (????)

1108

--* BackupToTempTable

1109

drop table if exists dailydatadetail cascade;

1110

1111

--* RestoreFromTempTable

1112

create table dailydatadetail (

1113

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1114

  , DailyDataDate date not null comment '???????'

1115

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1116

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

1117

  , JobCategoryCode decimal(5,0) not null comment '?E??L?['

1118

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

1119

  , TodayHeadCount decimal(4,1) not null comment '?????l????'

1120

  , TotalHeadCount decimal(5,1) not null comment '??v?l????'

1121

  , TodayWork varchar(100) comment '?????????e'

1122

  , NextdayWork varchar(100) comment '?????????e'

1123

  , NextdayHeadCount decimal(4,1) not null comment '?????l????'

1124

  , EntryDate datetime not null comment '?o?^???t'

1125

  , UpdateDate datetime not null comment '?X?V???t'

1126

  , constraint dailydatadetail_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

1127

) comment '????f?[?^ (????)' ;

1128

1129

create index DailyDataDetail_Index

1130

  on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);

1131

1132

-- ????f?[?^ (??????)

1133

--* BackupToTempTable

1134

drop table if exists dailydatafield cascade;

1135

1136

--* RestoreFromTempTable

1137

create table dailydatafield (

1138

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

1139

  , DailyDataDate date not null comment '???????'

1140

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1141

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

1142

  , PatrolTime datetime not null comment '?????'

1143

  , ContentsText varchar(200) comment '???e'

1144

  , EntryDate datetime not null comment '?o?^???t'

1145

  , UpdateDate datetime not null comment '?X?V???t'

1146

  , constraint dailydatafield_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

1147

) comment '????f?[?^ (??????)' ;

1148

1149

create index DailyDataField_Index

1150

  on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);

1151

1152

-- ????f?[?^ (????)

1153

--* BackupToTempTable

1154

drop table if exists dailydatamaterials cascade;

1155

1156

--* RestoreFromTempTable

1157

create table dailydatamaterials (

1158

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

1159

  , DailyDataDate date not null comment '???????'

1160

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1161

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

1162

  , Materials varchar(100) comment '?????'

1163

  , Quantity varchar(100) comment '????'

1164

  , Production varchar(100) comment '??????'

1165

  , Delivery varchar(100) comment '?[?????'

1166

  , QualityControl varchar(100) comment '?i?????????'

1167

  , EntryDate datetime not null comment '?o?^???t'

1168

  , UpdateDate datetime not null comment '?X?V???t'

1169

  , constraint dailydatamaterials_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

1170

) comment '????f?[?^ (????)' ;

1171

1172

create index DailyDataMaterials_Index

1173

  on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);

1174

1175

-- ????f?[?^ (??????w??)

1176

--* BackupToTempTable

1177

drop table if exists dailydatasubcontractors cascade;

1178

1179

--* RestoreFromTempTable

1180

create table dailydatasubcontractors (

1181

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

1182

  , DailyDataDate date not null comment '???????'

1183

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1184

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

1185

  , Attendee varchar(100) comment '?o???'

1186

  , ContentsText varchar(200) comment '???e'

1187

  , EntryDate datetime not null comment '?o?^???t'

1188

  , UpdateDate datetime not null comment '?X?V???t'

1189

  , constraint dailydatasubcontractors_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

1190

) comment '????f?[?^ (??????w??)' ;

1191

1192

create index DailyDataSubcontractors_Index

1193

  on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);

1194

1195

-- ????f?[?^ (???)

1196

--* BackupToTempTable

1197

drop table if exists dailydatavehicles cascade;

1198

1199

--* RestoreFromTempTable

1200

create table dailydatavehicles (

1201

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

1202

  , DailyDataDate date not null comment '???????'

1203

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1204

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

1205

  , Model varchar(100) comment '?@??'

1206

  , Performance varchar(100) comment '???\'

1207

  , Owner varchar(100) comment '???L???'

1208

  , Driver varchar(100) comment '?????^?]??'

1209

  , StartWorkingTime datetime not null comment '??????J?n'

1210

  , EndWorkingTime datetime not null comment '??????I??'

1211

  , EntryDate datetime not null comment '?o?^???t'

1212

  , UpdateDate datetime not null comment '?X?V???t'

1213

  , constraint dailydatavehicles_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

1214

) comment '????f?[?^ (???)' ;

1215

1216

create index DailyDataVehicles_Index

1217

  on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);

1218

1219

-- ???}?X?^

1220

--* BackupToTempTable

1221

drop table if exists daymaster cascade;

1222

1223

--* RestoreFromTempTable

1224

create table daymaster (

1225

  days smallint(6) not null comment '??'

1226

  , constraint daymaster_PKC primary key (days)

1227

) comment '???}?X?^' ;

1228

1229

-- ?????}?X?^

1230

--* BackupToTempTable

1231

drop table if exists deadlinemaster cascade;

1232

1233

--* RestoreFromTempTable

1234

create table deadlinemaster (

1235

  LABOURKIND decimal(1,0) default '0' not null comment '??????'

1236

  , DEADLINE decimal(2,0) comment '????'

1237

  , PAYDAY decimal(2,0) comment '?x????'

1238

  , NOTE varchar(120) comment '???l'

1239

  , DELETEFLG decimal(1,0) comment '???t???O'

1240

  , ENTRYDATE datetime comment '?o?^???t'

1241

  , UPDATEDATE datetime comment '?X?V???t'

1242

  , constraint deadlinemaster_PKC primary key (LABOURKIND)

1243

) comment '?????}?X?^' ;

1244

1245

-- ?????o???}?X?^

1246

--* BackupToTempTable

1247

drop table if exists departmentexpensesmaster cascade;

1248

1249

--* RestoreFromTempTable

1250

create table departmentexpensesmaster (

1251

  DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

1252

  , ExpensesPeriod smallint(6) not null comment '?????'

1253

  , NameCode decimal(5,0) unsigned not null comment '?o??R?[?h'

1254

  , NameString varchar(100) not null comment '????'

1255

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

1256

  , ExpensesRaito decimal(4,2) not null comment '?o??'

1257

  , DeleteFlg decimal(1,0) not null comment '???t???O'

1258

  , EntryDate datetime not null comment '?o?^???t'

1259

  , UpdateDate datetime not null comment '?X?V???t'

1260

  , constraint departmentexpensesmaster_PKC primary key (DepartmentCode,ExpensesPeriod,NameCode)

1261

) comment '?????o???}?X?^' ;

1262

1263

-- ?????}?X?^

1264

--* BackupToTempTable

1265

drop table if exists departmentmaster cascade;

1266

1267

--* RestoreFromTempTable

1268

create table departmentmaster (

1269

  DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

1270

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

1271

  , DepartmentString varchar(100) not null comment '??????'

1272

  , ActionScheduleFlg decimal(1,0) not null comment '?s???\??\???t???O'

1273

  , StaffAssignFlg decimal(1,0) not null comment '?l???z?u?\???t???O'

1274

  , StartDate datetime not null comment '?J?n???t'

1275

  , CompDate datetime not null comment '?I?????t'

1276

  , DeleteFlg decimal(1,0) not null comment '???t???O'

1277

  , EntryDate datetime not null comment '?o?^???t'

1278

  , UpdateDate datetime not null comment '?X?V???t'

1279

  , constraint departmentmaster_PKC primary key (DepartmentCode)

1280

) comment '?????}?X?^' ;

1281

1282

create index DepartmentMaster_index1

1283

  on departmentmaster(DisplayOrder);

1284

1285

-- ?????m?F???F?f?[?^

1286

--* BackupToTempTable

1287

drop table if exists depositapprovalinfo cascade;

1288

1289

--* RestoreFromTempTable

1290

create table depositapprovalinfo (

1291

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

1292

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

1293

  , TARGETDATE decimal(6,0) not null comment '???N??'

1294

  , SEQNO decimal(3,0) not null comment '?A??'

1295

  , LINECOUNT decimal(3,0) not null comment '?s???'

1296

  , APPROVALNO decimal(3,0) not null comment '???F????'

1297

  , APPROVALPERSON decimal(8,0) comment '???F??R?[?h'

1298

  , APPROVALPERSONNAME varchar(20) comment '???F???'

1299

  , APPROVALAUTHORITY decimal(1,0) comment '???F??????'

1300

  , APPROVALDATE date comment '???F???t'

1301

  , ENTRYDATE datetime comment '?o?^???t'

1302

  , UPDATEDATE datetime comment '?X?V???t'

1303

  , constraint depositapprovalinfo_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)

1304

) comment '?????m?F???F?f?[?^' ;

1305

1306

-- ?????f?[?^

1307

--* BackupToTempTable

1308

drop table if exists depositdata cascade;

1309

1310

--* RestoreFromTempTable

1311

create table depositdata (

1312

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

1313

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

1314

  , TARGETDATE decimal(6,0) not null comment '???N??'

1315

  , SEQNO decimal(3,0) not null comment '?A??'

1316

  , BUSINESSPERIOD decimal(4,0) comment '?c???'

1317

  , DEPOSITDATE date comment '??????'

1318

  , DEPOSITAMOUNT decimal(12,0) comment '???????z'

1319

  , DEPOSITAMOUNTCASH decimal(10,0) comment '???????z?i?????j'

1320

  , DEPOSITAMOUNTBILL decimal(10,0) comment '???????z?i??`?j'

1321

  , DEPOSITPERSONCODE decimal(8,0) not null comment '?????S????R?[?h'

1322

  , NOTE varchar(120) comment '???l'

1323

  , ENTRYDATE datetime comment '?o?^???t'

1324

  , UPDATEDATE datetime comment '?X?V???t'

1325

  , constraint depositdata_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO)

1326

) comment '?????f?[?^' ;

1327

1328

-- ????????f?[?^

1329

--* BackupToTempTable

1330

drop table if exists depositdatadetail cascade;

1331

1332

--* RestoreFromTempTable

1333

create table depositdatadetail (

1334

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

1335

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

1336

  , TARGETDATE decimal(6,0) not null comment '???N??'

1337

  , REQUESTNO decimal(10,0) not null comment '????No'

1338

  , ORDERNO decimal(2,0) comment '??t???'

1339

  , DEPOSITAMOUNT decimal(10,0) comment '???????z'

1340

  , DISCOUNTAMOUNT decimal(10,0) comment '?l???????z'

1341

  , CNSTRPRICE decimal(10,0) comment '?????'

1342

  , FEES decimal(10,0) comment '????'

1343

  , OTHERADJUSTMENTS decimal(10,0) comment '?????'

1344

  , DIFFERENCEAMOUNT decimal(10,0) comment '????'

1345

  , CONFIRMATIONPERSONCODE decimal(8,0) comment '?m?F?S????R?[?h'

1346

  , CONFIRMATIONDATE date comment '?S????m?F???t'

1347

  , CONFIRMATIONENDFLG decimal(1,0) comment '?m?F?????t???O'

1348

  , NOTE varchar(120) comment '???l'

1349

  , ENTRYDATE datetime comment '?o?^???t'

1350

  , UPDATEDATE datetime comment '?X?V???t'

1351

  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO)

1352

) comment '????????f?[?^' ;

1353

1354

-- ???}?X?^

1355

--* BackupToTempTable

1356

drop table if exists divisionmaster cascade;

1357

1358

--* RestoreFromTempTable

1359

create table divisionmaster (

1360

  DivisionCode decimal(5,0) unsigned not null comment '???R?[?h'

1361

  , NameCode decimal(5,0) unsigned not null comment '????R?[?h'

1362

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

1363

  , NameString varchar(100) not null comment '????'

1364

  , DeleteFlg decimal(1,0) not null comment '???t???O'

1365

  , EntryDate datetime not null comment '?o?^???t'

1366

  , UpdateDate datetime not null comment '?X?V???t'

1367

  , constraint divisionmaster_PKC primary key (DivisionCode,NameCode)

1368

) comment '???}?X?^' ;

1369

1370

-- ??Z?\?Z???f?[?^

1371

--* BackupToTempTable

1372

drop table if exists estimatebudget cascade;

1373

1374

--* RestoreFromTempTable

1375

create table estimatebudget (

1376

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1377

  , ConstructionTime decimal(5,2) unsigned not null comment '?H??'

1378

  , IntegratedCode decimal(8,0) not null comment '??Z??'

1379

  , DataCreateDate datetime not null comment '?f?[?^??????'

1380

  , RetValue1 decimal(12,0) not null comment '?\???i'

1381

  , RetValue2 decimal(12,0) not null comment '????H????'

1382

  , RetValue3 decimal(12,0) not null comment '????????????'

1383

  , RetValue4 decimal(12,0) not null comment '????????????'

1384

  , RetPercent decimal(5,2) not null comment '???????'

1385

  , EntryDate datetime not null comment '?o?^???t'

1386

  , UpdateDate datetime not null comment '?X?V???t'

1387

  , constraint estimatebudget_PKC primary key (ConstructionCode)

1388

) comment '??Z?\?Z???f?[?^' ;

1389

1390

-- ??Z?\?Z????f?[?^????

1391

--* BackupToTempTable

1392

drop table if exists estimatebudgetdetail cascade;

1393

1394

--* RestoreFromTempTable

1395

create table estimatebudgetdetail (

1396

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1397

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

1398

  , LineCount decimal(3,0) unsigned not null comment '?s???'

1399

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

1400

  , ItemCode decimal(5,0) unsigned comment '?H??L?['

1401

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

1402

  , FirstString varchar(120) comment '???????'

1403

  , SecondString varchar(120) comment '?H????E???????'

1404

  , Content varchar(120) comment '???e'

1405

  , EstimatePrice decimal(12,0) not null comment '????????z'

1406

  , NegotiationPrice decimal(12,0) not null comment '????????z'

1407

  , Notes varchar(120) comment '???????'

1408

  , EntryDate datetime not null comment '?o?^???t'

1409

  , UpdateDate datetime not null comment '?X?V???t'

1410

  , constraint estimatebudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

1411

) comment '??Z?\?Z????f?[?^????' ;

1412

1413

-- ??Z????f?[?^

1414

--* BackupToTempTable

1415

drop table if exists estimatedata cascade;

1416

1417

--* RestoreFromTempTable

1418

create table estimatedata (

1419

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1420

  , LineCount decimal(3,0) unsigned not null comment '?s???'

1421

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

1422

  , FixedItemCode varchar(1) comment '?????L?['

1423

  , ItemName varchar(120) comment '??????'

1424

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

1425

  , PriceValue decimal(14,0) not null comment '???z'

1426

  , note varchar(60) comment '???l'

1427

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

1428

  , InputFlg decimal(1,0) not null comment '????t???O'

1429

  , EntryDate datetime not null comment '?o?^???t'

1430

  , UpdateDate datetime not null comment '?X?V???t'

1431

  , constraint estimatedata_PKC primary key (ConstructionCode,LineCount)

1432

) comment '??Z????f?[?^' ;

1433

1434

create index EstimateData_Index1

1435

  on estimatedata(ConstructionCode,FixedItemCode);

1436

1437

-- ??Z????y?[?W?f?[?^

1438

--* BackupToTempTable

1439

drop table if exists estimatedatabody cascade;

1440

1441

--* RestoreFromTempTable

1442

create table estimatedatabody (

1443

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1444

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

1445

  , Category decimal(1,0) not null comment '?y?[?W??'

1446

  , UnionComponentCode decimal(5,0) unsigned not null comment '?????\???L?['

1447

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

1448

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

1449

  , SelectComponent decimal(5,0) unsigned not null comment '?I???\???L?['

1450

  , PageTitle varchar(120) not null comment '?y?[?W?\????'

1451

  , DetailLineCount decimal(3,0) unsigned not null comment '????s???'

1452

  , EntryDate datetime not null comment '?o?^???t'

1453

  , UpdateDate datetime not null comment '?X?V???t'

1454

  , constraint estimatedatabody_PKC primary key (ConstructionCode,PageCount)

1455

) comment '??Z????y?[?W?f?[?^' ;

1456

1457

create index EstimateDataBody_Index1

1458

  on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);

1459

1460

-- ??Z????f?[?^????

1461

--* BackupToTempTable

1462

drop table if exists estimatedatadetail cascade;

1463

1464

--* RestoreFromTempTable

1465

create table estimatedatadetail (

1466

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1467

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

1468

  , LineCount decimal(3,0) unsigned not null comment '?s???'

1469

  , DataType decimal(1,0) not null comment '?f?[?^???'

1470

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

1471

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

1472

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

1473

  , ItemName varchar(120) comment '??????'

1474

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

1475

  , Unitcount decimal(8,2) not null comment '????'

1476

  , UnitName varchar(30) comment '?P?????'

1477

  , UnitPrice decimal(9,2) not null comment '?P??'

1478

  , LineTotal decimal(12,0) not null comment '???z'

1479

  , note varchar(60) comment '???l'

1480

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

1481

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

1482

  , InputFlg decimal(1,0) comment '????t???O'

1483

  , EntryDate datetime not null comment '?o?^???t'

1484

  , UpdateDate datetime not null comment '?X?V???t'

1485

  , constraint estimatedatadetail_PKC primary key (ConstructionCode,PageCount,LineCount)

1486

) comment '??Z????f?[?^????' ;

1487

1488

create index EstimateDataDetail_Index1

1489

  on estimatedatadetail(ConstructionCode,PageCount);

1490

1491

-- ?o???}?X?^

1492

--* BackupToTempTable

1493

drop table if exists expensesmaster cascade;

1494

1495

--* RestoreFromTempTable

1496

create table expensesmaster (

1497

  DivisionCode smallint(6) not null comment '?H?????R?[?h'

1498

  , NameCode smallint(6) not null comment '?o????R?[?h'

1499

  , DisplayOrder smallint(6) not null comment '?\????'

1500

  , ExpensesRatio decimal(4,2) not null comment '?o??'

1501

  , DeleteFlg decimal(1,0) not null comment '???t???O'

1502

  , EntryDate datetime not null comment '?o?^???t'

1503

  , UpdateDate datetime not null comment '?X?V???t'

1504

  , constraint expensesmaster_PKC primary key (DivisionCode,NameCode)

1505

) comment '?o???}?X?^' ;

1506

1507

-- ???x???}?X?^

1508

--* BackupToTempTable

1509

drop table if exists holidaycalendermaster cascade;

1510

1511

--* RestoreFromTempTable

1512

create table holidaycalendermaster (

1513

  Holiday date not null comment '?x??'

1514

  , BusinessYear smallint(5) unsigned not null comment '?c??N?x'

1515

  , TargetMonth tinyint(3) unsigned not null comment '?Y????'

1516

  , TargetDay tinyint(3) unsigned not null comment '?Y????'

1517

  , constraint holidaycalendermaster_PKC primary key (Holiday)

1518

) comment '???x???}?X?^' ;

1519

1520

create index HolidayCalender_Index1

1521

  on holidaycalendermaster(BusinessYear);

1522

1523

create index HolidayCalenderMaster_Index2

1524

  on holidaycalendermaster(TargetMonth);

1525

1526

create index HolidayCalenderMaster_Index3

1527

  on holidaycalendermaster(TargetDay);

1528

1529

-- ?????????????

1530

--* BackupToTempTable

1531

drop table if exists inputsearchlogdata cascade;

1532

1533

--* RestoreFromTempTable

1534

create table inputsearchlogdata (

1535

  ConstructionCode decimal(10,0) not null comment '?H???R?[?h'

1536

  , UsedProcessNo decimal(4,0) not null comment '?g?p?@?\???'

1537

  , DisplayOrder decimal(4,0) unsigned not null comment '?\????'

1538

  , DataType decimal(1,0) not null comment '?f?[?^???'

1539

  , InputCode decimal(10,0) comment '????R?[?h'

1540

  , constraint inputsearchlogdata_PKC primary key (ConstructionCode,UsedProcessNo,DisplayOrder)

1541

) comment '?????????????' ;

1542

1543

create index InputSearchLogData_Index1

1544

  on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);

1545

1546

-- ???????f?[?^

1547

--* BackupToTempTable

1548

drop table if exists invoicedata cascade;

1549

1550

--* RestoreFromTempTable

1551

create table invoicedata (

1552

  INVOICENO decimal(9,0) not null comment '??????No'

1553

  , ORDERERSDIVISION decimal(5,0) not null comment '???????'

1554

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

1555

  , REQUESTMONTH decimal(6,0) not null comment '??????'

1556

  , SEQNO decimal(2,0) not null comment '?A??'

1557

  , CRETATEDATE date not null comment '????'

1558

  , REQUESTDATE date not null comment '??????'

1559

  , REQUESTNAME varchar(120) comment '??????'

1560

  , TOTALAMOUNT decimal(10,0) comment '???????v???z'

1561

  , TAXAMOUNT decimal(10,0) comment '???????z'

1562

  , COMMENT1 varchar(60) comment '?R?????g1'

1563

  , COMMENT2 varchar(60) comment '?R?????g2'

1564

  , COMMENT3 varchar(60) not null comment '?R?????g3'

1565

  , COMMENT4 varchar(60) not null comment '?R?????g4'

1566

  , COMMENT5 varchar(60) not null comment '?R?????g5'

1567

  , COMPLETEFLG decimal(1,0) default '0' not null comment '?????t???O'

1568

  , ENTRYDATE datetime not null comment '?o?^?N????'

1569

  , UPDATEDATE datetime not null comment '?X?V?N????'

1570

  , constraint invoicedata_PKC primary key (INVOICENO)

1571

) comment '???????f?[?^' ;

1572

1573

alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;

1574

1575

-- ??????

1576

--* BackupToTempTable

1577

drop table if exists materialinfo cascade;

1578

1579

--* RestoreFromTempTable

1580

create table materialinfo (

1581

  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

1582

  , MATERIALCOUNT smallint(5) unsigned comment '?????'

1583

  , RENTCOUNT smallint(5) unsigned comment '??o??\??'

1584

  , DELETEFLG smallint(5) unsigned comment '???t???O'

1585

  , ENTRYDATE datetime comment '?o?^???t'

1586

  , UPDATEDATE datetime comment '?X?V???t'

1587

  , constraint materialinfo_PKC primary key (MATERIALITEMCODE)

1588

) comment '??????' ;

1589

1590

-- ????i??}?X?^

1591

--* BackupToTempTable

1592

drop table if exists materialitemmaster cascade;

1593

1594

--* RestoreFromTempTable

1595

create table materialitemmaster (

1596

  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

1597

  , MATERIALKINDCODE smallint(5) unsigned comment '??????R?[?h'

1598

  , MATERIALITEMNAME varchar(40) comment '????i?????'

1599

  , DISPLAYORDER smallint(5) unsigned comment '?\????'

1600

  , DELETEFLG tinyint(3) unsigned comment '???t???O'

1601

  , ENTRYDATE datetime comment '?o?^???t'

1602

  , UPDATEDATE datetime comment '?X?V???t'

1603

  , VERSIONNO decimal(8,0) default '0' not null comment '?o?[?W???????'

1604

  , constraint materialitemmaster_PKC primary key (MATERIALITEMCODE)

1605

) comment '????i??}?X?^' ;

1606

1607

-- ??????}?X?^

1608

--* BackupToTempTable

1609

drop table if exists materialkindmaster cascade;

1610

1611

--* RestoreFromTempTable

1612

create table materialkindmaster (

1613

  MATERIALKINDCODE smallint(5) unsigned default 0 not null comment '??????R?[?h'

1614

  , MATERIALKINDNAME varchar(40) comment '?????????'

1615

  , DISPLAYORDER smallint(5) unsigned comment '?\????'

1616

  , DELETEFLG tinyint(3) unsigned comment '???t???O'

1617

  , ENTRYDATE datetime comment '?o?^???t'

1618

  , UPDATEDATE datetime comment '?X?V???t'

1619

  , constraint materialkindmaster_PKC primary key (MATERIALKINDCODE)

1620

) comment '??????}?X?^' ;

1621

1622

-- ??????????

1623

--* BackupToTempTable

1624

drop table if exists materialrecordinfo cascade;

1625

1626

--* RestoreFromTempTable

1627

create table materialrecordinfo (

1628

  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

1629

  , PROCESSDATE date default '0000-00-00' not null comment '?????N????'

1630

  , SEQNO smallint(5) unsigned default 0 not null comment '?A??'

1631

  , RECKIND tinyint(3) unsigned comment '???R?[?h??'

1632

  , CONSTRUCTIONCODE int(10) unsigned comment '?H?????'

1633

  , PERSONCODE int(10) unsigned comment '?S????R?[?h'

1634

  , MATERIALCOUNT smallint(5) unsigned comment '?????'

1635

  , REPAYPLANDATE date comment '??p?\??N????'

1636

  , COMMENTTEXT varchar(80) comment '?R?????g'

1637

  , ENTRYDATE datetime comment '?o?^???t'

1638

  , UPDATEDATE datetime comment '?X?V???t'

1639

  , constraint materialrecordinfo_PKC primary key (MATERIALITEMCODE,PROCESSDATE,SEQNO)

1640

) comment '??????????' ;

1641

1642

-- ?f??????b?Z?[?W

1643

--* BackupToTempTable

1644

drop table if exists messageboarddata cascade;

1645

1646

--* RestoreFromTempTable

1647

create table messageboarddata (

1648

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

1649

  , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'

1650

  , FromCode decimal(8,0) unsigned not null comment '???????R?[?h'

1651

  , FromName varchar(60) not null comment '???????'

1652

  , MessageTitile varchar(100) comment '?`???^?C?g??'

1653

  , MessageContent varchar(1333) not null comment '?`?????e'

1654

  , LinkType decimal(2,0) not null comment '?????N????^?C?v'

1655

  , LinkMessage varchar(200) comment '?????N??????'

1656

  , LinkCode varchar(30) comment '?????N?L?['

1657

  , WritingDate datetime not null comment '?????????'

1658

  , PersonCode decimal(8,0) not null comment '??????S????R?[?h'

1659

  , ShareFlag decimal(2,0) not null comment '???????t???O'

1660

  , MessageColor varchar(8) comment '?????F'

1661

  , BackColor varchar(8) comment '?o?b?N?J???['

1662

  , MessageFlag decimal(1,0) not null comment '???b?Z?[?W?t???O'

1663

  , EntryDate datetime not null comment '?o?^???t'

1664

  , UpdateDate datetime not null comment '?X?V???t'

1665

  , constraint messageboarddata_PKC primary key (RecordNumber,BranchNumber)

1666

) comment '?f??????b?Z?[?W' ;

1667

1668

create index MessageBoardData_Index1

1669

  on messageboarddata(WritingDate);

1670

1671

create index MessageBoardData_Index2

1672

  on messageboarddata(MessageFlag);

1673

1674

-- ?f???????e?[?u??

1675

--* BackupToTempTable

1676

drop table if exists messageboardterget cascade;

1677

1678

--* RestoreFromTempTable

1679

create table messageboardterget (

1680

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

1681

  , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'

1682

  , SeqNum decimal(3,0) unsigned not null comment '????'

1683

  , ToCode decimal(8,0) not null comment '????R?[?h'

1684

  , ToName varchar(60) not null comment '????'

1685

  , EntryDate datetime not null comment '?o?^???t'

1686

  , UpdateDate datetime not null comment '?X?V???t'

1687

  , constraint messageboardterget_PKC primary key (RecordNumber,BranchNumber,SeqNum)

1688

) comment '?f???????e?[?u??' ;

1689

1690

create index MessageBoardTerget_Index1

1691

  on messageboardterget(RecordNumber,BranchNumber);

1692

1693

-- ?f??????b?Z?[?W?{??????

1694

--* BackupToTempTable

1695

drop table if exists messagebrowsinghistory cascade;

1696

1697

--* RestoreFromTempTable

1698

create table messagebrowsinghistory (

1699

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

1700

  , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'

1701

  , SeqNum decimal(3,0) unsigned not null comment '????'

1702

  , BrowsingCode decimal(8,0) not null comment '?{????R?[?h'

1703

  , BrowsingDate datetime not null comment '?{?????t'

1704

  , EntryDate datetime not null comment '?o?^???t'

1705

  , UpdateDate datetime not null comment '?X?V???t'

1706

  , constraint messagebrowsinghistory_PKC primary key (RecordNumber,BranchNumber,SeqNum)

1707

) comment '?f??????b?Z?[?W?{??????' ;

1708

1709

-- ???}?X?^

1710

--* BackupToTempTable

1711

drop table if exists monthmaster cascade;

1712

1713

--* RestoreFromTempTable

1714

create table monthmaster (

1715

  month smallint(6) not null comment '??'

1716

  , constraint monthmaster_PKC primary key (month)

1717

) comment '???}?X?^' ;

1718

1719

-- ??????}?X?^

1720

--* BackupToTempTable

1721

drop table if exists orderersmaster cascade;

1722

1723

--* RestoreFromTempTable

1724

create table orderersmaster (

1725

  OrderCotegory decimal(5,0) unsigned not null comment '???????'

1726

  , OrderersCode decimal(5,0) unsigned not null comment '??????R?[?h'

1727

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

1728

  , OrderFlg decimal(1,0) not null comment '?@?l?c??E??l?t???O'

1729

  , CorporateStatusName varchar(100) comment '?@?l?i????'

1730

  , CorporateStatusPoint decimal(1,0) comment '?@?l?i?????u'

1731

  , OrderersName1 varchar(60) not null comment '???????1'

1732

  , OrderersName2 varchar(60) comment '????????Q'

1733

  , DepartmentName varchar(60) comment '??????'

1734

  , ChargePersonName varchar(60) comment '?S?????'

1735

  , ZipCode varchar(8) comment '?X????'

1736

  , Address1 varchar(60) comment '?Z???P'

1737

  , Address2 varchar(60) comment '?Z??2'

1738

  , Address3 varchar(60) comment '?Z??3'

1739

  , PhoneNumber varchar(13) comment '?d?b???'

1740

  , FaxNumber varchar(13) comment 'FAX???'

1741

  , MailAddress varchar(257) comment '???[???A?h???X'

1742

  , Note varchar(300) comment '???l'

1743

  , DeleteFlg decimal(1,0) not null comment '???t???O'

1744

  , EntryDate datetime not null comment '?o?^???t'

1745

  , UpdateDate datetime not null comment '?X?V???t'

1746

  , constraint orderersmaster_PKC primary key (OrderCotegory,OrderersCode)

1747

) comment '??????}?X?^' ;

1748

1749

-- ????z?f?[?^

1750

--* BackupToTempTable

1751

drop table if exists orderspricedata cascade;

1752

1753

--* RestoreFromTempTable

1754

create table orderspricedata (

1755

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1756

  , ChangeNo decimal(3,0) unsigned not null comment '??X???'

1757

  , ChangeDate date not null comment '??X??'

1758

  , ChangePersonCode decimal(8,0) unsigned not null comment '??X??R?[?h'

1759

  , ChangePersonName varchar(60) comment '??X???'

1760

  , BeforeValue decimal(14,0) not null comment '??X?O???????z'

1761

  , BeforeValueInTax decimal(14,0) not null comment '??X?O???????z'

1762

  , AfterValue decimal(14,0) not null comment '??X????????z'

1763

  , AfterValueInTax decimal(14,0) not null comment '??X????????z'

1764

  , ChangeComment varchar(200) comment '??X???R'

1765

  , EntryDate datetime not null comment '?o?^???t'

1766

  , UpdateDate datetime not null comment '?X?V???t'

1767

  , constraint orderspricedata_PKC primary key (ConstructionCode,ChangeNo)

1768

) comment '????z?f?[?^' ;

1769

1770

-- ?x?????F???f?[?^

1771

--* BackupToTempTable

1772

drop table if exists paymentapprovalinfo cascade;

1773

1774

--* RestoreFromTempTable

1775

create table paymentapprovalinfo (

1776

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

1777

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

1778

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

1779

  , LINECOUNT decimal(3,0) default '0' not null comment '?s???'

1780

  , APPROVALNO decimal(3,0) default '0' not null comment '???F????'

1781

  , APPROVALPERSON decimal(8,0) comment '???F??R?[?h'

1782

  , APPROVALPERSONNAME varchar(20) comment '???F???'

1783

  , APPROVALAUTHORITY decimal(1,0) comment '???F??????'

1784

  , APPROVALDATE date comment '???F???t'

1785

  , ENTRYDATE datetime comment '?o?^???t'

1786

  , UPDATEDATE datetime comment '?X?V???t'

1787

  , constraint paymentapprovalinfo_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)

1788

) comment '?x?????F???f?[?^' ;

1789

1790

-- ?x??????f?[?^

1791

--* BackupToTempTable

1792

drop table if exists paymentdatadetail cascade;

1793

1794

--* RestoreFromTempTable

1795

create table paymentdatadetail (

1796

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

1797

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

1798

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

1799

  , LINECOUNT decimal(3,0) default '0' not null comment '?s???'

1800

  , BILLPRICE decimal(10,0) comment '???????z'

1801

  , DISCOUNTPRICE decimal(10,0) comment '?l???????z'

1802

  , OFFSETPRICE decimal(10,0) comment '???E???z'

1803

  , NEXTCOPRICE decimal(10,0) comment '????J?z'

1804

  , HIGHWPRICE decimal(10,0) comment '??????'

1805

  , HARDWPRICE decimal(10,0) comment '??????'

1806

  , INDSWASTETAX decimal(10,0) comment '?Y?p??'

1807

  , CNSTRPRICE decimal(10,0) comment '?????'

1808

  , CNSTRPRICEEXIST decimal(1,0) comment '??????L??'

1809

  , APPROVALPERSONCODE decimal(8,0) comment '???F?S????R?[?h'

1810

  , APPROVALDATE date comment '?S??????F???t'

1811

  , APPROVALENDFLG decimal(1,0) comment '???F?????t???O'

1812

  , ENTRYDATE datetime comment '?o?^???t'

1813

  , UPDATEDATE datetime comment '?X?V???t'

1814

  , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)

1815

) comment '?x??????f?[?^' ;

1816

1817

create index PayDataDetail_Index1

1818

  on paymentdatadetail(TARGETDATE);

1819

1820

create index PayDataDetail_Index2

1821

  on paymentdatadetail(APPROVALPERSONCODE);

1822

1823

-- ?H??????????f?[?^

1824

--* BackupToTempTable

1825

drop table if exists periodavoidance cascade;

1826

1827

--* RestoreFromTempTable

1828

create table periodavoidance (

1829

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1830

  , ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'

1831

  , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'

1832

  , EntryDate datetime not null comment '?o?^???t'

1833

  , UpdateDate datetime not null comment '?X?V???t'

1834

  , constraint periodavoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo)

1835

) comment '?H??????????f?[?^' ;

1836

1837

create index PeriodAvoidance_Index1

1838

  on periodavoidance(ConstructionCode);

1839

1840

create index PeriodAvoidance_Index2

1841

  on periodavoidance(ConstructionStatusFlg);

1842

1843

create index PeriodAvoidance_Index3

1844

  on periodavoidance(FieldNo);

1845

1846

-- ?S??????F?f?[?^

1847

--* BackupToTempTable

1848

drop table if exists personapproval cascade;

1849

1850

--* RestoreFromTempTable

1851

create table personapproval (

1852

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1853

  , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

1854

  , OrderDate date not null comment '??t??'

1855

  , OrderNo decimal(2,0) unsigned not null comment '??t???'

1856

  , SeqNo decimal(2,0) not null comment '?}??'

1857

  , PersonCodeApproval decimal(8,0) unsigned not null comment '?\???E???F??R?[?h'

1858

  , PetitionApprovalDate datetime not null comment '?\???E???F???t'

1859

  , ApprovalLimitDates datetime not null comment '???F??]??'

1860

  , ApprovalStatus decimal(1,0) not null comment '???F???'

1861

  , InputComment varchar(300) comment '?R?????g'

1862

  , EntryDate datetime not null comment '?o?^???t'

1863

  , UpdateDate datetime not null comment '?X?V???t'

1864

  , constraint personapproval_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,SeqNo)

1865

) comment '?S??????F?f?[?^' ;

1866

1867

-- ?S??????F?R?????g?f?[?^

1868

--* BackupToTempTable

1869

drop table if exists personapprovalcomment cascade;

1870

1871

--* RestoreFromTempTable

1872

create table personapprovalcomment (

1873

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1874

  , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

1875

  , OrderDate date not null comment '??t??'

1876

  , OrderNo decimal(2,0) unsigned not null comment '??t???'

1877

  , CommentNo decimal(2,0) not null comment '?R?????g???'

1878

  , ParentNo decimal(2,0) not null comment '?e?R?????g???'

1879

  , ApproValComment varchar(300) comment '?w???E?A???R?????g'

1880

  , EntryDate datetime not null comment '?o?^???t'

1881

  , UpdateDate datetime not null comment '?X?V???t'

1882

  , constraint personapprovalcomment_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,CommentNo)

1883

) comment '?S??????F?R?????g?f?[?^' ;

1884

1885

-- ?S??????????}?X?^

1886

--* BackupToTempTable

1887

drop table if exists persondepartmentmaster cascade;

1888

1889

--* RestoreFromTempTable

1890

create table persondepartmentmaster (

1891

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1892

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

1893

  , AffiliationFlg decimal(1,0) not null comment '?????t???O'

1894

  , EntryDate datetime not null comment '?o?^???t'

1895

  , UpdateDate datetime not null comment '?X?V???t'

1896

  , constraint persondepartmentmaster_PKC primary key (PersonCode,DepartmentCode)

1897

) comment '?S??????????}?X?^' ;

1898

1899

create index PersonDepartmentMaster_Index1

1900

  on persondepartmentmaster(PersonCode);

1901

1902

create index PersonDepartmentMaster_Index2

1903

  on persondepartmentmaster(DepartmentCode);

1904

1905

-- ?S????}?X?^

1906

--* BackupToTempTable

1907

drop table if exists personinchargemaster cascade;

1908

1909

--* RestoreFromTempTable

1910

create table personinchargemaster (

1911

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1912

  , DisplayOrder decimal(8,0) unsigned not null comment '?\????'

1913

  , PersonName varchar(60) not null comment '?S?????'

1914

  , StartDate date not null comment '?g?p?J?n?N????'

1915

  , EndDate date comment '?g?p?I???N????'

1916

  , PassWord varchar(16) comment '?p?X???[?h'

1917

  , SecurityManagement decimal(1,0) not null comment '?@????'

1918

  , SecCode decimal(2,0) unsigned not null comment '???????'

1919

  , MsgBackColor varchar(8) comment '???b?Z?[?W?w?i?F'

1920

  , DisplayString varchar(20) comment '?\???E???????'

1921

  , DepartmentCode decimal(5,0) unsigned comment '?????R?[?h'

1922

  , MonthlySalary decimal(11,0) not null comment '???????z'

1923

  , YearSalary decimal(12,0) not null comment '?N????z'

1924

  , Qualification varchar(120) comment '???i?????'

1925

  , SealPrintName varchar(5) comment '???\????'

1926

  , EmployeeClassFlg decimal(1,0) not null comment '?????'

1927

  , LedgerFlg decimal(1,0) not null comment '???v?Z???t???O'

1928

  , CommutingDistance decimal(5,2) not null comment '??????'

1929

  , CommuteCosts decimal(5,0) not null comment '??????'

1930

  , DeleteFlg decimal(1,0) not null comment '???t???O'

1931

  , EntryDate datetime not null comment '?o?^???t'

1932

  , UpdateDate datetime not null comment '?X?V???t'

1933

  , constraint personinchargemaster_PKC primary key (PersonCode)

1934

) comment '?S????}?X?^' ;

1935

1936

create index PersonInChargeMaster_Index1

1937

  on personinchargemaster(StartDate);

1938

1939

create index PersonInChargeMaster_Index2

1940

  on personinchargemaster(DepartmentCode);

1941

1942

-- ?S??????^?}?X?^

1943

--* BackupToTempTable

1944

drop table if exists personsalarymaster cascade;

1945

1946

--* RestoreFromTempTable

1947

create table personsalarymaster (

1948

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

1949

  , StartDate date not null comment '?g?p?J?n?N????'

1950

  , MonthlySalary decimal(11,0) not null comment '???????z'

1951

  , YearSalary decimal(12,0) not null comment '?N????z'

1952

  , EntryDate datetime not null comment '?o?^???t'

1953

  , UpdateDate datetime not null comment '?X?V???t'

1954

  , constraint personsalarymaster_PKC primary key (PersonCode,StartDate)

1955

) comment '?S??????^?}?X?^' ;

1956

1957

create index PersonSalaryMaster_Index1

1958

  on personsalarymaster(PersonCode);

1959

1960

create index PersonSalaryMaster_Index2

1961

  on personsalarymaster(StartDate);

1962

1963

create index PersonSalaryMaster_Index3

1964

  on personsalarymaster(MonthlySalary);

1965

1966

-- ?w???????f?[?^

1967

--* BackupToTempTable

1968

drop table if exists pointingoutcomment cascade;

1969

1970

--* RestoreFromTempTable

1971

create table pointingoutcomment (

1972

  ConstructionCode decimal(10,0) not null comment '?H???R?[?h'

1973

  , ProcessNo smallint(6) not null comment '????????i??????j'

1974

  , SeqNo smallint(6) not null comment '????'

1975

  , PageCount smallint(6) not null comment '?y?[?W???'

1976

  , PersonCode decimal(8,0) not null comment '?L????R?[?h'

1977

  , DrowColor varchar(8) comment '?`??F'

1978

  , CommentMessage varchar(1000) comment '???b?Z?[?W'

1979

  , StartPointX smallint(6) not null comment '?w?E?????u?w'

1980

  , StartPointY smallint(6) not null comment '?w?E?????u?x'

1981

  , CurrentPointX smallint(6) not null comment '??????u?w'

1982

  , CurrentPointY smallint(6) not null comment '??????u?x'

1983

  , CurrentWidth smallint(6) not null comment '?\???T?C?YWidth'

1984

  , CurrentHeight smallint(6) not null comment '?\???T?C?YHeigth'

1985

  , EntryDate datetime not null comment '?o?^???t'

1986

  , UpdateDate datetime not null comment '?X?V???t'

1987

  , constraint pointingoutcomment_PKC primary key (ConstructionCode,ProcessNo,SeqNo)

1988

) comment '?w???????f?[?^' ;

1989

1990

-- ?????????????c???^?f?[?^

1991

--* BackupToTempTable

1992

drop table if exists proceedingsdata cascade;

1993

1994

--* RestoreFromTempTable

1995

create table proceedingsdata (

1996

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

1997

  , ProceedingsDataDate date not null comment '?c???^????'

1998

  , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'

1999

  , EndMeetingTime decimal(4,0) unsigned not null comment '??c????I??'

2000

  , CreatorCode decimal(8,0) not null comment '????R?[?h'

2001

  , PalceFlag decimal(1,0) not null comment '???n?t???O'

2002

  , MeetingPalce varchar(120) comment '???????'

2003

  , EntryDate datetime not null comment '?o?^???t'

2004

  , UpdateDate datetime not null comment '?X?V???t'

2005

  , constraint proceedingsdata_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime)

2006

) comment '?????????????c???^?f?[?^' ;

2007

2008

-- ?????????????c???^?f?[?^?i?o???j

2009

--* BackupToTempTable

2010

drop table if exists proceedingsdataattend cascade;

2011

2012

--* RestoreFromTempTable

2013

create table proceedingsdataattend (

2014

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2015

  , ProceedingsDataDate date not null comment '?c???^????'

2016

  , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'

2017

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

2018

  , Department varchar(20) comment '?o??????'

2019

  , AttendName varchar(10) comment '?o??????'

2020

  , EntryDate datetime not null comment '?o?^???t'

2021

  , UpdateDate datetime not null comment '?X?V???t'

2022

  , constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)

2023

) comment '?????????????c???^?f?[?^?i?o???j' ;

2024

2025

-- ?????????????c???^?f?[?^?i????j

2026

--* BackupToTempTable

2027

drop table if exists proceedingsdatadetail cascade;

2028

2029

--* RestoreFromTempTable

2030

create table proceedingsdatadetail (

2031

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2032

  , ProceedingsDataDate date not null comment '?c???^????'

2033

  , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'

2034

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

2035

  , TitleNo varchar(5) comment '?c????'

2036

  , Title varchar(20) comment '?c??'

2037

  , ContentsText varchar(50) comment '???e'

2038

  , EntryDate datetime not null comment '?o?^???t'

2039

  , UpdateDate datetime not null comment '?X?V???t'

2040

  , constraint proceedingsdatadetail_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)

2041

) comment '?????????????c???^?f?[?^?i????j' ;

2042

2043

-- ???F?f?[?^

2044

--* BackupToTempTable

2045

drop table if exists processapproval cascade;

2046

2047

--* RestoreFromTempTable

2048

create table processapproval (

2049

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2050

  , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

2051

  , OrderNo decimal(2,0) unsigned not null comment '??t???'

2052

  , SeqNo decimal(2,0) not null comment '?}??'

2053

  , PersonCode decimal(8,0) unsigned not null comment '?\???E???F??R?[?h'

2054

  , PetitionApprovalDate datetime not null comment '?\???E???F???t'

2055

  , ApprovalLimitDates datetime not null comment '???F??]??'

2056

  , ApprovalStatus decimal(1,0) not null comment '???F???'

2057

  , InputComment varchar(300) comment '?R?????g'

2058

  , EntryDate datetime not null comment '?o?^???t'

2059

  , UpdateDate datetime not null comment '?X?V???t'

2060

  , constraint processapproval_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SeqNo)

2061

) comment '???F?f?[?^' ;

2062

2063

-- ???F?R?????g?f?[?^

2064

--* BackupToTempTable

2065

drop table if exists processapprovalcomment cascade;

2066

2067

--* RestoreFromTempTable

2068

create table processapprovalcomment (

2069

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2070

  , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

2071

  , OrderNo decimal(2,0) unsigned not null comment '??t???'

2072

  , CommentNo decimal(2,0) not null comment '?R?????g???'

2073

  , ParentNo decimal(2,0) not null comment '?e?R?????g???'

2074

  , ApproValComment varchar(300) comment '?w???E?A???R?????g'

2075

  , EntryDate datetime not null comment '?o?^???t'

2076

  , UpdateDate datetime not null comment '?X?V???t'

2077

  , constraint processapprovalcomment_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,CommentNo)

2078

) comment '???F?R?????g?f?[?^' ;

2079

2080

-- ???F????f?[?^

2081

--* BackupToTempTable

2082

drop table if exists processapprovaldetail cascade;

2083

2084

--* RestoreFromTempTable

2085

create table processapprovaldetail (

2086

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2087

  , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

2088

  , OrderNo decimal(2,0) unsigned not null comment '??t???'

2089

  , SerialNo decimal(2,0) unsigned not null comment '?}??'

2090

  , LinkCode decimal(10,0) not null comment '?????N???'

2091

  , EntryDate datetime not null comment '?o?^???t'

2092

  , UpdateDate datetime not null comment '?X?V???t'

2093

  , constraint processapprovaldetail_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SerialNo)

2094

) comment '???F????f?[?^' ;

2095

2096

-- ?N?????}?X?^

2097

--* BackupToTempTable

2098

drop table if exists processexcutemaster cascade;

2099

2100

--* RestoreFromTempTable

2101

create table processexcutemaster (

2102

  SecCode decimal(2,0) unsigned not null comment '???????'

2103

  , ExecCode decimal(4,0) unsigned not null comment '?N?????????'

2104

  , EditFlg decimal(1,0) not null comment '??W?t???O'

2105

  , EntryDate datetime not null comment '?o?^???t'

2106

  , UpdateDate datetime not null comment '?X?V???t'

2107

  , constraint processexcutemaster_PKC primary key (SecCode,ExecCode)

2108

) comment '?N?????}?X?^' ;

2109

2110

create index ProcessExcuteMaster_Index1

2111

  on processexcutemaster(SecCode);

2112

2113

create index ProcessExcuteMaster_Index2

2114

  on processexcutemaster(ExecCode);

2115

2116

-- ???????f?[?^

2117

--* BackupToTempTable

2118

drop table if exists purchaseorder cascade;

2119

2120

--* RestoreFromTempTable

2121

create table purchaseorder (

2122

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2123

  , SeqNo decimal(3,0) unsigned not null comment '???????}??'

2124

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

2125

  , CreateDate date comment '?????t'

2126

  , OrderPrice decimal(12,0) not null comment '???????z'

2127

  , LastRowStringDate date not null comment '??I?s?\?????t'

2128

  , OrderSheetType decimal(1,0) not null comment '???E?{???t???O'

2129

  , PaymentTerms decimal(1,0) not null comment '?x????????'

2130

  , CashRatio decimal(4,1) not null comment '?????????i???j'

2131

  , BillPeriod decimal(4,0) not null comment '??`????'

2132

  , PrePayments decimal(1,0) not null comment '?O????'

2133

  , PrePaymentsDays decimal(3,0) not null comment '?O????????'

2134

  , PrePaymentsPrice decimal(12,0) not null comment '?O???????z'

2135

  , PartialPayment decimal(1,0) not null comment '??????'

2136

  , PartialPaymentMounth decimal(2,0) unsigned not null comment '???????????'

2137

  , PartialPaymentDay1 decimal(2,0) unsigned not null comment '???????????'

2138

  , PartialPaymentDay2 decimal(2,0) unsigned not null comment '???????x????'

2139

  , PartialPaymentPrice decimal(12,0) not null comment '?????????z'

2140

  , CompletionPayment decimal(1,0) not null comment '???n??????x??'

2141

  , CompletionPaymentDays decimal(3,0) unsigned not null comment '???n??????x??????'

2142

  , CompletionPaymentPrice decimal(12,0) not null comment '???n??????x?????z'

2143

  , LeadEngineerCode decimal(8,0) comment '??C?Z?p??R?[?h'

2144

  , LeadEngineerName varchar(60) comment '??C?Z?p???'

2145

  , SafetyOfficerCode decimal(8,0) comment '???S?????R?[?h'

2146

  , SafetyOfficerName varchar(60) comment '???S??????'

2147

  , WorkersCount decimal(3,0) unsigned comment '??????'

2148

  , PrintoutDate date not null comment '????N????'

2149

  , EntryDate datetime not null comment '?o?^???t'

2150

  , UpdateDate datetime not null comment '?X?V???t'

2151

  , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)

2152

) comment '???????f?[?^' ;

2153

2154

-- ?????????t?f?[?^

2155

--* BackupToTempTable

2156

drop table if exists purchaseorderdate cascade;

2157

2158

--* RestoreFromTempTable

2159

create table purchaseorderdate (

2160

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2161

  , SeqNo decimal(3,0) unsigned not null comment '???????}??'

2162

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

2163

  , SendDate date not null comment '???????X????'

2164

  , ReturnDate date not null comment '???????????'

2165

  , ReturnCheckDate date not null comment '??????????m?F??'

2166

  , EntryDate datetime not null comment '?o?^???t'

2167

  , UpdateDate datetime not null comment '?X?V???t'

2168

  , constraint purchaseorderdate_PKC primary key (ConstructionCode,SeqNo)

2169

) comment '?????????t?f?[?^' ;

2170

2171

-- ??????????f?[?^

2172

--* BackupToTempTable

2173

drop table if exists purchaseorderdetail cascade;

2174

2175

--* RestoreFromTempTable

2176

create table purchaseorderdetail (

2177

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2178

  , SeqNo decimal(3,0) unsigned not null comment '???????}??'

2179

  , GroupCount decimal(1,0) not null comment '?O???[?v???'

2180

  , LineCount decimal(3,0) unsigned not null comment '?s???'

2181

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

2182

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

2183

  , FirstString varchar(120) comment '?H??E?i??'

2184

  , SecondString varchar(120) comment '???e????'

2185

  , UnitCount decimal(8,2) not null comment '????'

2186

  , UnitName varchar(30) comment '?P??'

2187

  , UnitPrice decimal(10,0) not null comment '?P??'

2188

  , OrdersLinePrice decimal(12,0) comment '???z'

2189

  , SourceCode decimal(10,0) unsigned not null comment '???H?????'

2190

  , SourceDetailCnt decimal(4,0) unsigned not null comment '????????'

2191

  , DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O'

2192

  , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'

2193

  , EntryDate datetime not null comment '?o?^???t'

2194

  , UpdateDate datetime not null comment '?X?V???t'

2195

  , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)

2196

) comment '??????????f?[?^' ;

2197

2198

create index POrderDetail_Index1

2199

  on purchaseorderdetail(SourceCode);

2200

2201

-- ???R?[?h??????

2202

--* BackupToTempTable

2203

drop table if exists recordkey cascade;

2204

2205

--* RestoreFromTempTable

2206

create table recordkey (

2207

  KeyNo decimal(2,0) unsigned not null comment '?L?[?R?[?h'

2208

  , RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

2209

  , EntryDate datetime not null comment '?o?^???t'

2210

  , UpdateDate datetime not null comment '?X?V???t'

2211

  , constraint recordkey_PKC primary key (KeyNo,RecordNumber)

2212

) comment '???R?[?h??????' ;

2213

2214

-- ?????????f?[?^

2215

--* BackupToTempTable

2216

drop table if exists reminvoicedata cascade;

2217

2218

--* RestoreFromTempTable

2219

create table reminvoicedata (

2220

  InvoiceNo decimal(9,0) not null comment '??????No'

2221

  , RemPerson decimal(8,0) not null comment '???S????R?[?h'

2222

  , RemDate date not null comment '?????t'

2223

  , RemComment varchar(300) comment '?????R'

2224

  , EntryDate datetime not null comment '?o?^?N????'

2225

  , UpdateDate datetime not null comment '?X?V?N????'

2226

  , constraint reminvoicedata_PKC primary key (InvoiceNo)

2227

) comment '?????????f?[?^' ;

2228

2229

-- ????????????f?[?^

2230

--* BackupToTempTable

2231

drop table if exists reminvoicedatadetail cascade;

2232

2233

--* RestoreFromTempTable

2234

create table reminvoicedatadetail (

2235

  InvoiceNo decimal(9,0) not null comment '??????No'

2236

  , SeqNo smallint(5) unsigned not null comment '?A??'

2237

  , RequestNo decimal(9,0) not null comment '????No'

2238

  , EntryDate datetime not null comment '?o?^?N????'

2239

  , UpdateDate datetime not null comment '?X?V?N????'

2240

  , constraint reminvoicedatadetail_PKC primary key (InvoiceNo,SeqNo)

2241

) comment '????????????f?[?^' ;

2242

2243

-- ?????f?[?^

2244

--* BackupToTempTable

2245

drop table if exists requestdata cascade;

2246

2247

--* RestoreFromTempTable

2248

create table requestdata (

2249

  REQUESTNO decimal(9,0) not null comment '????No'

2250

  , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '?{?H?????'

2251

  , CONSTRUCTIONNAME varchar(120) not null comment '?H??????'

2252

  , CONTRACTAMOUNT decimal(10,0) not null comment '???????z'

2253

  , PAIDAMOUNT decimal(10,0) not null comment '????????z'

2254

  , REQUESTAMOUNT0 decimal(10,0) not null comment '???????z?O'

2255

  , REQUESTAMOUNT1 decimal(10,0) not null comment '???????z?P'

2256

  , REQUESTAMOUNT2 decimal(10,0) comment '???????z?Q'

2257

  , REQUESTAMOUNT3 decimal(10,0) comment '???????z?R'

2258

  , REQUESTAMOUNT4 decimal(10,0) comment '???????z?S'

2259

  , REQUESTAMOUNT5 decimal(10,0) comment '???????z?T'

2260

  , REQUESTAMOUNT6 decimal(10,0) comment '???????z?U'

2261

  , UNCLAIMEDAMOUNT decimal(10,0) not null comment '?????c???z'

2262

  , UNPAIDAMOUNT decimal(10,0) not null comment '?????????z'

2263

  , TAXAMOUNT decimal(10,0) not null comment '?????'

2264

  , NOTE varchar(120) not null comment '???l'

2265

  , ENTRYDATE datetime not null comment '?o?^?N????'

2266

  , UPDATEDATE datetime not null comment '?X?V?N????'

2267

  , constraint requestdata_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE)

2268

) comment '?????f?[?^' ;

2269

2270

-- ?????f?[?^????

2271

--* BackupToTempTable

2272

drop table if exists requestdatadetail cascade;

2273

2274

--* RestoreFromTempTable

2275

create table requestdatadetail (

2276

  REQUESTNO decimal(9,0) not null comment '????No'

2277

  , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '?{?H?????'

2278

  , CONSTRUCTIONCODE decimal(10,0) not null comment '?H?????'

2279

  , CONSTRUCTIONKIND decimal(1,0) not null comment '?H????'

2280

  , REQUESTAMOUNT decimal(10,0) not null comment '???????z'

2281

  , TAXAMOUNT decimal(10,0) not null comment '?????'

2282

  , ENTRYDATE datetime not null comment '?o?^?N????'

2283

  , UPDATEDATE datetime not null comment '?X?V?N????'

2284

  , constraint requestdatadetail_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE,CONSTRUCTIONCODE,CONSTRUCTIONKIND)

2285

) comment '?????f?[?^????' ;

2286

2287

-- ?????w?b?_

2288

--* BackupToTempTable

2289

drop table if exists requesthead cascade;

2290

2291

--* RestoreFromTempTable

2292

create table requesthead (

2293

  REQUESTNO decimal(9,0) not null comment '????No'

2294

  , REQCONSTRUCTIONCODE decimal(10,0) not null comment '?????H?????'

2295

  , ORDERNO decimal(2,0) not null comment '??t???'

2296

  , REQUESTMONTH decimal(6,0) not null comment '??????'

2297

  , ORDERERSDIVISION decimal(5,0) not null comment '???????'

2298

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

2299

  , ORDERERSNAME varchar(120) not null comment '???????'

2300

  , REQCONSTRUCTIONNAME varchar(120) not null comment '?????H??????'

2301

  , REQUESTTOTALAMOUNT decimal(10,0) not null comment '???????z???v'

2302

  , REQUESTAMOUNT decimal(10,0) not null comment '???????z'

2303

  , TAXAMOUNT decimal(10,0) not null comment '?????'

2304

  , UNPAIDAMOUNT decimal(10,0) comment '??????'

2305

  , NOTE varchar(120) comment '???l'

2306

  , ASSIGNEDFLG decimal(1,0) comment '??????t???O'

2307

  , INVOICENO decimal(9,0) not null comment '??????No'

2308

  , ENTRYDATE datetime not null comment '?o?^?N????'

2309

  , UPDATEDATE datetime not null comment '?X?V?N????'

2310

  , constraint requesthead_PKC primary key (REQUESTNO)

2311

) comment '?????w?b?_' ;

2312

2313

alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;

2314

2315

-- ?????????t?f?[?^

2316

--* BackupToTempTable

2317

drop table if exists requestorderdate cascade;

2318

2319

--* RestoreFromTempTable

2320

create table requestorderdate (

2321

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2322

  , InvoiceNo decimal(9,0) not null comment '??????No'

2323

  , SendDate date not null comment '???????????X????'

2324

  , EntryDate datetime not null comment '?o?^???t'

2325

  , UpdateDate datetime not null comment '?X?V???t'

2326

  , constraint requestorderdate_PKC primary key (ConstructionCode,InvoiceNo)

2327

) comment '?????????t?f?[?^' ;

2328

2329

-- ????O???t?f?[?^

2330

--* BackupToTempTable

2331

drop table if exists salesgraphdata cascade;

2332

2333

--* RestoreFromTempTable

2334

create table salesgraphdata (

2335

  GraphDataCode decimal(8,0) not null comment '?O???t?f?[?^?R?[?h'

2336

  , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'

2337

  , SalesDataDays date not null comment '????N??'

2338

  , DisplayOrder decimal(8,0) unsigned not null comment '?\????'

2339

  , DataName varchar(100) not null comment '?f?[?^?\??????'

2340

  , SalesAmount decimal(10,0) not null comment '????f?[?^'

2341

  , AdministrativeExpense decimal(10,0) not null comment '???E?????o??'

2342

  , GrossProfit decimal(10,0) not null comment '?e???v'

2343

  , NetIncome decimal(10,0) not null comment '?????v(???v)'

2344

  , EntryDate datetime not null comment '?o?^???t'

2345

  , UpdateDate datetime not null comment '?X?V???t'

2346

  , constraint salesgraphdata_PKC primary key (GraphDataCode,ConstructionPeriod,SalesDataDays)

2347

) comment '????O???t?f?[?^' ;

2348

2349

create index SalesGraphData_Idx1

2350

  on salesgraphdata(DisplayOrder);

2351

2352

create index SalesGraphData_idx2

2353

  on salesgraphdata(ConstructionPeriod);

2354

2355

-- ?????}?X?^

2356

--* BackupToTempTable

2357

drop table if exists securitymaster cascade;

2358

2359

--* RestoreFromTempTable

2360

create table securitymaster (

2361

  SecCode decimal(2,0) unsigned not null comment '???????'

2362

  , DisplayOrder decimal(2,0) not null comment '?\????'

2363

  , SecName varchar(60) not null comment '????????'

2364

  , SecRank decimal(1,0) not null comment '?????????N'

2365

  , SecRange decimal(1,0) not null comment '???????'

2366

  , GeneralAffairs decimal(1,0) not null comment '????????t???O'

2367

  , SelectBackColor varchar(8) not null comment '?I??w?i?F'

2368

  , EntryDate datetime not null comment '?o?^???t'

2369

  , UpdateDate datetime not null comment '?X?V???t'

2370

  , constraint securitymaster_PKC primary key (SecCode)

2371

) comment '?????}?X?^' ;

2372

2373

create index SecurityMaster_Index1

2374

  on securitymaster(DisplayOrder);

2375

2376

create index SecurityMaster_Index2

2377

  on securitymaster(SecRank);

2378

2379

create index SecurityMaster_Index3

2380

  on securitymaster(SecRange);

2381

2382

-- ???S?p?g???[???f?[?^

2383

--* BackupToTempTable

2384

drop table if exists sfpdata cascade;

2385

2386

--* RestoreFromTempTable

2387

create table sfpdata (

2388

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2389

  , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'

2390

  , RequestDate datetime not null comment '?p?g???[???v??????'

2391

  , PersonCode decimal(8,0) unsigned not null comment '?\????R?[?h'

2392

  , StringValue varchar(300) comment '?R?????g'

2393

  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'

2394

  , EntryDate datetime not null comment '?o?^???t'

2395

  , UpdateDate datetime not null comment '?X?V???t'

2396

  , constraint sfpdata_PKC primary key (ConstructionCode,DataCount)

2397

) comment '???S?p?g???[???f?[?^' ;

2398

2399

create index SFPData_Index1

2400

  on sfpdata(RequestDate);

2401

2402

-- ???S?p?g???[??????f?[?^

2403

--* BackupToTempTable

2404

drop table if exists sfpdatadetail cascade;

2405

2406

--* RestoreFromTempTable

2407

create table sfpdatadetail (

2408

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

2409

  , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'

2410

  , SeqNo decimal(2,0) unsigned not null comment '?f?[?^?}??'

2411

  , CompanyCode decimal(8,0) unsigned not null comment '??????R?[?h'

2412

  , EntryDate datetime not null comment '?o?^???t'

2413

  , UpdateDate datetime not null comment '?X?V???t'

2414

  , constraint sfpdatadetail_PKC primary key (ConstructionCode,DataCount,SeqNo)

2415

) comment '???S?p?g???[??????f?[?^' ;

2416

2417

-- ??????{?H?H??o?^?\???f?[?^

2418

--* BackupToTempTable

2419

drop table if exists subconstrjobitemregist cascade;

2420

2421

--* RestoreFromTempTable

2422

create table subconstrjobitemregist (

2423

  PersonCode decimal(8,0) unsigned not null comment '?\??????'

2424

  , CreateDate date not null comment '????'

2425

  , SeqNo decimal(2,0) unsigned not null comment '?\???A??'

2426

  , DisplayOrder decimal(8,0) unsigned not null comment '?\????'

2427

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

2428

  , EntryDate datetime not null comment '?o?^???t'

2429

  , UpdateDate datetime not null comment '?X?V???t'

2430

  , constraint subconstrjobitemregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)

2431

) comment '??????{?H?H??o?^?\???f?[?^' ;

2432

2433

-- ??????E?????N?o?^?\???f?[?^

2434

--* BackupToTempTable

2435

drop table if exists subconstrjoblinkregist cascade;

2436

2437

--* RestoreFromTempTable

2438

create table subconstrjoblinkregist (

2439

  PersonCode decimal(8,0) unsigned not null comment '?\??????'

2440

  , CreateDate date not null comment '????'

2441

  , SeqNo decimal(2,0) unsigned not null comment '?\???A??'

2442

  , DisplayOrder decimal(8,0) unsigned not null comment '?\????'

2443

  , JobCategoryCode decimal(5,0) not null comment '?E??L?['

2444

  , EntryDate datetime not null comment '?o?^???t'

2445

  , UpdateDate datetime not null comment '?X?V???t'

2446

  , constraint subconstrjoblinkregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)

2447

) comment '??????E?????N?o?^?\???f?[?^' ;

2448

2449

-- ??????o?^?\???f?[?^

2450

--* BackupToTempTable

2451

drop table if exists subconstrregist cascade;

2452

2453

--* RestoreFromTempTable

2454

create table subconstrregist (

2455

  PersonCode decimal(8,0) unsigned not null comment '?\??????'

2456

  , CreateDate date not null comment '????'

2457

  , SeqNo decimal(2,0) unsigned not null comment '?\???A??'

2458

  , DataMode decimal(1,0) comment '?f?[?^??'

2459

  , SourceCode decimal(8,0) not null comment '??????R?[?h'

2460

  , PetitionPeriod decimal(4,0) unsigned not null comment '?\???N?x'

2461

  , CorporateStatusName varchar(40) comment '?@?l?i????'

2462

  , CorporateStatusPoint decimal(1,0) not null comment '?@?l?i?????u'

2463

  , CompanyName varchar(100) not null comment '???????'

2464

  , CEOPositionName varchar(60) comment '??\???E??'

2465

  , CEOName varchar(60) comment '??\?????'

2466

  , ContactPersonName varchar(60) comment '?S???????'

2467

  , ZipCode varchar(8) comment '?X????'

2468

  , Address1 varchar(60) comment '?Z???P'

2469

  , Address2 varchar(60) comment '?Z??2'

2470

  , Address3 varchar(60) comment '?Z??3'

2471

  , CellPhoneNumber varchar(13) comment '?g??d?b???'

2472

  , MailAddress varchar(257) comment '???[???A?h???X'

2473

  , PhoneNumber varchar(13) comment '?d?b???'

2474

  , FaxNumber varchar(13) comment 'FAX???'

2475

  , JapaneseSyllabary varchar(2) comment '50?????'

2476

  , StartDate date not null comment '????J?n?N????'

2477

  , Note varchar(300) comment '???l'

2478

  , labourKind decimal(1,0) not null comment '?x???????E????'

2479

  , OrderDate date comment '?\????'

2480

  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'

2481

  , EntryDate datetime not null comment '?o?^???t'

2482

  , UpdateDate datetime not null comment '?X?V???t'

2483

  , constraint subconstrregist_PKC primary key (PersonCode,CreateDate,SeqNo)

2484

) comment '??????o?^?\???f?[?^' ;

2485

2486

-- ??????H??}?X?^

2487

--* BackupToTempTable

2488

drop table if exists subcontractoritemmaster cascade;

2489

2490

--* RestoreFromTempTable

2491

create table subcontractoritemmaster (

2492

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

2493

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2494

  , ItemName varchar(120) not null comment '?H????'

2495

  , DeleteFlg decimal(1,0) not null comment '???t???O'

2496

  , EntryDate datetime not null comment '?o?^???t'

2497

  , UpdateDate datetime not null comment '?X?V???t'

2498

  , constraint subcontractoritemmaster_PKC primary key (ItemCode)

2499

) comment '??????H??}?X?^' ;

2500

2501

-- ??????E??}?X?^

2502

--* BackupToTempTable

2503

drop table if exists subcontractorjobcategory cascade;

2504

2505

--* RestoreFromTempTable

2506

create table subcontractorjobcategory (

2507

  JobCategoryCode decimal(5,0) not null comment '?E??L?['

2508

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2509

  , JobCategoryName varchar(120) not null comment '?E????'

2510

  , DeleteFlg decimal(1,0) not null comment '???t???O'

2511

  , EntryDate datetime not null comment '?o?^???t'

2512

  , UpdateDate datetime not null comment '?X?V???t'

2513

  , constraint subcontractorjobcategory_PKC primary key (JobCategoryCode)

2514

) comment '??????E??}?X?^' ;

2515

2516

-- ??????{?H?H??f?[?^

2517

--* BackupToTempTable

2518

drop table if exists subcontractorjobitem cascade;

2519

2520

--* RestoreFromTempTable

2521

create table subcontractorjobitem (

2522

  CompanyCode decimal(8,0) not null comment '??????R?[?h'

2523

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

2524

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2525

  , EntryDate datetime not null comment '?o?^???t'

2526

  , UpdateDate datetime not null comment '?X?V???t'

2527

  , constraint subcontractorjobitem_PKC primary key (CompanyCode,ItemCode)

2528

) comment '??????{?H?H??f?[?^' ;

2529

2530

create index SubContractorJobItem_Index1

2531

  on subcontractorjobitem(CompanyCode);

2532

2533

create index SubContractorJobItem_Index2

2534

  on subcontractorjobitem(ItemCode);

2535

2536

-- ??????E?????N?}?X?^

2537

--* BackupToTempTable

2538

drop table if exists subcontractorjoblink cascade;

2539

2540

--* RestoreFromTempTable

2541

create table subcontractorjoblink (

2542

  CompanyCode decimal(8,0) not null comment '??????R?[?h'

2543

  , JobCategoryCode decimal(5,0) not null comment '?E??L?['

2544

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2545

  , EntryDate datetime not null comment '?o?^???t'

2546

  , UpdateDate datetime not null comment '?X?V???t'

2547

  , constraint subcontractorjoblink_PKC primary key (CompanyCode,JobCategoryCode)

2548

) comment '??????E?????N?}?X?^' ;

2549

2550

create index SubContractorJobLink_Index1

2551

  on subcontractorjoblink(CompanyCode);

2552

2553

create index SubContractorJobLink_Index2

2554

  on subcontractorjoblink(JobCategoryCode);

2555

2556

-- ??????}?X?^

2557

--* BackupToTempTable

2558

drop table if exists subcontractormaster cascade;

2559

2560

--* RestoreFromTempTable

2561

create table subcontractormaster (

2562

  CompanyCode decimal(8,0) not null comment '??????R?[?h'

2563

  , DisplayOrder decimal(8,0) unsigned not null comment '?\????'

2564

  , CorporateStatusName varchar(40) comment '?@?l?i????'

2565

  , CorporateStatusPoint decimal(1,0) not null comment '?@?l?i?????u'

2566

  , CompanyName varchar(100) not null comment '???????'

2567

  , CEOPositionName varchar(60) comment '??\???E??'

2568

  , CEOName varchar(60) comment '??\?????'

2569

  , ContactPersonName varchar(60) comment '?S???????'

2570

  , ZipCode varchar(8) comment '?X????'

2571

  , Address1 varchar(60) comment '?Z???P'

2572

  , Address2 varchar(60) comment '?Z??2'

2573

  , Address3 varchar(60) comment '?Z??3'

2574

  , CellPhoneNumber varchar(13) comment '?g??d?b???'

2575

  , MailAddress varchar(257) comment '???[???A?h???X'

2576

  , PhoneNumber varchar(13) comment '?d?b???'

2577

  , FaxNumber varchar(13) comment 'FAX???'

2578

  , JapaneseSyllabary varchar(2) comment '50?????'

2579

  , StartDate date not null comment '????J?n?N????'

2580

  , Note varchar(300) comment '???l'

2581

  , labourKind decimal(1,0) not null comment '?x???????E????'

2582

  , DeleteFlg decimal(1,0) default '0' not null comment '???t???O'

2583

  , EntryDate datetime not null comment '?o?^???t'

2584

  , UpdateDate datetime not null comment '?X?V???t'

2585

  , constraint subcontractormaster_PKC primary key (CompanyCode)

2586

) comment '??????}?X?^' ;

2587

2588

create index SubContractorMaster_Index1

2589

  on subcontractormaster(JapaneseSyllabary);

2590

2591

-- ?d????}?X?^

2592

--* BackupToTempTable

2593

drop table if exists suppliersmaster cascade;

2594

2595

--* RestoreFromTempTable

2596

create table suppliersmaster (

2597

  SuppliersCode decimal(5,0) unsigned not null comment '?d????R?[?h'

2598

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2599

  , SuppliersName1 varchar(60) not null comment '?d????1'

2600

  , SuppliersName2 varchar(60) comment '?d?????Q'

2601

  , ZipCode varchar(8) comment '?X????'

2602

  , Address1 varchar(60) comment '?Z???P'

2603

  , Address2 varchar(60) comment '?Z??2'

2604

  , Address3 varchar(60) comment '?Z??3'

2605

  , PhoneNumber varchar(13) comment '?d?b???'

2606

  , FaxNumber varchar(13) comment 'FAX???'

2607

  , Note varchar(300) comment '???l'

2608

  , DeleteFlg decimal(1,0) not null comment '???t???O'

2609

  , EntryDate datetime not null comment '?o?^???t'

2610

  , UpdateDate datetime not null comment '?X?V???t'

2611

  , constraint suppliersmaster_PKC primary key (SuppliersCode)

2612

) comment '?d????}?X?^' ;

2613

2614

-- ?V?X?e???N???m?F?f?[?^

2615

--* BackupToTempTable

2616

drop table if exists systemexecute cascade;

2617

2618

--* RestoreFromTempTable

2619

create table systemexecute (

2620

  PrimaryCode tinyint(4) not null comment '?L?[????'

2621

  , TargetDate date not null comment '?N?????t'

2622

  , SystemVersion int(11) not null comment '?{??E????o?[?W????'

2623

  , UpDateCopyVersion int(11) not null comment '?R?s?[?o?[?W????'

2624

  , EntryDate datetime not null comment '?o?^???t'

2625

  , UpdateDate datetime not null comment '?X?V???t'

2626

  , constraint systemexecute_PKC primary key (PrimaryCode)

2627

) comment '?V?X?e???N???m?F?f?[?^' ;

2628

2629

-- ????}?X?^

2630

--* BackupToTempTable

2631

drop table if exists systemmaster cascade;

2632

2633

--* RestoreFromTempTable

2634

create table systemmaster (

2635

  SystemCode decimal(3,0) unsigned not null comment '???R?[?h'

2636

  , CompanyName1 varchar(60) not null comment '?????P'

2637

  , CompanyName2 varchar(60) comment '?????Q'

2638

  , CEOName varchar(60) not null comment '??\?????'

2639

  , CEOPositionName varchar(60) comment '??\???E??'

2640

  , ZipCode varchar(8) not null comment '?X????'

2641

  , Address1 varchar(60) not null comment '?Z???P'

2642

  , Address2 varchar(60) comment '?Z??2'

2643

  , Address3 varchar(60) comment '?Z??3'

2644

  , PhoneNumber varchar(13) not null comment '?d?b???'

2645

  , FaxNumber varchar(13) comment 'FAX???'

2646

  , HomePageURL varchar(120) comment '?z?[???y?[?WURL'

2647

  , ConsumptionTax decimal(4,2) not null comment '?????'

2648

  , CooperationRate decimal(4,2) not null comment '???????'

2649

  , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'

2650

  , FuelPrice decimal(5,2) not null comment '?R???L???P??'

2651

  , AreaDistance decimal(5,2) not null comment '????u????????'

2652

  , ExcelSavePath varchar(120) comment 'Excel????p?X'

2653

  , BusinessPeriod smallint(6) not null comment '????c?????'

2654

  , ConstrYear smallint(6) not null comment '????H???N?x'

2655

  , BusinessBeginDate datetime not null comment '?c????????'

2656

  , ConstrBeginDate datetime not null comment '?H???N?x?????'

2657

  , BusinessCompDate datetime not null comment '?c?????????'

2658

  , ConstrCompDate datetime not null comment '?H???N?x??????'

2659

  , ConstructionNoBase decimal(1,0) not null comment '?H????????l'

2660

  , SloganString1 varchar(100) comment '?W??1'

2661

  , SloganString2 varchar(100) comment '?W??2'

2662

  , SloganString3 varchar(100) comment '?W??3'

2663

  , EntryDate datetime not null comment '?o?^???t'

2664

  , UpdateDate datetime not null comment '?X?V???t'

2665

  , constraint systemmaster_PKC primary key (SystemCode)

2666

) comment '????}?X?^' ;

2667

2668

-- ?????}?X?^

2669

--* BackupToTempTable

2670

drop table if exists termmaster cascade;

2671

2672

--* RestoreFromTempTable

2673

create table termmaster (

2674

  ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'

2675

  , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'

2676

  , SeqNo decimal(2,0) not null comment '?}??'

2677

  , DisplayOrder decimal(2,0) not null comment '?\????'

2678

  , CheckSchdule decimal(1,0) not null comment '?`?F?b?N?^?C?~???O'

2679

  , TermDays decimal(3,0) not null comment '?o???'

2680

  , SendTitile varchar(100) comment '?^?C?g??'

2681

  , SendMessage varchar(100) comment '???b?Z?[?W'

2682

  , BackColor varchar(8) comment '?w?i?F'

2683

  , ForeColor varchar(8) comment '?????F'

2684

  , EntryDate datetime not null comment '?o?^???t'

2685

  , UpdateDate datetime not null comment '?X?V???t'

2686

  , constraint termmaster_PKC primary key (ConstructionStatusFlg,FieldNo,SeqNo)

2687

) comment '?????}?X?^' ;

2688

2689

create index TermMaster_Index1

2690

  on termmaster(DisplayOrder);

2691

2692

-- ?o?????f?[?^

2693

--* BackupToTempTable

2694

drop table if exists tranceportdailydata cascade;

2695

2696

--* RestoreFromTempTable

2697

create table tranceportdailydata (

2698

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

2699

  , AttendanceDate date not null comment '???????'

2700

  , StartDistance decimal(7,1) not null comment '?????o???L????'

2701

  , ComplateDistance decimal(7,1) not null comment '?????I???L????'

2702

  , TotalDistance decimal(6,1) not null comment '???????v?L????'

2703

  , OfficeGoFlg decimal(1,0) not null comment '???????o??t???O'

2704

  , OfficeOutFlg decimal(1,0) not null comment '???????A??t???O'

2705

  , TrancePayGoFlg decimal(1,0) not null comment '?L?????o??t???O'

2706

  , TrancePayOutFlg decimal(1,0) not null comment '?L?????A??t???O'

2707

  , WareHouseFlg decimal(1,0) not null comment '????u??t???O'

2708

  , EntryDate datetime not null comment '?o?^???t'

2709

  , UpdateDate datetime not null comment '?X?V???t'

2710

  , constraint tranceportdailydata_PKC primary key (PersonCode,AttendanceDate)

2711

) comment '?o?????f?[?^' ;

2712

2713

create index TranceportDailyData_Index1

2714

  on tranceportdailydata(AttendanceDate);

2715

2716

-- ?H?????o???}?X?^

2717

--* BackupToTempTable

2718

drop table if exists typeexpensesmaster cascade;

2719

2720

--* RestoreFromTempTable

2721

create table typeexpensesmaster (

2722

  TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'

2723

  , ExpensesPeriod smallint(6) not null comment '?????'

2724

  , NameCode decimal(5,0) unsigned not null comment '?o????R?[?h'

2725

  , ExpensesRaito decimal(4,2) not null comment '?o??'

2726

  , DeleteFlg decimal(1,0) not null comment '???t???O'

2727

  , EntryDate datetime not null comment '?o?^???t'

2728

  , UpdateDate datetime not null comment '?X?V???t'

2729

  , constraint typeexpensesmaster_PKC primary key (TypeCode,ExpensesPeriod,NameCode)

2730

) comment '?H?????o???}?X?^' ;

2731

2732

-- ?P??}?X?^

2733

--* BackupToTempTable

2734

drop table if exists unitmaster cascade;

2735

2736

--* RestoreFromTempTable

2737

create table unitmaster (

2738

  UnitKey decimal(5,0) unsigned not null comment '?P??L?['

2739

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2740

  , UnitName varchar(30) not null comment '?P?????'

2741

  , EntryDate datetime not null comment '?o?^???t'

2742

  , UpdateDate datetime not null comment '?X?V???t'

2743

  , constraint unitmaster_PKC primary key (UnitKey)

2744

) comment '?P??}?X?^' ;

2745

2746

create index UnitMaster_Index1

2747

  on unitmaster(DisplayOrder);

2748

2749

-- ????}?X?^

2750

--* BackupToTempTable

2751

drop table if exists vehiclemaster cascade;

2752

2753

--* RestoreFromTempTable

2754

create table vehiclemaster (

2755

  VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'

2756

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2757

  , VehicleName varchar(100) not null comment '???????'

2758

  , RegistrationNumber varchar(30) comment '?o?^???'

2759

  , IdentificationNumber varchar(30) comment '?????'

2760

  , ModelCode varchar(30) comment '?^??'

2761

  , DepartmentCode decimal(5,0) unsigned not null comment '???????'

2762

  , VehicleScheduleFlg decimal(1,0) not null comment '????\??\???t???O'

2763

  , PurchaseDate date comment '?w????'

2764

  , PurchaseName varchar(30) comment '?w????'

2765

  , PurchaseContactPersons varchar(30) comment '?w????S????'

2766

  , PurchasePhone varchar(13) comment '?w????d?b???'

2767

  , LeaseDate date comment '???[?X?J?n??'

2768

  , LeaseDestination varchar(30) comment '???[?X??'

2769

  , LeaseContactPersons varchar(30) comment '???[?X??S????'

2770

  , LeasePhone varchar(13) comment '???[?X??d?b???'

2771

  , InsuranceCompany varchar(30) comment '?C???????'

2772

  , InsuranceContactPersons varchar(30) comment '?C???????S????'

2773

  , InsurancePhone varchar(13) comment '?C???????d?b???'

2774

  , Note varchar(300) comment '???l'

2775

  , EntryDate datetime comment '?o?^???t'

2776

  , UpdateDate datetime comment '?X?V???t'

2777

  , constraint vehiclemaster_PKC primary key (VehicleCode)

2778

) comment '????}?X?^' ;

2779

2780

-- ????L?^?f?[?^

2781

--* BackupToTempTable

2782

drop table if exists vehiclerecorddata cascade;

2783

2784

--* RestoreFromTempTable

2785

create table vehiclerecorddata (

2786

  VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'

2787

  , DivisionCode decimal(2,0) unsigned not null comment '?f?[?^??'

2788

  , SeqNo decimal(2,0) not null comment '?}??'

2789

  , RecordDate date comment '???n??'

2790

  , Mileage mediumint(9) comment '???s????'

2791

  , Content varchar(100) comment '???e'

2792

  , PaymentCost decimal(10,0) comment '??p'

2793

  , EntryDate datetime not null comment '?o?^???t'

2794

  , UpdateDate datetime not null comment '?X?V???t'

2795

  , constraint vehiclerecorddata_PKC primary key (VehicleCode,DivisionCode,SeqNo)

2796

) comment '????L?^?f?[?^' ;

2797

2798

-- ????\??f?[?^

2799

--* BackupToTempTable

2800

drop table if exists vehiclescheduledata cascade;

2801

2802

--* RestoreFromTempTable

2803

create table vehiclescheduledata (

2804

  TargetDate date not null comment '????'

2805

  , VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'

2806

  , MorningAfternoon decimal(1,0) not null comment '??O?E???'

2807

  , PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

2808

  , TargetYear year(4) not null comment '?Y???N'

2809

  , TargetMonth tinyint(3) unsigned not null comment '?Y????'

2810

  , TargetDay year(4) not null comment '?Y????'

2811

  , EntryDate datetime not null comment '?o?^???t'

2812

  , UpdateDate datetime not null comment '?X?V???t'

2813

  , constraint vehiclescheduledata_PKC primary key (TargetDate,VehicleCode,MorningAfternoon)

2814

) comment '????\??f?[?^' ;

2815

2816

create index VehicleScheduleData_Index1

2817

  on vehiclescheduledata(TargetYear);

2818

2819

create index VehicleScheduleData_Index2

2820

  on vehiclescheduledata(TargetMonth);

2821

2822

create index VehicleScheduleData_Index3

2823

  on vehiclescheduledata(TargetDay);

2824

2825

-- ?N?}?X?^

2826

--* BackupToTempTable

2827

drop table if exists yearmaster cascade;

2828

2829

--* RestoreFromTempTable

2830

create table yearmaster (

2831

  years smallint(6) not null comment '?N'

2832

  , constraint yearmaster_PKC primary key (years)

2833

) comment '?N?}?X?^' ;

プロジェクト

全般

プロフィール

工事管理システム製品化対応

h-you / trunk / ddl / ProcessManagement.sql @ 379