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