Index: branches/ddl/create_table_mysql.sql
===================================================================
--- branches/ddl/create_table_mysql.sql	(revision 89)
+++ branches/ddl/create_table_mysql.sql	(revision 90)
@@ -1,1025 +1,358 @@
-CREATE TABLE ACTIONSCHEDULEDATA
-(	TARGETDATE DATE NOT NULL,
-	PERSONCODE NUMERIC(8,0) NOT NULL,
-	ACTIONSCHEDULE VARCHAR(30),
-	TARGETYEAR NUMERIC(4,0) NOT NULL,
-	TARGETMONTH NUMERIC(2,0) NOT NULL,
-	TARGETDAY NUMERIC(2,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL,
-	 PRIMARY KEY(TARGETDATE, PERSONCODE)
-);
+-- Project Name : noname
+-- Date/Time    : 2017/04/28 18:49:40
+-- Author       : yamauchi
+-- RDBMS Type   : MySQL
+-- Application  : A5:SQL Mk-2
 
-CREATE TABLE APPROVALMASTER
-(	APPROVALCODE NUMERIC(3,0) NOT NULL,
-	DEPARTMENTCODE NUMERIC(5,0) NOT NULL,
-	SEQNO NUMERIC(2,0) NOT NULL,
-	DISPLAYORDER NUMERIC(2,0) NOT NULL,
-	APPROVALPERSON NUMERIC(8,0) NOT NULL,
-	APPROVALAUTHORITY NUMERIC(1,0) NOT NULL,
-	ENTRYDATE DATETIME,
-	UPDATEDATE DATETIME,
-	 PRIMARY KEY (APPROVALCODE, DEPARTMENTCODE, SEQNO)
-);
+-- ‹â�s‰c‹Æ“úƒ}ƒXƒ^
+drop table if exists bankbusinessdaymaster cascade;
 
-CREATE TABLE BUSINESSTYPEMASTER
-(	BUSINESSTYPECODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	BUSINESSTYPENAME VARCHAR(100) DEFAULT '' NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL,
-	 PRIMARY KEY (BUSINESSTYPECODE)
-);
+create table bankbusinessdaymaster (
+  YEARMONTH decimal(6,0) default '0' not null comment '”NŒŽ'
+  , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '‹â�s‰c‹Æ“ú'
+  , NOTE varchar(120) comment '”õ�l'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint bankbusinessdaymaster_PKC primary key (YEARMONTH,BANKBUSINESSDAY)
+) comment '‹â�s‰c‹Æ“úƒ}ƒXƒ^' ;
 
-CREATE TABLE COMMONCOSTLARGE
-(	LARGECODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	LARGENAME VARCHAR(50) DEFAULT '' NOT NULL,
-	COMMENTTEXT VARCHAR(120),
-	DELETEFLG NUMERIC(1,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL,
-	 PRIMARY KEY (LARGECODE)
-);
+-- ‹ÆŽÒ�¿‹�ƒf�[ƒ^
+drop table if exists billingdata cascade;
 
-CREATE TABLE COMMONCOSTLINKMS 
-(	LARGECODE NUMERIC(5,0) NOT NULL, 
-	MIDDLECODE NUMERIC(5,0) NOT NULL,
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	ENTRYDATE DATETIME,
-	UPDATEDATE DATETIME, 
-	 PRIMARY KEY (LARGECODE, MIDDLECODE, ITEMCODE) 
-);
+create table billingdata (
+  COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)
+) comment '‹ÆŽÒ�¿‹�ƒf�[ƒ^' ;
 
-CREATE TABLE COMMONCOSTMIDDLE 
-(	LARGECODE NUMERIC(5,0) NOT NULL, 
-	MIDDLECODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	MIDDLENAME VARCHAR(50) DEFAULT '' NOT NULL, 
-	COMMENTTEXT VARCHAR(120),
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (LARGECODE, MIDDLECODE) 
-);
+-- ‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^
+drop table if exists billingdatadetail cascade;
 
-CREATE TABLE COMMONCOSTMIDDLESEARCHWORD 
-(	LARGECODE NUMERIC(5,0) NOT NULL, 
-	MIDDLECODE NUMERIC(5,0) NOT NULL,
-	SEQNO NUMERIC(5,0) NOT NULL, 
-	SEARCHWORD VARCHAR(50) DEFAULT '' NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (LARGECODE, MIDDLECODE, SEQNO)
-);
+create table billingdatadetail (
+  COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , CONSTRUCTIONCODE decimal(10,0) comment '�HŽ–”Ô�†'
+  , FIELDNAME varchar(120) comment 'Œ»�ê–¼'
+  , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
+  , HIGHWPRICE decimal(10,0) comment '�‚‘¬‘ã'
+  , HARDWPRICE decimal(10,0) comment '‹à•¨‘ã'
+  , INDSWASTETAX decimal(10,0) comment 'ŽY”p�Å'
+  , NOTE varchar(120) comment '”õ�l'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
+) comment '‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^' ;
 
-CREATE TABLE COMPONENTLINKMASTER
-(	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0),
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (COMPONENTCODE, ITEMCODE) 
-);
+-- ‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^
+drop table if exists billingpaymentsummary cascade;
 
-CREATE TABLE COMPONENTMASTER
-(	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	COMPONENTNAME VARCHAR(120) DEFAULT '' NOT NULL, 
-	SUBITEMSFLG NUMERIC(1,0), 
-	DIRECTINPUTFLG NUMERIC(1,0),
-	MYEXPENSESFLG NUMERIC(1,0), 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (COMPONENTCODE) 
-);
+create table billingpaymentsummary (
+  COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
+  , CHARGEPAYMENTKIND decimal(1,0) default '0' not null comment '�¿‹�Žx•¥‹æ•ª'
+  , PAYDAY date comment 'Žx•¥“ú'
+  , BILLPRICESTOTAL decimal(10,0) comment '�¿‹�‹àŠz�¬Œv'
+  , CONSUMPTIONTAXRATE decimal(6,3) comment '�Á”ï�Å—¦'
+  , CONSUMPTIONTAXPRICE decimal(10,0) comment '�Á”ï�ÅŠz'
+  , HIGHWPRICESTOTAL decimal(10,0) comment '�‚‘¬‘ã�¬Œv'
+  , HARDWPRICESTOTAL decimal(10,0) comment '‹à•¨‘ã�¬Œv'
+  , INDSWASTETAXSTOTAL decimal(10,0) comment 'ŽY”p�Å�¬Œv'
+  , CNSTRPRICERATE decimal(6,3) comment '‹¦—Í‹à”ä—¦'
+  , CNSTRPRICESTOTAL decimal(10,0) comment '‹¦—Í‹à�¬Œv'
+  , BILLINGPRICETOTAL decimal(10,0) comment '�¿‹�‹àŠz�‡Œv'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND)
+) comment '‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^' ;
 
