-- Generated by Relational Schema Center on Fri Mar 30 16:53:14 CDT 2007 for DB2 Universal Database V8.1 CREATE SCHEMA DS3; CREATE TABLE DS3.ACQUIRER (ACQUIRERBINID INTEGER NOT NULL, NAME VARCHAR(64) NOT NULL, ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.ACQUIRER ADD CONSTRAINT C1845000 PRIMARY KEY (ACQUIRERBINID); CREATE TABLE DS3.AGENT (AGENTPK BIGINT NOT NULL, NAME VARCHAR(64) NOT NULL, BANKNUMBER INTEGER NOT NULL, CHAINNUMBER INTEGER NOT NULL, ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.AGENT ADD CONSTRAINT C1904312 PRIMARY KEY (AGENTPK); CREATE TABLE DS3.CREDITAUTHREQUEST (CREDITAUTHREQUESTPK BIGINT NOT NULL, REQUESTEDACI VARCHAR(1) NOT NULL, SEQUENCENUMBER INTEGER NOT NULL, TRANSACTIONCODE VARCHAR(2) NOT NULL, CARDHOLDERIDCODE VARCHAR(1) NOT NULL, ACCOUNTDATASOURCE VARCHAR(1) NOT NULL, TRANSACTIONAMOUNT DECIMAL(12, 2) NOT NULL, CUSTOMERDATA VARCHAR(76) NOT NULL, ADDRESSVERIFICATIONDATA VARCHAR(29), BATCHPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1) NOT NULL, APPLICATIONTYPE INTEGER NOT NULL, MESSAGEDELIMITER VARCHAR(1) NOT NULL, ACQUIRERBINID INTEGER NOT NULL, MERCHANTID BIGINT NOT NULL, PMTSTORENUMBER INTEGER NOT NULL, TERMINALID INTEGER NOT NULL, DEVICECODE VARCHAR(1) NOT NULL, INDUSTRYCODE VARCHAR(1) NOT NULL, CURRENCYCODE VARCHAR(3) NOT NULL, COUNTRYCODE VARCHAR(3) NOT NULL, ZIP VARCHAR(5) NOT NULL, LANGUAGECODE VARCHAR(3) NOT NULL, TIMEZONE VARCHAR(3) NOT NULL, CATEGORYCODE VARCHAR(4) NOT NULL, MERCHANTNAME VARCHAR(25) NOT NULL, MERCHANTCITY VARCHAR(13) NOT NULL, MERCHANTSTATE VARCHAR(2) NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CREDITAUTHREQUEST ADD CONSTRAINT C0930215 PRIMARY KEY (CREDITAUTHREQUESTPK); CREATE TABLE DS3.CREDITAUTHRESPONSE (CREDITAUTHRESPONSEPK BIGINT NOT NULL, RETURNEDACI VARCHAR(1), PMTSTORENUMBER INTEGER, TERMINALID INTEGER, AUTHSOURCECODE VARCHAR(1), SEQUENCENUMBER INTEGER, RESPONSECODE VARCHAR(2), APPROVALCODE VARCHAR(6), TRANSACTIONDATE DATE, TRANSACTIONTIME TIME, RESPONSETEXT VARCHAR(16), AVSRESULTCODE VARCHAR(1), RETRIEVALREFNUMBER VARCHAR(12), MARKETDATAID VARCHAR(1), TRANSACTIONID VARCHAR(15), VALIDATIONCODE VARCHAR(4), CREDITAUTHREQUESTPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1), APPLICATIONTYPE INTEGER, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, VOIDTRANSACTION SMALLINT, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CREDITAUTHRESPONSE ADD CONSTRAINT C1005841 PRIMARY KEY (CREDITAUTHRESPONSEPK); CREATE TABLE DS3.BATCH (BATCHID BIGINT NOT NULL, BATCHTYPEID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, BATCHSTATUSID BIGINT NOT NULL, CLOSEDATE DATE, CLOSETIME TIME, CLOSEUSERPK BIGINT, GLREVENUE DECIMAL(20, 2), GLEXPENSE DECIMAL(20, 2), GLTAXPAYABLE DECIMAL(20, 2), ITEMCOUNT INTEGER, STOREID BIGINT NOT NULL, GLCUSTOMERAR DECIMAL(20, 2), GLSTOREAR DECIMAL(20, 2), GLCASH DECIMAL(20, 2), USERDOLLARTOTAL DECIMAL(20, 2), USERHASHTOTAL BIGINT, GLPOSTEDYN SMALLINT, POSTEDYN SMALLINT, SETTLEATTEMPTS INTEGER, LASTSETTLEDATE DATE, LASTSETTLETIME TIME, LASTSETTLERESULT VARCHAR(10), RECORDCOUNT INTEGER, NETDEPOSIT DECIMAL(20, 2), RESPONSETEXT VARCHAR(9), RESPONSECODE VARCHAR(2), ERRORTYPE VARCHAR(1), ERRORSEQNUMBER INTEGER, ERRORRECORDTYPE VARCHAR(1), ERRORDATAFIELDNUM INTEGER, ERRORDATA VARCHAR(32), TRANSMISSIONDATE DATE, ERRORRECORDID VARCHAR(40), PMTBATCHNUMBER INTEGER, TERMINALPK BIGINT, TERMINAL_TERMINALPK BIGINT); ALTER TABLE DS3.BATCH ADD CONSTRAINT C0653151 PRIMARY KEY (BATCHID); CREATE TABLE DS3.CHECKAUTHREQUEST (CHECKAUTHREQUESTPK BIGINT NOT NULL, BATCHPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1) NOT NULL, APPLICATIONTYPE INTEGER NOT NULL, MESSAGEDELIMITER VARCHAR(1) NOT NULL, ACQUIRERBINID INTEGER NOT NULL, MERCHANTID BIGINT NOT NULL, PMTSTORENUMBER INTEGER NOT NULL, TERMINALID INTEGER NOT NULL, DEVICECODE VARCHAR(1) NOT NULL, INDUSTRYCODE VARCHAR(1) NOT NULL, CURRENCYCODE VARCHAR(3) NOT NULL, COUNTRYCODE VARCHAR(3) NOT NULL, ZIP VARCHAR(9) NOT NULL, LANGUAGECODE VARCHAR(2) NOT NULL, TIMEZONE VARCHAR(3) NOT NULL, CATEGORYCODE VARCHAR(4) NOT NULL, REQUESTEDACI VARCHAR(1) NOT NULL, SEQUENCENUMBER INTEGER NOT NULL, TRANSACTIONCODE VARCHAR(2) NOT NULL, CARDHOLDERID VARCHAR(1) NOT NULL, ACCOUNTDATASOURCE VARCHAR(1) NOT NULL, RAW_MICRDATA VARCHAR(54) NOT NULL, RECEIVING_INST_ID INTEGER NOT NULL, TRANSACTIONAMOUNT DECIMAL(12, 2) NOT NULL, CASHBACKAMOUNT DECIMAL(12, 2), MERCHANTNAME VARCHAR(25) NOT NULL, MERCHANTCITY VARCHAR(13) NOT NULL, MERCHANTSTATE VARCHAR(2) NOT NULL, MERCHANTABA INTEGER, SETTLEMENTAGENTNUM VARCHAR(4), AGENTNUMBER BIGINT NOT NULL, CHAINNUMBER INTEGER NOT NULL, BATCHNUMBER INTEGER NOT NULL, REIMBURSEMENTATTRIBUTE VARCHAR(1) NOT NULL, CHECK_PRIVATE_DATA VARCHAR(245) NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CHECKAUTHREQUEST ADD CONSTRAINT C0712651 PRIMARY KEY (CHECKAUTHREQUESTPK); CREATE TABLE DS3.CHECKAUTHRESPONSE (CHECKAUTHRESPONSEPK BIGINT NOT NULL, CHECKAUTHREQUESTPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1), APPLICATIONTYPE VARCHAR(1) NOT NULL, RETURNEDACI VARCHAR(1), PMTSTORENUMBER INTEGER, TERMINALID INTEGER, AUTHSOURCECODE VARCHAR(1), SEQUENCENUMBER INTEGER, RESPONSECODE VARCHAR(2), APPROVALCODE VARCHAR(6), TRANSACTIONDATE DATE, TRANSACTIONTIME TIME, RESPONSETEXT VARCHAR(16), AVSRESULTCODE VARCHAR(1), RETRIEVALREFNUMBER VARCHAR(12), MARKETDATAID VARCHAR(1), TRANSACTIONID VARCHAR(15), VALIDATIONCODE VARCHAR(4), KEYSETID INTEGER, HOSTMESSAGEID VARCHAR(8), SYSTRACEAUDITNUM INTEGER, NETWORKIDCODE VARCHAR(1), SETTLEMENTDATE DATE, VOIDTRANSACTION SMALLINT, CHECKSETTLEMENTCODE INTEGER, PARSED_MICRDATA VARCHAR(60), CHECK_PRIVATE_DATA VARCHAR(252), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACQUIRERBINID INTEGER, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CHECKAUTHRESPONSE ADD CONSTRAINT C0729198 PRIMARY KEY (CHECKAUTHRESPONSEPK); CREATE TABLE DS3.CHECKREVERSEREQUEST (CHECKREVERSEREQUESTPK BIGINT NOT NULL, CHECKAUTHREQUESTPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1) NOT NULL, APPLICATIONTYPE INTEGER NOT NULL, MESSAGEDELIMITER VARCHAR(1) NOT NULL, ACQUIRERBINID INTEGER NOT NULL, MERCHANTID BIGINT NOT NULL, PMTSTORENUMBER INTEGER NOT NULL, TERMINALID INTEGER NOT NULL, DEVICECODE VARCHAR(1) NOT NULL, INDUSTRYCODE VARCHAR(1) NOT NULL, CURRENCYCODE VARCHAR(3) NOT NULL, COUNTRYCODE VARCHAR(3) NOT NULL, ZIP VARCHAR(9) NOT NULL, LANGUAGECODE VARCHAR(2) NOT NULL, TIMEZONE VARCHAR(3) NOT NULL, CATEGORYCODE VARCHAR(4) NOT NULL, REQUESTEDACI VARCHAR(1) NOT NULL, SEQUENCENUMBER INTEGER NOT NULL, TRANSACTIONCODE VARCHAR(2) NOT NULL, CARDHOLDERID VARCHAR(1) NOT NULL, ACCOUNTDATASOURCE VARCHAR(1) NOT NULL, PARSED_MICRDATA VARCHAR(60) NOT NULL, RECEIVING_INST_ID INTEGER NOT NULL, TRANSACTIONAMOUNT DECIMAL(12, 2) NOT NULL, CASHBACKAMOUNT DECIMAL(12, 2), MERCHANTNAME VARCHAR(25) NOT NULL, MERCHANTCITY VARCHAR(13) NOT NULL, MERCHANTSTATE VARCHAR(2) NOT NULL, TRANSACTIONID VARCHAR(15), APPROVALCODE VARCHAR(6) NOT NULL, TRANSACTIONDATE DATE NOT NULL, TRANSACTIONTIME TIME NOT NULL, RETRIEVALREFNUMBER VARCHAR(12) NOT NULL, SYSTRACEAUDITNUM INTEGER NOT NULL, NETWORKIDCODE VARCHAR(1) NOT NULL, SHARINGGROUP VARCHAR(1) NOT NULL, MERCHANTABA INTEGER, SETTLEMENTAGENTNUM VARCHAR(4), AGENTNUMBER BIGINT NOT NULL, CHAINNUMBER INTEGER NOT NULL, BATCHNUMBER INTEGER NOT NULL, REIMBURSEMENTATTRIBUTE VARCHAR(1) NOT NULL, CHECK_PRIVATE_DATA VARCHAR(252) NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, BATCHPK BIGINT NOT NULL, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CHECKREVERSEREQUEST ADD CONSTRAINT C0739964 PRIMARY KEY (CHECKREVERSEREQUESTPK); CREATE TABLE DS3.CHECKREVERSERESPONSE (CHECKREVERSERESPONSEPK BIGINT NOT NULL, CHECKREVERSEREQUESTPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1), APPLICATIONTYPE VARCHAR(1), RETURNEDACI VARCHAR(1), PMTSTORENUMBER INTEGER, TERMINALID INTEGER, AUTHSOURCECODE VARCHAR(1), SEQUENCENUMBER INTEGER, RESPONSECODE VARCHAR(2), APPROVALCODE VARCHAR(6), TRANSACTIONDATE DATE, TRANSACTIONTIME TIME, RESPONSETEXT VARCHAR(16), AVSRESULTCODE VARCHAR(1), RETRIEVALREFNUMBER VARCHAR(12), MARKETDATAID VARCHAR(1), TRANSACTIONID VARCHAR(15), VALIDATIONCODE VARCHAR(4), ACQUIRERBINID INTEGER, HOSTMESSAGEID VARCHAR(8), SYSTRACEAUDITNUM INTEGER, NETWORKIDCODE VARCHAR(1), SETTLEMENTDATE DATE, VOIDTRANSACTION SMALLINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, CHECKSETTLEMENTCODE INTEGER, PARSEDMICRDATA VARCHAR(60), CHECKPRIVATEDATA VARCHAR(252), STOREID BIGINT NOT NULL); ALTER TABLE DS3.CHECKREVERSERESPONSE ADD CONSTRAINT C0749011 PRIMARY KEY (CHECKREVERSERESPONSEPK); CREATE TABLE DS3.COMPANY (COMPANYID BIGINT NOT NULL, NAME VARCHAR(30) NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.COMPANY ADD CONSTRAINT C1800204 PRIMARY KEY (COMPANYID); CREATE TABLE DS3.CONTROL (CONTROLID BIGINT NOT NULL, CONTROLTYPEID BIGINT, DESCRIPTION VARCHAR(100) NOT NULL, GLACCOUNTPK BIGINT, GLSUBACCOUNTPK BIGINT, GLMASK VARCHAR(20), STOREID BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, PARENTCONTROL BIGINT, USESEQUENCE SMALLINT, FOREIGNID VARCHAR(50), SCOPETYPEID BIGINT, SCOPEID BIGINT); ALTER TABLE DS3.CONTROL ADD CONSTRAINT C0354200 PRIMARY KEY (CONTROLID); CREATE TABLE DS3.CUSTADDR (CUSTADDRPK BIGINT NOT NULL, BUILDINGORFIRMNAME VARCHAR(40), CARRIERROUTEID VARCHAR(4), CITY VARCHAR(28) NOT NULL, CONGRESSIONALDISTRICTNUM VARCHAR(2), COUNTYNAME VARCHAR(25), DPC VARCHAR(3), STATE VARCHAR(2) NOT NULL, ZIPCODE VARCHAR(10), NAME VARCHAR(64) NOT NULL, FOREIGNCOUNTRYNAME VARCHAR(30), FOREIGNPOSTALCODE VARCHAR(10), CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, GEOCODE VARCHAR(30), INOUTCITY VARCHAR(30), TAXABLE SMALLINT NOT NULL, ADDRESSTYPEID BIGINT NOT NULL, CUSTOMERID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, TIGERLINEID VARCHAR(10), TIGERRIGHTLEFTFLAG VARCHAR(1), TIGERCENSUSTRACT VARCHAR(6), TIGERCENSUSBLOCK VARCHAR(4), TIGERFROMLATITUDE VARCHAR(9), TIGERFROMLONGITUDE VARCHAR(10), TIGERTOLATITUDE VARCHAR(9), TIGERTOLONGITUDE VARCHAR(10), TIGERPMSA VARCHAR(4), TIGERCMSA VARCHAR(4), TIGERMULTIMATCH VARCHAR(1), ADDRESS VARCHAR(64), ELOTASCDES VARCHAR(1), ELOTSEQNUM VARCHAR(4), URBANIZATION VARCHAR(28)); ALTER TABLE DS3.CUSTADDR ADD CONSTRAINT CUSTADDR PRIMARY KEY (CUSTADDRPK); CREATE TABLE DS3.CUSTBAL (AVGDAYSTOPAY INTEGER, CUSTBALPK BIGINT NOT NULL, HIGHESTBALANCE DECIMAL(20, 2) NOT NULL, LASTPAYDATE DATE, MAXPAYAMOUNT DECIMAL(20, 2), MINPAYAMOUNT DECIMAL(20, 2), MAXDAYSTOPAY INTEGER, MINDAYSTOPAY INTEGER, CURRENTBALANCE DECIMAL(20, 2) NOT NULL, PREVIOUSBALANCE DECIMAL(20, 2), CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, BALANCETYPEID BIGINT NOT NULL, CUSTOMERID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, AVGPAY DECIMAL(20, 2), ACTIVE SMALLINT, FISCALYEARENDING INTEGER NOT NULL, BEGINNINGBALANCE DECIMAL(5, 0) NOT NULL); ALTER TABLE DS3.CUSTBAL ADD CONSTRAINT CUSTBAL PRIMARY KEY (CUSTBALPK); CREATE TABLE DS3.CUSTCONTACT (CONTACTDATA VARCHAR(255) NOT NULL, CUSTCONTACTPK BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, CONTACTTYPEID BIGINT NOT NULL, CUSTOMERID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, CONTACTMEMO VARCHAR(30)); ALTER TABLE DS3.CUSTCONTACT ADD CONSTRAINT CUSTCONTACT PRIMARY KEY (CUSTCONTACTPK); CREATE TABLE DS3.CUSTNOTE (CUSTNOTEPK BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, NOTE VARCHAR(2048) NOT NULL, CUSTOMERID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, ACTIVE SMALLINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.CUSTNOTE ADD CONSTRAINT CUSTNOTE PRIMARY KEY (CUSTNOTEPK); CREATE TABLE DS3.CUSTOMER (CUSTOMERID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, STOREID BIGINT, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, BIRTHDATE DATE, SOCIALSECURITYNUM VARCHAR(9), DRIVERLICENSE VARCHAR(20), SALESREPPK BIGINT, DRIVERLICENSESTATE VARCHAR(2), FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(50) NOT NULL, DPVENABLED SMALLINT, DPVFALSEPOSITIVEDETECTED SMALLINT, DPVTOTALFALSEPOSITIVETEST INTEGER, LACSENABLED SMALLINT, LACSFALSEPOSITIVEDETECTED SMALLINT, LACSTOTALFALSEPOSITIVETESTS INTEGER, SIC VARCHAR(6), FEDERALTAXID VARCHAR(12), COAENABLED SMALLINT, CUSTOMERSTATUSID BIGINT, CUSTOMERREFERREDBYID BIGINT NOT NULL, CUSTOMERREFERREDBYDETAIL VARCHAR(255)); ALTER TABLE DS3.CUSTOMER ADD CONSTRAINT CUSTOMER PRIMARY KEY (CUSTOMERID); CREATE TABLE DS3.DEBITAUTHREQUEST (DEBITAUTHREQUESTPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1) NOT NULL, APPLICATIONTYPE INTEGER NOT NULL, MESSAGEDELIMITER VARCHAR(1) NOT NULL, ACQUIRERBINID INTEGER NOT NULL, MERCHANTID BIGINT NOT NULL, PMTSTORENUMBER INTEGER NOT NULL, DEVICECODE VARCHAR(1) NOT NULL, INDUSTRYCODE VARCHAR(1) NOT NULL, CURRENCYCODE VARCHAR(3) NOT NULL, COUNTRYCODE VARCHAR(3) NOT NULL, ZIP VARCHAR(9) NOT NULL, LANGUAGECODE VARCHAR(2) NOT NULL, TIMEZONE VARCHAR(3) NOT NULL, CATEGORYCODE VARCHAR(4) NOT NULL, REQUESTEDACI VARCHAR(1) NOT NULL, SEQUENCENUMBER INTEGER NOT NULL, TRANSACTIONCODE VARCHAR(2) NOT NULL, CARDHOLDERID VARCHAR(1) NOT NULL, ACCOUNTDATASOURCE VARCHAR(1) NOT NULL, CUSTOMERDATAFIELD VARCHAR(76) NOT NULL, CUSTOMERIDDATA VARCHAR(32) NOT NULL, TRANSACTIONAMOUNT DECIMAL(2, 0) NOT NULL, CASHBACKAMOUNT DECIMAL(2, 0) NOT NULL, MERCHANTNAME VARCHAR(25) NOT NULL, MERCHANTCITY VARCHAR(13) NOT NULL, MERCHANTSTATE VARCHAR(2) NOT NULL, SHARINGGROUP VARCHAR(30) NOT NULL, MERCHANTABA INTEGER NOT NULL, SETTLEMENTAGENTNUM VARCHAR(4) NOT NULL, AGENTNUMBER BIGINT NOT NULL, CHAINNUMBER INTEGER NOT NULL, BATCHNUMBER INTEGER NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, BATCHPK BIGINT NOT NULL, REIMBURSEMENTATTRIBUTE VARCHAR(1) NOT NULL, ORIGINALPURCHASEDATA VARCHAR(8) NOT NULL, TERMINALID INTEGER NOT NULL, STOREID BIGINT NOT NULL); ALTER TABLE DS3.DEBITAUTHREQUEST ADD CONSTRAINT C0800058 PRIMARY KEY (DEBITAUTHREQUESTPK); CREATE TABLE DS3.DEBITAUTHRESPONSE (DEBITAUTHRESPONSEPK BIGINT NOT NULL, DEBITAUTHREQUESTPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1), APPLICATIONTYPE VARCHAR(1), RETURNEDACI VARCHAR(1), PMTSTORENUMBER INTEGER, TERMINALID INTEGER, AUTHSOURCECODE VARCHAR(1), SEQUENCENUMBER INTEGER, RESPONSECODE VARCHAR(2), APPROVALCODE VARCHAR(6), TRANSACTIONDATE DATE, TRANSACTIONTIME TIME, RESPONSETEXT VARCHAR(16), AVSRESULTCODE VARCHAR(1), RETRIEVALREFNUMBER VARCHAR(12), MARKETDATAID VARCHAR(1), TRANSACTIONID VARCHAR(15), VALIDATIONCODE VARCHAR(4), ACQUIRERBINID INTEGER, HOSTMESSAGEID VARCHAR(8), SYSTRACEAUDITNUM INTEGER, NETWORKIDCODE VARCHAR(1), SETTLEMENTDATE DATE, VOIDTRANSACTION SMALLINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, STOREID BIGINT NOT NULL); ALTER TABLE DS3.DEBITAUTHRESPONSE ADD CONSTRAINT C0812355 PRIMARY KEY (DEBITAUTHRESPONSEPK); CREATE TABLE DS3.DOCUMENT (DOCUMENTID BIGINT NOT NULL, DOCUMENT BLOB(5242880)); ALTER TABLE DS3.DOCUMENT ADD CONSTRAINT C2328131 PRIMARY KEY (DOCUMENTID); CREATE TABLE DS3.DOCUMENTMASTER (DOCUMENTMASTERID BIGINT NOT NULL, TABLENAME VARCHAR(50), DOCUMENTDATE DATE NOT NULL, RELATEDTABLENAME VARCHAR(50) NOT NULL, RELATEDRECORDID VARCHAR(20) NOT NULL, NOTES VARCHAR(250), FILENAME VARCHAR(250) NOT NULL, FILETYPE VARCHAR(10) NOT NULL, CUSTOMSORT INTEGER, DOCUMENTTYPEID BIGINT NOT NULL, REVIEWDATE DATE, REVIEWTIME TIME, REVIEWUSERPK BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, DOCUMENTID BIGINT NOT NULL, SCOPEID BIGINT, SCOPETYPEID BIGINT, LOADONFINDRESULTS SMALLINT, LOADONVIEW SMALLINT); ALTER TABLE DS3.DOCUMENTMASTER ADD CONSTRAINT C1201784 PRIMARY KEY (DOCUMENTMASTERID); CREATE TABLE DS3.EQUIPMENT (MAKE VARCHAR(30) NOT NULL, MODEL VARCHAR(30) NOT NULL, SERIALNUMBER VARCHAR(30) NOT NULL, CARDID VARCHAR(30), DTVACCOUNTNUM VARCHAR(30), CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, LASTINSERVICEDATE DATE, FOREIGNID VARCHAR(30), EQUIPMENTID BIGINT NOT NULL, STOREID BIGINT, CUSTADDRID BIGINT, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT); ALTER TABLE DS3.EQUIPMENT ADD CONSTRAINT EQUIPMENT PRIMARY KEY (EQUIPMENTID); CREATE TABLE DS3.FPFINANCESUMMARY (STOREID BIGINT NOT NULL, LENDER BIGINT NOT NULL, STATEMENTDATE DATE NOT NULL, PRINCIPALBALANCE DECIMAL(20, 2), INTEREST DECIMAL(20, 2), INSURANCE DECIMAL(20, 2), MISCELLANEOUS DECIMAL(20, 2), OTHERCHARGES DECIMAL(20, 2), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, FPFINANCESUMMARYPK BIGINT NOT NULL, ACTIVE SMALLINT); ALTER TABLE DS3.FPFINANCESUMMARY ADD CONSTRAINT C3921119 PRIMARY KEY (FPFINANCESUMMARYPK); CREATE TABLE DS3.GLACCOUNT (GLACCOUNTID VARCHAR(20) NOT NULL, DESCRIPTION VARCHAR(100), FSTYPEID VARCHAR(1), FSSUBTYPEID VARCHAR(30), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, ACTIVE SMALLINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, GLACCOUNTPK BIGINT NOT NULL, STOREID BIGINT NOT NULL); ALTER TABLE DS3.GLACCOUNT ADD CONSTRAINT C1332249 PRIMARY KEY (GLACCOUNTPK); CREATE TABLE DS3.GLBAL (GLACCOUNTPK BIGINT NOT NULL, GLSUBACCOUNTPK BIGINT NOT NULL, PERIOD VARCHAR(3) NOT NULL, YEAR VARCHAR(4) NOT NULL, BALANCE DECIMAL(20, 2), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, GLBALPK BIGINT NOT NULL, STOREID BIGINT NOT NULL, QUANTITY DECIMAL(20, 5), UM BIGINT); ALTER TABLE DS3.GLBAL ADD CONSTRAINT C1337699 PRIMARY KEY (GLBALPK); CREATE TABLE DS3.GLINTEGRATION (SUBSYSTEMID BIGINT NOT NULL, GLACCOUNTPK BIGINT, MASK VARCHAR(20), GLSUBACCOUNTPK BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, ACTIVE SMALLINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, STOREID BIGINT NOT NULL, GLINTEGRATIONID BIGINT NOT NULL, ACCOUNTTYPEID BIGINT); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT C0334280 PRIMARY KEY (GLINTEGRATIONID); CREATE TABLE DS3.GLSUBACCOUNT (GLSUBACCOUNTID VARCHAR(100) NOT NULL, DESCRIPTION VARCHAR(50), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, ACTIVE SMALLINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, GLSUBACCOUNTPK BIGINT NOT NULL, STOREID BIGINT NOT NULL); ALTER TABLE DS3.GLSUBACCOUNT ADD CONSTRAINT GLSUBACCOUNT PRIMARY KEY (GLSUBACCOUNTPK); CREATE TABLE DS3.GLTRAN (EFFECTIVEDATE DATE NOT NULL, SUBSYSTEMID BIGINT NOT NULL, DESCRIPTION VARCHAR(50) NOT NULL, REFERENCE VARCHAR(20) NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, ACTIVE SMALLINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, GLTRANID BIGINT NOT NULL, STOREID BIGINT NOT NULL, JOURNALID BIGINT NOT NULL, JOURNALNUM VARCHAR(12), GLTRANTYPEID BIGINT NOT NULL, BATCHID BIGINT NOT NULL, APPLTOGLTRANID BIGINT, POSTEDYN SMALLINT); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT GLTRAN PRIMARY KEY (GLTRANID); CREATE TABLE DS3.GLTRANDETAIL (GLTRANDETAILID BIGINT NOT NULL, GLACCOUNTPK BIGINT NOT NULL, GLSUBACCOUNTPK BIGINT NOT NULL, AMOUNT DECIMAL(20, 2) NOT NULL, SUBSYSTEMREF BIGINT, GLTRANID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFYUSERPK BIGINT, MODIFIED TIMESTAMP, ACTIVE SMALLINT NOT NULL, STOREID BIGINT NOT NULL, LINEDESCRIPTION VARCHAR(20), QUANTITY DECIMAL(20, 5), UM BIGINT); ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT GLTRANDETAILID PRIMARY KEY (GLTRANDETAILID); CREATE TABLE DS3.ITEM (ITEMID BIGINT NOT NULL, MFGID VARCHAR(30), MFGLINEID VARCHAR(30), MFGITEMID VARCHAR(30), STATUS VARCHAR(30), DESCRIPTION VARCHAR(50) NOT NULL, REMARKS VARCHAR(500), CATEGORY VARCHAR(30), QTYNEEDED DECIMAL(20, 5), STORECOST DECIMAL(20, 5) NOT NULL, STOREPRICE DECIMAL(20, 5) NOT NULL, IMAGELINK BIGINT, OEMID VARCHAR(30), OEMLINEID VARCHAR(30), OEMITEMID VARCHAR(30), STOREID BIGINT, PURCHASINGUM BIGINT, SELLINGUM BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, STOCKINGUM BIGINT, COSTINGMETHODID BIGINT NOT NULL, LOTREQUIREDYN SMALLINT NOT NULL); ALTER TABLE DS3.ITEM ADD CONSTRAINT C3431784 PRIMARY KEY (ITEMID); CREATE TABLE DS3.ITEMLAYER (ITEMLAYERID BIGINT NOT NULL, RECEIVEDATE DATE NOT NULL, ONHAND DECIMAL(20, 5) NOT NULL, UM BIGINT NOT NULL, COST DECIMAL(20, 5) NOT NULL, STOREID BIGINT NOT NULL, ITEMID BIGINT NOT NULL, LOCATIONID BIGINT NOT NULL, BINID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, LOT VARCHAR(30)); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT C4057280 PRIMARY KEY (ITEMLAYERID); CREATE TABLE DS3.ITEMTRAN (ITEMTRANID BIGINT NOT NULL, TRANDATE DATE NOT NULL, QUANTITY DECIMAL(20, 5) NOT NULL, COST DECIMAL(20, 5), ITEMLAYERID BIGINT, SUBSYSTEMREFERENCE VARCHAR(30), STOREID BIGINT NOT NULL, ITEMID BIGINT NOT NULL, LOCATIONID BIGINT, BINID BIGINT, SUBSYSTEMID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, UM BIGINT NOT NULL, MODIFYUSERPK BIGINT, MODIFIED TIMESTAMP, STATUS BIGINT NOT NULL, TRANSACTIONTYPEID BIGINT NOT NULL, LOT VARCHAR(30)); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT C4917067 PRIMARY KEY (ITEMTRANID); CREATE TABLE DS3.LENDER (LENDERID BIGINT NOT NULL, ADDRESS VARCHAR(64) NOT NULL, CITY VARCHAR(28) NOT NULL, CREDITLIMIT DECIMAL(20, 2) NOT NULL, DPC VARCHAR(3), FOREIGNCOUNTRY VARCHAR(30), FOREIGNPOSTALCODE VARCHAR(10), ACTIVE SMALLINT, NAME VARCHAR(64) NOT NULL, STATE VARCHAR(2) NOT NULL, ZIP VARCHAR(10) NOT NULL, CREATED TIMESTAMP, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, BUILDINGORFIRMNAME VARCHAR(40), CARRIERROUTEID VARCHAR(4), ELOTASCDES VARCHAR(1), ELOTSEQNUM VARCHAR(4), URBANIZATION VARCHAR(28)); ALTER TABLE DS3.LENDER ADD CONSTRAINT LENDER PRIMARY KEY (LENDERID); CREATE TABLE DS3.MERCHANT (MERCHANTID BIGINT NOT NULL, MERCHANTNAME VARCHAR(25), ADDRESS1 VARCHAR(30) NOT NULL, ADDRESS2 VARCHAR(30), CITY VARCHAR(13) NOT NULL, STATE VARCHAR(2) NOT NULL, ZIP VARCHAR(5) NOT NULL, PHONE VARCHAR(12) NOT NULL, TIMEZONEPK BIGINT NOT NULL, CATEGORYCODEPK BIGINT NOT NULL, INDUSTRYCODEPK BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, ACQUIRERBINID INTEGER NOT NULL, COUNTRYCODEPK BIGINT NOT NULL, LANGUAGECODEPK BIGINT NOT NULL, CURRENCYCODEPK BIGINT NOT NULL, SERVICEPHONENUMBER VARCHAR(20), AGENTPK BIGINT NOT NULL, COMPANYPK BIGINT NOT NULL, SHARINGGROUP VARCHAR(30), ABANUMBER INTEGER, SETTLEMENTAGENTNUM VARCHAR(4), REIMBURSMENTATTRIBUTE VARCHAR(1), RECIEVING_INSTPK BIGINT); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT C4720593 PRIMARY KEY (MERCHANTID); COMMENT ON COLUMN DS3.MERCHANT.SERVICEPHONENUMBER IS 'Merchant telephone number that a customer can call regarding credit transactions. Used during settlement.'; CREATE TABLE DS3.LISTDETAIL (LISTDETAILPK BIGINT NOT NULL, FOREIGNID VARCHAR(255) NOT NULL, CARRIERROUTEALTANSWERALLOWED VARCHAR(1), CARRIERROUTEANSWER VARCHAR(4), CARRIERROUTEINCLUDEIN3553 VARCHAR(1), CATSUBCATIND VARCHAR(2), CITYNAMEALTANSWERALLOWED VARCHAR(1), CITYNAMEANSWER VARCHAR(28), CUSTOMERID VARCHAR(9), DEFAULTFLAG VARCHAR(1), DELIVADDRLINE1ALTANSWERALLOWED VARCHAR(1), DELIVADDRLINE2ALTANSWERALLOWED VARCHAR(1), DELIVERYPOINTCHECKDIGITANSWER VARCHAR(1), DELIVERYADDRESSLINE1ANSWER VARCHAR(95), DELIVERYADDRESSLINE1INPUT VARCHAR(95), DELIVERYADDRESSLINE2ANSWER VARCHAR(64), DELIVERYADDRESSLINE2INPUT VARCHAR(64), DELIVERYPOINTANSWER VARCHAR(2), DELIVERYPOINTINCLUDEIN3553 VARCHAR(1), FIRMNAMEANSWER VARCHAR(64), FIRMORRECIPIENTINPUT VARCHAR(64), INTERNALUSE1 VARCHAR(1), LASTLINEINPUT VARCHAR(42), LOCATABLEADDRESSCONVERSIONIND VARCHAR(1), ELOTASCDESCANSWER VARCHAR(1), ELOTSEQUENCEANSWER VARCHAR(4), MULTIPLERESPONSEZIP4ANSWER1 VARCHAR(9), MULTIPLERESPONSEZIP4ANSWER2 VARCHAR(9), NDICODE VARCHAR(1), PMBDESIGNATOR VARCHAR(4), PMBNUMBER VARCHAR(8), RECORDTYPECODE VARCHAR(1), STATECODEANSWER VARCHAR(2), URBANIZATIONANSWER VARCHAR(28), URBANIZATIONINPUT VARCHAR(28), INTERNALRESEARCHDEVIND VARCHAR(1), ZIP4ADDONANSWER VARCHAR(4), ZIP4ADDONINCLUDEIN3553 VARCHAR(1), ZIPCODEALTANSWERALLOWED VARCHAR(1), ZIPCODEANSWER VARCHAR(5), ZIPCODEINCLUDEIN3553 VARCHAR(1), CREATED TIMESTAMP, MODIFIED TIMESTAMP, NONDELIVERABLERECORDIND VARCHAR(1), ADDRESSMATCHINGRESULTIND VARCHAR(10), EWSFLAG VARCHAR(1), INTERNALUSE2 VARCHAR(1), ELOTSEQUENCE VARCHAR(4), ELOTASCDESC VARCHAR(1), DPVCONFIRMATIONIND VARCHAR(1), DPVCMRAIND VARCHAR(1), DPVFALSEPOSITIVEIND VARCHAR(1), DSF2DELIVERYTYPE VARCHAR(1), DSF2NOSTATSIND VARCHAR(1), DSF2BUSINESSIND VARCHAR(1), DSF2DROPIND VARCHAR(1), DSF2DROPCOUNT VARCHAR(3), DSF2THROWBACKIND VARCHAR(1), DSF2SEASONALIND VARCHAR(1), DSF2VACANTIND VARCHAR(1), DSF2LACSIND VARCHAR(1), DPVFOOTNOTE1 VARCHAR(2), DPVFOOTNOTE2 VARCHAR(2), DPVFOOTNOTE3 VARCHAR(2), DSF2PRIMARYNUMBERERRORFLAG VARCHAR(1), DSF2SECONDARYNUMBERERRORFLAG VARCHAR(1), INTERNALUSE3 VARCHAR(12), LISTPK BIGINT NOT NULL, HRFLAG SMALLINT, HRDEFAULTFLAG SMALLINT, RRFLAG SMALLINT, RRDEFAULTFLAG SMALLINT, RESIDENTIALDELIVERYIND VARCHAR(1), CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, ADDRESSPRIMARYNUMBERANSWER VARCHAR(10), ADDRESSPRIMARYODDEVENCODE VARCHAR(1), ADDRESSSECONDARYABBR VARCHAR(4), ADDRESSSECONDARYODDEVENCODE VARCHAR(1), ADDRESSSECONDARYNUMBERANSWER VARCHAR(8), BUILDINGTYPE VARCHAR(1), CONGRESSIONALDISTRICTNUM VARCHAR(2), COUNTYNUM VARCHAR(3), COUNTYNAME VARCHAR(25), FINANCENUM VARCHAR(6), STREETNAMEANSWER VARCHAR(28), STREETNAMEABBRANSWER VARCHAR(28), STREETPOSTDIRECTIONALABBR VARCHAR(2), STREETPREDIRECTIONALABBR VARCHAR(2), STREETSUFFIXABBR VARCHAR(4), ZIPSECTORANSWER VARCHAR(2), ZIPSEGMENTANSWER VARCHAR(2), HIGHRISEDEFAULTALTERNATE SMALLINT, CITYMAILINGNAMEANSWER VARCHAR(28), SECONDARYABBR1 VARCHAR(4), SECONDARYABBR2 VARCHAR(4), SECONDARYNUMBER1 VARCHAR(8), SECONDARYNUMBER2 VARCHAR(8), STANDARDSECUNIT VARCHAR(30), STREETSUFFIXPRIMARYNAMEANSWER VARCHAR(30), ZIPCLASSTYPE VARCHAR(1), STREETSUFFIXANSWER VARCHAR(30), CITYSTATEMAILINGNAMEIND SMALLINT, APPROVEDABBRSECUNIT VARCHAR(30), DELIVERYADDRESSLINE1SHORTANSWR VARCHAR(30), DELIVERYADDRESSLINE2SHORTANSWR VARCHAR(30), DSF2EDUCATIONALIND VARCHAR(1), LACSLINKIND VARCHAR(1), LACSLINKRETURNCODE VARCHAR(2), MERGEVERSION INTEGER, EPOCHVERSION INTEGER, PREFIXTITLEINPUT VARCHAR(12), FIRSTNAMEINPUT VARCHAR(30), MIDDLENAMEINPUT VARCHAR(30), LASTNAMEINPUT VARCHAR(30), SUFFIXTITLEINPUT VARCHAR(6), UNPARSEDNAMEINPUT VARCHAR(66), PROFESSIONALTITLEINPUT VARCHAR(64), FUNCTIONALTITLEINPUT VARCHAR(64), DEPARTMENTINPUT VARCHAR(64), MAILSTOPCODEINPUT VARCHAR(64), NAMEINPUTPARSEDYN SMALLINT, ADDRESSINPUTPARSEDYN SMALLINT, ADDRESSPRIMARYNUMBERINPUT VARCHAR(10), STREETPREDIRECTIONALABBRINPUT VARCHAR(2), STREETNAMEINPUT VARCHAR(28), STREETSUFFIXABBRINPUT VARCHAR(4), STREETPOSTDIRECTIONALABBRINPUT VARCHAR(2), ADDRESSSECONDARYABBRINPUT VARCHAR(4), ADDRESSSECONDARYNUMBERINPUT VARCHAR(8), LASTLINEINPUTPARSEDYN SMALLINT, CITYNAMEINPUT VARCHAR(28), STATECODEINPUT VARCHAR(2), ZIPCODEINPUT VARCHAR(5), ZIP4ADDONINPUT VARCHAR(4), PREFIXTITLEANSWER VARCHAR(6), FIRSTNAMEANSWER VARCHAR(15), MIDDLENAMEANSWER VARCHAR(15), LASTNAMEANSWER VARCHAR(20), SUFFIXTITLEANSWER VARCHAR(6), URBANIZATIONCOAANSWER VARCHAR(28), ADDRESSPRIMARYNUMBERCOAANSWER VARCHAR(10), STREETPREDIRECTIONALCOAANSWER VARCHAR(2), STREETNAMECOAANSWER VARCHAR(28), STREETSUFFIXABBRCOAANSWER VARCHAR(4), STREETPOSTDIRECTIONALCOAANSWER VARCHAR(2), ADDRESSSECONDARYABBRCOAANSWER VARCHAR(4), ADDRESSSECONDARYNUMCOAANSWER VARCHAR(8), CITYNAMECOAANSWER VARCHAR(28), STATECODECOAANSWER VARCHAR(2), ZIPCODECOAANSWER VARCHAR(5), ZIP4ADDONCOAANSWER VARCHAR(4), DPBCCOAANSWER VARCHAR(3), CARRIERROUTECOAANSWER VARCHAR(4), DROPFLAGIND VARCHAR(1), DROPNFLAGIND VARCHAR(1), MOVEEFFECTIVEDATECOAANSWER VARCHAR(6), MIDDLENAMECOAANSWER VARCHAR(2), GENDERCOAANSWER VARCHAR(1), HINTCOAANSWER VARCHAR(8), COAFOOTNOTE VARCHAR(4), HEXEMDP VARCHAR(16), HEXSHAEMDP VARCHAR(40), HEXOFFIRST8OF48OBJECT VARCHAR(16), FIRSTNAMEOF48OBJECT VARCHAR(15), LASTNAMEOF48OBJECT VARCHAR(20), SUFFIXNAMEOF48OBJECT VARCHAR(5), HEXSHAOF48OBJECT VARCHAR(40), HEXOFDATARETRIEVED VARCHAR(16), DECIMALOF17RESULTVALUE VARCHAR(17), MOVETYPEIND VARCHAR(1), USERDATA VARCHAR(255), TOTALNUMCOAQUERIES INTEGER, COAMATCHREJECTED SMALLINT, COARELEASENUMBER INTEGER, CHANGED SMALLINT, PSEUDOSEQUENCE INTEGER, ABSOLUTESEQUENCE INTEGER, LASTLINEANSWER VARCHAR(42), DELIVERYLINE1COAANSWER VARCHAR(95), DELIVERYLINE2COAANSWER VARCHAR(64), LASTLINECOAANSWER VARCHAR(42), COAFUSENEEDED SMALLINT, USERDATA2 VARCHAR(30), USERDATA3 VARCHAR(30), USERDATA4 VARCHAR(30), USERDATA5 VARCHAR(30), USERDATA6 VARCHAR(30), USERDATA7 VARCHAR(30), USERDATA8 VARCHAR(30), OEL VARCHAR(64), PLANET VARCHAR(11), LABELLISTNAME VARCHAR(6), LABELID VARCHAR(30), LABELSTATE VARCHAR(2), LABELZIP VARCHAR(5), LABELMISC VARCHAR(20), LABELINDICATOR VARCHAR(1), EMAIL VARCHAR(64), PHONE VARCHAR(20), CONTAINERSORTATIONLEVEL VARCHAR(4), RATECLASSID BIGINT, CONTAINERSEQUENCE INTEGER, WEIGHTUM BIGINT, CITYNAMESHORTANSWER VARCHAR(13), PIECEENTRYSTATECOUNTYNUMBER VARCHAR(5), PALLETID INTEGER, PALLETLINE1LABEL VARCHAR(43), PALLETSORTATIONLEVEL VARCHAR(4), PALLETDESTFACILITYZIPCODE VARCHAR(5), MAILCLASSIFICATION VARCHAR(1), CUSTOMERCODE VARCHAR(1), POSTAGEPAYMENTMETHODINPUT VARCHAR(1), AMOUNTOFAFFIXEDPOSTAGE DECIMAL(7, 3), MAILPIECECHARACTERISTICCODE VARCHAR(1), PIECEWEIGHT DECIMAL(6, 4), PIECETHICKNESS DECIMAL(6, 4), PIECELENGTH DECIMAL(7, 4), PIECEHEIGHT DECIMAL(6, 4), BARCODEVERIFIER SMALLINT, CONTAINERDESTFACILITYZIPCODE VARCHAR(5), CINCODE VARCHAR(3), TRAYPROCESSINGCODE VARCHAR(2), CINVERBIAGE VARCHAR(23), GROUPPACKAGEINDICATOR VARCHAR(1), GROUPPACKAGEID INTEGER, GROUPPACKAGESORTATIONLEVEL VARCHAR(4), GROUPPACKAGEDESTINATION VARCHAR(9), RATECODE VARCHAR(7), ZONE VARCHAR(3), DESTINATIONENTRY VARCHAR(1), MAILSTREAMSPLITINDICATOR VARCHAR(2), KEYLINE VARCHAR(30), FIRSTMANIFESTPIECEIDOFBATCH INTEGER, LASTMANIFESTPIECEIDOFBATCH INTEGER, POSTAGEPAYMENTMETHODANSWER VARCHAR(1), QUALIFYINGPIECEPOSTAGE DECIMAL(7, 4), PARCELBARCODEDDISCOUNT SMALLINT, MANIFESTBATCHPOSTAGE DECIMAL(7, 3), CONTAINER INTEGER, CONTAINERTYPE VARCHAR(2), CONTAINERLABEL VARCHAR(43), DELIVERYLINE1DDPVANSWER VARCHAR(95), DELIVERYLINE2DDPVANSWER VARCHAR(64), LASTLINEDDPVANSWER VARCHAR(42), DDPVRESULT VARCHAR(1), SUITELINKRETURNCODE VARCHAR(2), DELIVERYLINE1SUITEANSWER VARCHAR(95), SUITEFUSENEEDED SMALLINT); ALTER TABLE DS3.LISTDETAIL ADD CONSTRAINT C4540712 PRIMARY KEY (LISTDETAILPK); CREATE TABLE DS3.LIST (LISTPK BIGINT NOT NULL, A1CASSZ4CHANGECOMPANYNAME VARCHAR(40), A1CASSZ4CHANGECONFIGURATION VARCHAR(3), A1CASSZ4CHANGESOFTWARENAME VARCHAR(30), A1CASSZ4CHANGESOFTWAREVERSION VARCHAR(16), A1LOTDPCSOFTWARENAME VARCHAR(30), A1LOTDPCSOFTWAREVERSION VARCHAR(16), A1LOTDPCUTILITYCOMPANYNAME VARCHAR(40), A1LOTDPCUTILITYCONFIGURATION VARCHAR(3), B1LISTPROCESSORNAME VARCHAR(25), B2CARRIERROUTEPROCESSDATE DATE, B2LOTPROCESSDATE DATE, B2MASTERFILEPROCESSDATE DATE, B2Z4CHANGEPROCESSDATE DATE, B3CARRIERROUTEDATABASEDATE DATE, B3LOTDATABASEDATE DATE, B3ZIP4DATABASEDATE DATE, B4ADDRESSLISTNAME VARCHAR(64), B5NUMBERLISTSPROCESSED BIGINT, B6TOTALRECORDSSUBMITTED BIGINT, C1TOTALRECORDSZIP4CODED BIGINT, C1ZIP4VALIDFROMDATE DATE, C1ZIP4VALIDTODATE DATE, C2TOTALRECORDSZ4CHANGECODED BIGINT, C3DPBCVALIDFROMDATE DATE, C3DPBCVALIDTODATE DATE, C3TOTALDPBCCODED BIGINT, C45DIGITVALIDFROMDATE DATE, C45DIGITVALIDTODATE DATE, C4TOTALRECORDS5DIGITCODED BIGINT, C5CARRIERROUTEVALIDFROMDATE DATE, C5CARRIERROUTEVALIDTODATE DATE, C5TOTALCARRIERROUTECODED BIGINT, C6LOTVALIDFROMDATE DATE, C6LOTVALIDTODATE DATE, C6TOTALRECORDSLOTCODED BIGINT, COPYRIGHTSYMBOL VARCHAR(11), FILEVERSIONDATE DATE, SEQUENCENUMBER VARCHAR(3), STAGENUMBER VARCHAR(6), SYSTEMNAME VARCHAR(5), TOTALHIGHRISEDEFAULT BIGINT, TOTALHIGHRISEEXACT BIGINT, TOTALLACS BIGINT, TOTALRURALROUTEDEFAULT BIGINT, TOTALRURALROUTEEXACT BIGINT, Z4CHANGEDATE DATE, CREATED TIMESTAMP, MODIFIED TIMESTAMP, TOTALEWS BIGINT, TOTALDPV BIGINT, DPVDATE DATE, PLATFORMFORTEST VARCHAR(12), CONFIGURATIONFORTEST VARCHAR(3), TOTALRDI BIGINT, TOTALRECORDSPROCESSED BIGINT, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, CUSTOMERID BIGINT, STOREID BIGINT NOT NULL, FILENAME VARCHAR(255) NOT NULL, ERRORMESSAGE VARCHAR(256), MANUALEDITFLAG SMALLINT, CUSTADDRPK BIGINT, JOBDEFID BIGINT, MERGEVERSION INTEGER NOT NULL, EPOCHVERSION INTEGER NOT NULL, NCSCFILECREATETIME TIME, NCSCFILENUM VARCHAR(32), NCSCRELEASEDATE DATE, NCSCZIP4RELEASEDATE DATE, NCSCDPVRELEASEDATE DATE, NCSCTYPE VARCHAR(1), LACSDATE DATE, COADATE DATE, CORRECTED BIGINT, PAFPK BIGINT, ORIGINZIPCODE VARCHAR(5), TESTFILECREATED TIMESTAMP, AMSIIEPOCH TIMESTAMP, STANDARDTESTINGSETIDKEY VARCHAR(3), CYCLETESTNUMBERIDKEY VARCHAR(4), ENTRYSTATEANDCOUNTYNUMBER VARCHAR(5), PIECEWEIGHT DECIMAL(6, 4), PIECELENGTH DECIMAL(7, 4), PIECEHEIGHT DECIMAL(6, 4), PIECETHICKNESS DECIMAL(6, 4), PRESORTPROCESSDATE TIMESTAMP, ADVERTISINGPERCENTAGE DECIMAL(4, 2), CONTAINERCOMPRESSIONFACTOR DECIMAL(4, 3), AMSIIEPOCHUSEDTOPROCESSFILE TIMESTAMP, TRAYMINIMUMPERCENTAGE DECIMAL(4, 3), ZONECHARTMATRIXDATE TIMESTAMP, PRESORTEDSEQUENCENUMBER INTEGER); ALTER TABLE DS3.LIST ADD CONSTRAINT C4251028 PRIMARY KEY (LISTPK); CREATE TABLE DS3.STORE (STOREID BIGINT NOT NULL, CREDITCARD VARCHAR(16), CREDITCARDEXP VARCHAR(6), NAME VARCHAR(64) NOT NULL, ADDRESS VARCHAR(64) NOT NULL, CITY VARCHAR(28) NOT NULL, STATE VARCHAR(2) NOT NULL, ZIP VARCHAR(10) NOT NULL, CREDITLIMIT DECIMAL(20, 2), FOREIGNCOUNTRY VARCHAR(30), FOREIGNPOSTALCODE VARCHAR(10), CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, DPC VARCHAR(3), CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, PASSWORD VARCHAR(20) NOT NULL, ACTIVE SMALLINT, GEOCODE VARCHAR(10), COMPANYID BIGINT NOT NULL, TIGERLINEID VARCHAR(10), TIGERRIGHTLEFTFLAG VARCHAR(1), TIGERCENSUSTRACT VARCHAR(6), TIGERCENSUSBLOCK VARCHAR(4), TIGERFROMLATITUDE VARCHAR(9), TIGERFROMLONGITUDE VARCHAR(10), TIGERTOLATITUDE VARCHAR(9), TIGERTOLONGITUDE VARCHAR(10), TIGERPMSA VARCHAR(4), TIGERCMSA VARCHAR(4), TIGERMULTIMATCH VARCHAR(1), ONROADUNITSALESTAXRATE DECIMAL(20, 5), OFFROADUNITSALESTAXRATE DECIMAL(20, 5), SERVICESALESTAXRATE DECIMAL(20, 5), ITEMSALESTAXRATE DECIMAL(20, 5), MERCHANTID BIGINT, PMTSTORENUMBER INTEGER, BUILDINGORFIRMNAME VARCHAR(40), CARRIERROUTEID VARCHAR(4), ELOTASCDES VARCHAR(1), ELOTSEQNUM VARCHAR(4), URBANIZATION VARCHAR(28), OPENTOPUBLIC SMALLINT, SIC VARCHAR(6), FEDERALTAXID VARCHAR(13)); ALTER TABLE DS3.STORE ADD CONSTRAINT STORE PRIMARY KEY (STOREID); CREATE TABLE DS3.STOREACCESS (STOREACCESSID BIGINT NOT NULL, STOREID BIGINT NOT NULL, STORETRUSTEEID BIGINT NOT NULL, ACCESSTYPE BIGINT NOT NULL, CONTRACTREFERENCE VARCHAR(50), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT); ALTER TABLE DS3.STOREACCESS ADD CONSTRAINT C5738184 PRIMARY KEY (STOREACCESSID); CREATE TABLE DS3.STOREBAL (STOREBALPK BIGINT NOT NULL, AVGDAYSTOPAY INTEGER, AVGPAY DECIMAL(20, 2), CURRENTBALANCE DECIMAL(20, 2) NOT NULL, HIGHESTBALANCE DECIMAL(20, 2) NOT NULL, LASTPAYDATE DATE, PREVIOUSBALANCE DECIMAL(20, 2), MAXPAYAMOUNT DECIMAL(20, 2), MINPAYAMOUNT DECIMAL(20, 2), MAXDAYSTOPAY INTEGER, MINDAYSTOPAY INTEGER, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, BALANCETYPEID BIGINT NOT NULL, STOREID BIGINT NOT NULL, FISCALYEARENDING INTEGER NOT NULL, BEGINNINGBALANCE DECIMAL(20, 2) NOT NULL, JAN DECIMAL(20, 2), FEB DECIMAL(20, 2), MAR DECIMAL(20, 2), APR DECIMAL(20, 2), MAY DECIMAL(20, 2), JUN DECIMAL(20, 2), JUL DECIMAL(20, 2), AUG DECIMAL(20, 2), SEP DECIMAL(20, 2), OCT DECIMAL(20, 2), NOV DECIMAL(20, 2), DEC DECIMAL(20, 2)); ALTER TABLE DS3.STOREBAL ADD CONSTRAINT STOREBAL PRIMARY KEY (STOREBALPK); CREATE TABLE DS3.STORECONTACT (STORECONTACTPK BIGINT NOT NULL, CONTACTDATA VARCHAR(255) NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, STOREID BIGINT NOT NULL, CONTACTTYPEID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, CONTACTMEMO VARCHAR(30), ACTIVE SMALLINT); ALTER TABLE DS3.STORECONTACT ADD CONSTRAINT STORECONTACT PRIMARY KEY (STORECONTACTPK); CREATE TABLE DS3.STORENOTE (CREATED TIMESTAMP NOT NULL, NOTE VARCHAR(2048) NOT NULL, STORENOTEPK BIGINT NOT NULL, STOREID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, ACTIVE SMALLINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.STORENOTE ADD CONSTRAINT STORENOTE PRIMARY KEY (STORENOTEPK); CREATE TABLE DS3.MODEL (MODELID VARCHAR(12) NOT NULL, DESCRIPTION VARCHAR(30) NOT NULL, MAKEID BIGINT NOT NULL, STYLEID BIGINT NOT NULL, TYPEID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, BUILDMINUTES INTEGER, CHASSISSERIALNUM VARCHAR(30), COLOR VARCHAR(40), COST DECIMAL(20, 2), SPECIFICATIONS VARCHAR(3000), ENGINESERIALNUM VARCHAR(30), FREIGHTIN DECIMAL(20, 2), GROSSWEIGHT BIGINT, GROSSWEIGHTUM BIGINT, PRICE DECIMAL(20, 2), YEAR INTEGER, ENGINESIZE BIGINT, SETUPPDI DECIMAL(20, 2), RESERVE DECIMAL(20, 2), DRYWEIGHT BIGINT, CRATEWEIGHT BIGINT, MFGCODE VARCHAR(20), STOREID BIGINT, MODELPK BIGINT NOT NULL); ALTER TABLE DS3.MODEL ADD CONSTRAINT MODEL PRIMARY KEY (MODELPK); CREATE TABLE DS3.ORDER (ORDERID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, ORDERDATE DATE NOT NULL, TAX DECIMAL(20, 2), TOTAL DECIMAL(20, 2), MODIFIED TIMESTAMP, STOREID BIGINT NOT NULL, ORDERTYPEID BIGINT NOT NULL, CUSTADDRID BIGINT, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ORDERSTATUSID BIGINT NOT NULL, BATCHID BIGINT NOT NULL, POSTEDYN SMALLINT, DESCRIPTION VARCHAR(3500), CUSTOMERID BIGINT, ITEMTOTAL DECIMAL(20, 2), SERVICETOTAL DECIMAL(20, 2), UNITTOTAL DECIMAL(20, 2), TRADEINTOTAL DECIMAL(20, 2), PAYMENTTOTAL DECIMAL(20, 2)); ALTER TABLE DS3.ORDER ADD CONSTRAINT ORDER PRIMARY KEY (ORDERID); CREATE TABLE DS3.ORDERITEM (ORDERITEMID BIGINT NOT NULL, ORDERID BIGINT NOT NULL, ITEMID BIGINT NOT NULL, UM BIGINT NOT NULL, ORDERQUANTITY DECIMAL(20, 5) NOT NULL, SHIPQUANTITY DECIMAL(20, 5), BACKORDERQUANTITY DECIMAL(20, 5), ITEMPRICE DECIMAL(20, 5) NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, DESCRIPTION VARCHAR(3500) NOT NULL); ALTER TABLE DS3.ORDERITEM ADD CONSTRAINT ORDERITEM PRIMARY KEY (ORDERITEMID); CREATE TABLE DS3.ORDERPAYMENT (ORDERPAYMENTID BIGINT NOT NULL, ORDERID BIGINT NOT NULL, PAYMENTTYPEID BIGINT NOT NULL, AMOUNT DECIMAL(20, 2) NOT NULL, REFERENCE VARCHAR(30), EXPIRATION DATE, NAMEONCARD VARCHAR(64), TELEPHONE VARCHAR(20), CARDBILLINGADDRESS VARCHAR(64), AUTHCODE VARCHAR(30), CUSTBALANCEID BIGINT, STOREBALANCEID BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, LENDERID BIGINT, AUTHRESPONSEPK BIGINT, CARDBILLINGZIPCODE VARCHAR(10), ACCOUNT VARCHAR(30), PINABA VARCHAR(10)); ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT ORDERPAYMENT PRIMARY KEY (ORDERPAYMENTID); CREATE TABLE DS3.ORDERSERVICE (AMOUNT DECIMAL(20, 2) NOT NULL, CREATED TIMESTAMP NOT NULL, QUANTITY INTEGER NOT NULL, FULFILLDATE DATE, ORDERSERVICEID BIGINT NOT NULL, REQUESTDATE DATE NOT NULL, MODIFIED TIMESTAMP, ORDERID BIGINT NOT NULL, SERVICEITEMID VARCHAR(20) NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, FULFILLTIME TIME, FULFILLID VARCHAR(30), SERVICEPROVIDERID BIGINT NOT NULL, DESCRIPTION VARCHAR(3500), EQUIPMENTID BIGINT); ALTER TABLE DS3.ORDERSERVICE ADD CONSTRAINT ORDERSERVICE PRIMARY KEY (ORDERSERVICEID); CREATE TABLE DS3.ORDERTAX (ORDERTAXID BIGINT NOT NULL, ORDERID BIGINT NOT NULL, TAXTYPE VARCHAR(30), DESCRIPTION VARCHAR(100), TAXABLEAMOUNT DECIMAL(20, 2), TAX DECIMAL(20, 2), GEOCODE VARCHAR(10), LOCATION VARCHAR(8), TAXRATE DECIMAL(20, 5), FLATRATE DECIMAL(20, 2), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.ORDERTAX ADD CONSTRAINT ORDERTAX PRIMARY KEY (ORDERTAXID); CREATE TABLE DS3.ORDERTAXDETAIL (ORDERTAXDETAILID BIGINT NOT NULL, TAXTYPE VARCHAR(30) NOT NULL, DESCRIPTION VARCHAR(100) NOT NULL, TAXABLEAMOUNT DECIMAL(20, 2) NOT NULL, TAX DECIMAL(20, 2) NOT NULL, GEOCODE VARCHAR(10) NOT NULL, LOCATION VARCHAR(8), TAXRATE DECIMAL(20, 5), FLATRATE DECIMAL(20, 2), ORDERID BIGINT NOT NULL, RELATEDTABLEID BIGINT NOT NULL, RELATEDRECORDID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.ORDERTAXDETAIL ADD CONSTRAINT ORDERTAXDETAIL PRIMARY KEY (ORDERTAXDETAILID); CREATE TABLE DS3.ORDERTRADEIN (ORDERTRADEINID BIGINT NOT NULL, ORDERID BIGINT NOT NULL, LENDERID BIGINT, LENDERACCOUNT VARCHAR(30), PAYOFFAMOUNT DECIMAL(20, 2), PAYOFFDATE DATE, PAYOFFPERDIEM DECIMAL(20, 2), CATEGORY VARCHAR(20), CHASSISSERIALNUM VARCHAR(30), COLOR VARCHAR(30), ENGINESERIALNUM VARCHAR(30), GROSSUNITWEIGHT BIGINT, GROSSUNITWEIGHTUM BIGINT, LICENSENUM VARCHAR(10), LOCATIONID BIGINT, MAKE VARCHAR(30), MILES BIGINT, MODELPK BIGINT, NEWUSED VARCHAR(1), RECEIVEDATE DATE, UNITID BIGINT, UNITSERIALNUM VARCHAR(30), YEAR INTEGER, ALLOWANCE DECIMAL(20, 2), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, DESCRIPTION VARCHAR(3000)); ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT ORDERTRADEIN PRIMARY KEY (ORDERTRADEINID); CREATE TABLE DS3.ORDERTRADEINACCY (ORDERTRADEINACCYID BIGINT NOT NULL, ORDERTRADEINID BIGINT NOT NULL, DESCRIPTION VARCHAR(3500), ALLOWANCE DECIMAL(20, 2), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.ORDERTRADEINACCY ADD CONSTRAINT ORDERTRADEINACCY PRIMARY KEY (ORDERTRADEINACCYID); CREATE TABLE DS3.ORDERUNIT (ORDERUNITID BIGINT NOT NULL, ORDERID BIGINT NOT NULL, UNITID BIGINT NOT NULL, CUSTOMERID1 BIGINT, CUSTADDRID1 BIGINT, CUSTOMERID2 BIGINT, CUSTADDRID2 BIGINT, UNITPRICE DECIMAL(20, 2) NOT NULL, FREIGHTOUT DECIMAL(20, 2), INSPECTION DECIMAL(20, 2), PREP DECIMAL(20, 2), UNITINVENTORYTAX DECIMAL(20, 2), DOCUMENTFEE DECIMAL(20, 2), LICENSE DECIMAL(20, 2), TRANSFER DECIMAL(20, 2), TITLE DECIMAL(20, 2), REGISTRATION DECIMAL(20, 2), OPTIONPRICE DECIMAL(20, 2), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, DESCRIPTION VARCHAR(3000), OPTIONINSTALLPRICE DECIMAL(20, 2), FINANCESTARTDATE DATE, UNITCOST DECIMAL(20, 2), FINANCERATE DECIMAL(7, 5), OPTIONCOST DECIMAL(20, 2), OPTIONINSTALLCOST DECIMAL(5, 0), FREIGHTIN DECIMAL(20, 2)); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT ORDERUNIT PRIMARY KEY (ORDERUNITID); CREATE TABLE DS3.PAYMENT (PAYMENTID BIGINT NOT NULL, CUSTOMERID BIGINT, AMOUNT DECIMAL(20, 2) NOT NULL, CUSTBALANCEID BIGINT, PAYMENTTYPEID BIGINT NOT NULL, AUTHCODE VARCHAR(30), CARDBILLINGADDRESS VARCHAR(64), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, EXPIRATION DATE, NAMEONCARD VARCHAR(64), REFERENCE VARCHAR(30), TELEPHONE VARCHAR(20), BATCHID BIGINT, STOREBALANCEID BIGINT, POSTEDYN SMALLINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, STOREID BIGINT); ALTER TABLE DS3.PAYMENT ADD CONSTRAINT PAYMENT PRIMARY KEY (PAYMENTID); CREATE TABLE DS3.REMINDER (REMINDERID BIGINT NOT NULL, SUBJECT VARCHAR(30) NOT NULL, REMINDERTYPE BIGINT, DESCRIPTION VARCHAR(1024), RESPONSE VARCHAR(1024), REVIEWDATE DATE, REVIEWTIME TIME, REVIEWUSERPK BIGINT, ASSIGNDATE DATE, ASSIGNTIME TIME, ASSIGNUSERPK BIGINT, COMPLETIONDATE DATE, COMPLETIONTIME TIME, COMPLETIONUSERPK BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, URL VARCHAR(250), STOREID BIGINT, PRIORITY BIGINT); ALTER TABLE DS3.REMINDER ADD CONSTRAINT C2336269 PRIMARY KEY (REMINDERID); CREATE TABLE DS3.SERVICE (CREATED TIMESTAMP NOT NULL, DAYS INTEGER NOT NULL, SERVICEID BIGINT NOT NULL, STARTDATE DATE NOT NULL, SERVICEITEMID VARCHAR(20) NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, EQUIPMENTID BIGINT, ORDERID BIGINT NOT NULL, ORDERSERVICEID BIGINT NOT NULL, MODIFIED TIMESTAMP, CUSTADDRID BIGINT NOT NULL, STOREID BIGINT NOT NULL, SERVICEPROVIDERID BIGINT NOT NULL); ALTER TABLE DS3.SERVICE ADD CONSTRAINT SERVICE PRIMARY KEY (SERVICEID); CREATE TABLE DS3.SERVICEITEM (SERVICEITEMID VARCHAR(20) NOT NULL, CREATED TIMESTAMP NOT NULL, FOREIGNID VARCHAR(30), ONETIMECHARGE SMALLINT NOT NULL, PRICE DECIMAL(20, 2) NOT NULL, PRORATE SMALLINT NOT NULL, REQUIRED SMALLINT NOT NULL, MODIFIED TIMESTAMP, SERVICEPREFIX VARCHAR(30), PRICECODE INTEGER, DESCRIPTION VARCHAR(30) NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, UM BIGINT, GLREVACCOUNT VARCHAR(20), GLREVSUBACCOUNT VARCHAR(20), STOREID BIGINT NOT NULL); ALTER TABLE DS3.SERVICEITEM ADD CONSTRAINT SERVICEITEM PRIMARY KEY (SERVICEITEMID); CREATE TABLE DS3.SERVICEPROVIDER (CREDITCARD VARCHAR(16), CREDITCARDEXP VARCHAR(6), NAME VARCHAR(64) NOT NULL, ADDRESS VARCHAR(64) NOT NULL, CITY VARCHAR(28) NOT NULL, STATE VARCHAR(2) NOT NULL, ZIP VARCHAR(10) NOT NULL, CREDITLIMIT DECIMAL(20, 2) NOT NULL, FOREIGNCOUNTRY VARCHAR(30), FOREIGNPOSTALCODE VARCHAR(10), CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, DPC VARCHAR(3), CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, PASSWORD VARCHAR(20) NOT NULL, ACTIVE SMALLINT, NICKNAME VARCHAR(10) NOT NULL, SERVICEPROVIDERID BIGINT NOT NULL, BUILDINGORFIRMNAME VARCHAR(40), CARRIERROUTEID VARCHAR(4), ELOTASCDES VARCHAR(1), ELOTSEQNUM VARCHAR(4), URBANIZATION VARCHAR(28)); ALTER TABLE DS3.SERVICEPROVIDER ADD CONSTRAINT SERVICEPROVIDER PRIMARY KEY (SERVICEPROVIDERID); CREATE TABLE DS3.STATEMENT (STATEMENTID BIGINT NOT NULL, CUSTOMERID BIGINT, STATEMENTDATE DATE NOT NULL, CURRENTBALANCE DECIMAL(20, 2) NOT NULL, PREVIOUSBALANCE DECIMAL(20, 2) NOT NULL, REQUIREDPAYMENT DECIMAL(20, 2) NOT NULL, PREPAIDTOTAL DECIMAL(20, 2) NOT NULL, REQUIREDPAYMENTTAXES DECIMAL(20, 2) NOT NULL, PREPAIDTOTALTAXES DECIMAL(20, 2) NOT NULL, GRANDTOTAL DECIMAL(20, 2) NOT NULL, GRANDTOTALTAXES DECIMAL(20, 2) NOT NULL, DUEDATE DATE NOT NULL, CREATEUSERPK BIGINT NOT NULL, BATCHID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, STOREID BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.STATEMENT ADD CONSTRAINT STATEMENT PRIMARY KEY (STATEMENTID); CREATE TABLE DS3.STATEMENTDETAIL (STATEMENTDETAILID BIGINT NOT NULL, STATEMENTDETAILTYPE BIGINT NOT NULL, STATEMENTID BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, SERVICEPROVIDERID BIGINT, CREATED TIMESTAMP NOT NULL, TRANDATE DATE NOT NULL, AMOUNT DECIMAL(20, 2) NOT NULL, DESCRIPTION VARCHAR(64) NOT NULL, TRANDETAILID BIGINT, ORDERID BIGINT, ORDERSERVICEID BIGINT, ORDERTAXID BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT STATEMENTDETAIL PRIMARY KEY (STATEMENTDETAILID); CREATE TABLE DS3.SUPPORT (SUPPORTID BIGINT NOT NULL, SUBJECT VARCHAR(30) NOT NULL, SUPPORTTYPE BIGINT NOT NULL, DESCRIPTION VARCHAR(1024), RESPONSE VARCHAR(1024), REVIEWDATE DATE, REVIEWTIME TIME, REVIEWUSERPK BIGINT, ASSIGNDATE DATE, ASSIGNTIME TIME, ASSIGNUSERPK BIGINT, COMPLETIONDATE DATE, COMPLETIONTIME TIME, COMPLETIONUSERPK BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, URL VARCHAR(250) NOT NULL, STOREID BIGINT); ALTER TABLE DS3.SUPPORT ADD CONSTRAINT C3310897 PRIMARY KEY (SUPPORTID); CREATE TABLE DS3.TERMINAL (DEVICECODEPK BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, TERMINALID INTEGER NOT NULL, CURRENTBATCHPK BIGINT, SEQUENCENUMBER INTEGER NOT NULL, CURRENCYCODEPK BIGINT, STOREPK BIGINT NOT NULL, REQUESTEDACIPK BIGINT, TERMINALPK BIGINT NOT NULL, TERMINALIDNUMBER INTEGER NOT NULL, TERMINALTYPERETAIL SMALLINT); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT C1833781 PRIMARY KEY (TERMINALPK); CREATE TABLE DS3.TRANDETAIL (TRANDETAILID BIGINT NOT NULL, AMOUNT DECIMAL(20, 2) NOT NULL, CREATED TIMESTAMP NOT NULL, DESCRIPTION VARCHAR(30) NOT NULL, REFERENCE VARCHAR(20) NOT NULL, TRANDATE DATE NOT NULL, STOREID BIGINT, TRANTYPEID BIGINT NOT NULL, MODIFIED TIMESTAMP, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, CUSTOMERID BIGINT, CUSTBALANCEID BIGINT, STOREBALANCEID BIGINT, SUBSYSTEMREFERENCE BIGINT NOT NULL, SUBSYSTEMID BIGINT NOT NULL, BATCHID BIGINT); ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT TRANDETAIL PRIMARY KEY (TRANDETAILID); CREATE TABLE DS3.UNIT (UNITID BIGINT NOT NULL, APINVOICEREF VARCHAR(30), NEWUSED VARCHAR(1), YEAR INTEGER, MODELPK BIGINT NOT NULL, CHASSISSERIALNUM VARCHAR(30), ENGINESERIALNUM VARCHAR(30), MILES BIGINT, GROSSUNITWEIGHT BIGINT, GROSSUNITWEIGHTUM BIGINT, LICENSENUM VARCHAR(10), RECEIVEDATE DATE, COST DECIMAL(20, 2), FINANCERATE DECIMAL(7, 5), FINANCESTARTDATE DATE, OPTIONCOST DECIMAL(20, 2), PRICE DECIMAL(20, 2), FREIGHTIN DECIMAL(20, 2), FREIGHTOUT DECIMAL(20, 2), PREP DECIMAL(20, 2), OPTIONPRICE DECIMAL(20, 2), LOCATIONID BIGINT NOT NULL, STOREID BIGINT NOT NULL, COLOR VARCHAR(30), OPTIONINSTALLCOST DECIMAL(20, 2), OPTIONINSTALLPRICE DECIMAL(20, 2), DESCRIPTION VARCHAR(3000), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, CATEGORY VARCHAR(20), STOCKNUMBER VARCHAR(20), CUSTOMERID BIGINT, ORDERUNITID BIGINT, RESERVEDATE DATE, RESERVETIME TIME, RESERVEUSERPK BIGINT, RESERVEEXPIRATIONDATE DATE, RESERVEEXPIRATIONTIME TIME, DELIVERYDATE DATE, DELIVERYTIME TIME, DELIVERYUSERPK BIGINT, BUILDSTATUS BIGINT, BUILDDATE DATE, BUILDUSERPK BIGINT, BUILDTIME TIME, KEYNUMBER VARCHAR(30), INSURANCERATE DECIMAL(7, 5), INSURANCEACTUAL DECIMAL(20, 2), INSURANCEACTUALASOFDATE DATE, FINANCEACTUAL DECIMAL(20, 2), FINANCEACTUALASOFDATE DATE, FINANCEADDPRIME SMALLINT, STATUS BIGINT NOT NULL); ALTER TABLE DS3.UNIT ADD CONSTRAINT UNIT PRIMARY KEY (UNITID); CREATE TABLE DS3.USER (NAME VARCHAR(64) NOT NULL, WORKPHONE VARCHAR(20), POSITION VARCHAR(30), STOREID BIGINT, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, USERPK BIGINT NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT, EMAIL VARCHAR(50), SSN VARCHAR(9), DL VARCHAR(30), HOMEPHONE VARCHAR(20), HOMEADDRESS VARCHAR(64), HOMECITY VARCHAR(28), HOMESTATE VARCHAR(2), HOMEZIP VARCHAR(10), COMPANYID BIGINT, USERTYPEID BIGINT, TIMEZONE VARCHAR(30), LASTORDER BIGINT, LASTORDERBATCH BIGINT, LASTPAYMENTBATCH BIGINT, TIGERLINEID VARCHAR(10), TIGERRIGHTLEFTFLAG VARCHAR(1), TIGERCENSUSTRACT VARCHAR(6), TIGERCENSUSBLOCK VARCHAR(4), TIGERFROMLATITUDE VARCHAR(9), TIGERFROMLONGITUDE VARCHAR(10), TIGERTOLATITUDE VARCHAR(9), TIGERTOLONGITUDE VARCHAR(10), TIGERPMSA VARCHAR(4), TIGERCMSA VARCHAR(4), TIGERMULTIMATCH VARCHAR(1), USERID VARCHAR(30) NOT NULL, TERMINALPK BIGINT, PMTMODE VARCHAR(32), CUSTOMERID BIGINT, CARRIERROUTEID VARCHAR(4), DPC VARCHAR(3), FOREIGNCOUNTRYNAME VARCHAR(30), FOREIGNPOSTALCODE VARCHAR(10), ELOTASCDES VARCHAR(1), ELOTSEQNUM VARCHAR(4), URBANIZATION VARCHAR(28)); ALTER TABLE DS3.USER ADD CONSTRAINT USER PRIMARY KEY (USERPK); CREATE TABLE DS3.USERACCESS (USERACCESSPK BIGINT NOT NULL, USERPK BIGINT NOT NULL, COMPANYID BIGINT NOT NULL, STOREID BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT); ALTER TABLE DS3.USERACCESS ADD CONSTRAINT C3022938 PRIMARY KEY (USERACCESSPK); CREATE TABLE DS3.CREDITREVERSEREQUEST (CREDITREVERSEREQUESTPK BIGINT NOT NULL, BATCHPK BIGINT NOT NULL, CREDITAUTHREQUESTPK BIGINT NOT NULL, RECORDFORMAT VARCHAR(1) NOT NULL, APPLICATIONTYPE INTEGER NOT NULL, MESSAGEDELIMITER VARCHAR(1) NOT NULL, ACQUIRERBINID INTEGER NOT NULL, MERCHANTID BIGINT NOT NULL, PMTSTORENUMBER INTEGER NOT NULL, TERMINALID INTEGER NOT NULL, DEVICECODE VARCHAR(1) NOT NULL, INDUSTRYCODE VARCHAR(1) NOT NULL, COUNTRYCODE VARCHAR(3) NOT NULL, CURRENCYCODE VARCHAR(3) NOT NULL, ZIP VARCHAR(9) NOT NULL, LANGUAGECODE VARCHAR(2) NOT NULL, TIMEZONE VARCHAR(3) NOT NULL, CATEGORYCODE VARCHAR(32) NOT NULL, RETURNEDACI VARCHAR(1) NOT NULL, SEQUENCENUMBER INTEGER NOT NULL, TRANSACTIONCODE VARCHAR(2) NOT NULL, CARDHOLDERIDCODE VARCHAR(1) NOT NULL, ACCOUNTDATASOURCE VARCHAR(1) NOT NULL, CUSTOMERDATA VARCHAR(76) NOT NULL, TOTALAUTHORIZEDAMOUNT DECIMAL(12, 2) NOT NULL, SETTLEMENTAMOUNT DECIMAL(12, 2) NOT NULL, MERCHANTNAME VARCHAR(25) NOT NULL, MERCHANTCITY VARCHAR(13) NOT NULL, TRANSACTIONID VARCHAR(15) NOT NULL, APPROVALCODE VARCHAR(6) NOT NULL, TRANSACTIONDATE DATE NOT NULL, TRANSACTIONTIME TIME NOT NULL, RETRIEVALREFNUMBER VARCHAR(12) NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, MERCHANTSTATE VARCHAR(2) NOT NULL, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CREDITREVERSEREQUEST ADD CONSTRAINT C1028326 PRIMARY KEY (CREDITREVERSEREQUESTPK); CREATE TABLE DS3.CREDITREVERSERESPONSE (CREDITREVERSERESPONSEPK BIGINT NOT NULL, CREDITREVERSEREQUESTPK BIGINT NOT NULL, RETURNEDACI VARCHAR(1), PMTSTORENUMBER INTEGER, TERMINALID INTEGER, AUTHSOURCECODE VARCHAR(1), SEQUENCENUMBER INTEGER, RESPONSECODE VARCHAR(2), APPROVALCODE VARCHAR(6), TRANSACTIONDATE DATE, TRANSACTIONTIME TIME, RESPONSETEXT VARCHAR(16), AVSRESULTCODE VARCHAR(1), RETRIEVALREFNUMBER VARCHAR(12), MARKETDATAID VARCHAR(1), TRANSACTIONID VARCHAR(15), VALIDATIONCODE VARCHAR(4), CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, APPLICATIONTYPE INTEGER, RECORDFORMAT VARCHAR(1), VOIDTRANSACTION SMALLINT, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CREDITREVERSERESPONSE ADD CONSTRAINT C1039560 PRIMARY KEY (CREDITREVERSERESPONSEPK); CREATE TABLE DS3.CUSTACCESS (CUSTACCESSPK BIGINT NOT NULL, CUSTOMERID BIGINT NOT NULL, USERPK BIGINT NOT NULL, ACCESSTYPE BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, STOREID BIGINT NOT NULL); ALTER TABLE DS3.CUSTACCESS ADD CONSTRAINT C3501292 PRIMARY KEY (CUSTACCESSPK); CREATE TABLE DS3.JOBCONTROL (JOBCONTROLPK BIGINT NOT NULL, ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, START TIMESTAMP NOT NULL, PRIORITYINCREASETIME BIGINT, PRIORITY INTEGER NOT NULL, JOBNAME VARCHAR(255), JOBTYPEID BIGINT, JOBINFO BLOB(5242880), STATUSID BIGINT, STATUSMESSAGE VARCHAR(100), LASTSTART TIMESTAMP, LASTFINISH TIMESTAMP, REPETITIONINTERVAL BIGINT, INTERVALTYPEID BIGINT, END TIMESTAMP, INTERVALBEGINSATJOBSTARTTIME SMALLINT, DAYOFWEEKID BIGINT, MONTHDAYOCCURRENCEID BIGINT, MONTHSPECIFICDATE INTEGER, LASTDAYOFMONTH SMALLINT, STOREID BIGINT NOT NULL, RECORDSPROCESSED BIGINT, RUNAFTER BIGINT, CUSTOMERID BIGINT, REFERENCE VARCHAR(32), JOBLINK0 VARCHAR(256), JOBLINK1 VARCHAR(256), JOBLINK2 VARCHAR(256), JOBLINK3 VARCHAR(256), JOBLINK4 VARCHAR(256), PERCENTCOMPLETE INTEGER, RUNSEQUENCE INTEGER, JOBDISPATCHERPK BIGINT, SERVERPK BIGINT, THREADALLOC BIGINT); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT C4250729 PRIMARY KEY (JOBCONTROLPK); CREATE TABLE DS3.PROPERTY (PROPERTYPK BIGINT NOT NULL, LANGUAGE VARCHAR(5) NOT NULL, PROPERTIESFILE VARCHAR(255) NOT NULL, PROPERTYKEY VARCHAR(255) NOT NULL, VALUE LONG VARCHAR NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP); ALTER TABLE DS3.PROPERTY ADD CONSTRAINT C0309231 PRIMARY KEY (PROPERTYPK); CREATE TABLE DS3.COACSLHEADER (COACSLHEADERPK BIGINT NOT NULL, PLATFORMID VARCHAR(4), NUMBEROFRECORDS VARCHAR(14), TOTALCOARECORDSPROCESSED VARCHAR(11), TOTALCOAQUERIESPERFORMED VARCHAR(11), TOTALCOARECORDSMATCHED VARCHAR(11), TOTALCOARECORDSREJECTED VARCHAR(11), TOTALZIP4CODED VARCHAR(11), TOTALDPVCONFIRMED VARCHAR(11), TOTALZIP4MATCHEDPOBOX VARCHAR(11), TOTALZIP4MATCHEDHCREXACT VARCHAR(11), TOTALZIP4MATCHEDRRDEFAULT VARCHAR(11), TOTALZIP4MATCHEDFIRM VARCHAR(11), TOTALZIP4MATCHEDGENERALDEL VARCHAR(11), TOTALZIP4MATCHEDHRDEFAULT VARCHAR(11), TOTALZIP4MATCHEDMILITARY VARCHAR(11), TOTALZIP4MATCHEDNONDELIVERABLE VARCHAR(11), TOTALZIP4MATCHEDRREXACT VARCHAR(11), TOTALZIP4MATCHEDSTREET VARCHAR(11), TOTALZIP4MATCHEDHCRDEFAULT VARCHAR(11), TOTALZIP4MATCHEDHIGHRISEEXACT VARCHAR(11), TOTALZIP4MATCHEDOTHER VARCHAR(11), TOTALZIP4MATCHEDPOSLACS VARCHAR(11), TOTALZIP4MATCHEDEWS VARCHAR(11), COAFOOTNOTEA VARCHAR(11), COAFOOTNOTE91 VARCHAR(11), COAFOOTNOTE92 VARCHAR(11), COAFOOTNOTE1 VARCHAR(11), COAFOOTNOTE2 VARCHAR(11), COAFOOTNOTE3 VARCHAR(11), COAFOOTNOTE4 VARCHAR(11), COAFOOTNOTE5 VARCHAR(11), COAFOOTNOTE6 VARCHAR(11), COAFOOTNOTE7 VARCHAR(11), COAFOOTNOTE8 VARCHAR(11), COAFOOTNOTE9 VARCHAR(11), COAFOOTNOTE10 VARCHAR(11), COAFOOTNOTE11 VARCHAR(11), COAFOOTNOTE12 VARCHAR(11), COAFOOTNOTE13 VARCHAR(11), COAFOOTNOTE14 VARCHAR(11), COAFOOTNOTE15 VARCHAR(11), COAFOOTNOTE16 VARCHAR(11), COAFOOTNOTE17 VARCHAR(11), COAFOOTNOTE18 VARCHAR(11), COAFOOTNOTE19 VARCHAR(11), COAFOOTNOTE20 VARCHAR(11), COAFOOTNOTE66 VARCHAR(11), DPVFOOTNOTEAA VARCHAR(11), DPVFOOTNOTEA1 VARCHAR(11), DPVFOOTNOTEM1 VARCHAR(11), DPVFOOTNOTEM3 VARCHAR(11), DPVFOOTNOTEP1 VARCHAR(11), DPVFOOTNOTEP3 VARCHAR(11), DPVFOOTNOTEBB VARCHAR(11), DPVFOOTNOTERR VARCHAR(11), DPVFOOTNOTECC VARCHAR(11), DPVFOOTNOTEN1 VARCHAR(11), DPVFOOTNOTERR1 VARCHAR(11), DPVFOOTNOTERF1 VARCHAR(11), DPVFOOTNOTERU1 VARCHAR(11), DPVFOOTNOTERG1 VARCHAR(11), MATCHEDMONTH0 VARCHAR(11), MATCHEDMONTH1 VARCHAR(11), MATCHEDMONTH2 VARCHAR(11), MATCHEDMONTH3 VARCHAR(11), MATCHEDMONTH4 VARCHAR(11), MATCHEDMONTH5 VARCHAR(11), MATCHEDMONTH6 VARCHAR(11), MATCHEDMONTH7 VARCHAR(11), MATCHEDMONTH8 VARCHAR(11), MATCHEDMONTH9 VARCHAR(11), MATCHEDMONTH10 VARCHAR(11), MATCHEDMONTH11 VARCHAR(11), MATCHEDMONTH12 VARCHAR(11), MATCHEDMONTH13 VARCHAR(11), MATCHEDMONTH14 VARCHAR(11), MATCHEDMONTH15 VARCHAR(11), MATCHEDMONTH16 VARCHAR(11), MATCHEDMONTH17 VARCHAR(11), MATCHEDMONTH18 VARCHAR(11), MATCHEDMONTH19 VARCHAR(11), MATCHEDMONTH20 VARCHAR(11), MATCHEDMONTH21 VARCHAR(11), MATCHEDMONTH22 VARCHAR(11), MATCHEDMONTH23 VARCHAR(11), MATCHEDMONTH24 VARCHAR(11), MATCHEDMONTH25 VARCHAR(11), MATCHEDMONTH26 VARCHAR(11), MATCHEDMONTH27 VARCHAR(11), MATCHEDMONTH28 VARCHAR(11), MATCHEDMONTH29 VARCHAR(11), MATCHEDMONTH30 VARCHAR(11), MATCHEDMONTH31 VARCHAR(11), MATCHEDMONTH32 VARCHAR(11), MATCHEDMONTH33 VARCHAR(11), MATCHEDMONTH34 VARCHAR(11), MATCHEDMONTH35 VARCHAR(11), MATCHEDMONTH36 VARCHAR(11), MATCHEDMONTH37 VARCHAR(11), MATCHEDMONTH38 VARCHAR(11), MATCHEDMONTH39 VARCHAR(11), MATCHEDMONTH40 VARCHAR(11), MATCHEDMONTH41 VARCHAR(11), MATCHEDMONTH42 VARCHAR(11), MATCHEDMONTH43 VARCHAR(11), MATCHEDMONTH44 VARCHAR(11), MATCHEDMONTH45 VARCHAR(11), MATCHEDMONTH46 VARCHAR(11), MATCHEDMONTH47 VARCHAR(11), MATCHEDMONTH48 VARCHAR(11), DPVSTREETVALIDATED VARCHAR(11), DPVSTREETCMRAPRESENTED VARCHAR(11), DPVSTREETCMRAVALIDATED VARCHAR(11), DPVHIGHRISEVALIDATED VARCHAR(11), DPVHIGHRISECMRAPRESENTED VARCHAR(11), DPVHIGHRISECMRAVALIDATED VARCHAR(11), DPVPOBOXVALIDATED VARCHAR(11), DPVRRHCVALIDATED VARCHAR(11), DPVRRHCCMRAPRESENTED VARCHAR(11), DPVRRHCCMRAVALIDATED VARCHAR(11), DPVFIRMVALIDATED VARCHAR(11), DPVFIRMCMRAPRESENTED VARCHAR(11), DPVFIRMCMRAVALIDATED VARCHAR(11), DPVGENERALDELIVERYVALIDATED VARCHAR(11), TOTALDPVPRIMARYERRORS VARCHAR(11), DPVSTREETPRIMARYNUMBERERRORS VARCHAR(11), DPVHIGHRISEPRIMARYNUMBERERRORS VARCHAR(11), DPVPOBOXPRIMARYNUMBERERRORS VARCHAR(11), DPVRRHCPRIMARYNUMBERERRORS VARCHAR(11), DPVFIRMPRIMARYNUMBERERRORS VARCHAR(11), TOTALDPVSECONDARYNUMBERERRORS VARCHAR(11), DPVSTREETSECONDARYNUMBERERRORS VARCHAR(11), DPVHRSECONDARYNUMBERERRORS VARCHAR(11), DPVFIRMSECONDARYNUMBERERRORS VARCHAR(11), LACSFOOTNOTEA VARCHAR(11), LACSFOOTNOTE00 VARCHAR(11), LACSFOOTNOTE14 VARCHAR(11), LACSFOOTNOTE92 VARCHAR(11), ANK77COAA VARCHAR(11), ANK77COA91 VARCHAR(11), ANK77COA92 VARCHAR(11), ANK77COA1 VARCHAR(11), ANK77COA2 VARCHAR(11), ANK77COA3 VARCHAR(11), ANK77COA4 VARCHAR(11), ANK77COA5 VARCHAR(11), ANK77COA6 VARCHAR(11), ANK77COA7 VARCHAR(11), ANK77COA8 VARCHAR(11), ANK77COA9 VARCHAR(11), ANK77COA10 VARCHAR(11), ANK77COA11 VARCHAR(11), ANK77COA12 VARCHAR(11), ANK77COA13 VARCHAR(11), ANK77COA14 VARCHAR(11), ANK77COA15 VARCHAR(11), ANK77COA16 VARCHAR(11), ANK77COA17 VARCHAR(11), ANK77COA18 VARCHAR(11), ANK77COA19 VARCHAR(11), ANK77COA20 VARCHAR(11), ANK77COA66 VARCHAR(11), TOTALANKRECORDSMATCHED VARCHAR(11), RECORDTYPE VARCHAR(1), CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP); ALTER TABLE DS3.COACSLHEADER ADD CONSTRAINT COACSL_PK PRIMARY KEY (COACSLHEADERPK); CREATE TABLE DS3.COACSLDETAIL (COACSLDETAILPK BIGINT NOT NULL, PAFID VARCHAR(18) NOT NULL, PROCESSINGCATEGORY VARCHAR(10), ADDITIONALNOTES VARCHAR(1), PREPROCESSESPERFORMED VARCHAR(1), CONCURRENTPROCESSESPERFORMED VARCHAR(1), POSTPROCESSESPERFORMED VARCHAR(1), STANDARDOUTPUTRETURNED VARCHAR(1), MATCHINGLOGICAPPLIED VARCHAR(1), DATARETURNED VARCHAR(1), NUMBERMONTHSREQUESTED VARCHAR(2), CLASSOFMAIL VARCHAR(1), DATELISTRECEIVEDFROMCUSTOMER DATE, DATECOAPROCESSINGBEGAN DATE, DATECOAPROCESSINGCOMPLETED DATE, DATELISTRETURNEDTOCUSTOMER DATE, ZIP4SOFTWARENAME VARCHAR(30), ZIP4SOFTWAREVERSION VARCHAR(12), ZIP4DATARELEASEDATE DATE, COASOFTWARENAME VARCHAR(30), COASOFTWAREVERSION VARCHAR(12), COADATARELEASEDATE DATE, DPVSOFTWARENAME VARCHAR(30), DPVSOFTWAREVERSION VARCHAR(12), DPVDATARELEASEDATE DATE, OPERATORID VARCHAR(12), BUYERCOMPANYNAME VARCHAR(30), MAILINGZIPCODE VARCHAR(5), TOTALCOARECORDSPROCESSED VARCHAR(11), TOTALCOAQUERIESPERFORMED VARCHAR(11), TOTALCOARECORDSMATCHED VARCHAR(11), TOTALCOARECORDSREJECTED VARCHAR(11), TOTALZIP4CODED VARCHAR(11), TOTALDPVCONFIRMED VARCHAR(11), TOTALZIP4MATCHEDPOBOX VARCHAR(11), TOTALZIP4MATCHEDHCREXACT VARCHAR(11), TOTALZIP4MATCHEDRRDEFAULT VARCHAR(11), TOTALZIP4MATCHEDFIRM VARCHAR(11), TOTALZIP4MATCHEDGENERALDEL VARCHAR(11), TOTALZIP4MATCHEDHRDEFAULT VARCHAR(11), TOTALZIP4MATCHEDMILITARY VARCHAR(11), TOTALZIP4MATCHEDNONDELIVERABLE VARCHAR(11), TOTALZIP4MATCHEDRREXACT VARCHAR(11), TOTALZIP4MATCHEDSTREET VARCHAR(11), TOTALZIP4MATCHEDHCRDEFAULT VARCHAR(11), TOTALZIP4MATCHEDHIGHRISEEXACT VARCHAR(11), TOTALZIP4MATCHEDOTHER VARCHAR(11), TOTALZIP4MATCHEDPOSLACS VARCHAR(11), TOTALZIP4MATCHEDEWS VARCHAR(11), COAFOOTNOTEA VARCHAR(11), COAFOOTNOTE91 VARCHAR(11), COAFOOTNOTE92 VARCHAR(11), COAFOOTNOTE1 VARCHAR(11), COAFOOTNOTE2 VARCHAR(11), COAFOOTNOTE3 VARCHAR(11), COAFOOTNOTE4 VARCHAR(11), COAFOOTNOTE5 VARCHAR(11), COAFOOTNOTE6 VARCHAR(11), COAFOOTNOTE7 VARCHAR(11), COAFOOTNOTE8 VARCHAR(11), COAFOOTNOTE9 VARCHAR(11), COAFOOTNOTE10 VARCHAR(11), COAFOOTNOTE11 VARCHAR(11), COAFOOTNOTE12 VARCHAR(11), COAFOOTNOTE13 VARCHAR(11), COAFOOTNOTE14 VARCHAR(11), COAFOOTNOTE15 VARCHAR(11), COAFOOTNOTE16 VARCHAR(11), COAFOOTNOTE17 VARCHAR(11), COAFOOTNOTE18 VARCHAR(11), COAFOOTNOTE19 VARCHAR(11), COAFOOTNOTE20 VARCHAR(11), COAFOOTNOTE66 VARCHAR(11), DPVFOOTNOTEAA VARCHAR(11), DPVFOOTNOTEA1 VARCHAR(11), DPVFOOTNOTEM1 VARCHAR(11), DPVFOOTNOTEM3 VARCHAR(11), DPVFOOTNOTEP1 VARCHAR(11), DPVFOOTNOTEP3 VARCHAR(11), DPVFOOTNOTEBB VARCHAR(11), DPVFOOTNOTERR VARCHAR(11), DPVFOOTNOTECC VARCHAR(11), DPVFOOTNOTEN1 VARCHAR(11), DPVFOOTNOTERR1 VARCHAR(11), DPVFOOTNOTERF1 VARCHAR(11), DPVFOOTNOTERU1 VARCHAR(11), DPVFOOTNOTERG1 VARCHAR(11), MATCHEDMONTH0 VARCHAR(11), MATCHEDMONTH1 VARCHAR(11), MATCHEDMONTH2 VARCHAR(11), MATCHEDMONTH3 VARCHAR(11), MATCHEDMONTH4 VARCHAR(11), MATCHEDMONTH5 VARCHAR(11), MATCHEDMONTH6 VARCHAR(11), MATCHEDMONTH7 VARCHAR(11), MATCHEDMONTH8 VARCHAR(11), MATCHEDMONTH9 VARCHAR(11), MATCHEDMONTH10 VARCHAR(11), MATCHEDMONTH11 VARCHAR(11), MATCHEDMONTH12 VARCHAR(11), MATCHEDMONTH13 VARCHAR(11), MATCHEDMONTH14 VARCHAR(11), MATCHEDMONTH15 VARCHAR(11), MATCHEDMONTH16 VARCHAR(11), MATCHEDMONTH17 VARCHAR(11), MATCHEDMONTH18 VARCHAR(11), MATCHEDMONTH19 VARCHAR(11), MATCHEDMONTH20 VARCHAR(11), MATCHEDMONTH21 VARCHAR(11), MATCHEDMONTH22 VARCHAR(11), MATCHEDMONTH23 VARCHAR(11), MATCHEDMONTH24 VARCHAR(11), MATCHEDMONTH25 VARCHAR(11), MATCHEDMONTH26 VARCHAR(11), MATCHEDMONTH27 VARCHAR(11), MATCHEDMONTH28 VARCHAR(11), MATCHEDMONTH29 VARCHAR(11), MATCHEDMONTH30 VARCHAR(11), MATCHEDMONTH31 VARCHAR(11), MATCHEDMONTH32 VARCHAR(11), MATCHEDMONTH33 VARCHAR(11), MATCHEDMONTH34 VARCHAR(11), MATCHEDMONTH35 VARCHAR(11), MATCHEDMONTH36 VARCHAR(11), MATCHEDMONTH37 VARCHAR(11), MATCHEDMONTH38 VARCHAR(11), MATCHEDMONTH39 VARCHAR(11), MATCHEDMONTH40 VARCHAR(11), MATCHEDMONTH41 VARCHAR(11), MATCHEDMONTH42 VARCHAR(11), MATCHEDMONTH43 VARCHAR(11), MATCHEDMONTH44 VARCHAR(11), MATCHEDMONTH45 VARCHAR(11), MATCHEDMONTH46 VARCHAR(11), MATCHEDMONTH47 VARCHAR(11), MATCHEDMONTH48 VARCHAR(11), DPVSTREETVALIDATED VARCHAR(11), DPVSTREETCMRAPRESENTED VARCHAR(11), DPVSTREETCMRAVALIDATED VARCHAR(11), DPVHIGHRISEVALIDATED VARCHAR(11), DPVHIGHRISECMRAPRESENTED VARCHAR(11), DPVHIGHRISECMRAVALIDATED VARCHAR(11), DPVPOBOXVALIDATED VARCHAR(11), DPVRRHCVALIDATED VARCHAR(11), DPVRRHCCMRAPRESENTED VARCHAR(11), DPVRRHCCMRAVALIDATED VARCHAR(11), DPVFIRMVALIDATED VARCHAR(11), DPVFIRMCMRAPRESENTED VARCHAR(11), DPVFIRMCMRAVALIDATED VARCHAR(11), DPVGENERALDELIVERYVALIDATED VARCHAR(11), TOTALDPVPRIMARYERRORS VARCHAR(11), DPVSTREETPRIMARYNUMBERERRORS VARCHAR(11), DPVHIGHRISEPRIMARYNUMBERERRORS VARCHAR(11), DPVPOBOXPRIMARYNUMBERERRORS VARCHAR(11), DPVRRHCPRIMARYNUMBERERRORS VARCHAR(11), DPVFIRMPRIMARYNUMBERERRORS VARCHAR(11), TOTALDPVSECONDARYNUMBERERRORS VARCHAR(11), DPVSTREETSECONDARYNUMBERERRORS VARCHAR(11), DPVHRSECONDARYNUMBERERRORS VARCHAR(11), DPVFIRMSECONDARYNUMBERERRORS VARCHAR(11), LACSFOOTNOTEA VARCHAR(11), LACSFOOTNOTE00 VARCHAR(11), LACSFOOTNOTE14 VARCHAR(11), LACSFOOTNOTE92 VARCHAR(11), ANK77COAA VARCHAR(11), ANK77COA91 VARCHAR(11), ANK77COA92 VARCHAR(11), ANK77COA1 VARCHAR(11), ANK77COA2 VARCHAR(11), ANK77COA3 VARCHAR(11), ANK77COA4 VARCHAR(11), ANK77COA5 VARCHAR(11), ANK77COA6 VARCHAR(11), ANK77COA7 VARCHAR(11), ANK77COA8 VARCHAR(11), ANK77COA9 VARCHAR(11), ANK77COA10 VARCHAR(11), ANK77COA11 VARCHAR(11), ANK77COA12 VARCHAR(11), ANK77COA13 VARCHAR(11), ANK77COA14 VARCHAR(11), ANK77COA15 VARCHAR(11) NOT NULL, ANK77COA16 VARCHAR(11), ANK77COA17 VARCHAR(11), ANK77COA18 VARCHAR(11), ANK77COA19 VARCHAR(11), ANK77COA20 VARCHAR(11), ANK77COA66 VARCHAR(11), TOTALANKRECORDSMATCHED VARCHAR(11), RECORDTYPE VARCHAR(1), CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, LISTPK BIGINT NOT NULL, LACSSOFTWARENAME VARCHAR(30), LACSSOFTWAREVERSION VARCHAR(12), LACSDATARELEASEDATE DATE, COAPAFPK BIGINT NOT NULL, STOREID BIGINT, CUSTOMERID BIGINT, COAPAFSNAPSHOTPK BIGINT NOT NULL, COAFOOTNOTE21 VARCHAR(11), COAFOOTNOTE22 VARCHAR(11), COAFOOTNOTE23 VARCHAR(11), COAFOOTNOTE24 VARCHAR(11), COAFOOTNOTE25 VARCHAR(11), COAFOOTNOTE26 VARCHAR(11), COAFOOTNOTE27 VARCHAR(11), COAFOOTNOTE28 VARCHAR(11), COAFOOTNOTE29 VARCHAR(11), COAFOOTNOTE30 VARCHAR(11), ANK77COA21 VARCHAR(11), ANK77COA22 VARCHAR(11), ANK77COA23 VARCHAR(11), ANK77COA24 VARCHAR(11), ANK77COA25 VARCHAR(11), ANK77COA26 VARCHAR(11), ANK77COA27 VARCHAR(11), ANK77COA28 VARCHAR(11), ANK77COA29 VARCHAR(11), ANK77COA30 VARCHAR(11), LACSFOOTNOTE09 VARCHAR(11), COAPRODUCTVERSION VARCHAR(1), COAHIGHMATCHRATEDESC VARCHAR(11), SUITESOFTWARENAME VARCHAR(30), SUITESOFTWAREVERSION VARCHAR(12), SUITEDATARELEASEDATE DATE, SUITEFOOTNOTEA VARCHAR(11), SUITEFOOTNOTE00 VARCHAR(11)); ALTER TABLE DS3.COACSLDETAIL ADD CONSTRAINT COACSLDEATAIL_PK PRIMARY KEY (COACSLDETAILPK); CREATE TABLE DS3.COAPAF (COAPAFPK BIGINT NOT NULL, CUSTOMERPK BIGINT NOT NULL, DATESIGNEDCUSTOMER TIMESTAMP, PAFTYPE VARCHAR(1) NOT NULL, POSTALID VARCHAR(15), PARENTCOMPANY VARCHAR(50), ALTERNATECOMPANYNAME VARCHAR(50), DATESIGNEDBROKERADMIN TIMESTAMP, DATESIGNEDNCOALICENSEE TIMESTAMP, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, PAFCUSTOMERID VARCHAR(18), CUSTOMERADDRESSPK BIGINT, CUSTOMERCONTACTPK BIGINT, LISTOWNERUSERPK BIGINT NOT NULL, BROKERID BIGINT, LISTADMINISTRATORID BIGINT, BROKERAGENTYN SMALLINT, LISTADMINYN SMALLINT, BROKERADMINUSERPK BIGINT, LICENSEEUSERPK BIGINT, LISTOWNERIP VARCHAR(32), LICENSEEIP VARCHAR(32), BROKERADMINIP VARCHAR(32), LISTOWNERPRIMARYCONTACTUSERPK BIGINT); ALTER TABLE DS3.COAPAF ADD CONSTRAINT COAPAF PRIMARY KEY (COAPAFPK); CREATE TABLE DS3.COAPAFSNAPSHOT (COAPAFSNAPSHOTPK BIGINT NOT NULL, PAFCUSTOMERID VARCHAR(18), FEDERALTAXID VARCHAR(13), CUSTOMERSIC VARCHAR(6), STORESIC VARCHAR(6), COMPANYNAME VARCHAR(50), ADDRESS VARCHAR(50), CITY VARCHAR(28), STATE VARCHAR(2), ZIPCODE VARCHAR(5), PLUS4CODE VARCHAR(4), TELEPHONE VARCHAR(14), PAFSIGNEE VARCHAR(50), PAFSIGNEETITLE VARCHAR(50), BROKERAGENTID VARCHAR(16), LISTADMINID VARCHAR(16), BROKERBUSINESSNAME VARCHAR(50), BROKERADDRESS VARCHAR(50), BROKERCITYSTATEZIP VARCHAR(40), BROKERPERSONALNAME VARCHAR(50), BROKERTITLE VARCHAR(50), BROKERADMINTAXID VARCHAR(13), BROKERPHONE VARCHAR(14), BROKERAGENTYN SMALLINT, LISTADMINYN SMALLINT, PARENTCOMPANY VARCHAR(50), ALTERNATECOMPANYNAME VARCHAR(50), PAFTYPE VARCHAR(1), LISTNAME VARCHAR(30), POSTALID VARCHAR(15), DATESIGNEDCUSTOMER TIMESTAMP, DATESIGNEDBROKERADMIN TIMESTAMP, DATESIGNEDNCOALICENSEE TIMESTAMP, LICENSEEPHONENUMBER VARCHAR(14), LICENSEENAME VARCHAR(50), LICENSEETITLE VARCHAR(50), LICENSEETAXID VARCHAR(13), LICENSEEBUSINESSNAME VARCHAR(50), ACTIVE SMALLINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, COAPAFPK BIGINT NOT NULL, LISTOWNERIP VARCHAR(32), LICENSEEIP VARCHAR(32), BROKERADMINIP VARCHAR(32)); ALTER TABLE DS3.COAPAFSNAPSHOT ADD CONSTRAINT C3757201 PRIMARY KEY (COAPAFSNAPSHOTPK); CREATE TABLE DS3.MEASURE (MEASUREPK BIGINT NOT NULL, MEASUREID VARCHAR(32) NOT NULL, DESCRIPTION VARCHAR(32) NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, BASEUM BIGINT NOT NULL, RATIOTOBASE DECIMAL(20, 5) NOT NULL, MEASURETYPE BIGINT NOT NULL); ALTER TABLE DS3.MEASURE ADD CONSTRAINT C1609669 PRIMARY KEY (MEASUREPK); COMMENT ON TABLE DS3.MEASURE IS 'Units of Measure'; CREATE TABLE DS3.SERVER (SERVERPK BIGINT NOT NULL, SERVERID VARCHAR(32) NOT NULL, DESCRIPTION VARCHAR(32), CPUCAPACITY BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL, THROUGHPUTCAPACITY BIGINT, CURRENTTHROUGHPUT BIGINT, CURRENTCPU BIGINT); ALTER TABLE DS3.SERVER ADD CONSTRAINT C6868561 PRIMARY KEY (SERVERPK); CREATE TABLE DS3.JOBDISPATCHER (JOBDISPATCHERPK BIGINT NOT NULL, SERVERPK BIGINT NOT NULL, PROCESSID VARCHAR(32) NOT NULL, JOBTYPEID BIGINT NOT NULL, SIMULTANEOUSJOBS INTEGER NOT NULL, MAXWORKERS INTEGER NOT NULL, SMALLJOBMINTHREADS INTEGER NOT NULL, LARGEJOBMINTHREADS INTEGER NOT NULL, LARGEJOBTHRESHOLD BIGINT NOT NULL, CURRENTJOBS INTEGER, CURRENTWORKERS INTEGER, CURRENTLARGEJOBS INTEGER, TARGETSERVERPK1 BIGINT NOT NULL, TARGETSERVERPK2 BIGINT, TARGETSERVERPK3 BIGINT, TARGETSERVERPK4 BIGINT, TARGETSERVERPK5 BIGINT, TARGETSERVERPK6 BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL); ALTER TABLE DS3.JOBDISPATCHER ADD CONSTRAINT C8365607 PRIMARY KEY (JOBDISPATCHERPK); CREATE TABLE DS3.INTEGRATION (INTEGRATIONPK BIGINT NOT NULL, INTEGRATIONINFO BLOB(5242880), STOREPK BIGINT NOT NULL, CUSTOMERPK BIGINT, FOREIGNID VARCHAR(255) NOT NULL, INTEGRATIONTYPEPK BIGINT, CREATED TIMESTAMP NOT NULL, CREATEUSERPK BIGINT NOT NULL, MODIFIED TIMESTAMP, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL); ALTER TABLE DS3.INTEGRATION ADD CONSTRAINT C9102316 PRIMARY KEY (INTEGRATIONPK); CREATE TABLE DS3.LISTINTEGRATION (LISTPK BIGINT NOT NULL, INTEGRATIONPK BIGINT NOT NULL, CREATED TIMESTAMP NOT NULL, MODIFIED TIMESTAMP, CREATEUSERPK BIGINT NOT NULL, MODIFYUSERPK BIGINT, ACTIVE SMALLINT NOT NULL); ALTER TABLE DS3.LISTINTEGRATION ADD CONSTRAINT C3437551 PRIMARY KEY (LISTPK, INTEGRATIONPK); ALTER TABLE DS3.ACQUIRER ADD CONSTRAINT USER_ACQUIRERC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ACQUIRER ADD CONSTRAINT USER_ACQUIRERU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.AGENT ADD CONSTRAINT USER_AGENTC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.AGENT ADD CONSTRAINT USER_AGENTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CREDITAUTHREQUEST ADD CONSTRAINT BATCH_CRAQ FOREIGN KEY (BATCHPK) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.CREDITAUTHREQUEST ADD CONSTRAINT STORE_CRAQ FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CREDITAUTHRESPONSE ADD CONSTRAINT STORE_CRAS FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CREDITAUTHRESPONSE ADD CONSTRAINT CRAQ_CRAS FOREIGN KEY (CREDITAUTHREQUESTPK) REFERENCES DS3.CREDITAUTHREQUEST(CREDITAUTHREQUESTPK); ALTER TABLE DS3.BATCH ADD CONSTRAINT STATUS_BATCH FOREIGN KEY (BATCHSTATUSID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.BATCH ADD CONSTRAINT TYPE_BATCH FOREIGN KEY (BATCHTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.BATCH ADD CONSTRAINT USER_BATCHC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.BATCH ADD CONSTRAINT USER_BATCHU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.BATCH ADD CONSTRAINT USER_BATCHCL FOREIGN KEY (CLOSEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.BATCH ADD CONSTRAINT STORE_BATCH FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.BATCH ADD CONSTRAINT TERM_BATCH FOREIGN KEY (TERMINALPK) REFERENCES DS3.TERMINAL(TERMINALPK); ALTER TABLE DS3.CHECKAUTHREQUEST ADD CONSTRAINT BATCH_CKAQ FOREIGN KEY (BATCHPK) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.CHECKAUTHREQUEST ADD CONSTRAINT STORE_CKAQ FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CHECKAUTHRESPONSE ADD CONSTRAINT STORE_CKAS FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CHECKAUTHRESPONSE ADD CONSTRAINT CKAQ_CKAS FOREIGN KEY (CHECKAUTHREQUESTPK) REFERENCES DS3.CHECKAUTHREQUEST(CHECKAUTHREQUESTPK); ALTER TABLE DS3.CHECKREVERSEREQUEST ADD CONSTRAINT BATCH_CKRQ FOREIGN KEY (BATCHPK) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.CHECKREVERSEREQUEST ADD CONSTRAINT STORE_CKRQ FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CHECKREVERSEREQUEST ADD CONSTRAINT CKAQ_CKRQ FOREIGN KEY (CHECKAUTHREQUESTPK) REFERENCES DS3.CHECKAUTHREQUEST(CHECKAUTHREQUESTPK); ALTER TABLE DS3.CHECKREVERSERESPONSE ADD CONSTRAINT STORE_CKRS FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CHECKREVERSERESPONSE ADD CONSTRAINT CKRQ_CKRS FOREIGN KEY (CHECKREVERSEREQUESTPK) REFERENCES DS3.CHECKREVERSEREQUEST(CHECKREVERSEREQUESTPK); ALTER TABLE DS3.COMPANY ADD CONSTRAINT USER_COMPANY FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.COMPANY ADD CONSTRAINT USER_COMPANYU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CONTROL ADD CONSTRAINT PARENTCTRL_CTRL FOREIGN KEY (PARENTCONTROL) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CONTROL ADD CONSTRAINT STORE_CONTROL FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CONTROL ADD CONSTRAINT GLACCOUNT_CONTROL FOREIGN KEY (GLACCOUNTPK) REFERENCES DS3.GLACCOUNT(GLACCOUNTPK); ALTER TABLE DS3.CONTROL ADD CONSTRAINT GLSUBAC_CONTROL FOREIGN KEY (GLSUBACCOUNTPK) REFERENCES DS3.GLSUBACCOUNT(GLSUBACCOUNTPK); ALTER TABLE DS3.CONTROL ADD CONSTRAINT USER_CONTROL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CONTROL ADD CONSTRAINT USER_CONTROLU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CONTROL ADD CONSTRAINT CONTROL_TYPE FOREIGN KEY (CONTROLTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.CONTROL ADD CONSTRAINT CONTROL_SCOPE FOREIGN KEY (SCOPETYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.CUSTADDR ADD CONSTRAINT ADDRTYPE_CUSTADDR FOREIGN KEY (ADDRESSTYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTADDR ADD CONSTRAINT CUSTOMER_CUSTADDR FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTADDR ADD CONSTRAINT USER_CUSTADDR FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTADDR ADD CONSTRAINT USER_CUSTADDRU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTBAL ADD CONSTRAINT BALTYPE_CUSTBAL FOREIGN KEY (BALANCETYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.CUSTBAL ADD CONSTRAINT CUSTOMER_CUSTBAL FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.CUSTBAL ADD CONSTRAINT CREATEUSER_CUSTBAL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CUSTBAL ADD CONSTRAINT MODIFYUSER_CUSTBAL FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CUSTCONTACT ADD CONSTRAINT CNTCTTYP_CUSTCNTCT FOREIGN KEY (CONTACTTYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTCONTACT ADD CONSTRAINT CUST_CUSTCONTACT FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTCONTACT ADD CONSTRAINT USER_CUSTCONTACTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTCONTACT ADD CONSTRAINT USER_CUSTCONTACT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTNOTE ADD CONSTRAINT CUSTOMER_CUSTNOTE FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTNOTE ADD CONSTRAINT USER_CUSTNOTE FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTNOTE ADD CONSTRAINT USER_CUSTNOTEU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CUSTOMER ADD CONSTRAINT STORE_CUSTOMER FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTOMER ADD CONSTRAINT USER_CUSTOMER FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTOMER ADD CONSTRAINT USER_CUSTOMERU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.CUSTOMER ADD CONSTRAINT USER_CUSTOMERS FOREIGN KEY (SALESREPPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CUSTOMER ADD CONSTRAINT CTRL_CUSTSTATUS FOREIGN KEY (CUSTOMERSTATUSID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.CUSTOMER ADD CONSTRAINT CTRL_CUSTREF FOREIGN KEY (CUSTOMERREFERREDBYID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.DEBITAUTHREQUEST ADD CONSTRAINT STORE_DBAQ FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.DEBITAUTHREQUEST ADD CONSTRAINT BATCH_DBAQ FOREIGN KEY (BATCHPK) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.DEBITAUTHRESPONSE ADD CONSTRAINT STORE_DBAS FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.DEBITAUTHRESPONSE ADD CONSTRAINT DBAQ_DBAS FOREIGN KEY (DEBITAUTHREQUESTPK) REFERENCES DS3.DEBITAUTHREQUEST(DEBITAUTHREQUESTPK); ALTER TABLE DS3.DOCUMENTMASTER ADD CONSTRAINT CONTROL_DOCTYPE FOREIGN KEY (DOCUMENTTYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.DOCUMENTMASTER ADD CONSTRAINT DOC_DOCMAST FOREIGN KEY (DOCUMENTID) REFERENCES DS3.DOCUMENT(DOCUMENTID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.DOCUMENTMASTER ADD CONSTRAINT USER_DOCMAST FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.DOCUMENTMASTER ADD CONSTRAINT USER_DOCMASTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.DOCUMENTMASTER ADD CONSTRAINT USER_DOCMASTR FOREIGN KEY (REVIEWUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.DOCUMENTMASTER ADD CONSTRAINT SCOPETYPE_DOCMAST FOREIGN KEY (SCOPETYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.EQUIPMENT ADD CONSTRAINT CUSTADDR_EQUIPMENT FOREIGN KEY (CUSTADDRID) REFERENCES DS3.CUSTADDR(CUSTADDRPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.EQUIPMENT ADD CONSTRAINT STORE_EQUIPMENT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.EQUIPMENT ADD CONSTRAINT USER_EQUIPMENT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.EQUIPMENT ADD CONSTRAINT USER_EQUIPMENTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.FPFINANCESUMMARY ADD CONSTRAINT LENDER_FPFINSUM FOREIGN KEY (LENDER) REFERENCES DS3.LENDER(LENDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.FPFINANCESUMMARY ADD CONSTRAINT STORE_FPFINSUM FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.FPFINANCESUMMARY ADD CONSTRAINT USER_FPFS FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.FPFINANCESUMMARY ADD CONSTRAINT USER_FPFSU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLACCOUNT ADD CONSTRAINT USER_GLACCOUNT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.GLACCOUNT ADD CONSTRAINT USER_GLACCOUNTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.GLACCOUNT ADD CONSTRAINT STORE_GLACCOUNT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.GLBAL ADD CONSTRAINT CREATEUSER_GLBAL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.GLBAL ADD CONSTRAINT MODIFYUSER_GLBAL FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.GLBAL ADD CONSTRAINT GLACCOUNT_GLBAL FOREIGN KEY (GLACCOUNTPK) REFERENCES DS3.GLACCOUNT(GLACCOUNTPK); ALTER TABLE DS3.GLBAL ADD CONSTRAINT GLSUBAC_GLBAL FOREIGN KEY (GLSUBACCOUNTPK) REFERENCES DS3.GLSUBACCOUNT(GLSUBACCOUNTPK); ALTER TABLE DS3.GLBAL ADD CONSTRAINT STORE_GLBAL FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.GLBAL ADD CONSTRAINT MSR_GLBAL FOREIGN KEY (UM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT SUBSYSTEM_GLINT FOREIGN KEY (SUBSYSTEMID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT GLACCOUNT_GLINT FOREIGN KEY (GLACCOUNTPK) REFERENCES DS3.GLACCOUNT(GLACCOUNTPK); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT GLSUBAC_GLINT FOREIGN KEY (GLSUBACCOUNTPK) REFERENCES DS3.GLSUBACCOUNT(GLSUBACCOUNTPK); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT STORE_GLINT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT ACCOUNTTYPE_GLINT FOREIGN KEY (ACCOUNTTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT USER_GLINT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLINTEGRATION ADD CONSTRAINT USER_GLINTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLSUBACCOUNT ADD CONSTRAINT STORE_GLSUB FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.GLSUBACCOUNT ADD CONSTRAINT USER_GLSUB FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLSUBACCOUNT ADD CONSTRAINT USER_GLSUBU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT SUBSYSTEM_GLTRAN FOREIGN KEY (SUBSYSTEMID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT STORE_GLTRAN FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT USER_GLTRAN FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT USER_GLTRANU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT JOURNAL_GLTRAN FOREIGN KEY (JOURNALID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT GLTRANTYPE_GLTRAN FOREIGN KEY (GLTRANTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.GLTRAN ADD CONSTRAINT GLTRAN_APLGLTRAN FOREIGN KEY (APPLTOGLTRANID) REFERENCES DS3.GLTRAN(GLTRANID) ON DELETE CASCADE; ALTER TABLE DS3.GLTRAN ADD CONSTRAINT BATCH_GLTRAN FOREIGN KEY (BATCHID) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT GLTRAN_GLTRANDTL FOREIGN KEY (GLTRANID) REFERENCES DS3.GLTRAN(GLTRANID) ON DELETE CASCADE; ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT GLACCT_GLTRANDTL FOREIGN KEY (GLACCOUNTPK) REFERENCES DS3.GLACCOUNT(GLACCOUNTPK); ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT GLSACCT_GLTRANDTL FOREIGN KEY (GLSUBACCOUNTPK) REFERENCES DS3.GLSUBACCOUNT(GLSUBACCOUNTPK); ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT CUSER_GLTRANDTL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT UPUSER_GLTRANDTL FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT STORE_GLTRANDTL FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.GLTRANDETAIL ADD CONSTRAINT MSR_GLTRANDTL FOREIGN KEY (UM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ITEM ADD CONSTRAINT STORE_ITEM FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.ITEM ADD CONSTRAINT USER_ITEM FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ITEM ADD CONSTRAINT USER_ITEMU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ITEM ADD CONSTRAINT COSTMETHOD_ITEM FOREIGN KEY (COSTINGMETHODID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEM ADD CONSTRAINT MSR_ITMPUR FOREIGN KEY (PURCHASINGUM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ITEM ADD CONSTRAINT MSR_ITMSEL FOREIGN KEY (SELLINGUM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ITEM ADD CONSTRAINT MSR_ITMSTK FOREIGN KEY (STOCKINGUM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT STORE_ITEMLAYER FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT ITEM_ITEMLAYER FOREIGN KEY (ITEMID) REFERENCES DS3.ITEM(ITEMID); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT LOCATION_ITEMLAYER FOREIGN KEY (LOCATIONID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT BIN_ITEMLAYER FOREIGN KEY (BINID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT USER_ITEMLAYER FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT USER_ITEMLAYERU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ITEMLAYER ADD CONSTRAINT MSR_ITEMLAYER FOREIGN KEY (UM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT ITEMLAYER_ITEMTRAN FOREIGN KEY (ITEMLAYERID) REFERENCES DS3.ITEMLAYER(ITEMLAYERID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT STORE_ITEMTRAN FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT ITEM_ITEMTRAN FOREIGN KEY (ITEMID) REFERENCES DS3.ITEM(ITEMID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT LOCATION_ITEMTRAN FOREIGN KEY (LOCATIONID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT BIN_ITEMTRAN FOREIGN KEY (BINID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT SUBSYSTEM_ITEMTRAN FOREIGN KEY (SUBSYSTEMID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT USER_ITEMTRAN FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT USER_ITEMTRANU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT CONTROL_STATUS FOREIGN KEY (STATUS) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT CONTROL_TRANTYPE FOREIGN KEY (TRANSACTIONTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ITEMTRAN ADD CONSTRAINT MSR_ITEMTRAN FOREIGN KEY (UM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.LENDER ADD CONSTRAINT USER_LENDER FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.LENDER ADD CONSTRAINT USER_LENDERU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT ACQUIRER_MERCHANT FOREIGN KEY (ACQUIRERBINID) REFERENCES DS3.ACQUIRER(ACQUIRERBINID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT AGENT_MERCHANT FOREIGN KEY (AGENTPK) REFERENCES DS3.AGENT(AGENTPK); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT COMPANY_MERCHANT FOREIGN KEY (COMPANYPK) REFERENCES DS3.COMPANY(COMPANYID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT CTRL_MERCH_CATCO FOREIGN KEY (CATEGORYCODEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT CTRL_MERCH_INDCO FOREIGN KEY (INDUSTRYCODEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT CTRL_MERCH_COUNCO FOREIGN KEY (COUNTRYCODEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT CTRL_MERCH_LANGCO FOREIGN KEY (LANGUAGECODEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT CTRL_MERCH_TIMZO FOREIGN KEY (TIMEZONEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT CTRL_MERCH_CURRCO FOREIGN KEY (CURRENCYCODEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT CTRL_MERCH_RECINS FOREIGN KEY (RECIEVING_INSTPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT USER_MERCHC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.MERCHANT ADD CONSTRAINT USER_MERCHU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.LISTDETAIL ADD CONSTRAINT USER_LDTLC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.LISTDETAIL ADD CONSTRAINT USER_LDTLU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.LISTDETAIL ADD CONSTRAINT L_LDTL FOREIGN KEY (LISTPK) REFERENCES DS3.LIST(LISTPK); ALTER TABLE DS3.LISTDETAIL ADD CONSTRAINT CONTROL_RATECLASS FOREIGN KEY (RATECLASSID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.LISTDETAIL ADD CONSTRAINT MSR_LISTDTL FOREIGN KEY (WEIGHTUM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.LIST ADD CONSTRAINT USER_LISTC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.LIST ADD CONSTRAINT USER_LISTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.LIST ADD CONSTRAINT CUSTOMER_LIST FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.LIST ADD CONSTRAINT STORE_LIST FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.LIST ADD CONSTRAINT CUSTADDR_LIST FOREIGN KEY (CUSTADDRPK) REFERENCES DS3.CUSTADDR(CUSTADDRPK); ALTER TABLE DS3.LIST ADD CONSTRAINT DCMSTR_LISTDEF FOREIGN KEY (JOBDEFID) REFERENCES DS3.DOCUMENTMASTER(DOCUMENTMASTERID); ALTER TABLE DS3.LIST ADD CONSTRAINT COAPAF_LIST FOREIGN KEY (PAFPK) REFERENCES DS3.COAPAF(COAPAFPK); ALTER TABLE DS3.STORE ADD CONSTRAINT COMPANY_STORE FOREIGN KEY (COMPANYID) REFERENCES DS3.COMPANY(COMPANYID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORE ADD CONSTRAINT USER_STOREU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORE ADD CONSTRAINT USER_STORE FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORE ADD CONSTRAINT MERCHANT_STORE FOREIGN KEY (MERCHANTID) REFERENCES DS3.MERCHANT(MERCHANTID); ALTER TABLE DS3.STOREACCESS ADD CONSTRAINT CONTROL_STOREACC FOREIGN KEY (ACCESSTYPE) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STOREACCESS ADD CONSTRAINT STORE_STOREACC FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STOREACCESS ADD CONSTRAINT STORE_STOREACC2 FOREIGN KEY (STORETRUSTEEID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STOREACCESS ADD CONSTRAINT USER_STOREACCESS FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.STOREACCESS ADD CONSTRAINT USER_STOREACCESSU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.STOREBAL ADD CONSTRAINT BALTYPE_STOREBAL FOREIGN KEY (BALANCETYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STOREBAL ADD CONSTRAINT STORE_STOREBAL FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STOREBAL ADD CONSTRAINT USER_STOREBALU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STOREBAL ADD CONSTRAINT USER_STOREBAL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORECONTACT ADD CONSTRAINT CONTROL_STORECNTCT FOREIGN KEY (CONTACTTYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORECONTACT ADD CONSTRAINT STORE_STORECONTACT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORECONTACT ADD CONSTRAINT USER_STORECONTACT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORECONTACT ADD CONSTRAINT USER_STORECONTACTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STORENOTE ADD CONSTRAINT STORE_STORENOTE FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.STORENOTE ADD CONSTRAINT USER_STORENOTE FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.STORENOTE ADD CONSTRAINT USER_STORENOTEU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.MODEL ADD CONSTRAINT MAKE_MODEL FOREIGN KEY (MAKEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MODEL ADD CONSTRAINT STYLE_MODEL FOREIGN KEY (STYLEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MODEL ADD CONSTRAINT TYPE_MODEL FOREIGN KEY (TYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MODEL ADD CONSTRAINT ENGINESIZE_MODEL FOREIGN KEY (ENGINESIZE) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.MODEL ADD CONSTRAINT STORE_MODEL FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.MODEL ADD CONSTRAINT USER_MODEL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.MODEL ADD CONSTRAINT USER_MODELU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.MODEL ADD CONSTRAINT MSR_MODEL FOREIGN KEY (GROSSWEIGHTUM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ORDER ADD CONSTRAINT CUSTOMER_ORDER FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.ORDER ADD CONSTRAINT STORE_ORDER FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.ORDER ADD CONSTRAINT CUSTADDR_ORDER FOREIGN KEY (CUSTADDRID) REFERENCES DS3.CUSTADDR(CUSTADDRPK); ALTER TABLE DS3.ORDER ADD CONSTRAINT ORDERSTATUS_ORDER FOREIGN KEY (ORDERSTATUSID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ORDER ADD CONSTRAINT ORDERTYPE_ORDER FOREIGN KEY (ORDERTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.ORDER ADD CONSTRAINT USER_ORDER FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ORDER ADD CONSTRAINT USER_ORDERU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ORDER ADD CONSTRAINT BATCH_ORDER FOREIGN KEY (BATCHID) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.ORDERITEM ADD CONSTRAINT ORDER_ORDERITEM FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERITEM ADD CONSTRAINT USER_ORDERITEMU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERITEM ADD CONSTRAINT USER_ORDERITEM FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERITEM ADD CONSTRAINT ITEM_ORDERITEM FOREIGN KEY (ITEMID) REFERENCES DS3.ITEM(ITEMID); ALTER TABLE DS3.ORDERITEM ADD CONSTRAINT MSR_ORDERITEM FOREIGN KEY (UM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT PMTTYPE_ORDERPMT FOREIGN KEY (PAYMENTTYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT CUSTBAL_ORDERPMT FOREIGN KEY (CUSTBALANCEID) REFERENCES DS3.CUSTBAL(CUSTBALPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT LENDER_ORDERPMT FOREIGN KEY (LENDERID) REFERENCES DS3.LENDER(LENDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT STOREBAL_ORDERPMT FOREIGN KEY (STOREBALANCEID) REFERENCES DS3.STOREBAL(STOREBALPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT ORDER_ORDERPMT FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT USER_ORDERPAYMENT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERPAYMENT ADD CONSTRAINT USER_ORDERPAYMENTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERSERVICE ADD CONSTRAINT EQUIP_ORDERSVC FOREIGN KEY (EQUIPMENTID) REFERENCES DS3.EQUIPMENT(EQUIPMENTID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERSERVICE ADD CONSTRAINT ORDER_ORDERSVC FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERSERVICE ADD CONSTRAINT SERVICEITEM_ORDSVC FOREIGN KEY (SERVICEITEMID) REFERENCES DS3.SERVICEITEM(SERVICEITEMID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERSERVICE ADD CONSTRAINT SERVPROV_ORDSRV FOREIGN KEY (SERVICEPROVIDERID) REFERENCES DS3.SERVICEPROVIDER(SERVICEPROVIDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERSERVICE ADD CONSTRAINT USER_ORDERDETAIL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERSERVICE ADD CONSTRAINT USER_ORDERDETAILU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTAX ADD CONSTRAINT ORDER_ORDERTAX FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTAX ADD CONSTRAINT USER_ORDERTAX FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ORDERTAX ADD CONSTRAINT USER_ORDERTAXU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ORDERTAXDETAIL ADD CONSTRAINT ORDER_ORDTAXDTL FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID); ALTER TABLE DS3.ORDERTAXDETAIL ADD CONSTRAINT USER_ORDTXDTL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ORDERTAXDETAIL ADD CONSTRAINT USER_ORDTXDTLU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT LOC_ORDTRADEIN FOREIGN KEY (LOCATIONID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT LENDER_ORDTRADEIN FOREIGN KEY (LENDERID) REFERENCES DS3.LENDER(LENDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT ORDER_ORDERTRADEIN FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT UNIT_ORDTRDIN FOREIGN KEY (UNITID) REFERENCES DS3.UNIT(UNITID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT USER_ORDERTRADEIN FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT USER_ORDERTRADEINU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT MODEL_ORDTRDIN FOREIGN KEY (MODELPK) REFERENCES DS3.MODEL(MODELPK); ALTER TABLE DS3.ORDERTRADEIN ADD CONSTRAINT MSR_ORDTRDIN FOREIGN KEY (GROSSUNITWEIGHTUM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.ORDERTRADEINACCY ADD CONSTRAINT ORDTRDIN_ORDTRDNAC FOREIGN KEY (ORDERTRADEINID) REFERENCES DS3.ORDERTRADEIN(ORDERTRADEINID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEINACCY ADD CONSTRAINT USER_ORTTRDINACCY FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERTRADEINACCY ADD CONSTRAINT USER_ORDTRDINACCYU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT ORDER_ORDERUNIT FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT UNIT_ORDERUNIT FOREIGN KEY (UNITID) REFERENCES DS3.UNIT(UNITID); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT CUST1_ORDERUNIT FOREIGN KEY (CUSTOMERID1) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT CUST2_ORDERUNIT FOREIGN KEY (CUSTOMERID2) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT CUSTADR1_ORDUNIT FOREIGN KEY (CUSTADDRID1) REFERENCES DS3.CUSTADDR(CUSTADDRPK); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT CUSTADR2_ORDUNIT FOREIGN KEY (CUSTADDRID2) REFERENCES DS3.CUSTADDR(CUSTADDRPK); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT USER_ORDERUNIT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.ORDERUNIT ADD CONSTRAINT USER_ORDERUNITU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.PAYMENT ADD CONSTRAINT PMTTYPE_PAYMENT FOREIGN KEY (PAYMENTTYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.PAYMENT ADD CONSTRAINT CUSTBAL_PAYMENT FOREIGN KEY (CUSTBALANCEID) REFERENCES DS3.CUSTBAL(CUSTBALPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.PAYMENT ADD CONSTRAINT CUSTOMER_PAYMENT FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.PAYMENT ADD CONSTRAINT STORE_PAYMENT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.PAYMENT ADD CONSTRAINT STOREBAL_PAYMENT FOREIGN KEY (STOREBALANCEID) REFERENCES DS3.STOREBAL(STOREBALPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.PAYMENT ADD CONSTRAINT USER_PAYMENTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.PAYMENT ADD CONSTRAINT USER_PAYMENT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.PAYMENT ADD CONSTRAINT BATCH_PMT FOREIGN KEY (BATCHID) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.REMINDER ADD CONSTRAINT RMDRTYPE_RMDR FOREIGN KEY (REMINDERTYPE) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.REMINDER ADD CONSTRAINT STORE_REMINDER FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.REMINDER ADD CONSTRAINT PRIORITY_REMINDER FOREIGN KEY (PRIORITY) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.REMINDER ADD CONSTRAINT USER_REMINDER FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.REMINDER ADD CONSTRAINT USER_REMINDERU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.REMINDER ADD CONSTRAINT USER_REMINDERA FOREIGN KEY (ASSIGNUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.REMINDER ADD CONSTRAINT USER_REMINDERC FOREIGN KEY (COMPLETIONUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.REMINDER ADD CONSTRAINT USER_REMINDERR FOREIGN KEY (REVIEWUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.SERVICE ADD CONSTRAINT CUSTADDR_SERVICE FOREIGN KEY (CUSTADDRID) REFERENCES DS3.CUSTADDR(CUSTADDRPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT EQUIPMENT_SERVICE FOREIGN KEY (EQUIPMENTID) REFERENCES DS3.EQUIPMENT(EQUIPMENTID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT STORE_SERVICE FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT ORDER_SVC FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT ORDERSERVICE_SVC FOREIGN KEY (ORDERSERVICEID) REFERENCES DS3.ORDERSERVICE(ORDERSERVICEID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT SERVICEITEM_SVC FOREIGN KEY (SERVICEITEMID) REFERENCES DS3.SERVICEITEM(SERVICEITEMID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT SERVPROV_SERVICE FOREIGN KEY (SERVICEPROVIDERID) REFERENCES DS3.SERVICEPROVIDER(SERVICEPROVIDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT USER_SERVICEU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICE ADD CONSTRAINT USER_SERVICE FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICEITEM ADD CONSTRAINT USER_SERVICEITEMU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICEITEM ADD CONSTRAINT USER_SERVICEITEM FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICEITEM ADD CONSTRAINT STORE_SERVITEM FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.SERVICEITEM ADD CONSTRAINT MSR_SRVITM FOREIGN KEY (UM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.SERVICEPROVIDER ADD CONSTRAINT USER_SERVPROV FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SERVICEPROVIDER ADD CONSTRAINT USER_SERVPROVU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENT ADD CONSTRAINT CUSTOMER_STATEMENT FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.STATEMENT ADD CONSTRAINT STORE_STATEMENT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.STATEMENT ADD CONSTRAINT USER_STATEMENT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.STATEMENT ADD CONSTRAINT USER_STATEMENTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.STATEMENT ADD CONSTRAINT BATCH_STMT FOREIGN KEY (BATCHID) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT STMTDTLTP_STMTDTL FOREIGN KEY (STATEMENTDETAILTYPE) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT ORDER_STMTDETAIL FOREIGN KEY (ORDERID) REFERENCES DS3.ORDER(ORDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT ORDSVC_STMTDETAIL FOREIGN KEY (ORDERSERVICEID) REFERENCES DS3.ORDERSERVICE(ORDERSERVICEID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT ORDTAX_STMTDETAIL FOREIGN KEY (ORDERTAXID) REFERENCES DS3.ORDERTAX(ORDERTAXID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT SERVPROV_STMTDTL FOREIGN KEY (SERVICEPROVIDERID) REFERENCES DS3.SERVICEPROVIDER(SERVICEPROVIDERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT STMT_STMTDTL FOREIGN KEY (STATEMENTID) REFERENCES DS3.STATEMENT(STATEMENTID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT USER_STMTDTL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.STATEMENTDETAIL ADD CONSTRAINT USER_STMTDTLU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.SUPPORT ADD CONSTRAINT CONTROL_SUPPORTTP FOREIGN KEY (SUPPORTTYPE) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.SUPPORT ADD CONSTRAINT STORE_SUPPORT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.SUPPORT ADD CONSTRAINT USER_SUPPORT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.SUPPORT ADD CONSTRAINT USER_SUPPORTU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.SUPPORT ADD CONSTRAINT USER_SUPPORTR FOREIGN KEY (REVIEWUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.SUPPORT ADD CONSTRAINT USER_SUPPORTC FOREIGN KEY (COMPLETIONUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.SUPPORT ADD CONSTRAINT USER_SUPPORTA FOREIGN KEY (ASSIGNUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT STORE_TERMINAL FOREIGN KEY (STOREPK) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT CTRL_TERM_DEVCOD FOREIGN KEY (DEVICECODEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT CTRL_TERM_CURCOD FOREIGN KEY (CURRENCYCODEPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT CTRL_TERM_REQACI FOREIGN KEY (REQUESTEDACIPK) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT USER_TERMC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT USER_TERMU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.TERMINAL ADD CONSTRAINT CURBATCH_TERM FOREIGN KEY (CURRENTBATCHPK) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT SUBSYS_TRANDETAIL FOREIGN KEY (SUBSYSTEMID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT TRNTYPE_TRNDTL FOREIGN KEY (TRANTYPEID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT CUSTBAL_TRANDETAIL FOREIGN KEY (CUSTBALANCEID) REFERENCES DS3.CUSTBAL(CUSTBALPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT CUST_TRANDETAIL FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT STORE_TRANDETAIL FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT STOREBAL_TRNDETAIL FOREIGN KEY (STOREBALANCEID) REFERENCES DS3.STOREBAL(STOREBALPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT USER_TRANDETAIL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT USER_TRANDETAILU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.TRANDETAIL ADD CONSTRAINT BATCH_TRANDETAIL FOREIGN KEY (BATCHID) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.UNIT ADD CONSTRAINT LOCATION_UNIT FOREIGN KEY (LOCATIONID) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.UNIT ADD CONSTRAINT BLDSTATUS_UNIT FOREIGN KEY (BUILDSTATUS) REFERENCES DS3.CONTROL(CONTROLID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.UNIT ADD CONSTRAINT CUST_UNIT FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.UNIT ADD CONSTRAINT STORE_UNIT FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.UNIT ADD CONSTRAINT ORDUNIT_UNIT FOREIGN KEY (ORDERUNITID) REFERENCES DS3.ORDERUNIT(ORDERUNITID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.UNIT ADD CONSTRAINT USER_UNIT FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.UNIT ADD CONSTRAINT USER_UNITU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.UNIT ADD CONSTRAINT USER_UNITR FOREIGN KEY (RESERVEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.UNIT ADD CONSTRAINT USER_UNITD FOREIGN KEY (DELIVERYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.UNIT ADD CONSTRAINT USER_UNITB FOREIGN KEY (BUILDUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.UNIT ADD CONSTRAINT STATUS_UNIT FOREIGN KEY (STATUS) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.UNIT ADD CONSTRAINT MODEL_UNIT FOREIGN KEY (MODELPK) REFERENCES DS3.MODEL(MODELPK); ALTER TABLE DS3.UNIT ADD CONSTRAINT MSR_UNIT FOREIGN KEY (GROSSUNITWEIGHTUM) REFERENCES DS3.MEASURE(MEASUREPK); ALTER TABLE DS3.USER ADD CONSTRAINT STORE_USER FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.USER ADD CONSTRAINT COMPANY_USER FOREIGN KEY (COMPANYID) REFERENCES DS3.COMPANY(COMPANYID); ALTER TABLE DS3.USER ADD CONSTRAINT USERTYPE_USER FOREIGN KEY (USERTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.USER ADD CONSTRAINT ORDER_USER FOREIGN KEY (LASTORDER) REFERENCES DS3.ORDER(ORDERID); ALTER TABLE DS3.USER ADD CONSTRAINT USER_USER FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.USER ADD CONSTRAINT USER_USERU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.USER ADD CONSTRAINT TERMINAL_USER FOREIGN KEY (TERMINALPK) REFERENCES DS3.TERMINAL(TERMINALPK); ALTER TABLE DS3.USER ADD CONSTRAINT CUSTOMER_USER FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.USER ADD CONSTRAINT LPMTBATCH_USER FOREIGN KEY (LASTPAYMENTBATCH) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.USER ADD CONSTRAINT LORDBATCH_USER FOREIGN KEY (LASTORDERBATCH) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.USERACCESS ADD CONSTRAINT STORE_USERACCESS FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.USERACCESS ADD CONSTRAINT USER_USERACCESS FOREIGN KEY (USERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.USERACCESS ADD CONSTRAINT COMPANY_USERACCESS FOREIGN KEY (COMPANYID) REFERENCES DS3.COMPANY(COMPANYID); ALTER TABLE DS3.USERACCESS ADD CONSTRAINT USER_USERACCESSC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.USERACCESS ADD CONSTRAINT USER_USERACCESSU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CREDITREVERSEREQUEST ADD CONSTRAINT BATCH_CRRQ FOREIGN KEY (BATCHPK) REFERENCES DS3.BATCH(BATCHID); ALTER TABLE DS3.CREDITREVERSEREQUEST ADD CONSTRAINT STORE_CRRQ FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CREDITREVERSEREQUEST ADD CONSTRAINT CRAQ_CRRQ FOREIGN KEY (CREDITAUTHREQUESTPK) REFERENCES DS3.CREDITAUTHREQUEST(CREDITAUTHREQUESTPK); ALTER TABLE DS3.CREDITREVERSERESPONSE ADD CONSTRAINT STORE_CRRS FOREIGN KEY (CREDITREVERSEREQUESTPK) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.CREDITREVERSERESPONSE ADD CONSTRAINT CRRQ_CRRS FOREIGN KEY (CREDITREVERSEREQUESTPK) REFERENCES DS3.CREDITREVERSEREQUEST(CREDITREVERSEREQUESTPK); ALTER TABLE DS3.CUSTACCESS ADD CONSTRAINT CUST_CUSTACCESS FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.CUSTACCESS ADD CONSTRAINT USER_CUSTACCESS FOREIGN KEY (USERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CUSTACCESS ADD CONSTRAINT ACCTYPE_CUSTACC FOREIGN KEY (ACCESSTYPE) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.CUSTACCESS ADD CONSTRAINT USER_CUSTACCESSC FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CUSTACCESS ADD CONSTRAINT USER_CUSTACCESSU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK); ALTER TABLE DS3.CUSTACCESS ADD CONSTRAINT STORE_CUSTACCESS FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT CONTROL_JOBTYPE FOREIGN KEY (JOBTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT CONTROL_STATUS FOREIGN KEY (STATUSID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT CONTROL_DAYOFWEEK FOREIGN KEY (DAYOFWEEKID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT CNTRL_INTERVALTYP FOREIGN KEY (INTERVALTYPEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT CNTRL_MNTHDAYOCCR FOREIGN KEY (MONTHDAYOCCURRENCEID) REFERENCES DS3.CONTROL(CONTROLID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT USER_JOBCONTROLU FOREIGN KEY (MODIFYUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT USER_JOBCONTROL FOREIGN KEY (CREATEUSERPK) REFERENCES DS3.USER(USERPK) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT STORE_JOBCONTROL FOREIGN KEY (STOREID) REFERENCES DS3.STORE(STOREID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT JOBCTRL_RUNAFTER FOREIGN KEY (RUNAFTER) REFERENCES DS3.JOBCONTROL(JOBCONTROLPK); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT CUSTOMER_JOBCNTR FOREIGN KEY (CUSTOMERID) REFERENCES DS3.CUSTOMER(CUSTOMERID); ALTER TABLE DS3.JOBCONTROL ADD CONSTRAINT JOBRUN_JOBCTRL FOREIG