Database model
tbl_Document
DocumentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
Description: nvarchar(2048) NULL
DocumentName: nvarchar(1024) NULL
DocumentTypeID: int NULL
CompanyID: int
PhysicalLocation: nvarchar(1024) NULL
OriginalFileName: nvarchar(1024) NULL
links
link_id: int PRIMARY KEY IDENTITY(1,1)
link: varchar(2000) NULL
hash: varchar(2000)  NULL
created: datetime NULL
oauth_access_tokens
access_token: varchar(80)
client_id: varchar(80) NULL
user_id: varchar(80) NULL
expires: datetime NULL
scope: varchar(4000) NULL
oauth_authorization_codes
authorization_code: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
redirect_uri: varchar(2000)
expires: datetime NOT NULL
scope: varchar(4000)
id_token: varchar(1000)
oauth_clients
client_id: varchar(80)
client_secret: varchar(80) NULL
redirect_uri: varchar(2000) NULL
grant_types: varchar(80) NULL
scope: varchar(4000) NULL
user_id: varchar(80) NULL
oauth_ip_logins
ip_login_id: int PRIMARY KEY IDENTITY(1,1)
ip: varchar(128)
user_agent: varchar(512)
login_time: datetime
user_id: varchar(4000)
access_token: varchar(4000)
location: varchar(4000)
success: bit NULL
oauth_jwt
client_id: varchar(80)
subject: varchar(80) NULL
public_key: varchar(2000)
oauth_public_keys
client_id: varchar(80)
private_key: varchar(8000)
public_key: varchar(8000)
encryption_algorithm: varchar(80) DEFAULT 'RS256'
oauth_refresh_tokens
refresh_token: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
expires: datetime NOT NULL
scope: varchar(4000) NULL
oauth_scopes
is_default: tinyint NULL
scope: varchar(80)
oauth_users
user_id: int  PRIMARY KEY IDENTITY(1,1)
username: varchar(40)
password: varchar(80)
email: varchar(4000) NULL
email_verified: tinyint NULL
scope: varchar(80) NULL
activate_token: varchar(200) NULL
reset_token: varchar(200) NULL
last_login: datetime NULL
first_name: varchar(512) NULL
last_name: varchar(512) NULL
external_id: int NULL
perm_group_to_resource
resource_id: int NULL
group_id: int NULL
perm: int
perm_resources
resource_id: int PRIMARY KEY IDENTITY(1,1)
resource_name: varchar(256)
resource_description: varchar(512) NULL
perm_roles_to_resource
role_id: int
resource_id: int
perm: int
perm_roles
role_id: int PRIMARY KEY IDENTITY(1,1)
role_name: varchar(256) NULL
resource_restrict: bit NULL
external_role: bit NULL
starting_page: varchar(256) NULL
perm_user_to_resource
resource_id: int NULL
user_id: int NULL
perm: int
perm_user_to_role
role_id: int NULL
user_id: int NULL
tbl_BenefitType
BenefitTypeID: int PRIMARY KEY IDENTITY(1,1)
BenefitType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_Candidate
CandidateID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(300) NULL
LastName: nvarchar(300) NULL
Email: nvarchar(50) NULL
Credentials: nvarchar(300) NULL
TitleID: int NULL
Address1: nvarchar(128) NULL
Address2: nvarchar(128) NULL
City: nvarchar(300) NULL
StateID: int NULL
PostalCode: nvarchar(32) NULL
Latitude: nvarchar(300) NULL
Longitude: nvarchar(300) NULL
CountryID: int NULL
Headline: nvarchar(300) NULL
Industries: nvarchar(300) NULL
Phone: nvarchar(300) NULL
ImagePath: nvarchar(512) NULL
LinkedinProfileURL: nvarchar(512) NULL
Relocate: bit NULL
ContactID: int NULL
CandidatePrivateToken: nvarchar(32) NULL
CandidateImportID: int NULL
ColorID: int NULL
tbl_CandidateAccessCheck
CandidateAccessCheckID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Count: int DEFAULT 0
Tab: nvarchar(1024) NULL
ContactID: int
CandidateID: int
tbl_CandidateCommission
CandidateCommissionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Name: nvarchar(2048) NULL
PaymentAmount: decimal (16,4) NULL
CandidateID: int
CompanyID: int
tbl_CandidateCredentials
CandidateCredentialsID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CredentialTypeID: int NULL
Organization: nvarchar(2048) NULL
StartDate: datetime NULL
EndDate: datetime NULL
Description: nvarchar(2048) NULL
Active: bit NULL
CandidateID: int
CandidateProfileID: int NULL
tbl_CandidateDesiredRole
CandidateDesiredRoleID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
DesiredRoleID: int NULL
LocationIDs: nvarchar(128) NULL
AvailabilityDate: datetime NULL
RelocationIssues: nvarchar(1024) NULL
DesiredSalary: decimal(16,4) NULL
DesiredBonus: decimal(16,4) NULL
DesiredLTI: nvarchar(64) NULL
DesiredVacation: nvarchar(64) NULL
DesiredBenefitID: int NULL
SalaryComments: nvarchar(2000) NULL
CandidateID: int
tbl_CandidateDocument
CandidateDocumentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
DocumentName: nvarchar(4000) NULL
DocumentTypeID: int NULL
PhysicalLocation: nvarchar(4000)
OriginalFileName: nvarchar(4000) NULL
Description: nvarchar(4000) NULL
IsPublic: bit NULL
CandidateID: int
tbl_CandidateEditPerm
CandidateEditPermID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
RecruiterID: int
CandidateID: int
tbl_CandidateImport
CandidateImportID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ImportRef: nvarchar(2048) NULL
CompanyID: int
FileName: nvarchar(2048) NULL
Result: int DEFAULT 0
tbl_CandidateMedia
CandidateMediaID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
DocumentName: nvarchar(4000) NULL
DocumentTypeID: int NULL
PhysicalLocation: nvarchar(4000)
OriginalFileName: nvarchar(4000) NULL
Description: nvarchar(4000) NULL
CandidateID: int
tbl_CandidateMessage
CandidateMessageID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CandidateID: int
Message: nvarchar(2048)
MessageTypeID: int
ContactID: int NULL
CompanyID: int
tbl_CandidateMessageSent
CandidateMessageSentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ContactID: int NULL
Date: datetime NULL
Subject: nvarchar(512) NULL
Message: nvarchar(4000) NULL
IsReceived: bit DEFAULT 0
CandidateID: int
tbl_CandidateMotivation
CandidateMotivationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
MotivationForOpportunity: nvarchar(4000) NULL
RecentAccomplishments: nvarchar(4000) NULL
DesiredRoleID: int NULL
LocationIDs: nvarchar(128) NULL
AvailabilityDate: datetime NULL
CandidateID: int
CandidateProfileID: int NULL
tbl_CandidateNotes
CandidateNotesID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Note: nvarchar(2048) NULL
CandidateID: int
tbl_CandidateProfile
CandidateProfileID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ProfileName: nvarchar(128) NULL
CandidateID: int
tbl_CandidateQuestions
CandidateQuestionsID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Question: nvarchar(2048) NULL
Answer: nvarchar(2048) NULL
Date: datetime NULL
CandidateID: int
tbl_CandidateReference
CandidateReferenceID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ReferenceName: nvarchar(2048) NULL
ReferenceDate: datetime NULL
RoleTitleID: int NULL
CompanyName: nvarchar(2048) NULL
OkToContact: bit NULL
Email: nvarchar(50) NULL
Phone: nvarchar(300) NULL
Relationship: nvarchar(2048)
CandidateID: int
CandidateProfileID: int NULL
tbl_CandidateResume
CandidateResumeID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
RoleTitleID: int NULL
SpecialityID: int NULL
CompanyName: nvarchar(128) NULL
StateID: int NULL
City: nvarchar(64) NULL
StartDate: datetime NULL
EndDate: datetime NULL
Description: nvarchar(2000) NULL
CandidateID: int
CandidateProfileID: int NULL
tbl_CandidateSkills
CandidateSkillsID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
SkillTypeID: int NULL
SkillID: int NULL
YearsExperience: int NULL
Description: nvarchar(2000) NULL
CandidateID: int
CandidateProfileID: int NULL
tbl_Client
ClientID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ClientName: nvarchar(64) NULL
OrganizationTypeID: int NULL
AddressName: nvarchar(128) NULL
AddressName2: nvarchar(128) NULL
CityName: nvarchar(128) NULL
StateID: int NULL
PostalCode: nvarchar(32) NULL
CountryID: int NULL
AreaCode: varchar(5) NULL
PhoneNumber: varchar(12) NULL
PhoneExtension: varchar(10) NULL
ClientLogoUrl: nvarchar(512) NULL
ImagePath: nvarchar(512) NULL
Latitude: nvarchar(64) NULL
Longitude: nvarchar(64) NULL
ColorID: int NULL
CompanyID: int
tbl_ClientContact
ClientContactID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(300) NULL
LastName: nvarchar(300) NULL
Email: nvarchar(50) NULL
TitleID: int NULL
Address1: nvarchar(128) NULL
Address2: nvarchar(128) NULL
City: nvarchar(300) NULL
StateID: int NULL
PostalCode: nvarchar(32) NULL
CountryID: int NULL
Phone: nvarchar(300) NULL
ContactNote: nvarchar(128) NULL
IsBillingContact: bit NULL
ContactID: int NULL
ClientID: int
tbl_ClientDocument
ClientDocumentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ClientID: int NULL
DocumentName: nvarchar(1024)
DocumentTypeID: int NULL
PhysicalLocation: nvarchar(1024)
OriginalFileName: nvarchar(1024)
Description: nvarchar(2048) NULL
tbl_ClientInvoice
ClientInvoiceID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
RoleID: int NULL
InvoiceDate: datetime NULL
ClientID: int
DocumentName: nvarchar(1024) NULL
DocumentTypeID: int NULL
PhysicalLocation: nvarchar(1024) NULL
OriginalFileName: nvarchar(1024) NULL
Description: nvarchar(2048) NULL
tbl_ClientLocation
ClientLocationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
LocationName: nvarchar(300)
LocationTypeID: int NULL
AddressName: nvarchar(128) NULL
AddressName2: nvarchar(128) NULL
CityName: nvarchar(128) NULL
StateID: int NULL
PostalCode: nvarchar(32) NULL
CountryID: int NULL
Latitude: nvarchar(64) NULL
Longitude: nvarchar(64) NULL
ClientID: int
tbl_ClientOverview
ClientOverviewID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
OrganizationalOverview: nvarchar(4000) NULL
AwardsAndAccolades: nvarchar(4000) NULL
ClientID: int
tbl_Company
CompanyID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CompanyName: nvarchar(64) NULL
AddressName: nvarchar(128) NULL
AddressName2: nvarchar(128) NULL
CityName: nvarchar(128) NULL
StateID: int NULL
PostalCode: nvarchar(32) NULL
CountryID: int NULL
AreaCode: varchar(5) NULL
PhoneNumber: varchar(12) NULL
PhoneExtension: varchar(10) NULL
CompanyLogoUrl: nvarchar(512) NULL
LineOfBusiness: varchar(80) NULL
ImagePath: nvarchar(512) NULL
DefaultEmail: nvarchar(64) NULL
Password: nvarchar(64) NULL
SMTPServer: nvarchar(64) NULL
Port: varchar(16) NULL
SSL: bit
TwilioPhoneNumber: nvarchar(64) NULL
tbl_CompanyCandidate
CompanyCandidateID: int PRIMARY KEY IDENTITY(1,1)
CandidateID: int
CompanyID: int
Connected: bit DEFAULT 0
ConnectedDateTime: datetime NULL
InviteSend: bit DEFAULT 0
TempEmail: nvarchar(50) NULL
TempFirstName: nvarchar(300) NULL
TempLastName: nvarchar(300) NULL
TempPhone: nvarchar(128) NULL
TempCredentials: nvarchar(300) NULL
TempTitleID: int NULL
TempCity: nvarchar(300) NULL
TempStateID: int NULL
TempHeadline: nvarchar(300) NULL
Source: nvarchar(50) NULL
tbl_Contact
ContactID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(20)
LastName: nvarchar(30)
Email: nvarchar(50)
Phone: nvarchar(50)
IsSystemUser: int NULL
UserID: int NULL
Timezone: nvarchar(64) DEFAULT 'UTC'
DateTimeFormat: nvarchar(64) DEFAULT 'MM/DD/YYYY h:mm A'
CompanyID: int
ImagePath: nvarchar(512) NULL
LastAccessed: datetime NULL
tbl_ContactGroups
ContactGroupID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
ArchivedDate: datetime NULL
CreateUpdateDate: datetime NULL
CompanyID: int
ContactGroupName: nvarchar(64) NULL
ContactGroupDesc: nvarchar(2048) NULL
ContactID: int NULL
tbl_ContactInGroup
ContactGroupID: int
ContactID: int
tbl_ContactNotification
ContactID: int NULL
NotificationChannelID: int NULL
NotificationLevelID: int NULL
Value: int NULL
tbl_Country
CountryID: int PRIMARY KEY IDENTITY(1,1)
Country: nvarchar(40) NULL
tbl_CredentialType
CredentialTypeID: int PRIMARY KEY IDENTITY(1,1)
CredentialType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_DirectMessage
DirectMessageID: int PRIMARY KEY IDENTITY(1,1)
DateTime: datetime
FromID: int
SystemID: int NULL
ToID: int
Msg: nvarchar(2000)
IsRead: bit NULL
tbl_DocumentType
DocumentTypeID: int PRIMARY KEY IDENTITY(1,1)
DocumentType: nvarchar(40) NULL
ArchivedDate: datetime NULL
ParentID: int NULL
CompanyID: int NULL
tbl_EmailTemplate
EmailTemplateID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
EmailTemplateName: nvarchar(40) NULL
Subject: nvarchar(2000) NULL
Content: nvarchar(2000) NULL
CompanyID: int NULL
tbl_ExpenseCategory
ExpenseCategoryID: int PRIMARY KEY IDENTITY(1,1)
ExpenseCategory: nvarchar(40) NULL
tbl_FeedbackQuestionType
FeedbackQuestionTypeID: int PRIMARY KEY IDENTITY(1,1)
FeedbackQuestionType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_FeedbackRecommend
FeedbackRecommendID: int PRIMARY KEY IDENTITY(1,1)
FeedbackRecommend: nvarchar(40) NULL
tbl_LocationType
LocationTypeID: int PRIMARY KEY IDENTITY(1,1)
LocationType: nvarchar(40) NULL
tbl_MediaBookmark
MediaBookmarkID: int PRIMARY KEY IDENTITY(1,1)
Note: nvarchar(1024)
RoleMediaID: int NULL
RefID: int NULL
TimeInSec: int NULL
tbl_MediaType
MediaTypeID: int PRIMARY KEY IDENTITY(1,1)
MediaType: nvarchar(64) NULL
IsVideoType: bit NULL
IsEnabled: bit NULL
tbl_Meeting
MeetingID: int PRIMARY KEY IDENTITY(1,1)
Meeting: nvarchar(64) NULL
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CandidateID: int NULL
RoleID: int NULL
StartDate: datetime NULL
EndDate: datetime NULL
Description: nvarchar(2000) NULL
AutoToken: nvarchar(2000) NULL
ContactIDs: nvarchar(2000) NULL
CompanyID: int NULL
tbl_NotificationChannel
NotificationChannelID: int PRIMARY KEY IDENTITY(1,1)
NotificationChannel: varchar(20) NULL
tbl_NotificationLevel
NotificationLevelID: int PRIMARY KEY IDENTITY(1,1)
NotificationLevel: varchar(20) NULL
tbl_OrganizationType
OrganizationTypeID: int PRIMARY KEY IDENTITY(1,1)
OrganizationType: nvarchar(40) NULL
tbl_PaymentType
PaymentTypeID: int PRIMARY KEY IDENTITY(1,1)
PaymentType: nvarchar(40) NULL
tbl_PersonalMeetingNotes
PersonalMeetingNotesID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
MeetingID: int NUll
Date: datetime NULL
Note: nvarchar(2000) NULL
CompanyID: int NULL
tbl_PromoContactForm
PromoContactFormID: int PRIMARY KEY IDENTITY(1,1)
CreateDate: datetime NULL
Name: nvarchar(60) NULL
Email: nvarchar(100) NULL
Phone: varchar(12) NULL
Comments: nvarchar(2000) NULL
tbl_RecruiterProfile
RecruiterProfileID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ShowInPublic: bit NULL
RecruiterName: nvarchar(2000)
About: nvarchar(2000) NULL
IndustryIDs: nvarchar(2000) NULL
CompanyID: int
tbl_Role
RoleID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
RoleName: nvarchar(2048)
ClientLocationID: int NULL
ContactID: int NULL
RoleTitleID: int NULL
Description: nvarchar(4000) NULL
RefNumber: nvarchar(4000) NULL
RoleStatusID: int NULL
PostDate: datetime NULL
FillDate: datetime NULL
ClientID: int NULL
FilledCandidateID: int NULL
AgreedSalary: decimal(16,4) NULL
SeoUrl: nvarchar(2000) NULL
IsPublic: bit NULL
SpecialityID: int NULL
RecruiterID: int NULL
ColorID: int NULL
CompanyID: int
tbl_RoleCandidate
RoleCandidateID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CandidateID: int NULL
RoleID: int NULL
CandidateProfileID: int NULL
Applied: int DEFAULT 0
Note: nvarchar(512) NULL
RoleCandidateStatusID: int NULL
CompanyID: int
tbl_RoleCandidateClientFeedback
RoleCandidateClientFeedbackID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ClientContactID: int NULL
CandidateID: int NULL
Token: nvarchar(2048) NULL
RoleCandidateClientFeedbackStatusID: int NULL DEFAULT 1
RoleCandidateInterviewID: int NULL
FeedbackRecommendID: int NULL
Comments: nvarchar(2048) NULL
RoleID: int
tbl_RoleCandidateClientFeedbackItem
RoleCandidateClientFeedbackItemID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
RoleFeedbackID: int NULL
Answer: nvarchar(2048) NULL
RoleCandidateClientFeedbackID: int NULL
tbl_RoleCandidateClientFeedbackStatus
RoleCandidateClientFeedbackStatusID: int PRIMARY KEY IDENTITY(1,1)
RoleCandidateClientFeedbackStatus: nvarchar(40) NULL
tbl_RoleCandidateInterview
RoleCandidateInterviewID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
StartDate: datetime NULL
EndDate: datetime NULL
CandidateID: int NULL
ClientContactID: int NULL
InterviewEmailSent: bit NULL
FeedbackEmailSent: bit NULL
OrderNum: int NULL
Description: nvarchar(512) NULL
AutoToken: nvarchar(2000) NULL
RoleID: int NULL
CompanyID: int
tbl_RoleCandidateStatus
RoleCandidateStatusID: int PRIMARY KEY IDENTITY(1,1)
RoleCandidateStatus: nvarchar(40) NULL
tbl_RoleCommission
RoleCommissionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Name: nvarchar(2048) NULL
PaymentTypeID: int NULL
PaymentAmount: decimal (16,4) NULL
DueDate: datetime NULL
Comments: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleCompensation
RoleCompensationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
SalaryRange: nvarchar(2048) NULL
SalaryBonus: nvarchar(2048) NULL
LTI: nvarchar(2048) NULL
Vacation: nvarchar(2048) NULL
BenefitTypeID: int NULL
Comments: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleDates
RoleDatesID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Milestone: nvarchar(2048) NULL
Date: datetime NULL
Description: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleDescription
RoleDescriptionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
DisplayClient: bit NULL
Description: nvarchar(2048) NULL
Requirements: nvarchar(2048) NULL
Responsibilities: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleDocument
RoleDocumentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
RoleID: int NULL
DocumentName: nvarchar(1024)
DocumentTypeID: int NULL
PhysicalLocation: nvarchar(1024)
OriginalFileName: nvarchar(1024)
Description: nvarchar(2048) NULL
tbl_RoleExpense
RoleExpenseID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Date: datetime NULL
Vendor: nvarchar(50) NULL
Amount: decimal (16,4) NULL
ExpenseCategoryID: int NULL
Comment: nvarchar(2000) NULL
RoleID: int
CompanyID: int
tbl_RoleExperience
RoleExperienceID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
RoleTitleID: int NULL
SpecialityID: int NULL
YearsExperience: int NULL
IsRequired: bit NULL
Description: nvarchar(2048) NULL
RankingPoints: int NULL
RoleID: int
CompanyID: int
tbl_RoleFeedback
RoleFeedbackID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
OrderNum: int NULL
Title: nvarchar(2048) NULL
Description: nvarchar(2048) NULL
FeedbackQuestionTypeID: int NULL
RoleID: int
CompanyID: int
tbl_RoleMedia
RoleMediaID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
RoleID: int NULL
DocumentName: nvarchar(1024)
DocumentTypeID: int NULL
PhysicalLocation: nvarchar(1024)
OriginalFileName: nvarchar(1024)
Description: nvarchar(2048) NULL
tbl_RolePricingItem
RolePricingItemID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
PaymentTypeID: int NULL
PaymentAmount: decimal (16,4) NULL
DueDate: datetime NULL
InvoiceDate: datetime NULL
Comments: nvarchar(2048) NULL
IsEstimate: bit NULL
IsInvoiced: bit NULL
RoleID: int
CompanyID: int
tbl_RolePricingType
RolePricingTypeID: int PRIMARY KEY IDENTITY(1,1)
RolePricingType: nvarchar(40) NULL
tbl_RoleQuestions
RoleQuestionsID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Description: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleQuestionsAnswers
RoleQuestionsAnswersID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CandidateID: int
RoleQuestionsID: int
Description: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleShare
RoleShareID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
Token: nvarchar(2048)
IsAccessAll: bit DEFAULT 1
CompanyID: int
tbl_RoleSkills
RoleSkillID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
SkillTypeID: int NULL
SkillID: int NULL
YearsExperience: int NULL
IsRequired: bit NULL
Description: nvarchar(2048) NULL
RankingPoints: int NULL
RoleID: int
CompanyID: int
tbl_RoleStatus
RoleStatusID: int PRIMARY KEY IDENTITY(1,1)
RoleStatus: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_RoleSurvey
RoleSurveyID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ShortSurveyQuestion: nvarchar(2048) NULL
ShortSurveyTypeID: int NULL
DesiredAnswer: nvarchar(2048) NULL
RankingPoints: int NULL
OrderNum: int NULL
Instructions: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleSurveyAnswers
RoleSurveyAnswersID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CandidateID: int
RoleSurveyID: int
CandidateAnswer: nvarchar(2048) NULL
RoleID: int
CompanyID: int
tbl_RoleSurveyItem
RoleSurveyItemID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
RoleSurveyItemName: nvarchar(2048) NULL
ItemOrderNum: int NULL
RoleSurveyID: int
tbl_RoleTitle
RoleTitleID: int PRIMARY KEY IDENTITY(1,1)
RoleTitle: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_ShortSurveyQuestion
ShortSurveyQuestionID: int PRIMARY KEY IDENTITY(1,1)
ShortSurveyQuestion: nvarchar(64) NULL
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CompanyID: int NULL
tbl_ShortSurveyType
ShortSurveyTypeID: int PRIMARY KEY IDENTITY(1,1)
ShortSurveyType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_Skill
SkillID: int PRIMARY KEY IDENTITY(1,1)
Skill: nvarchar(64) NULL
SkillTypeID: int NULL
IsEnabled: bit NULL
tbl_SkillType
SkillTypeID: int PRIMARY KEY IDENTITY(1,1)
SkillType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_Speciality
SpecialityID: int PRIMARY KEY IDENTITY(1,1)
Speciality: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_State
StateID: int PRIMARY KEY IDENTITY(1,1)
StateAbbreviation: nvarchar(2) NULL
State: nvarchar(50) NULL
ArchivedDate: datetime NULL
tbl_Subscription
SubscriptionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
SubscriptionStatusID: int NULL
CompanyID: int
SubscriptionPlanID: int NULL
Quantity: int DEFAULT 0
NextBillingDate: datetime NULL
ExpiryDate: datetime NULL
PaymentReference: nvarchar(512)
CustomerReference: nvarchar(512)
PaymentProvider: int
tbl_SubscriptionPlan
SubscriptionPlanID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
PlanName: nvarchar(512)
PlanDescription: nvarchar(2000)
PlanAmount: float NULL
tbl_Support
SupportID: int PRIMARY KEY IDENTITY(1,1)
CreateDate: datetime NULL
Name: nvarchar(60) NULL
Email: nvarchar(100) NULL
PhoneNumber: varchar(12) NULL
AddressName: nvarchar(128) NULL
Description: nvarchar(2000) NULL
SupportType: nvarchar(150) NULL
CompanyID: int NULL
tbl_Task
TaskID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
TaskTitle: nvarchar(64) NULL
TaskTypeID: int NULL
RoleID: int NULL
CandidateID: int NULL
TaskStatusID: int NULL
TaskDate: datetime NULL
Description: nvarchar(2000) NULL
CompanyID: int
tbl_TaskStatus
TaskStatusID: int PRIMARY KEY IDENTITY(1,1)
TaskStatus: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_TaskType
TaskTypeID: int PRIMARY KEY IDENTITY(1,1)
TaskType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_TermsPricing
TermsPricingID: int PRIMARY KEY IDENTITY(1,1)
TermsPricing: nvarchar(40) NULL