-CREATE TABLE CONSTRUCTIONBASEINFO 
-(	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	TYINGFLG NUMERIC(1,0) NOT NULL,
-	CONSTRUCTIONYEAR NUMERIC(4,0) NOT NULL,
-	CONSTRUCTIONPERIOD NUMERIC(4,0) NOT NULL,
-	REQUESTEDDATE DATE,
-	ESTIMATESSUBMITDEADLINE DATE,
-	ESTIMATESSUBMITTEDDATE DATE, 
-	PROVISIONALORDERDATE DATE, 
-	ORDERDATE DATE,
-	ORDERSTARTINGDATE DATE,
-	ORDERCOMPLETIONDATE DATE,
-	PREPARATIONSTARTDATE DATE, 
-	CONSTRUCTIONSTARTINGDATE DATE, 
-	CONSTRUCTIONCOMPLETIONDATE DATE, 
-	NONORDERDATE DATE, 
-	ORDERSDECISIONPRICE NUMERIC(12,2) NOT NULL,
-	ORDERSDECISIONPRICEINTAX NUMERIC(12,2) NOT NULL, 
-	SALESPERSONCODE NUMERIC(8,0), 
-	CONSTRUCTIONPERSONCODE NUMERIC(8,0) NOT NULL,
-	CONSTRSUBPERSONCODE NUMERIC(8,0) NOT NULL, 
-	CONSTRUCTIONINSTRUCTOR NUMERIC(8,0) NOT NULL,
-	TRANSFERCONSTRUCTION NUMERIC(8,0) NOT NULL,
-	TRANSFERCONSTRUCTIONDATE DATE, 
-	ORDERERSDIVISION NUMERIC(5,0) NOT NULL,
-	ORDERERSCODE NUMERIC(5,0) NOT NULL,
-	ESTIMATESEXPIRATIONDATE DATE,
-	CONSTRUCTIONPERIODSTART DATE,
-	CONSTRUCTIONPERIODEND DATE,
-	CONSTRUCTIONPERIODSTART2 DATE, 
-	CONSTRUCTIONPERIODEND2 DATE, 
-	STARTDATE DATE,
-	ENDDATE DATE,
-	PURCHASEORDERMAILINGDATE DATE, 
-	PURCHASEORDERRETURNDATE DATE,
-	PURCHASEORDERRETURNCHECKDATE DATE, 
-	CONSUMPTIONTAXFLG NUMERIC(1,0) NOT NULL, 
-	PRIMECONTRACTORFLG NUMERIC(1,0) NOT NULL,
-	SALESCOSTFLG NUMERIC(1,0) NOT NULL,
-	CONSTRUCTIONSTATUSFLG NUMERIC(2,0) NOT NULL, 
-	CONSTRUCTIONTYPE NUMERIC(5,0) NOT NULL,
-	ESTIMATETYPE NUMERIC(1,0) NOT NULL,
-	BILLINGSTARTDATE DATE NOT NULL, 
-	BILLINGDATE DATE NOT NULL,
-	BILLINGSPLITFLG NUMERIC(1,0) NOT NULL, 
-	BILLINGSENDDATE DATE,
-	LEDGERCOMPLATEDATE DATE NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE)
-);
+-- �HŽ–Ž‘�Þ�î•ñ
+drop table if exists constructionmaterialinfo cascade;
 
-CREATE TABLE CONSTRUCTIONBASEINFODETAIL 
-(	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	DETAILNO NUMERIC(2,0) NOT NULL,
-	DETAILSTRING VARCHAR(120), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, DETAILNO)
-);
+create table constructionmaterialinfo (
+  CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '�HŽ–”Ô�†'
+  , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
+  , RENTCOUNT smallint(5) unsigned comment '‘Ý�o�”'
+  , REPAYCOUNT smallint(5) unsigned comment '•Ô‹p�”'
+  , COMPLETEFLG tinyint(3) unsigned comment 'Š®—¹ƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE)
+) comment '�HŽ–Ž‘�Þ�î•ñ' ;
 
-CREATE TABLE CONSTRUCTIONBUDGET 
-(	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	CREATORCODE NUMERIC(8,0) NOT NULL, 
-	CREATORNAME VARCHAR(60), 
-	CREATORCOSTS NUMERIC(11,3) NOT NULL, 
-	ASSISTANTCODE NUMERIC(8,0) NOT NULL, 
-	ASSISTANTNAME VARCHAR(60), 
-	ASSISTANTCOSTS NUMERIC(11,3) NOT NULL, 
-	INSTRUCTORCODE NUMERIC(8,0) NOT NULL,
-	INSTRUCTORNAME VARCHAR(60),
-	INSTRUCTORCOSTS NUMERIC(11,3) NOT NULL,
-	CREATEDATE DATE NOT NULL, 
-	CONSTRUCTIONTIMES NUMERIC(5,2) NOT NULL, 
-	CONSTRUCTIONSTART DATE NOT NULL,
-	CONSTRUCTIONEND DATE NOT NULL,
-	INSTRUCTORTIMES NUMERIC(5,2) NOT NULL, 
-	SALARYFLG NUMERIC(1,0) NOT NULL, 
-	SALARYDAYS NUMERIC(4,0) NOT NULL,
-	A_SALARYFLG NUMERIC(1,0) NOT NULL, 
-	A_SALARYDAYS NUMERIC(4,0) NOT NULL,
-	I_SALARYFLG NUMERIC(1,0) NOT NULL, 
-	I_SALARYDAYS NUMERIC(4,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE)
-);
+-- ’÷“úƒ}ƒXƒ^
+drop table if exists deadlinemaster cascade;
 
-CREATE TABLE CONSTRUCTIONBUDGETDETAIL 
-(	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	GROUPCOUNT NUMERIC(2,0) NOT NULL,
-	LINECOUNT NUMERIC(3,0) NOT NULL, 
-	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	FIRSTSTRING VARCHAR(120),
-	SECONDSTRING VARCHAR(120), 
-	COMPANYTYPE NUMERIC(1,0) NOT NULL, 
-	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	COMPANYNAME VARCHAR(120),
-	ESTIMATEPRICE NUMERIC(12,2) NOT NULL,
-	NEGOTIATIONPRICE NUMERIC(12,2) NOT NULL, 
-	ORDERDESIREDAMOUNT NUMERIC(12,2) NOT NULL, 
-	EXECUTIONAMOUNT NUMERIC(12,2) NOT NULL,
-	AMOUNTCONFIGRATE NUMERIC(5,2) NOT NULL,
-	NEGOTIATEFLG NUMERIC(1,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, GROUPCOUNT, LINECOUNT) 
-);
+create table deadlinemaster (
+  LABOURKIND decimal(1,0) default '0' not null comment 'ŽèŠÔ‹ÆŽÒ‹æ•ª'
+  , DEADLINE decimal(2,0) comment '’÷“ú'
+  , PAYDAY decimal(2,0) comment 'Žx•¥“ú'
+  , NOTE varchar(120) comment '”õ�l'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint deadlinemaster_PKC primary key (LABOURKIND)
+) comment '’÷“úƒ}ƒXƒ^' ;
 
-CREATE TABLE CONSTRUCTIONITEMMASTER 
-(	ITEMCODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	ITEMNAME VARCHAR(120) DEFAULT '' NOT NULL,
-	SUBITEMSFLG NUMERIC(1,0), 
-	MYEXPENSESFLG NUMERIC(1,0) NOT NULL, 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (ITEMCODE)
-);
+-- “ü‹àŠm”F�³”Fƒf�[ƒ^
+drop table if exists depositapprovalinfo cascade;
 
-CREATE TABLE CONSTRUCTIONLEDGER 
-(	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	CONSTRUCTIONPERIOD NUMERIC(4,0) NOT NULL,
-	CREATORCODE NUMERIC(8,0), 
-	CREATORNAME VARCHAR(60), 
-	CREATEDATE DATE NOT NULL, 
-	CONSTRUCTIONTIMES NUMERIC(5,2) NOT NULL, 
-	CONSTRUCTIONSTART DATE NOT NULL,
-	CONSTRUCTIONEND DATE NOT NULL,
-	ORDERSDECISIONPRICE NUMERIC(14,2) NOT NULL,
-	COMPANYEXPENSES NUMERIC(10,2) NOT NULL,
-	DEPARTMENTEXPENSES NUMERIC(10,2) NOT NULL, 
-	SALESEXPENSES NUMERIC(10,2) NOT NULL,
-	TOTALPAYMENT NUMERIC(10,2) NOT NULL, 
-	GROSSPROFIT NUMERIC(10,2) NOT NULL,
-	ALLOWANCE NUMERIC(10,2) NOT NULL,
-	NETPROFIT NUMERIC(10,2) NOT NULL,
-	COMPLATEFLG NUMERIC(1,0) NOT NULL, 
-	INTEGRATIONFLG NUMERIC(1,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE)
-);
+create table depositapprovalinfo (
+  ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , TARGETDATE decimal(6,0) not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) not null comment '�s”Ô�†'
+  , APPROVALNO decimal(3,0) not null comment '�³”F�‡�˜'
+  , APPROVALPERSON decimal(8,0) comment '�³”FŽÒƒR�[ƒh'
+  , APPROVALPERSONNAME varchar(20) comment '�³”FŽÒ–¼'
+  , APPROVALAUTHORITY decimal(1,0) comment '�³”FŒ ŒÀ‹æ•ª'
+  , APPROVALDATE date comment '�³”F“ú•t'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint depositapprovalinfo_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)
+) comment '“ü‹àŠm”F�³”Fƒf�[ƒ^' ;
 
