<?xml version="1.0" encoding="UTF-8"?>
<Diagram version="1.0" type="SYBASE_ASE" versionMajor="15" versionMinor="7" groupSchema="false" hide_inv="false">
<Table id="0" name="SD_RequestUserAuthorizasation" schema="dbo" database="pubs2" background="16777165">
<Column id="1" name="authID" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">YES</CP>
</Column>
<Column id="2" name="versionNumber" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="3" name="authorizationType" type="varchar" length="3" nulls="false"/>
<Column id="4" name="userID" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="5" name="businessServiceCode" type="varchar" length="8" nulls="false"/>
<Column id="6" name="inputStatusCode" type="varchar" length="3" nulls="false">
<CP name="DEFAULT_VALUE">'A'</CP>
</Column>
<Column id="7" name="userRoleCode" type="varchar" length="3" nulls="false"/>
<Column id="8" name="companyID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="9" name="companyGroupID" type="numeric" length="0" nulls="true">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="10" name="globalCompanyID" type="varchar" length="8" nulls="false"/>
<Column id="11" name="enteredBy" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="12" name="entityCode" type="AS  case when authorizationType = 'GC'&#10;                                 then authorizationType + '@' + globalCompanyID&#10;                                 when authorizationType = 'C'&#10;                                 then authorizationType + '@' + convert(varchar(12),companyID)&#10;                                 when authorizationType = 'CG'&#10;                                 then authorizationType + '@' + convert(varchar(12),companyGroupID)&#10;                            end" length="0" nulls="true"/>
<Column id="13" name="proxyType" type="char" length="1" nulls="true"/>
<Column id="14" name="proxyInformation" type="varchar" length="65" nulls="true"/>
<Column id="15" name="umProduct" type="varchar" length="4" nulls="true"/>
<Column id="16" name="restrictedToBeneficiaryTemplate" type="tinyint" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Storage name="TableLockType" value="2"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="17" name="SD_RequestUserAuthorization" schema="dbo" database="pubs2" background="16777165">
<Column id="18" name="authID" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">YES</CP>
</Column>
<Column id="19" name="versionNumber" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="20" name="authorizationType" type="varchar" length="3" nulls="false"/>
<Column id="21" name="userID" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="22" name="businessServiceCode" type="varchar" length="8" nulls="false"/>
<Column id="23" name="inputStatusCode" type="varchar" length="3" nulls="false">
<CP name="DEFAULT_VALUE">'A'</CP>
</Column>
<Column id="24" name="userRoleCode" type="varchar" length="3" nulls="false"/>
<Column id="25" name="companyID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="26" name="companyGroupID" type="numeric" length="0" nulls="true">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="27" name="globalCompanyID" type="varchar" length="8" nulls="false"/>
<Column id="28" name="enteredBy" type="numeric" length="0" nulls="false">
<CP name="PRECISION">12</CP>
<CP name="SCALE">0</CP>
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="29" name="entityCode" type="AS  case when authorizationType = 'GC'&#10;                                 then authorizationType + '@' + globalCompanyID&#10;                                 when authorizationType = 'C'&#10;                                 then authorizationType + '@' + convert(varchar(12),companyID)&#10;                                 when authorizationType = 'CG'&#10;                                 then authorizationType + '@' + convert(varchar(12),companyGroupID)&#10;                            end" length="0" nulls="true"/>
<Column id="30" name="proxyType" type="char" length="1" nulls="true"/>
<Column id="31" name="proxyInformation" type="varchar" length="65" nulls="true"/>
<Column id="32" name="umProduct" type="varchar" length="4" nulls="true"/>
<Column id="33" name="restrictedToBeneficiaryTemplate" type="tinyint" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Storage name="TableLockType" value="2"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="34" name="au_pix" schema="dbo" database="pubs2" background="16777165">
<Column id="35" name="au_id" type="char" length="11" nulls="false"/>
<Column id="36" name="pic" type="image" length="0" nulls="true"/>
<Column id="37" name="format_type" type="char" length="11" nulls="true"/>
<Column id="38" name="bytesize" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="39" name="pixwidth_hor" type="char" length="14" nulls="true"/>
<Column id="40" name="pixwidth_vert" type="char" length="14" nulls="true"/>
<Storage name="TableLockType" value="1"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="41" name="authors" schema="dbo" database="pubs2" background="16777165">
<Column id="42" name="au_id" type="id" length="0" nulls="false"/>
<Column id="43" name="au_lname" type="varchar" length="40" nulls="false"/>
<Column id="44" name="au_fname" type="varchar" length="20" nulls="false"/>
<Column id="45" name="phone" type="char" length="12" nulls="false">
<CP name="DEFAULT_VALUE">create default phonedflt
as "UNKNOWN"
</CP>
</Column>
<Column id="46" name="address" type="varchar" length="40" nulls="true"/>
<Column id="47" name="city" type="varchar" length="20" nulls="true"/>
<Column id="48" name="state" type="char" length="2" nulls="true"/>
<Column id="49" name="country" type="varchar" length="12" nulls="true"/>
<Column id="50" name="postalcode" type="char" length="10" nulls="true"/>
</Table>
<Table id="51" name="blurbs" schema="dbo" database="pubs2" background="16777165">
<Column id="52" name="au_id" type="id" length="0" nulls="false"/>
<Column id="53" name="copy" type="text" length="0" nulls="true"/>
<Storage name="TableLockType" value="1"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="54" name="discounts" schema="dbo" database="pubs2" background="16777165">
<Column id="55" name="discounttype" type="varchar" length="40" nulls="false"/>
<Column id="56" name="stor_id" type="char" length="4" nulls="true"/>
<Column id="57" name="lowqty" type="smallint" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="58" name="highqty" type="smallint" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="59" name="discount" type="float" length="0" nulls="false">
<CP name="IDENTITY">NO</CP>
</Column>
<Storage name="TableLockType" value="1"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="60" name="publishers" schema="dbo" database="pubs2" background="16777165">
<Column id="61" name="pub_id" type="char" length="4" nulls="false"/>
<Column id="62" name="pub_name" type="varchar" length="40" nulls="true"/>
<Column id="63" name="city" type="varchar" length="20" nulls="true"/>
<Column id="64" name="state" type="char" length="2" nulls="true"/>
</Table>
<Table id="65" name="roysched" schema="dbo" database="pubs2" background="16777165">
<Column id="66" name="title_id" type="tid" length="0" nulls="false"/>
<Column id="67" name="lorange" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="68" name="hirange" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="69" name="royalty" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Storage name="TableLockType" value="1"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="70" name="sales" schema="dbo" database="pubs2" background="16777165">
<Column id="71" name="stor_id" type="char" length="4" nulls="false"/>
<Column id="72" name="ord_num" type="varchar" length="20" nulls="false"/>
<Column id="73" name="date" type="datetime" length="0" nulls="false"/>
</Table>
<Table id="74" name="salesdetail" schema="dbo" database="pubs2" background="16777165">
<Column id="75" name="stor_id" type="char" length="4" nulls="false"/>
<Column id="76" name="ord_num" type="varchar" length="20" nulls="false"/>
<Column id="77" name="title_id" type="tid" length="0" nulls="false"/>
<Column id="78" name="qty" type="smallint" length="0" nulls="false">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="79" name="discount" type="float" length="0" nulls="false">
<CP name="IDENTITY">NO</CP>
</Column>
<Storage name="TableLockType" value="1"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="80" name="stores" schema="dbo" database="pubs2" background="16777165">
<Column id="81" name="stor_id" type="char" length="4" nulls="false"/>
<Column id="82" name="stor_name" type="varchar" length="40" nulls="true"/>
<Column id="83" name="stor_address" type="varchar" length="40" nulls="true"/>
<Column id="84" name="city" type="varchar" length="20" nulls="true"/>
<Column id="85" name="state" type="char" length="2" nulls="true"/>
<Column id="86" name="country" type="varchar" length="12" nulls="true"/>
<Column id="87" name="postalcode" type="char" length="10" nulls="true"/>
<Column id="88" name="payterms" type="varchar" length="12" nulls="true"/>
<Storage name="TableLockType" value="1"/>
<Storage name="ResPageGap" value="0"/>
<Storage name="ExpRowSize" value="0"/>
<Storage name="MaxRowsPerPage" value="0"/>
<Storage name="Segment" value="default"/>
<Storage name="IdentityGap" value="0"/>
</Table>
<Table id="89" name="titleauthor" schema="dbo" database="pubs2" background="16777165">
<Column id="90" name="au_id" type="id" length="0" nulls="false"/>
<Column id="91" name="title_id" type="tid" length="0" nulls="false"/>
<Column id="92" name="au_ord" type="tinyint" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="93" name="royaltyper" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
</Table>
<Table id="94" name="titles" schema="dbo" database="pubs2" background="16777165">
<Column id="95" name="title_id" type="tid" length="0" nulls="false"/>
<Column id="96" name="title" type="varchar" length="80" nulls="false"/>
<Column id="97" name="type" type="char" length="12" nulls="false">
<CP name="DEFAULT_VALUE">create default typedflt
as "UNDECIDED"
</CP>
</Column>
<Column id="98" name="pub_id" type="char" length="4" nulls="true"/>
<Column id="99" name="price" type="money" length="0" nulls="true"/>
<Column id="100" name="advance" type="money" length="0" nulls="true"/>
<Column id="101" name="total_sales" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
</Column>
<Column id="102" name="notes" type="varchar" length="200" nulls="true"/>
<Column id="103" name="pubdate" type="datetime" length="0" nulls="false">
<CP name="DEFAULT_VALUE">create default datedflt
as getdate()
</CP>
</Column>
<Column id="104" name="contract" type="bit" length="0" nulls="false"/>
</Table>
<Index table="41" name="aunmind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="43" sequence="0" ascending="true"/>
<IndexColumn id="44" sequence="1" ascending="true"/>
</Index>
<Index table="41" name="auidind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="true"/>
<Option name="clustered" class="Boolean" value="true"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="42" sequence="0" ascending="true"/>
</Index>
<Index table="60" name="pubind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="true"/>
<Option name="clustered" class="Boolean" value="true"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="61" sequence="0" ascending="true"/>
</Index>
<Index table="65" name="titleidind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="66" sequence="0" ascending="true"/>
</Index>
<Index table="70" name="salesind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="true"/>
<Option name="clustered" class="Boolean" value="true"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="71" sequence="0" ascending="true"/>
<IndexColumn id="72" sequence="1" ascending="true"/>
</Index>
<Index table="74" name="salesdetailind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="75" sequence="0" ascending="true"/>
<IndexColumn id="76" sequence="1" ascending="true"/>
</Index>
<Index table="74" name="titleidind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="77" sequence="0" ascending="true"/>
</Index>
<Index table="89" name="taind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="true"/>
<Option name="clustered" class="Boolean" value="true"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="90" sequence="0" ascending="true"/>
<IndexColumn id="91" sequence="1" ascending="true"/>
</Index>
<Index table="89" name="auidind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="90" sequence="0" ascending="true"/>
</Index>
<Index table="89" name="titleidind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="91" sequence="0" ascending="true"/>
</Index>
<Index table="94" name="titleind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="96" sequence="0" ascending="true"/>
</Index>
<Index table="94" name="titleidind" schema="dbo" database="pubs2">
<Option name="unique" class="Boolean" value="true"/>
<Option name="clustered" class="Boolean" value="true"/>
<Option name="segment" class="String" value="default"/>
<Option name="ignoreDuplicate" class="Boolean" value="false"/>
<Option name="sortedData" class="Boolean" value="false"/>
<IndexColumn id="95" sequence="0" ascending="true"/>
</Index>
<Constraint table="0" name="SD_RequestUserAuthorization_PK" type="PrimKey">
<Option name="clustered" class="Boolean" value="false"/>
<Option name="pageGap" class="Integer" value="0"/>
<Option name="maxRows" class="Integer" value="0"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="1"/>
</Constraint>
<Constraint table="17" name="SD_RequestUserAuthorization_PK" type="PrimKey">
<Option name="clustered" class="Boolean" value="false"/>
<Option name="pageGap" class="Integer" value="0"/>
<Option name="maxRows" class="Integer" value="0"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="18"/>
</Constraint>
<Constraint table="41" name="auidind" type="Unique">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="pageGap" class="Integer" value="0"/>
<Option name="maxRows" class="Integer" value="0"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="42"/>
</Constraint>
<Constraint table="60" name="pubind" type="Unique">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="pageGap" class="Integer" value="0"/>
<Option name="maxRows" class="Integer" value="0"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="61"/>
</Constraint>
<Constraint table="70" name="salesind" type="Unique">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="pageGap" class="Integer" value="0"/>
<Option name="maxRows" class="Integer" value="0"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="71"/>
<ConstraintColumn id="72"/>
</Constraint>
<Constraint table="89" name="taind" type="Unique">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="pageGap" class="Integer" value="0"/>
<Option name="maxRows" class="Integer" value="0"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="90"/>
<ConstraintColumn id="91"/>
</Constraint>
<Constraint table="94" name="titleidind" type="Unique">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="pageGap" class="Integer" value="0"/>
<Option name="maxRows" class="Integer" value="0"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="95"/>
</Constraint>
<Sheet name="10.168.11.82 v15.7" id="105" disp_at="true" disp_ph="true" disp_co="true" disp_rn="true">
<Place id="74" visible="true">10,10,170,110</Place>
<Place id="60" visible="true">220,10,180,90</Place>
<Place id="89" visible="true">440,10,120,90</Place>
<Place id="41" visible="true">600,10,170,180</Place>
<Place id="17" visible="true">810,10,400,300</Place>
<Place id="34" visible="true">10,350,180,130</Place>
<Place id="0" visible="true">230,350,400,300</Place>
<Place id="54" visible="true">670,350,190,110</Place>
<Place id="51" visible="true">900,350,100,60</Place>
<Place id="80" visible="true">1040,350,190,160</Place>
<Place id="70" visible="true">10,690,170,80</Place>
<Place id="65" visible="true">220,690,100,90</Place>
<Place id="94" visible="true">360,690,160,190</Place>
</Sheet>
<Settings sheet="105" zoom="1.0"/>
</Diagram>
