﻿<?xml version="1.0" encoding="utf-8"?><Database Name="Classifieds" Class="EMUPDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=jhalakservices.cpm5bnayea5q.us-west-2.rds.amazonaws.com;Initial Catalog=Classifieds;Persist Security Info=True;User ID=Shailesh" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="ConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.Event_Category_Det" Member="Event_Category_Dets">
    <Type Name="Event_Category_Det">
      <Column Name="EventCategoryId" Type="System.Decimal" DbType="Decimal(4,0) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="CategoryName" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Association Name="Event_Category_Det_Event_Create" Member="Event_Creates" ThisKey="EventCategoryId" OtherKey="CategoryId" Type="Event_Create" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Guests" Member="Event_Guests">
    <Type Name="Event_Guest">
      <Column Name="Event_Guest_Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="LastName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="EmailId" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="EmailIdOptional" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="ContactNumber" Type="System.String" DbType="VarChar(12)" CanBeNull="true" />
      <Column Name="ContactNumber1" Type="System.String" DbType="VarChar(12)" CanBeNull="true" />
      <Column Name="AboutGuest" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="StartTime" Type="System.String" DbType="VarChar(5)" CanBeNull="true" />
      <Column Name="EndTime" Type="System.String" DbType="VarChar(5)" CanBeNull="true" />
      <Column Name="GuestPhoto" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Association Name="UserAdsDet_Event_Guest" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Invitees" Member="Event_Invitees">
    <Type Name="Event_Invitee">
      <Column Name="Evnent_InvitedId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="FirstName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="LastName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="EmailId" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="ContactNumber" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="VarChar(256) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Association Name="UserAdsDet_Event_Invitee" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Partner" Member="Event_Partners">
    <Type Name="Event_Partner">
      <Column Name="Event_PartnerId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="PartnerName" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PartnerType" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="PartnerEmail" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="PartnerLogo" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Association Name="UserAdsDet_Event_Partner" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Schedules" Member="Event_Schedules">
    <Type Name="Event_Schedule">
      <Column Name="Event_Schedule_Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="Title" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="Starttime" Type="System.String" DbType="VarChar(5)" CanBeNull="true" />
      <Column Name="Endtime" Type="System.String" DbType="VarChar(5)" CanBeNull="true" />
      <Column Name="StartDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="EndDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Sponsor_Create" Member="Event_Sponsor_Creates">
    <Type Name="Event_Sponsor_Create">
      <Column Name="Sponsor_Id" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="SponsorName" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SponsorType" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="SponsorManager" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Website" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="Email" Type="System.String" DbType="VarChar(256) NOT NULL" CanBeNull="false" />
      <Column Name="Logo" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="PhoneNo" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="Address" Type="System.String" DbType="VarChar(1000) NOT NULL" CanBeNull="false" />
      <Column Name="Description" Type="System.String" DbType="VarChar(2000) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Association Name="UserAdsDet_Event_Sponsor_Create" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Sponsor_Det" Member="Event_Sponsor_Dets">
    <Type Name="Event_Sponsor_Det">
      <Column Name="SponsorEventId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="SponsorId" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL" CanBeNull="false" />
      <Column Name="Eventd" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="Description" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="VarChar(256) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Supplier_Service_List" Member="Event_Supplier_Service_Lists">
    <Type Name="Event_Supplier_Service_List">
      <Column Name="SuplierServiceSerNo" Type="System.Decimal" DbType="Decimal(8,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="SupplierId" Type="System.Decimal" DbType="Decimal(8,0) NOT NULL" CanBeNull="false" />
      <Column Name="ConceptDesignPlanning" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="Budgeting" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SiteSelection" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="LogisticVendor" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="TicketingRegistration" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="PermitLicence" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="ExhibitSponsor" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="MarketingCommunication" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="ArtistSpeaker" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="EventTechnology" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="MobileApp" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="AccountingRevenue" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="FoodBevarage" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="DecorPlanning" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="EntertairnemntAttractions" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SoundLighting" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="Transportation" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SecurityEmergency" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SiteCleanUp" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="PartyGifts" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="Excursions" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EventManagementServiceList" Member="EventManagementServiceLists">
    <Type Name="EventManagementServiceList">
      <Column Name="EventMgmtServiceSerNo" Type="System.Decimal" DbType="Decimal(8,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="EventMgmtId" Type="System.Decimal" DbType="Decimal(8,0) NOT NULL" CanBeNull="false" />
      <Column Name="ConceptDesignPlanning" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="Budgeting" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SiteSelection" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="LogisticVendor" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="TicketingRegistration" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="PermitLicence" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="ExhibitSponsor" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="MarketingCommunication" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="ArtistSpeaker" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="EventTechnology" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="MobileApp" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="AccountingRevenue" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="FoodBevarage" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="DecorPlanning" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="EntertairnemntAttractions" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SoundLighting" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="Transportation" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SecurityEmergency" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="SiteCleanUp" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="PartyGifts" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="Excursions" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.CityList" Member="CityLists">
    <Type Name="CityList">
      <Column Name="Cityid" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="CityName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="StateId" Type="System.Decimal" DbType="Decimal(5,0) NOT NULL" CanBeNull="false" />
      <Column Name="ZipCode" Type="System.Decimal" DbType="Decimal(8,0)" CanBeNull="true" />
      <Association Name="StatesList_CityList" Member="StatesList" ThisKey="StateId" OtherKey="StateId" Type="StatesList" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.CountryList" Member="CountryLists">
    <Type Name="CountryList">
      <Column Name="CountryId" Type="System.Decimal" DbType="Decimal(3,0) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Name" Type="System.String" DbType="VarChar(40) NOT NULL" CanBeNull="false" />
      <Association Name="CountryList_StatesList" Member="StatesLists" ThisKey="CountryId" OtherKey="CountryId" Type="StatesList" />
    </Type>
  </Table>
  <Table Name="dbo.CategoryDet" Member="CategoryDets">
    <Type Name="CategoryDet">
      <Column Name="CategoryId" Type="System.Decimal" DbType="Decimal(2,0) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Categoryname" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Association Name="CategoryDet_SubCategoryDet" Member="SubCategoryDets" ThisKey="CategoryId" OtherKey="CategoryId" Type="SubCategoryDet" />
      <Association Name="CategoryDet_ServiceDet" Member="ServiceDets" ThisKey="CategoryId" OtherKey="CategoryId" Type="ServiceDet" />
      <Association Name="CategoryDet_UserAdsDet" Member="UserAdsDets" ThisKey="CategoryId" OtherKey="CategoryId" Type="UserAdsDet" />
      <Association Name="CategoryDet_UserDet" Member="UserDets" ThisKey="CategoryId" OtherKey="CategoryId" Type="UserDet" />
    </Type>
  </Table>
  <Table Name="dbo.SubCategoryDet" Member="SubCategoryDets">
    <Type Name="SubCategoryDet">
      <Column Name="SubCategoryId" Type="System.Decimal" DbType="Decimal(4,0) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="SubCategory" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="CategoryId" Type="System.Decimal" DbType="Decimal(2,0) NOT NULL" CanBeNull="false" />
      <Association Name="SubCategoryDet_ServiceDet" Member="ServiceDets" ThisKey="SubCategoryId" OtherKey="SubCategoryId" Type="ServiceDet" />
      <Association Name="SubCategoryDet_UserAdsDet" Member="UserAdsDets" ThisKey="SubCategoryId" OtherKey="SubCategoryId" Type="UserAdsDet" />
      <Association Name="CategoryDet_SubCategoryDet" Member="CategoryDet" ThisKey="CategoryId" OtherKey="CategoryId" Type="CategoryDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.UserAdsImagesDet" Member="UserAdsImagesDets">
    <Type Name="UserAdsImagesDet">
      <Column Name="UserAdImageId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="UserAdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="UserEmailId" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="Image" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Association Name="UserAdsDet_UserAdsImagesDet" Member="UserAdsDet" ThisKey="UserAdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="UserDet_UserAdsImagesDet" Member="UserDet" ThisKey="UserEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.StatesList" Member="StatesLists">
    <Type Name="StatesList">
      <Column Name="StateId" Type="System.Decimal" DbType="Decimal(5,0) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ShortName" Type="System.String" DbType="VarChar(5)" CanBeNull="true" />
      <Column Name="StateName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="CountryId" Type="System.Decimal" DbType="Decimal(3,0) NOT NULL" CanBeNull="false" />
      <Association Name="StatesList_CityList" Member="CityLists" ThisKey="StateId" OtherKey="StateId" Type="CityList" />
      <Association Name="CountryList_StatesList" Member="CountryList" ThisKey="CountryId" OtherKey="CountryId" Type="CountryList" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.AdResponseDet" Member="AdResponseDets">
    <Type Name="AdResponseDet">
      <Column Name="RespId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="RespondentMailId" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="UserEmailId" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="AdResponseDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="AdResponseMsg" Type="System.String" DbType="VarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="PhoneNo" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="RespondentName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="Location" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Association Name="UserAdsDet_AdResponseDet" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="UserDet_AdResponseDet" Member="UserDet" ThisKey="UserEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.SignupSubcategoryDet" Member="SignupSubcategoryDets">
    <Type Name="SignupSubcategoryDet">
      <Column Name="SubCategoryId" Type="System.Decimal" DbType="Decimal(4,0) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="SubCategoryname" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="CategoryId" Type="System.Decimal" DbType="Decimal(2,0) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Venue_Managers" Member="Event_Venue_Managers">
    <Type Name="Event_Venue_Manager">
      <Column Name="VenueId" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="Userid" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="EmailId" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="Brochure" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="Description" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="Weddings" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Birthdays" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Mehendi_and_Sangeet" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Meetings" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Bridal_Showers" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Baby_Showers" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Corporate_Events" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Sweet_Sixteen" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Cultural_Events" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Music_and_Entertainments" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Others" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Parking" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Handicap_Accessible" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Liability_Insurance" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="On_Site_Accommodations" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Indoor" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="OutdoorNotCovered" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Reception_Area" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Wireless_Internet" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="AV_Equipped" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Onsite_Audio_Visual_Services" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Outside_Catering_Permitted" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Onsite_Restaurant" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Tables_and_Chairs" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Linen_for_Table_Chairs" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Full_Kitchen_Access" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Onsite_Event_Decorator" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Onsite_Event_Manager" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Bar_and_Bartenders" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Onsite_Accommodations" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="KidsZone" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Security" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PriceMin" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="PriceMax" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="CapacityMin" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="CapacityMax" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="MaxAffairs" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="PostedBy" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="MondayOpen" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="MondayClose" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="TuesdayOpen" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="TuesdayClose" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="WednsdayOpen" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="WednsdayClose" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="ThursdayOpen" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="ThursdayClose" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="FridayOpen" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="FridayClose" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="SaturdayOpen" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="SaturdayClose" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="SundayOpen" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="SundayClose" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="SundayClosed" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="MondayClosed" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="TuesdayClosed" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="WednesdayClosed" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="ThursdayClosed" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="FridayClosed" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="SaturdayClosed" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Association Name="UserAdsDet_Event_Venue_Manager" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="UserDet_Event_Venue_Manager" Member="UserDet" ThisKey="Userid" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Supplier_Network" Member="Event_Supplier_Networks">
    <Type Name="Event_Supplier_Network">
      <Column Name="SupplierId" Type="System.Decimal" DbType="Decimal(8,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="ServiceDescription" Type="System.String" DbType="VarChar(250)" CanBeNull="true" />
      <Column Name="CompanyLogo" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="UserId" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="PostedBy" Type="System.String" DbType="VarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="Brochure" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" />
      <Association Name="UserAdsDet_Event_Supplier_Network" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="UserDet_Event_Supplier_Network" Member="UserDet" ThisKey="UserId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.UserAdServiceDet" Member="UserAdServiceDets">
    <Type Name="UserAdServiceDet">
      <Column Name="AdServiceNo" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="UserAdID" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="UserEmailId" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="ServiceId" Type="System.Decimal" DbType="Decimal(5,0) NOT NULL" CanBeNull="false" />
      <Association Name="ServiceDet_UserAdServiceDet" Member="ServiceDet" ThisKey="ServiceId" OtherKey="ServiceId" Type="ServiceDet" IsForeignKey="true" />
      <Association Name="UserAdsDet_UserAdServiceDet" Member="UserAdsDet" ThisKey="UserAdID" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="UserDet_UserAdServiceDet" Member="UserDet" ThisKey="UserEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.ServiceDet" Member="ServiceDets">
    <Type Name="ServiceDet">
      <Column Name="ServiceId" Type="System.Decimal" DbType="Decimal(5,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ServiceName" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="SubCategoryId" Type="System.Decimal" DbType="Decimal(4,0) NOT NULL" CanBeNull="false" />
      <Column Name="CategoryId" Type="System.Decimal" DbType="Decimal(2,0) NOT NULL" CanBeNull="false" />
      <Association Name="ServiceDet_UserAdServiceDet" Member="UserAdServiceDets" ThisKey="ServiceId" OtherKey="ServiceId" Type="UserAdServiceDet" />
      <Association Name="CategoryDet_ServiceDet" Member="CategoryDet" ThisKey="CategoryId" OtherKey="CategoryId" Type="CategoryDet" IsForeignKey="true" />
      <Association Name="SubCategoryDet_ServiceDet" Member="SubCategoryDet" ThisKey="SubCategoryId" OtherKey="SubCategoryId" Type="SubCategoryDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Oraganization_Create" Member="Event_Oraganization_Creates">
    <Type Name="Event_Oraganization_Create">
      <Column Name="OrganizerId" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="OrganizationName" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="ShortName" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="OrganizationLogo" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="Website" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="OrganizerName" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
      <Column Name="Email" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="Address" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="PhoneNo" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="Description" Type="System.String" DbType="VarChar(1000)" CanBeNull="true" />
      <Column Name="ConceptDesignPlanning" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Budgeting" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="SiteSelection" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="LogisticVendor" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="TicketingRegistration" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PermitLicence" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="ExhibitSponsor" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="MarketingCommunication" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="ArtistSpeaker" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Audio_Video" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="MobileApp_Msg_Services" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="AccountingRevenue" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="FoodBevarage" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="DecorPlanning" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="EntertairnemntAttractions" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="SoundLighting" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Transportation" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="SecurityEmergency" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="SiteCleanUp" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PartyGifts" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Excursions" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="InnovativeConcepts" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Art_Galleries_Exhibit" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Business_NetWorking" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Comedy_Performing_Events" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Concerts_Tour_Dates" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Conferences" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="TradeShows" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Science_Education" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Festival" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Film" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Food_Wine" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Fundraising_Charity" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Health_Wellness" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Holidays_Events" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Kids_Baby_shower" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Literary_Books" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Museum_Attractions" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Neighbourhood" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="NightLife_Singles" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Corporate_Meetups" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Outdoor_Recreation" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Birthdays" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Family_Reunion" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Weddings" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Graduation_Party" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Bachelor_Party" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Pets" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Religious_Spiriutuality" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Politics" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Sales_Retalis" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Sports" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Technonolgy" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="University_Alumini" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PostedBy" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="Broachure" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Association Name="UserAdsDet_Event_Oraganization_Create" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="UserDet_Event_Oraganization_Create" Member="UserDet" ThisKey="Email" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Organizers" Member="Event_Organizers">
    <Type Name="Event_Organizer">
      <Column Name="Event_Organizer_Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="OrganizationName" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="OrganizerName" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="EmailId" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Contact" Type="System.String" DbType="VarChar(12)" CanBeNull="true" />
      <Column Name="Website" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Association Name="UserAdsDet_Event_Organizer" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Ticket_Mgmt" Member="Event_Ticket_Mgmts">
    <Type Name="Event_Ticket_Mgmt">
      <Column Name="Tiket_Mgmt_Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="SeatingArrangement" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="TicketSaleClosingDate" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="TicketType" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="TotalQty" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL" CanBeNull="false" />
      <Column Name="UnitPrice" Type="System.String" DbType="VarChar(6) NOT NULL" CanBeNull="false" />
      <Column Name="MaxOrder" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL" CanBeNull="false" />
      <Column Name="MinOrder" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL" CanBeNull="false" />
      <Column Name="AvailableQty" Type="System.Decimal" DbType="Decimal(6,0)" CanBeNull="true" />
      <Column Name="TermsConditions" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="CreatedBy" Type="System.String" DbType="VarChar(256) NOT NULL" CanBeNull="false" />
      <Column Name="CreateDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Association Name="Event_Ticket_Mgmt_Event_Ticket_Buy_Detail" Member="Event_Ticket_Buy_Details" ThisKey="Tiket_Mgmt_Id" OtherKey="TicketMgmtId" Type="Event_Ticket_Buy_Detail" />
      <Association Name="Event_Ticket_Mgmt_Event_Ticket_Buyer_Det" Member="Event_Ticket_Buyer_Dets" ThisKey="Tiket_Mgmt_Id" OtherKey="TicketMgmtId" Type="Event_Ticket_Buyer_Det" />
      <Association Name="Event_Ticket_Mgmt_Dummy_Event_Ticket_Buyer_Det" Member="Dummy_Event_Ticket_Buyer_Dets" ThisKey="Tiket_Mgmt_Id" OtherKey="TicketMgmtId" Type="Dummy_Event_Ticket_Buyer_Det" />
      <Association Name="Event_Ticket_Mgmt_Dummy_Event_Ticket_Buy_Detail" Member="Dummy_Event_Ticket_Buy_Details" ThisKey="Tiket_Mgmt_Id" OtherKey="TicketMgmtId" Type="Dummy_Event_Ticket_Buy_Detail" />
      <Association Name="UserAdsDet_Event_Ticket_Mgmt" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Ticket_Receipt_Det" Member="Event_Ticket_Receipt_Dets">
    <Type Name="Event_Ticket_Receipt_Det">
      <Column Name="Event_ReceiptId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="TotQty" Type="System.Decimal" DbType="Decimal(6,0)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Association Name="Event_Ticket_Receipt_Det_Event_Ticket_Buy_Detail" Member="Event_Ticket_Buy_Details" ThisKey="Event_ReceiptId" OtherKey="TicketReceiptId" Type="Event_Ticket_Buy_Detail" />
      <Association Name="Event_Ticket_Receipt_Det_Event_Ticket_Buyer_Det" Member="Event_Ticket_Buyer_Dets" ThisKey="Event_ReceiptId" OtherKey="TicketReceiptId" Type="Event_Ticket_Buyer_Det" />
      <Association Name="Event_Ticket_Receipt_Det_Dummy_Event_Ticket_Buyer_Det" Member="Dummy_Event_Ticket_Buyer_Dets" ThisKey="Event_ReceiptId" OtherKey="TicketReceiptId" Type="Dummy_Event_Ticket_Buyer_Det" />
      <Association Name="Event_Ticket_Receipt_Det_Dummy_Event_Ticket_Buy_Detail" Member="Dummy_Event_Ticket_Buy_Details" ThisKey="Event_ReceiptId" OtherKey="TicketReceiptId" Type="Dummy_Event_Ticket_Buy_Detail" />
      <Association Name="UserAdsDet_Event_Ticket_Receipt_Det" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Ticket_Buy_Details" Member="Event_Ticket_Buy_Details">
    <Type Name="Event_Ticket_Buy_Detail">
      <Column Name="TicketbuyId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="TicketMgmtId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="TicketReceiptId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="Quantity" Type="System.Decimal" DbType="Decimal(4,0) NOT NULL" CanBeNull="false" />
      <Column Name="TotalCost" Type="System.String" DbType="VarChar(10) NOT NULL" CanBeNull="false" />
      <Column Name="Fee" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Association Name="Event_Ticket_Mgmt_Event_Ticket_Buy_Detail" Member="Event_Ticket_Mgmt" ThisKey="TicketMgmtId" OtherKey="Tiket_Mgmt_Id" Type="Event_Ticket_Mgmt" IsForeignKey="true" />
      <Association Name="Event_Ticket_Receipt_Det_Event_Ticket_Buy_Detail" Member="Event_Ticket_Receipt_Det" ThisKey="TicketReceiptId" OtherKey="Event_ReceiptId" Type="Event_Ticket_Receipt_Det" IsForeignKey="true" />
      <Association Name="UserAdsDet_Event_Ticket_Buy_Detail" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.UserAdsDet" Member="UserAdsDets">
    <Type Name="UserAdsDet">
      <Column Name="UserAdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="UserEmailId" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="CategoryId" Type="System.Decimal" DbType="Decimal(2,0) NOT NULL" CanBeNull="false" />
      <Column Name="SubCategoryId" Type="System.Decimal" DbType="Decimal(4,0)" CanBeNull="true" />
      <Column Name="AdTitle" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="Price" Type="System.Decimal" DbType="Decimal(8,0)" CanBeNull="true" />
      <Column Name="Location" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="VarChar(1000)" CanBeNull="true" />
      <Column Name="OtherDecription" Type="System.String" DbType="VarChar(1000)" CanBeNull="true" />
      <Column Name="AdType" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="AdditionalInfo" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="VideoUrl" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Altitude" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="Longitude" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ZipCode" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="City" Type="System.String" DbType="VarChar(300)" CanBeNull="true" />
      <Column Name="BusinessURL" Type="System.String" DbType="VarChar(300)" CanBeNull="true" />
      <Column Name="Services" Type="System.String" DbType="VarChar(5000)" CanBeNull="true" />
      <Column Name="ImageUrl" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Association Name="UserAdsDet_Event_Guest" Member="Event_Guests" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Guest" />
      <Association Name="UserAdsDet_Event_Invitee" Member="Event_Invitees" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Invitee" />
      <Association Name="UserAdsDet_Event_Partner" Member="Event_Partners" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Partner" />
      <Association Name="UserAdsDet_Event_Sponsor_Create" Member="Event_Sponsor_Creates" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Sponsor_Create" />
      <Association Name="UserAdsDet_UserAdsImagesDet" Member="UserAdsImagesDets" ThisKey="UserAdId" OtherKey="UserAdId" Type="UserAdsImagesDet" />
      <Association Name="UserAdsDet_AdResponseDet" Member="AdResponseDets" ThisKey="UserAdId" OtherKey="AdId" Type="AdResponseDet" />
      <Association Name="UserAdsDet_Event_Venue_Manager" Member="Event_Venue_Managers" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Venue_Manager" />
      <Association Name="UserAdsDet_Event_Supplier_Network" Member="Event_Supplier_Networks" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Supplier_Network" />
      <Association Name="UserAdsDet_UserAdServiceDet" Member="UserAdServiceDets" ThisKey="UserAdId" OtherKey="UserAdID" Type="UserAdServiceDet" />
      <Association Name="UserAdsDet_Event_Oraganization_Create" Member="Event_Oraganization_Creates" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Oraganization_Create" />
      <Association Name="UserAdsDet_Event_Organizer" Member="Event_Organizers" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Organizer" />
      <Association Name="UserAdsDet_Event_Ticket_Mgmt" Member="Event_Ticket_Mgmts" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Ticket_Mgmt" />
      <Association Name="UserAdsDet_Event_Ticket_Receipt_Det" Member="Event_Ticket_Receipt_Dets" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Ticket_Receipt_Det" />
      <Association Name="UserAdsDet_Event_Ticket_Buy_Detail" Member="Event_Ticket_Buy_Details" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Ticket_Buy_Detail" />
      <Association Name="UserAdsDet_Event_Ticket_Buyer_Det" Member="Event_Ticket_Buyer_Dets" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Ticket_Buyer_Det" />
      <Association Name="UserAdsDet_Dummy_Event_Ticket_Buyer_Det" Member="Dummy_Event_Ticket_Buyer_Dets" ThisKey="UserAdId" OtherKey="AdId" Type="Dummy_Event_Ticket_Buyer_Det" />
      <Association Name="UserAdsDet_Dummy_Event_Ticket_Buy_Detail" Member="Dummy_Event_Ticket_Buy_Details" ThisKey="UserAdId" OtherKey="AdId" Type="Dummy_Event_Ticket_Buy_Detail" />
      <Association Name="UserAdsDet_Event_Create" Member="Event_Creates" ThisKey="UserAdId" OtherKey="AdId" Type="Event_Create" />
      <Association Name="CategoryDet_UserAdsDet" Member="CategoryDet" ThisKey="CategoryId" OtherKey="CategoryId" Type="CategoryDet" IsForeignKey="true" />
      <Association Name="SubCategoryDet_UserAdsDet" Member="SubCategoryDet" ThisKey="SubCategoryId" OtherKey="SubCategoryId" Type="SubCategoryDet" IsForeignKey="true" />
      <Association Name="UserDet_UserAdsDet" Member="UserDet" ThisKey="UserEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.cities" Member="cities">
    <Type Name="city">
      <Column Name="id" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="zip_codes" Type="System.String" DbType="VarChar(2701)" CanBeNull="true" />
      <Column Name="name" Type="System.String" DbType="VarChar(35)" CanBeNull="true" />
      <Column Name="county" Type="System.String" DbType="VarChar(80)" CanBeNull="true" />
      <Column Name="state_code" Type="System.String" DbType="Char(2)" CanBeNull="true" />
      <Column Name="state" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="type" Type="System.String" DbType="VarChar(23)" CanBeNull="true" />
      <Column Name="latitude" Type="System.Decimal" DbType="Decimal(8,5)" CanBeNull="true" />
      <Column Name="longitude" Type="System.Decimal" DbType="Decimal(8,5)" CanBeNull="true" />
      <Column Name="area_code" Type="System.String" DbType="VarChar(33)" CanBeNull="true" />
      <Column Name="population" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="households" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="median_income" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="land_area" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
      <Column Name="water_area" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
      <Column Name="time_zone" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Ticket_Buyer_Det" Member="Event_Ticket_Buyer_Dets">
    <Type Name="Event_Ticket_Buyer_Det">
      <Column Name="EventTicketBuyerId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="TicketReceiptId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="TicketMgmtId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="TicketQty" Type="System.Decimal" DbType="Decimal(6,0)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="BuyerEmailId" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Event_Id" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Association Name="Event_Ticket_Mgmt_Event_Ticket_Buyer_Det" Member="Event_Ticket_Mgmt" ThisKey="TicketMgmtId" OtherKey="Tiket_Mgmt_Id" Type="Event_Ticket_Mgmt" IsForeignKey="true" />
      <Association Name="Event_Ticket_Receipt_Det_Event_Ticket_Buyer_Det" Member="Event_Ticket_Receipt_Det" ThisKey="TicketReceiptId" OtherKey="Event_ReceiptId" Type="Event_Ticket_Receipt_Det" IsForeignKey="true" />
      <Association Name="UserAdsDet_Event_Ticket_Buyer_Det" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="Event_Create_Event_Ticket_Buyer_Det" Member="Event_Create" ThisKey="Event_Id" OtherKey="Event_Id" Type="Event_Create" IsForeignKey="true" />
      <Association Name="UserDet_Event_Ticket_Buyer_Det" Member="UserDet" ThisKey="BuyerEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Dummy_Event_Pay_Id" Member="Dummy_Event_Pay_Ids">
    <Type Name="Dummy_Event_Pay_Id">
      <Column Name="Event_Ticket_Pay_Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="Ticket_ReceiptId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="TicketMgmtId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Dummy_Event_Ticket_Available" Member="Dummy_Event_Ticket_Availables">
    <Type Name="Dummy_Event_Ticket_Available">
      <Column Name="id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="TicketIdMgmtId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="AvailableQty" Type="System.Decimal" DbType="Decimal(6,0) NOT NULL" CanBeNull="false" />
      <Column Name="ReceiptId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Dummy_Event_Ticket_Buyer_Det" Member="Dummy_Event_Ticket_Buyer_Dets">
    <Type Name="Dummy_Event_Ticket_Buyer_Det">
      <Column Name="EventTicketBuyerId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="TicketReceiptId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="TicketMgmtId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="TicketQty" Type="System.Decimal" DbType="Decimal(6,0)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="BuyerEmailId" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Event_Id" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Association Name="Event_Ticket_Mgmt_Dummy_Event_Ticket_Buyer_Det" Member="Event_Ticket_Mgmt" ThisKey="TicketMgmtId" OtherKey="Tiket_Mgmt_Id" Type="Event_Ticket_Mgmt" IsForeignKey="true" />
      <Association Name="Event_Ticket_Receipt_Det_Dummy_Event_Ticket_Buyer_Det" Member="Event_Ticket_Receipt_Det" ThisKey="TicketReceiptId" OtherKey="Event_ReceiptId" Type="Event_Ticket_Receipt_Det" IsForeignKey="true" />
      <Association Name="UserAdsDet_Dummy_Event_Ticket_Buyer_Det" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="Event_Create_Dummy_Event_Ticket_Buyer_Det" Member="Event_Create" ThisKey="Event_Id" OtherKey="Event_Id" Type="Event_Create" IsForeignKey="true" />
      <Association Name="UserDet_Dummy_Event_Ticket_Buyer_Det" Member="UserDet" ThisKey="BuyerEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Dummy_Event_Ticket_Buy_Details" Member="Dummy_Event_Ticket_Buy_Details">
    <Type Name="Dummy_Event_Ticket_Buy_Detail">
      <Column Name="TicketbuyId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="TicketMgmtId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="TicketReceiptId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="Quantity" Type="System.Decimal" DbType="Decimal(4,0) NOT NULL" CanBeNull="false" />
      <Column Name="TotalCost" Type="System.String" DbType="VarChar(10) NOT NULL" CanBeNull="false" />
      <Column Name="Fee" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="AvailQuant" Type="System.Decimal" DbType="Decimal(6,0)" CanBeNull="true" />
      <Column Name="Event_Id" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Association Name="Event_Ticket_Mgmt_Dummy_Event_Ticket_Buy_Detail" Member="Event_Ticket_Mgmt" ThisKey="TicketMgmtId" OtherKey="Tiket_Mgmt_Id" Type="Event_Ticket_Mgmt" IsForeignKey="true" />
      <Association Name="Event_Ticket_Receipt_Det_Dummy_Event_Ticket_Buy_Detail" Member="Event_Ticket_Receipt_Det" ThisKey="TicketReceiptId" OtherKey="Event_ReceiptId" Type="Event_Ticket_Receipt_Det" IsForeignKey="true" />
      <Association Name="UserAdsDet_Dummy_Event_Ticket_Buy_Detail" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
      <Association Name="Event_Create_Dummy_Event_Ticket_Buy_Detail" Member="Event_Create" ThisKey="Event_Id" OtherKey="Event_Id" Type="Event_Create" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.[Ad-Management]" Member="Ad_Managements">
    <Type Name="Ad_Management">
      <Column Name="[Ad-Banner-Id]" Member="Ad_Banner_Id" Type="System.Decimal" DbType="Decimal(5,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="Name" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="Organization" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Website" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Image" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="State" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="Country" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="Subdomain" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Bannername" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Ticket_Buyer_Companian_Det" Member="Event_Ticket_Buyer_Companian_Dets">
    <Type Name="Event_Ticket_Buyer_Companian_Det">
      <Column Name="Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="EventTicketBuyerId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="TicketReceiptId" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="Email" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Name" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="ContactNo" Type="System.String" DbType="VarChar(12)" CanBeNull="true" />
      <Column Name="Location" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.CelebrityDet" Member="CelebrityDets">
    <Type Name="CelebrityDet">
      <Column Name="CelebrityId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="CelebrityName" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="CelebrityOfficialImage" Type="System.Data.Linq.Binary" DbType="Image NOT NULL" CanBeNull="false" UpdateCheck="Never" />
      <Column Name="DOB" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="Earnings" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="MoneyRank" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="FameRank" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
      <Column Name="BirthLocation" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="CurrentStay" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Spouse" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="FamilyMembers" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="ZodiacSign" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="Height" Type="System.Decimal" DbType="Decimal(5,2)" CanBeNull="true" />
      <Column Name="Biography" Type="System.String" DbType="VarChar(5000)" CanBeNull="true" />
      <Column Name="Twitter" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="FB" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="GPlus" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="LanguesKnow" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="Filmygraphy" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="Awards" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="IndustryTypeId" Type="System.Decimal" DbType="Decimal(2,0)" CanBeNull="true" />
      <Column Name="Website" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="ContactInfo" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="YoutubeLink" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="ImageURL" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="VarChar(256)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="Industry" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="AvailableDateFrom" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="AvailableDateTo" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Association Name="CelebrityDet_CelebrityPhoto" Member="CelebrityPhotos" ThisKey="CelebrityId" OtherKey="CelebrityId" Type="CelebrityPhoto" />
    </Type>
  </Table>
  <Table Name="dbo.CelebrityPhotos" Member="CelebrityPhotos">
    <Type Name="CelebrityPhoto">
      <Column Name="CelebrityPhotoId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="CelebrityId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="Photo" Type="System.Data.Linq.Binary" DbType="Image NOT NULL" CanBeNull="false" UpdateCheck="Never" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Association Name="CelebrityDet_CelebrityPhoto" Member="CelebrityDet" ThisKey="CelebrityId" OtherKey="CelebrityId" Type="CelebrityDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Raffle_Master" Member="Raffle_Masters">
    <Type Name="Raffle_Master">
      <Column Name="Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="Name" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Email" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="PhoneNo" Type="System.String" DbType="VarChar(15) NOT NULL" CanBeNull="false" />
      <Column Name="RaffleNumber" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.Event_Create" Member="Event_Creates">
    <Type Name="Event_Create">
      <Column Name="Event_Id" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="Event_Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
      <Column Name="AdId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL" CanBeNull="false" />
      <Column Name="CategoryId" Type="System.Decimal" DbType="Decimal(4,0)" CanBeNull="true" />
      <Column Name="OptionOne" Type="System.Decimal" DbType="Decimal(4,0)" CanBeNull="true" />
      <Column Name="VenueName" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="EventDate" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="StartTime" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="EndTime" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="Venue" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
      <Column Name="AdmissionType" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="cbAdmission" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Event_Desc" Type="System.String" DbType="VarChar(8000) NOT NULL" CanBeNull="false" />
      <Column Name="Repeats" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="FBEventURL" Type="System.String" DbType="VarChar(1000)" CanBeNull="true" />
      <Column Name="EVentType" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="EventLogo" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="EventBrochure" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="ContactNumber2" Type="System.String" DbType="VarChar(12)" CanBeNull="true" />
      <Column Name="ContactNumber3" Type="System.String" DbType="VarChar(12)" CanBeNull="true" />
      <Column Name="Price1" Type="System.String" DbType="VarChar(6)" CanBeNull="true" />
      <Column Name="Price2" Type="System.String" DbType="VarChar(6)" CanBeNull="true" />
      <Column Name="Price3" Type="System.String" DbType="VarChar(6)" CanBeNull="true" />
      <Column Name="Price4" Type="System.String" DbType="VarChar(6)" CanBeNull="true" />
      <Column Name="EventEndDate" Type="System.String" DbType="VarChar(12)" CanBeNull="true" />
      <Column Name="ServiceTax" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="SeatingArrangement" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="TermsConditions" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="TimeZone" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="TicketBuyURL" Type="System.String" DbType="VarChar(1000)" CanBeNull="true" />
      <Association Name="Event_Create_Event_Ticket_Buyer_Det" Member="Event_Ticket_Buyer_Dets" ThisKey="Event_Id" OtherKey="Event_Id" Type="Event_Ticket_Buyer_Det" />
      <Association Name="Event_Create_Dummy_Event_Ticket_Buyer_Det" Member="Dummy_Event_Ticket_Buyer_Dets" ThisKey="Event_Id" OtherKey="Event_Id" Type="Dummy_Event_Ticket_Buyer_Det" />
      <Association Name="Event_Create_Dummy_Event_Ticket_Buy_Detail" Member="Dummy_Event_Ticket_Buy_Details" ThisKey="Event_Id" OtherKey="Event_Id" Type="Dummy_Event_Ticket_Buy_Detail" />
      <Association Name="Event_Category_Det_Event_Create" Member="Event_Category_Det" ThisKey="CategoryId" OtherKey="EventCategoryId" Type="Event_Category_Det" IsForeignKey="true" />
      <Association Name="UserAdsDet_Event_Create" Member="UserAdsDet" ThisKey="AdId" OtherKey="UserAdId" Type="UserAdsDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.User_Ad_Review_Det" Member="User_Ad_Review_Dets">
    <Type Name="User_Ad_Review_Det">
      <Column Name="ReviewId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="UserEmailId" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="Date" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReviewDesc" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Name" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="ReviewerEmailId" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="Rating" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="Ip" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Adid" Type="System.Decimal" DbType="Decimal(10,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.User_Review_Det" Member="User_Review_Dets">
    <Type Name="User_Review_Det">
      <Column Name="ReviewId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="UserEmailId" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Date" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReviewDesc" Type="System.String" DbType="VarChar(300)" CanBeNull="true" />
      <Column Name="Name" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="ReviewerEmail" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Rating" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="Ip" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Association Name="UserDet_User_Review_Det" Member="UserDet" ThisKey="UserEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.BusinessEnquiryDet" Member="BusinessEnquiryDets">
    <Type Name="BusinessEnquiryDet">
      <Column Name="EnquiryId" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="RespondentMailId" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="UserEmailId" Type="System.String" DbType="VarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="ResponseDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="Description" Type="System.String" DbType="VarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="PhoneNo" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="RespondentName" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Association Name="UserDet_BusinessEnquiryDet" Member="UserDet" ThisKey="UserEmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.UserDet" Member="UserDets">
    <Type Name="UserDet">
      <Column Name="UserSerNo" Type="System.Decimal" DbType="Decimal(10,0) NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="EmailId" Type="System.String" DbType="VarChar(100) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="ContactNo" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="Password" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="Location" Type="System.String" DbType="VarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="City" Type="System.String" DbType="VarChar(300)" CanBeNull="true" />
      <Column Name="ZipCode" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="Role" Type="System.String" DbType="VarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="CategoryId" Type="System.Decimal" DbType="Decimal(2,0)" CanBeNull="true" />
      <Column Name="BusinessName" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="BusinessContact" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="OperationLocatoin" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Website" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="BusinessLogo" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="BusinessFlyer" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="AboutUs" Type="System.String" DbType="VarChar(5000)" CanBeNull="true" />
      <Column Name="CreatedDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="Status" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="UserType" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="Latitude" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="Longitude" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="RoleId" Type="System.Decimal" DbType="Decimal(20,0)" CanBeNull="true" />
      <Column Name="Verified" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="FB_Id" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Facebook_URL" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Instagram_URL" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Youtube_URL" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Gplus_URL" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Pinrest_URL" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="Twitter_URL" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Association Name="UserDet_UserAdsImagesDet" Member="UserAdsImagesDets" ThisKey="EmailId" OtherKey="UserEmailId" Type="UserAdsImagesDet" />
      <Association Name="UserDet_AdResponseDet" Member="AdResponseDets" ThisKey="EmailId" OtherKey="UserEmailId" Type="AdResponseDet" />
      <Association Name="UserDet_Event_Venue_Manager" Member="Event_Venue_Managers" ThisKey="EmailId" OtherKey="Userid" Type="Event_Venue_Manager" />
      <Association Name="UserDet_Event_Supplier_Network" Member="Event_Supplier_Networks" ThisKey="EmailId" OtherKey="UserId" Type="Event_Supplier_Network" />
      <Association Name="UserDet_UserAdServiceDet" Member="UserAdServiceDets" ThisKey="EmailId" OtherKey="UserEmailId" Type="UserAdServiceDet" />
      <Association Name="UserDet_Event_Oraganization_Create" Member="Event_Oraganization_Creates" ThisKey="EmailId" OtherKey="Email" Type="Event_Oraganization_Create" />
      <Association Name="UserDet_UserAdsDet" Member="UserAdsDets" ThisKey="EmailId" OtherKey="UserEmailId" Type="UserAdsDet" />
      <Association Name="UserDet_Event_Ticket_Buyer_Det" Member="Event_Ticket_Buyer_Dets" ThisKey="EmailId" OtherKey="BuyerEmailId" Type="Event_Ticket_Buyer_Det" />
      <Association Name="UserDet_Dummy_Event_Ticket_Buyer_Det" Member="Dummy_Event_Ticket_Buyer_Dets" ThisKey="EmailId" OtherKey="BuyerEmailId" Type="Dummy_Event_Ticket_Buyer_Det" />
      <Association Name="UserDet_User_Review_Det" Member="User_Review_Dets" ThisKey="EmailId" OtherKey="UserEmailId" Type="User_Review_Det" />
      <Association Name="UserDet_BusinessEnquiryDet" Member="BusinessEnquiryDets" ThisKey="EmailId" OtherKey="UserEmailId" Type="BusinessEnquiryDet" />
      <Association Name="UserDet_UserDet" Member="UserDet2" ThisKey="EmailId" OtherKey="EmailId" Type="UserDet" Cardinality="One" />
      <Association Name="CategoryDet_UserDet" Member="CategoryDet" ThisKey="CategoryId" OtherKey="CategoryId" Type="CategoryDet" IsForeignKey="true" />
      <Association Name="UserDet_UserDet" Member="UserDet1" ThisKey="EmailId" OtherKey="EmailId" Type="UserDet" IsForeignKey="true" />
    </Type>
  </Table>
</Database>