SeniorLearn

Tables (15)

Administrator (Untitled15)

  • Id (Field)
  • FirstName (Field2)
  • LastName (Field3)
  • Method: ApproveRegistration (Field4)
  • Method: ApproveRenewal (Field5)
  • Method: ApprovePayment (Field10)
  • Method: ApproveHiatusOrExtension (Field8)
  • Method: SendCommunications (Field6)
  • Method: LogIn (Field7)

Category (Untitled)

  • Id (Field)
  • Name (Field2)
  • Description (Field3)

Dashboard (Untitled10)

  • MemberId (Field)
  • Notifications (Field2)
  • FontSize (Field3)
  • Captioning (Field4)
  • BrightnessMode (Field5)

Enrolment (Untitled7)

  • Id (Field)
  • MemberId (Field2)
  • LessonId (Field3)
  • EnrolmentDate (Field4)
  • Status (Field5)

Lesson (Untitled2)

  • Id (Field)
  • ProgramId (Field2)
  • StatusId (Field3)
  • Title (Field4)
  • Location (Field5)
  • Descrption (Field6)
  • Date (Field7)
  • MaxCapacity (Field8)
  • CurrentCapacity (Field9)
  • DeliveryMode (Field10)
  • StartTime (Field11)
  • EndTime (Field12)

LessonStatus (Untitled3)

  • Name (Field)
  • Description (Field2)

Login (Untitled11)

  • Id (Field)
  • Username (Field2)
  • Password (Field3)
  • IsAdministrator (Field4)

Member (Untitled9)

  • Id (Field)
  • UserId (Field2)
  • FirstName (Field3)
  • LastName (Field4)
  • Email (Field5)
  • Phone (Field6)
  • RegistrationDate (Field7)
  • MembershipStartDate (Field8)
  • MebershipEndDate (Field9)
  • Method: SendCommunications (Field10)
  • Method: EnrolCourse (Field11)
  • Method: CreateCourse (Field12)
  • Method: Login (Field13)
  • Method: RegsisterMembership/CreateAccount (Field14)
  • Method: RenewMembership/PayAnnualFee (Field15)

MemberRole (Untitled5)

  • Id (Field)
  • MemberId (Field2)
  • RoleId (Field3)
  • IsActive (Field4)

MembershipFeeHistory (Untitled14)

  • Id (Field)
  • MembershipFeeTypeId (Field2)
  • Amount (Field3)
  • EffectiveDate (Field4)

MembershipFeeType (Untitled13)

  • Id (Field)
  • Name (Field2)
  • IsActive (Field3)

MembershipStatusChange (Untitled8)

  • Id (Field)
  • MemberId (Field2)
  • ChangeType (Field3)
  • StartDate (Field4)
  • EndDate (Field5)

PaymentTransactionHistory (Untitled12)

  • Id (Field)
  • MemberId (Field2)
  • Amount (Field3)
  • PaymentDate (Field4)
  • PaymentMethod (Field5)
  • Notes (Field6)

Program (Untitled6)

  • Id (Field)
  • MemberId (Field2)
  • CategoryId (Field3)
  • ProgramCode (Field4)
  • Title (Field5)
  • Description (Field6)
  • StartDate (Field7)
  • EndDate (Field8)
  • IsCourse (Field9)

Role (Untitled4)

  • RoleName (Field)
  • FeeExempt (Field2)