-CREATE TABLE CONSTRUCTIONLEDGERDETAIL 
-(	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	GROUPCOUNT NUMERIC(2,0) NOT NULL,
-	LINECOUNT NUMERIC(3,0) NOT NULL, 
-	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	FIRSTSTRING VARCHAR(120),
-	SECONDSTRING VARCHAR(120), 
-	COMPANYTYPE NUMERIC(1,0) NOT NULL, 
-	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	COMPANYNAME VARCHAR(120),
-	ESTIMATEPRICE NUMERIC(12,2) NOT NULL,
-	EXECUTIONAMOUNT NUMERIC(12,2) NOT NULL,
-	AMOUNTCONFIGRATE NUMERIC(5,2) NOT NULL,
-	PAYMENTBURDEN NUMERIC(12,2) NOT NULL,
-	FIXDATAFLG NUMERIC(1,0) NOT NULL,
-	INDEPENDENTFLG NUMERIC(1,0) NOT NULL,
-	FLUCTUATIONFLG NUMERIC(1,0) NOT NULL,
-	SALARYFLG NUMERIC(1,0) NOT NULL, 
-	SALARYDAYS NUMERIC(4,0) NOT NULL,
-	OPERATINGFLG NUMERIC(1,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, GROUPCOUNT, LINECOUNT) 
-);
+-- “ü‹àƒf�[ƒ^
+drop table if exists depositdata cascade;
 
-CREATE TABLE CONSTRUCTIONLEDGEREXCUTE 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	GROUPCOUNT NUMERIC(2,0) NOT NULL,
-	LINECOUNT NUMERIC(3,0) NOT NULL, 
-	COLUMNCOUNT NUMERIC(3,0) NOT NULL, 
-	PAYMENTAMOUNT NUMERIC(12,2) NOT NULL,
-	TARGETMONTH DATE NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, GROUPCOUNT, LINECOUNT, COLUMNCOUNT)
-);
+create table depositdata (
+  ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , TARGETDATE decimal(6,0) not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) not null comment '˜A”Ô'
+  , BusinessPeriod decimal(4,0) comment '‰c‹ÆŠú'
+  , DEPOSITDATE date comment '“ü‹à“ú'
+  , DepositAmount decimal(12,0) comment '“ü‹à‹àŠz'
+  , DEPOSITAMOUNTCASH decimal(10,0) comment '“ü‹à‹àŠz�iŒ»‹à�j'
+  , DEPOSITAMOUNTBILL decimal(10,0) comment '“ü‹à‹àŠz�iŽèŒ`�j'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint depositdata_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO)
+) comment '“ü‹àƒf�[ƒ^' ;
 
-CREATE TABLE CONSTRUCTIONLINK 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	FLUCTUATIONCODE NUMERIC(10,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, FLUCTUATIONCODE) 
-);
+-- “ü‹à–¾�×ƒf�[ƒ^
+drop table if exists depositdatadetail cascade;
 
-CREATE TABLE CONSTRUCTIONPROGRESSDATE 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	CONSTRUCTIONSTATUSFLG NUMERIC(2,0) NOT NULL, 
-	PREVIOUSSTATUSFLG NUMERIC(2,0), 
-	CHANGEDATE DATE NOT NULL, 
-	CHANGEPERSONCODE NUMERIC(8,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, CONSTRUCTIONSTATUSFLG) 
-);
+create table depositdatadetail (
+  ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , TARGETDATE decimal(6,0) not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) not null comment '�s”Ô�†'
+  , REQUESTNO decimal(10,0) comment '�¿‹�No'
+  , ORDERNO decimal(2,0) comment 'Žó•t”Ô�†'
+  , DEPOSITAMOUNT decimal(10,0) comment '“ü‹à‹àŠz'
+  , DISCOUNTAMOUNT decimal(10,0) comment '’lˆø‚«‹àŠz'
+  , CNSTRPRICE decimal(10,0) comment '‹¦—Í‹à'
+  , FEES decimal(10,0) comment 'Žè�”—¿'
+  , OTHERADJUSTMENTS decimal(10,0) comment '‚»‚Ì‘¼’²�®'
+  , CARRYAMOUNT decimal(10,0) comment 'ŒJ‰z‹àŠz'
+  , APPROVALPERSONCODE decimal(8,0) comment '�³”F’S“–ŽÒƒR�[ƒh'
+  , APPROVALDATE date comment '’S“–ŽÒ�³”F“ú•t'
+  , APPROVALENDFLG decimal(1,0) comment '�³”FŠ®—¹ƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT)
+) comment '“ü‹à–¾�×ƒf�[ƒ^' ;
 
-CREATE TABLE CONSTRUCTIONSPECMASTER 
- (	ITEMCODE NUMERIC(5,0) NOT NULL,
-	SPECCODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	ITEMNAME VARCHAR(120) DEFAULT '',
-	SPECNAME VARCHAR(120), 
-	UNITNAME VARCHAR(30),
-	UNITPRICE NUMERIC(9,2) NOT NULL, 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (ITEMCODE, SPECCODE)
-);
+-- �¿‹��‘ƒf�[ƒ^
+drop table if exists invoicedata cascade;
 
-CREATE TABLE CONSTRUCTIONSPECUNITPRICE
- (	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	SPECCODE NUMERIC(5,0) NOT NULL,
-	CONSTRUCTIONTYPECODE NUMERIC(5,0) NOT NULL,
-	UNITPRICE NUMERIC(9,2) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (COMPONENTCODE, ITEMCODE, SPECCODE, CONSTRUCTIONTYPECODE) 
-);
+create table invoicedata (
+  INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
+  , ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , REQUESTMONTH decimal(6,0) not null comment '�¿‹�ŒŽ'
+  , SEQNO decimal(2,0) not null comment '˜A”Ô'
+  , CRETATEDATE date not null comment '�ì�¬“ú'
+  , REQUESTDATE date not null comment '�¿‹�“ú'
+  , REQUESTNAME varchar(120) comment '�¿‹��æ–¼'
+  , TOTALAMOUNT decimal(10,0) comment '�Å�ž‚Ý�‡Œv‹àŠz'
+  , TAXAMOUNT decimal(10,0) comment '�Á”ï�Å‹àŠz'
+  , COMMENT1 varchar(60) comment 'ƒRƒ�ƒ“ƒg1'
+  , COMMENT2 varchar(60) comment 'ƒRƒ�ƒ“ƒg2'
+  , COMMENT3 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg3'
+  , COMMENT4 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg4'
+  , COMMENT5 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg5'
+  , COMPLETEFLG decimal(1,0) default '0' not null comment 'Š®—¹ƒtƒ‰ƒO'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint invoicedata_PKC primary key (INVOICENO)
+) comment '�¿‹��‘ƒf�[ƒ^' ;
 
-CREATE TABLE CONSTRUCTIONTYPEMASTER 
- (	TYPECODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	NAMESTRING VARCHAR(100) DEFAULT '' NOT NULL,
-	PUBLICFLG NUMERIC(1,0) NOT NULL, 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (TYPECODE)
-);
+alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
 
-CREATE TABLE COSTDATAOFPERSON 
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	ACTIONDATE DATE NOT NULL, 
-	DATATYPE NUMERIC(1,0) NOT NULL,
-	DATAADDCOUNT NUMERIC(5,0) NOT NULL,
-	TARGETMONTH VARCHAR(7) NOT NULL, 
-	CONSTRUCTIONCODE NUMERIC(10,0), 
-	SUPPLIERSCODE NUMERIC(5,0) NOT NULL, 
-	SUPPLIERSNAME VARCHAR(120),
-	PAYMENTCONTENT VARCHAR(60),
-	PAYMENTTYPE NUMERIC(1,0) NOT NULL, 
-	ENTRYPRICE NUMERIC(12,2) NOT NULL, 
-	COMPLATEFLG NUMERIC(1,0) NOT NULL, 
-	APPROVALFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, ACTIONDATE, DATATYPE, DATAADDCOUNT)
-);
+-- Ž‘�Þ�î•ñ
+drop table if exists materialinfo cascade;
 
