V2.44 ERwi[ 2(( CHAR(18)X%KeyType%TableName %EntityName()Note ID Note Text 2Fill With SpacesspacesSet To Empty Stringempty Set To Nullnull Set To Zero0 Template Name" Template Code Template TypeTemplate CSX Id&PARENT UPDATE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT UPDATE RESTRICT */ if /* %%JoinPKPK(:%%Old,:%%New," <> "," or ") */ %JoinPKPK(:%Old,:%New," <> "," or ") then select count(*) into numrows from %Child where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); if (numrows > 0) then raise_application_error( -20005, 'Cannot UPDATE %Parent because %Child exists.' ); end if; end if; 'PARENT UPDATE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT UPDATE CASCADE */ if /* %%JoinPKPK(:%%Old,:%%New," <> "," or ") */ %JoinPKPK(:%Old,:%New," <> "," or ") then update %Child set /* %%JoinFKPK(%Child,:%%New," = ",",") */ %JoinFKPK(%Child,:%New," = ",",") where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); end if; 'PARENT UPDATE SET NULL /* %Parent %VerbPhrase %Child ON PARENT UPDATE SET NULL */ if /* %%JoinPKPK(:%%Old,:%%New," <> "," or " */ %JoinPKPK(:%Old,:%New," <> "," or ") then update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where /* %%JoinFKPK(%Child,:%%Old," = ",",") */ %JoinFKPK(%Child,:%Old," = "," and"); end if; 'PARENT DELETE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE RESTRICT */ select count(*) into numrows from %Child where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); if (numrows > 0) then raise_application_error( -20001, 'Cannot DELETE %Parent because %Child exists.' ); end if; 'PARENT DELETE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE CASCADE */ delete from %Child where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); 'PARENT DELETE SET NULL4 /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE SET NULL */ update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); 'CHILD INSERT RESTRICT" /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT RESTRICT */ select count(*) into numrows from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and"); if ( /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") numrows = 0 ) then raise_application_error( -20002, 'Cannot INSERT %Child because %Parent does not exist.' ); end if; 'CHILD INSERT CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT CASCADE */ insert into %Parent (%ParentPK(",",)) select %ChildFK(",",) from %Child where /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ); 'CHILD INSERT SETNULL /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT SET NULL */ update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ) and /* %%JoinPKPK(%Child,:%%New," = "," and") */ %JoinPKPK(%Child,:%New," = "," and"); 'CHILD UPDATE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE RESTRICT */ select count(*) into numrows from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and"); if ( /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") numrows = 0 ) then raise_application_error( -20007, 'Cannot UPDATE %Child because %Parent does not exist.' ); end if; 'CHILD UPDATE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE CASCADE */ insert into %Parent (%ParentPK(",",)) select %ChildFK(",",) from %Child where /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ); 'CHILD UPDATE SETNULL /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE SET NULL */ update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ) and /* %%JoinPKPK(%Child,:%%New," = "," and") */ %JoinPKPK(%Child,:%New," = "," and"); 'CHILD DELETE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE RESTRICT */ select count(*) into numrows from %Parent where /* %%JoinFKPK(:%%Old,%Parent," = "," and") */ %JoinFKPK(:%Old,%Parent," = "," and"); if (numrows > 0) then raise_application_error( -20010, 'Cannot DELETE %Child because %Parent exists.' ); end if; 'CHILD DELETE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE CASCADE */ delete from %Parent where /* %%JoinFKPK(:%%Old,%Parent," = "," and") */ %JoinFKPK(:%Old,%Parent," = "," and"); !'PARENT INSERT RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT RESTRICT */ select count(*) into numrows from %Child where /* %%JoinFKPK(%Child,:%%New," = "," and") */ %JoinFKPK(%Child,:%New," = "," and"); if (numrows = 0) then raise_application_error( -20011, 'Cannot INSERT %Parent because %Child does not.' ); end if; $' UPDATE HEADERcreate trigger t%1Action_%27TableName after %Action on %TableName for each row -- ERwin Builtin %Datetime -- %Action trigger on %TableName declare numrows INTEGER; begin(' UPDATE FOOTER%-- ERwin Builtin %Datetime end; / )' DELETE HEADERcreate trigger t%1Action_%27TableName after %Action on %TableName for each row -- ERwin Builtin %Datetime -- %Action trigger on %TableName declare numrows INTEGER; begin*' DELETE FOOTER%-- ERwin Builtin %Datetime end; / +' INSERT HEADERcreate trigger t%1Action_%27TableName after %Action on %TableName for each row -- ERwin Builtin %Datetime -- %Action trigger on %TableName declare numrows INTEGER; begin,' INSERT FOOTER%-- ERwin Builtin %Datetime end; / -'CUSTOM TRIGGER HEADER`create trigger %TriggerName %Fire %Actions(" or ") on %TableName %RefClause %Scope .'CUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER DEFAULT BODY!create trigger %TriggerName %Fire %Actions(" or ") on %TableName %RefClause %Scope /* ERwin Builtin %Datetime */ /* default body for %TriggerName */ declare numrows INTEGER; begin %ForEachChildRel() { %RelTemplate } %ForEachParentRel() { %RelTemplate } end; / 0'PARENT UPDATE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT UPDATE SET DEFAULT */ /* Application specific. Left out intentionally. */'PARENT DELETE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE SET DEFAULT */ /* Application specific. Left out intentionally. */'PARENT INSERT SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT SET DEFAULT */ /* Application specific. Left out intentionally. */''CHILD INSERT SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT SET DEFAULT */ /* Application specific. Left out intentionally. */'CHILD UPDATE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE SET DEFAULT */ /* Application specific. Left out intentionally. */'CHILD DELETE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE SET DEFAULT */ /* Application specific. Left out intentionally. */#'CHILD DELETE SET NULL/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE SET NULL */ /* Application specific. Left out intentionally. */"'PARENT INSERT SET NULL/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT SET NULL */ /* Application specific. Left out intentionally. */&'PARENT INSERT CASCADE/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT CASCADE */ /* Application specific. Left out intentionally. */%' Template Name"Template Handle Purpose Text"PurposeTemplate Handle""CHILD DELETE CASCADE!'!'CHILD DELETE RESTRICT ' 'CHILD DELETE SET DEFAULT#'#'CHILD DELETE SET NULL"'"'CHILD INSERT CASCADE''CHILD INSERT RESTRICT''CHILD INSERT SET DEFAULT''CHILD INSERT SET NULL''CHILD UPDATE CASCADE''CHILD UPDATE RESTRICT''CHILD UPDATE SET DEFAULT''CHILD UPDATE SET NULL''CUSTOM TRIGGER DEFAULT BODY0'0'CUSTOM TRIGGER FOOTER/'CUSTOM TRIGGER HEADER.'.'PARENT DELETE CASCADE''PARENT DELETE RESTRICT''PARENT DELETE SET DEFAULT''PARENT DELETE SET NULL''PARENT INSERT CASCADE%'%'PARENT INSERT RESTRICT$'$'PARENT INSERT SET DEFAULT''''PARENT INSERT SET NULL&'&'PARENT UPDATE CASCADE''PARENT UPDATE RESTRICT''PARENT UPDATE SET DEFAULT''PARENT UPDATE SET NULL''RAISE EXCEPTION PROC1'TRIGGER DELETE FOOTER+'+'TRIGGER DELETE HEADER*'*'TRIGGER INSERT FOOTER-'-'TRIGGER INSERT HEADER,','TRIGGER UPDATE FOOTER)')'TRIGGER UPDATE HEADER('('#@ #@ @ @ ''''''''''''''''Default Icon((Default Blob Iconh(@Default Datetime Icon(Default Number Iconh(@Default String Iconh(@ Default Entity Icon ( ADefault Entity Small Iconh(@(((((CHAR(18)%AttName %AttName:%AttName%AttDef %DomainDef %DomainName %AttDomain%AttDefny! !BlobBLOB !DatetimeDATE !NumberNUMBER !String VARCHAR2(20)   UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId5 DiagTitle4 DiagAuth3DiagDef7 DiagImpType6 DiagDbName   UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId(((  "Arial      ! & ) . / 258:BCEGHJPRSUVDBMS DPO_CLASSDPO_IDDPO_NAME DPO_LAST_NAMEA DPO_EPP_UDS DPO_CSX_IDDPO_UDPS =Zh1 8TechsToLab( Laboratory_Name Person_ID:.54 .1.2.7.8.55   ddPKYES IF54NO IF55NO IF54ASCPROP IF55ASCPROP PKASCPROP PKASCPROP   uh1 8Building( Building_ID~P   ddPKYES PKASCPROP   >5h1 8CareCenter(  CareCenter_Name  Building_No Building_Name Building_Code Nurse_In_ChargeZdddBd   ddPKYES PKASCPROP  Oh1 8Person( Person_ID Name Address City State Zip Birth_Date Phonedd d d d d d   ddPKYES PKASCPROP   _^h1 8Employee( Person_ID Date_Hired.1.2d   ddPKYES IF2NO IF2ASCPROP PKASCPROP  &h1 8Patient( Contact_Date Person_IDI Referrer_ Person_ID` Physician_IDs Person_IDu Bed_ID.1.5Rd.53d.1.14.27dCdJdd.1.14.39   ddPKYES IF27NO IF39NO IF5NO IF53NO IF27ASCPROP IF39ASCPROP IF5ASCPROP IF53ASCPROP PKASCPROP    9h1 8Physician( Person_ID Specialty  Pager_Number".1.14dd   ddPKYES IF14NO IF14ASCPROP PKASCPROP  t,h1 8Bed( Bed_Number# Room_Number$ Bed_ID CareCenter_NameRd.47dd   ddPKYES IF47NO IF47ASCPROP PKPROP  <h1 8Item( Item_Number' Description( Unit_Cost)dd   ddPKYES PKASCPROP   h1 8Treatment( Treatment_Number+ Treatment_Name.!d   ddPKYES PKASCPROP   ZTh1 8Volunteer( Person_ID2 Skill3.1.6&d   ddPKYES IF6NO IF6ASCPROP PKASCPROP   N.h1 8Resident( Person_ID5 Date_Admitted6 .1.5.11.13)d   ddPKYES IF13NO IF13ASCPROP PKASCPROP   Fah1 8Outpatient( Person_ID8 .1.5.11.12   ddPKYES IF12NO IF12ASCPROP PKASCPROP   'lh1 8Visit( Date; Comments< Person_IDv. .1.5.11.12.40/d   ddPKYES IF40NO IF40ASCPROP PKPROP PKASCPROP  j9h1 8Nurse( Person_ID> Certificate? CareCenter_Namez CareCenter_Name{ .1.2.7.10d.412dd.42   ddPKYES IF10NO IF41NO IF42NO IF10ASCPROP IF41ASCPROP IF42ASCPROP PKASCPROP  Xh1 8Staff( Person_IDA Job_ClassB.1.2.7.95d   ddPKYES IF9NO IF9ASCPROP PKASCPROP   ]Lh1 8Technician( Person_IDD SkillE.1.2.7.88d   ddPKYES IF8NO IF8ASCPROP PKASCPROP   vRh1 8Laboratory( Laboratory_NameG Building_ID:Pd.44   ddPKYES IF44NO IF44ASCPROP PKASCPROP  mh1 8(   dd  Heh1 8(   dd  ch1 8(   dd  [h1 8EmployeeToCareCenter( Person_IDa CareCenter_Nameb Hours_Per_Week.1.2.28.29Sd   ddPKYES IF28NO IF29NO IF28ASCPROP IF29ASCPROP PKASCPROP PKASCPROP  7h1 8TreatmentsToPatients( Treatment_Numberf Person_IDi Physician_IDk Person_IDl DateTime Results.32.1.5.35d.1.14.36EdUdVd   ddPKYES IF32NO IF35NO IF36NO IF32ASCPROP IF35ASCPROP IF36ASCPROP PKASCPROP PKASCPROP  Fh1 8ComsumedItems( Person_IDn Item_Numbero DateTimep Quantityq.1.5.37.38GdHd   ddPKYES IF37NO IF38NO IF37ASCPROP IF38ASCPROP PKASCPROP PKASCPROP   dOii''''~i~i  d^''''  d''''  d T''''  d_HH''''HH  de*L''''*e*e de'''' de9'''' dL{'''' d sxa''''xx d '''' d''''77e''''vv R/27d<^''''<yyR/28d''''UUR/29 d KK7''''KhKhR/32#d'''' R/35$d[7''''[ R/36%d&F''''44 R/37&d'''' R/38'e''''uu R/39(d G'G''''GG R/40)euu''''uu R/41*e''''R/42,duR''''dd R/44/dt'''' R/475dv''''R/536dv===''''Z=Z= R/547d]55''''55 R/55X7
splay% / %SubjectArebw,xQlPages% -- %%Date%>>vR]LXj9 'l Fa N. ZT  <t, 9&_^O>5F7[cHem& %&44F $[[7 #  KKhKhK7UU<^<yyvv 77  sxxxa  L{  e9 ee*e*e*L _HHHH T  ^ Oi~i~ii u7     /t ,uddR *)uuuu (GGG'G 'uu =Z7]5555 6v=Z=Z=== 5vDisplay1bwXxQxfXlww@a fX>>%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%X,winspool\\beetle\18-ITLAB-HP4100-2itlab-hp4100-2.it.rit.edu \\beetle\18-ITLAB-HP4100-2 S odXXLetterPRIV0''''T\K\K!kTRJPHAANEO2846UNTITLED