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

379

bit

-- Project Name : noname

3

379

bit

-- 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

520

379

bit

--* BackupToTempTable

521

drop table if exists componenttotypemaster cascade;

522

523

--* RestoreFromTempTable

524

create table componenttotypemaster (

528

379

bit

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

529

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

532

379

bit

533

create index ComponentToTypeMaster_Index1

535

379

bit

536

create index ComponentToTypeMaster_Index2

538

379

bit

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 (

954

379

bit

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

955

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

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'

960

379

bit

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

961

965

379

bit

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

966

--* BackupToTempTable

967

drop table if exists constructiontypemaster cascade;

968

969

--* RestoreFromTempTable

970

create table constructiontypemaster (

971

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

972

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

973

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

974

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

975

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

976

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

977

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

978

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

979

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

980

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

981

  , constraint constructiontypemaster_PKC primary key (TypeCode)

982

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

983

984

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

985

--* BackupToTempTable

986

drop table if exists costdataofdepartment cascade;

987

988

--* RestoreFromTempTable

989

create table costdataofdepartment (

990

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

991

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

992

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

993

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

994

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

995

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

996

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

997

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

998

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

999

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

1000

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

1001

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

1002

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

1003

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

1004

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

1005

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

1006

1007

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

1008

--* BackupToTempTable

1009

drop table if exists costdataofperson cascade;

1010

1011

--* RestoreFromTempTable

1012

create table costdataofperson (

1013

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

1014

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

1015

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

1016

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

1017

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

1018

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

1019

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

1020

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

1021

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

1022

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

1023

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

1024

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

1025

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

1026

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

1027

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

1028

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

1029

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

1030

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

1031

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

1032

1033

create index CostDataOfPerson_Index1

1034

  on costdataofperson(TargetMonth);

1035

1036

create index CostDataOfPerson_Index2

1037

  on costdataofperson(ConstructionCode);

1038

1039

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

1040

--* BackupToTempTable

1041

drop table if exists costomerregist cascade;

1042

1043

--* RestoreFromTempTable

1044

create table costomerregist (

1045

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

1046

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

1047

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

1048

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

1049

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

1050

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

1051

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

1052

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

1053

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

1054

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

1055

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

1056

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

1057

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

1058

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

1059

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

1060

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

1061

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

1062

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

1063

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

1064

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

1065

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

1066

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

1067

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

1068

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

1069

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

1070

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

1071

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

1072

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

1073

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

1074

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

1075

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

1076

1077

create index CostomerRegist_Index1

1078

  on costomerregist(PetitionPeriod);

1079

1080

create index CostomerRegist_Index2

1081

  on costomerregist(CreatePersonCode);

1082

1083

create index CostomerRegist_Index3

1084

  on costomerregist(CreateDepartmentCode);

1085

1086

-- ????f?[?^

1087

--* BackupToTempTable

1088

drop table if exists dailydataconstruction cascade;

1089

1090

--* RestoreFromTempTable

1091

create table dailydataconstruction (

1092

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

1093

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

1094

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

1095

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

1096

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

1097

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

1098

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

1099

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

1100

1101

create index DailyDataConstruction_Index1

1102

  on dailydataconstruction(PersonCode);

1103

1104

create index DailyDataConstruction_Index2

1105

  on dailydataconstruction(DailyDataDate);

1106

1107

create index DailyDataConstruction_Index3

1108

  on dailydataconstruction(ConstructionCode);

1109

1110

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

1111

--* BackupToTempTable

1112

drop table if exists dailydatadetail cascade;

1113

1114

--* RestoreFromTempTable

1115

create table dailydatadetail (

1116

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

1117

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

1118

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

1119

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

1120

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

1121

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

1122

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

1123

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

1124

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

1125

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

1126

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

1127

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

1128

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

1129

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

1130

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

1131

1132

create index DailyDataDetail_Index

1133

  on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);

1134

1135

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

1136

--* BackupToTempTable

1137

drop table if exists dailydatafield cascade;

1138

1139

--* RestoreFromTempTable

1140

create table dailydatafield (

1141

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

1142

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

1143

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

1144

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

1145

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

1146

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

1147

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

1148

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

1149

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

1150

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

1151

1152

create index DailyDataField_Index

1153

  on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);

1154

1155

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

1156

--* BackupToTempTable

1157

drop table if exists dailydatamaterials cascade;

1158

1159

--* RestoreFromTempTable

1160

create table dailydatamaterials (

1161

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

1162

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

1163

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

1164

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

1165

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

1166

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

1167

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

1168

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

1169

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

1170

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

1171

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

1172

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

1173

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

1174

1175

create index DailyDataMaterials_Index

1176

  on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);

1177

1178

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

1179

--* BackupToTempTable

1180

drop table if exists dailydatasubcontractors cascade;

1181

1182

--* RestoreFromTempTable

1183

create table dailydatasubcontractors (

1184

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

1185

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

1186

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

1187

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

1188

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

1189

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

1190

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

1191

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

1192

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

1193

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

1194

1195

create index DailyDataSubcontractors_Index

1196

  on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);

1197

1198

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

1199

--* BackupToTempTable

1200

drop table if exists dailydatavehicles cascade;

1201

1202

--* RestoreFromTempTable

1203

create table dailydatavehicles (

1204

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

1205

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

1206

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

1207

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

1208

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

1209

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

1210

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

1211

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

1212

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

1213

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

1214

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

1215

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

1216

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

1217

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

1218

1219

create index DailyDataVehicles_Index

1220

  on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);

1221

1222

-- ???}?X?^

1223

--* BackupToTempTable

1224

drop table if exists daymaster cascade;

1225

1226

--* RestoreFromTempTable

1227

create table daymaster (

1228

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

1229

  , constraint daymaster_PKC primary key (days)

1230

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

1231

1232

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

1233

--* BackupToTempTable

1234

drop table if exists deadlinemaster cascade;

1235

1236

--* RestoreFromTempTable

1237

create table deadlinemaster (

1238

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

1239

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

1240

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

1241

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

1242

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

1243

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

1244

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

1245

  , constraint deadlinemaster_PKC primary key (LABOURKIND)

1246

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

1247

1248

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

1249

--* BackupToTempTable

1250

drop table if exists departmentexpensesmaster cascade;

1251

1252

--* RestoreFromTempTable

1253

create table departmentexpensesmaster (

1254

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

1255

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

1256

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

1257

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

1258

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

1259

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

1260

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

1261

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

1262

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

1263

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

1264

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

1265

1266

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

1267

--* BackupToTempTable

1268

drop table if exists departmentmaster cascade;

1269

1270

--* RestoreFromTempTable

1271

create table departmentmaster (

1272

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

1273

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

1274

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

1275

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

1276

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

1277

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

1278

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

1279

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

1280

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

1281

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

1282

  , constraint departmentmaster_PKC primary key (DepartmentCode)

1283

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

1284

1285

create index DepartmentMaster_index1

1286

  on departmentmaster(DisplayOrder);

1287

1288

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

1289

--* BackupToTempTable

1290

drop table if exists depositapprovalinfo cascade;

1291

1292

--* RestoreFromTempTable

1293

create table depositapprovalinfo (

1294

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

1295

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

1296

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

1297

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

1298

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

1299

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

1300

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

1301

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

1302

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

1303

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

1304

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

1305

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

1306

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

1307

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

1308

1309

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

1310

--* BackupToTempTable

1311

drop table if exists depositdata cascade;

1312

1313

--* RestoreFromTempTable

1314

create table depositdata (

1315

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

1316

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

1317

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

1318

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

1319

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

1320

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

1321

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

1322

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

1323

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

1324

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

1325

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

1326

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

1327

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

1328

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

1329

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

1330

1331

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

1332

--* BackupToTempTable

1333

drop table if exists depositdatadetail cascade;

1334

1335

--* RestoreFromTempTable

1336

create table depositdatadetail (

1337

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

1338

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

1339

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

1340

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

1341

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

1344

379

bit

  , DISCOUNTAMOUNT decimal(10,0) comment '?l???????z'

1345

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

1346

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

1347

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

1348

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

1349

  , CONFIRMATIONPERSONCODE decimal(8,0) comment '?m?F?S????R?[?h'

1350

  , CONFIRMATIONDATE date comment '?S????m?F???t'

1351

  , CONFIRMATIONENDFLG decimal(1,0) comment '?m?F?????t???O'

1352

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

1353

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

1354

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

1355

  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO)

1356

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

1357

1358

-- ???}?X?^

1359

--* BackupToTempTable

1360

drop table if exists divisionmaster cascade;

1361

1362

--* RestoreFromTempTable

1363

create table divisionmaster (

1364

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

1365

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

1366

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

1367

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

1368

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

1369

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

1370

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

1371

  , constraint divisionmaster_PKC primary key (DivisionCode,NameCode)

1372

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

1373

1374

-- ??Z?\?Z???f?[?^

1375

--* BackupToTempTable

1376

drop table if exists estimatebudget cascade;

1377

1378

--* RestoreFromTempTable

1379

create table estimatebudget (

1380

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

1381

  , ConstructionTime decimal(5,2) unsigned not null comment '?H??'

1382

  , IntegratedCode decimal(8,0) not null comment '??Z??'

1383

  , DataCreateDate datetime not null comment '?f?[?^??????'

1384

  , RetValue1 decimal(12,0) not null comment '?\???i'

1385

  , RetValue2 decimal(12,0) not null comment '????H????'

1386

  , RetValue3 decimal(12,0) not null comment '????????????'

1387

  , RetValue4 decimal(12,0) not null comment '????????????'

1388

  , RetPercent decimal(5,2) not null comment '???????'

1389

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

1390

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

1391

  , constraint estimatebudget_PKC primary key (ConstructionCode)

1392

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

1393

1394

-- ??Z?\?Z????f?[?^????

1395

--* BackupToTempTable

1396

drop table if exists estimatebudgetdetail cascade;

1397

1398

--* RestoreFromTempTable

1399

create table estimatebudgetdetail (

1400

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

1401

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

1402

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

1403

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

1404

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

1405

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

1406

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

1407

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

1408

  , Content varchar(120) comment '???e'

1409

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

1410

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

1411

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

1412

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

1413

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

1414

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

1415

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

1416

1417

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

1418

--* BackupToTempTable

1419

drop table if exists estimatedata cascade;

1420

1421

--* RestoreFromTempTable

1422

create table estimatedata (

1423

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

1424

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

1425

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

1426

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

1427

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

1428

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

1429

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

1430

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

1431

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

1432

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

1433

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

1434

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

1435

  , constraint estimatedata_PKC primary key (ConstructionCode,LineCount)

1436

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

1437

1438

create index EstimateData_Index1

1439

  on estimatedata(ConstructionCode,FixedItemCode);

1440

1441

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

1442

--* BackupToTempTable

1443

drop table if exists estimatedatabody cascade;

1444

1445

--* RestoreFromTempTable

1446

create table estimatedatabody (

1447

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

1448

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

1449

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

1450

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

1451

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

1452

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

1453

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

1454

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

1455

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

1456

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

1457

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

1458

  , constraint estimatedatabody_PKC primary key (ConstructionCode,PageCount)

1459

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

1460

1461

create index EstimateDataBody_Index1

1462

  on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);

1463

1464

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

1465

--* BackupToTempTable

1466

drop table if exists estimatedatadetail cascade;

1467

1468

--* RestoreFromTempTable

1469

create table estimatedatadetail (

1470

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

1471

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

1472

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

1473

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

1474

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

1475

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

1476

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

1477

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

1478

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

1479

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

1480

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

1481

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

1482

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

1483

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

1484

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

1485

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

1486

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

1487

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

1488

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

1489

  , constraint estimatedatadetail_PKC primary key (ConstructionCode,PageCount,LineCount)

1490

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

1491

1492

create index EstimateDataDetail_Index1

1493

  on estimatedatadetail(ConstructionCode,PageCount);

1494

1495

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

1496

--* BackupToTempTable

1497

drop table if exists expensesmaster cascade;

1498

1499

--* RestoreFromTempTable

1500

create table expensesmaster (

1501

  DivisionCode smallint(6) not null comment '?H?????R?[?h'

1502

  , NameCode smallint(6) not null comment '?o????R?[?h'

1503

  , DisplayOrder smallint(6) not null comment '?\????'

1504

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

1505

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

1506

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

1507

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

1508

  , constraint expensesmaster_PKC primary key (DivisionCode,NameCode)

1509

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

1510

1511

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

1512

--* BackupToTempTable

1513

drop table if exists holidaycalendermaster cascade;

1514

1515

--* RestoreFromTempTable

1516

create table holidaycalendermaster (

1517

  Holiday date not null comment '?x??'

1518

  , BusinessYear smallint(5) unsigned not null comment '?c??N?x'

1519

  , TargetMonth tinyint(3) unsigned not null comment '?Y????'

1520

  , TargetDay tinyint(3) unsigned not null comment '?Y????'

1521

  , constraint holidaycalendermaster_PKC primary key (Holiday)

1522

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

1523

1524

create index HolidayCalender_Index1

1525

  on holidaycalendermaster(BusinessYear);

1526

1527

create index HolidayCalenderMaster_Index2

1528

  on holidaycalendermaster(TargetMonth);

1529

1530

create index HolidayCalenderMaster_Index3

1531

  on holidaycalendermaster(TargetDay);

1532

1533

-- ?????????????

1534

--* BackupToTempTable

1535

drop table if exists inputsearchlogdata cascade;

1536

1537

--* RestoreFromTempTable

1538

create table inputsearchlogdata (

1539

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

1540

  , UsedProcessNo decimal(4,0) not null comment '?g?p?@?\???'

1541

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

1542

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

1543

  , InputCode decimal(10,0) comment '????R?[?h'

1544

  , constraint inputsearchlogdata_PKC primary key (ConstructionCode,UsedProcessNo,DisplayOrder)

1545

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

1546

1547

create index InputSearchLogData_Index1

1548

  on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);

1549

1550

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

1551

--* BackupToTempTable

1552

drop table if exists invoicedata cascade;

1553

1554

--* RestoreFromTempTable

1555

create table invoicedata (

1556

  INVOICENO decimal(9,0) not null comment '??????No'

1557

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

1558

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

1559

  , REQUESTMONTH decimal(6,0) not null comment '??????'

1560

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

1561

  , CRETATEDATE date not null comment '????'

1562

  , REQUESTDATE date not null comment '??????'

1563

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

1564

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

1565

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

1566

  , COMMENT1 varchar(60) comment '?R?????g1'

1567

  , COMMENT2 varchar(60) comment '?R?????g2'

1568

  , COMMENT3 varchar(60) not null comment '?R?????g3'

1569

  , COMMENT4 varchar(60) not null comment '?R?????g4'

1570

  , COMMENT5 varchar(60) not null comment '?R?????g5'

1571

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

1572

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

1573

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

1574

  , constraint invoicedata_PKC primary key (INVOICENO)

1575

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

1576

1577

alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;

1578

1579

-- ??????

1580

--* BackupToTempTable

1581

drop table if exists materialinfo cascade;

1582

1583

--* RestoreFromTempTable

1584

create table materialinfo (

1585

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

1586

  , MATERIALCOUNT smallint(5) unsigned comment '?????'

1587

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

1588

  , DELETEFLG smallint(5) unsigned comment '???t???O'

1589

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

1590

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

1591

  , constraint materialinfo_PKC primary key (MATERIALITEMCODE)

1592

) comment '??????' ;

1593

1594

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

1595

--* BackupToTempTable

1596

drop table if exists materialitemmaster cascade;

1597

1598

--* RestoreFromTempTable

1599

create table materialitemmaster (

1600

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

1601

  , MATERIALKINDCODE smallint(5) unsigned comment '??????R?[?h'

1602

  , MATERIALITEMNAME varchar(40) comment '????i?????'

1603

  , DISPLAYORDER smallint(5) unsigned comment '?\????'

1604

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

1605

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

1606

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

1607

  , VERSIONNO decimal(8,0) default '0' not null comment '?o?[?W???????'

1608

  , constraint materialitemmaster_PKC primary key (MATERIALITEMCODE)

1609

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

1610

1611

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

1612

--* BackupToTempTable

1613

drop table if exists materialkindmaster cascade;

1614

1615

--* RestoreFromTempTable

1616

create table materialkindmaster (

1617

  MATERIALKINDCODE smallint(5) unsigned default 0 not null comment '??????R?[?h'

1618

  , MATERIALKINDNAME varchar(40) comment '?????????'

1619

  , DISPLAYORDER smallint(5) unsigned comment '?\????'

1620

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

1621

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

1622

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

1623

  , constraint materialkindmaster_PKC primary key (MATERIALKINDCODE)

1624

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

1625

1626

-- ??????????

1627

--* BackupToTempTable

1628

drop table if exists materialrecordinfo cascade;

1629

1630

--* RestoreFromTempTable

1631

create table materialrecordinfo (

1632

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

1633

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

1634

  , SEQNO smallint(5) unsigned default 0 not null comment '?A??'

1635

  , RECKIND tinyint(3) unsigned comment '???R?[?h??'

1636

  , CONSTRUCTIONCODE int(10) unsigned comment '?H?????'

1637

  , PERSONCODE int(10) unsigned comment '?S????R?[?h'

1638

  , MATERIALCOUNT smallint(5) unsigned comment '?????'

1639

  , REPAYPLANDATE date comment '??p?\??N????'

1640

  , COMMENTTEXT varchar(80) comment '?R?????g'

1641

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

1642

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

1643

  , constraint materialrecordinfo_PKC primary key (MATERIALITEMCODE,PROCESSDATE,SEQNO)

1644

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

1645

1646

-- ?f??????b?Z?[?W

1647

--* BackupToTempTable

1648

drop table if exists messageboarddata cascade;

1649

1650

--* RestoreFromTempTable

1651

create table messageboarddata (

1652

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

1653

  , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'

1654

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

1655

  , FromName varchar(60) not null comment '???????'

1656

  , MessageTitile varchar(100) comment '?`???^?C?g??'

1657

  , MessageContent varchar(1333) not null comment '?`?????e'

1658

  , LinkType decimal(2,0) not null comment '?????N????^?C?v'

1659

  , LinkMessage varchar(200) comment '?????N??????'

1660

  , LinkCode varchar(30) comment '?????N?L?['

1661

  , WritingDate datetime not null comment '?????????'

1662

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

1663

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

1664

  , MessageColor varchar(8) comment '?????F'

1665

  , BackColor varchar(8) comment '?o?b?N?J???['

1666

  , MessageFlag decimal(1,0) not null comment '???b?Z?[?W?t???O'

1667

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

1668

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

1669

  , constraint messageboarddata_PKC primary key (RecordNumber,BranchNumber)

1670

) comment '?f??????b?Z?[?W' ;

1671

1672

create index MessageBoardData_Index1

1673

  on messageboarddata(WritingDate);

1674

1675

create index MessageBoardData_Index2

1676

  on messageboarddata(MessageFlag);

1677

1678

-- ?f???????e?[?u??

1679

--* BackupToTempTable

1680

drop table if exists messageboardterget cascade;

1681

1682

--* RestoreFromTempTable

1683

create table messageboardterget (

1684

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

1685

  , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'

1686

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

1687

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

1688

  , ToName varchar(60) not null comment '????'

1689

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

1690

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

1691

  , constraint messageboardterget_PKC primary key (RecordNumber,BranchNumber,SeqNum)

1692

) comment '?f???????e?[?u??' ;

1693

1694

create index MessageBoardTerget_Index1

1695

  on messageboardterget(RecordNumber,BranchNumber);

1696

1697

-- ?f??????b?Z?[?W?{??????

1698

--* BackupToTempTable

1699

drop table if exists messagebrowsinghistory cascade;

1700

1701

--* RestoreFromTempTable

1702

create table messagebrowsinghistory (

1703

  RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

1704

  , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'

1705

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

1706

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

1707

  , BrowsingDate datetime not null comment '?{?????t'

1708

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

1709

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

1710

  , constraint messagebrowsinghistory_PKC primary key (RecordNumber,BranchNumber,SeqNum)

1711

) comment '?f??????b?Z?[?W?{??????' ;

1712

1713

-- ???}?X?^

1714

--* BackupToTempTable

1715

drop table if exists monthmaster cascade;

1716

1717

--* RestoreFromTempTable

1718

create table monthmaster (

1719

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

1720

  , constraint monthmaster_PKC primary key (month)

1721

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

1722

1723

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

1724

--* BackupToTempTable

1725

drop table if exists orderersmaster cascade;

1726

1727

--* RestoreFromTempTable

1728

create table orderersmaster (

1729

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

1730

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

1731

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

1732

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

1733

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

1734

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

1735

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

1736

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

1737

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

1738

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

1739

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

1740

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

1741

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

1742

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

1743

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

1744

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

1745

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

1746

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

1747

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

1748

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

1749

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

1750

  , constraint orderersmaster_PKC primary key (OrderCotegory,OrderersCode)

1751

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

1752

1753

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

1754

--* BackupToTempTable

1755

drop table if exists orderspricedata cascade;

1756

1757

--* RestoreFromTempTable

1758

create table orderspricedata (

1759

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

1760

  , ChangeNo decimal(3,0) unsigned not null comment '??X???'

1761

  , ChangeDate date not null comment '??X??'

1762

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

1763

  , ChangePersonName varchar(60) comment '??X???'

1764

  , BeforeValue decimal(14,0) not null comment '??X?O???????z'

1765

  , BeforeValueInTax decimal(14,0) not null comment '??X?O???????z'

1766

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

1767

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

1768

  , ChangeComment varchar(200) comment '??X???R'

1769

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

1770

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

1771

  , constraint orderspricedata_PKC primary key (ConstructionCode,ChangeNo)

1772

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

1773

1774

-- ?x?????F???f?[?^

1775

--* BackupToTempTable

1776

drop table if exists paymentapprovalinfo cascade;

1777

1778

--* RestoreFromTempTable

1779

create table paymentapprovalinfo (

1780

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

1781

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

1782

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

1783

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

1784

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

1785

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

1786

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

1787

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

1788

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

1789

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

1790

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

1791

  , constraint paymentapprovalinfo_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)

1792

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

1793

1794

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

1795

--* BackupToTempTable

1796

drop table if exists paymentdatadetail cascade;

1797

1798

--* RestoreFromTempTable

1799

create table paymentdatadetail (

1800

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

1801

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

1802

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

1803

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

1804

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

1805

  , DISCOUNTPRICE decimal(10,0) comment '?l???????z'

1806

  , OFFSETPRICE decimal(10,0) comment '???E???z'

1807

  , NEXTCOPRICE decimal(10,0) comment '????J?z'

1808

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

1809

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

1810

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

1811

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

1812

  , CNSTRPRICEEXIST decimal(1,0) comment '??????L??'

1813

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

1814

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

1815

  , APPROVALENDFLG decimal(1,0) comment '???F?????t???O'

1816

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

1817

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

1818

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

1819

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

1820

1821

create index PayDataDetail_Index1

1822

  on paymentdatadetail(TARGETDATE);

1823

1824

create index PayDataDetail_Index2

1825

  on paymentdatadetail(APPROVALPERSONCODE);

1826

1827

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

1828

--* BackupToTempTable

1829

drop table if exists periodavoidance cascade;

1830

1831

--* RestoreFromTempTable

1832

create table periodavoidance (

1833

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

1834

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

1835

  , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'

1836

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

1837

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

1838

  , constraint periodavoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo)

1839

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

1840

1841

create index PeriodAvoidance_Index1

1842

  on periodavoidance(ConstructionCode);

1843

1844

create index PeriodAvoidance_Index2

1845

  on periodavoidance(ConstructionStatusFlg);

1846

1847

create index PeriodAvoidance_Index3

1848

  on periodavoidance(FieldNo);

1849

1850

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

1851

--* BackupToTempTable

1852

drop table if exists personapproval cascade;

1853

1854

--* RestoreFromTempTable

1855

create table personapproval (

1856

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

1857

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

1858

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

1859

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

1860

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

1861

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

1862

  , PetitionApprovalDate datetime not null comment '?\???E???F???t'

1863

  , ApprovalLimitDates datetime not null comment '???F??]??'

1864

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

1865

  , InputComment varchar(300) comment '?R?????g'

1866

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

1867

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

1868

  , constraint personapproval_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,SeqNo)

1869

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

1870

1871

-- ?S??????F?R?????g?f?[?^

1872

--* BackupToTempTable

1873

drop table if exists personapprovalcomment cascade;

1874

1875

--* RestoreFromTempTable

1876

create table personapprovalcomment (

1877

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

1878

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

1879

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

1880

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

1881

  , CommentNo decimal(2,0) not null comment '?R?????g???'

1882

  , ParentNo decimal(2,0) not null comment '?e?R?????g???'

1883

  , ApproValComment varchar(300) comment '?w???E?A???R?????g'

1884

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

1885

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

1886

  , constraint personapprovalcomment_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,CommentNo)

1887

) comment '?S??????F?R?????g?f?[?^' ;

1888

1889

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

1890

--* BackupToTempTable

1891

drop table if exists persondepartmentmaster cascade;

1892

1893

--* RestoreFromTempTable

1894

create table persondepartmentmaster (

1895

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

1896

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

1897

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

1898

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

1899

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

1900

  , constraint persondepartmentmaster_PKC primary key (PersonCode,DepartmentCode)

1901

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

1902

1903

create index PersonDepartmentMaster_Index1

1904

  on persondepartmentmaster(PersonCode);

1905

1906

create index PersonDepartmentMaster_Index2

1907

  on persondepartmentmaster(DepartmentCode);

1908

1909

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

1910

--* BackupToTempTable

1911

drop table if exists personinchargemaster cascade;

1912

1913

--* RestoreFromTempTable

1914

create table personinchargemaster (

1915

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

1916

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

1917

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

1918

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

1919

  , EndDate date comment '?g?p?I???N????'

1920

  , PassWord varchar(16) comment '?p?X???[?h'

1921

  , SecurityManagement decimal(1,0) not null comment '?@????'

1922

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

1923

  , MsgBackColor varchar(8) comment '???b?Z?[?W?w?i?F'

1924

  , DisplayString varchar(20) comment '?\???E???????'

1925

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

1926

  , MonthlySalary decimal(11,0) not null comment '???????z'

1927

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

1928

  , Qualification varchar(120) comment '???i?????'

1929

  , SealPrintName varchar(5) comment '???\????'

1930

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

1931

  , LedgerFlg decimal(1,0) not null comment '???v?Z???t???O'

1932

  , CommutingDistance decimal(5,2) not null comment '??????'

1933

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

1934

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

1935

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

1936

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

1937

  , constraint personinchargemaster_PKC primary key (PersonCode)

1938

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

1939

1940

create index PersonInChargeMaster_Index1

1941

  on personinchargemaster(StartDate);

1942

1943

create index PersonInChargeMaster_Index2

1944

  on personinchargemaster(DepartmentCode);

1945

1946

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

1947

--* BackupToTempTable

1948

drop table if exists personsalarymaster cascade;

1949

1950

--* RestoreFromTempTable

1951

create table personsalarymaster (

1952

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

1953

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

1954

  , MonthlySalary decimal(11,0) not null comment '???????z'

1955

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

1956

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

1957

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

1958

  , constraint personsalarymaster_PKC primary key (PersonCode,StartDate)

1959

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

1960

1961

create index PersonSalaryMaster_Index1

1962

  on personsalarymaster(PersonCode);

1963

1964

create index PersonSalaryMaster_Index2

1965

  on personsalarymaster(StartDate);

1966

1967

create index PersonSalaryMaster_Index3

1968

  on personsalarymaster(MonthlySalary);

1969

1970

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

1971

--* BackupToTempTable

1972

drop table if exists pointingoutcomment cascade;

1973

1974

--* RestoreFromTempTable

1975

create table pointingoutcomment (

1976

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

1977

  , ProcessNo smallint(6) not null comment '????????i??????j'

1978

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

1979

  , PageCount smallint(6) not null comment '?y?[?W???'

1980

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

1981

  , DrowColor varchar(8) comment '?`??F'

1982

  , CommentMessage varchar(1000) comment '???b?Z?[?W'

1983

  , StartPointX smallint(6) not null comment '?w?E?????u?w'

1984

  , StartPointY smallint(6) not null comment '?w?E?????u?x'

1985

  , CurrentPointX smallint(6) not null comment '??????u?w'

1986

  , CurrentPointY smallint(6) not null comment '??????u?x'

1987

  , CurrentWidth smallint(6) not null comment '?\???T?C?YWidth'

1988

  , CurrentHeight smallint(6) not null comment '?\???T?C?YHeigth'

1989

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

1990

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

1991

  , constraint pointingoutcomment_PKC primary key (ConstructionCode,ProcessNo,SeqNo)

1992

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

1993

1994

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

1995

--* BackupToTempTable

1996

drop table if exists proceedingsdata cascade;

1997

1998

--* RestoreFromTempTable

1999

create table proceedingsdata (

2000

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

2001

  , ProceedingsDataDate date not null comment '?c???^????'

2002

  , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'

2003

  , EndMeetingTime decimal(4,0) unsigned not null comment '??c????I??'

2004

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

2005

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

2006

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

2007

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

2008

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

2009

  , constraint proceedingsdata_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime)

2010

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

2011

2012

-- ?????????????c???^?f?[?^?i?o???j

2013

--* BackupToTempTable

2014

drop table if exists proceedingsdataattend cascade;

2015

2016

--* RestoreFromTempTable

2017

create table proceedingsdataattend (

2018

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

2019

  , ProceedingsDataDate date not null comment '?c???^????'

2020

  , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'

2021

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

2022

  , Department varchar(20) comment '?o??????'

2023

  , AttendName varchar(10) comment '?o??????'

2024

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

2025

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

2026

  , constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)

2027

) comment '?????????????c???^?f?[?^?i?o???j' ;

2028

2029

-- ?????????????c???^?f?[?^?i????j

2030

--* BackupToTempTable

2031

drop table if exists proceedingsdatadetail cascade;

2032

2033

--* RestoreFromTempTable

2034

create table proceedingsdatadetail (

2035

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

2036

  , ProceedingsDataDate date not null comment '?c???^????'

2037

  , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'

2038

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

2039

  , TitleNo varchar(5) comment '?c????'

2040

  , Title varchar(20) comment '?c??'

2041

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

2042

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

2043

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

2044

  , constraint proceedingsdatadetail_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)

2045

) comment '?????????????c???^?f?[?^?i????j' ;

2046

2047

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

2048

--* BackupToTempTable

2049

drop table if exists processapproval cascade;

2050

2051

--* RestoreFromTempTable

2052

create table processapproval (

2053

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

2054

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

2055

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

2056

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

2057

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

2058

  , PetitionApprovalDate datetime not null comment '?\???E???F???t'

2059

  , ApprovalLimitDates datetime not null comment '???F??]??'

2060

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

2061

  , InputComment varchar(300) comment '?R?????g'

2062

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

2063

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

2064

  , constraint processapproval_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SeqNo)

2065

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

2066

2067

-- ???F?R?????g?f?[?^

2068

--* BackupToTempTable

2069

drop table if exists processapprovalcomment cascade;

2070

2071

--* RestoreFromTempTable

2072

create table processapprovalcomment (

2073

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

2074

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

2075

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

2076

  , CommentNo decimal(2,0) not null comment '?R?????g???'

2077

  , ParentNo decimal(2,0) not null comment '?e?R?????g???'

2078

  , ApproValComment varchar(300) comment '?w???E?A???R?????g'

2079

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

2080

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

2081

  , constraint processapprovalcomment_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,CommentNo)

2082

) comment '???F?R?????g?f?[?^' ;

2083

2084

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

2085

--* BackupToTempTable

2086

drop table if exists processapprovaldetail cascade;

2087

2088

--* RestoreFromTempTable

2089

create table processapprovaldetail (

2090

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

2091

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

2092

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

2093

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

2094

  , LinkCode decimal(10,0) not null comment '?????N???'

2095

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

2096

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

2097

  , constraint processapprovaldetail_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SerialNo)

2098

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

2099

2100

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

2101

--* BackupToTempTable

2102

drop table if exists processexcutemaster cascade;

2103

2104

--* RestoreFromTempTable

2105

create table processexcutemaster (

2106

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

2107

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

2108

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

2109

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

2110

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

2111

  , constraint processexcutemaster_PKC primary key (SecCode,ExecCode)

2112

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

2113

2114

create index ProcessExcuteMaster_Index1

2115

  on processexcutemaster(SecCode);

2116

2117

create index ProcessExcuteMaster_Index2

2118

  on processexcutemaster(ExecCode);

2119

2120

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

2121

--* BackupToTempTable

2122

drop table if exists purchaseorder cascade;

2123

2124

--* RestoreFromTempTable

2125

create table purchaseorder (

2126

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

2127

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

2128

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

2129

  , CreateDate date comment '?????t'

2130

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

2131

  , LastRowStringDate date not null comment '??I?s?\?????t'

2132

  , OrderSheetType decimal(1,0) not null comment '???E?{???t???O'

2133

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

2134

  , CashRatio decimal(4,1) not null comment '?????????i???j'

2135

  , BillPeriod decimal(4,0) not null comment '??`????'

2136

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

2137

  , PrePaymentsDays decimal(3,0) not null comment '?O????????'

2138

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

2139

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

2140

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

2141

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

2142

  , PartialPaymentDay2 decimal(2,0) unsigned not null comment '???????x????'

2143

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

2144

  , CompletionPayment decimal(1,0) not null comment '???n??????x??'

2145

  , CompletionPaymentDays decimal(3,0) unsigned not null comment '???n??????x??????'

2146

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

2147

  , LeadEngineerCode decimal(8,0) comment '??C?Z?p??R?[?h'

2148

  , LeadEngineerName varchar(60) comment '??C?Z?p???'

2149

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

2150

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

2151

  , WorkersCount decimal(3,0) unsigned comment '??????'

2152

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

2153

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

2154

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

2155

  , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)

2156

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

2157

2158

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

2159

--* BackupToTempTable

2160

drop table if exists purchaseorderdate cascade;

2161

2162

--* RestoreFromTempTable

2163

create table purchaseorderdate (

2164

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

2165

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

2166

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

2167

  , SendDate date not null comment '???????X????'

2168

  , ReturnDate date not null comment '???????????'

2169

  , ReturnCheckDate date not null comment '??????????m?F??'

2170

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

2171

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

2172

  , constraint purchaseorderdate_PKC primary key (ConstructionCode,SeqNo)

2173

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

2174

2175

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

2176

--* BackupToTempTable

2177

drop table if exists purchaseorderdetail cascade;

2178

2179

--* RestoreFromTempTable

2180

create table purchaseorderdetail (

2181

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

2182

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

2183

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

2184

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

2185

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

2186

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

2187

  , FirstString varchar(120) comment '?H??E?i??'

2188

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

2189

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

2190

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

2191

  , UnitPrice decimal(10,0) not null comment '?P??'

2192

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

2193

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

2194

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

2195

  , DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O'

2196

  , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'

2197

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

2198

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

2199

  , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)

2200

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

2201

2202

create index POrderDetail_Index1

2203

  on purchaseorderdetail(SourceCode);

2204

2205

-- ???R?[?h??????

2206

--* BackupToTempTable

2207

drop table if exists recordkey cascade;

2208

2209

--* RestoreFromTempTable

2210

create table recordkey (

2211

  KeyNo decimal(2,0) unsigned not null comment '?L?[?R?[?h'

2212

  , RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

2213

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

2214

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

2215

  , constraint recordkey_PKC primary key (KeyNo,RecordNumber)

2216

) comment '???R?[?h??????' ;

2217

2218

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

2219

--* BackupToTempTable

2220

drop table if exists reminvoicedata cascade;

2221

2222

--* RestoreFromTempTable

2223

create table reminvoicedata (

2224

  InvoiceNo decimal(9,0) not null comment '??????No'

2225

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

2226

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

2227

  , RemComment varchar(300) comment '?????R'

2228

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

2229

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

2230

  , constraint reminvoicedata_PKC primary key (InvoiceNo)

2231

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

2232

2233

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

2234

--* BackupToTempTable

2235

drop table if exists reminvoicedatadetail cascade;

2236

2237

--* RestoreFromTempTable

2238

create table reminvoicedatadetail (

2239

  InvoiceNo decimal(9,0) not null comment '??????No'

2240

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

2241

  , RequestNo decimal(9,0) not null comment '????No'

2242

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

2243

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

2244

  , constraint reminvoicedatadetail_PKC primary key (InvoiceNo,SeqNo)

2245

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

2246

2247

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

2248

--* BackupToTempTable

2249

drop table if exists requestdata cascade;

2250

2251

--* RestoreFromTempTable

2252

create table requestdata (

2253

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

2254

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

2255

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

2256

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

2257

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

2258

  , REQUESTAMOUNT0 decimal(10,0) not null comment '???????z?O'

2259

  , REQUESTAMOUNT1 decimal(10,0) not null comment '???????z?P'

2260

  , REQUESTAMOUNT2 decimal(10,0) comment '???????z?Q'

2261

  , REQUESTAMOUNT3 decimal(10,0) comment '???????z?R'

2262

  , REQUESTAMOUNT4 decimal(10,0) comment '???????z?S'

2263

  , REQUESTAMOUNT5 decimal(10,0) comment '???????z?T'

2264

  , REQUESTAMOUNT6 decimal(10,0) comment '???????z?U'

2265

  , UNCLAIMEDAMOUNT decimal(10,0) not null comment '?????c???z'

2266

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

2267

  , TAXAMOUNT decimal(10,0) not null comment '?????'

2268

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

2269

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

2270

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

2271

  , constraint requestdata_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE)

2272

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

2273

2274

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

2275

--* BackupToTempTable

2276

drop table if exists requestdatadetail cascade;

2277

2278

--* RestoreFromTempTable

2279

create table requestdatadetail (

2280

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

2281

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

2282

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

2283

  , CONSTRUCTIONKIND decimal(1,0) not null comment '?H????'

2284

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

2285

  , TAXAMOUNT decimal(10,0) not null comment '?????'

2286

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

2287

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

2288

  , constraint requestdatadetail_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE,CONSTRUCTIONCODE,CONSTRUCTIONKIND)

2289

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

2290

2291

-- ?????w?b?_

2292

--* BackupToTempTable

2293

drop table if exists requesthead cascade;

2294

2295

--* RestoreFromTempTable

2296

create table requesthead (

2297

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

2298

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

2299

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

2300

  , REQUESTMONTH decimal(6,0) not null comment '??????'

2301

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

2302

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

2303

  , ORDERERSNAME varchar(120) not null comment '???????'

2304

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

2305

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

2306

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

2307

  , TAXAMOUNT decimal(10,0) not null comment '?????'

2308

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

2309

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

2310

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

2311

  , INVOICENO decimal(9,0) not null comment '??????No'

2312

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

2313

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

2314

  , constraint requesthead_PKC primary key (REQUESTNO)

2315

) comment '?????w?b?_' ;

2316

2317

alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;

2318

2319

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

2320

--* BackupToTempTable

2321

drop table if exists requestorderdate cascade;

2322

2323

--* RestoreFromTempTable

2324

create table requestorderdate (

2325

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

2326

  , InvoiceNo decimal(9,0) not null comment '??????No'

2327

  , SendDate date not null comment '???????????X????'

2328

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

2329

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

2330

  , constraint requestorderdate_PKC primary key (ConstructionCode,InvoiceNo)

2331

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

2332

2333

-- ????O???t?f?[?^

2334

--* BackupToTempTable

2335

drop table if exists salesgraphdata cascade;

2336

2337

--* RestoreFromTempTable

2338

create table salesgraphdata (

2339

  GraphDataCode decimal(8,0) not null comment '?O???t?f?[?^?R?[?h'

2340

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

2341

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

2342

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

2343

  , DataName varchar(100) not null comment '?f?[?^?\??????'

2344

  , SalesAmount decimal(10,0) not null comment '????f?[?^'

2345

  , AdministrativeExpense decimal(10,0) not null comment '???E?????o??'

2346

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

2347

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

2348

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

2349

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

2350

  , constraint salesgraphdata_PKC primary key (GraphDataCode,ConstructionPeriod,SalesDataDays)

2351

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

2352

2353

create index SalesGraphData_Idx1

2354

  on salesgraphdata(DisplayOrder);

2355

2356

create index SalesGraphData_idx2

2357

  on salesgraphdata(ConstructionPeriod);

2358

2359

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

2360

--* BackupToTempTable

2361

drop table if exists securitymaster cascade;

2362

2363

--* RestoreFromTempTable

2364

create table securitymaster (

2365

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

2366

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

2367

  , SecName varchar(60) not null comment '????????'

2368

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

2369

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

2370

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

2371

  , SelectBackColor varchar(8) not null comment '?I??w?i?F'

2372

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

2373

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

2374

  , constraint securitymaster_PKC primary key (SecCode)

2375

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

2376

2377

create index SecurityMaster_Index1

2378

  on securitymaster(DisplayOrder);

2379

2380

create index SecurityMaster_Index2

2381

  on securitymaster(SecRank);

2382

2383

create index SecurityMaster_Index3

2384

  on securitymaster(SecRange);

2385

2386

-- ???S?p?g???[???f?[?^

2387

--* BackupToTempTable

2388

drop table if exists sfpdata cascade;

2389

2390

--* RestoreFromTempTable

2391

create table sfpdata (

2392

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

2393

  , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'

2394

  , RequestDate datetime not null comment '?p?g???[???v??????'

2395

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

2396

  , StringValue varchar(300) comment '?R?????g'

2397

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

2398

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

2399

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

2400

  , constraint sfpdata_PKC primary key (ConstructionCode,DataCount)

2401

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

2402

2403

create index SFPData_Index1

2404

  on sfpdata(RequestDate);

2405

2406

-- ???S?p?g???[??????f?[?^

2407

--* BackupToTempTable

2408

drop table if exists sfpdatadetail cascade;

2409

2410

--* RestoreFromTempTable

2411

create table sfpdatadetail (

2412

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

2413

  , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'

2414

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

2415

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

2416

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

2417

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

2418

  , constraint sfpdatadetail_PKC primary key (ConstructionCode,DataCount,SeqNo)

2419

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

2420

2421

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

2422

--* BackupToTempTable

2423

drop table if exists subconstrjobitemregist cascade;

2424

2425

--* RestoreFromTempTable

2426

create table subconstrjobitemregist (

2427

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

2428

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

2429

  , SeqNo decimal(2,0) unsigned not null comment '?\???A??'

2430

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

2431

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

2432

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

2433

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

2434

  , constraint subconstrjobitemregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)

2435

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

2436

2437

-- ??????E?????N?o?^?\???f?[?^

2438

--* BackupToTempTable

2439

drop table if exists subconstrjoblinkregist cascade;

2440

2441

--* RestoreFromTempTable

2442

create table subconstrjoblinkregist (

2443

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

2444

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

2445

  , SeqNo decimal(2,0) unsigned not null comment '?\???A??'

2446

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

2447

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

2448

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

2449

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

2450

  , constraint subconstrjoblinkregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)

2451

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

2452

2453

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

2454

--* BackupToTempTable

2455

drop table if exists subconstrregist cascade;

2456

2457

--* RestoreFromTempTable

2458

create table subconstrregist (

2459

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

2460

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

2461

  , SeqNo decimal(2,0) unsigned not null comment '?\???A??'

2462

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

2463

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

2464

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

2465

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

2466

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

2467

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

2468

  , CEOPositionName varchar(60) comment '??\???E??'

2469

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

2470

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

2471

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

2472

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

2473

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

2474

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

2475

  , CellPhoneNumber varchar(13) comment '?g??d?b???'

2476

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

2477

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

2478

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

2479

  , JapaneseSyllabary varchar(2) comment '50?????'

2480

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

2481

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

2482

  , labourKind decimal(1,0) not null comment '?x???????E????'

2483

  , OrderDate date comment '?\????'

2484

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

2485

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

2486

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

2487

  , constraint subconstrregist_PKC primary key (PersonCode,CreateDate,SeqNo)

2488

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

2489

2490

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

2491

--* BackupToTempTable

2492

drop table if exists subcontractoritemmaster cascade;

2493

2494

--* RestoreFromTempTable

2495

create table subcontractoritemmaster (

2496

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

2497

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

2498

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

2499

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

2500

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

2501

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

2502

  , constraint subcontractoritemmaster_PKC primary key (ItemCode)

2503

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

2504

2505

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

2506

--* BackupToTempTable

2507

drop table if exists subcontractorjobcategory cascade;

2508

2509

--* RestoreFromTempTable

2510

create table subcontractorjobcategory (

2511

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

2512

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

2513

  , JobCategoryName varchar(120) not null comment '?E????'

2514

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

2515

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

2516

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

2517

  , constraint subcontractorjobcategory_PKC primary key (JobCategoryCode)

2518

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

2519

2520

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

2521

--* BackupToTempTable

2522

drop table if exists subcontractorjobitem cascade;

2523

2524

--* RestoreFromTempTable

2525

create table subcontractorjobitem (

2526

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

2527

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

2528

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

2529

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

2530

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

2531

  , constraint subcontractorjobitem_PKC primary key (CompanyCode,ItemCode)

2532

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

2533

2534

create index SubContractorJobItem_Index1

2535

  on subcontractorjobitem(CompanyCode);

2536

2537

create index SubContractorJobItem_Index2

2538

  on subcontractorjobitem(ItemCode);

2539

2540

-- ??????E?????N?}?X?^

2541

--* BackupToTempTable

2542

drop table if exists subcontractorjoblink cascade;

2543

2544

--* RestoreFromTempTable

2545

create table subcontractorjoblink (

2546

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

2547

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

2548

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

2549

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

2550

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

2551

  , constraint subcontractorjoblink_PKC primary key (CompanyCode,JobCategoryCode)

2552

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

2553

2554

create index SubContractorJobLink_Index1

2555

  on subcontractorjoblink(CompanyCode);

2556

2557

create index SubContractorJobLink_Index2

2558

  on subcontractorjoblink(JobCategoryCode);

2559

2560

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

2561

--* BackupToTempTable

2562

drop table if exists subcontractormaster cascade;

2563

2564

--* RestoreFromTempTable

2565

create table subcontractormaster (

2566

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

2567

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

2568

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

2569

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

2570

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

2571

  , CEOPositionName varchar(60) comment '??\???E??'

2572

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

2573

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

2574

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

2575

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

2576

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

2577

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

2578

  , CellPhoneNumber varchar(13) comment '?g??d?b???'

2579

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

2580

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

2581

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

2582

  , JapaneseSyllabary varchar(2) comment '50?????'

2583

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

2584

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

2585

  , labourKind decimal(1,0) not null comment '?x???????E????'

2586

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

2587

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

2588

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

2589

  , constraint subcontractormaster_PKC primary key (CompanyCode)

2590

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

2591

2592

create index SubContractorMaster_Index1

2593

  on subcontractormaster(JapaneseSyllabary);

2594

2595

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

2596

--* BackupToTempTable

2597

drop table if exists suppliersmaster cascade;

2598

2599

--* RestoreFromTempTable

2600

create table suppliersmaster (

2601

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

2602

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

2603

  , SuppliersName1 varchar(60) not null comment '?d????1'

2604

  , SuppliersName2 varchar(60) comment '?d?????Q'

2605

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

2606

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

2607

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

2608

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

2609

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

2610

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

2611

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

2612

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

2613

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

2614

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

2615

  , constraint suppliersmaster_PKC primary key (SuppliersCode)

2616

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

2617

2618

-- ?V?X?e???N???m?F?f?[?^

2619

--* BackupToTempTable

2620

drop table if exists systemexecute cascade;

2621

2622

--* RestoreFromTempTable

2623

create table systemexecute (

2624

  PrimaryCode tinyint(4) not null comment '?L?[????'

2625

  , TargetDate date not null comment '?N?????t'

2626

  , SystemVersion int(11) not null comment '?{??E????o?[?W????'

2627

  , UpDateCopyVersion int(11) not null comment '?R?s?[?o?[?W????'

2628

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

2629

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

2630

  , constraint systemexecute_PKC primary key (PrimaryCode)

2631

) comment '?V?X?e???N???m?F?f?[?^' ;

2632

2633

-- ????}?X?^

2634

--* BackupToTempTable

2635

drop table if exists systemmaster cascade;

2636

2637

--* RestoreFromTempTable

2638

create table systemmaster (

2639

  SystemCode decimal(3,0) unsigned not null comment '???R?[?h'

2640

  , CompanyName1 varchar(60) not null comment '?????P'

2641

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

2642

  , CEOName varchar(60) not null comment '??\?????'

2643

  , CEOPositionName varchar(60) comment '??\???E??'

2644

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

2645

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

2646

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

2647

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

2648

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

2649

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

2650

  , HomePageURL varchar(120) comment '?z?[???y?[?WURL'

2651

  , ConsumptionTax decimal(4,2) not null comment '?????'

2652

  , CooperationRate decimal(4,2) not null comment '???????'

2653

  , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'

2654

  , FuelPrice decimal(5,2) not null comment '?R???L???P??'

2655

  , AreaDistance decimal(5,2) not null comment '????u????????'

2656

  , ExcelSavePath varchar(120) comment 'Excel????p?X'

2657

  , BusinessPeriod smallint(6) not null comment '????c?????'

2658

  , ConstrYear smallint(6) not null comment '????H???N?x'

2659

  , BusinessBeginDate datetime not null comment '?c????????'

2660

  , ConstrBeginDate datetime not null comment '?H???N?x?????'

2661

  , BusinessCompDate datetime not null comment '?c?????????'

2662

  , ConstrCompDate datetime not null comment '?H???N?x??????'

2663

  , ConstructionNoBase decimal(1,0) not null comment '?H????????l'

2664

  , SloganString1 varchar(100) comment '?W??1'

2665

  , SloganString2 varchar(100) comment '?W??2'

2666

  , SloganString3 varchar(100) comment '?W??3'

2668

379

bit

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

2669

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

2670

  , constraint systemmaster_PKC primary key (SystemCode)

2671

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

2672

2673

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

2674

--* BackupToTempTable

2675

drop table if exists termmaster cascade;

2676

2677

--* RestoreFromTempTable

2678

create table termmaster (

2679

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

2680

  , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'

2681

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

2682

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

2683

  , CheckSchdule decimal(1,0) not null comment '?`?F?b?N?^?C?~???O'

2684

  , TermDays decimal(3,0) not null comment '?o???'

2685

  , SendTitile varchar(100) comment '?^?C?g??'

2686

  , SendMessage varchar(100) comment '???b?Z?[?W'

2687

  , BackColor varchar(8) comment '?w?i?F'

2688

  , ForeColor varchar(8) comment '?????F'

2689

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

2690

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

2691

  , constraint termmaster_PKC primary key (ConstructionStatusFlg,FieldNo,SeqNo)

2692

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

2693

2694

create index TermMaster_Index1

2695

  on termmaster(DisplayOrder);

2696

2697

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

2698

--* BackupToTempTable

2699

drop table if exists tranceportdailydata cascade;

2700

2701

--* RestoreFromTempTable

2702

create table tranceportdailydata (

2703

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

2704

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

2705

  , StartDistance decimal(7,1) not null comment '?????o???L????'

2706

  , ComplateDistance decimal(7,1) not null comment '?????I???L????'

2707

  , TotalDistance decimal(6,1) not null comment '???????v?L????'

2708

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

2709

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

2710

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

2711

  , TrancePayOutFlg decimal(1,0) not null comment '?L?????A??t???O'

2712

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

2713

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

2714

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

2715

  , constraint tranceportdailydata_PKC primary key (PersonCode,AttendanceDate)

2716

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

2717

2718

create index TranceportDailyData_Index1

2719

  on tranceportdailydata(AttendanceDate);

2720

2721

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

2722

--* BackupToTempTable

2723

drop table if exists typeexpensesmaster cascade;

2724

2725

--* RestoreFromTempTable

2726

create table typeexpensesmaster (

2727

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

2728

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

2729

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

2730

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

2731

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

2732

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

2733

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

2734

  , constraint typeexpensesmaster_PKC primary key (TypeCode,ExpensesPeriod,NameCode)

2735

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

2736

2737

-- ?P??}?X?^

2738

--* BackupToTempTable

2739

drop table if exists unitmaster cascade;

2740

2741

--* RestoreFromTempTable

2742

create table unitmaster (

2743

  UnitKey decimal(5,0) unsigned not null comment '?P??L?['

2744

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2745

  , UnitName varchar(30) not null comment '?P?????'

2746

  , EntryDate datetime not null comment '?o?^???t'

2747

  , UpdateDate datetime not null comment '?X?V???t'

2748

  , constraint unitmaster_PKC primary key (UnitKey)

2749

) comment '?P??}?X?^' ;

2750

2751

create index UnitMaster_Index1

2752

  on unitmaster(DisplayOrder);

2753

2754

-- ????}?X?^

2755

--* BackupToTempTable

2756

drop table if exists vehiclemaster cascade;

2757

2758

--* RestoreFromTempTable

2759

create table vehiclemaster (

2760

  VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'

2761

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

2762

  , VehicleName varchar(100) not null comment '???????'

2763

  , RegistrationNumber varchar(30) comment '?o?^???'

2764

  , IdentificationNumber varchar(30) comment '?????'

2765

  , ModelCode varchar(30) comment '?^??'

2766

  , DepartmentCode decimal(5,0) unsigned not null comment '???????'

2767

  , VehicleScheduleFlg decimal(1,0) not null comment '????\??\???t???O'

2768

  , PurchaseDate date comment '?w????'

2769

  , PurchaseName varchar(30) comment '?w????'

2770

  , PurchaseContactPersons varchar(30) comment '?w????S????'

2771

  , PurchasePhone varchar(13) comment '?w????d?b???'

2772

  , LeaseDate date comment '???[?X?J?n??'

2773

  , LeaseDestination varchar(30) comment '???[?X??'

2774

  , LeaseContactPersons varchar(30) comment '???[?X??S????'

2775

  , LeasePhone varchar(13) comment '???[?X??d?b???'

2776

  , InsuranceCompany varchar(30) comment '?C???????'

2777

  , InsuranceContactPersons varchar(30) comment '?C???????S????'

2778

  , InsurancePhone varchar(13) comment '?C???????d?b???'

2779

  , Note varchar(300) comment '???l'

2780

  , EntryDate datetime comment '?o?^???t'

2781

  , UpdateDate datetime comment '?X?V???t'

2782

  , constraint vehiclemaster_PKC primary key (VehicleCode)

2783

) comment '????}?X?^' ;

2784

2785

-- ????L?^?f?[?^

2786

--* BackupToTempTable

2787

drop table if exists vehiclerecorddata cascade;

2788

2789

--* RestoreFromTempTable

2790

create table vehiclerecorddata (

2791

  VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'

2792

  , DivisionCode decimal(2,0) unsigned not null comment '?f?[?^??'

2793

  , SeqNo decimal(2,0) not null comment '?}??'

2794

  , RecordDate date comment '???n??'

2795

  , Mileage mediumint(9) comment '???s????'

2796

  , Content varchar(100) comment '???e'

2797

  , PaymentCost decimal(10,0) comment '??p'

2798

  , EntryDate datetime not null comment '?o?^???t'

2799

  , UpdateDate datetime not null comment '?X?V???t'

2800

  , constraint vehiclerecorddata_PKC primary key (VehicleCode,DivisionCode,SeqNo)

2801

) comment '????L?^?f?[?^' ;

2802

2803

-- ????\??f?[?^

2804

--* BackupToTempTable

2805

drop table if exists vehiclescheduledata cascade;

2806

2807

--* RestoreFromTempTable

2808

create table vehiclescheduledata (

2809

  TargetDate date not null comment '????'

2810

  , VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'

2811

  , MorningAfternoon decimal(1,0) not null comment '??O?E???'

2812

  , PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

2813

  , TargetYear year(4) not null comment '?Y???N'

2814

  , TargetMonth tinyint(3) unsigned not null comment '?Y????'

2815

  , TargetDay year(4) not null comment '?Y????'

2816

  , EntryDate datetime not null comment '?o?^???t'

2817

  , UpdateDate datetime not null comment '?X?V???t'

2818

  , constraint vehiclescheduledata_PKC primary key (TargetDate,VehicleCode,MorningAfternoon)

2819

) comment '????\??f?[?^' ;

2820

2821

create index VehicleScheduleData_Index1

2822

  on vehiclescheduledata(TargetYear);

2823

2824

create index VehicleScheduleData_Index2

2825

  on vehiclescheduledata(TargetMonth);

2826

2827

create index VehicleScheduleData_Index3

2828

  on vehiclescheduledata(TargetDay);

2829

2830

-- ?N?}?X?^

2831

--* BackupToTempTable

2832

drop table if exists yearmaster cascade;

2833

2834

--* RestoreFromTempTable

2835

create table yearmaster (

2836

  years smallint(6) not null comment '?N'

2837

  , constraint yearmaster_PKC primary key (years)

2838

) comment '?N?}?X?^' ;

プロジェクト

全般

プロフィール

工事管理システム製品化対応

h-you / trunk / ddl / ProcessManagement.sql @ 451