-CREATE TABLE DAILYDATACONSTRUCTION
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DAILYDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	WEATHER VARCHAR(60), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, DAILYDATADATE, CONSTRUCTIONCODE) 
-);
+create table materialinfo (
+  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
+  , MATERIALCOUNT smallint(5) unsigned comment 'Ž‘�Þ�”'
+  , RENTCOUNT smallint(5) unsigned comment '‘Ý�o‰Â”\�”'
+  , DELETEFLG smallint(5) unsigned comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint materialinfo_PKC primary key (MATERIALITEMCODE)
+) comment 'Ž‘�Þ�î•ñ' ;
 
-CREATE TABLE DAILYDATADETAIL
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DAILYDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	JOBCATEGORYCODE NUMERIC(5,0) NOT NULL, 
-	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	TODAYHEADCOUNT NUMERIC(3,0) NOT NULL,
-	TOTALHEADCOUNT NUMERIC(4,0) NOT NULL,
-	TODAYWORK VARCHAR(100),
-	NEXTDAYWORK VARCHAR(100),
-	NEXTDAYHEADCOUNT NUMERIC(3,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, DAILYDATADATE, CONSTRUCTIONCODE, SEQNO)
-);
+-- Ž‘�Þ•i–Úƒ}ƒXƒ^
+drop table if exists materialitemmaster cascade;
 
-CREATE TABLE DAILYDATAFIELD 
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DAILYDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	PATROLTIME DATE NOT NULL, 
-	CONTENTSTEXT VARCHAR(200), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, DAILYDATADATE, CONSTRUCTIONCODE, SEQNO)
-);
+create table materialitemmaster (
+  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
+  , MATERIALKINDCODE smallint(5) unsigned comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
+  , MATERIALITEMNAME varchar(40) comment 'Ž‘�Þ•i–Ú–¼�Ì'
+  , DISPLAYORDER smallint(5) unsigned comment '•\Ž¦�‡'
+  , DELETEFLG tinyint(3) unsigned comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint materialitemmaster_PKC primary key (MATERIALITEMCODE)
+) comment 'Ž‘�Þ•i–Úƒ}ƒXƒ^' ;
 
-CREATE TABLE DAILYDATAMATERIALS 
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DAILYDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	MATERIALS VARCHAR(100),
-	QUANTITY VARCHAR(100), 
-	PRODUCTION VARCHAR(100), 
-	DELIVERY VARCHAR(100), 
-	QUALITYCONTROL VARCHAR(100), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, DAILYDATADATE, CONSTRUCTIONCODE, SEQNO)
-);
+-- Ž‘�ÞŽí—Þƒ}ƒXƒ^
+drop table if exists materialkindmaster cascade;
 
-CREATE TABLE DAILYDATASUBCONTRACTORS
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DAILYDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	ATTENDEE VARCHAR(100), 
-	CONTENTSTEXT VARCHAR(200), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, DAILYDATADATE, CONSTRUCTIONCODE, SEQNO)
-);
+create table materialkindmaster (
+  MATERIALKINDCODE smallint(5) unsigned default 0 not null comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
+  , MATERIALKINDNAME varchar(40) comment 'Ž‘�ÞŽí—Þ–¼�Ì'
+  , DISPLAYORDER smallint(5) unsigned comment '•\Ž¦�‡'
+  , DELETEFLG tinyint(3) unsigned comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint materialkindmaster_PKC primary key (MATERIALKINDCODE)
+) comment 'Ž‘�ÞŽí—Þƒ}ƒXƒ^' ;
 
-CREATE TABLE DAILYDATAVEHICLES
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DAILYDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	MODEL VARCHAR(100),
-	PERFORMANCE VARCHAR(100),
-	OWNER VARCHAR(100),
-	DRIVER VARCHAR(100), 
-	STARTWORKINGTIME DATE NOT NULL, 
-	ENDWORKINGTIME DATE NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, DAILYDATADATE, CONSTRUCTIONCODE, SEQNO)
-);
+-- Ž‘�Þ—š—ð�î•ñ
+drop table if exists materialrecordinfo cascade;
 
-CREATE TABLE DEPARTMENTEXPENSESMASTER 
- (	DEPARTMENTCODE NUMERIC(5,0) NOT NULL,
-	EXPENSESPERIOD NUMERIC(4,0) NOT NULL,
-	NAMECODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	EXPENSESRATIO NUMERIC(4,2) NOT NULL, 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (DEPARTMENTCODE, EXPENSESPERIOD, NAMECODE)
-);
+create table materialrecordinfo (
+  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
+  , PROCESSDATE date default '0000-00-00' not null comment '�ˆ—�”NŒŽ“ú'
+  , SEQNO smallint(5) unsigned default 0 not null comment '˜A”Ô'
+  , RECKIND tinyint(3) unsigned comment 'ƒŒƒR�[ƒh‹æ•ª'
+  , CONSTRUCTIONCODE int(10) unsigned comment '�HŽ–”Ô�†'
+  , PERSONCODE int(10) unsigned comment '’S“–ŽÒƒR�[ƒh'
+  , MATERIALCOUNT smallint(5) unsigned comment 'Ž‘�Þ�”'
+  , REPAYPLANDATE date comment '•Ô‹p—\’è”NŒŽ“ú'
+  , COMMENTTEXT varchar(80) comment 'ƒRƒ�ƒ“ƒg'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint materialrecordinfo_PKC primary key (MATERIALITEMCODE,PROCESSDATE,SEQNO)
+) comment 'Ž‘�Þ—š—ð�î•ñ' ;
 
-CREATE TABLE DEPARTMENTMASTER 
- (	DEPARTMENTCODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	DEPARTMENTSTRING VARCHAR(100) DEFAULT '' NOT NULL,
-	ACTIONSCHEDULEFLG NUMERIC(1,0) NOT NULL, 
-	STAFFASSIGNFLG NUMERIC(1,0) NOT NULL,
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (DEPARTMENTCODE)
-);
+-- Žx•¥�³”F�î•ñƒf�[ƒ^
+drop table if exists paymentapprovalinfo cascade;
 
-CREATE TABLE DIVISIONMASTER 
- (	DIVISIONCODE NUMERIC(5,0) NOT NULL,
-	NAMECODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	NAMESTRING VARCHAR(100) DEFAULT '' NOT NULL,
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (DIVISIONCODE, NAMECODE)
-);
+create table paymentapprovalinfo (
+  COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , APPROVALNO decimal(3,0) default '0' not null comment '�³”F�‡�˜'
+  , APPROVALPERSON decimal(8,0) comment '�³”FŽÒƒR�[ƒh'
+  , APPROVALPERSONNAME varchar(20) comment '�³”FŽÒ–¼'
+  , APPROVALAUTHORITY decimal(1,0) comment '�³”FŒ ŒÀ‹æ•ª'
+  , APPROVALDATE date comment '�³”F“ú•t'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint paymentapprovalinfo_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)
+) comment 'Žx•¥�³”F�î•ñƒf�[ƒ^' ;
 
