Databases
The project will two database connections. User stories will reference which connection string should be used for each/all database interaction within the user story. Each database connection will have 4 configurations associated with it
The ASWB connection strings are used for WRITING records.
The ASWBOnline connection strings are used for READING records.
Connection String Name | Server name | Database name | UserName | Description | |
|---|---|---|---|---|---|
| 1 | ASWBLocal | local | ExamRegistration | ||
| 2 | ASWBQA | ASWBDevData | ExamRegistration | ||
| 3 | ASWBTest | ASWBDecData | ExamRegistration | ||
| 4 | ASWB | ASWBSQL2\ASWBSQL2 | ASWBTest | ||
| 5 | ASWBOnlineLocal | local | ExamRegistration | ||
| 6 | ASWBOnlineQA | ASWBDevData | ExamRegistration | ||
| 7 | ASWBOnlineTest | ASWBDevData | ExamRegistration | ||
| 8 | ASWBOnline | ASWBData | ExamRegistration | ||
| 9 | |||||
| 10 |
Key Reference Information
Column / Item References | ID Number | Display |
ExamBeforeGraduation | 0 | None Selected |
ExamBeforeGraduation | 1 | No |
ExamBeforeGraduation | 2 | Yes |
ExamBeforeGraduation | 3 | Maybe |
ExamBeforeGraduation | 99 | Unknown |
ExamBeforePostGrad | 0 | None Selected |
ExamBeforePostGrad | 1 | No |
ExamBeforePostGrad | 2 | Yes |
ExamBeforePostGrad | 3 | Maybe |
ExamBeforePostGrad | 99 | Unknown |
IsJurisdiction | 0 | None Selected |
IsJurisdiction | 1 | No |
IsJurisdiction | 2 | Yes |
IsJurisdiction | 3 | Maybe |
IsJurisdiction | 99 | Unknown |
IsMember | 0 | None Selected |
IsMember | 1 | No |
IsMember | 2 | Yes |
IsMember | 3 | Maybe |
IsMember | 99 | Unknown |
MSWBeforeExam | 0 | None Selected |
MSWBeforeExam | 1 | No |
MSWBeforeExam | 2 | Yes |
MSWBeforeExam | 3 | Maybe |
MSWBeforeExam | 99 | Unknown |
UsesAGExam | 0 | None Selected |
UsesAGExam | 1 | No |
UsesAGExam | 2 | Yes |
UsesAGExam | 3 | Maybe |
UsesAGExam | 99 | Unknown |
UsesASExam | 0 | None Selected |
UsesASExam | 1 | No |
UsesASExam | 2 | Yes |
UsesASExam | 3 | Maybe |
UsesASExam | 99 | Unknown |
UsesBSExam | 0 | None Selected |
UsesBSExam | 1 | No |
UsesBSExam | 2 | Yes |
UsesBSExam | 3 | Maybe |
UsesBSExam | 99 | Unknown |
UsesCLExam | 0 | None Selected |
UsesCLExam | 1 | No |
UsesCLExam | 2 | Yes |
UsesCLExam | 3 | Maybe |
UsesCLExam | 99 | Unknown |
UsesMSExam | 0 | None Selected |
UsesMSExam | 1 | No |
UsesMSExam | 2 | Yes |
UsesMSExam | 3 | Maybe |
UsesMSExam | 99 | Unknown |
Exam Level | 0 | None Selected |
Exam Level | 1 | Associate |
Exam Level | 2 | Bachelors |
Exam Level | 3 | Masters |
Exam Level | 4 | Advanced Generalist |
Exam Level | 5 | Clinical |