Basic ERD diagram of PV Database
Nevar pievienot vairāk kā 25 tēmas Tēmai ir jāsākas ar burtu vai ciparu, tā var saturēt domu zīmes ('-') un var būt līdz 35 simboliem gara.

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. //------------------------------------------------------------------------------
  2. // <auto-generated>
  3. // This code was generated from a template.
  4. //
  5. // Manual changes to this file may cause unexpected behavior in your application.
  6. // Manual changes to this file will be overwritten if the code is regenerated.
  7. // </auto-generated>
  8. //------------------------------------------------------------------------------
  9. namespace ERD
  10. {
  11. using System;
  12. using System.Collections.Generic;
  13. public partial class TblVoucher
  14. {
  15. public int OID { get; set; }
  16. public string CreatedBy { get; set; }
  17. public Nullable<System.DateTime> CreatedDate { get; set; }
  18. public Nullable<int> DetailedInfo { get; set; }
  19. public Nullable<int> Campaign { get; set; }
  20. public string ConfigurationCode { get; set; }
  21. public Nullable<int> Resort { get; set; }
  22. public string UnitNumber { get; set; }
  23. public Nullable<int> VoucherSeries { get; set; }
  24. public Nullable<System.Guid> AssetAvail { get; set; }
  25. public string VoucherNumber { get; set; }
  26. public string AdditionalCellPhoneNumber { get; set; }
  27. public Nullable<bool> WeekReminderEmailSent { get; set; }
  28. public Nullable<bool> WelcomeMessageSent { get; set; }
  29. public Nullable<bool> DayOfArrivalMessageSent { get; set; }
  30. public Nullable<bool> DayOfDepartureMessageSent { get; set; }
  31. public Nullable<bool> SurveyEmailSent { get; set; }
  32. public Nullable<bool> BookingConfirmationFailed { get; set; }
  33. public Nullable<bool> Contacted { get; set; }
  34. public Nullable<bool> Arrived { get; set; }
  35. public Nullable<System.DateTime> ArrivalDate { get; set; }
  36. public Nullable<System.DateTime> DepartureDate { get; set; }
  37. public Nullable<System.DateTime> ResortBookingDate { get; set; }
  38. public Nullable<System.DateTime> VoucherRegDate { get; set; }
  39. public string Guest1Name { get; set; }
  40. public string Guest1Surname { get; set; }
  41. public string Guest1IdNumber { get; set; }
  42. public string Guest2Name { get; set; }
  43. public string Guest2Surname { get; set; }
  44. public string Guest2IdNumber { get; set; }
  45. public string Child1Name { get; set; }
  46. public string Child2Name { get; set; }
  47. public string Child3Name { get; set; }
  48. public string Disabilities { get; set; }
  49. public string VehicleRegNo { get; set; }
  50. public string ReasonSentFailed { get; set; }
  51. public virtual TblVoucherSery TblVoucherSery { get; set; }
  52. public virtual TblResort TblResort { get; set; }
  53. public virtual TblDetailedInfo TblDetailedInfo { get; set; }
  54. public virtual TblMarketingCampaign TblMarketingCampaign { get; set; }
  55. }
  56. }