-CREATE TABLE ESTIMATEBUDGET 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	CONSTRUCTIONTIME NUMERIC(5,2) NOT NULL,
-	INTEGRATEDCODE NUMERIC(8,0) NOT NULL,
-	DATACREATEDATE DATE NOT NULL, 
-	RETVALUE1 NUMERIC(12,2) NOT NULL,
-	RETVALUE2 NUMERIC(12,2) NOT NULL,
-	RETVALUE3 NUMERIC(12,2) NOT NULL,
-	RETVALUE4 NUMERIC(12,2) NOT NULL,
-	RETPERCENT NUMERIC(5,2) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME, 
-	 PRIMARY KEY (CONSTRUCTIONCODE)
-);
+-- Žx•¥–¾�×ƒf�[ƒ^
+drop table if exists paymentdatadetail cascade;
 
-CREATE TABLE ESTIMATEBUDGETDETAIL 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	GROUPCOUNT NUMERIC(2,0) NOT NULL,
-	LINECOUNT NUMERIC(3,0) NOT NULL, 
-	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0),
-	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	FIRSTSTRING VARCHAR(120),
-	SECONDSTRING VARCHAR(120), 
-	ESTIMATEPRICE NUMERIC(12,2) NOT NULL,
-	NEGOTIATIONPRICE NUMERIC(12,2) NOT NULL, 
-	NOTES VARCHAR(120),
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, GROUPCOUNT, LINECOUNT) 
-);
+create table paymentdatadetail (
+  COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
+  , DISCOUNTPRICE decimal(10,0) comment '’lˆø‚«‹àŠz'
+  , OFFSETPRICE decimal(10,0) comment '‘ŠŽE‹àŠz'
+  , NEXTCOPRICE decimal(10,0) comment 'ŽŸ‰ñŒJ‰z'
+  , HIGHWPRICE decimal(10,0) comment '�‚‘¬‘ã'
+  , HARDWPRICE decimal(10,0) comment '‹à•¨‘ã'
+  , INDSWASTETAX decimal(10,0) comment 'ŽY”p�Å'
+  , CNSTRPRICE decimal(10,0) comment '‹¦—Í‹à'
+  , CNSTRPRICEEXIST decimal(1,0) comment '‹¦—Í‹à—L–³'
+  , APPROVALPERSONCODE decimal(8,0) comment '�³”F’S“–ŽÒƒR�[ƒh'
+  , APPROVALDATE date comment '’S“–ŽÒ�³”F“ú•t'
+  , APPROVALENDFLG decimal(1,0) comment '�³”FŠ®—¹ƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
+) comment 'Žx•¥–¾�×ƒf�[ƒ^' ;
 
-CREATE TABLE ESTIMATEDATA 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	LINECOUNT NUMERIC(3,0) NOT NULL, 
-	COMPONENTCODE NUMERIC(3,0) NOT NULL, 
-	FIXEDITEMCODE VARCHAR(1), 
-	ITEMNAME VARCHAR(120), 
-	WORKNAME VARCHAR(120), 
-	PRICEVALUE NUMERIC(14,2) NOT NULL, 
-	NOTE VARCHAR(60),
-	MYEXPENSESFLG NUMERIC(1,0) NOT NULL, 
-	INPUTFLG NUMERIC(1,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, LINECOUNT) 
-);
+-- �¿‹�ƒf�[ƒ^
+drop table if exists requestdata cascade;
 
-CREATE TABLE ESTIMATEDATABODY 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	PAGECOUNT NUMERIC(4,0) NOT NULL, 
-	CATEGORY NUMERIC(1,0) NOT NULL,
-	UNIONCOMPONENTCODE NUMERIC(5,0) NOT NULL,
-	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	SELECTCOMPONENT NUMERIC(5,0) NOT NULL, 
-	PAGETITLE VARCHAR(120) NOT NULL,
-	DETAILLINECOUNT NUMERIC(3,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, PAGECOUNT) 
-);
+create table requestdata (
+  REQUESTNO decimal(9,0) not null comment '�¿‹�No'
+  , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
+  , CONSTRUCTIONNAME varchar(120) not null comment '�HŽ–Œ�–¼'
+  , CONTRACTAMOUNT decimal(10,0) not null comment '�¿•‰‹àŠz'
+  , PAIDAMOUNT decimal(10,0) not null comment '�¿‹��Ï‹àŠz'
+  , REQUESTAMOUNT0 decimal(10,0) not null comment '�¿‹�‹àŠz‚O'
+  , REQUESTAMOUNT1 decimal(10,0) not null comment '�¿‹�‹àŠz‚P'
+  , REQUESTAMOUNT2 decimal(10,0) comment '�¿‹�‹àŠz‚Q'
+  , REQUESTAMOUNT3 decimal(10,0) comment '�¿‹�‹àŠz‚R'
+  , REQUESTAMOUNT4 decimal(10,0) comment '�¿‹�‹àŠz‚S'
+  , REQUESTAMOUNT5 decimal(10,0) comment '�¿‹�‹àŠz‚T'
+  , REQUESTAMOUNT6 decimal(10,0) comment '�¿‹�‹àŠz‚U'
+  , UNCLAIMEDAMOUNT decimal(10,0) not null comment '�¿‹�Žc‹àŠz'
+  , UNPAIDAMOUNT decimal(10,0) not null comment '–¢“ü‹à‹àŠz'
+  , TAXAMOUNT decimal(10,0) not null comment '�Á”ï�Å'
+  , NOTE varchar(120) not null comment '”õ�l'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint requestdata_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE)
+) comment '�¿‹�ƒf�[ƒ^' ;
 
-CREATE TABLE ESTIMATEDATADETAIL 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	PAGECOUNT NUMERIC(4,0) NOT NULL, 
-	LINECOUNT NUMERIC(3,0) NOT NULL, 
-	DATATYPE NUMERIC(1,0) NOT NULL,
-	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	SPECCODE NUMERIC(5,0) NOT NULL,
-	ITEMNAME VARCHAR(120), 
-	SPECNAME VARCHAR(120), 
-	UNITCOUNT NUMERIC(8,2) NOT NULL, 
-	UNITNAME VARCHAR(30),
-	UNITPRICE NUMERIC(9,2) NOT NULL, 
-	LINETOTAL NUMERIC(12,2) NOT NULL,
-	NOTE VARCHAR(60),
-	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	MYEXPENSESFLG NUMERIC(1,0) NOT NULL, 
-	INPUTFLG NUMERIC(1,0),
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, PAGECOUNT, LINECOUNT)
-);
+-- �¿‹�ƒf�[ƒ^–¾�×
+drop table if exists requestdatadetail cascade;
 
-CREATE TABLE EXPENSESMASTER 
- (	DIVISIONCODE NUMERIC(5,0) NOT NULL,
-	NAMECODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	EXPENSESRATIO NUMERIC(4,2) NOT NULL, 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (DIVISIONCODE, NAMECODE)
-);
+create table requestdatadetail (
+  REQUESTNO decimal(9,0) not null comment '�¿‹�No'
+  , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
+  , CONSTRUCTIONCODE decimal(10,0) not null comment '�HŽ–”Ô�†'
+  , CONSTRUCTIONKIND decimal(1,0) not null comment '�HŽ–‹æ•ª'
+  , REQUESTAMOUNT decimal(10,0) not null comment '�¿‹�‹àŠz'
+  , TAXAMOUNT decimal(10,0) not null comment '�Á”ï�Å'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint requestdatadetail_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE,CONSTRUCTIONCODE,CONSTRUCTIONKIND)
+) comment '�¿‹�ƒf�[ƒ^–¾�×' ;
 
