Versus Baseball

Tables (8)

Account

  • UserNumber — int — Primary key — NOT NULL
  • UserId — nvarchar(MAX)
  • UserPassword — nvarchar(MAX)
  • UserPassword_Confirm — nvarchar(MAX)
  • UserTitle — nvarchar(MAX)
  • FirstName — nvarchar(50)
  • MiddleName — nvarchar(50)
  • LastName — nvarchar(50)
  • DOB — date
  • Email — nvarchar(MAX)
  • Phone — int
  • Address — nvarchar(MAX)
  • City — nvarchar(20)
  • State — varchar(20)
  • ZipCode — int
  • UserImage (Image) — nvarchar(MAX)
  • CreatedDate — Date

Family Member (FamilyMember)

  • MemberNumber — int — Primary key — NOT NULL
  • UserNumber — int — Foreign key → Account.UserNumber — NOT NULL
  • FirstName — nvarchar(50)
  • LastName — nvarchar(50)
  • Email — nvarchar(MAX)
  • PhoneNumber — int
  • Role — varchar(10)

Gallery

  • PhotoNumber — int — Primary key — NOT NULL
  • UserNumber — int — Foreign key → Account.UserNumber — NOT NULL
  • ImageData — nvarchar(MAX)

Location

  • LocationNumber (LocaionNumber) — int — Primary key — NOT NULL
  • ScheduleNumber — int — Foreign key → Schedule.ScheduleNumber — NOT NULL
  • FieldName — nvarchar(MAX)
  • FieldAddress — nvarchar(MAX)
  • FieldCity — nvarchar(20)
  • FieldState — varchar(10)
  • FieldZipCode — int

Schedule

  • ScheduleNumber — int — Primary key — NOT NULL
  • UserTeamNumber — int — Foreign key → UserTeam.UserTeamNumber — NOT NULL
  • ScheduleName (EventName) — nvarchar(50)
  • Field (IsEvent) — bit
  • Date — datetime
  • Location — nvarchar(50)
  • LocationDetail — nvarchar(50)
  • Availability — int
  • Notes — nvarchar(MAX)
  • Field (Opponent) — nvarchar(MAX)
  • Field2 (Score) — varchar(10)

State

  • StateNumber — int — Primary key — NOT NULL
  • StateCode — char(2)
  • StateName — varchar(20)

Team

  • TeamNumber — int — Primary key — NOT NULL
  • TeamName — nvarchar(MAX)
  • TeamImage — nvarchar(MAX)
  • TeamManager (TeamOwner) — varchar(50)
  • Address — nvarchar(MAX)
  • City — nvarchar(20)
  • State — varchar(10)
  • ZipCode — int
  • CreatedDate — Date

UserTeam

  • UserTeamNumber — int — Primary key — NOT NULL
  • UserNumber — int — Foreign key → Account.UserNumber — NOT NULL
  • TeamNumber — int — Foreign key → Team.TeamNumber — NOT NULL
  • TeamName — nvarchar(MAX)
  • Location — nvarchar(50)
  • Notes — nvarchar(MAX)
  • Position — varchar(50)
  • Record — nvarchar(MAX)
  • Field (Attendance) — varchar(3)
  • Field (IsPlayer) — bit