DCS Database Field formats and length

Admin ID Table

AdminID text max 50 char

FirstName text max 50 char

LastName text max 50 char

Title text max 50 char

Department text max 50 char

PhoneNumber text max 50 char

Email text max 50 char

Password text max 50 char

User Info Table

UserID text max 50 char

FirstName text max 50 char

LastName text max 50 char

Phone text max 50 char

Email text max 50 char

Password text max 50 char

Announcement Table

AnnouncementID text max 50 char

Date Date max 50 char

Department text max 50 char

AnnouncementTitle text max 50 char

Comment text max 50 char

Award Table

AwardID text max 50 char

Date Date max 50 char

Department text max 50 char

AwardTitle text max 50 char

Comment text max 50 char

ImportantDates Table

ImpDateID text max 50 char

Date Date max 50 char

Department text max 50 char

ImpDateTitle text max 50 char

Comment text max 50 char

Opportunities Table

OpportunityID text max 50 char

Date Date max 50 char

Department text max 50 char

OpportunityTitle text max 50 char

Comment text max 50 char

Meetings Table

MeetingID text max 50 char

Date Date max 50 char

Department text max 50 char

MeetingsTitle text max 50 char

Comment text max 50 char

SpecialAlerts Table

SpecialAlertsID text max 50 char

Date Date max 50 char

Department text max 50 char

SpecialAlertsTitle text max 50 char

Comment text max 50 char

SpecialMessages Table

SpecialMessageID text max 50 char

Date Date max 50 char

Department text max 50 char

SpecialMessageTitle text max 50 char

Comment text max 50 char

* Primary keys are shown in red.