-CREATE TABLE HOLIDAYCALENDERMASTER
- (	HOLIDAY DATE NOT NULL,
-	BUSINESSYEAR NUMERIC(4,0) NOT NULL,
-	TARGETMONTH NUMERIC(2,0) NOT NULL, 
-	TARGETDAY NUMERIC(2,0) NOT NULL, 
-	 PRIMARY KEY (HOLIDAY) 
-);
+-- �¿‹�ƒwƒbƒ_
+drop table if exists requesthead cascade;
 
-CREATE TABLE INPUTSEARCHLOGDATA 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	USEDPROCESSNO NUMERIC(3,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	DATATYPE NUMERIC(1,0) NOT NULL,
-	INPUTCODE NUMERIC(10,0),
-	 PRIMARY KEY (CONSTRUCTIONCODE, USEDPROCESSNO, DISPLAYORDER) 
-);
+create table requesthead (
+  REQUESTNO decimal(9,0) not null comment '�¿‹�No'
+  , REQCONSTRUCTIONCODE decimal(10,0) not null comment '�¿‹��HŽ–”Ô�†'
+  , ORDERNO decimal(2,0) not null comment 'Žó•t”Ô�†'
+  , REQUESTMONTH decimal(6,0) not null comment '�¿‹�ŒŽ'
+  , ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , ORDERERSNAME varchar(120) not null comment '”­’�ŽÒ�æ–¼'
+  , REQCONSTRUCTIONNAME varchar(120) not null comment '�¿‹��HŽ–Œ�–¼'
+  , REQUESTTOTALAMOUNT decimal(10,0) not null comment '�¿‹�‹àŠz�‡Œv'
+  , REQUESTAMOUNT decimal(10,0) not null comment '�¿‹�‹àŠz'
+  , TAXAMOUNT decimal(10,0) not null comment '�Á”ï�Å'
+  , UNPAIDAMOUNT decimal(10,0) comment '–¢“ü‹à'
+  , NOTE varchar(120) comment '”õ�l'
+  , ASSIGNEDFLG decimal(1,0) comment 'Š„“–�Ïƒtƒ‰ƒO'
+  , INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint requesthead_PKC primary key (REQUESTNO)
+) comment '�¿‹�ƒwƒbƒ_' ;
 
-CREATE TABLE MESSAGEBOARDDATA 
- (	RECORDNUMBER NUMERIC(6,0) NOT NULL,
-	BRANCHNUMBER NUMERIC(3,0) NOT NULL,
-	FROMCODE NUMERIC(8,0) NOT NULL,
-	FROMNAME VARCHAR(60) NOT NULL,
-	MESSAGETITILE VARCHAR(100),
-	MESSAGECONTENT VARCHAR(1333) NOT NULL,
-	LINKTYPE NUMERIC(2,0) NOT NULL,
-	LINKMESSAGE VARCHAR(200),
-	LINKCODE VARCHAR(30), 
-	WRITINGDATE DATE NOT NULL,
-	PERSONCODE NUMERIC(8,0) NOT NULL,
-	SHAREFLAG NUMERIC(2,0) NOT NULL, 
-	MESSAGECOLOR VARCHAR(8),
-	BACKCOLOR VARCHAR(8), 
-	MESSAGEFLAG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME,
-	UPDATEDATE DATETIME, 
-	 PRIMARY KEY (RECORDNUMBER, BRANCHNUMBER)
-);
+alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
 
