--This document contains everything needed for the schema of a blank Open Dental database. (v7.7.1.0) SET DEFINE OFF; SET SCAN OFF; -- DROP TABLE account CASCADE CONSTRAINTS; PROMPT Creating Table account ... CREATE TABLE account ( AccountNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), AcctType NUMBER(3) DEFAULT '0' NOT NULL, BankNumber VARCHAR2(255 CHAR), Inactive NUMBER(3) DEFAULT '0' NOT NULL, AccountColor NUMBER(11) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY on table account ... ALTER TABLE account ADD CONSTRAINT PRIMARY PRIMARY KEY ( AccountNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON account TO PUBLIC; -- DROP TABLE accountingautopay CASCADE CONSTRAINTS; PROMPT Creating Table accountingautopay ... CREATE TABLE accountingautopay ( AccountingAutoPayNum NUMBER(20) NOT NULL, PayType NUMBER(20) NOT NULL, PickList VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_155 on table accountingautopay ... ALTER TABLE accountingautopay ADD CONSTRAINT PRIMARY_155 PRIMARY KEY ( AccountingAutoPayNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON accountingautopay TO PUBLIC; -- DROP TABLE adjustment CASCADE CONSTRAINTS; PROMPT Creating Table adjustment ... CREATE TABLE adjustment ( AdjNum NUMBER(20) NOT NULL, AdjDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, AdjAmt NUMBER(38,8) DEFAULT '0' NOT NULL, PatNum NUMBER(20) NOT NULL, AdjType NUMBER(20) NOT NULL, ProvNum NUMBER(20) NOT NULL, AdjNote VARCHAR2(4000 CHAR), ProcDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ProcNum NUMBER(20) NOT NULL, DateEntry DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ClinicNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_66 on table adjustment ... ALTER TABLE adjustment ADD CONSTRAINT PRIMARY_66 PRIMARY KEY ( AdjNum ) ENABLE ; PROMPT Creating Index INDEXPATNUM_182 on adjustment ... CREATE INDEX INDEXPATNUM_182 ON adjustment ( PatNum ) ; PROMPT Creating Index ClinicNum_1 on adjustment ... CREATE INDEX ClinicNum_1 ON adjustment ( ClinicNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON adjustment TO PUBLIC; -- DROP TABLE anestheticdata CASCADE CONSTRAINTS; PROMPT Creating Table anestheticdata ... CREATE TABLE anestheticdata ( AnestheticDataNum NUMBER(11) NOT NULL, AnestheticRecordNum NUMBER(11) NOT NULL, AnesthOpen CHAR(32 CHAR), AnesthClose CHAR(32 CHAR), SurgOpen CHAR(32 CHAR), SurgClose CHAR(32 CHAR), Anesthetist CHAR(32 CHAR), Surgeon CHAR(32 CHAR), Asst CHAR(32 CHAR), Circulator CHAR(32 CHAR), VSMName CHAR(20 CHAR), VSMSerNum CHAR(20 CHAR), ASA CHAR(3 CHAR), ASA_EModifier CHAR(1 CHAR), O2LMin NUMBER(1), N2OLMin NUMBER(1), RteNasCan NUMBER(1), RteNasHood NUMBER(1), RteETT NUMBER(1), MedRouteIVCath NUMBER(1), MedRouteIVButtFly NUMBER(1), MedRouteIM NUMBER(1), MedRoutePO NUMBER(1), MedRouteNasal NUMBER(1), MedRouteRectal NUMBER(1), IVSite CHAR(20 CHAR), IVGauge NUMBER(2), IVSideR NUMBER(2), IVSideL NUMBER(2), IVAtt NUMBER(1), IVF CHAR(20 CHAR), IVFVol NUMBER(38,8), MonBP NUMBER(1), MonSpO2 NUMBER(1), MonEtCO2 NUMBER(1), MonTemp NUMBER(1), MonPrecordial NUMBER(1), MonEKG NUMBER(1), Notes VARCHAR2(4000 CHAR), PatWgt NUMBER(3), WgtUnitsLbs NUMBER(1), WgtUnitsKgs NUMBER(1), PatHgt NUMBER(3), EscortName CHAR(32 CHAR), EscortCellNum CHAR(13 CHAR), EscortRel CHAR(16 CHAR), NPOTime CHAR(5 CHAR), HgtUnitsIn NUMBER(1), HgtUnitsCm NUMBER(1), Signature VARCHAR2(4000 CHAR), SigIsTopaz NUMBER(3) DEFAULT '0' ); PROMPT Creating Primary Key Constraint PRIMARY_67 on table anestheticdata ... ALTER TABLE anestheticdata ADD CONSTRAINT PRIMARY_67 PRIMARY KEY ( AnestheticDataNum ) ENABLE ; PROMPT Creating Index AnestheticRecordNum on anestheticdata ... CREATE INDEX AnestheticRecordNum ON anestheticdata ( AnestheticRecordNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anestheticdata TO PUBLIC; -- DROP TABLE anestheticrecord CASCADE CONSTRAINTS; PROMPT Creating Table anestheticrecord ... CREATE TABLE anestheticrecord ( AnestheticRecordNum NUMBER(11) NOT NULL, PatNum NUMBER(11) NOT NULL, AnestheticDate DATE NOT NULL, ProvNum NUMBER(5) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_1 on table anestheticrecord ... ALTER TABLE anestheticrecord ADD CONSTRAINT PRIMARY_1 PRIMARY KEY ( AnestheticRecordNum ) ENABLE ; PROMPT Creating Index PatNum on anestheticrecord ... CREATE INDEX PatNum ON anestheticrecord ( PatNum ) ; PROMPT Creating Index ProvNum_1 on anestheticrecord ... CREATE INDEX ProvNum_1 ON anestheticrecord ( ProvNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anestheticrecord TO PUBLIC; -- DROP TABLE anesthmedsgiven CASCADE CONSTRAINTS; PROMPT Creating Table anesthmedsgiven ... CREATE TABLE anesthmedsgiven ( AnestheticMedNum NUMBER(3) NOT NULL, AnestheticRecordNum NUMBER(11) NOT NULL, AnesthMedName CHAR(32 CHAR), QtyGiven NUMBER(38,8), QtyWasted NUMBER(38,8), DoseTimeStamp CHAR(32 CHAR), QtyOnHandOld NUMBER(38,8), AnesthMedNum NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_129 on table anesthmedsgiven ... ALTER TABLE anesthmedsgiven ADD CONSTRAINT PRIMARY_129 PRIMARY KEY ( AnestheticMedNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anesthmedsgiven TO PUBLIC; -- DROP TABLE anesthmedsintake CASCADE CONSTRAINTS; PROMPT Creating Table anesthmedsintake ... CREATE TABLE anesthmedsintake ( AnestheticMedNum NUMBER(3) NOT NULL, IntakeDate DATE NOT NULL, AnesthMedName CHAR(32 CHAR), Qty NUMBER(6) NOT NULL, SupplierIDNum CHAR(11 CHAR), InvoiceNum CHAR(20 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_68 on table anesthmedsintake ... ALTER TABLE anesthmedsintake ADD CONSTRAINT PRIMARY_68 PRIMARY KEY ( AnestheticMedNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anesthmedsintake TO PUBLIC; -- DROP TABLE anesthmedsinventory CASCADE CONSTRAINTS; PROMPT Creating Table anesthmedsinventory ... CREATE TABLE anesthmedsinventory ( AnestheticMedNum NUMBER(11) NOT NULL, AnesthMedName CHAR(30 CHAR), AnesthHowSupplied CHAR(20 CHAR), QtyOnHand NUMBER(38,8) DEFAULT '0', DEASchedule CHAR(3 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_104 on table anesthmedsinventory ... ALTER TABLE anesthmedsinventory ADD CONSTRAINT PRIMARY_104 PRIMARY KEY ( AnestheticMedNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anesthmedsinventory TO PUBLIC; -- DROP TABLE anesthmedsinventoryadj CASCADE CONSTRAINTS; PROMPT Creating Table anesthmedsinventoryadj ... CREATE TABLE anesthmedsinventoryadj ( AdjustNum NUMBER(11) NOT NULL, AnestheticMedNum NUMBER(11) NOT NULL, QtyAdj NUMBER(38,8), UserNum NUMBER(11) NOT NULL, Notes VARCHAR2(255 CHAR), TimeStamp DATE NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_130 on table anesthmedsinventoryadj ... ALTER TABLE anesthmedsinventoryadj ADD CONSTRAINT PRIMARY_130 PRIMARY KEY ( AdjustNum ) ENABLE ; PROMPT Creating Index AnestheticMedNum on anesthmedsinventoryadj ... CREATE INDEX AnestheticMedNum ON anesthmedsinventoryadj ( AnestheticMedNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anesthmedsinventoryadj TO PUBLIC; -- DROP TABLE anesthmedsuppliers CASCADE CONSTRAINTS; PROMPT Creating Table anesthmedsuppliers ... CREATE TABLE anesthmedsuppliers ( SupplierIDNum NUMBER(3) NOT NULL, SupplierName VARCHAR2(255 CHAR), Phone CHAR(13 CHAR), PhoneExt CHAR(6 CHAR), Fax CHAR(13 CHAR), Addr1 VARCHAR2(48 CHAR), Addr2 CHAR(32 CHAR), City VARCHAR2(48 CHAR), State CHAR(20 CHAR), Zip CHAR(10 CHAR), Contact CHAR(32 CHAR), WebSite VARCHAR2(48 CHAR), Notes VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_105 on table anesthmedsuppliers ... ALTER TABLE anesthmedsuppliers ADD CONSTRAINT PRIMARY_105 PRIMARY KEY ( SupplierIDNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anesthmedsuppliers TO PUBLIC; -- DROP TABLE anesthscore CASCADE CONSTRAINTS; PROMPT Creating Table anesthscore ... CREATE TABLE anesthscore ( AnesthScoreNum NUMBER(11) NOT NULL, AnestheticRecordNum NUMBER(11), QActivity NUMBER(1), QResp NUMBER(1), QCirc NUMBER(1), QConc NUMBER(1), QColor NUMBER(1), AnesthesiaScore NUMBER(2), DischAmb NUMBER(1), DischWheelChr NUMBER(1), DischAmbulance NUMBER(1), DischCondStable NUMBER(1), DischCondUnStable NUMBER(1) ); PROMPT Creating Primary Key Constraint PRIMARY_2 on table anesthscore ... ALTER TABLE anesthscore ADD CONSTRAINT PRIMARY_2 PRIMARY KEY ( AnesthScoreNum ) ENABLE ; PROMPT Creating Index AnestheticRecordNum_1 on anesthscore ... CREATE INDEX AnestheticRecordNum_1 ON anesthscore ( AnestheticRecordNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anesthscore TO PUBLIC; -- DROP TABLE anesthvsdata CASCADE CONSTRAINTS; PROMPT Creating Table anesthvsdata ... CREATE TABLE anesthvsdata ( AnesthVSDataNum NUMBER(11) NOT NULL, AnestheticRecordNum NUMBER(11) NOT NULL, PatNum NUMBER(11), VSMName CHAR(20 CHAR), VSMSerNum CHAR(32 CHAR), BPSys NUMBER(3), BPDias NUMBER(3), BPMAP NUMBER(3), HR NUMBER(3), SpO2 NUMBER(3), EtCo2 NUMBER(3), Temp NUMBER(3), VSTimeStamp CHAR(32 CHAR), MessageID VARCHAR2(50 CHAR), HL7Message CLOB ); PROMPT Creating Primary Key Constraint PRIMARY_156 on table anesthvsdata ... ALTER TABLE anesthvsdata ADD CONSTRAINT PRIMARY_156 PRIMARY KEY ( AnesthVSDataNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON anesthvsdata TO PUBLIC; -- DROP TABLE appointment CASCADE CONSTRAINTS; PROMPT Creating Table appointment ... CREATE TABLE appointment ( AptNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, AptStatus NUMBER(3) DEFAULT '0' NOT NULL, Pattern VARCHAR2(255 CHAR), Confirmed NUMBER(20) NOT NULL, TimeLocked NUMBER(1) NOT NULL, Op NUMBER(20) NOT NULL, Note VARCHAR2(4000 CHAR), ProvNum NUMBER(20) NOT NULL, ProvHyg NUMBER(20) NOT NULL, AptDateTime DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, NextAptNum NUMBER(20) NOT NULL, UnschedStatus NUMBER(20) NOT NULL, IsNewPatient NUMBER(1) DEFAULT '0' NOT NULL, ProcDescript VARCHAR2(255 CHAR), Assistant NUMBER(20) NOT NULL, ClinicNum NUMBER(20) NOT NULL, IsHygiene NUMBER(3) DEFAULT '0' NOT NULL, DateTStamp DATE DEFAULT SYSDATE, DateTimeArrived DATE NOT NULL, DateTimeSeated DATE NOT NULL, DateTimeDismissed DATE NOT NULL, InsPlan1 NUMBER(20) NOT NULL, InsPlan2 NUMBER(20) NOT NULL, DateTimeAskedToArrive DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, ProcsColored VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_106 on table appointment ... ALTER TABLE appointment ADD CONSTRAINT PRIMARY_106 PRIMARY KEY ( AptNum ) ENABLE ; PROMPT Creating Index indexPatNum_1 on appointment ... CREATE INDEX indexPatNum_1 ON appointment ( PatNum ) ; PROMPT Creating Index indexNextAptNum on appointment ... CREATE INDEX indexNextAptNum ON appointment ( NextAptNum ) ; PROMPT Creating Index indexProvNum_1 on appointment ... CREATE INDEX indexProvNum_1 ON appointment ( ProvNum ) ; PROMPT Creating Index indexProvHyg on appointment ... CREATE INDEX indexProvHyg ON appointment ( ProvHyg ) ; PROMPT Creating Index indexAptDateTime on appointment ... CREATE INDEX indexAptDateTime ON appointment ( AptDateTime ) ; PROMPT Creating Index InsPlan1 on appointment ... CREATE INDEX InsPlan1 ON appointment ( InsPlan1 ) ; PROMPT Creating Index InsPlan2 on appointment ... CREATE INDEX InsPlan2 ON appointment ( InsPlan2 ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON appointment TO PUBLIC; -- DROP TABLE appointmentrule CASCADE CONSTRAINTS; PROMPT Creating Table appointmentrule ... CREATE TABLE appointmentrule ( AppointmentRuleNum NUMBER(20) NOT NULL, RuleDesc VARCHAR2(255 CHAR), CodeStart VARCHAR2(15 CHAR), CodeEnd VARCHAR2(15 CHAR), IsEnabled NUMBER(3) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_69 on table appointmentrule ... ALTER TABLE appointmentrule ADD CONSTRAINT PRIMARY_69 PRIMARY KEY ( AppointmentRuleNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON appointmentrule TO PUBLIC; -- DROP TABLE apptfield CASCADE CONSTRAINTS; PROMPT Creating Table apptfield ... CREATE TABLE apptfield ( ApptFieldNum NUMBER(20) NOT NULL, AptNum NUMBER(20) NOT NULL, FieldName VARCHAR2(255 CHAR), FieldValue VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_22 on table apptfield ... ALTER TABLE apptfield ADD CONSTRAINT PRIMARY_22 PRIMARY KEY ( ApptFieldNum ) ENABLE ; PROMPT Creating Index AptNum_1 on apptfield ... CREATE INDEX AptNum_1 ON apptfield ( AptNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON apptfield TO PUBLIC; -- DROP TABLE apptfielddef CASCADE CONSTRAINTS; PROMPT Creating Table apptfielddef ... CREATE TABLE apptfielddef ( ApptFieldDefNum NUMBER(20) NOT NULL, FieldName VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_23 on table apptfielddef ... ALTER TABLE apptfielddef ADD CONSTRAINT PRIMARY_23 PRIMARY KEY ( ApptFieldDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON apptfielddef TO PUBLIC; -- DROP TABLE apptview CASCADE CONSTRAINTS; PROMPT Creating Table apptview ... CREATE TABLE apptview ( ApptViewNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, RowsPerIncr NUMBER(3) DEFAULT '1' NOT NULL, OnlyScheduledProvs NUMBER(3) NOT NULL, OnlySchedBeforeTime DATE NOT NULL, OnlySchedAfterTime DATE NOT NULL, StackBehavUR NUMBER(4) NOT NULL, StackBehavLR NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_157 on table apptview ... ALTER TABLE apptview ADD CONSTRAINT PRIMARY_157 PRIMARY KEY ( ApptViewNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON apptview TO PUBLIC; -- DROP TABLE apptviewitem CASCADE CONSTRAINTS; PROMPT Creating Table apptviewitem ... CREATE TABLE apptviewitem ( ApptViewItemNum NUMBER(20) NOT NULL, ApptViewNum NUMBER(20) NOT NULL, OpNum NUMBER(20) NOT NULL, ProvNum NUMBER(20) NOT NULL, ElementDesc VARCHAR2(255 CHAR), ElementOrder NUMBER(3) DEFAULT '0' NOT NULL, ElementColor NUMBER(11) DEFAULT '0' NOT NULL, ElementAlignment NUMBER(4) NOT NULL, ApptFieldDefNum NUMBER(20) NOT NULL, PatFieldDefNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_158 on table apptviewitem ... ALTER TABLE apptviewitem ADD CONSTRAINT PRIMARY_158 PRIMARY KEY ( ApptViewItemNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON apptviewitem TO PUBLIC; -- DROP TABLE autocode CASCADE CONSTRAINTS; PROMPT Creating Table autocode ... CREATE TABLE autocode ( AutoCodeNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), IsHidden NUMBER(1) DEFAULT '0' NOT NULL, LessIntrusive NUMBER(1) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_44 on table autocode ... ALTER TABLE autocode ADD CONSTRAINT PRIMARY_44 PRIMARY KEY ( AutoCodeNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON autocode TO PUBLIC; -- DROP TABLE autocodecond CASCADE CONSTRAINTS; PROMPT Creating Table autocodecond ... CREATE TABLE autocodecond ( AutoCodeCondNum NUMBER(20) NOT NULL, AutoCodeItemNum NUMBER(20) NOT NULL, Cond NUMBER(3) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_3 on table autocodecond ... ALTER TABLE autocodecond ADD CONSTRAINT PRIMARY_3 PRIMARY KEY ( AutoCodeCondNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON autocodecond TO PUBLIC; -- DROP TABLE autocodeitem CASCADE CONSTRAINTS; PROMPT Creating Table autocodeitem ... CREATE TABLE autocodeitem ( AutoCodeItemNum NUMBER(20) NOT NULL, AutoCodeNum NUMBER(20) NOT NULL, OldCode VARCHAR2(15 CHAR), CodeNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_45 on table autocodeitem ... ALTER TABLE autocodeitem ADD CONSTRAINT PRIMARY_45 PRIMARY KEY ( AutoCodeItemNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON autocodeitem TO PUBLIC; -- DROP TABLE automation CASCADE CONSTRAINTS; PROMPT Creating Table automation ... CREATE TABLE automation ( AutomationNum NUMBER(20) NOT NULL, Description VARCHAR2(4000 CHAR), Autotrigger NUMBER(4) NOT NULL, ProcCodes VARCHAR2(4000 CHAR), AutoAction NUMBER(4) NOT NULL, SheetDefNum NUMBER(20) NOT NULL, CommType NUMBER(20) NOT NULL, MessageContent VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_86 on table automation ... ALTER TABLE automation ADD CONSTRAINT PRIMARY_86 PRIMARY KEY ( AutomationNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON automation TO PUBLIC; -- DROP TABLE automationcondition CASCADE CONSTRAINTS; PROMPT Creating Table automationcondition ... CREATE TABLE automationcondition ( AutomationConditionNum NUMBER(20) NOT NULL, AutomationNum NUMBER(20) NOT NULL, CompareField NUMBER(4) NOT NULL, Comparison NUMBER(4) NOT NULL, CompareString VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_159 on table automationcondition ... ALTER TABLE automationcondition ADD CONSTRAINT PRIMARY_159 PRIMARY KEY ( AutomationConditionNum ) ENABLE ; PROMPT Creating Index AutomationNum on automationcondition ... CREATE INDEX AutomationNum ON automationcondition ( AutomationNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON automationcondition TO PUBLIC; -- DROP TABLE autonote CASCADE CONSTRAINTS; PROMPT Creating Table autonote ... CREATE TABLE autonote ( AutoNoteNum NUMBER(20) NOT NULL, AutoNoteName VARCHAR2(50 CHAR), MainText VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_131 on table autonote ... ALTER TABLE autonote ADD CONSTRAINT PRIMARY_131 PRIMARY KEY ( AutoNoteNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON autonote TO PUBLIC; -- DROP TABLE autonotecontrol CASCADE CONSTRAINTS; PROMPT Creating Table autonotecontrol ... CREATE TABLE autonotecontrol ( AutoNoteControlNum NUMBER(20) NOT NULL, Descript VARCHAR2(50 CHAR), ControlType VARCHAR2(50 CHAR), ControlLabel VARCHAR2(50 CHAR), ControlOptions VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_160 on table autonotecontrol ... ALTER TABLE autonotecontrol ADD CONSTRAINT PRIMARY_160 PRIMARY KEY ( AutoNoteControlNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON autonotecontrol TO PUBLIC; -- DROP TABLE benefit CASCADE CONSTRAINTS; PROMPT Creating Table benefit ... CREATE TABLE benefit ( BenefitNum NUMBER(20) NOT NULL, PlanNum NUMBER(20) NOT NULL, PatPlanNum NUMBER(20) NOT NULL, CovCatNum NUMBER(20) NOT NULL, BenefitType NUMBER(3) DEFAULT '0' NOT NULL, Percent NUMBER(4) NOT NULL, MonetaryAmt NUMBER(38,8) DEFAULT '0' NOT NULL, TimePeriod NUMBER(3) DEFAULT '0' NOT NULL, QuantityQualifier NUMBER(3) DEFAULT '0' NOT NULL, Quantity NUMBER(3) DEFAULT '0' NOT NULL, CodeNum NUMBER(20) NOT NULL, CoverageLevel NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_46 on table benefit ... ALTER TABLE benefit ADD CONSTRAINT PRIMARY_46 PRIMARY KEY ( BenefitNum ) ENABLE ; PROMPT Creating Index indexPlanNum_2 on benefit ... CREATE INDEX indexPlanNum_2 ON benefit ( PlanNum ) ; PROMPT Creating Index indexPatPlanNum on benefit ... CREATE INDEX indexPatPlanNum ON benefit ( PatPlanNum ) ; PROMPT Creating Index CovCatNum on benefit ... CREATE INDEX CovCatNum ON benefit ( CovCatNum ) ; PROMPT Creating Index BenefitType on benefit ... CREATE INDEX BenefitType ON benefit ( BenefitType ) ; PROMPT Creating Index Percent on benefit ... CREATE INDEX Percent ON benefit ( Percent ) ; PROMPT Creating Index MonetaryAmt on benefit ... CREATE INDEX MonetaryAmt ON benefit ( MonetaryAmt ) ; PROMPT Creating Index TimePeriod on benefit ... CREATE INDEX TimePeriod ON benefit ( TimePeriod ) ; PROMPT Creating Index QuantityQualifier on benefit ... CREATE INDEX QuantityQualifier ON benefit ( QuantityQualifier ) ; PROMPT Creating Index Quantity on benefit ... CREATE INDEX Quantity ON benefit ( Quantity ) ; PROMPT Creating Index CodeNum_1 on benefit ... CREATE INDEX CodeNum_1 ON benefit ( CodeNum ) ; PROMPT Creating Index CoverageLevel on benefit ... CREATE INDEX CoverageLevel ON benefit ( CoverageLevel ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON benefit TO PUBLIC; -- DROP TABLE canadiannetwork CASCADE CONSTRAINTS; PROMPT Creating Table canadiannetwork ... CREATE TABLE canadiannetwork ( CanadianNetworkNum NUMBER(20) NOT NULL, Abbrev VARCHAR2(20 CHAR), Descript VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_24 on table canadiannetwork ... ALTER TABLE canadiannetwork ADD CONSTRAINT PRIMARY_24 PRIMARY KEY ( CanadianNetworkNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON canadiannetwork TO PUBLIC; -- DROP TABLE carrier CASCADE CONSTRAINTS; PROMPT Creating Table carrier ... CREATE TABLE carrier ( CarrierNum NUMBER(20) NOT NULL, CarrierName VARCHAR2(255 CHAR), Address VARCHAR2(255 CHAR), Address2 VARCHAR2(255 CHAR), City VARCHAR2(255 CHAR), State VARCHAR2(255 CHAR), Zip VARCHAR2(255 CHAR), Phone VARCHAR2(255 CHAR), ElectID VARCHAR2(255 CHAR), NoSendElect NUMBER(1) DEFAULT '0' NOT NULL, IsCDA NUMBER(3) NOT NULL, CDAnetVersion VARCHAR2(100 CHAR), CanadianNetworkNum NUMBER(20) NOT NULL, IsHidden NUMBER(4) NOT NULL, CanadianEncryptionMethod NUMBER(4) NOT NULL, CanadianTransactionPrefix VARCHAR2(255 CHAR), CanadianSupportedTypes NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_47 on table carrier ... ALTER TABLE carrier ADD CONSTRAINT PRIMARY_47 PRIMARY KEY ( CarrierNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON carrier TO PUBLIC; -- DROP TABLE chartview CASCADE CONSTRAINTS; PROMPT Creating Table chartview ... CREATE TABLE chartview ( ChartViewNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), ItemOrder NUMBER(11) NOT NULL, ProcStatuses NUMBER(4) NOT NULL, ObjectTypes NUMBER(6) NOT NULL, ShowProcNotes NUMBER(4) NOT NULL, IsAudit NUMBER(4) NOT NULL, SelectedTeethOnly NUMBER(4) NOT NULL, OrionStatusFlags NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_87 on table chartview ... ALTER TABLE chartview ADD CONSTRAINT PRIMARY_87 PRIMARY KEY ( ChartViewNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON chartview TO PUBLIC; -- DROP TABLE claim CASCADE CONSTRAINTS; PROMPT Creating Table claim ... CREATE TABLE claim ( ClaimNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, DateService DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateSent DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ClaimStatus CHAR(1 CHAR), DateReceived DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, PlanNum NUMBER(20) NOT NULL, ProvTreat NUMBER(20) NOT NULL, ClaimFee NUMBER(38,8) DEFAULT '0' NOT NULL, InsPayEst NUMBER(38,8) DEFAULT '0' NOT NULL, InsPayAmt NUMBER(38,8) DEFAULT '0' NOT NULL, DedApplied NUMBER(38,8) DEFAULT '0' NOT NULL, PreAuthString VARCHAR2(40 CHAR), IsProsthesis CHAR(1 CHAR), PriorDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ReasonUnderPaid VARCHAR2(255 CHAR), ClaimNote VARCHAR2(255 CHAR), ClaimType VARCHAR2(255 CHAR), ProvBill NUMBER(20) NOT NULL, ReferringProv NUMBER(20) NOT NULL, RefNumString VARCHAR2(40 CHAR), PlaceService NUMBER(3) DEFAULT '0' NOT NULL, AccidentRelated CHAR(1 CHAR), AccidentDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, AccidentST VARCHAR2(2 CHAR), EmployRelated NUMBER(3) DEFAULT '0' NOT NULL, IsOrtho NUMBER(1) DEFAULT '0' NOT NULL, OrthoRemainM NUMBER(3) DEFAULT '0' NOT NULL, OrthoDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, PatRelat NUMBER(3) DEFAULT '0' NOT NULL, PlanNum2 NUMBER(20) NOT NULL, PatRelat2 NUMBER(3) DEFAULT '0' NOT NULL, WriteOff NUMBER(38,8) DEFAULT '0' NOT NULL, Radiographs NUMBER(3) DEFAULT '0' NOT NULL, ClinicNum NUMBER(20) NOT NULL, ClaimForm NUMBER(20) NOT NULL, EFormat NUMBER(11) NOT NULL, AttachedImages NUMBER(11) NOT NULL, AttachedModels NUMBER(11) NOT NULL, AttachedFlags VARCHAR2(255 CHAR), AttachmentID VARCHAR2(255 CHAR), CanadianMaterialsForwarded VARCHAR2(10 CHAR) NOT NULL, CanadianReferralProviderNum VARCHAR2(20 CHAR) NOT NULL, CanadianReferralReason NUMBER(4) NOT NULL, CanadianIsInitialLower VARCHAR2(5 CHAR) NOT NULL, CanadianDateInitialLower DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, CanadianMandProsthMaterial NUMBER(4) NOT NULL, CanadianIsInitialUpper VARCHAR2(5 CHAR) NOT NULL, CanadianDateInitialUpper DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, CanadianMaxProsthMaterial NUMBER(4) NOT NULL, InsSubNum NUMBER(20) NOT NULL, InsSubNum2 NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_107 on table claim ... ALTER TABLE claim ADD CONSTRAINT PRIMARY_107 PRIMARY KEY ( ClaimNum ) ENABLE ; PROMPT Creating Index indexPatNum_2 on claim ... CREATE INDEX indexPatNum_2 ON claim ( PatNum ) ; PROMPT Creating Index indexPlanNum on claim ... CREATE INDEX indexPlanNum ON claim ( PlanNum ) ; PROMPT Creating Index InsSubNum_2 on claim ... CREATE INDEX InsSubNum_2 ON claim ( InsSubNum ) ; PROMPT Creating Index InsSubNum2 on claim ... CREATE INDEX InsSubNum2 ON claim ( InsSubNum2 ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claim TO PUBLIC; -- DROP TABLE claimattach CASCADE CONSTRAINTS; PROMPT Creating Table claimattach ... CREATE TABLE claimattach ( ClaimAttachNum NUMBER(20) NOT NULL, ClaimNum NUMBER(20) NOT NULL, DisplayedFileName VARCHAR2(255 CHAR), ActualFileName VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_25 on table claimattach ... ALTER TABLE claimattach ADD CONSTRAINT PRIMARY_25 PRIMARY KEY ( ClaimAttachNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claimattach TO PUBLIC; -- DROP TABLE claimcondcodelog CASCADE CONSTRAINTS; PROMPT Creating Table claimcondcodelog ... CREATE TABLE claimcondcodelog ( ClaimCondCodeLogNum NUMBER(20) NOT NULL, ClaimNum NUMBER(20) NOT NULL, Code0 VARCHAR2(2 CHAR), Code1 VARCHAR2(2 CHAR), Code2 VARCHAR2(2 CHAR), Code3 VARCHAR2(2 CHAR), Code4 VARCHAR2(2 CHAR), Code5 VARCHAR2(2 CHAR), Code6 VARCHAR2(2 CHAR), Code7 VARCHAR2(2 CHAR), Code8 VARCHAR2(2 CHAR), Code9 VARCHAR2(2 CHAR), Code10 VARCHAR2(2 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_108 on table claimcondcodelog ... ALTER TABLE claimcondcodelog ADD CONSTRAINT PRIMARY_108 PRIMARY KEY ( ClaimCondCodeLogNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claimcondcodelog TO PUBLIC; -- DROP TABLE claimform CASCADE CONSTRAINTS; PROMPT Creating Table claimform ... CREATE TABLE claimform ( ClaimFormNum NUMBER(20) NOT NULL, Description VARCHAR2(50 CHAR), IsHidden NUMBER(1) DEFAULT '0' NOT NULL, FontName VARCHAR2(255 CHAR), FontSize NUMBER(38,8) DEFAULT '0' NOT NULL, UniqueID VARCHAR2(255 CHAR), PrintImages NUMBER(1) DEFAULT '0' NOT NULL, OffsetX NUMBER(5) DEFAULT '0' NOT NULL, OffsetY NUMBER(5) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_132 on table claimform ... ALTER TABLE claimform ADD CONSTRAINT PRIMARY_132 PRIMARY KEY ( ClaimFormNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claimform TO PUBLIC; -- DROP TABLE claimformitem CASCADE CONSTRAINTS; PROMPT Creating Table claimformitem ... CREATE TABLE claimformitem ( ClaimFormItemNum NUMBER(20) NOT NULL, ClaimFormNum NUMBER(20) NOT NULL, ImageFileName VARCHAR2(255 CHAR), FieldName VARCHAR2(255 CHAR), FormatString VARCHAR2(255 CHAR), XPos NUMBER(38,8) DEFAULT '0' NOT NULL, YPos NUMBER(38,8) DEFAULT '0' NOT NULL, Width NUMBER(38,8) DEFAULT '0' NOT NULL, Height NUMBER(38,8) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_161 on table claimformitem ... ALTER TABLE claimformitem ADD CONSTRAINT PRIMARY_161 PRIMARY KEY ( ClaimFormItemNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claimformitem TO PUBLIC; -- DROP TABLE claimpayment CASCADE CONSTRAINTS; PROMPT Creating Table claimpayment ... CREATE TABLE claimpayment ( ClaimPaymentNum NUMBER(20) NOT NULL, CheckDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, CheckAmt NUMBER(38,8) DEFAULT '0' NOT NULL, CheckNum VARCHAR2(25 CHAR), BankBranch VARCHAR2(25 CHAR), Note VARCHAR2(255 CHAR), ClinicNum NUMBER(20) NOT NULL, DepositNum NUMBER(20) NOT NULL, CarrierName VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_88 on table claimpayment ... ALTER TABLE claimpayment ADD CONSTRAINT PRIMARY_88 PRIMARY KEY ( ClaimPaymentNum ) ENABLE ; PROMPT Creating Index DepositNum on claimpayment ... CREATE INDEX DepositNum ON claimpayment ( DepositNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claimpayment TO PUBLIC; -- DROP TABLE claimproc CASCADE CONSTRAINTS; PROMPT Creating Table claimproc ... CREATE TABLE claimproc ( ClaimProcNum NUMBER(20) NOT NULL, ProcNum NUMBER(20) NOT NULL, ClaimNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ProvNum NUMBER(20) NOT NULL, FeeBilled NUMBER(38,8) DEFAULT '0' NOT NULL, InsPayEst NUMBER(38,8) DEFAULT '0' NOT NULL, DedApplied NUMBER(38,8) DEFAULT '0' NOT NULL, Status NUMBER(3) DEFAULT '0' NOT NULL, InsPayAmt NUMBER(38,8) DEFAULT '0' NOT NULL, Remarks VARCHAR2(255 CHAR), ClaimPaymentNum NUMBER(20) NOT NULL, PlanNum NUMBER(20) NOT NULL, DateCP DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, WriteOff NUMBER(38,8) DEFAULT '0' NOT NULL, CodeSent VARCHAR2(15 CHAR), AllowedOverride NUMBER(38,8) NOT NULL, Percentage NUMBER(4) DEFAULT '-1' NOT NULL, PercentOverride NUMBER(4) DEFAULT '-1' NOT NULL, CopayAmt NUMBER(38,8) DEFAULT '-1' NOT NULL, NoBillIns NUMBER(1) DEFAULT '0' NOT NULL, PaidOtherIns NUMBER(38,8) DEFAULT '-1' NOT NULL, BaseEst NUMBER(38,8) DEFAULT '0' NOT NULL, CopayOverride NUMBER(38,8) DEFAULT '-1' NOT NULL, ProcDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateEntry DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, LineNumber NUMBER(3) NOT NULL, DedEst NUMBER(38,8) NOT NULL, DedEstOverride NUMBER(38,8) NOT NULL, InsEstTotal NUMBER(38,8) NOT NULL, InsEstTotalOverride NUMBER(38,8) NOT NULL, PaidOtherInsOverride NUMBER(38,8) NOT NULL, EstimateNote VARCHAR2(255 CHAR), WriteOffEst NUMBER(38,8) NOT NULL, WriteOffEstOverride NUMBER(38,8) NOT NULL, ClinicNum NUMBER(20) NOT NULL, InsSubNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_133 on table claimproc ... ALTER TABLE claimproc ADD CONSTRAINT PRIMARY_133 PRIMARY KEY ( ClaimProcNum ) ENABLE ; PROMPT Creating Index indexPatNum_3 on claimproc ... CREATE INDEX indexPatNum_3 ON claimproc ( PatNum ) ; PROMPT Creating Index indexPlanNum_1 on claimproc ... CREATE INDEX indexPlanNum_1 ON claimproc ( PlanNum ) ; PROMPT Creating Index indexClaimNum on claimproc ... CREATE INDEX indexClaimNum ON claimproc ( ClaimNum ) ; PROMPT Creating Index indexProvNum on claimproc ... CREATE INDEX indexProvNum ON claimproc ( ProvNum ) ; PROMPT Creating Index indexProcNum on claimproc ... CREATE INDEX indexProcNum ON claimproc ( ProcNum ) ; PROMPT Creating Index indexClaimPaymentNum on claimproc ... CREATE INDEX indexClaimPaymentNum ON claimproc ( ClaimPaymentNum ) ; PROMPT Creating Index ClinicNum_3 on claimproc ... CREATE INDEX ClinicNum_3 ON claimproc ( ClinicNum ) ; PROMPT Creating Index InsSubNum_3 on claimproc ... CREATE INDEX InsSubNum_3 ON claimproc ( InsSubNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claimproc TO PUBLIC; -- DROP TABLE claimvalcodelog CASCADE CONSTRAINTS; PROMPT Creating Table claimvalcodelog ... CREATE TABLE claimvalcodelog ( ClaimValCodeLogNum NUMBER(20) NOT NULL, ClaimNum NUMBER(20) NOT NULL, ClaimField VARCHAR2(5 CHAR) NOT NULL, ValCode CHAR(2 CHAR) NOT NULL, ValAmount NUMBER(38,8) NOT NULL, Ordinal NUMBER(10) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_162 on table claimvalcodelog ... ALTER TABLE claimvalcodelog ADD CONSTRAINT PRIMARY_162 PRIMARY KEY ( ClaimValCodeLogNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON claimvalcodelog TO PUBLIC; -- DROP TABLE clearinghouse CASCADE CONSTRAINTS; PROMPT Creating Table clearinghouse ... CREATE TABLE clearinghouse ( ClearinghouseNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), ExportPath VARCHAR2(4000 CHAR), IsDefault NUMBER(1) DEFAULT '0' NOT NULL, Payors VARCHAR2(4000 CHAR), Eformat NUMBER(3) DEFAULT '0' NOT NULL, ISA05 VARCHAR2(255 CHAR), SenderTIN VARCHAR2(255 CHAR), ISA07 VARCHAR2(255 CHAR), ISA08 VARCHAR2(255 CHAR), ISA15 VARCHAR2(255 CHAR), Password VARCHAR2(255 CHAR), ResponsePath VARCHAR2(255 CHAR), CommBridge NUMBER(3) DEFAULT '0' NOT NULL, ClientProgram VARCHAR2(255 CHAR), LastBatchNumber NUMBER(5) DEFAULT '0' NOT NULL, ModemPort NUMBER(3) DEFAULT '0' NOT NULL, LoginID VARCHAR2(255 CHAR), SenderName VARCHAR2(255 CHAR), SenderTelephone VARCHAR2(255 CHAR), GS03 VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_163 on table clearinghouse ... ALTER TABLE clearinghouse ADD CONSTRAINT PRIMARY_163 PRIMARY KEY ( ClearinghouseNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON clearinghouse TO PUBLIC; -- DROP TABLE clinic CASCADE CONSTRAINTS; PROMPT Creating Table clinic ... CREATE TABLE clinic ( ClinicNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), Address VARCHAR2(255 CHAR), Address2 VARCHAR2(255 CHAR), City VARCHAR2(255 CHAR), State VARCHAR2(255 CHAR), Zip VARCHAR2(255 CHAR), Phone VARCHAR2(255 CHAR), BankNumber VARCHAR2(255 CHAR), DefaultPlaceService NUMBER(3) DEFAULT '0' NOT NULL, InsBillingProv NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_109 on table clinic ... ALTER TABLE clinic ADD CONSTRAINT PRIMARY_109 PRIMARY KEY ( ClinicNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON clinic TO PUBLIC; -- DROP TABLE clockevent CASCADE CONSTRAINTS; PROMPT Creating Table clockevent ... CREATE TABLE clockevent ( ClockEventNum NUMBER(20) NOT NULL, EmployeeNum NUMBER(20) NOT NULL, TimeEntered1 DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, TimeDisplayed1 DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, ClockStatus NUMBER(3) DEFAULT '0' NOT NULL, Note VARCHAR2(4000 CHAR), TimeEntered2 DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, TimeDisplayed2 DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, OTimeHours VARCHAR2(4000) NOT NULL, OTimeAuto VARCHAR2(4000) NOT NULL, Adjust VARCHAR2(4000) NOT NULL, AdjustAuto VARCHAR2(4000) NOT NULL, AdjustIsOverridden NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_70 on table clockevent ... ALTER TABLE clockevent ADD CONSTRAINT PRIMARY_70 PRIMARY KEY ( ClockEventNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON clockevent TO PUBLIC; -- DROP TABLE commlog CASCADE CONSTRAINTS; PROMPT Creating Table commlog ... CREATE TABLE commlog ( CommlogNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, CommDateTime DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, CommType NUMBER(20) NOT NULL, Note VARCHAR2(4000 CHAR), Mode_ NUMBER(3) DEFAULT '0' NOT NULL, SentOrReceived NUMBER(3) DEFAULT '0' NOT NULL, IsStatementSent NUMBER(1) NOT NULL, UserNum NUMBER(20) NOT NULL, Signature VARCHAR2(4000 CHAR), SigIsTopaz NUMBER(4) NOT NULL, DateTStamp DATE DEFAULT SYSDATE ); PROMPT Creating Primary Key Constraint PRIMARY_164 on table commlog ... ALTER TABLE commlog ADD CONSTRAINT PRIMARY_164 PRIMARY KEY ( CommlogNum ) ENABLE ; PROMPT Creating Index PatNum_3 on commlog ... CREATE INDEX PatNum_3 ON commlog ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON commlog TO PUBLIC; -- DROP TABLE computer CASCADE CONSTRAINTS; PROMPT Creating Table computer ... CREATE TABLE computer ( ComputerNum NUMBER(20) NOT NULL, CompName VARCHAR2(100 CHAR), LastHeartBeat DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_48 on table computer ... ALTER TABLE computer ADD CONSTRAINT PRIMARY_48 PRIMARY KEY ( ComputerNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON computer TO PUBLIC; -- DROP TABLE computerpref CASCADE CONSTRAINTS; PROMPT Creating Table computerpref ... CREATE TABLE computerpref ( ComputerPrefNum NUMBER(20) NOT NULL, ComputerName VARCHAR2(64 CHAR) NOT NULL, GraphicsUseHardware NUMBER(1) DEFAULT '0' NOT NULL, GraphicsSimple NUMBER(1) DEFAULT '0' NOT NULL, SensorType VARCHAR2(255 CHAR) DEFAULT 'D', SensorBinned NUMBER(4) NOT NULL, SensorPort NUMBER(11) DEFAULT '0', SensorExposure NUMBER(11) DEFAULT '1', GraphicsDoubleBuffering NUMBER(4) NOT NULL, PreferredPixelFormatNum NUMBER(11) DEFAULT '0', AtoZpath VARCHAR2(255 CHAR), TaskKeepListHidden NUMBER(1) NOT NULL, TaskDock NUMBER(11) DEFAULT '0' NOT NULL, TaskX NUMBER(11) DEFAULT '900' NOT NULL, TaskY NUMBER(11) DEFAULT '625' NOT NULL, DirectXFormat VARCHAR2(255 CHAR), RecentApptView NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_165 on table computerpref ... ALTER TABLE computerpref ADD CONSTRAINT PRIMARY_165 PRIMARY KEY ( ComputerPrefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON computerpref TO PUBLIC; -- DROP TABLE contact CASCADE CONSTRAINTS; PROMPT Creating Table contact ... CREATE TABLE contact ( ContactNum NUMBER(20) NOT NULL, LName VARCHAR2(255 CHAR), FName VARCHAR2(255 CHAR), WkPhone VARCHAR2(255 CHAR), Fax VARCHAR2(255 CHAR), Category NUMBER(20) NOT NULL, Notes VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_4 on table contact ... ALTER TABLE contact ADD CONSTRAINT PRIMARY_4 PRIMARY KEY ( ContactNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON contact TO PUBLIC; -- DROP TABLE county CASCADE CONSTRAINTS; PROMPT Creating Table county ... CREATE TABLE county ( CountyNum NUMBER(20) NOT NULL, CountyName VARCHAR2(255 CHAR), CountyCode VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_89 on table county ... ALTER TABLE county ADD CONSTRAINT PRIMARY_89 PRIMARY KEY ( CountyNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON county TO PUBLIC; -- DROP TABLE covcat CASCADE CONSTRAINTS; PROMPT Creating Table covcat ... CREATE TABLE covcat ( CovCatNum NUMBER(20) NOT NULL, Description VARCHAR2(50 CHAR), DefaultPercent NUMBER(6) NOT NULL, CovOrder NUMBER(3) DEFAULT '0' NOT NULL, IsHidden NUMBER(1) DEFAULT '0' NOT NULL, EbenefitCat NUMBER(3) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_26 on table covcat ... ALTER TABLE covcat ADD CONSTRAINT PRIMARY_26 PRIMARY KEY ( CovCatNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON covcat TO PUBLIC; -- DROP TABLE covspan CASCADE CONSTRAINTS; PROMPT Creating Table covspan ... CREATE TABLE covspan ( CovSpanNum NUMBER(20) NOT NULL, CovCatNum NUMBER(20) NOT NULL, FromCode VARCHAR2(15 CHAR), ToCode VARCHAR2(15 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_71 on table covspan ... ALTER TABLE covspan ADD CONSTRAINT PRIMARY_71 PRIMARY KEY ( CovSpanNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON covspan TO PUBLIC; -- DROP TABLE definition CASCADE CONSTRAINTS; PROMPT Creating Table definition ... CREATE TABLE definition ( DefNum NUMBER(20) NOT NULL, Category NUMBER(3) DEFAULT '0' NOT NULL, ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, ItemName VARCHAR2(255 CHAR), ItemValue VARCHAR2(255 CHAR), ItemColor NUMBER(11) DEFAULT '0' NOT NULL, IsHidden NUMBER(3) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_110 on table definition ... ALTER TABLE definition ADD CONSTRAINT PRIMARY_110 PRIMARY KEY ( DefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON definition TO PUBLIC; -- DROP TABLE deletedobject CASCADE CONSTRAINTS; PROMPT Creating Table deletedobject ... CREATE TABLE deletedobject ( DeletedObjectNum NUMBER(20) NOT NULL, ObjectNum NUMBER(20) NOT NULL, ObjectType NUMBER(11) NOT NULL, DateTStamp DATE DEFAULT SYSDATE ); PROMPT Creating Primary Key Constraint PRIMARY_166 on table deletedobject ... ALTER TABLE deletedobject ADD CONSTRAINT PRIMARY_166 PRIMARY KEY ( DeletedObjectNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON deletedobject TO PUBLIC; -- DROP TABLE deposit CASCADE CONSTRAINTS; PROMPT Creating Table deposit ... CREATE TABLE deposit ( DepositNum NUMBER(20) NOT NULL, DateDeposit DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, BankAccountInfo VARCHAR2(4000 CHAR), Amount NUMBER(38,8) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_90 on table deposit ... ALTER TABLE deposit ADD CONSTRAINT PRIMARY_90 PRIMARY KEY ( DepositNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON deposit TO PUBLIC; -- DROP TABLE disease CASCADE CONSTRAINTS; PROMPT Creating Table disease ... CREATE TABLE disease ( DiseaseNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, DiseaseDefNum NUMBER(20) NOT NULL, PatNote VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_134 on table disease ... ALTER TABLE disease ADD CONSTRAINT PRIMARY_134 PRIMARY KEY ( DiseaseNum ) ENABLE ; PROMPT Creating Index indexPatNum_4 on disease ... CREATE INDEX indexPatNum_4 ON disease ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON disease TO PUBLIC; -- DROP TABLE diseasedef CASCADE CONSTRAINTS; PROMPT Creating Table diseasedef ... CREATE TABLE diseasedef ( DiseaseDefNum NUMBER(20) NOT NULL, DiseaseName VARCHAR2(255 CHAR), ItemOrder NUMBER(5) NOT NULL, IsHidden NUMBER(3) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_135 on table diseasedef ... ALTER TABLE diseasedef ADD CONSTRAINT PRIMARY_135 PRIMARY KEY ( DiseaseDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON diseasedef TO PUBLIC; -- DROP TABLE displayfield CASCADE CONSTRAINTS; PROMPT Creating Table displayfield ... CREATE TABLE displayfield ( DisplayFieldNum NUMBER(20) NOT NULL, InternalName VARCHAR2(255 CHAR), ItemOrder NUMBER(11) NOT NULL, Description VARCHAR2(255 CHAR), ColumnWidth NUMBER(11) NOT NULL, Category NUMBER(11) DEFAULT '0' NOT NULL, ChartViewNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_5 on table displayfield ... ALTER TABLE displayfield ADD CONSTRAINT PRIMARY_5 PRIMARY KEY ( DisplayFieldNum ) ENABLE ; PROMPT Creating Index ChartViewNum on displayfield ... CREATE INDEX ChartViewNum ON displayfield ( ChartViewNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON displayfield TO PUBLIC; -- DROP TABLE document CASCADE CONSTRAINTS; PROMPT Creating Table document ... CREATE TABLE document ( DocNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), DateCreated DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, DocCategory NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, FileName VARCHAR2(255 CHAR), ImgType NUMBER(3) DEFAULT '0' NOT NULL, IsFlipped NUMBER(1) DEFAULT '0' NOT NULL, DegreesRotated NUMBER(6) NOT NULL, ToothNumbers VARCHAR2(255 CHAR), Note VARCHAR2(4000 CHAR), SigIsTopaz NUMBER(3) NOT NULL, Signature VARCHAR2(4000 CHAR), CropX NUMBER(11) NOT NULL, CropY NUMBER(11) NOT NULL, CropW NUMBER(11) NOT NULL, CropH NUMBER(11) NOT NULL, WindowingMin NUMBER(11) NOT NULL, WindowingMax NUMBER(11) NOT NULL, MountItemNum NUMBER(20) NOT NULL, DateTStamp DATE DEFAULT SYSDATE ); PROMPT Creating Primary Key Constraint PRIMARY_49 on table document ... ALTER TABLE document ADD CONSTRAINT PRIMARY_49 PRIMARY KEY ( DocNum ) ENABLE ; PROMPT Creating Index PatNum_4 on document ... CREATE INDEX PatNum_4 ON document ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON document TO PUBLIC; -- DROP TABLE dunning CASCADE CONSTRAINTS; PROMPT Creating Table dunning ... CREATE TABLE dunning ( DunningNum NUMBER(20) NOT NULL, DunMessage VARCHAR2(4000 CHAR), BillingType NUMBER(20) NOT NULL, AgeAccount NUMBER(3) DEFAULT '0' NOT NULL, InsIsPending NUMBER(3) DEFAULT '0' NOT NULL, MessageBold VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_167 on table dunning ... ALTER TABLE dunning ADD CONSTRAINT PRIMARY_167 PRIMARY KEY ( DunningNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON dunning TO PUBLIC; -- DROP TABLE electid CASCADE CONSTRAINTS; PROMPT Creating Table electid ... CREATE TABLE electid ( ElectIDNum NUMBER(20) NOT NULL, PayorID VARCHAR2(255 CHAR), CarrierName VARCHAR2(255 CHAR), IsMedicaid NUMBER(3) DEFAULT '0' NOT NULL, ProviderTypes VARCHAR2(255 CHAR), Comments VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_136 on table electid ... ALTER TABLE electid ADD CONSTRAINT PRIMARY_136 PRIMARY KEY ( ElectIDNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON electid TO PUBLIC; -- DROP TABLE emailattach CASCADE CONSTRAINTS; PROMPT Creating Table emailattach ... CREATE TABLE emailattach ( EmailAttachNum NUMBER(20) NOT NULL, EmailMessageNum NUMBER(20) NOT NULL, DisplayedFileName VARCHAR2(255 CHAR), ActualFileName VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_91 on table emailattach ... ALTER TABLE emailattach ADD CONSTRAINT PRIMARY_91 PRIMARY KEY ( EmailAttachNum ) ENABLE ; PROMPT Creating Index EmailMessageNum on emailattach ... CREATE INDEX EmailMessageNum ON emailattach ( EmailMessageNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON emailattach TO PUBLIC; -- DROP TABLE emailmessage CASCADE CONSTRAINTS; PROMPT Creating Table emailmessage ... CREATE TABLE emailmessage ( EmailMessageNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ToAddress VARCHAR2(4000 CHAR), FromAddress VARCHAR2(4000 CHAR), Subject VARCHAR2(4000 CHAR), BodyText VARCHAR2(4000 CHAR), MsgDateTime DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, SentOrReceived NUMBER(3) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_27 on table emailmessage ... ALTER TABLE emailmessage ADD CONSTRAINT PRIMARY_27 PRIMARY KEY ( EmailMessageNum ) ENABLE ; PROMPT Creating Index PatNum_5 on emailmessage ... CREATE INDEX PatNum_5 ON emailmessage ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON emailmessage TO PUBLIC; -- DROP TABLE emailtemplate CASCADE CONSTRAINTS; PROMPT Creating Table emailtemplate ... CREATE TABLE emailtemplate ( EmailTemplateNum NUMBER(20) NOT NULL, Subject VARCHAR2(4000 CHAR), BodyText VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_72 on table emailtemplate ... ALTER TABLE emailtemplate ADD CONSTRAINT PRIMARY_72 PRIMARY KEY ( EmailTemplateNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON emailtemplate TO PUBLIC; -- DROP TABLE employee CASCADE CONSTRAINTS; PROMPT Creating Table employee ... CREATE TABLE employee ( EmployeeNum NUMBER(20) NOT NULL, LName VARCHAR2(255 CHAR), FName VARCHAR2(255 CHAR), MiddleI VARCHAR2(255 CHAR), IsHidden NUMBER(1) DEFAULT '0' NOT NULL, ClockStatus VARCHAR2(255 CHAR), PhoneExt NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_73 on table employee ... ALTER TABLE employee ADD CONSTRAINT PRIMARY_73 PRIMARY KEY ( EmployeeNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON employee TO PUBLIC; -- DROP TABLE employer CASCADE CONSTRAINTS; PROMPT Creating Table employer ... CREATE TABLE employer ( EmployerNum NUMBER(20) NOT NULL, EmpName VARCHAR2(255 CHAR), Address VARCHAR2(255 CHAR), Address2 VARCHAR2(255 CHAR), City VARCHAR2(255 CHAR), State VARCHAR2(255 CHAR), Zip VARCHAR2(255 CHAR), Phone VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_50 on table employer ... ALTER TABLE employer ADD CONSTRAINT PRIMARY_50 PRIMARY KEY ( EmployerNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON employer TO PUBLIC; -- DROP TABLE equipment CASCADE CONSTRAINTS; PROMPT Creating Table equipment ... CREATE TABLE equipment ( EquipmentNum NUMBER(20) NOT NULL, Description VARCHAR2(4000 CHAR), SerialNumber VARCHAR2(255 CHAR), ModelYear VARCHAR2(2 CHAR), DatePurchased DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateSold DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, PurchaseCost NUMBER(38,8) NOT NULL, MarketValue NUMBER(38,8) NOT NULL, Location VARCHAR2(4000 CHAR), DateEntry DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_92 on table equipment ... ALTER TABLE equipment ADD CONSTRAINT PRIMARY_92 PRIMARY KEY ( EquipmentNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON equipment TO PUBLIC; -- DROP TABLE etrans CASCADE CONSTRAINTS; PROMPT Creating Table etrans ... CREATE TABLE etrans ( EtransNum NUMBER(20) NOT NULL, DateTimeTrans DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, ClearingHouseNum NUMBER(20) NOT NULL, Etype NUMBER(3) NOT NULL, ClaimNum NUMBER(20) NOT NULL, OfficeSequenceNumber NUMBER(11) NOT NULL, CarrierTransCounter NUMBER(11) NOT NULL, CarrierTransCounter2 NUMBER(11) NOT NULL, CarrierNum NUMBER(20) NOT NULL, CarrierNum2 NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, BatchNumber NUMBER(11) NOT NULL, AckCode VARCHAR2(255 CHAR), TransSetNum NUMBER(11) NOT NULL, Note VARCHAR2(4000 CHAR), EtransMessageTextNum NUMBER(20) NOT NULL, AckEtransNum NUMBER(20) NOT NULL, PlanNum NUMBER(20) NOT NULL, InsSubNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_111 on table etrans ... ALTER TABLE etrans ADD CONSTRAINT PRIMARY_111 PRIMARY KEY ( EtransNum ) ENABLE ; PROMPT Creating Index ClaimNum on etrans ... CREATE INDEX ClaimNum ON etrans ( ClaimNum ) ; PROMPT Creating Index CarrierNum on etrans ... CREATE INDEX CarrierNum ON etrans ( CarrierNum ) ; PROMPT Creating Index CarrierNum2 on etrans ... CREATE INDEX CarrierNum2 ON etrans ( CarrierNum2 ) ; PROMPT Creating Index PlanNum on etrans ... CREATE INDEX PlanNum ON etrans ( PlanNum ) ; PROMPT Creating Index InsSubNum on etrans ... CREATE INDEX InsSubNum ON etrans ( InsSubNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON etrans TO PUBLIC; -- DROP TABLE etransmessagetext CASCADE CONSTRAINTS; PROMPT Creating Table etransmessagetext ... CREATE TABLE etransmessagetext ( EtransMessageTextNum NUMBER(20) NOT NULL, MessageText CLOB NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_112 on table etransmessagetext ... ALTER TABLE etransmessagetext ADD CONSTRAINT PRIMARY_112 PRIMARY KEY ( EtransMessageTextNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON etransmessagetext TO PUBLIC; -- DROP TABLE fee CASCADE CONSTRAINTS; PROMPT Creating Table fee ... CREATE TABLE fee ( FeeNum NUMBER(20) NOT NULL, Amount NUMBER(38,8) DEFAULT '0' NOT NULL, OldCode VARCHAR2(15 CHAR), FeeSched NUMBER(20) NOT NULL, UseDefaultFee NUMBER(1) DEFAULT '0' NOT NULL, UseDefaultCov NUMBER(1) DEFAULT '0' NOT NULL, CodeNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_137 on table fee ... ALTER TABLE fee ADD CONSTRAINT PRIMARY_137 PRIMARY KEY ( FeeNum ) ENABLE ; PROMPT Creating Index indexADACode on fee ... CREATE INDEX indexADACode ON fee ( OldCode ) ; PROMPT Creating Index indexFeeSched on fee ... CREATE INDEX indexFeeSched ON fee ( FeeSched ) ; PROMPT Creating Index CodeNum on fee ... CREATE INDEX CodeNum ON fee ( CodeNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON fee TO PUBLIC; -- DROP TABLE feesched CASCADE CONSTRAINTS; PROMPT Creating Table feesched ... CREATE TABLE feesched ( FeeSchedNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), FeeSchedType NUMBER(11) NOT NULL, ItemOrder NUMBER(11) NOT NULL, IsHidden NUMBER(1) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_138 on table feesched ... ALTER TABLE feesched ADD CONSTRAINT PRIMARY_138 PRIMARY KEY ( FeeSchedNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON feesched TO PUBLIC; -- DROP TABLE files CASCADE CONSTRAINTS; PROMPT Creating Table files ... CREATE TABLE files ( DocNum NUMBER(20) NOT NULL, Data BLOB NOT NULL, Thumbnail BLOB ); PROMPT Creating Primary Key Constraint PRIMARY_51 on table files ... ALTER TABLE files ADD CONSTRAINT PRIMARY_51 PRIMARY KEY ( DocNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON files TO PUBLIC; -- DROP TABLE formpat CASCADE CONSTRAINTS; PROMPT Creating Table formpat ... CREATE TABLE formpat ( FormPatNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, FormDateTime DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_52 on table formpat ... ALTER TABLE formpat ADD CONSTRAINT PRIMARY_52 PRIMARY KEY ( FormPatNum ) ENABLE ; PROMPT Creating Index PatNum_7 on formpat ... CREATE INDEX PatNum_7 ON formpat ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON formpat TO PUBLIC; -- DROP TABLE grouppermission CASCADE CONSTRAINTS; PROMPT Creating Table grouppermission ... CREATE TABLE grouppermission ( GroupPermNum NUMBER(20) NOT NULL, NewerDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, NewerDays NUMBER(11) NOT NULL, UserGroupNum NUMBER(20) NOT NULL, PermType NUMBER(3) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_139 on table grouppermission ... ALTER TABLE grouppermission ADD CONSTRAINT PRIMARY_139 PRIMARY KEY ( GroupPermNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON grouppermission TO PUBLIC; -- DROP TABLE guardian CASCADE CONSTRAINTS; PROMPT Creating Table guardian ... CREATE TABLE guardian ( GuardianNum NUMBER(20) NOT NULL, PatNumChild NUMBER(20) NOT NULL, PatNumGuardian NUMBER(20) NOT NULL, Relationship NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_53 on table guardian ... ALTER TABLE guardian ADD CONSTRAINT PRIMARY_53 PRIMARY KEY ( GuardianNum ) ENABLE ; PROMPT Creating Index PatNumChild on guardian ... CREATE INDEX PatNumChild ON guardian ( PatNumChild ) ; PROMPT Creating Index PatNumGuardian on guardian ... CREATE INDEX PatNumGuardian ON guardian ( PatNumGuardian ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON guardian TO PUBLIC; -- DROP TABLE hl7msg CASCADE CONSTRAINTS; PROMPT Creating Table hl7msg ... CREATE TABLE hl7msg ( HL7MsgNum NUMBER(20) NOT NULL, HL7Status NUMBER(11) NOT NULL, MsgText CLOB, AptNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_28 on table hl7msg ... ALTER TABLE hl7msg ADD CONSTRAINT PRIMARY_28 PRIMARY KEY ( HL7MsgNum ) ENABLE ; PROMPT Creating Index AptNum_2 on hl7msg ... CREATE INDEX AptNum_2 ON hl7msg ( AptNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON hl7msg TO PUBLIC; -- DROP TABLE insfilingcode CASCADE CONSTRAINTS; PROMPT Creating Table insfilingcode ... CREATE TABLE insfilingcode ( InsFilingCodeNum NUMBER(20) NOT NULL, Descript VARCHAR2(255 CHAR), EclaimCode VARCHAR2(100 CHAR), ItemOrder NUMBER(11) ); PROMPT Creating Primary Key Constraint PRIMARY_29 on table insfilingcode ... ALTER TABLE insfilingcode ADD CONSTRAINT PRIMARY_29 PRIMARY KEY ( InsFilingCodeNum ) ENABLE ; PROMPT Creating Index ItemOrder on insfilingcode ... CREATE INDEX ItemOrder ON insfilingcode ( ItemOrder ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON insfilingcode TO PUBLIC; -- DROP TABLE insfilingcodesubtype CASCADE CONSTRAINTS; PROMPT Creating Table insfilingcodesubtype ... CREATE TABLE insfilingcodesubtype ( InsFilingCodeSubTypeNum NUMBER(20) NOT NULL, InsFilingCodeNum NUMBER(20) NOT NULL, Descript VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_140 on table insfilingcodesubtype ... ALTER TABLE insfilingcodesubtype ADD CONSTRAINT PRIMARY_140 PRIMARY KEY ( InsFilingCodeSubTypeNum ) ENABLE ; PROMPT Creating Index InsFilingCodeNum on insfilingcodesubtype ... CREATE INDEX InsFilingCodeNum ON insfilingcodesubtype ( InsFilingCodeNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON insfilingcodesubtype TO PUBLIC; -- DROP TABLE insplan CASCADE CONSTRAINTS; PROMPT Creating Table insplan ... CREATE TABLE insplan ( PlanNum NUMBER(20) NOT NULL, GroupName VARCHAR2(50 CHAR), GroupNum VARCHAR2(20 CHAR), PlanNote VARCHAR2(4000 CHAR), FeeSched NUMBER(20) NOT NULL, PlanType CHAR(1 CHAR), ClaimFormNum NUMBER(20) NOT NULL, UseAltCode NUMBER(1) DEFAULT '0' NOT NULL, ClaimsUseUCR NUMBER(1) DEFAULT '0' NOT NULL, CopayFeeSched NUMBER(20) NOT NULL, EmployerNum NUMBER(20) NOT NULL, CarrierNum NUMBER(20) NOT NULL, AllowedFeeSched NUMBER(20) NOT NULL, TrojanID VARCHAR2(100 CHAR), DivisionNo VARCHAR2(255 CHAR), IsMedical NUMBER(3) DEFAULT '0' NOT NULL, FilingCode NUMBER(20) NOT NULL, DentaideCardSequence NUMBER(3) NOT NULL, ShowBaseUnits NUMBER(1) NOT NULL, DedBeforePerc NUMBER(1) NOT NULL, CodeSubstNone NUMBER(1) NOT NULL, IsHidden NUMBER(4) NOT NULL, MonthRenew NUMBER(4) NOT NULL, FilingCodeSubtype NUMBER(20) NOT NULL, CanadianPlanFlag VARCHAR2(5 CHAR) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_74 on table insplan ... ALTER TABLE insplan ADD CONSTRAINT PRIMARY_74 PRIMARY KEY ( PlanNum ) ENABLE ; PROMPT Creating Index CarrierNum_1 on insplan ... CREATE INDEX CarrierNum_1 ON insplan ( CarrierNum ) ; PROMPT Creating Index FilingCodeSubtype on insplan ... CREATE INDEX FilingCodeSubtype ON insplan ( FilingCodeSubtype ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON insplan TO PUBLIC; -- DROP TABLE inssub CASCADE CONSTRAINTS; PROMPT Creating Table inssub ... CREATE TABLE inssub ( InsSubNum NUMBER(20) NOT NULL, PlanNum NUMBER(20) NOT NULL, Subscriber NUMBER(20) NOT NULL, DateEffective DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateTerm DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ReleaseInfo NUMBER(4) NOT NULL, AssignBen NUMBER(4) NOT NULL, SubscriberID VARCHAR2(255 CHAR), BenefitNotes CLOB, SubscNote VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_141 on table inssub ... ALTER TABLE inssub ADD CONSTRAINT PRIMARY_141 PRIMARY KEY ( InsSubNum ) ENABLE ; PROMPT Creating Index PlanNum_1 on inssub ... CREATE INDEX PlanNum_1 ON inssub ( PlanNum ) ; PROMPT Creating Index Subscriber on inssub ... CREATE INDEX Subscriber ON inssub ( Subscriber ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON inssub TO PUBLIC; -- DROP TABLE instructor CASCADE CONSTRAINTS; PROMPT Creating Table instructor ... CREATE TABLE instructor ( InstructorNum NUMBER(11) NOT NULL, LName VARCHAR2(255 CHAR), FName VARCHAR2(255 CHAR), Suffix VARCHAR2(100 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_142 on table instructor ... ALTER TABLE instructor ADD CONSTRAINT PRIMARY_142 PRIMARY KEY ( InstructorNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON instructor TO PUBLIC; -- DROP TABLE journalentry CASCADE CONSTRAINTS; PROMPT Creating Table journalentry ... CREATE TABLE journalentry ( JournalEntryNum NUMBER(20) NOT NULL, TransactionNum NUMBER(20) NOT NULL, AccountNum NUMBER(20) NOT NULL, DateDisplayed DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DebitAmt NUMBER(38,8) DEFAULT '0' NOT NULL, CreditAmt NUMBER(38,8) DEFAULT '0' NOT NULL, Memo VARCHAR2(4000 CHAR), Splits VARCHAR2(4000 CHAR), CheckNumber VARCHAR2(255 CHAR), ReconcileNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_93 on table journalentry ... ALTER TABLE journalentry ADD CONSTRAINT PRIMARY_93 PRIMARY KEY ( JournalEntryNum ) ENABLE ; PROMPT Creating Index indexAccountNum on journalentry ... CREATE INDEX indexAccountNum ON journalentry ( AccountNum ) ; PROMPT Creating Index indexTransactionNum on journalentry ... CREATE INDEX indexTransactionNum ON journalentry ( TransactionNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON journalentry TO PUBLIC; -- DROP TABLE labcase CASCADE CONSTRAINTS; PROMPT Creating Table labcase ... CREATE TABLE labcase ( LabCaseNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, LaboratoryNum NUMBER(20) NOT NULL, AptNum NUMBER(20) NOT NULL, PlannedAptNum NUMBER(20) NOT NULL, DateTimeDue DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, DateTimeCreated DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, DateTimeSent DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, DateTimeRecd DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, DateTimeChecked DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, ProvNum NUMBER(20) NOT NULL, Instructions VARCHAR2(4000 CHAR), LabFee NUMBER(38,8) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_30 on table labcase ... ALTER TABLE labcase ADD CONSTRAINT PRIMARY_30 PRIMARY KEY ( LabCaseNum ) ENABLE ; PROMPT Creating Index indexAptNum on labcase ... CREATE INDEX indexAptNum ON labcase ( AptNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON labcase TO PUBLIC; -- DROP TABLE laboratory CASCADE CONSTRAINTS; PROMPT Creating Table laboratory ... CREATE TABLE laboratory ( LaboratoryNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), Phone VARCHAR2(255 CHAR), Notes VARCHAR2(4000 CHAR), Slip NUMBER(20) NOT NULL, Address VARCHAR2(255 CHAR), City VARCHAR2(255 CHAR), State VARCHAR2(255 CHAR), Zip VARCHAR2(255 CHAR), Email VARCHAR2(255 CHAR), WirelessPhone VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_6 on table laboratory ... ALTER TABLE laboratory ADD CONSTRAINT PRIMARY_6 PRIMARY KEY ( LaboratoryNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON laboratory TO PUBLIC; -- DROP TABLE labturnaround CASCADE CONSTRAINTS; PROMPT Creating Table labturnaround ... CREATE TABLE labturnaround ( LabTurnaroundNum NUMBER(20) NOT NULL, LaboratoryNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), DaysPublished NUMBER(6) NOT NULL, DaysActual NUMBER(6) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_75 on table labturnaround ... ALTER TABLE labturnaround ADD CONSTRAINT PRIMARY_75 PRIMARY KEY ( LabTurnaroundNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON labturnaround TO PUBLIC; -- DROP TABLE language CASCADE CONSTRAINTS; PROMPT Creating Table language ... CREATE TABLE language ( LanguageNum NUMBER(20) NOT NULL, EnglishComments VARCHAR2(4000 CHAR), ClassType VARCHAR2(4000 CHAR), English VARCHAR2(4000 CHAR), IsObsolete NUMBER(1) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_94 on table language ... ALTER TABLE language ADD CONSTRAINT PRIMARY_94 PRIMARY KEY ( LanguageNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON language TO PUBLIC; -- DROP TABLE languageforeign CASCADE CONSTRAINTS; PROMPT Creating Table languageforeign ... CREATE TABLE languageforeign ( LanguageForeignNum NUMBER(20) NOT NULL, ClassType VARCHAR2(4000 CHAR), English VARCHAR2(4000 CHAR), Culture VARCHAR2(255 CHAR), Translation VARCHAR2(4000 CHAR), Comments VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_143 on table languageforeign ... ALTER TABLE languageforeign ADD CONSTRAINT PRIMARY_143 PRIMARY KEY ( LanguageForeignNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON languageforeign TO PUBLIC; -- DROP TABLE letter CASCADE CONSTRAINTS; PROMPT Creating Table letter ... CREATE TABLE letter ( LetterNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), BodyText CLOB ); PROMPT Creating Primary Key Constraint PRIMARY_168 on table letter ... ALTER TABLE letter ADD CONSTRAINT PRIMARY_168 PRIMARY KEY ( LetterNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON letter TO PUBLIC; -- DROP TABLE lettermerge CASCADE CONSTRAINTS; PROMPT Creating Table lettermerge ... CREATE TABLE lettermerge ( LetterMergeNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), TemplateName VARCHAR2(255 CHAR), DataFileName VARCHAR2(255 CHAR), Category NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_113 on table lettermerge ... ALTER TABLE lettermerge ADD CONSTRAINT PRIMARY_113 PRIMARY KEY ( LetterMergeNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON lettermerge TO PUBLIC; -- DROP TABLE lettermergefield CASCADE CONSTRAINTS; PROMPT Creating Table lettermergefield ... CREATE TABLE lettermergefield ( FieldNum NUMBER(20) NOT NULL, LetterMergeNum NUMBER(20) NOT NULL, FieldName VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_31 on table lettermergefield ... ALTER TABLE lettermergefield ADD CONSTRAINT PRIMARY_31 PRIMARY KEY ( FieldNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON lettermergefield TO PUBLIC; -- DROP TABLE medication CASCADE CONSTRAINTS; PROMPT Creating Table medication ... CREATE TABLE medication ( MedicationNum NUMBER(20) NOT NULL, MedName VARCHAR2(255 CHAR), GenericNum NUMBER(20) NOT NULL, Notes VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_76 on table medication ... ALTER TABLE medication ADD CONSTRAINT PRIMARY_76 PRIMARY KEY ( MedicationNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON medication TO PUBLIC; -- DROP TABLE medicationpat CASCADE CONSTRAINTS; PROMPT Creating Table medicationpat ... CREATE TABLE medicationpat ( MedicationPatNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, MedicationNum NUMBER(20) NOT NULL, PatNote VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_32 on table medicationpat ... ALTER TABLE medicationpat ADD CONSTRAINT PRIMARY_32 PRIMARY KEY ( MedicationPatNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON medicationpat TO PUBLIC; -- DROP TABLE mount CASCADE CONSTRAINTS; PROMPT Creating Table mount ... CREATE TABLE mount ( MountNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, DocCategory NUMBER(20) NOT NULL, DateCreated DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, Description VARCHAR2(255 CHAR), ImgType NUMBER(3) DEFAULT '0' NOT NULL, Note VARCHAR2(4000 CHAR), Width NUMBER(11) DEFAULT '0', Height NUMBER(11) DEFAULT '0' ); PROMPT Creating Primary Key Constraint PRIMARY_95 on table mount ... ALTER TABLE mount ADD CONSTRAINT PRIMARY_95 PRIMARY KEY ( MountNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON mount TO PUBLIC; -- DROP TABLE mountdef CASCADE CONSTRAINTS; PROMPT Creating Table mountdef ... CREATE TABLE mountdef ( MountDefNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), ItemOrder NUMBER(11) NOT NULL, IsRadiograph NUMBER(3) NOT NULL, Width NUMBER(11) NOT NULL, Height NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_169 on table mountdef ... ALTER TABLE mountdef ADD CONSTRAINT PRIMARY_169 PRIMARY KEY ( MountDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON mountdef TO PUBLIC; -- DROP TABLE mountitem CASCADE CONSTRAINTS; PROMPT Creating Table mountitem ... CREATE TABLE mountitem ( MountItemNum NUMBER(20) NOT NULL, MountNum NUMBER(20) NOT NULL, Xpos NUMBER(11) NOT NULL, Ypos NUMBER(11) NOT NULL, OrdinalPos NUMBER(11) DEFAULT '0' NOT NULL, Width NUMBER(11) DEFAULT '0', Height NUMBER(11) DEFAULT '0' ); PROMPT Creating Primary Key Constraint PRIMARY_96 on table mountitem ... ALTER TABLE mountitem ADD CONSTRAINT PRIMARY_96 PRIMARY KEY ( MountItemNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON mountitem TO PUBLIC; -- DROP TABLE mountitemdef CASCADE CONSTRAINTS; PROMPT Creating Table mountitemdef ... CREATE TABLE mountitemdef ( MountItemDefNum NUMBER(20) NOT NULL, MountDefNum NUMBER(20) NOT NULL, Xpos NUMBER(11) NOT NULL, Ypos NUMBER(11) NOT NULL, Width NUMBER(11) NOT NULL, Height NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_7 on table mountitemdef ... ALTER TABLE mountitemdef ADD CONSTRAINT PRIMARY_7 PRIMARY KEY ( MountItemDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON mountitemdef TO PUBLIC; -- DROP TABLE operatory CASCADE CONSTRAINTS; PROMPT Creating Table operatory ... CREATE TABLE operatory ( OperatoryNum NUMBER(20) NOT NULL, OpName VARCHAR2(255 CHAR), Abbrev VARCHAR2(255 CHAR), ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, IsHidden NUMBER(3) DEFAULT '0' NOT NULL, ProvDentist NUMBER(20) NOT NULL, ProvHygienist NUMBER(20) NOT NULL, IsHygiene NUMBER(3) DEFAULT '0' NOT NULL, ClinicNum NUMBER(20) NOT NULL, DateTStamp DATE DEFAULT SYSDATE, SetProspective NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_170 on table operatory ... ALTER TABLE operatory ADD CONSTRAINT PRIMARY_170 PRIMARY KEY ( OperatoryNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON operatory TO PUBLIC; -- DROP TABLE orionproc CASCADE CONSTRAINTS; PROMPT Creating Table orionproc ... CREATE TABLE orionproc ( OrionProcNum NUMBER(20) NOT NULL, ProcNum NUMBER(20) NOT NULL, DPC NUMBER(4) NOT NULL, DateScheduleBy DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateStopClock DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, Status2 NUMBER(11) NOT NULL, IsOnCall NUMBER(4) NOT NULL, IsEffectiveComm NUMBER(4) NOT NULL, IsRepair NUMBER(4) NOT NULL, DPCpost NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_114 on table orionproc ... ALTER TABLE orionproc ADD CONSTRAINT PRIMARY_114 PRIMARY KEY ( OrionProcNum ) ENABLE ; PROMPT Creating Index ProcNum_3 on orionproc ... CREATE INDEX ProcNum_3 ON orionproc ( ProcNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON orionproc TO PUBLIC; -- DROP TABLE patfield CASCADE CONSTRAINTS; PROMPT Creating Table patfield ... CREATE TABLE patfield ( PatFieldNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, FieldName VARCHAR2(255 CHAR), FieldValue VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_8 on table patfield ... ALTER TABLE patfield ADD CONSTRAINT PRIMARY_8 PRIMARY KEY ( PatFieldNum ) ENABLE ; PROMPT Creating Index PatNum_12 on patfield ... CREATE INDEX PatNum_12 ON patfield ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON patfield TO PUBLIC; -- DROP TABLE patfielddef CASCADE CONSTRAINTS; PROMPT Creating Table patfielddef ... CREATE TABLE patfielddef ( PatFieldDefNum NUMBER(20) NOT NULL, FieldName VARCHAR2(255 CHAR), FieldType NUMBER(4) NOT NULL, PickList VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_33 on table patfielddef ... ALTER TABLE patfielddef ADD CONSTRAINT PRIMARY_33 PRIMARY KEY ( PatFieldDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON patfielddef TO PUBLIC; -- DROP TABLE patient CASCADE CONSTRAINTS; PROMPT Creating Table patient ... CREATE TABLE patient ( PatNum NUMBER(20) NOT NULL, LName VARCHAR2(100 CHAR), FName VARCHAR2(100 CHAR), MiddleI VARCHAR2(100 CHAR), Preferred VARCHAR2(100 CHAR), PatStatus NUMBER(3) DEFAULT '0' NOT NULL, Gender NUMBER(3) DEFAULT '0' NOT NULL, Position NUMBER(3) DEFAULT '0' NOT NULL, Birthdate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, SSN VARCHAR2(100 CHAR), Address VARCHAR2(100 CHAR), Address2 VARCHAR2(100 CHAR), City VARCHAR2(100 CHAR), State VARCHAR2(100 CHAR), Zip VARCHAR2(100 CHAR), HmPhone VARCHAR2(30 CHAR), WkPhone VARCHAR2(30 CHAR), WirelessPhone VARCHAR2(30 CHAR), Guarantor NUMBER(20) NOT NULL, CreditType CHAR(1 CHAR), Email VARCHAR2(100 CHAR), Salutation VARCHAR2(100 CHAR), EstBalance NUMBER(38,8) DEFAULT '0' NOT NULL, PriProv NUMBER(20) NOT NULL, SecProv NUMBER(20) NOT NULL, FeeSched NUMBER(20) NOT NULL, BillingType NUMBER(20) NOT NULL, ImageFolder VARCHAR2(100 CHAR), AddrNote VARCHAR2(4000 CHAR), FamFinUrgNote VARCHAR2(4000 CHAR), MedUrgNote VARCHAR2(255 CHAR), ApptModNote VARCHAR2(255 CHAR), StudentStatus CHAR(1 CHAR), SchoolName VARCHAR2(255 CHAR), ChartNumber VARCHAR2(20 CHAR), MedicaidID VARCHAR2(20 CHAR), Bal_0_30 NUMBER(38,8) DEFAULT '0' NOT NULL, Bal_31_60 NUMBER(38,8) DEFAULT '0' NOT NULL, Bal_61_90 NUMBER(38,8) DEFAULT '0' NOT NULL, BalOver90 NUMBER(38,8) DEFAULT '0' NOT NULL, InsEst NUMBER(38,8) DEFAULT '0' NOT NULL, BalTotal NUMBER(38,8) DEFAULT '0' NOT NULL, EmployerNum NUMBER(20) NOT NULL, EmploymentNote VARCHAR2(255 CHAR), Race NUMBER(4) DEFAULT '0' NOT NULL, County VARCHAR2(255 CHAR), GradeLevel NUMBER(4) DEFAULT '0' NOT NULL, Urgency NUMBER(4) DEFAULT '0' NOT NULL, DateFirstVisit DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ClinicNum NUMBER(20) NOT NULL, HasIns VARCHAR2(255 CHAR), TrophyFolder VARCHAR2(255 CHAR), PlannedIsDone NUMBER(3) DEFAULT '0' NOT NULL, Premed NUMBER(3) NOT NULL, Ward VARCHAR2(255 CHAR), PreferConfirmMethod NUMBER(3) NOT NULL, PreferContactMethod NUMBER(3) NOT NULL, PreferRecallMethod NUMBER(3) NOT NULL, SchedBeforeTime DATE, SchedAfterTime DATE, SchedDayOfWeek NUMBER(3) NOT NULL, Language VARCHAR2(100 CHAR), AdmitDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, Title VARCHAR2(15 CHAR), PayPlanDue NUMBER(38,8) NOT NULL, SiteNum NUMBER(20) NOT NULL, DateTStamp DATE DEFAULT SYSDATE, ResponsParty NUMBER(20) NOT NULL, CanadianEligibilityCode NUMBER(4) NOT NULL, AskToArriveEarly NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_171 on table patient ... ALTER TABLE patient ADD CONSTRAINT PRIMARY_171 PRIMARY KEY ( PatNum ) ENABLE ; PROMPT Creating Index indexLName on patient ... CREATE INDEX indexLName ON patient ( LName ) ; PROMPT Creating Index indexFName on patient ... CREATE INDEX indexFName ON patient ( FName ) ; PROMPT Creating Index indexLFName on patient ... CREATE INDEX indexLFName ON patient ( LName, FName ) ; PROMPT Creating Index indexGuarantor_1 on patient ... CREATE INDEX indexGuarantor_1 ON patient ( Guarantor ) ; PROMPT Creating Index ResponsParty on patient ... CREATE INDEX ResponsParty ON patient ( ResponsParty ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON patient TO PUBLIC; -- DROP TABLE patientnote CASCADE CONSTRAINTS; PROMPT Creating Table patientnote ... CREATE TABLE patientnote ( PatNum NUMBER(20) NOT NULL, FamFinancial VARCHAR2(4000 CHAR), ApptPhone VARCHAR2(4000 CHAR), Medical VARCHAR2(4000 CHAR), Service VARCHAR2(4000 CHAR), MedicalComp CLOB, Treatment VARCHAR2(4000 CHAR), CCNumber VARCHAR2(255 CHAR), CCExpiration DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_172 on table patientnote ... ALTER TABLE patientnote ADD CONSTRAINT PRIMARY_172 PRIMARY KEY ( PatNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON patientnote TO PUBLIC; -- DROP TABLE patplan CASCADE CONSTRAINTS; PROMPT Creating Table patplan ... CREATE TABLE patplan ( PatPlanNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, PlanNum NUMBER(20) NOT NULL, Ordinal NUMBER(3) DEFAULT '0' NOT NULL, IsPending NUMBER(3) DEFAULT '0' NOT NULL, Relationship NUMBER(3) DEFAULT '0' NOT NULL, PatID VARCHAR2(100 CHAR), InsSubNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_115 on table patplan ... ALTER TABLE patplan ADD CONSTRAINT PRIMARY_115 PRIMARY KEY ( PatPlanNum ) ENABLE ; PROMPT Creating Index indexPatNum_5 on patplan ... CREATE INDEX indexPatNum_5 ON patplan ( PatNum ) ; PROMPT Creating Index PlanNum_2 on patplan ... CREATE INDEX PlanNum_2 ON patplan ( PlanNum ) ; PROMPT Creating Index InsSubNum_4 on patplan ... CREATE INDEX InsSubNum_4 ON patplan ( InsSubNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON patplan TO PUBLIC; -- DROP TABLE payment CASCADE CONSTRAINTS; PROMPT Creating Table payment ... CREATE TABLE payment ( PayNum NUMBER(20) NOT NULL, PayType NUMBER(20) NOT NULL, PayDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, PayAmt NUMBER(38,8) DEFAULT '0' NOT NULL, CheckNum VARCHAR2(25 CHAR), BankBranch VARCHAR2(25 CHAR), PayNote VARCHAR2(255 CHAR), IsSplit NUMBER(1) DEFAULT '0' NOT NULL, PatNum NUMBER(20) NOT NULL, ClinicNum NUMBER(20) NOT NULL, DateEntry DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DepositNum NUMBER(20) NOT NULL, Receipt CLOB ); PROMPT Creating Primary Key Constraint PRIMARY_116 on table payment ... ALTER TABLE payment ADD CONSTRAINT PRIMARY_116 PRIMARY KEY ( PayNum ) ENABLE ; PROMPT Creating Index indexPatNum_6 on payment ... CREATE INDEX indexPatNum_6 ON payment ( PatNum ) ; PROMPT Creating Index DepositNum_1 on payment ... CREATE INDEX DepositNum_1 ON payment ( DepositNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON payment TO PUBLIC; -- DROP TABLE payperiod CASCADE CONSTRAINTS; PROMPT Creating Table payperiod ... CREATE TABLE payperiod ( PayPeriodNum NUMBER(20) NOT NULL, DateStart DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateStop DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DatePaycheck DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_117 on table payperiod ... ALTER TABLE payperiod ADD CONSTRAINT PRIMARY_117 PRIMARY KEY ( PayPeriodNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON payperiod TO PUBLIC; -- DROP TABLE payplan CASCADE CONSTRAINTS; PROMPT Creating Table payplan ... CREATE TABLE payplan ( PayPlanNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, Guarantor NUMBER(20) NOT NULL, PayPlanDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, APR NUMBER(38,8) DEFAULT '0' NOT NULL, Note VARCHAR2(4000 CHAR), PlanNum NUMBER(20) NOT NULL, CompletedAmt NUMBER(38,8) NOT NULL, InsSubNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_118 on table payplan ... ALTER TABLE payplan ADD CONSTRAINT PRIMARY_118 PRIMARY KEY ( PayPlanNum ) ENABLE ; PROMPT Creating Index InsSubNum_1 on payplan ... CREATE INDEX InsSubNum_1 ON payplan ( InsSubNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON payplan TO PUBLIC; -- DROP TABLE payplancharge CASCADE CONSTRAINTS; PROMPT Creating Table payplancharge ... CREATE TABLE payplancharge ( PayPlanChargeNum NUMBER(20) NOT NULL, PayPlanNum NUMBER(20) NOT NULL, Guarantor NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ChargeDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, Principal NUMBER(38,8) DEFAULT '0' NOT NULL, Interest NUMBER(38,8) DEFAULT '0' NOT NULL, Note VARCHAR2(4000 CHAR), ProvNum NUMBER(20) NOT NULL, ClinicNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_144 on table payplancharge ... ALTER TABLE payplancharge ADD CONSTRAINT PRIMARY_144 PRIMARY KEY ( PayPlanChargeNum ) ENABLE ; PROMPT Creating Index indexPatNum_7 on payplancharge ... CREATE INDEX indexPatNum_7 ON payplancharge ( PatNum ) ; PROMPT Creating Index indexGuarantor on payplancharge ... CREATE INDEX indexGuarantor ON payplancharge ( Guarantor ) ; PROMPT Creating Index indexPayPlanNum on payplancharge ... CREATE INDEX indexPayPlanNum ON payplancharge ( PayPlanNum ) ; PROMPT Creating Index ClinicNum on payplancharge ... CREATE INDEX ClinicNum ON payplancharge ( ClinicNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON payplancharge TO PUBLIC; -- DROP TABLE paysplit CASCADE CONSTRAINTS; PROMPT Creating Table paysplit ... CREATE TABLE paysplit ( SplitNum NUMBER(20) NOT NULL, SplitAmt NUMBER(38,8) DEFAULT '0' NOT NULL, PatNum NUMBER(20) NOT NULL, ProcDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, PayNum NUMBER(20) NOT NULL, IsDiscount NUMBER(1) DEFAULT '0' NOT NULL, DiscountType NUMBER(3) DEFAULT '0' NOT NULL, ProvNum NUMBER(20) NOT NULL, PayPlanNum NUMBER(20) NOT NULL, DatePay DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ProcNum NUMBER(20) NOT NULL, DateEntry DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, UnearnedType NUMBER(20) NOT NULL, ClinicNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_119 on table paysplit ... ALTER TABLE paysplit ADD CONSTRAINT PRIMARY_119 PRIMARY KEY ( SplitNum ) ENABLE ; PROMPT Creating Index indexPatNum_8 on paysplit ... CREATE INDEX indexPatNum_8 ON paysplit ( PatNum ) ; PROMPT Creating Index ProcNum_2 on paysplit ... CREATE INDEX ProcNum_2 ON paysplit ( ProcNum ) ; PROMPT Creating Index PayNum on paysplit ... CREATE INDEX PayNum ON paysplit ( PayNum ) ; PROMPT Creating Index ClinicNum_2 on paysplit ... CREATE INDEX ClinicNum_2 ON paysplit ( ClinicNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON paysplit TO PUBLIC; -- DROP TABLE perioexam CASCADE CONSTRAINTS; PROMPT Creating Table perioexam ... CREATE TABLE perioexam ( PerioExamNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ExamDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, ProvNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_145 on table perioexam ... ALTER TABLE perioexam ADD CONSTRAINT PRIMARY_145 PRIMARY KEY ( PerioExamNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON perioexam TO PUBLIC; -- DROP TABLE periomeasure CASCADE CONSTRAINTS; PROMPT Creating Table periomeasure ... CREATE TABLE periomeasure ( PerioMeasureNum NUMBER(20) NOT NULL, PerioExamNum NUMBER(20) NOT NULL, SequenceType NUMBER(3) DEFAULT '0' NOT NULL, IntTooth NUMBER(6) NOT NULL, ToothValue NUMBER(6) NOT NULL, MBvalue NUMBER(6) NOT NULL, Bvalue NUMBER(6) NOT NULL, DBvalue NUMBER(6) NOT NULL, MLvalue NUMBER(6) NOT NULL, Lvalue NUMBER(6) NOT NULL, DLvalue NUMBER(6) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_146 on table periomeasure ... ALTER TABLE periomeasure ADD CONSTRAINT PRIMARY_146 PRIMARY KEY ( PerioMeasureNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON periomeasure TO PUBLIC; -- DROP TABLE pharmacy CASCADE CONSTRAINTS; PROMPT Creating Table pharmacy ... CREATE TABLE pharmacy ( PharmacyNum NUMBER(20) NOT NULL, PharmID VARCHAR2(255 CHAR), StoreName VARCHAR2(255 CHAR), Phone VARCHAR2(255 CHAR), Fax VARCHAR2(255 CHAR), Address VARCHAR2(255 CHAR), Address2 VARCHAR2(255 CHAR), City VARCHAR2(255 CHAR), State VARCHAR2(255 CHAR), Zip VARCHAR2(255 CHAR), Note VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_9 on table pharmacy ... ALTER TABLE pharmacy ADD CONSTRAINT PRIMARY_9 PRIMARY KEY ( PharmacyNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON pharmacy TO PUBLIC; -- DROP TABLE phonenumber CASCADE CONSTRAINTS; PROMPT Creating Table phonenumber ... CREATE TABLE phonenumber ( PhoneNumberNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, PhoneNumberVal VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_77 on table phonenumber ... ALTER TABLE phonenumber ADD CONSTRAINT PRIMARY_77 PRIMARY KEY ( PhoneNumberNum ) ENABLE ; PROMPT Creating Index PatNum_1 on phonenumber ... CREATE INDEX PatNum_1 ON phonenumber ( PatNum ) ; PROMPT Creating Index PhoneNumberVal on phonenumber ... CREATE INDEX PhoneNumberVal ON phonenumber ( PhoneNumberVal ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON phonenumber TO PUBLIC; -- DROP TABLE plannedappt CASCADE CONSTRAINTS; PROMPT Creating Table plannedappt ... CREATE TABLE plannedappt ( PlannedApptNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, AptNum NUMBER(20) NOT NULL, ItemOrder NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_147 on table plannedappt ... ALTER TABLE plannedappt ADD CONSTRAINT PRIMARY_147 PRIMARY KEY ( PlannedApptNum ) ENABLE ; PROMPT Creating Index PatNum_14 on plannedappt ... CREATE INDEX PatNum_14 ON plannedappt ( PatNum ) ; PROMPT Creating Index AptNum on plannedappt ... CREATE INDEX AptNum ON plannedappt ( AptNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON plannedappt TO PUBLIC; -- DROP TABLE popup CASCADE CONSTRAINTS; PROMPT Creating Table popup ... CREATE TABLE popup ( PopupNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, Description VARCHAR2(4000 CHAR), IsDisabled NUMBER(1) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_78 on table popup ... ALTER TABLE popup ADD CONSTRAINT PRIMARY_78 PRIMARY KEY ( PopupNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON popup TO PUBLIC; -- DROP TABLE preference CASCADE CONSTRAINTS; PROMPT Creating Table preference ... CREATE TABLE preference ( PrefName VARCHAR2(255 CHAR), ValueString VARCHAR2(4000 CHAR), PrefNum NUMBER(20) NOT NULL, Comments VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_120 on table preference ... ALTER TABLE preference ADD CONSTRAINT PRIMARY_120 PRIMARY KEY ( PrefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON preference TO PUBLIC; -- DROP TABLE printer CASCADE CONSTRAINTS; PROMPT Creating Table printer ... CREATE TABLE printer ( PrinterNum NUMBER(20) NOT NULL, ComputerNum NUMBER(20) NOT NULL, PrintSit NUMBER(3) DEFAULT '0' NOT NULL, PrinterName VARCHAR2(255 CHAR), DisplayPrompt NUMBER(3) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_148 on table printer ... ALTER TABLE printer ADD CONSTRAINT PRIMARY_148 PRIMARY KEY ( PrinterNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON printer TO PUBLIC; -- DROP TABLE procapptcolor CASCADE CONSTRAINTS; PROMPT Creating Table procapptcolor ... CREATE TABLE procapptcolor ( ProcApptColorNum NUMBER(20) NOT NULL, CodeRange VARCHAR2(255 CHAR), ColorText NUMBER(11) NOT NULL, ShowPreviousDate NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_121 on table procapptcolor ... ALTER TABLE procapptcolor ADD CONSTRAINT PRIMARY_121 PRIMARY KEY ( ProcApptColorNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON procapptcolor TO PUBLIC; -- DROP TABLE procbutton CASCADE CONSTRAINTS; PROMPT Creating Table procbutton ... CREATE TABLE procbutton ( ProcButtonNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, Category NUMBER(20) NOT NULL, ButtonImage CLOB ); PROMPT Creating Primary Key Constraint PRIMARY_54 on table procbutton ... ALTER TABLE procbutton ADD CONSTRAINT PRIMARY_54 PRIMARY KEY ( ProcButtonNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON procbutton TO PUBLIC; -- DROP TABLE procbuttonitem CASCADE CONSTRAINTS; PROMPT Creating Table procbuttonitem ... CREATE TABLE procbuttonitem ( ProcButtonItemNum NUMBER(20) NOT NULL, ProcButtonNum NUMBER(20) NOT NULL, OldCode VARCHAR2(15 CHAR), AutoCodeNum NUMBER(20) NOT NULL, CodeNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_10 on table procbuttonitem ... ALTER TABLE procbuttonitem ADD CONSTRAINT PRIMARY_10 PRIMARY KEY ( ProcButtonItemNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON procbuttonitem TO PUBLIC; -- DROP TABLE proccodenote CASCADE CONSTRAINTS; PROMPT Creating Table proccodenote ... CREATE TABLE proccodenote ( ProcCodeNoteNum NUMBER(20) NOT NULL, CodeNum NUMBER(20) NOT NULL, ProvNum NUMBER(20) NOT NULL, Note VARCHAR2(4000 CHAR), ProcTime VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_11 on table proccodenote ... ALTER TABLE proccodenote ADD CONSTRAINT PRIMARY_11 PRIMARY KEY ( ProcCodeNoteNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON proccodenote TO PUBLIC; -- DROP TABLE procedurecode CASCADE CONSTRAINTS; PROMPT Creating Table procedurecode ... CREATE TABLE procedurecode ( CodeNum NUMBER(20) NOT NULL, ProcCode VARCHAR2(15 CHAR), Descript VARCHAR2(255 CHAR), AbbrDesc VARCHAR2(50 CHAR), ProcTime VARCHAR2(24 CHAR), ProcCat NUMBER(20) NOT NULL, TreatArea NUMBER(3) DEFAULT '0' NOT NULL, NoBillIns NUMBER(1) DEFAULT '0' NOT NULL, IsProsth NUMBER(1) DEFAULT '0' NOT NULL, DefaultNote VARCHAR2(4000 CHAR), IsHygiene NUMBER(1) DEFAULT '0' NOT NULL, GTypeNum NUMBER(5) DEFAULT '0' NOT NULL, AlternateCode1 VARCHAR2(15 CHAR), MedicalCode VARCHAR2(15 CHAR), IsTaxed NUMBER(3) DEFAULT '0' NOT NULL, PaintType NUMBER(4) DEFAULT '0' NOT NULL, GraphicColor NUMBER(11) NOT NULL, LaymanTerm VARCHAR2(255 CHAR), IsCanadianLab NUMBER(3) NOT NULL, PreExisting NUMBER(1) DEFAULT '0' NOT NULL, BaseUnits NUMBER(11) NOT NULL, SubstitutionCode VARCHAR2(25 CHAR), SubstOnlyIf NUMBER(11) NOT NULL, DateTStamp DATE DEFAULT SYSDATE, IsMultiVisit NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_55 on table procedurecode ... ALTER TABLE procedurecode ADD CONSTRAINT PRIMARY_55 PRIMARY KEY ( CodeNum ) ENABLE ; PROMPT Creating Index ProcCode on procedurecode ... CREATE INDEX ProcCode ON procedurecode ( ProcCode ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON procedurecode TO PUBLIC; -- DROP TABLE procedurelog CASCADE CONSTRAINTS; PROMPT Creating Table procedurelog ... CREATE TABLE procedurelog ( ProcNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, AptNum NUMBER(20) NOT NULL, OldCode VARCHAR2(15 CHAR), ProcDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ProcFee NUMBER(38,8) DEFAULT '0' NOT NULL, Surf VARCHAR2(10 CHAR), ToothNum VARCHAR2(2 CHAR), ToothRange VARCHAR2(100 CHAR), Priority NUMBER(20) NOT NULL, ProcStatus NUMBER(3) DEFAULT '0' NOT NULL, ProvNum NUMBER(20) NOT NULL, Dx NUMBER(20) NOT NULL, PlannedAptNum NUMBER(20) NOT NULL, PlaceService NUMBER(3) DEFAULT '0' NOT NULL, Prosthesis CHAR(1 CHAR), DateOriginalProsth DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ClaimNote VARCHAR2(80 CHAR), DateEntryC DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, ClinicNum NUMBER(20) NOT NULL, MedicalCode VARCHAR2(15 CHAR), DiagnosticCode VARCHAR2(255 CHAR), IsPrincDiag NUMBER(3) DEFAULT '0' NOT NULL, ProcNumLab NUMBER(20) NOT NULL, BillingTypeOne NUMBER(20) NOT NULL, BillingTypeTwo NUMBER(20) NOT NULL, CodeNum NUMBER(20) NOT NULL, CodeMod1 CHAR(2 CHAR), CodeMod2 CHAR(2 CHAR), CodeMod3 CHAR(2 CHAR), CodeMod4 CHAR(2 CHAR), RevCode VARCHAR2(45 CHAR), UnitCode CHAR(2 CHAR), UnitQty NUMBER(11) NOT NULL, BaseUnits NUMBER(11) NOT NULL, StartTime NUMBER(11) NOT NULL, StopTime NUMBER(11) NOT NULL, DateTP DATE NOT NULL, SiteNum NUMBER(20) NOT NULL, HideGraphics NUMBER(4) NOT NULL, CanadianTypeCodes VARCHAR2(20 CHAR), ProcTime DATE NOT NULL, ProcTimeEnd DATE NOT NULL, DateTStamp DATE DEFAULT SYSDATE ); PROMPT Creating Primary Key Constraint PRIMARY_97 on table procedurelog ... ALTER TABLE procedurelog ADD CONSTRAINT PRIMARY_97 PRIMARY KEY ( ProcNum ) ENABLE ; PROMPT Creating Index INDEXPATNUM_181 on procedurelog ... CREATE INDEX INDEXPATNUM_181 ON procedurelog ( PatNum ) ; PROMPT Creating Index indexAptNum_1 on procedurelog ... CREATE INDEX indexAptNum_1 ON procedurelog ( AptNum ) ; PROMPT Creating Index CodeNum_2 on procedurelog ... CREATE INDEX CodeNum_2 ON procedurelog ( CodeNum ) ; PROMPT Creating Index PlannedAptNum on procedurelog ... CREATE INDEX PlannedAptNum ON procedurelog ( PlannedAptNum ) ; PROMPT Creating Index BillingTypeOne on procedurelog ... CREATE INDEX BillingTypeOne ON procedurelog ( BillingTypeOne ) ; PROMPT Creating Index BillingTypeTwo on procedurelog ... CREATE INDEX BillingTypeTwo ON procedurelog ( BillingTypeTwo ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON procedurelog TO PUBLIC; -- DROP TABLE procgroupitem CASCADE CONSTRAINTS; PROMPT Creating Table procgroupitem ... CREATE TABLE procgroupitem ( ProcGroupItemNum NUMBER(20) NOT NULL, ProcNum NUMBER(20) NOT NULL, GroupNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_98 on table procgroupitem ... ALTER TABLE procgroupitem ADD CONSTRAINT PRIMARY_98 PRIMARY KEY ( ProcGroupItemNum ) ENABLE ; PROMPT Creating Index ProcNum_1 on procgroupitem ... CREATE INDEX ProcNum_1 ON procgroupitem ( ProcNum ) ; PROMPT Creating Index GroupNum on procgroupitem ... CREATE INDEX GroupNum ON procgroupitem ( GroupNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON procgroupitem TO PUBLIC; -- DROP TABLE procnote CASCADE CONSTRAINTS; PROMPT Creating Table procnote ... CREATE TABLE procnote ( ProcNoteNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ProcNum NUMBER(20) NOT NULL, EntryDateTime DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, UserNum NUMBER(20) NOT NULL, Note CLOB, SigIsTopaz NUMBER(3) NOT NULL, Signature VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_122 on table procnote ... ALTER TABLE procnote ADD CONSTRAINT PRIMARY_122 PRIMARY KEY ( ProcNoteNum ) ENABLE ; PROMPT Creating Index PatNum_13 on procnote ... CREATE INDEX PatNum_13 ON procnote ( PatNum ) ; PROMPT Creating Index ProcNum on procnote ... CREATE INDEX ProcNum ON procnote ( ProcNum ) ; PROMPT Creating Index UserNum on procnote ... CREATE INDEX UserNum ON procnote ( UserNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON procnote TO PUBLIC; -- DROP TABLE proctp CASCADE CONSTRAINTS; PROMPT Creating Table proctp ... CREATE TABLE proctp ( ProcTPNum NUMBER(20) NOT NULL, TreatPlanNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ProcNumOrig NUMBER(20) NOT NULL, ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, Priority NUMBER(20) NOT NULL, ToothNumTP VARCHAR2(255 CHAR), Surf VARCHAR2(255 CHAR), ProcCode VARCHAR2(15 CHAR), Descript VARCHAR2(255 CHAR), FeeAmt NUMBER(38,8) DEFAULT '0' NOT NULL, PriInsAmt NUMBER(38,8) DEFAULT '0' NOT NULL, SecInsAmt NUMBER(38,8) DEFAULT '0' NOT NULL, PatAmt NUMBER(38,8) DEFAULT '0' NOT NULL, Discount NUMBER(38,8) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_173 on table proctp ... ALTER TABLE proctp ADD CONSTRAINT PRIMARY_173 PRIMARY KEY ( ProcTPNum ) ENABLE ; PROMPT Creating Index indexPatNum_11 on proctp ... CREATE INDEX indexPatNum_11 ON proctp ( PatNum ) ; PROMPT Creating Index indexTreatPlanNum on proctp ... CREATE INDEX indexTreatPlanNum ON proctp ( TreatPlanNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON proctp TO PUBLIC; -- DROP TABLE program CASCADE CONSTRAINTS; PROMPT Creating Table program ... CREATE TABLE program ( ProgramNum NUMBER(20) NOT NULL, ProgName VARCHAR2(100 CHAR), ProgDesc VARCHAR2(100 CHAR), Enabled NUMBER(1) DEFAULT '0' NOT NULL, Path VARCHAR2(255 CHAR), CommandLine VARCHAR2(255 CHAR), Note VARCHAR2(4000 CHAR), PluginDllName VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_99 on table program ... ALTER TABLE program ADD CONSTRAINT PRIMARY_99 PRIMARY KEY ( ProgramNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON program TO PUBLIC; -- DROP TABLE programproperty CASCADE CONSTRAINTS; PROMPT Creating Table programproperty ... CREATE TABLE programproperty ( ProgramPropertyNum NUMBER(20) NOT NULL, ProgramNum NUMBER(20) NOT NULL, PropertyDesc VARCHAR2(255 CHAR), PropertyValue VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_149 on table programproperty ... ALTER TABLE programproperty ADD CONSTRAINT PRIMARY_149 PRIMARY KEY ( ProgramPropertyNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON programproperty TO PUBLIC; -- DROP TABLE provider CASCADE CONSTRAINTS; PROMPT Creating Table provider ... CREATE TABLE provider ( ProvNum NUMBER(20) NOT NULL, Abbr VARCHAR2(255 CHAR), ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, LName VARCHAR2(100 CHAR), FName VARCHAR2(100 CHAR), MI VARCHAR2(100 CHAR), Suffix VARCHAR2(100 CHAR), FeeSched NUMBER(20) NOT NULL, Specialty NUMBER(3) DEFAULT '0' NOT NULL, SSN VARCHAR2(12 CHAR), StateLicense VARCHAR2(15 CHAR), DEANum VARCHAR2(15 CHAR), IsSecondary NUMBER(1) DEFAULT '0' NOT NULL, ProvColor NUMBER(11) DEFAULT '0' NOT NULL, IsHidden NUMBER(1) DEFAULT '0' NOT NULL, UsingTIN NUMBER(1) DEFAULT '0' NOT NULL, BlueCrossID VARCHAR2(25 CHAR), SigOnFile NUMBER(1) DEFAULT '1' NOT NULL, MedicaidID VARCHAR2(20 CHAR), OutlineColor NUMBER(11) DEFAULT '0' NOT NULL, SchoolClassNum NUMBER(20) NOT NULL, NationalProvID VARCHAR2(255 CHAR), CanadianOfficeNum VARCHAR2(100 CHAR), DateTStamp DATE DEFAULT SYSDATE, AnesthProvType NUMBER(20) NOT NULL, TaxonomyCodeOverride VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_79 on table provider ... ALTER TABLE provider ADD CONSTRAINT PRIMARY_79 PRIMARY KEY ( ProvNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON provider TO PUBLIC; -- DROP TABLE providerident CASCADE CONSTRAINTS; PROMPT Creating Table providerident ... CREATE TABLE providerident ( ProviderIdentNum NUMBER(20) NOT NULL, ProvNum NUMBER(20) NOT NULL, PayorID VARCHAR2(255 CHAR), SuppIDType NUMBER(3) DEFAULT '0' NOT NULL, IDNumber VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_150 on table providerident ... ALTER TABLE providerident ADD CONSTRAINT PRIMARY_150 PRIMARY KEY ( ProviderIdentNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON providerident TO PUBLIC; -- DROP TABLE question CASCADE CONSTRAINTS; PROMPT Creating Table question ... CREATE TABLE question ( QuestionNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ItemOrder NUMBER(5) NOT NULL, Description VARCHAR2(4000 CHAR), Answer VARCHAR2(4000 CHAR), FormPatNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_123 on table question ... ALTER TABLE question ADD CONSTRAINT PRIMARY_123 PRIMARY KEY ( QuestionNum ) ENABLE ; PROMPT Creating Index indexPatNum_12 on question ... CREATE INDEX indexPatNum_12 ON question ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON question TO PUBLIC; -- DROP TABLE questiondef CASCADE CONSTRAINTS; PROMPT Creating Table questiondef ... CREATE TABLE questiondef ( QuestionDefNum NUMBER(20) NOT NULL, Description VARCHAR2(4000 CHAR), ItemOrder NUMBER(5) NOT NULL, QuestType NUMBER(3) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_56 on table questiondef ... ALTER TABLE questiondef ADD CONSTRAINT PRIMARY_56 PRIMARY KEY ( QuestionDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON questiondef TO PUBLIC; -- DROP TABLE quickpastecat CASCADE CONSTRAINTS; PROMPT Creating Table quickpastecat ... CREATE TABLE quickpastecat ( QuickPasteCatNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, DefaultForTypes VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_57 on table quickpastecat ... ALTER TABLE quickpastecat ADD CONSTRAINT PRIMARY_57 PRIMARY KEY ( QuickPasteCatNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON quickpastecat TO PUBLIC; -- DROP TABLE quickpastenote CASCADE CONSTRAINTS; PROMPT Creating Table quickpastenote ... CREATE TABLE quickpastenote ( QuickPasteNoteNum NUMBER(20) NOT NULL, QuickPasteCatNum NUMBER(20) NOT NULL, ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, Note VARCHAR2(4000 CHAR), Abbreviation VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_100 on table quickpastenote ... ALTER TABLE quickpastenote ADD CONSTRAINT PRIMARY_100 PRIMARY KEY ( QuickPasteNoteNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON quickpastenote TO PUBLIC; -- DROP TABLE recall CASCADE CONSTRAINTS; PROMPT Creating Table recall ... CREATE TABLE recall ( RecallNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, DateDueCalc DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateDue DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DatePrevious DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, RecallInterval NUMBER(11) DEFAULT '0' NOT NULL, RecallStatus NUMBER(20) NOT NULL, Note VARCHAR2(4000 CHAR), IsDisabled NUMBER(3) DEFAULT '0' NOT NULL, DateTStamp DATE DEFAULT SYSDATE, RecallTypeNum NUMBER(20) NOT NULL, DisableUntilBalance NUMBER(38,8) NOT NULL, DisableUntilDate DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_12 on table recall ... ALTER TABLE recall ADD CONSTRAINT PRIMARY_12 PRIMARY KEY ( RecallNum ) ENABLE ; PROMPT Creating Index PatNum_11 on recall ... CREATE INDEX PatNum_11 ON recall ( PatNum ) ; PROMPT Creating Index DateDue on recall ... CREATE INDEX DateDue ON recall ( DateDue ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON recall TO PUBLIC; -- DROP TABLE recalltrigger CASCADE CONSTRAINTS; PROMPT Creating Table recalltrigger ... CREATE TABLE recalltrigger ( RecallTriggerNum NUMBER(20) NOT NULL, RecallTypeNum NUMBER(20) NOT NULL, CodeNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_13 on table recalltrigger ... ALTER TABLE recalltrigger ADD CONSTRAINT PRIMARY_13 PRIMARY KEY ( RecallTriggerNum ) ENABLE ; PROMPT Creating Index CodeNum_3 on recalltrigger ... CREATE INDEX CodeNum_3 ON recalltrigger ( CodeNum ) ; PROMPT Creating Index RecallTypeNum on recalltrigger ... CREATE INDEX RecallTypeNum ON recalltrigger ( RecallTypeNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON recalltrigger TO PUBLIC; -- DROP TABLE recalltype CASCADE CONSTRAINTS; PROMPT Creating Table recalltype ... CREATE TABLE recalltype ( RecallTypeNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), DefaultInterval NUMBER(11) NOT NULL, TimePattern VARCHAR2(255 CHAR), Procedures VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_80 on table recalltype ... ALTER TABLE recalltype ADD CONSTRAINT PRIMARY_80 PRIMARY KEY ( RecallTypeNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON recalltype TO PUBLIC; -- DROP TABLE reconcile CASCADE CONSTRAINTS; PROMPT Creating Table reconcile ... CREATE TABLE reconcile ( ReconcileNum NUMBER(20) NOT NULL, AccountNum NUMBER(20) NOT NULL, StartingBal NUMBER(38,8) DEFAULT '0' NOT NULL, EndingBal NUMBER(38,8) DEFAULT '0' NOT NULL, DateReconcile DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, IsLocked NUMBER(3) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_14 on table reconcile ... ALTER TABLE reconcile ADD CONSTRAINT PRIMARY_14 PRIMARY KEY ( ReconcileNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON reconcile TO PUBLIC; -- DROP TABLE refattach CASCADE CONSTRAINTS; PROMPT Creating Table refattach ... CREATE TABLE refattach ( RefAttachNum NUMBER(20) NOT NULL, ReferralNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ItemOrder NUMBER(5) DEFAULT '0' NOT NULL, RefDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, IsFrom NUMBER(1) DEFAULT '0' NOT NULL, RefToStatus NUMBER(3) NOT NULL, Note VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_58 on table refattach ... ALTER TABLE refattach ADD CONSTRAINT PRIMARY_58 PRIMARY KEY ( RefAttachNum ) ENABLE ; PROMPT Creating Index PatNum_10 on refattach ... CREATE INDEX PatNum_10 ON refattach ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON refattach TO PUBLIC; -- DROP TABLE referral CASCADE CONSTRAINTS; PROMPT Creating Table referral ... CREATE TABLE referral ( ReferralNum NUMBER(20) NOT NULL, LName VARCHAR2(100 CHAR), FName VARCHAR2(100 CHAR), MName VARCHAR2(100 CHAR), SSN VARCHAR2(9 CHAR), UsingTIN NUMBER(1) DEFAULT '0' NOT NULL, Specialty NUMBER(3) DEFAULT '0' NOT NULL, ST VARCHAR2(2 CHAR), Telephone VARCHAR2(10 CHAR), Address VARCHAR2(100 CHAR), Address2 VARCHAR2(100 CHAR), City VARCHAR2(100 CHAR), Zip VARCHAR2(10 CHAR), Note VARCHAR2(4000 CHAR), Phone2 VARCHAR2(30 CHAR), IsHidden NUMBER(1) DEFAULT '0' NOT NULL, NotPerson NUMBER(1) DEFAULT '0' NOT NULL, Title VARCHAR2(255 CHAR), EMail VARCHAR2(255 CHAR), PatNum NUMBER(20) NOT NULL, NationalProvID VARCHAR2(255 CHAR), Slip NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_15 on table referral ... ALTER TABLE referral ADD CONSTRAINT PRIMARY_15 PRIMARY KEY ( ReferralNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON referral TO PUBLIC; -- DROP TABLE registrationkey CASCADE CONSTRAINTS; PROMPT Creating Table registrationkey ... CREATE TABLE registrationkey ( RegistrationKeyNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, RegKey VARCHAR2(4000 CHAR), Note VARCHAR2(4000 CHAR), DateStarted DATE NOT NULL, DateDisabled DATE NOT NULL, DateEnded DATE NOT NULL, IsForeign NUMBER(1) NOT NULL, UsesServerVersion NUMBER(4) NOT NULL, IsFreeVersion NUMBER(4) NOT NULL, IsOnlyForTesting NUMBER(4) NOT NULL, VotesAllotted NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_34 on table registrationkey ... ALTER TABLE registrationkey ADD CONSTRAINT PRIMARY_34 PRIMARY KEY ( RegistrationKeyNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON registrationkey TO PUBLIC; -- DROP TABLE repeatcharge CASCADE CONSTRAINTS; PROMPT Creating Table repeatcharge ... CREATE TABLE repeatcharge ( RepeatChargeNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ProcCode VARCHAR2(15 CHAR), ChargeAmt NUMBER(38,8) DEFAULT '0' NOT NULL, DateStart DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, DateStop DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, Note VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_35 on table repeatcharge ... ALTER TABLE repeatcharge ADD CONSTRAINT PRIMARY_35 PRIMARY KEY ( RepeatChargeNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON repeatcharge TO PUBLIC; -- DROP TABLE replicationserver CASCADE CONSTRAINTS; PROMPT Creating Table replicationserver ... CREATE TABLE replicationserver ( ReplicationServerNum NUMBER(20) NOT NULL, Descript VARCHAR2(4000 CHAR), ServerId NUMBER(10) NOT NULL, RangeStart NUMBER(20) NOT NULL, RangeEnd NUMBER(20) NOT NULL, AtoZpath VARCHAR2(255 CHAR), UpdateBlocked NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_151 on table replicationserver ... ALTER TABLE replicationserver ADD CONSTRAINT PRIMARY_151 PRIMARY KEY ( ReplicationServerNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON replicationserver TO PUBLIC; -- DROP TABLE reqneeded CASCADE CONSTRAINTS; PROMPT Creating Table reqneeded ... CREATE TABLE reqneeded ( ReqNeededNum NUMBER(20) NOT NULL, Descript VARCHAR2(255 CHAR), SchoolCourseNum NUMBER(20) NOT NULL, SchoolClassNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_59 on table reqneeded ... ALTER TABLE reqneeded ADD CONSTRAINT PRIMARY_59 PRIMARY KEY ( ReqNeededNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON reqneeded TO PUBLIC; -- DROP TABLE reqstudent CASCADE CONSTRAINTS; PROMPT Creating Table reqstudent ... CREATE TABLE reqstudent ( ReqStudentNum NUMBER(20) NOT NULL, ReqNeededNum NUMBER(20) NOT NULL, Descript VARCHAR2(255 CHAR), SchoolCourseNum NUMBER(20) NOT NULL, ProvNum NUMBER(20) NOT NULL, AptNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, InstructorNum NUMBER(20) NOT NULL, DateCompleted DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_81 on table reqstudent ... ALTER TABLE reqstudent ADD CONSTRAINT PRIMARY_81 PRIMARY KEY ( ReqStudentNum ) ENABLE ; PROMPT Creating Index ReqNeededNum on reqstudent ... CREATE INDEX ReqNeededNum ON reqstudent ( ReqNeededNum ) ; PROMPT Creating Index ProvNum on reqstudent ... CREATE INDEX ProvNum ON reqstudent ( ProvNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON reqstudent TO PUBLIC; -- DROP TABLE rxalert CASCADE CONSTRAINTS; PROMPT Creating Table rxalert ... CREATE TABLE rxalert ( RxAlertNum NUMBER(20) NOT NULL, RxDefNum NUMBER(20) NOT NULL, DiseaseDefNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_124 on table rxalert ... ALTER TABLE rxalert ADD CONSTRAINT PRIMARY_124 PRIMARY KEY ( RxAlertNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON rxalert TO PUBLIC; -- DROP TABLE rxdef CASCADE CONSTRAINTS; PROMPT Creating Table rxdef ... CREATE TABLE rxdef ( RxDefNum NUMBER(20) NOT NULL, Drug VARCHAR2(255 CHAR), Sig VARCHAR2(255 CHAR), Disp VARCHAR2(255 CHAR), Refills VARCHAR2(30 CHAR), Notes VARCHAR2(255 CHAR), IsControlled NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_174 on table rxdef ... ALTER TABLE rxdef ADD CONSTRAINT PRIMARY_174 PRIMARY KEY ( RxDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON rxdef TO PUBLIC; -- DROP TABLE rxpat CASCADE CONSTRAINTS; PROMPT Creating Table rxpat ... CREATE TABLE rxpat ( RxNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, RxDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, Drug VARCHAR2(255 CHAR), Sig VARCHAR2(255 CHAR), Disp VARCHAR2(255 CHAR), Refills VARCHAR2(30 CHAR), ProvNum NUMBER(20) NOT NULL, Notes VARCHAR2(255 CHAR), PharmacyNum NUMBER(20) NOT NULL, IsControlled NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_101 on table rxpat ... ALTER TABLE rxpat ADD CONSTRAINT PRIMARY_101 PRIMARY KEY ( RxNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON rxpat TO PUBLIC; -- DROP TABLE schedule CASCADE CONSTRAINTS; PROMPT Creating Table schedule ... CREATE TABLE schedule ( ScheduleNum NUMBER(20) NOT NULL, SchedDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, StartTime DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, StopTime DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, SchedType NUMBER(3) DEFAULT '0' NOT NULL, ProvNum NUMBER(20) NOT NULL, BlockoutType NUMBER(20) NOT NULL, Note VARCHAR2(4000 CHAR), Status NUMBER(3) DEFAULT '0' NOT NULL, EmployeeNum NUMBER(20) NOT NULL, DateTStamp DATE DEFAULT SYSDATE ); PROMPT Creating Primary Key Constraint PRIMARY_36 on table schedule ... ALTER TABLE schedule ADD CONSTRAINT PRIMARY_36 PRIMARY KEY ( ScheduleNum ) ENABLE ; PROMPT Creating Index EmployeeNum_1 on schedule ... CREATE INDEX EmployeeNum_1 ON schedule ( EmployeeNum ) ; PROMPT Creating Index ProvNum_2 on schedule ... CREATE INDEX ProvNum_2 ON schedule ( ProvNum ) ; PROMPT Creating Index SchedDate on schedule ... CREATE INDEX SchedDate ON schedule ( SchedDate ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON schedule TO PUBLIC; -- DROP TABLE scheduleop CASCADE CONSTRAINTS; PROMPT Creating Table scheduleop ... CREATE TABLE scheduleop ( ScheduleOpNum NUMBER(20) NOT NULL, ScheduleNum NUMBER(20) NOT NULL, OperatoryNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_16 on table scheduleop ... ALTER TABLE scheduleop ADD CONSTRAINT PRIMARY_16 PRIMARY KEY ( ScheduleOpNum ) ENABLE ; PROMPT Creating Index ScheduleNum on scheduleop ... CREATE INDEX ScheduleNum ON scheduleop ( ScheduleNum ) ; PROMPT Creating Index OperatoryNum on scheduleop ... CREATE INDEX OperatoryNum ON scheduleop ( OperatoryNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON scheduleop TO PUBLIC; -- DROP TABLE school CASCADE CONSTRAINTS; PROMPT Creating Table school ... CREATE TABLE school ( SchoolNum NUMBER(20) NOT NULL, SchoolName VARCHAR2(255 CHAR), SchoolCode VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_17 on table school ... ALTER TABLE school ADD CONSTRAINT PRIMARY_17 PRIMARY KEY ( SchoolNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON school TO PUBLIC; -- DROP TABLE schoolclass CASCADE CONSTRAINTS; PROMPT Creating Table schoolclass ... CREATE TABLE schoolclass ( SchoolClassNum NUMBER(20) NOT NULL, GradYear NUMBER(11) NOT NULL, Descript VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_125 on table schoolclass ... ALTER TABLE schoolclass ADD CONSTRAINT PRIMARY_125 PRIMARY KEY ( SchoolClassNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON schoolclass TO PUBLIC; -- DROP TABLE schoolcourse CASCADE CONSTRAINTS; PROMPT Creating Table schoolcourse ... CREATE TABLE schoolcourse ( SchoolCourseNum NUMBER(20) NOT NULL, CourseID VARCHAR2(255 CHAR), Descript VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_175 on table schoolcourse ... ALTER TABLE schoolcourse ADD CONSTRAINT PRIMARY_175 PRIMARY KEY ( SchoolCourseNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON schoolcourse TO PUBLIC; -- DROP TABLE screen CASCADE CONSTRAINTS; PROMPT Creating Table screen ... CREATE TABLE screen ( ScreenNum NUMBER(20) NOT NULL, ScreenDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, GradeSchool VARCHAR2(255 CHAR), County VARCHAR2(255 CHAR), PlaceService NUMBER(3) DEFAULT '0' NOT NULL, ProvNum NUMBER(20) NOT NULL, ProvName VARCHAR2(255 CHAR), Gender NUMBER(3) DEFAULT '0' NOT NULL, Race NUMBER(4) DEFAULT '0' NOT NULL, GradeLevel NUMBER(4) DEFAULT '0' NOT NULL, Age NUMBER(3) DEFAULT '0' NOT NULL, Urgency NUMBER(4) DEFAULT '0' NOT NULL, HasCaries NUMBER(3) DEFAULT '0' NOT NULL, NeedsSealants NUMBER(3) DEFAULT '0' NOT NULL, CariesExperience NUMBER(3) DEFAULT '0' NOT NULL, EarlyChildCaries NUMBER(3) DEFAULT '0' NOT NULL, ExistingSealants NUMBER(3) DEFAULT '0' NOT NULL, MissingAllTeeth NUMBER(3) DEFAULT '0' NOT NULL, Birthdate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, ScreenGroupNum NUMBER(20) NOT NULL, ScreenGroupOrder NUMBER(5) DEFAULT '0' NOT NULL, Comments VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_37 on table screen ... ALTER TABLE screen ADD CONSTRAINT PRIMARY_37 PRIMARY KEY ( ScreenNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON screen TO PUBLIC; -- DROP TABLE screengroup CASCADE CONSTRAINTS; PROMPT Creating Table screengroup ... CREATE TABLE screengroup ( ScreenGroupNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), SGDate DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_82 on table screengroup ... ALTER TABLE screengroup ADD CONSTRAINT PRIMARY_82 PRIMARY KEY ( ScreenGroupNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON screengroup TO PUBLIC; -- DROP TABLE securitylog CASCADE CONSTRAINTS; PROMPT Creating Table securitylog ... CREATE TABLE securitylog ( SecurityLogNum NUMBER(20) NOT NULL, PermType NUMBER(3) DEFAULT '0' NOT NULL, UserNum NUMBER(20) NOT NULL, LogDateTime DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, LogText VARCHAR2(4000 CHAR), PatNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_83 on table securitylog ... ALTER TABLE securitylog ADD CONSTRAINT PRIMARY_83 PRIMARY KEY ( SecurityLogNum ) ENABLE ; PROMPT Creating Index PatNum_6 on securitylog ... CREATE INDEX PatNum_6 ON securitylog ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON securitylog TO PUBLIC; -- DROP TABLE sheet CASCADE CONSTRAINTS; PROMPT Creating Table sheet ... CREATE TABLE sheet ( SheetNum NUMBER(20) NOT NULL, SheetType NUMBER(11) NOT NULL, PatNum NUMBER(20) NOT NULL, DateTimeSheet DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, FontSize NUMBER(38,8) NOT NULL, FontName VARCHAR2(255 CHAR), Width NUMBER(11) NOT NULL, Height NUMBER(11) NOT NULL, IsLandscape NUMBER(4) NOT NULL, InternalNote VARCHAR2(4000 CHAR), Description VARCHAR2(255 CHAR), ShowInTerminal NUMBER(4) NOT NULL, IsWebForm NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_18 on table sheet ... ALTER TABLE sheet ADD CONSTRAINT PRIMARY_18 PRIMARY KEY ( SheetNum ) ENABLE ; PROMPT Creating Index PatNum_2 on sheet ... CREATE INDEX PatNum_2 ON sheet ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sheet TO PUBLIC; -- DROP TABLE sheetdef CASCADE CONSTRAINTS; PROMPT Creating Table sheetdef ... CREATE TABLE sheetdef ( SheetDefNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), SheetType NUMBER(11) NOT NULL, FontSize NUMBER(38,8) NOT NULL, FontName VARCHAR2(255 CHAR), Width NUMBER(11) NOT NULL, Height NUMBER(11) NOT NULL, IsLandscape NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_60 on table sheetdef ... ALTER TABLE sheetdef ADD CONSTRAINT PRIMARY_60 PRIMARY KEY ( SheetDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sheetdef TO PUBLIC; -- DROP TABLE sheetfield CASCADE CONSTRAINTS; PROMPT Creating Table sheetfield ... CREATE TABLE sheetfield ( SheetFieldNum NUMBER(20) NOT NULL, SheetNum NUMBER(20) NOT NULL, FieldType NUMBER(11) NOT NULL, FieldName VARCHAR2(255 CHAR), FieldValue CLOB, FontSize NUMBER(38,8) NOT NULL, FontName VARCHAR2(255 CHAR), FontIsBold NUMBER(4) NOT NULL, XPos NUMBER(11) NOT NULL, YPos NUMBER(11) NOT NULL, Width NUMBER(11) NOT NULL, Height NUMBER(11) NOT NULL, GrowthBehavior NUMBER(11) NOT NULL, RadioButtonValue VARCHAR2(255 CHAR), RadioButtonGroup VARCHAR2(255 CHAR), IsRequired NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_38 on table sheetfield ... ALTER TABLE sheetfield ADD CONSTRAINT PRIMARY_38 PRIMARY KEY ( SheetFieldNum ) ENABLE ; PROMPT Creating Index SheetNum on sheetfield ... CREATE INDEX SheetNum ON sheetfield ( SheetNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sheetfield TO PUBLIC; -- DROP TABLE sheetfielddef CASCADE CONSTRAINTS; PROMPT Creating Table sheetfielddef ... CREATE TABLE sheetfielddef ( SheetFieldDefNum NUMBER(20) NOT NULL, SheetDefNum NUMBER(20) NOT NULL, FieldType NUMBER(11) NOT NULL, FieldName VARCHAR2(255 CHAR), FieldValue CLOB, FontSize NUMBER(38,8) NOT NULL, FontName VARCHAR2(255 CHAR), FontIsBold NUMBER(4) NOT NULL, XPos NUMBER(11) NOT NULL, YPos NUMBER(11) NOT NULL, Width NUMBER(11) NOT NULL, Height NUMBER(11) NOT NULL, GrowthBehavior NUMBER(11) NOT NULL, RadioButtonValue VARCHAR2(255 CHAR), RadioButtonGroup VARCHAR2(255 CHAR), IsRequired NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_152 on table sheetfielddef ... ALTER TABLE sheetfielddef ADD CONSTRAINT PRIMARY_152 PRIMARY KEY ( SheetFieldDefNum ) ENABLE ; PROMPT Creating Index SheetDefNum on sheetfielddef ... CREATE INDEX SheetDefNum ON sheetfielddef ( SheetDefNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sheetfielddef TO PUBLIC; -- DROP TABLE sigbutdef CASCADE CONSTRAINTS; PROMPT Creating Table sigbutdef ... CREATE TABLE sigbutdef ( SigButDefNum NUMBER(20) NOT NULL, ButtonText VARCHAR2(255 CHAR), ButtonIndex NUMBER(6) NOT NULL, SynchIcon NUMBER(3) NOT NULL, ComputerName VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_84 on table sigbutdef ... ALTER TABLE sigbutdef ADD CONSTRAINT PRIMARY_84 PRIMARY KEY ( SigButDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sigbutdef TO PUBLIC; -- DROP TABLE sigbutdefelement CASCADE CONSTRAINTS; PROMPT Creating Table sigbutdefelement ... CREATE TABLE sigbutdefelement ( ElementNum NUMBER(20) NOT NULL, SigButDefNum NUMBER(20) NOT NULL, SigElementDefNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_102 on table sigbutdefelement ... ALTER TABLE sigbutdefelement ADD CONSTRAINT PRIMARY_102 PRIMARY KEY ( ElementNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sigbutdefelement TO PUBLIC; -- DROP TABLE sigelement CASCADE CONSTRAINTS; PROMPT Creating Table sigelement ... CREATE TABLE sigelement ( SigElementNum NUMBER(20) NOT NULL, SigElementDefNum NUMBER(20) NOT NULL, SignalNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_61 on table sigelement ... ALTER TABLE sigelement ADD CONSTRAINT PRIMARY_61 PRIMARY KEY ( SigElementNum ) ENABLE ; PROMPT Creating Index SignalNum on sigelement ... CREATE INDEX SignalNum ON sigelement ( SignalNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sigelement TO PUBLIC; -- DROP TABLE sigelementdef CASCADE CONSTRAINTS; PROMPT Creating Table sigelementdef ... CREATE TABLE sigelementdef ( SigElementDefNum NUMBER(20) NOT NULL, LightRow NUMBER(3) NOT NULL, LightColor NUMBER(11) NOT NULL, SigElementType NUMBER(3) NOT NULL, SigText VARCHAR2(255 CHAR), Sound CLOB, ItemOrder NUMBER(6) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_39 on table sigelementdef ... ALTER TABLE sigelementdef ADD CONSTRAINT PRIMARY_39 PRIMARY KEY ( SigElementDefNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON sigelementdef TO PUBLIC; -- DROP TABLE signal CASCADE CONSTRAINTS; PROMPT Creating Table signal ... CREATE TABLE signal ( SignalNum NUMBER(20) NOT NULL, FromUser VARCHAR2(255 CHAR), ITypes VARCHAR2(4000 CHAR), DateViewing DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, SigType NUMBER(3) DEFAULT '0' NOT NULL, SigText VARCHAR2(4000 CHAR), SigDateTime DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, ToUser VARCHAR2(255 CHAR), AckTime DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL, TaskNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_103 on table signal ... ALTER TABLE signal ADD CONSTRAINT PRIMARY_103 PRIMARY KEY ( SignalNum ) ENABLE ; PROMPT Creating Index indexSigDateTime on signal ... CREATE INDEX indexSigDateTime ON signal ( SigDateTime ) ; PROMPT Creating Index indexAckTime on signal ... CREATE INDEX indexAckTime ON signal ( AckTime ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON signal TO PUBLIC; -- DROP TABLE site CASCADE CONSTRAINTS; PROMPT Creating Table site ... CREATE TABLE site ( SiteNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), Note VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_176 on table site ... ALTER TABLE site ADD CONSTRAINT PRIMARY_176 PRIMARY KEY ( SiteNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON site TO PUBLIC; -- DROP TABLE statement CASCADE CONSTRAINTS; PROMPT Creating Table statement ... CREATE TABLE statement ( StatementNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, DateSent DATE NOT NULL, DateRangeFrom DATE NOT NULL, DateRangeTo DATE NOT NULL, Note VARCHAR2(4000 CHAR), NoteBold VARCHAR2(4000 CHAR), Mode_ NUMBER(3) NOT NULL, HidePayment NUMBER(1) NOT NULL, SinglePatient NUMBER(1) NOT NULL, Intermingled NUMBER(1) NOT NULL, IsSent NUMBER(1) NOT NULL, DocNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_177 on table statement ... ALTER TABLE statement ADD CONSTRAINT PRIMARY_177 PRIMARY KEY ( StatementNum ) ENABLE ; PROMPT Creating Index PatNum_8 on statement ... CREATE INDEX PatNum_8 ON statement ( PatNum ) ; PROMPT Creating Index DocNum on statement ... CREATE INDEX DocNum ON statement ( DocNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON statement TO PUBLIC; -- DROP TABLE supplier CASCADE CONSTRAINTS; PROMPT Creating Table supplier ... CREATE TABLE supplier ( SupplierNum NUMBER(20) NOT NULL, Name VARCHAR2(255 CHAR), Phone VARCHAR2(255 CHAR), CustomerId VARCHAR2(255 CHAR), Website VARCHAR2(4000 CHAR), UserName VARCHAR2(255 CHAR), Password VARCHAR2(255 CHAR), Note VARCHAR2(4000 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_153 on table supplier ... ALTER TABLE supplier ADD CONSTRAINT PRIMARY_153 PRIMARY KEY ( SupplierNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON supplier TO PUBLIC; -- DROP TABLE supply CASCADE CONSTRAINTS; PROMPT Creating Table supply ... CREATE TABLE supply ( SupplyNum NUMBER(20) NOT NULL, SupplierNum NUMBER(20) NOT NULL, CatalogNumber VARCHAR2(255 CHAR), Descript VARCHAR2(255 CHAR), Category NUMBER(20) NOT NULL, ItemOrder NUMBER(11) NOT NULL, LevelDesired NUMBER(38,8) NOT NULL, IsHidden NUMBER(1) NOT NULL, Price NUMBER(38,8) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_178 on table supply ... ALTER TABLE supply ADD CONSTRAINT PRIMARY_178 PRIMARY KEY ( SupplyNum ) ENABLE ; PROMPT Creating Index SupplierNum on supply ... CREATE INDEX SupplierNum ON supply ( SupplierNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON supply TO PUBLIC; -- DROP TABLE supplyneeded CASCADE CONSTRAINTS; PROMPT Creating Table supplyneeded ... CREATE TABLE supplyneeded ( SupplyNeededNum NUMBER(20) NOT NULL, Description VARCHAR2(4000 CHAR), DateAdded DATE NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_179 on table supplyneeded ... ALTER TABLE supplyneeded ADD CONSTRAINT PRIMARY_179 PRIMARY KEY ( SupplyNeededNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON supplyneeded TO PUBLIC; -- DROP TABLE supplyorder CASCADE CONSTRAINTS; PROMPT Creating Table supplyorder ... CREATE TABLE supplyorder ( SupplyOrderNum NUMBER(20) NOT NULL, SupplierNum NUMBER(20) NOT NULL, DatePlaced DATE NOT NULL, Note VARCHAR2(4000 CHAR), AmountTotal NUMBER(38,8) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_62 on table supplyorder ... ALTER TABLE supplyorder ADD CONSTRAINT PRIMARY_62 PRIMARY KEY ( SupplyOrderNum ) ENABLE ; PROMPT Creating Index SupplierNum_1 on supplyorder ... CREATE INDEX SupplierNum_1 ON supplyorder ( SupplierNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON supplyorder TO PUBLIC; -- DROP TABLE supplyorderitem CASCADE CONSTRAINTS; PROMPT Creating Table supplyorderitem ... CREATE TABLE supplyorderitem ( SupplyOrderItemNum NUMBER(20) NOT NULL, SupplyOrderNum NUMBER(20) NOT NULL, SupplyNum NUMBER(20) NOT NULL, Qty NUMBER(11) NOT NULL, Price NUMBER(38,8) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_63 on table supplyorderitem ... ALTER TABLE supplyorderitem ADD CONSTRAINT PRIMARY_63 PRIMARY KEY ( SupplyOrderItemNum ) ENABLE ; PROMPT Creating Index SupplyOrderNum on supplyorderitem ... CREATE INDEX SupplyOrderNum ON supplyorderitem ( SupplyOrderNum ) ; PROMPT Creating Index SupplyNum on supplyorderitem ... CREATE INDEX SupplyNum ON supplyorderitem ( SupplyNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON supplyorderitem TO PUBLIC; -- DROP TABLE task CASCADE CONSTRAINTS; PROMPT Creating Table task ... CREATE TABLE task ( TaskNum NUMBER(20) NOT NULL, TaskListNum NUMBER(20) NOT NULL, DateTask DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, KeyNum NUMBER(20) NOT NULL, Descript CLOB, TaskStatus NUMBER(3) DEFAULT '0' NOT NULL, IsRepeating NUMBER(3) DEFAULT '0' NOT NULL, DateType NUMBER(3) DEFAULT '0' NOT NULL, FromNum NUMBER(20) NOT NULL, ObjectType NUMBER(3) DEFAULT '0' NOT NULL, DateTimeEntry DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, UserNum NUMBER(20) NOT NULL, DateTimeFinished DATE NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_40 on table task ... ALTER TABLE task ADD CONSTRAINT PRIMARY_40 PRIMARY KEY ( TaskNum ) ENABLE ; PROMPT Creating Index indexTaskListNum on task ... CREATE INDEX indexTaskListNum ON task ( TaskListNum ) ; PROMPT Creating Index KeyNum on task ... CREATE INDEX KeyNum ON task ( KeyNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON task TO PUBLIC; -- DROP TABLE taskancestor CASCADE CONSTRAINTS; PROMPT Creating Table taskancestor ... CREATE TABLE taskancestor ( TaskAncestorNum NUMBER(20) NOT NULL, TaskNum NUMBER(20) NOT NULL, TaskListNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_19 on table taskancestor ... ALTER TABLE taskancestor ADD CONSTRAINT PRIMARY_19 PRIMARY KEY ( TaskAncestorNum ) ENABLE ; PROMPT Creating Index TaskNum_1 on taskancestor ... CREATE INDEX TaskNum_1 ON taskancestor ( TaskNum ) ; PROMPT Creating Index TaskListNum on taskancestor ... CREATE INDEX TaskListNum ON taskancestor ( TaskListNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON taskancestor TO PUBLIC; -- DROP TABLE tasklist CASCADE CONSTRAINTS; PROMPT Creating Table tasklist ... CREATE TABLE tasklist ( TaskListNum NUMBER(20) NOT NULL, Descript VARCHAR2(255 CHAR), Parent NUMBER(20) NOT NULL, DateTL DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, IsRepeating NUMBER(3) DEFAULT '0' NOT NULL, DateType NUMBER(3) DEFAULT '0' NOT NULL, FromNum NUMBER(20) NOT NULL, ObjectType NUMBER(3) DEFAULT '0' NOT NULL, DateTimeEntry DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_41 on table tasklist ... ALTER TABLE tasklist ADD CONSTRAINT PRIMARY_41 PRIMARY KEY ( TaskListNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON tasklist TO PUBLIC; -- DROP TABLE tasksubscription CASCADE CONSTRAINTS; PROMPT Creating Table tasksubscription ... CREATE TABLE tasksubscription ( TaskSubscriptionNum NUMBER(20) NOT NULL, UserNum NUMBER(20) NOT NULL, TaskListNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_85 on table tasksubscription ... ALTER TABLE tasksubscription ADD CONSTRAINT PRIMARY_85 PRIMARY KEY ( TaskSubscriptionNum ) ENABLE ; PROMPT Creating Index UserNum_2 on tasksubscription ... CREATE INDEX UserNum_2 ON tasksubscription ( UserNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON tasksubscription TO PUBLIC; -- DROP TABLE taskunread CASCADE CONSTRAINTS; PROMPT Creating Table taskunread ... CREATE TABLE taskunread ( TaskUnreadNum NUMBER(20) NOT NULL, TaskNum NUMBER(20) NOT NULL, UserNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_154 on table taskunread ... ALTER TABLE taskunread ADD CONSTRAINT PRIMARY_154 PRIMARY KEY ( TaskUnreadNum ) ENABLE ; PROMPT Creating Index TaskNum on taskunread ... CREATE INDEX TaskNum ON taskunread ( TaskNum ) ; PROMPT Creating Index UserNum_1 on taskunread ... CREATE INDEX UserNum_1 ON taskunread ( UserNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON taskunread TO PUBLIC; -- DROP TABLE terminalactive CASCADE CONSTRAINTS; PROMPT Creating Table terminalactive ... CREATE TABLE terminalactive ( TerminalActiveNum NUMBER(20) NOT NULL, ComputerName VARCHAR2(255 CHAR), TerminalStatus NUMBER(3) NOT NULL, PatNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_126 on table terminalactive ... ALTER TABLE terminalactive ADD CONSTRAINT PRIMARY_126 PRIMARY KEY ( TerminalActiveNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON terminalactive TO PUBLIC; -- DROP TABLE timeadjust CASCADE CONSTRAINTS; PROMPT Creating Table timeadjust ... CREATE TABLE timeadjust ( TimeAdjustNum NUMBER(20) NOT NULL, EmployeeNum NUMBER(20) NOT NULL, TimeEntry DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, RegHours VARCHAR2(4000) NOT NULL, OTimeHours VARCHAR2(4000) NOT NULL, Note VARCHAR2(4000 CHAR), IsAuto NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_20 on table timeadjust ... ALTER TABLE timeadjust ADD CONSTRAINT PRIMARY_20 PRIMARY KEY ( TimeAdjustNum ) ENABLE ; PROMPT Creating Index indexEmployeeNum on timeadjust ... CREATE INDEX indexEmployeeNum ON timeadjust ( EmployeeNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON timeadjust TO PUBLIC; -- DROP TABLE timecardrule CASCADE CONSTRAINTS; PROMPT Creating Table timecardrule ... CREATE TABLE timecardrule ( TimeCardRuleNum NUMBER(20) NOT NULL, EmployeeNum NUMBER(20) NOT NULL, OverHoursPerDay DATE NOT NULL, AfterTimeOfDay DATE NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_64 on table timecardrule ... ALTER TABLE timecardrule ADD CONSTRAINT PRIMARY_64 PRIMARY KEY ( TimeCardRuleNum ) ENABLE ; PROMPT Creating Index EmployeeNum on timecardrule ... CREATE INDEX EmployeeNum ON timecardrule ( EmployeeNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON timecardrule TO PUBLIC; -- DROP TABLE toolbutitem CASCADE CONSTRAINTS; PROMPT Creating Table toolbutitem ... CREATE TABLE toolbutitem ( ToolButItemNum NUMBER(20) NOT NULL, ProgramNum NUMBER(20) NOT NULL, ToolBar NUMBER(5) DEFAULT '0' NOT NULL, ButtonText VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_42 on table toolbutitem ... ALTER TABLE toolbutitem ADD CONSTRAINT PRIMARY_42 PRIMARY KEY ( ToolButItemNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON toolbutitem TO PUBLIC; -- DROP TABLE toothinitial CASCADE CONSTRAINTS; PROMPT Creating Table toothinitial ... CREATE TABLE toothinitial ( ToothInitialNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, ToothNum VARCHAR2(2 CHAR), InitialType NUMBER(3) DEFAULT '0' NOT NULL, Movement NUMBER(38,8) DEFAULT '0' NOT NULL, DrawingSegment VARCHAR2(4000 CHAR), ColorDraw NUMBER(11) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_180 on table toothinitial ... ALTER TABLE toothinitial ADD CONSTRAINT PRIMARY_180 PRIMARY KEY ( ToothInitialNum ) ENABLE ; PROMPT Creating Index PatNum_9 on toothinitial ... CREATE INDEX PatNum_9 ON toothinitial ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON toothinitial TO PUBLIC; -- DROP TABLE transaction CASCADE CONSTRAINTS; PROMPT Creating Table transaction ... CREATE TABLE transaction ( TransactionNum NUMBER(20) NOT NULL, DateTimeEntry DATE DEFAULT to_date('0001-01-01 00:00:00', 'yyyy-mm-dd HH24:mi:ss') NOT NULL, UserNum NUMBER(20) NOT NULL, DepositNum NUMBER(20) NOT NULL, PayNum NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_127 on table transaction ... ALTER TABLE transaction ADD CONSTRAINT PRIMARY_127 PRIMARY KEY ( TransactionNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON transaction TO PUBLIC; -- DROP TABLE treatplan CASCADE CONSTRAINTS; PROMPT Creating Table treatplan ... CREATE TABLE treatplan ( TreatPlanNum NUMBER(20) NOT NULL, PatNum NUMBER(20) NOT NULL, DateTP DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL, Heading VARCHAR2(255 CHAR), Note VARCHAR2(4000 CHAR), Signature VARCHAR2(4000 CHAR), SigIsTopaz NUMBER(1) NOT NULL, ResponsParty NUMBER(20) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_65 on table treatplan ... ALTER TABLE treatplan ADD CONSTRAINT PRIMARY_65 PRIMARY KEY ( TreatPlanNum ) ENABLE ; PROMPT Creating Index indexPatNum_13 on treatplan ... CREATE INDEX indexPatNum_13 ON treatplan ( PatNum ) ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON treatplan TO PUBLIC; -- DROP TABLE usergroup CASCADE CONSTRAINTS; PROMPT Creating Table usergroup ... CREATE TABLE usergroup ( UserGroupNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR) ); PROMPT Creating Primary Key Constraint PRIMARY_181 on table usergroup ... ALTER TABLE usergroup ADD CONSTRAINT PRIMARY_181 PRIMARY KEY ( UserGroupNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON usergroup TO PUBLIC; -- DROP TABLE userod CASCADE CONSTRAINTS; PROMPT Creating Table userod ... CREATE TABLE userod ( UserNum NUMBER(20) NOT NULL, UserName VARCHAR2(255 CHAR), Password VARCHAR2(255 CHAR), UserGroupNum NUMBER(20) NOT NULL, EmployeeNum NUMBER(20) NOT NULL, ClinicNum NUMBER(20) NOT NULL, ProvNum NUMBER(20) NOT NULL, IsHidden NUMBER(1) NOT NULL, TaskListInBox NUMBER(20) NOT NULL, AnesthProvType NUMBER(2) DEFAULT '3' NOT NULL, DefaultHidePopups NUMBER(4) NOT NULL, PasswordIsStrong NUMBER(4) NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_21 on table userod ... ALTER TABLE userod ADD CONSTRAINT PRIMARY_21 PRIMARY KEY ( UserNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON userod TO PUBLIC; -- DROP TABLE userquery CASCADE CONSTRAINTS; PROMPT Creating Table userquery ... CREATE TABLE userquery ( QueryNum NUMBER(20) NOT NULL, Description VARCHAR2(255 CHAR), FileName VARCHAR2(255 CHAR), QueryText CLOB ); PROMPT Creating Primary Key Constraint PRIMARY_43 on table userquery ... ALTER TABLE userquery ADD CONSTRAINT PRIMARY_43 PRIMARY KEY ( QueryNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON userquery TO PUBLIC; -- DROP TABLE zipcode CASCADE CONSTRAINTS; PROMPT Creating Table zipcode ... CREATE TABLE zipcode ( ZipCodeNum NUMBER(20) NOT NULL, ZipCodeDigits VARCHAR2(20 CHAR), City VARCHAR2(100 CHAR), State VARCHAR2(20 CHAR), IsFrequent NUMBER(1) DEFAULT '0' NOT NULL ); PROMPT Creating Primary Key Constraint PRIMARY_128 on table zipcode ... ALTER TABLE zipcode ADD CONSTRAINT PRIMARY_128 PRIMARY KEY ( ZipCodeNum ) ENABLE ; GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON zipcode TO PUBLIC; --Manually created triggers for updating 'timestamp' data types in Oracle. --This will never be needed again because it will be automated in the code. CREATE OR REPLACE TRIGGER appointment_timestamp BEFORE UPDATE ON appointment FOR EACH ROW BEGIN IF :OLD.PatNum <> :NEW.PatNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AptStatus <> :NEW.AptStatus THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Pattern <> :NEW.Pattern THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Confirmed <> :NEW.Confirmed THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.TimeLocked <> :NEW.TimeLocked THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Op <> :NEW.Op THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Note <> :NEW.Note THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProvNum <> :NEW.ProvNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProvHyg <> :NEW.ProvHyg THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AptDateTime <> :NEW.AptDateTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.NextAptNum <> :NEW.NextAptNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.UnschedStatus <> :NEW.UnschedStatus THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsNewPatient <> :NEW.IsNewPatient THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcDescript <> :NEW.ProcDescript THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Assistant <> :NEW.Assistant THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ClinicNum <> :NEW.ClinicNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsHygiene <> :NEW.IsHygiene THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTimeArrived <> :NEW.DateTimeArrived THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTimeSeated <> :NEW.DateTimeSeated THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTimeDismissed <> :NEW.DateTimeDismissed THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.InsPlan1 <> :NEW.InsPlan1 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.InsPlan2 <> :NEW.InsPlan2 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTimeAskedToArrive <> :NEW.DateTimeAskedToArrive THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcsColored <> :NEW.ProcsColored THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; END appointment_timestamp; / CREATE OR REPLACE TRIGGER commlog_timestamp BEFORE UPDATE ON commlog FOR EACH ROW BEGIN IF :OLD.PatNum <> :NEW.PatNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CommDateTime <> :NEW.CommDateTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CommType <> :NEW.CommType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Note <> :NEW.Note THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Mode_ <> :NEW.Mode_ THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SentOrReceived <> :NEW.SentOrReceived THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsStatementSent <> :NEW.IsStatementSent THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.UserNum <> :NEW.UserNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Signature <> :NEW.Signature THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SigIsTopaz <> :NEW.SigIsTopaz THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; END commlog_timestamp; / CREATE OR REPLACE TRIGGER deletedobject_timestamp BEFORE UPDATE ON deletedobject FOR EACH ROW BEGIN IF :OLD.ObjectNum <> :NEW.ObjectNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ObjectType <> :NEW.ObjectType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; END deletedobject_timespan; / CREATE OR REPLACE TRIGGER document_timestamp BEFORE UPDATE ON document FOR EACH ROW BEGIN IF :OLD.Description <> :NEW.Description THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateCreated <> :NEW.DateCreated THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DocCategory <> :NEW.DocCategory THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PatNum <> :NEW.PatNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.FileName <> :NEW.FileName THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ImgType <> :NEW.ImgType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsFlipped <> :NEW.IsFlipped THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DegreesRotated <> :NEW.DegreesRotated THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ToothNumbers <> :NEW.ToothNumbers THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Note <> :NEW.Note THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SigIsTopaz <> :NEW.SigIsTopaz THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Signature <> :NEW.Signature THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CropX <> :NEW.CropX THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CropY <> :NEW.CropY THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CropW <> :NEW.CropW THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CropH <> :NEW.CropH THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.WindowingMin <> :NEW.WindowingMin THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.WindowingMax <> :NEW.WindowingMax THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MountItemNum <> :NEW.MountItemNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; END document_timestamp; / CREATE OR REPLACE TRIGGER operatory_timestamp BEFORE UPDATE ON operatory FOR EACH ROW BEGIN IF :OLD.OpName <> :NEW.OpName THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Abbrev <> :NEW.Abbrev THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ItemOrder <> :NEW.ItemOrder THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsHidden <> :NEW.IsHidden THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProvDentist <> :NEW.ProvDentist THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProvHygienist <> :NEW.ProvHygienist THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsHygiene <> :NEW.IsHygiene THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ClinicNum <> :NEW.ClinicNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SetProspective <> :NEW.SetProspective THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; END operatory_timestamp; / CREATE OR REPLACE TRIGGER patient_timestamp BEFORE UPDATE ON patient FOR EACH ROW BEGIN IF :OLD.LName <> :NEW.LName THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.FName <> :NEW.FName THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MiddleI <> :NEW.MiddleI THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Preferred <> :NEW.Preferred THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PatStatus <> :NEW.PatStatus THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Gender <> :NEW.Gender THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Position <> :NEW.Position THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Birthdate <> :NEW.Birthdate THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SSN <> :NEW.SSN THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Address <> :NEW.Address THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Address2 <> :NEW.Address2 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.City <> :NEW.City THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.State <> :NEW.State THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Zip <> :NEW.Zip THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.HmPhone <> :NEW.HmPhone THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.WkPhone <> :NEW.WkPhone THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.WirelessPhone <> :NEW.WirelessPhone THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Guarantor <> :NEW.Guarantor THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CreditType <> :NEW.CreditType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Email <> :NEW.Email THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Salutation <> :NEW.Salutation THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.EstBalance <> :NEW.EstBalance THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PriProv <> :NEW.PriProv THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SecProv <> :NEW.SecProv THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.FeeSched <> :NEW.FeeSched THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BillingType <> :NEW.BillingType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ImageFolder <> :NEW.ImageFolder THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AddrNote <> :NEW.AddrNote THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.FamFinUrgNote <> :NEW.FamFinUrgNote THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MedUrgNote <> :NEW.MedUrgNote THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ApptModNote <> :NEW.ApptModNote THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.StudentStatus <> :NEW.StudentStatus THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SchoolName <> :NEW.SchoolName THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ChartNumber <> :NEW.ChartNumber THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MedicaidID <> :NEW.MedicaidID THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Bal_0_30 <> :NEW.Bal_0_30 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Bal_31_60 <> :NEW.Bal_31_60 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Bal_61_90 <> :NEW.Bal_61_90 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BalOver90 <> :NEW.BalOver90 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.InsEst <> :NEW.InsEst THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BalTotal <> :NEW.BalTotal THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.EmployerNum <> :NEW.EmployerNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.EmploymentNote <> :NEW.EmploymentNote THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Race <> :NEW.Race THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.County <> :NEW.County THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.GradeLevel <> :NEW.GradeLevel THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Urgency <> :NEW.Urgency THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateFirstVisit <> :NEW.DateFirstVisit THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ClinicNum <> :NEW.ClinicNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.HasIns <> :NEW.HasIns THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.TrophyFolder <> :NEW.TrophyFolder THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PlannedIsDone <> :NEW.PlannedIsDone THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Premed <> :NEW.Premed THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Ward <> :NEW.Ward THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PreferConfirmMethod <> :NEW.PreferConfirmMethod THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PreferContactMethod <> :NEW.PreferContactMethod THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PreferRecallMethod <> :NEW.PreferRecallMethod THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SchedBeforeTime <> :NEW.SchedBeforeTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SchedAfterTime <> :NEW.SchedAfterTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SchedDayOfWeek <> :NEW.SchedDayOfWeek THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Language <> :NEW.Language THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AdmitDate <> :NEW.AdmitDate THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Title <> :NEW.Title THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PayPlanDue <> :NEW.PayPlanDue THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SiteNum <> :NEW.SiteNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ResponsParty <> :NEW.ResponsParty THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CanadianEligibilityCode <> :NEW.CanadianEligibilityCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AskToArriveEarly <> :NEW.AskToArriveEarly THEN :NEW.DateTStamp := SYSDATE; END IF; END patient_timestamp; / CREATE OR REPLACE TRIGGER procedurecode_timestamp BEFORE UPDATE ON procedurecode FOR EACH ROW BEGIN IF :OLD.ProcCode <> :NEW.ProcCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Descript <> :NEW.Descript THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AbbrDesc <> :NEW.AbbrDesc THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcTime <> :NEW.ProcTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcCat <> :NEW.ProcCat THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.TreatArea <> :NEW.TreatArea THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.NoBillIns <> :NEW.NoBillIns THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsProsth <> :NEW.IsProsth THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DefaultNote <> :NEW.DefaultNote THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsHygiene <> :NEW.IsHygiene THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.GTypeNum <> :NEW.GTypeNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AlternateCode1 <> :NEW.AlternateCode1 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MedicalCode <> :NEW.MedicalCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsTaxed <> :NEW.IsTaxed THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PaintType <> :NEW.PaintType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.GraphicColor <> :NEW.GraphicColor THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.LaymanTerm <> :NEW.LaymanTerm THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsCanadianLab <> :NEW.IsCanadianLab THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PreExisting <> :NEW.PreExisting THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BaseUnits <> :NEW.BaseUnits THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SubstitutionCode <> :NEW.SubstitutionCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SubstOnlyIf <> :NEW.SubstOnlyIf THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsMultiVisit <> :NEW.IsMultiVisit THEN :NEW.DateTStamp := SYSDATE; END IF; END procedurecode_timestamp; / CREATE OR REPLACE TRIGGER procedurelog_timestamp BEFORE UPDATE ON procedurelog FOR EACH ROW BEGIN IF :OLD.PatNum <> :NEW.PatNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AptNum <> :NEW.AptNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.OldCode <> :NEW.OldCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcDate <> :NEW.ProcDate THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcFee <> :NEW.ProcFee THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Surf <> :NEW.Surf THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ToothNum <> :NEW.ToothNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ToothRange <> :NEW.ToothRange THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Priority <> :NEW.Priority THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcStatus <> :NEW.ProcStatus THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProvNum <> :NEW.ProvNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Dx <> :NEW.Dx THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PlannedAptNum <> :NEW.PlannedAptNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.PlaceService <> :NEW.PlaceService THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Prosthesis <> :NEW.Prosthesis THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateOriginalProsth <> :NEW.DateOriginalProsth THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ClaimNote <> :NEW.ClaimNote THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateEntryC <> :NEW.DateEntryC THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ClinicNum <> :NEW.ClinicNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MedicalCode <> :NEW.MedicalCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DiagnosticCode <> :NEW.DiagnosticCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsPrincDiag <> :NEW.IsPrincDiag THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcNumLab <> :NEW.ProcNumLab THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BillingTypeOne <> :NEW.BillingTypeOne THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BillingTypeTwo <> :NEW.BillingTypeTwo THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CodeNum <> :NEW.CodeNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CodeMod1 <> :NEW.CodeMod1 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CodeMod2 <> :NEW.CodeMod2 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CodeMod3 <> :NEW.CodeMod3 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CodeMod4 <> :NEW.CodeMod4 THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.RevCode <> :NEW.RevCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.UnitCode <> :NEW.UnitCode THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.UnitQty <> :NEW.UnitQty THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BaseUnits <> :NEW.BaseUnits THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.StartTime <> :NEW.StartTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.StopTime <> :NEW.StopTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTP <> :NEW.DateTP THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SiteNum <> :NEW.SiteNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.HideGraphics <> :NEW.HideGraphics THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CanadianTypeCodes <> :NEW.CanadianTypeCodes THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcTime <> :NEW.ProcTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProcTimeEnd <> :NEW.ProcTimeEnd THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; END procedurelog_timestamp; / CREATE OR REPLACE TRIGGER provider_timestamp BEFORE UPDATE ON provider FOR EACH ROW BEGIN IF :OLD.Abbr <> :NEW.Abbr THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ItemOrder <> :NEW.ItemOrder THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.LName <> :NEW.LName THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.FName <> :NEW.FName THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MI <> :NEW.MI THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Suffix <> :NEW.Suffix THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.FeeSched <> :NEW.FeeSched THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Specialty <> :NEW.Specialty THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SSN <> :NEW.SSN THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.StateLicense <> :NEW.StateLicense THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DEANum <> :NEW.DEANum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsSecondary <> :NEW.IsSecondary THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProvColor <> :NEW.ProvColor THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsHidden <> :NEW.IsHidden THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.UsingTIN <> :NEW.UsingTIN THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BlueCrossID <> :NEW.BlueCrossID THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SigOnFile <> :NEW.SigOnFile THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.MedicaidID <> :NEW.MedicaidID THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.OutlineColor <> :NEW.OutlineColor THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SchoolClassNum <> :NEW.SchoolClassNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.NationalProvID <> :NEW.NationalProvID THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.CanadianOfficeNum <> :NEW.CanadianOfficeNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.AnesthProvType <> :NEW.AnesthProvType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.TaxonomyCodeOverride <> :NEW.TaxonomyCodeOverride THEN :NEW.DateTStamp := SYSDATE; END IF; END provider_timestamp; / CREATE OR REPLACE TRIGGER recall_timestamp BEFORE UPDATE ON recall FOR EACH ROW BEGIN IF :OLD.PatNum <> :NEW.PatNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateDueCalc <> :NEW.DateDueCalc THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateDue <> :NEW.DateDue THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DatePrevious <> :NEW.DatePrevious THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.RecallInterval <> :NEW.RecallInterval THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.RecallStatus <> :NEW.RecallStatus THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Note <> :NEW.Note THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.IsDisabled <> :NEW.IsDisabled THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.RecallTypeNum <> :NEW.RecallTypeNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DisableUntilBalance <> :NEW.DisableUntilBalance THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DisableUntilDate <> :NEW.DisableUntilDate THEN :NEW.DateTStamp := SYSDATE; END IF; END recall_timestamp; / CREATE OR REPLACE TRIGGER schedule_timestamp BEFORE UPDATE ON schedule FOR EACH ROW BEGIN IF :OLD.SchedDate <> :NEW.SchedDate THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.StartTime <> :NEW.StartTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.StopTime <> :NEW.StopTime THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.SchedType <> :NEW.SchedType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.ProvNum <> :NEW.ProvNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.BlockoutType <> :NEW.BlockoutType THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Note <> :NEW.Note THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.Status <> :NEW.Status THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.EmployeeNum <> :NEW.EmployeeNum THEN :NEW.DateTStamp := SYSDATE; END IF; IF :OLD.DateTStamp <> :NEW.DateTStamp THEN :NEW.DateTStamp := SYSDATE; END IF; END schedule_timestamp; / ALTER TABLE document ADD RawBase64 clob; ALTER TABLE document ADD Thumbnail clob; DISCONNECT;