<?xml version="1.0" encoding="UTF-8"?>
<Diagram version="1.0" type="NETEZZA" versionMajor="7" versionMinor="0" groupSchema="false" hide_inv="false">
<Table id="0" name="all_tables" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="1" name="a1" type="DATE" length="0" nulls="false"/>
<Column id="2" name="a2" type="FLOAT4" length="0" nulls="true"/>
<Column id="3" name="a3" type="FLOAT8" length="0" nulls="true"/>
<Column id="4" name="a4" type="INT1" length="0" nulls="true"/>
<Column id="5" name="a5" type="INT2" length="0" nulls="true"/>
<Column id="6" name="a6" type="INTERVAL" length="0" nulls="true"/>
<Storage name="Distribution" value="(a1)"/>
</Table>
<Table id="7" name="table_company" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="8" name="id" type="INT1" length="0" nulls="false"/>
<Column id="9" name="e_name" type="VARCHAR" length="50" nulls="true"/>
<Column id="10" name="departments" type="NVARCHAR" length="200" nulls="true"/>
<Column id="11" name="profit" type="FLOAT4" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="12" name="table_company" schema="SAHIL" database="TARIQ" background="16777165">
<Column id="13" name="id" type="INT1" length="0" nulls="false"/>
<Column id="14" name="e_name" type="VARCHAR" length="50" nulls="true"/>
<Column id="15" name="departments" type="NVARCHAR" length="200" nulls="true"/>
<Column id="16" name="profit" type="FLOAT4" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="17" name="table_employee" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="18" name="id" type="INT2" length="0" nulls="false"/>
<Column id="19" name="name" type="VARCHAR" length="100" nulls="false"/>
<Column id="20" name="department" type="CHAR" length="125" nulls="true"/>
<Column id="21" name="salary" type="FLOAT8" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="22" name="table_employee" schema="SAHIL" database="TARIQ" background="16777165">
<Column id="23" name="id" type="INT2" length="0" nulls="false"/>
<Column id="24" name="name" type="VARCHAR" length="100" nulls="false"/>
<Column id="25" name="department" type="CHAR" length="125" nulls="true"/>
<Column id="26" name="salary" type="FLOAT8" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="27" name="table_hospital" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="28" name="id" type="INT1" length="0" nulls="false"/>
<Column id="29" name="name" type="VARCHAR" length="50" nulls="true"/>
<Column id="30" name="address" type="NVARCHAR" length="150" nulls="true"/>
<Column id="31" name="rating" type="FLOAT4" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="32" name="table_hospital" schema="SAHIL" database="TARIQ" background="16777165">
<Column id="33" name="id" type="INT1" length="0" nulls="false"/>
<Column id="34" name="name" type="VARCHAR" length="50" nulls="true"/>
<Column id="35" name="address" type="NVARCHAR" length="150" nulls="true"/>
<Column id="36" name="rating" type="FLOAT4" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="37" name="table_patient" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="38" name="id" type="INT2" length="0" nulls="false"/>
<Column id="39" name="name" type="NVARCHAR" length="200" nulls="true"/>
<Column id="40" name="city" type="VARCHAR" length="30" nulls="true"/>
<Column id="41" name="diesease" type="VARCHAR" length="25" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="42" name="table_patient" schema="SAHIL" database="TARIQ" background="16777165">
<Column id="43" name="id" type="INT2" length="0" nulls="false"/>
<Column id="44" name="name" type="NVARCHAR" length="200" nulls="true"/>
<Column id="45" name="city" type="VARCHAR" length="30" nulls="true"/>
<Column id="46" name="diesease" type="VARCHAR" length="25" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="47" name="table_player" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="48" name="id" type="INT2" length="0" nulls="false"/>
<Column id="49" name="name" type="VARCHAR" length="25" nulls="true"/>
<Column id="50" name="runs" type="NUMERIC" length="0" nulls="true">
<CP name="DEFAULT_VALUE">1000</CP>
<CP name="PRECISION">18</CP>
<CP name="SCALE">5</CP>
</Column>
<Column id="51" name="wkts" type="NUMERIC" length="0" nulls="true">
<CP name="DEFAULT_VALUE">100</CP>
<CP name="PRECISION">10</CP>
<CP name="SCALE">5</CP>
</Column>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="52" name="table_player" schema="SAHIL" database="TARIQ" background="16777165">
<Column id="53" name="id" type="INT2" length="0" nulls="false"/>
<Column id="54" name="name" type="VARCHAR" length="25" nulls="true"/>
<Column id="55" name="runs" type="NUMERIC" length="0" nulls="true">
<CP name="DEFAULT_VALUE">1000</CP>
<CP name="PRECISION">18</CP>
<CP name="SCALE">5</CP>
</Column>
<Column id="56" name="wkts" type="NUMERIC" length="0" nulls="true">
<CP name="DEFAULT_VALUE">100</CP>
<CP name="PRECISION">10</CP>
<CP name="SCALE">5</CP>
</Column>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="57" name="table_student" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="58" name="id" type="INT1" length="0" nulls="false"/>
<Column id="59" name="name" type="NVARCHAR" length="150" nulls="true"/>
<Column id="60" name="date_of_birth" type="DATE" length="0" nulls="true"/>
<Column id="61" name="time_of_birth" type="TIME" length="0" nulls="true"/>
<Column id="62" name="first_date_of_school" type="TIMESTAMP" length="0" nulls="true"/>
<Column id="63" name="pass/fail" type="BOOL" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="64" name="table_student" schema="SAHIL" database="TARIQ" background="16777165">
<Column id="65" name="id" type="INT1" length="0" nulls="false"/>
<Column id="66" name="name" type="NVARCHAR" length="150" nulls="true"/>
<Column id="67" name="date_of_birth" type="DATE" length="0" nulls="true"/>
<Column id="68" name="time_of_birth" type="TIME" length="0" nulls="true"/>
<Column id="69" name="first_date_of_school" type="TIMESTAMP" length="0" nulls="true"/>
<Column id="70" name="pass/fail" type="BOOL" length="0" nulls="true"/>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="71" name="table_teacher" schema="ADMIN" database="TARIQ" background="16777165">
<Text>This is teacher table</Text>
<Column id="72" name="id" type="INT1" length="0" nulls="false">
<CP name="COMMENTS">first column</CP>
</Column>
<Column id="73" name="name" type="CHAR" length="100" nulls="true">
<CP name="DEFAULT_VALUE">'abc'::"NVARCHAR"</CP>
</Column>
<Column id="74" name="salary" type="INT2" length="0" nulls="true"/>
<Column id="75" name="donation" type="FLOAT4" length="0" nulls="false">
<CP name="DEFAULT_VALUE">500</CP>
</Column>
<Column id="76" name="school_name" type="VARCHAR" length="150" nulls="false">
<CP name="DEFAULT_VALUE">'abc school'::"NVARCHAR"</CP>
</Column>
<Column id="77" name="expenses" type="FLOAT8" length="0" nulls="true"/>
<Column id="78" name="rank" type="INT8" length="0" nulls="true"/>
<Column id="79" name="signature" type="NCHAR" length="200" nulls="false">
<CP name="DEFAULT_VALUE">'abc'::"NVARCHAR"</CP>
</Column>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="80" name="table_teacher" schema="SAHIL" database="TARIQ" background="16777165">
<Text>This is teacher table</Text>
<Column id="81" name="id" type="INT1" length="0" nulls="false">
<CP name="COMMENTS">first column</CP>
</Column>
<Column id="82" name="name" type="CHAR" length="101" nulls="true">
<CP name="DEFAULT_VALUE">'abc'::"NVARCHAR"</CP>
</Column>
<Column id="83" name="salary" type="INT2" length="0" nulls="true"/>
<Column id="84" name="donation" type="FLOAT4" length="0" nulls="false">
<CP name="DEFAULT_VALUE">500</CP>
</Column>
<Column id="85" name="school_name" type="VARCHAR" length="150" nulls="false">
<CP name="DEFAULT_VALUE">'abc school'::"NVARCHAR"</CP>
</Column>
<Column id="86" name="expenses" type="FLOAT8" length="0" nulls="true"/>
<Column id="87" name="rank" type="INT8" length="0" nulls="true"/>
<Column id="88" name="signature" type="NCHAR" length="200" nulls="false">
<CP name="DEFAULT_VALUE">'abc'::"NVARCHAR"</CP>
</Column>
<Storage name="Distribution" value="(id)"/>
</Table>
<Table id="89" name="table_team" schema="ADMIN" database="TARIQ" background="16777165">
<Column id="90" name="name" type="VARCHAR" length="100" nulls="false">
<CP name="DEFAULT_VALUE">'India'::"NVARCHAR"</CP>
</Column>
<Column id="91" name="player_id" type="INT2" length="0" nulls="false"/>
<Column id="92" name="no_matches" type="NUMERIC" length="0" nulls="false">
<CP name="PRECISION">15</CP>
<CP name="SCALE">5</CP>
</Column>
<Storage name="Distribution" value="(name)"/>
</Table>
<Table id="93" name="table_team" schema="SAHIL" database="TARIQ" background="16777165">
<Column id="94" name="name" type="VARCHAR" length="100" nulls="false">
<CP name="DEFAULT_VALUE">'India'::"NVARCHAR"</CP>
</Column>
<Column id="95" name="player_id" type="INT2" length="0" nulls="false"/>
<Column id="96" name="no_matches" type="NUMERIC" length="0" nulls="false">
<CP name="PRECISION">15</CP>
<CP name="SCALE">5</CP>
</Column>
<Storage name="Distribution" value="(name)"/>
</Table>
<Constraint table="0" name="pk_1" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="1"/>
</Constraint>
<Constraint table="7" name="PK03" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="8"/>
</Constraint>
<Constraint table="7" name="UK03" type="Unique">
<Option name="initially" class="String" value="INITIALLY DEFERRED"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="10"/>
</Constraint>
<Constraint table="7" name="UK03" type="Unique">
<Option name="initially" class="String" value="INITIALLY DEFERRED"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="10"/>
</Constraint>
<Constraint table="12" name="PK03" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="13"/>
</Constraint>
<Constraint table="12" name="UK03" type="Unique">
<Option name="initially" class="String" value="INITIALLY DEFERRED"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="15"/>
</Constraint>
<Constraint table="12" name="UK03" type="Unique">
<Option name="initially" class="String" value="INITIALLY DEFERRED"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="15"/>
</Constraint>
<Constraint table="17" name="PK04" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="18"/>
</Constraint>
<Constraint table="22" name="PK04" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="23"/>
</Constraint>
<Constraint table="27" name="PK05" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="28"/>
</Constraint>
<Constraint table="32" name="PK05" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="33"/>
</Constraint>
<Constraint table="37" name="PK06" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="38"/>
</Constraint>
<Constraint table="42" name="PK06" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="43"/>
</Constraint>
<Constraint table="57" name="PK02" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY DEFERRED"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="58"/>
</Constraint>
<Constraint table="57" name="UK02" type="Unique">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="59"/>
</Constraint>
<Constraint table="57" name="UK02" type="Unique">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="59"/>
</Constraint>
<Constraint table="64" name="PK02" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY DEFERRED"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="65"/>
</Constraint>
<Constraint table="64" name="UK02" type="Unique">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="66"/>
</Constraint>
<Constraint table="64" name="UK02" type="Unique">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="66"/>
</Constraint>
<Constraint table="71" name="PK01" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="72"/>
</Constraint>
<Constraint table="80" name="PK01" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="81"/>
</Constraint>
<Constraint table="89" name="PK25" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="91"/>
</Constraint>
<Constraint table="93" name="PK25" type="PrimKey">
<Option name="initially" class="String" value="INITIALLY IMMEDIATE"/>
<Option name="deferrable" class="String" value="DEFERRABLE"/>
<ConstraintColumn id="95"/>
</Constraint>
<Sheet name="Netezza 7.0.3" id="97" disp_at="true" disp_ph="true" disp_co="true" disp_rn="true">
<Place id="22" visible="true">10,10,180,90</Place>
<Place id="27" visible="true">230,10,200,90</Place>
<Place id="93" visible="true">470,10,200,80</Place>
<Place id="17" visible="true">710,10,180,90</Place>
<Place id="80" visible="true">930,10,210,180</Place>
<Place id="12" visible="true">10,230,220,90</Place>
<Place id="42" visible="true">270,230,180,90</Place>
<Place id="71" visible="true">490,230,210,180</Place>
<Place id="7" visible="true">740,230,220,90</Place>
<Place id="52" visible="true">1000,230,160,90</Place>
<Place id="37" visible="true">10,450,180,90</Place>
<Place id="47" visible="true">230,450,160,90</Place>
<Place id="0" visible="true">430,450,120,130</Place>
<Place id="64" visible="true">590,450,230,130</Place>
<Place id="57" visible="true">860,450,230,130</Place>
<Place id="32" visible="true">10,620,200,90</Place>
<Place id="89" visible="true">250,620,200,80</Place>
</Sheet>
<Settings sheet="97" zoom="1.0"/>
</Diagram>