-CREATE TABLE MESSAGEBOARDTERGET 
- (	RECORDNUMBER NUMERIC(6,0) NOT NULL,
-	BRANCHNUMBER NUMERIC(3,0) NOT NULL,
-	SEQNUM NUMERIC(3,0) NOT NULL,
-	TOCODE NUMERIC(8,0) NOT NULL,
-	TONAME VARCHAR(60) NOT NULL,
-	ENTRYDATE DATETIME,
-	UPDATEDATE DATETIME, 
-	 PRIMARY KEY (RECORDNUMBER, BRANCHNUMBER, SEQNUM)
-);
-
-CREATE TABLE MESSAGEBROWSINGHISTORY 
- (	RECORDNUMBER NUMERIC(6,0) NOT NULL,
-	BRANCHNUMBER NUMERIC(3,0) NOT NULL,
-	SEQNUM NUMERIC(3,0) NOT NULL,
-	BROWSINGCODE NUMERIC(8,0) NOT NULL,
-	BROWSINGDATE DATE NOT NULL, 
-	ENTRYDATE DATETIME,
-	UPDATEDATE DATETIME, 
-	 PRIMARY KEY (RECORDNUMBER, BRANCHNUMBER, SEQNUM)
-);
-
-CREATE TABLE ORDERERSMASTER 
- (	ORDERCOTEGORY NUMERIC(5,0) NOT NULL, 
-	ORDERERSCODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	CORPORATESTATUSNAME VARCHAR(100),
-	CORPORATESTATUSPOINT NUMERIC(1,0),
-	ORDERERSNAME1 VARCHAR(60) DEFAULT '' NOT NULL,
-	ORDERERSNAME2 VARCHAR(60), 
-	ZIPCODE VARCHAR(8), 
-	ADDRESS1 VARCHAR(60),
-	ADDRESS2 VARCHAR(60) DEFAULT '', 
-	ADDRESS3 VARCHAR(60),
-	PHONENUMBER VARCHAR(13) DEFAULT '', 
-	FAXNUMBER VARCHAR(13) DEFAULT '', 
-	NOTE VARCHAR(300) DEFAULT '',
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (ORDERCOTEGORY, ORDERERSCODE) 
-);
-
-CREATE TABLE ORDERSPRICEDATA
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	CHANGENO NUMERIC(3,0) NOT NULL,
-	CHANGEDATE DATE NOT NULL, 
-	CHANGEPERSONCODE NUMERIC(8,0) NOT NULL,
-	CHANGEPERSONNAME VARCHAR(60),
-	BEFOREVALUE NUMERIC(14,2) NOT NULL,
-	BEFOREVALUEINTAX NUMERIC(14,2) NOT NULL, 
-	AFTERVALUE NUMERIC(14,2) NOT NULL, 
-	AFTERVALUEINTAX NUMERIC(14,2) NOT NULL,
-	CHANGECOMMENT VARCHAR(200),
-	ENTRYDATE DATETIME,
-	UPDATEDATE DATETIME, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, CHANGENO)
-);
-
-CREATE TABLE PERSONINCHARGEMASTER 
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DISPLAYORDER NUMERIC(8,0) NOT NULL,
-	PERSONNAME VARCHAR(60) DEFAULT '' NOT NULL, 
-	STARTDATE DATE NOT NULL,
-	ENDDATE DATE,
-	PASSWORD VARCHAR(16), 
-	SECURITYMANAGEMENT NUMERIC(1,0) NOT NULL,
-	MSGBACKCOLOR VARCHAR(8),
-	DISPLAYSTRING VARCHAR(20), 
-	DEPARTMENTCODE NUMERIC(5,0),
-	MONTHLYSALARY NUMERIC(11,3) NOT NULL,
-	YEARSALARY NUMERIC(12,3) NOT NULL, 
-	QUALIFICATION VARCHAR(120),
-	SEALPRINTNAME VARCHAR(5),
-	EMPLOYEECLASSFLG NUMERIC(1,0) NOT NULL,
-	LEDGERFLG NUMERIC(1,0) NOT NULL, 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE)
-);
-
-CREATE TABLE POINTINGOUTCOMMENT 
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	PROCESSNO NUMERIC(3,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	PAGECOUNT NUMERIC(4,0) NOT NULL, 
-	PERSONCODE NUMERIC(8,0) NOT NULL,
-	DROWCOLOR VARCHAR(8), 
-	COMMENTMESSAGE VARCHAR(1000),
-	STARTPOINTX NUMERIC(4,0) NOT NULL, 
-	STARTPOINTY NUMERIC(4,0) NOT NULL, 
-	CURRENTPOINTX NUMERIC(4,0) NOT NULL, 
-	CURRENTPOINTY NUMERIC(4,0) NOT NULL, 
-	CURRENTWIDTH NUMERIC(4,0) NOT NULL,
-	CURRENTHEIGHT NUMERIC(4,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, PROCESSNO, SEQNO)
-);
-
-CREATE TABLE PROCEEDINGSDATA
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	PROCEEDINGSDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	STARTMEETINGTIME DATE NOT NULL, 
-	ENDMEETINGTIME DATE NOT NULL, 
-	MEETINGPALCE1 VARCHAR(100),
-	MEETINGPALCE2 VARCHAR(100),
-	MEETINGPALCE3 VARCHAR(100),
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, PROCEEDINGSDATADATE, CONSTRUCTIONCODE) 
-);
-
-CREATE TABLE PROCEEDINGSDATAATTENDEE
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	PROCEEDINGSDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	DEPARTMENT VARCHAR(100), 
-	ATTENDEENAME VARCHAR(100), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, PROCEEDINGSDATADATE, CONSTRUCTIONCODE, SEQNO)
-);
-
-CREATE TABLE PROCEEDINGSDATADETAIL
- (	PERSONCODE NUMERIC(8,0) NOT NULL,
-	PROCEEDINGSDATADATE DATE NOT NULL,
-	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	TITILENO NUMERIC(3,0),
-	TITILE VARCHAR(100), 
-	CONTENTSTEXT VARCHAR(200), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PERSONCODE, PROCEEDINGSDATADATE, CONSTRUCTIONCODE, SEQNO)
-);
-
-CREATE TABLE PROCESSAPPROVAL
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	APPROVALCODE NUMERIC(3,0) NOT NULL,
-	SEQNO NUMERIC(2,0) NOT NULL, 
-	PERSONCODE NUMERIC(8,0) NOT NULL,
-	PETITIONAPPROVALDATE DATE NOT NULL, 
-	APPROVALLIMITDATES DATE NOT NULL, 
-	APPROVALSTATUS NUMERIC(1,0) NOT NULL,
-	INPUTCOMMENT VARCHAR(300), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, APPROVALCODE, SEQNO) 
-);
-
-CREATE TABLE PURCHASEORDER
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	CREATEDATE DATE, 
-	ORDERPRICE NUMERIC(12,2) NOT NULL, 
-	LASTROWSTRINGDATE DATE NOT NULL,
-	ORDERSHEETTYPE NUMERIC(1,0) NOT NULL,
-	PAYMENTTERMS NUMERIC(1,0) NOT NULL,
-	CASHRATIO NUMERIC(4,1) NOT NULL, 
-	BILLPERIOD NUMERIC(4,0) NOT NULL,
-	PREPAYMENTS NUMERIC(1,0) NOT NULL, 
-	PREPAYMENTSDAYS NUMERIC(3,0) NOT NULL, 
-	PREPAYMENTSPRICE NUMERIC(12,2) NOT NULL, 
-	PARTIALPAYMENT NUMERIC(1,0) NOT NULL,
-	PARTIALPAYMENTMOUNTH NUMERIC(2,0) NOT NULL,
-	PARTIALPAYMENTDAY1 NUMERIC(2,0) NOT NULL,
-	PARTIALPAYMENTDAY2 NUMERIC(2,0) NOT NULL,
-	PARTIALPAYMENTPRICE NUMERIC(12,2) NOT NULL,
-	COMPLETIONPAYMENT NUMERIC(1,0) NOT NULL, 
-	COMPLETIONPAYMENTDAYS NUMERIC(3,0) NOT NULL, 
-	COMPLETIONPAYMENTPRICE NUMERIC(12,2) NOT NULL, 
-	LEADENGINEERCODE NUMERIC(8,0),
-	LEADENGINEERNAME VARCHAR(60),
-	SAFETYOFFICERCODE NUMERIC(8,0), 
-	SAFETYOFFICERNAME VARCHAR(60), 
-	WORKERSCOUNT NUMERIC(3,0),
-	PRINTOUTDATE DATE NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, SEQNO) 
-);
-
-CREATE TABLE PURCHASEORDERDETAIL
- (	CONSTRUCTIONCODE NUMERIC(10,0) NOT NULL, 
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	GROUPCOUNT NUMERIC(1,0) NOT NULL,
-	LINECOUNT NUMERIC(3,0) NOT NULL, 
-	COMPONENTCODE NUMERIC(5,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	FIRSTSTRING VARCHAR(120),
-	SECONDSTRING VARCHAR(120), 
-	UNITCOUNT NUMERIC(8,2) NOT NULL, 
-	UNITNAME VARCHAR(30),
-	UNITPRICE NUMERIC(10,2) NOT NULL,
-	ORDERSLINEPRICE NUMERIC(12,2),
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONCODE, SEQNO, GROUPCOUNT, LINECOUNT)
-);
-
-CREATE TABLE SALESGRAPHDATA 
- (	GRAPHDATACODE NUMERIC(8,0) NOT NULL, 
-	CONSTRUCTIONPERIOD NUMERIC(4,0) NOT NULL,
-	SALESDATADAYS DATE NOT NULL,
-	DISPLAYORDER NUMERIC(8,0) NOT NULL,
-	DATANAME VARCHAR(100) NOT NULL, 
-	SALESAMOUNT NUMERIC(10,0) NOT NULL,
-	ADMINISTRATIVEEXPENSE NUMERIC(10,0) NOT NULL,
-	GROSSPROFIT NUMERIC(10,0) NOT NULL,
-	NETINCOME NUMERIC(10,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (GRAPHDATACODE, CONSTRUCTIONPERIOD, SALESDATADAYS)
-);
-
-CREATE TABLE SUBCONTRACTORITEMMASTER
- (	ITEMCODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	ITEMNAME VARCHAR(120) DEFAULT '' NOT NULL,
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (ITEMCODE)
-);
-
-CREATE TABLE SUBCONTRACTORJOBCATEGORY 
- (	JOBCATEGORYCODE NUMERIC(5,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	JOBCATEGORYNAME VARCHAR(120) DEFAULT '' NOT NULL, 
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (JOBCATEGORYCODE) 
-);
-
-CREATE TABLE SUBCONTRACTORJOBITEM 
- (	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	ITEMCODE NUMERIC(5,0) NOT NULL,
-	DISPLAYORDER NUMERIC(8,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (COMPANYCODE, ITEMCODE) 
-);
-
-CREATE TABLE SUBCONTRACTORJOBLINK 
- (	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	JOBCATEGORYCODE NUMERIC(5,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(8,0) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (COMPANYCODE, JOBCATEGORYCODE)
-);
-
-CREATE TABLE SUBCONTRACTORMASTER
- (	COMPANYCODE NUMERIC(8,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	CORPORATESTATUSNAME VARCHAR(40) DEFAULT '',
-	CORPORATESTATUSPOINT NUMERIC(1,0) NOT NULL,
-	COMPANYNAME VARCHAR(100) DEFAULT '' NOT NULL, 
-	CEOPOSITIONNAME VARCHAR(60) DEFAULT '',
-	CEONAME VARCHAR(60) DEFAULT '',
-	CONTACTPERSONNAME VARCHAR(60), 
-	ZIPCODE VARCHAR(8), 
-	ADDRESS1 VARCHAR(60),
-	ADDRESS2 VARCHAR(60) DEFAULT '', 
-	ADDRESS3 VARCHAR(60),
-	CELLPHONENUMBER VARCHAR(13),
-	MAILADDRESS VARCHAR(257), 
-	PHONENUMBER VARCHAR(13) DEFAULT '', 
-	FAXNUMBER VARCHAR(13) DEFAULT '', 
-	JAPANESESYLLABARY VARCHAR(2),
-	STARTDATE DATE NOT NULL,
-	NOTE VARCHAR(300) DEFAULT '',
-	LABOURKIND NUMERIC(1,0) NOT NULL,
-	DELETEFLG NUMERIC(1,0) DEFAULT 0 NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (COMPANYCODE) 
-);
-
-CREATE TABLE SUPPLIERSMASTER
- (	SUPPLIERSCODE NUMERIC(5,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	SUPPLIERSNAME1 VARCHAR(60) DEFAULT '' NOT NULL, 
-	SUPPLIERSNAME2 VARCHAR(60),
-	ZIPCODE VARCHAR(8), 
-	ADDRESS1 VARCHAR(60),
-	ADDRESS2 VARCHAR(60) DEFAULT '', 
-	ADDRESS3 VARCHAR(60),
-	PHONENUMBER VARCHAR(13) DEFAULT '', 
-	FAXNUMBER VARCHAR(13) DEFAULT '', 
-	NOTE VARCHAR(300) DEFAULT '',
-	DELETEFLG NUMERIC(1,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (SUPPLIERSCODE) 
-);
-
-CREATE TABLE SYSTEMEXECUTE
- (	PRIMARYCODE NUMERIC(3,0) NOT NULL, 
-	TARGETDATE DATE NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (PRIMARYCODE) 
-);
-
-CREATE TABLE SYSTEMMASTER 
- (	SYSTEMCODE NUMERIC(3,0) NOT NULL,
-	COMPANYNAME1 VARCHAR(60) DEFAULT '' NOT NULL, 
-	COMPANYNAME2 VARCHAR(60) DEFAULT '', 
-	CEONAME VARCHAR(60) DEFAULT '' NOT NULL,
-	CEOPOSITIONNAME VARCHAR(60) DEFAULT '',
-	ZIPCODE VARCHAR(8) NOT NULL, 
-	ADDRESS1 VARCHAR(60) NOT NULL,
-	ADDRESS2 VARCHAR(60) DEFAULT '', 
-	ADDRESS3 VARCHAR(60),
-	PHONENUMBER VARCHAR(13) DEFAULT '' NOT NULL, 
-	FAXNUMBER VARCHAR(13) DEFAULT '', 
-	CONSTRUCTIONEXPENSES NUMERIC(4,2) NOT NULL,
-	OFFICEEXPENSES NUMERIC(4,2) NOT NULL,
-	OPERATINGEXPENSES NUMERIC(4,2) NOT NULL, 
-	CONSUMPTIONTAX NUMERIC(4,2) NOT NULL,
-	EXCELSAVEPATH VARCHAR(120),
-	BUSINESSPERIOD NUMERIC(4,0) NOT NULL,
-	CONSTRUCTIONYEAR NUMERIC(4,0) NOT NULL,
-	BUSINESSBEGINNINGDATE VARCHAR(5) NOT NULL, 
-	CONSTRUCTIONBEGINNINGDATE VARCHAR(5) NOT NULL, 
-	CONSTRUCTIONNOBASE NUMERIC(1,0) NOT NULL,
-	SLOGANSTRING1 VARCHAR(100),
-	SLOGANSTRING2 VARCHAR(100),
-	SLOGANSTRING3 VARCHAR(100),
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (SYSTEMCODE)
-);
-
-CREATE TABLE TERMMASTER 
- (	CONSTRUCTIONSTATUSFLG NUMERIC(2,0) NOT NULL, 
-	FIELDNO NUMERIC(2,0) NOT NULL, 
-	SEQNO NUMERIC(2,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(2,0) NOT NULL,
-	CHECKSCHDULE NUMERIC(1,0) NOT NULL,
-	TERMDAYS NUMERIC(3,0) NOT NULL,
-	SENDTITILE VARCHAR(100), 
-	SENDMESSAGE VARCHAR(100),
-	BACKCOLOR VARCHAR(8), 
-	FORECOLOR VARCHAR(8), 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (CONSTRUCTIONSTATUSFLG, FIELDNO, SEQNO) 
-);
-
-CREATE TABLE UNITMASTER 
- (	UNITKEY NUMERIC(5,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	UNITNAME VARCHAR(30) NOT NULL,
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (UNITKEY) 
-);
-
-CREATE TABLE VEHICLEMASTER
- (	VEHICLECODE NUMERIC(5,0) NOT NULL, 
-	DISPLAYORDER NUMERIC(5,0) NOT NULL,
-	VEHICLENAME VARCHAR(100) NOT NULL,
-	REGISTRATIONNUMBER VARCHAR(30),
-	IDENTIFICATIONNUMBER VARCHAR(30),
-	MODELCODE VARCHAR(30), 
-	DEPARTMENTCODE NUMERIC(5,0) NOT NULL,
-	VEHICLESCHEDULEFLG NUMERIC(1,0) NOT NULL,
-	PURCHASEDATE DATE, 
-	PURCHASENAME VARCHAR(30),
-	PURCHASECONTACTPERSONS VARCHAR(30),
-	PURCHASEPHONE VARCHAR(13),
-	LEASEDATE DATE,
-	LEASEDESTINATION VARCHAR(30),
-	LEASECONTACTPERSONS VARCHAR(30), 
-	LEASEPHONE VARCHAR(13), 
-	INSURANCECOMPANY VARCHAR(30),
-	INSURANCECONTACTPERSONS VARCHAR(30), 
-	INSURANCEPHONE VARCHAR(13),
-	NOTE VARCHAR(300), 
-	ENTRYDATE DATETIME,
-	UPDATEDATE DATETIME, 
-	 PRIMARY KEY (VEHICLECODE) 
-);
-
-CREATE TABLE VEHICLERECORDDATA
- (	VEHICLECODE NUMERIC(5,0) NOT NULL, 
-	DIVISIONCODE NUMERIC(2,0) NOT NULL,
-	SEQNO NUMERIC(3,0) NOT NULL, 
-	RECORDDATE DATE, 
-	MILEAGE NUMERIC(7,0), 
-	CONTENT VARCHAR(100),
-	PAYMENTCOST NUMERIC(10,2),
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (VEHICLECODE, DIVISIONCODE, SEQNO)
-);
-
-CREATE TABLE VEHICLESCHEDULEDATA
-( TARGETDATE DATE NOT NULL, 
-	VEHICLECODE NUMERIC(5,0) NOT NULL, 
-	MORNINGAFTERNOON NUMERIC(1,0) NOT NULL,
-	PERSONCODE NUMERIC(8,0) NOT NULL,
-	TARGETYEAR NUMERIC(4,0) NOT NULL,
-	TARGETMONTH NUMERIC(2,0) NOT NULL, 
-	TARGETDAY NUMERIC(2,0) NOT NULL, 
-	ENTRYDATE DATETIME NOT NULL,
-	UPDATEDATE DATETIME NOT NULL, 
-	 PRIMARY KEY (TARGETDATE, VEHICLECODE, MORNINGAFTERNOON) 
-);
-
