<?xml version="1.0" encoding="utf-8"?>
<Database Name="ITC" Class="ITCDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
<Connection Mode="AppSettings" ConnectionString="Data Source=ADVANTECH;Initial Catalog=ITC;Integrated Security=True" SettingsObjectName="TicketCenter_Data.Properties.Settings" SettingsPropertyName="ITCConnectionString" Provider="System.Data.SqlClient" />
<Table Name="dbo.Committee" Member="Committees">
<Type Name="Committee">
<Column Name="CommitteeID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
<Column Name="CommitteeName" Type="System.String" DbType="VarChar(25)" CanBeNull="true" />
<Column Name="Chairperson" Type="System.String" DbType="VarChar(25)" CanBeNull="true" />
<Column Name="ChairpersonPhone" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
<Column Name="ChairpersonEmail" Type="System.String" DbType="VarChar(25)" CanBeNull="true" />
<Column Name="ContactPerson" Type="System.String" DbType="VarChar(25)" CanBeNull="true" />
<Column Name="ContactPersonPhone" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
<Column Name="ContactPersonEmail" Type="System.String" DbType="VarChar(25)" CanBeNull="true" />
<Association Name="Committee_Event" Member="Events" ThisKey="CommitteeID" OtherKey="CommitteeID" Type="Event" />
</Type>
</Table>
<Table Name="dbo.Events" Member="Events">
<Type Name="Event">
<Column Name="EventID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
<Column Name="EventName" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
<Column Name="EventDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
<Column Name="EventLocation" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
<Column Name="EventPrice" Type="System.Decimal" DbType="Money NOT NULL" CanBeNull="false" />
<Column Name="TotalTicketsIssued" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
<Column Name="CommitteeID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
<Column Name="Refreshments" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
<Column Name="Posters" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
<Association Name="Event_DailySale" Member="DailySales" ThisKey="EventID" OtherKey="EventID" Type="DailySale" />
<Association Name="Event_TransferLog" Member="TransferLogs" ThisKey="EventID" OtherKey="EventID" Type="TransferLog" />
<Association Name="Event_BankDeposit" Member="BankDeposits" ThisKey="EventID" OtherKey="EventID" Type="BankDeposit" />
<Association Name="Event_TicketsAllocation" Member="TicketsAllocations" ThisKey="EventID" OtherKey="EventID" Type="TicketsAllocation" />
<Association Name="Committee_Event" Member="Committee" ThisKey="CommitteeID" OtherKey="CommitteeID" Type="Committee" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
</Type>
</Table>
<Table Name="dbo.JK" Member="JKs">
<Type Name="JK">
<Column Name="JKID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
<Column Name="Name" Type="System.String" DbType="VarChar(25) NOT NULL" CanBeNull="false" />
<Association Name="JK_DailySale" Member="DailySales" ThisKey="JKID" OtherKey="JKID" Type="DailySale" />
<Association Name="JK_TransferLog" Member="TransferLogs" ThisKey="JKID" OtherKey="JKIDFrom" Type="TransferLog" />
<Association Name="JK_TransferLog1" Member="TransferLogs1" ThisKey="JKID" OtherKey="JKIDTo" Type="TransferLog" />
<Association Name="JK_BankDeposit" Member="BankDeposits" ThisKey="JKID" OtherKey="JKID" Type="BankDeposit" />
<Association Name="JK_TicketsAllocation" Member="TicketsAllocations" ThisKey="JKID" OtherKey="JKID" Type="TicketsAllocation" />
</Type>
</Table>
<Table Name="dbo.CurrentEvents" Member="CurrentEvents">
<Type Name="CurrentEvent">
<Column Name="ID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
<Column Name="EventName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
</Type>
</Table>
<Table Name="dbo.DailySales" Member="DailySales">
<Type Name="DailySale">
<Column Name="JKID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="DateSold" Type="System.DateTime" DbType="Date NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="EventID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="TicketsSold" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
<Column Name="Modified" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Association Name="Event_DailySale" Member="Event" ThisKey="EventID" OtherKey="EventID" Type="Event" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
<Association Name="JK_DailySale" Member="JK" ThisKey="JKID" OtherKey="JKID" Type="JK" IsForeignKey="true" />
</Type>
</Table>
<Table Name="dbo.TransferLog" Member="TransferLogs">
<Type Name="TransferLog">
<Column Name="EventID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="DateTransfer" Type="System.DateTime" DbType="Date NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="JKIDFrom" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="JKIDTo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="QtyTransfer" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
<Column Name="Comments" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
<Column Name="Modified" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Association Name="Event_TransferLog" Member="Event" ThisKey="EventID" OtherKey="EventID" Type="Event" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
<Association Name="JK_TransferLog" Member="JK" ThisKey="JKIDFrom" OtherKey="JKID" Type="JK" IsForeignKey="true" />
<Association Name="JK_TransferLog1" Member="JK1" ThisKey="JKIDTo" OtherKey="JKID" Type="JK" IsForeignKey="true" />
</Type>
</Table>
<Table Name="dbo.BankDeposit" Member="BankDeposits">
<Type Name="BankDeposit">
<Column Name="JKID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="EventID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="DateDeposit" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
<Column Name="AmountDeposit" Type="System.Decimal" DbType="Money NOT NULL" CanBeNull="false" />
<Column Name="ReferenceNumber" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
<Association Name="Event_BankDeposit" Member="Event" ThisKey="EventID" OtherKey="EventID" Type="Event" IsForeignKey="true" />
<Association Name="JK_BankDeposit" Member="JK" ThisKey="JKID" OtherKey="JKID" Type="JK" IsForeignKey="true" />
</Type>
</Table>
<Table Name="dbo.TicketsAllocation" Member="TicketsAllocations">
<Type Name="TicketsAllocation">
<Column Name="JKID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="EventID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="TicketsIssued" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="TotalTicketsSold" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="TicketsCommited" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="TicketsRemaining" Type="System.Int32" DbType="Int" IsDbGenerated="true" CanBeNull="true" UpdateCheck="Never" />
<Association Name="Event_TicketsAllocation" Member="Event" ThisKey="EventID" OtherKey="EventID" Type="Event" IsForeignKey="true" />
<Association Name="JK_TicketsAllocation" Member="JK" ThisKey="JKID" OtherKey="JKID" Type="JK" IsForeignKey="true" />
</Type>
</Table>
</Database>