| Table |
Column |
Type |
PK |
Null |
Unique |
Cardinality |
Sample Data |
Comment |
| ADDRESS |
ADDRESS_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
ADDRESS ID |
| ADDRESS |
USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
USER ID |
| ADDRESS |
STREET |
VARCHAR2[100] |
|
NO |
N/A |
N/A |
|
STREET |
| ADDRESS |
ADDITIONAL_ADDRESS_INFORMATION |
VARCHAR2[200] |
|
YES |
N/A |
N/A |
|
ADDITIONAL ADDRESS INFORMATION |
| ADDRESS |
BUILDING_NUMBER |
VARCHAR2[10] |
|
YES |
N/A |
N/A |
|
BUILDING NUMBER |
| ADDRESS |
UNIT |
VARCHAR2[10] |
|
YES |
N/A |
N/A |
|
This is apartment or townhouse number. It may have an alphanumeric values such as "PH 4" (penthouse #4) |
| ADDRESS |
CITY |
VARCHAR2[50] |
|
NO |
N/A |
N/A |
|
CITY |
| ADDRESS |
POSTAL_CODE |
VARCHAR2[10] |
|
YES |
N/A |
N/A |
|
This field will contain:
Postal Code (Canada)
ZIP (US)
Postanski Broj (Balkan countries)
Equivalent information for other countries |
| ADDRESS |
STATE |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
STATE |
| ADDRESS |
COUNTRY |
VARCHAR2[50] |
|
NO |
N/A |
N/A |
|
COUNTRY |
| ADDRESS |
ADDRESS_URL |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
URL of the Address. For example, GOOGLE mal URL. |
| ADDRESS |
ADDRESS_TYPE |
CHAR[1] |
|
NO |
N/A |
N/A |
|
P - Personal (Home)
B - Business (Office)
|
| ADDRESS |
SHIPPING_ADDRESS_IND |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Indicated if this is a shipping address. |
| ADDRESS |
BILLING_ADDRESS_IND |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Indicates if this is a Billing address |
| ADDRESS |
SHIPP_BILL_ADR_SAME_IND |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Indicates if shipping and billing addresses are the same |
| ADDRESS |
ACTIVE_FROM |
DATE[7] |
|
NO |
N/A |
N/A |
|
ACTIVE FROM |
| ADDRESS |
ACTIVE_TO |
DATE[7] |
|
YES |
N/A |
N/A |
|
In this value is NULL then this recor represents the current address |
| ADDRESS |
ADDRESS_STATUS |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
Status of this address |
| ADDRESS |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| ADDRESS |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| ADDRESS |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| ADDRESS |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| ANSWER |
ANSWER_ID |
NUMBER[10] |
1 |
NO |
YES |
605
(100.00%) |
| Value | Length | Count | | 5000 | | 1 | | 5001 | | 1 | | 5002 | | 1 | | 5003 | | 1 | | 5004 | | 1 | | 5005 | | 1 | | 5006 | | 1 | | 5007 | | 1 | | 5008 | | 1 | | 5009 | | 1 |
|
ANSWER ID |
| ANSWER |
QUESTION_ID |
NUMBER[10] |
|
NO |
NO |
121
(20.00%) |
| Value | Length | Count | | 5000 | | 5 | | 5001 | | 5 | | 5002 | | 5 | | 5003 | | 5 | | 5004 | | 5 | | 5005 | | 5 | | 5006 | | 5 | | 5007 | | 5 | | 5008 | | 5 | | 5009 | | 5 |
|
QUESTION ID |
| ANSWER |
ANSWER_TEXT |
VARCHAR2[2000] |
|
NO |
YES |
N/A |
|
This is free form text for "essay" answers.
It is also used for "FILL IN BLANKS" type of questions. |
| ANSWER |
ANSWER_ORDINAL_NUMBER |
NUMBER[0] |
|
YES |
NO |
5
(0.83%) |
| Value | Length | Count | | 2 | | 123 | | 1 | | 121 | | 4 | | 121 | | 5 | | 121 | | 3 | | 119 |
|
Determines the order in which question will appear in the list under the question. |
| ANSWER |
CORRECT_ANSWER_IND |
CHAR[1] |
|
YES |
NO |
2
(0.33%) |
| Value | Length | Count | | null | 0 | 485 | | Y | 1 | 120 |
|
Indicates if this is the correct answer. |
| ANSWER |
ANSWER_ADDITIONAL_INFO |
VARCHAR2[2000] |
|
YES |
YES |
N/A |
|
This is additional inforamtion that can be used to explain the answer. It may be used for educational purposes. |
| ANSWER |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(0.17%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ANSWER |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
5
(0.83%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:51:08.0000 | | 137 | | Sun Feb 23, 2014 09:51:09.0000 | | 121 | | Sun Feb 23, 2014 09:51:11.0000 | | 120 | | Sun Feb 23, 2014 09:51:07.0000 | | 118 | | Sun Feb 23, 2014 09:51:10.0000 | | 109 |
|
CREATE DATETIME |
| ANSWER |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(0.17%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ANSWER |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(0.17%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS |
CLASS_ID |
NUMBER[10] |
1 |
NO |
YES |
25
(100.00%) |
| Value | Length | Count | | 1 | | 1 | | 2 | | 1 | | 3 | | 1 | | 4 | | 1 | | 5 | | 1 | | 6 | | 1 | | 7 | | 1 | | 8 | | 1 | | 9 | | 1 | | 10 | | 1 |
|
CLASS_ID |
| CLASS |
CLASS_NAME |
VARCHAR2[200] |
|
NO |
YES |
25
(100.00%) |
| Value | Length | Count | | Class I-a | 9 | 1 | | Class I-b | 9 | 1 | | Class I-c | 9 | 1 | | Class I-d | 9 | 1 | | Class I-e | 9 | 1 | | Class II-a | 10 | 1 | | Class II-b | 10 | 1 | | Class II-c | 10 | 1 | | Class II-d | 10 | 1 | | Class II-e | 10 | 1 |
|
CLASS_NAME |
| CLASS |
CLASS_CODE |
VARCHAR2[30] |
|
YES |
NO |
1
(4.00%) |
|
CLASS_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS |
CLASS_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
NO |
1
(4.00%) |
|
Description of the CLASS or the comment about the CLASS
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS |
ACTIVE_FROM |
DATE[7] |
|
YES |
NO |
5
(20.00%) |
| Value | Length | Count | | Mon Feb 24, 2003 08:10:05.0000 | | 5 | | Fri Apr 23, 2004 08:18:25.0000 | | 5 | | Fri Dec 24, 2004 05:10:55.0000 | | 5 | | Fri Dec 24, 2004 10:10:55.0000 | | 5 | | Thu Dec 25, 2008 06:10:17.0000 | | 5 |
|
Witch column "ACTIVE_TO" describes the period when this Student Class is active. For example it could be specifict school year. |
| CLASS |
ACTIVE_TO |
DATE[7] |
|
YES |
YES |
25
(100.00%) |
| Value | Length | Count | | Fri Dec 25, 2015 06:10:17.0000 | | 1 | | Sat Dec 26, 2015 06:10:17.0000 | | 1 | | Sun Dec 27, 2015 06:10:17.0000 | | 1 | | Mon Dec 28, 2015 06:10:17.0000 | | 1 | | Tue Dec 29, 2015 06:10:17.0000 | | 1 | | Wed Dec 30, 2015 06:10:17.0000 | | 1 | | Thu Dec 31, 2015 06:10:17.0000 | | 1 | | Fri Jan 1, 2016 06:10:17.0000 | | 1 | | Sat Jan 2, 2016 06:10:17.0000 | | 1 | | Sun Jan 3, 2016 06:10:17.0000 | | 1 |
|
With column "ACTIVE_FROM" describes the period when this Student Class is active. For example it could be specifict school year. |
| CLASS |
CLASS_STATUS |
VARCHAR2[3] |
|
YES |
NO |
1
(4.00%) |
|
Describes the status of the Student Class.
For example:
- Stand By (prepared for next year)
- Active
- Finished
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(4.00%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
2
(8.00%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:50:47.0000 | | 24 | | Sun Feb 23, 2014 09:50:46.0000 | | 1 |
|
CREATE DATETIME |
| CLASS |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(4.00%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(4.00%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS_COURSE |
CLASS_ID |
NUMBER[10] |
1 |
NO |
NO |
3
(3.23%) |
| Value | Length | Count | | 1 | | 31 | | 2 | | 31 | | 3 | | 31 |
|
CLASS_ID |
| CLASS_COURSE |
COURSE_ID |
NUMBER[10] |
2 |
NO |
NO |
31
(33.33%) |
| Value | Length | Count | | 2 | | 3 | | 3 | | 3 | | 4 | | 3 | | 5 | | 3 | | 6 | | 3 | | 7 | | 3 | | 8 | | 3 | | 9 | | 3 | | 26 | | 3 | | 27 | | 3 |
|
COURSE_ID |
| CLASS_COURSE |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(1.08%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS_COURSE |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
2
(2.15%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:51:14.0000 | | 86 | | Sun Feb 23, 2014 09:51:13.0000 | | 7 |
|
CREATE DATETIME |
| CLASS_COURSE |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(1.08%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CLASS_COURSE |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(1.08%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CODE |
CODE_ID |
VARCHAR2[3] |
1 |
NO |
YES |
71
(100.00%) |
| Value | Length | Count | | AAL | 3 | 1 | | ACE | 3 | 1 | | ACT | 3 | 1 | | ADS | 3 | 1 | | AOL | 3 | 1 | | AOP | 3 | 1 | | APR | 3 | 1 | | ATN | 3 | 1 | | ATR | 3 | 1 | | ATV | 3 | 1 |
|
This column is created
to be sole column in Primary Key.
This is intentional because this way all codes are unique accross the
system and there is no posibility for confusion (for example: "what code
type is this code?") |
| CODE |
CODE_TYPE_ID |
VARCHAR2[3] |
|
NO |
NO |
23
(32.39%) |
| Value | Length | Count | | QST | 3 | 8 | | QUT | 3 | 7 | | USS | 3 | 5 | | QAS | 3 | 4 | | QDS | 3 | 4 | | AST | 3 | 3 | | COS | 3 | 3 | | CST | 3 | 3 | | DUT | 3 | 3 | | ESS | 3 | 3 |
|
CODE TYPE ID |
| CODE |
CODE_NAME |
VARCHAR2[50] |
|
NO |
NO |
60
(84.51%) |
| Value | Length | Count | | ACTIVE | 6 | 4 | | DELETED | 7 | 3 | | CANCELLED | 9 | 2 | | DEFFERED | 8 | 2 | | EXPIRED | 7 | 2 | | INACTIVE | 8 | 2 | | MANAGER | 7 | 2 | | SUSPENDED | 9 | 2 | | ADMINISTRATOR | 13 | 1 | | ALL ON PAGE | 11 | 1 |
|
CODE NAME |
| CODE |
CODE_DESCRIPTION |
VARCHAR2[200] |
|
NO |
NO |
65
(91.55%) |
| Value | Length | Count | | Active | 6 | 4 | | Cancelled | 9 | 2 | | Deleted | 7 | 2 | | Inactive | 8 | 2 | | ATTEMPTED NO REPORT | 19 | 1 | | ATTEMPTED WITH REPOR... | 23 | 1 | | Administrator | 13 | 1 | | All questions on one... | 23 | 1 | | Alternate | 9 | 1 | | Assigned | 8 | 1 |
|
CODE DESCRIPTION |
| CODE |
CODE_LONG_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
NO |
1
(1.41%) |
|
CODE LONG DESCRIPTION
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CODE |
ALTERNATE_CODE_VALUE |
VARCHAR2[50] |
|
YES |
NO |
1
(1.41%) |
|
Sometime it is practical to associate some meaningful value to the code in order to do some calculation, sorting or similar.
For example Question difficulty alternate values could be: 1, 2, 3 and so on.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| CODE_TYPE |
CODE_TYPE_ID |
VARCHAR2[3] |
1 |
NO |
YES |
24
(100.00%) |
| Value | Length | Count | | ADT | 3 | 1 | | AST | 3 | 1 | | COS | 3 | 1 | | CRT | 3 | 1 | | CST | 3 | 1 | | DUT | 3 | 1 | | ESS | 3 | 1 | | GEN | 3 | 1 | | LOT | 3 | 1 | | QAS | 3 | 1 |
|
CODE TYPE ID |
| CODE_TYPE |
CODE_TYPE_NAME |
VARCHAR2[50] |
|
NO |
YES |
24
(100.00%) |
| Value | Length | Count | | ADDRESS STATUS | 14 | 1 | | ADDRESS TYPE | 12 | 1 | | CLASS STATUS | 12 | 1 | | COURSE STATUS | 13 | 1 | | CREATE TYPE | 11 | 1 | | DURATION TYPE | 13 | 1 | | EMAIL SENT STATUS | 17 | 1 | | GENDER CODE | 11 | 1 | | LOOK TYPE | 9 | 1 | | QUESTION DIFFICULTY | 19 | 1 |
|
CODE TYPE NAME |
| CODE_TYPE |
CODE_TYPE_DESCRIPTION |
VARCHAR2[200] |
|
NO |
YES |
24
(100.00%) |
| Value | Length | Count | | Address Status | 14 | 1 | | Address Type | 12 | 1 | | Class of Users Statu... | 23 | 1 | | Course Status | 13 | 1 | | Describes User's ro... | 23 | 1 | | Describes User's ro... | 23 | 1 | | Describes how the re... | 23 | 1 | | Describes type of th... | 23 | 1 | | Describes when the r... | 23 | 1 | | Email Sent Status | 17 | 1 |
|
CODE TYPE DESCRIPTION |
| CODE_TYPE |
CODE_TYPE_LONG_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
NO |
1
(4.17%) |
|
CODE TYPE LONG DESCRIPTION
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
COURSE_ID |
NUMBER[10] |
1 |
NO |
YES |
65
(100.00%) |
| Value | Length | Count | | 1 | | 1 | | 2 | | 1 | | 3 | | 1 | | 4 | | 1 | | 5 | | 1 | | 6 | | 1 | | 7 | | 1 | | 8 | | 1 | | 9 | | 1 | | 10 | | 1 |
|
COURSE_ID |
| COURSE |
PARENT_COURSE_ID |
NUMBER[10] |
|
YES |
NO |
16
(24.62%) |
| Value | Length | Count | | 16 | | 8 | | 2 | | 7 | | 42 | | 7 | | 51 | | 7 | | 35 | | 6 | | null | | 6 | | 60 | | 5 | | 11 | | 4 | | 26 | | 3 | | 30 | | 3 |
|
Course may have a parent course.
This is made for flexibility, it may not be used very frequently. |
| COURSE |
COURSE_NAME |
VARCHAR2[300] |
|
NO |
YES |
65
(100.00%) |
| Value | Length | Count | | Advanced Accounting ... | 23 | 1 | | Advanced Auditing | 17 | 1 | | Advanced Financial A... | 23 | 1 | | Animal Behaviour | 16 | 1 | | Animal Physiology La... | 23 | 1 | | Art and Culture | 15 | 1 | | Astronomy | 9 | 1 | | Astrophysics Researc... | 23 | 1 | | Astrophysics of Plan... | 23 | 1 | | Astrophysics of Star... | 23 | 1 |
|
COURSE_NAME |
| COURSE |
COURSE_CODE |
VARCHAR2[30] |
|
YES |
NO |
51
(78.46%) |
| Value | Length | Count | | null | 0 | 15 | | ASTA01H3 | 8 | 1 | | ASTA02H3 | 8 | 1 | | ASTB03H3 | 8 | 1 | | ASTB23H3 | 8 | 1 | | ASTC25H3 | 8 | 1 | | ASTD01H3 | 8 | 1 | | ASTD02H3 | 8 | 1 | | BIOA01H3 | 8 | 1 | | BIOA02H3 | 8 | 1 |
|
Code may have a code used by the school. |
| COURSE |
COURSE_STATUS |
VARCHAR2[3] |
|
YES |
NO |
1
(1.54%) |
|
COURSE_STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
CATEGORY_LEVEL |
NUMBER[0] |
|
NO |
NO |
3
(4.62%) |
|
This is helper field that will indicate level of this category in a tree of categories.
For example: top level will be "1", second level (child of level "1") will be "2" and so on. |
| COURSE |
COURSE_DESCRIPTION |
VARCHAR2[2000] |
|
NO |
YES |
N/A |
|
COURSE_DESCRIPTION |
| COURSE |
CREDITS |
NUMBER[0] |
|
YES |
NO |
1
(1.54%) |
|
Number of Credits carried by this course.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
DURATION_IN_HRS |
NUMBER[0] |
|
YES |
NO |
1
(1.54%) |
|
Duration of the course in hours
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
DEPARTMENT_ID |
VARCHAR2[3] |
|
YES |
NO |
1
(1.54%) |
|
DEPARTMENT_ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
SEMESTER |
NUMBER[0] |
|
YES |
NO |
1
(1.54%) |
|
SEMESTER
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
NO |
1
(1.54%) |
|
YEAR_OF_STUDY
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(1.54%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
2
(3.08%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:51:13.0000 | | 48 | | Sun Feb 23, 2014 09:51:12.0000 | | 17 |
|
CREATE DATETIME |
| COURSE |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(1.54%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| COURSE |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(1.54%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| DOCUMENT |
DOCUMENT_ID |
NUMBER[0] |
1 |
NO |
N/A |
N/A |
|
DOCUMENT ID |
| DOCUMENT |
DOCUMENT_TITLE |
VARCHAR2[400] |
|
NO |
N/A |
N/A |
|
DOCUMENT TITLE |
| DOCUMENT |
DOCUMENT_DESCRIPTION |
VARCHAR2[2000] |
|
NO |
N/A |
N/A |
|
DOCUMENT DESCRIPTION |
| DOCUMENT |
DOCUMENT_BINARY_CONTENT |
BLOB[4000] |
|
YES |
N/A |
N/A |
|
DOCUMENT BINARY CONTENT |
| DOCUMENT |
DOCUMENT_CHAR_CONTENT |
CLOB[4000] |
|
YES |
N/A |
N/A |
|
DOCUMENT CHAR CONTENT |
| DOCUMENT |
FILE_NAME |
VARCHAR2[400] |
|
YES |
N/A |
N/A |
|
FILE_NAME |
| DOCUMENT |
FILE_PATH |
VARCHAR2[400] |
|
YES |
N/A |
N/A |
|
document path to in the file system.
This can be source or destination path. |
| DOCUMENT |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| DOCUMENT |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| DOCUMENT |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| DOCUMENT |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| EMAIL_SENT |
EMAIL_SENT_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
EMAIL_SENT_ID |
| EMAIL_SENT |
QUIZ_EMAIL_ACTION_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
QUIZ_EMAIL ACTION_ID |
| EMAIL_SENT |
EVENT_DATE_TIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
EVENT_DATE_TIME |
| EMAIL_SENT |
EMAIL_SENT_STATUS |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
Email Sent Status |
| EMAIL_TEMPLATE |
EMAIL_TEMPLATE_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
EMAIL_TEMPLATE_ID |
| EMAIL_TEMPLATE |
EMAIL_TEMPLATE |
BLOB[4000] |
|
YES |
N/A |
N/A |
|
Email template may be in a rich text format. |
| FUNCTION |
FUNCTION_CODE |
VARCHAR2[3] |
1 |
NO |
YES |
14
(100.00%) |
| Value | Length | Count | | CCL | 3 | 1 | | CHP | 3 | 1 | | COD | 3 | 1 | | CPD | 3 | 1 | | CRC | 3 | 1 | | CRQ | 3 | 1 | | CRR | 3 | 1 | | CRU | 3 | 1 | | EDC | 3 | 1 | | EDE | 3 | 1 |
|
FUNCTION CODE |
| FUNCTION |
FUNCTION_NAME |
VARCHAR2[50] |
|
NO |
YES |
14
(100.00%) |
| Value | Length | Count | | Change Others Person... | 23 | 1 | | Change Own Personal ... | 23 | 1 | | Change Password | 15 | 1 | | Create Class | 12 | 1 | | Create Course | 13 | 1 | | Create Quiz | 11 | 1 | | Create Role | 11 | 1 | | Create User | 11 | 1 | | Edit Class | 10 | 1 | | Edit Course | 11 | 1 |
|
This is the name (short description) of the system function:
For example:
1. Create User
2. Delete user
3. Create Quiz
4. Reports |
| FUNCTION |
FUNCTION_DESCRIPTION |
VARCHAR2[400] |
|
YES |
YES |
14
(100.00%) |
| Value | Length | Count | | Change Others Person... | 23 | 1 | | Change Own Personal ... | 23 | 1 | | Change Password | 15 | 1 | | Create Class | 12 | 1 | | Create Course | 13 | 1 | | Create Quiz | 11 | 1 | | Create Role | 11 | 1 | | Create User | 11 | 1 | | Edit Class | 10 | 1 | | Edit Course | 11 | 1 |
|
Description of the system function. |
| FUNCTION |
ENABLED |
CHAR[1] |
|
NO |
NO |
1
(7.14%) |
|
ENABLED
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| GRADING_SYSTEM |
GRADING_SYSTEM_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
Primarry Key |
| GRADING_SYSTEM |
GRADING_SYSTEM_NAME |
VARCHAR2[50] |
|
NO |
N/A |
N/A |
|
GRADING_SYSTEM_NAME |
| GRADING_SYSTEM |
GRADING_SYSTEM_DESCRIPTION |
VARCHAR2[1000] |
|
NO |
N/A |
N/A |
|
GRADING_SYSTEM_DESCRIPTION |
| GRADING_SYSTEM |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| GRADING_SYSTEM |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| GRADING_SYSTEM |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| GRADING_SYSTEM |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| GRADING_SYSTEM_LABEL |
GRADING_SYSTEM_LABEL_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
Primary Key |
| GRADING_SYSTEM_LABEL |
GRADING_SYSTEM_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
Primarry Key |
| GRADING_SYSTEM_LABEL |
GRADING_SYSTEM_LABEL_CODE |
VARCHAR2[50] |
|
NO |
N/A |
N/A |
|
GRADING_SYSTEM_LABEL_CODE |
| GRADING_SYSTEM_LABEL |
GRADING_SYSTEM_LABEL_NAME |
VARCHAR2[50] |
|
NO |
N/A |
N/A |
|
GRADING_SYSTEM_LABEL_NAME |
| GRADING_SYSTEM_LABEL |
PERCENT_MINIMUM |
NUMBER[0] |
|
NO |
N/A |
N/A |
|
PERCENT_MINIMUM |
| GRADING_SYSTEM_LABEL |
PERCENT_MAXIMUM |
NUMBER[0] |
|
NO |
N/A |
N/A |
|
PERCENT_MAXIMUM |
| GRADING_SYSTEM_LABEL |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| GRADING_SYSTEM_LABEL |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| GRADING_SYSTEM_LABEL |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| GRADING_SYSTEM_LABEL |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| LANGUAGE |
LANGUAGE_ID |
NUMBER[10] |
1 |
NO |
YES |
72
(100.00%) |
| Value | Length | Count | | 1 | | 1 | | 2 | | 1 | | 3 | | 1 | | 4 | | 1 | | 5 | | 1 | | 6 | | 1 | | 7 | | 1 | | 8 | | 1 | | 9 | | 1 | | 10 | | 1 |
|
LANGUAGE ID |
| LANGUAGE |
LANGUAGE |
VARCHAR2[100] |
|
NO |
YES |
72
(100.00%) |
| Value | Length | Count | | Afrikanns | 9 | 1 | | Albanian | 8 | 1 | | Arabic | 6 | 1 | | Armenian | 8 | 1 | | Basque | 6 | 1 | | Bengali | 7 | 1 | | Bulgarian | 9 | 1 | | Cambodian | 9 | 1 | | Catalan | 7 | 1 | | Chinese (Mandarin) | 18 | 1 |
|
LANGUAGE |
| LANGUAGE |
LANGUAGE_CODE |
CHAR[2] |
|
YES |
NO |
1
(1.39%) |
|
LANGUAGE_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ORGANIZATION |
ORGANIZATION_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
ORGANIZATION ID |
| ORGANIZATION |
PARENT_ORGANIZATION_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
PARENT_ORGANIZATION_ID |
| ORGANIZATION |
ORGANIZATION_NAME |
VARCHAR2[250] |
|
NO |
N/A |
N/A |
|
ORGANIZATION NAME |
| ORGANIZATION |
ORGANIZATION_DESCRIPTION |
NVARCHAR2[250] |
|
YES |
N/A |
N/A |
|
ORGANIZATION DESCRIPTION |
| ORGANIZATION |
ORGANIZATION_CATEGORY_CODE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
Identifies category og organization:
- Univesity
- College
- Community College
- High School
- Commercial
- Manufacturing
|
| ORGANIZATION |
ORGANIZATION_STATUS |
VARCHAR2[3] |
|
NO |
N/A |
N/A |
|
Status of the Organization:
- Active
- Inactive
- Deleted |
| ORGANIZATION |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| ORGANIZATION |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| ORGANIZATION |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| ORGANIZATION |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| POOL |
POOL_ID |
NUMBER[10] |
1 |
NO |
YES |
70
(100.00%) |
| Value | Length | Count | | 50 | | 1 | | 51 | | 1 | | 52 | | 1 | | 57 | | 1 | | 58 | | 1 | | 59 | | 1 | | 60 | | 1 | | 61 | | 1 | | 63 | | 1 | | 64 | | 1 |
|
Pool of questions Primary Key |
| POOL |
PARENT_POOL_ID |
NUMBER[10] |
|
YES |
NO |
13
(18.57%) |
| Value | Length | Count | | 50 | | 16 | | 60 | | 12 | | 58 | | 6 | | 59 | | 6 | | 64 | | 5 | | 66 | | 5 | | 67 | | 5 | | 68 | | 5 | | 57 | | 4 | | null | | 3 |
|
Pool of question can belong to another pool.
This way we can make hierarchy of pools.
For example we can have a pool of questions from one lesson.
All pools from certain lessons may belong to another Pool from particular Subject Area. |
| POOL |
POOL_NAME |
VARCHAR2[100] |
|
NO |
YES |
70
(100.00%) |
| Value | Length | Count | | Accounting | 10 | 1 | | Accounting 1 | 12 | 1 | | Accounting 2 | 12 | 1 | | Accounting 3 | 12 | 1 | | Accounting 4 | 12 | 1 | | Business | 8 | 1 | | Engineering | 11 | 1 | | English | 7 | 1 | | English 1 | 9 | 1 | | English 2 | 9 | 1 |
|
POOL NAME |
| POOL |
POOL_DESCRIPTION |
VARCHAR2[500] |
|
NO |
YES |
70
(100.00%) |
| Value | Length | Count | | Accounting | 10 | 1 | | Accounting 1 | 12 | 1 | | Accounting 2 | 12 | 1 | | Accounting 3 | 12 | 1 | | Accounting 4 | 12 | 1 | | Business | 8 | 1 | | Engineering | 11 | 1 | | English | 7 | 1 | | English 1 | 9 | 1 | | English 2 | 9 | 1 |
|
POOL_DESCRIPTION |
| POOL |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(1.43%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| POOL |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
2
(2.86%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:51:16.0000 | | 68 | | Sun Feb 23, 2014 09:51:17.0000 | | 2 |
|
CREATE DATETIME |
| POOL |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(1.43%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| POOL |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(1.43%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| POOL_QUESTION |
QUESTION_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
QUESTION ID |
| POOL_QUESTION |
POOL_ID |
NUMBER[10] |
2 |
NO |
N/A |
N/A |
|
Pool of questions Primary Key |
| QUESTION |
QUESTION_ID |
NUMBER[10] |
1 |
NO |
YES |
121
(100.00%) |
| Value | Length | Count | | 5000 | | 1 | | 5001 | | 1 | | 5002 | | 1 | | 5003 | | 1 | | 5004 | | 1 | | 5005 | | 1 | | 5006 | | 1 | | 5007 | | 1 | | 5008 | | 1 | | 5009 | | 1 |
|
QUESTION ID |
| QUESTION |
QUESTION_TEXT |
NVARCHAR2[2000] |
|
NO |
YES |
N/A |
|
QUESTION TEXT |
| QUESTION |
QUESTION_BLOB |
BLOB[4000] |
|
YES |
YES |
N/A |
|
This field is used to create more complex questions, for example:
- formatted text
- formulas
- videos
- sounds
- animations
- diagrams |
| QUESTION |
PICTURE |
BLOB[4000] |
|
YES |
YES |
N/A |
|
This is picture that is displayed with question. |
| QUESTION |
DURATION |
NUMBER[10] |
|
YES |
NO |
1
(0.83%) |
|
Duration of the question in seconds.
This is optional value and it is intended to be used to limit time avaiable to anwer this question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
DIFFICULTY_CODE |
VARCHAR2[3] |
|
YES |
NO |
1
(0.83%) |
|
Difficulty code
indicates difficulty level of the question. It is a code and therefore
suitable to be used in the drop down list since display value can be
stored in table "CODES".
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
DIFFICULTY |
NUMBER[0] |
|
YES |
NO |
1
(0.83%) |
|
This is degree of
difficulty. Data type is intentionally left NUMERIC so it is easier for
comparison and sorting. It may be used in combination with
DIFFICULTY_CODE or totally independent.
Higher number represents higher difficulty of question.
There could be a various scales of the difficulties, for example:
1-10
1-100
10-500
etc.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
EXCEL_QUESTION_ID |
NUMBER[10] |
|
YES |
NO |
31
(25.62%) |
| Value | Length | Count | | 1001 | | 4 | | 1002 | | 4 | | 1003 | | 4 | | 1004 | | 4 | | 1005 | | 4 | | 1006 | | 4 | | 1007 | | 4 | | 1008 | | 4 | | 1009 | | 4 | | 1010 | | 4 |
|
This is value used in excel spreadsheet to match Questions with Answers.
It is used only for investigation.
For questions NOT created by loading from Excel file this value will be NULL. |
| QUESTION |
POINTS |
NUMBER[0] |
|
YES |
NO |
1
(0.83%) |
|
Number of points that person gets by answering this question correctly.
For example difficult questions can score more points than the others.
This is the "weight" of the question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
QUESTION_TYPE |
VARCHAR2[3] |
|
YES |
NO |
1
(0.83%) |
|
Describes type of the question:
SNC - Single Choice Question
MLC - Multiple Choice Quesiton
TFC - True False Question
ESY - Essay Quesiton
ORD - Ordering Question
FBL - Fill in the Blanks Question
MCH - Maching Question
"Y" indicates that this is multiple choice question
"N" or null indicates that this is not multiple choice answer.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
READ_ONLY_IND |
CHAR[1] |
|
YES |
NO |
1
(0.83%) |
|
If set to "Y" indicates that question is already assigned to someone and it cannot be edited any more.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
FREQUENCY_FACTOR |
NUMBER[10] |
|
YES |
NO |
1
(0.83%) |
|
Factor that indicates how frequently this question should appear in quizzes.
It is actually a probability that question will appear in the quiz.
It can have values from 0 to 100
For example:
0 - Never
50 - it shoud appear on every other test
100 - Always
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
PENALTY |
NUMBER[0] |
|
YES |
NO |
1
(0.83%) |
|
Number of points that person looses for choosing or fiving wrong answer.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
LARNING_FEEDBACK |
VARCHAR2[1000] |
|
YES |
NO |
1
(0.83%) |
|
The purpose of this text is to explain the correct answer or why other answers are incorrect.
The value is in accelerated learning and providing explanation to student.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(0.83%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
5
(4.13%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:51:08.0000 | | 27 | | Sun Feb 23, 2014 09:51:09.0000 | | 25 | | Sun Feb 23, 2014 09:51:07.0000 | | 24 | | Sun Feb 23, 2014 09:51:11.0000 | | 23 | | Sun Feb 23, 2014 09:51:10.0000 | | 22 |
|
CREATE DATETIME |
| QUESTION |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(0.83%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUESTION |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(0.83%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUIZ_CATEGORY |
QUIZ_CATEGORY_ID |
NUMBER[10] |
1 |
NO |
YES |
69
(100.00%) |
| Value | Length | Count | | 1000 | | 1 | | 1001 | | 1 | | 1002 | | 1 | | 1003 | | 1 | | 1004 | | 1 | | 1005 | | 1 | | 1006 | | 1 | | 1007 | | 1 | | 1008 | | 1 | | 1009 | | 1 |
|
QUIZ_CATEGORY_ID |
| QUIZ_CATEGORY |
PARENT_QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
NO |
22
(31.88%) |
| Value | Length | Count | | null | | 8 | | 1017 | | 6 | | 1034 | | 6 | | 1000 | | 4 | | 1011 | | 4 | | 1025 | | 4 | | 1002 | | 3 | | 1007 | | 3 | | 1013 | | 3 | | 1041 | | 3 |
|
PARENT_QUIZ CATEGORY ID |
| QUIZ_CATEGORY |
CATEGORY_NAME |
VARCHAR2[50] |
|
NO |
NO |
62
(89.86%) |
| Value | Length | Count | | 1900s | 5 | 2 | | 2000s | 5 | 2 | | Australia | 9 | 2 | | Biography | 9 | 2 | | India | 5 | 2 | | Latest | 6 | 2 | | South | 5 | 2 | | Action movies | 13 | 1 | | Actors | 6 | 1 | | Actresses | 9 | 1 |
|
CATEGORY_NAME |
| QUIZ_CATEGORY |
QUIZ_CATEGORY_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
NO |
62
(89.86%) |
| Value | Length | Count | | 1900s | 5 | 2 | | 2000s | 5 | 2 | | Australia | 9 | 2 | | Biography | 9 | 2 | | India | 5 | 2 | | Latest | 6 | 2 | | South | 5 | 2 | | Action movies | 13 | 1 | | Actors | 6 | 1 | | Actresses | 9 | 1 |
|
QUIZ_CATEGORY_DESCRIPTION |
| QUIZ_CATEGORY |
CATEGORY_LEVEL |
NUMBER[0] |
|
NO |
NO |
5
(7.25%) |
| Value | Length | Count | | 3 | | 29 | | 2 | | 28 | | 1 | | 8 | | 4 | | 2 | | 5 | | 2 |
|
This is helper field that will indicate level of this category in a tree of categories.
For example: top level will be "1", second level (child of level "1") will be "2" and so on. |
| QUIZ_CATEGORY |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(1.45%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUIZ_CATEGORY |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
2
(2.90%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:50:50.0000 | | 48 | | Sun Feb 23, 2014 09:50:51.0000 | | 21 |
|
CREATE DATETIME |
| QUIZ_CATEGORY |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(1.45%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUIZ_CATEGORY |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(1.45%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUIZ_DEFINITION |
QUIZ_DEFINITION_ID |
NUMBER[10] |
1 |
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | 1000 | | 1 | | 1001 | | 1 | | 1002 | | 1 | | 1003 | | 1 |
|
QUIZ_DEFINITION_ID |
| QUIZ_DEFINITION |
GRADING_SYSTEM_ID |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
Primarry Key |
| QUIZ_DEFINITION |
QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
QUIZ_CATEGORY_ID |
| QUIZ_DEFINITION |
QUIZ_TEMPLATE_ID |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
QUIZ_TEMPLATE_ID |
| QUIZ_DEFINITION |
QUIZ_NAME |
NVARCHAR2[100] |
|
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | History | 7 | 1 | | North American Geogr... | 23 | 1 | | Science | 7 | 1 | | Sport | 5 | 1 |
|
Name (Title) of this test. |
| QUIZ_DEFINITION |
QUIZ_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
NO |
1
(25.00%) |
|
Quiz Long Decsription |
| QUIZ_DEFINITION |
DEFAULT_DURATION |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
Test duration in seconds.
This is time available to complete the test once test instance started. |
| QUIZ_DEFINITION |
USERS_COMMENT |
NVARCHAR2[2000] |
|
YES |
YES |
N/A |
|
USERS COMMENT |
| QUIZ_DEFINITION |
QUIZ_DEFINITION_STATUS |
VARCHAR2[3] |
|
NO |
NO |
1
(25.00%) |
|
Examples:
- Active
- Inactive
- Under Construction
|
| QUIZ_DEFINITION |
NUM_OF_UNIQUE_TESTS |
NUMBER[10] |
|
NO |
NO |
1
(25.00%) |
|
Has to be minimum of 1. |
| QUIZ_DEFINITION |
POINTS_EASY |
NUMBER[10] |
|
NO |
NO |
1
(25.00%) |
|
POINTS_EASY |
| QUIZ_DEFINITION |
POINTS_MEDIUM |
NUMBER[10] |
|
NO |
NO |
1
(25.00%) |
|
POINTS_MEDIUM |
| QUIZ_DEFINITION |
POINTS_HARD |
NUMBER[10] |
|
NO |
NO |
1
(25.00%) |
|
POINTS_HARD |
| QUIZ_DEFINITION |
DURATION_EASY |
NUMBER[0] |
|
YES |
NO |
1
(25.00%) |
|
DURATION_EASY |
| QUIZ_DEFINITION |
DURATION_MEDIUM |
NUMBER[0] |
|
YES |
NO |
1
(25.00%) |
|
DURATION_MEDIUM |
| QUIZ_DEFINITION |
DURATION_HARD |
NUMBER[0] |
|
YES |
NO |
1
(25.00%) |
|
DURATION_HARD |
| QUIZ_DEFINITION |
DURATION_FACTOR |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
Factor (in percents,
for example: -40%, +120%, +300%) - how much the available time for
anwsering the questions should be shortened or prolonged.
Apply duration factor to the length of every question.
On this way duration of the questions can be parametrized. |
| QUIZ_DEFINITION |
DEFAULT_ENABLED_FROM |
DATE[7] |
|
YES |
NO |
1
(25.00%) |
|
DEFAULT ENABLED FROM |
| QUIZ_DEFINITION |
DEFAULT_ENABLED_TO |
DATE[7] |
|
YES |
NO |
1
(25.00%) |
|
DEFAULT ENABLED TO |
| QUIZ_DEFINITION |
DISPLAY_ANSWER_IND |
CHAR[1] |
|
YES |
NO |
1
(25.00%) |
|
Determines if the correct answer is displayed after every question is answered. |
| QUIZ_DEFINITION |
DISPLAY_CORRECT_IND |
CHAR[1] |
|
YES |
NO |
1
(25.00%) |
|
Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered. |
| QUIZ_DEFINITION |
CREATE_TYPE |
VARCHAR2[3] |
|
YES |
NO |
1
(25.00%) |
|
GEN (Generated), MAN (Manual) |
| QUIZ_DEFINITION |
REPORT_TYPE |
VARCHAR2[3] |
|
YES |
NO |
1
(25.00%) |
|
OPA (On professor approval),
IMM (Immediatly after finishing whole quiz)
IQT (After every question - works only for wizard type of quiz) |
| QUIZ_DEFINITION |
LOOK_TYPE |
VARCHAR2[3] |
|
YES |
NO |
1
(25.00%) |
|
AOP (All questions on page), OPP (One question per page) |
| QUIZ_DEFINITION |
DURATION_TYPE |
VARCHAR2[3] |
|
YES |
NO |
1
(25.00%) |
|
UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz) |
| QUIZ_DEFINITION |
RESOLVE_TYPE |
VARCHAR2[3] |
|
YES |
NO |
1
(25.00%) |
|
Shows if quiz contains questions that need to be resolved by professor himself.
QRY - quiz can be resolved by system
QRN- quiz cannot be resolved by system - must professor. |
| QUIZ_DEFINITION |
RAND_QUESTION_ORDER |
CHAR[1] |
|
YES |
NO |
1
(25.00%) |
|
Indicates whether the order of questions is randomized when instance of the quiz is created. |
| QUIZ_DEFINITION |
RAND_ANSWER_ORDER |
CHAR[1] |
|
YES |
NO |
1
(25.00%) |
|
Indicates whether the order of answers within the question is randomized when instance of the quiz is created. |
| QUIZ_DEFINITION |
RESULTS_DISPLAY_CODE |
VARCHAR2[3] |
|
YES |
NO |
1
(25.00%) |
|
This code determines how the results are displayed:
FUL (grade and preview),
GRA (only grade) |
| QUIZ_DEFINITION |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(25.00%) |
|
CREATE USER ID |
| QUIZ_DEFINITION |
CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:51:06.0000 | | 1 | | Sun Feb 23, 2014 09:51:08.0000 | | 1 | | Sun Feb 23, 2014 09:51:09.0000 | | 1 | | Sun Feb 23, 2014 09:51:10.0000 | | 1 |
|
CREATE DATETIME |
| QUIZ_DEFINITION |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
UPDATE USER ID |
| QUIZ_DEFINITION |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(25.00%) |
|
UPDATE DATETIME |
| QUIZ_DEFINITION_POOL |
POOL_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
Pool of questions Primary Key |
| QUIZ_DEFINITION_POOL |
QUIZ_DEFINITION_ID |
NUMBER[10] |
2 |
NO |
N/A |
N/A |
|
QUIZ_DEFINITION_ID |
| QUIZ_DEFINITION_POOL |
NUM_OF_HARD_QUESTIONS |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
NUM_OF_HARD_QUESTIONS |
| QUIZ_DEFINITION_POOL |
NUM_OF_MEDIUM_QUESTIONS |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
NUM_OF_MEDIUM_QUESTIONS |
| QUIZ_DEFINITION_POOL |
NUM_OF_EASY_QUESTIONS |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
NUM_OF_EASY_QUESTIONS |
| QUIZ_DEFINITION_POOL |
CUT_OFF_DATE |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CUT_OFF_DATE |
| QUIZ_EMAIL_ACTION |
QUIZ_EMAIL_ACTION_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
QUIZ_EMAIL ACTION_ID |
| QUIZ_EMAIL_ACTION |
QUIZ_INSTANCE_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
QUIZ_INSTANCE_ID |
| QUIZ_EMAIL_ACTION |
EMAIL_TEMPLATE_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
Specifies the template to be used to contruct the e-mail. |
| QUIZ_EMAIL_ACTION |
USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
USER ID |
| QUIZ_EMAIL_ACTION |
QUIZ_INSTANCE_STATUS |
VARCHAR2[3] |
|
NO |
N/A |
N/A |
|
e-Mail is sent when the Quiz Instance changes status to this value.
|
| QUIZ_INSTANCE |
QUIZ_INSTANCE_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
QUIZ_INSTANCE_ID |
| QUIZ_INSTANCE |
UNIQUE_QUIZ_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
UNIQUE_QUIZ_ID |
| QUIZ_INSTANCE |
USER_ID_TESTED |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
USER ID TESTED |
| QUIZ_INSTANCE |
COURSE_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
This quiz is taken as a
part of this Course.
Both COURSE_ID and CLASS_ID are optional in this table ant they link to
COURSE and CLASS table (vs. CLASS_COURSE) and this is done intentionaly
for maximum flexibility.
If the FKs are linked to CLASS that would impose that class has to
belong to the course which may ne the situation when test is taken but
the it may change after that. This is one scenario. In any case this is
done for maximum flexibility.
|
| QUIZ_INSTANCE |
CLASS_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
User tested may belong to the class.
THis class may be independent of course (may not belong to the course at all).
This is done for maximum flexibility. |
| QUIZ_INSTANCE |
DURATION |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
DURATION |
| QUIZ_INSTANCE |
ENABLED_FROM |
DATE[7] |
|
YES |
N/A |
N/A |
|
ENABLED FROM |
| QUIZ_INSTANCE |
ENABLED_TO |
DATE[7] |
|
YES |
N/A |
N/A |
|
ENABLED TO |
| QUIZ_INSTANCE |
QUIZ_STARTED |
DATE[7] |
|
YES |
N/A |
N/A |
|
Date and time when user started the quiz (received first question).
This data will be used to calculate quiz duration. |
| QUIZ_INSTANCE |
QUIZ_FINISHED |
DATE[7] |
|
YES |
N/A |
N/A |
|
QUIZ FINISHED |
| QUIZ_INSTANCE |
QUIZ_INSTANCE_STATUS |
VARCHAR2[3] |
|
NO |
N/A |
N/A |
|
Describes the status of the Quiz instance:
- Not sent
- Not attempted
- Attempted No Report
- Attempted With Report
- Expired
|
| QUIZ_INSTANCE |
ACTIVATION_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
Indicates when this quiz instance is activated.
Quiz instance has to be activated in order for person to take the quiz.
When QUIZ_INSTANCE is activated all quations linked to this QUIZ_INSTANCE
record are marked as "read only" (QUESTION.READ_ONLY_IND is set to "Y")
Questions with QUESTION.READ_ONLY_IND set to "Y" cannot be edited any more.
Quiz can be taken by individual if:
1. QUIZ_INSTANCE.ACTIVATION_DATETIME is not null (quiz instance is activated
and questions are locked)
2. QUIZ_INSTANCE.ENABLED_FROM is greated than SYSDATE
3. QUIZ_INSTANCE.ENABLED_FROM is lesser than SYSDATE |
| QUIZ_INSTANCE |
RESOLVE_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
Shows if quiz contains questions that need to be resolved by professor himself.
QRY - quiz can be resolved by system
QRN- quiz cannot be resolved by system - must professor. |
| QUIZ_INSTANCE |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| QUIZ_INSTANCE |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| QUIZ_INSTANCE |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| QUIZ_INSTANCE |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| QUIZ_QUESTION |
UNIQUE_QUIZ_ID |
NUMBER[10] |
2 |
NO |
NO |
4
(3.31%) |
| Value | Length | Count | | 1 | | 31 | | 2 | | 30 | | 3 | | 30 | | 4 | | 30 |
|
UNIQUE_QUIZ_ID |
| QUIZ_QUESTION |
QUESTION_ID |
NUMBER[10] |
1 |
NO |
YES |
121
(100.00%) |
| Value | Length | Count | | 5000 | | 1 | | 5001 | | 1 | | 5002 | | 1 | | 5003 | | 1 | | 5004 | | 1 | | 5005 | | 1 | | 5006 | | 1 | | 5007 | | 1 | | 5008 | | 1 | | 5009 | | 1 |
|
QUESTION ID |
| QUIZ_QUESTION |
QUESTION_ORDINAL_NUMBER |
NUMBER[10] |
|
YES |
NO |
31
(25.62%) |
| Value | Length | Count | | 1 | | 4 | | 2 | | 4 | | 3 | | 4 | | 4 | | 4 | | 5 | | 4 | | 6 | | 4 | | 7 | | 4 | | 8 | | 4 | | 9 | | 4 | | 10 | | 4 |
|
This is the number that determines order of the question in test.
Lower numbers are displayed first in the test. |
| QUIZ_QUESTION |
STATUS |
VARCHAR2[3] |
|
NO |
NO |
1
(0.83%) |
|
STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUIZ_QUESTION |
FREQUENCY_FACTOR |
NUMBER[0] |
|
YES |
NO |
1
(0.83%) |
|
Spec. of question occurence for current quiz. Default values are in table QUESTION.
Will be labeled in application and mapped to numbers after.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUIZ_QUESTION |
DURATION |
NUMBER[0] |
|
YES |
NO |
1
(0.83%) |
|
Defualt duration is in table question, But if user wants to change it while making the quiz it will be inserted here.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| QUIZ_RESULT |
QUIZ_RESULT_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
QUIZ RESULT ID |
| QUIZ_RESULT |
QUIZ_INSTANCE_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
QUIZ_INSTANCE_ID |
| QUIZ_RESULT |
QUESTION_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
QUESTION ID |
| QUIZ_RESULT |
ANSWER_TEXT |
NVARCHAR2[2000] |
|
YES |
N/A |
N/A |
|
This field is reserved for questions that require free form text answer.
Answer entered by candidate taking test will be saved in this field. |
| QUIZ_RESULT |
ANSWER_CLOB |
CLOB[4000] |
|
YES |
N/A |
N/A |
|
This field provides capability to create textual answers of unlimited length. |
| QUIZ_RESULT |
ANSWER_BLOB |
BLOB[4000] |
|
YES |
N/A |
N/A |
|
This field provides
capability to create more "complex" answers that would invlove
formuulas, specific tect formatting, diagrams, pictures, etc. |
| QUIZ_RESULT |
ANSWER_FEEDBACK |
VARCHAR2[2000] |
|
YES |
N/A |
N/A |
|
This is the feedback from the examiner on the given answer.
examiner may not be able to change Answer text but he/she can write a feedback on the answer. |
| QUIZ_RESULT |
NOT_SURE_FLAG |
CHAR[1] |
|
YES |
N/A |
N/A |
|
NOT SURE FLAG |
| QUIZ_RESULT |
POINTS_ASSIGNED |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
This is number of points assigned by examiner after evaluating the answer.
It overrides default number of points in table Answers.
Also it is used for free form text answers. |
| QUIZ_RESULT |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| QUIZ_RESULT |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| QUIZ_RESULT |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| QUIZ_RESULT |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| QUIZ_RESULT_ANSWER |
ANSWER_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
ANSWER ID |
| QUIZ_RESULT_ANSWER |
QUIZ_RESULT_ID |
NUMBER[10] |
2 |
NO |
N/A |
N/A |
|
QUIZ RESULT ID |
| QUIZ_RESULT_ANSWER |
TIME_TO_ANSWER |
NUMBER[8] |
|
YES |
N/A |
N/A |
|
Time that user has taken to answer the question - for stats. |
| QUIZ_TEMPLATE |
QUIZ_TEMPLATE_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
QUIZ_TEMPLATE_ID |
| QUIZ_TEMPLATE |
QUIZ_CATEGORY_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
QUIZ_CATEGORY_ID |
| QUIZ_TEMPLATE |
GRADING_SYSTEM_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
Primarry Key |
| QUIZ_TEMPLATE |
NUM_OF_UNIQUE_TESTS |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
Has to be minimum of 1. |
| QUIZ_TEMPLATE |
TEMPLATE_NAME |
NVARCHAR2[100] |
|
NO |
N/A |
N/A |
|
Name (Title) of this template |
| QUIZ_TEMPLATE |
TEMPLATE_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
Quiz Long Decsription |
| QUIZ_TEMPLATE |
TEMPLATE_STATUS |
VARCHAR2[3] |
|
NO |
N/A |
N/A |
|
Examples:
- Active
- Inactive
- Under Construction
|
| QUIZ_TEMPLATE |
POINTS_EASY |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
POINTS_EASY |
| QUIZ_TEMPLATE |
POINTS_MEDIUM |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
POINTS_MEDIUM |
| QUIZ_TEMPLATE |
POINTS_HARD |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
POINTS_HARD |
| QUIZ_TEMPLATE |
DURATION_EASY |
NUMBER[0] |
|
YES |
N/A |
N/A |
|
DURATION_EASY |
| QUIZ_TEMPLATE |
DURATION_MEDIUM |
NUMBER[0] |
|
YES |
N/A |
N/A |
|
DURATION_MEDIUM |
| QUIZ_TEMPLATE |
DURATION_HARD |
NUMBER[0] |
|
YES |
N/A |
N/A |
|
DURATION_HARD |
| QUIZ_TEMPLATE |
DEFAULT_DURATION |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
Test duration in seconds.
This is time available to complete the test once test instance started. |
| QUIZ_TEMPLATE |
DISPLAY_ANSWER_IND |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Determines if the correct answer is displayed after every question is answered. |
| QUIZ_TEMPLATE |
DISPLAY_CORRECT_IND |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered. |
| QUIZ_TEMPLATE |
REPORT_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
OPA (On professor
approval), FUL (Immediatly after finishing user can see his report with
preview), GRA (User can see only grade after finishing) |
| QUIZ_TEMPLATE |
LOOK_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
AOP (All questions on page), OPP (One question per page) |
| QUIZ_TEMPLATE |
DURATION_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz) |
| QUIZ_TEMPLATE |
DURATION_FACTOR |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
Factor (in percents,
for example: -40%, +120%, +300%) - how much the available time for
anwsering the questions should be shortened or prolonged.
Apply duration factor to the length of every question.
On this way duration of the questions can be parametrized. |
| QUIZ_TEMPLATE |
RAND_QUESTION_ORDER |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Indicates whether the order of questions is randomized when instance of the quiz is created. |
| QUIZ_TEMPLATE |
RAND_ANSWER_ORDER |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Indicates whether the order of answers within the question is randomized when instance of the quiz is created. |
| QUIZ_TEMPLATE |
RESULTS_DISPLAY_CODE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
This code determines when the results are displayed:
- after svery question is answered
- after entire quiz is finished
- once it is reviewed and apprived by examiner |
| QUIZ_TEMPLATE |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| QUIZ_TEMPLATE |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| QUIZ_TEMPLATE |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| QUIZ_TEMPLATE |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| QUIZ_TEMPLATE_POOL |
POOL_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
Pool of questions Primary Key |
| QUIZ_TEMPLATE_POOL |
QUIZ_TEMPLATE_ID |
NUMBER[10] |
2 |
NO |
N/A |
N/A |
|
QUIZ_TEMPLATE_ID |
| QUIZ_TEMPLATE_POOL |
NUM_OF_HARD_QUESTIONS |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
NUM_OF_HARD_QUESTIONS |
| QUIZ_TEMPLATE_POOL |
NUM_OF_MEDIUM_QUESTIONS |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
NUM_OF_MEDIUM_QUESTIONS |
| QUIZ_TEMPLATE_POOL |
NUM_OF_EASY_QUESTIONS |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
NUM_OF_EASY_QUESTIONS |
| QUIZ_TEMPLATE_POOL |
CUT_OFF_DATE |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CUT_OFF_DATE |
| REPORT_DEFINITION |
REPORT_DEFINITION_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
REPORT_DEFINITION_ID |
| REPORT_DEFINITION |
REPORT_NAME |
VARCHAR2[50] |
|
NO |
N/A |
N/A |
|
REPORT_NAME |
| REPORT_DEFINITION |
REPORT_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
Report description with more details |
| REPORT_DEFINITION |
DEFAULT_REPORT_TITLE |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
This is title that will appear in the report. |
| REPORT_DEFINITION |
DEFAULT_LOCATION |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
This is the default location where report will be created in the file system |
| REPORT_DEFINITION |
REPORT_FORMAT_CODE |
VARCHAR2[3] |
|
NO |
N/A |
N/A |
|
Identifis the format of the report, for example:
- PDF
- Excel
- Rich Text Format (RTF)
- HTML |
| REPORT_DEFINITION |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| REPORT_DEFINITION |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| REPORT_DEFINITION |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| REPORT_DEFINITION |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| REPORT_INSTANCE |
REPORT_INSTANCE_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
REPORT_INSTANCE_ID |
| REPORT_INSTANCE |
REPORT_DEFINITION_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
REPORT_DEFINITION_ID |
| REPORT_INSTANCE |
REPORT_LOCATION |
VARCHAR2[1000] |
|
NO |
N/A |
N/A |
|
Location of the report in the file system |
| REPORT_INSTANCE |
COMMENT |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
This is the comment related to this particulear report instance.
It is usually a text entered through Front End by person submitting report. |
| REPORT_INSTANCE |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| REPORT_INSTANCE |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| REPORT_INSTANCE |
REPORT_TITLE |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
This is title that will appear in the report.
It overrides value from REPORT_DEFINITION.DEFAULT_REPORT_TITLE |
| ROLE |
ROLE_CODE |
VARCHAR2[3] |
1 |
NO |
YES |
3
(100.00%) |
| Value | Length | Count | | ADM | 3 | 1 | | PRF | 3 | 1 | | STU | 3 | 1 |
|
ROLE CODE |
| ROLE |
ROLE_NAME |
VARCHAR2[50] |
|
NO |
YES |
3
(100.00%) |
| Value | Length | Count | | Administrator | 13 | 1 | | Professor | 9 | 1 | | Student | 7 | 1 |
|
ROLE NAME |
| ROLE |
ROLE_DESCRIPTION |
VARCHAR2[400] |
|
YES |
YES |
3
(100.00%) |
| Value | Length | Count | | Administartor of the... | 23 | 1 | | Professor | 9 | 1 | | Student | 7 | 1 |
|
ROLE_DESCRIPTION |
| ROLE |
GRANTABLE |
CHAR[1] |
|
YES |
NO |
2
(66.67%) |
|
If 'Y' then this Role can grant Roles to other users. |
| ROLE |
ENABLED |
CHAR[1] |
|
NO |
NO |
1
(33.33%) |
|
ENABLED |
| ROLE_FUNCTION |
ROLE_CODE |
VARCHAR2[3] |
1 |
NO |
NO |
3
(33.33%) |
| Value | Length | Count | | ADM | 3 | 3 | | PRF | 3 | 3 | | STU | 3 | 3 |
|
ROLE CODE |
| ROLE_FUNCTION |
FUNCTION_CODE |
VARCHAR2[3] |
2 |
NO |
NO |
3
(33.33%) |
| Value | Length | Count | | CHP | 3 | 3 | | LGN | 3 | 3 | | TAQ | 3 | 3 |
|
FUNCTION CODE |
| ROLE_FUNCTION |
ENABLED |
CHAR[1] |
|
NO |
NO |
1
(11.11%) |
|
ENABLED
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_ANSWER |
ST_ANSWER_ID |
NUMBER[10] |
1 |
NO |
YES |
605
(100.00%) |
| Value | Length | Count | | 4 | | 1 | | 8 | | 1 | | 12 | | 1 | | 16 | | 1 | | 20 | | 1 | | 24 | | 1 | | 28 | | 1 | | 32 | | 1 | | 36 | | 1 | | 40 | | 1 |
|
ST_ANSWER_ID |
| ST_ANSWER |
ST_QUIZ_ID |
NUMBER[10] |
|
NO |
NO |
4
(0.66%) |
| Value | Length | Count | | 1 | | 155 | | 2 | | 150 | | 3 | | 150 | | 4 | | 150 |
|
ST_QUIZ_ID |
| ST_ANSWER |
ARTIFICIAL_QUESTION_ID |
NUMBER[10] |
|
NO |
NO |
31
(5.12%) |
| Value | Length | Count | | 1001 | | 20 | | 1002 | | 20 | | 1003 | | 20 | | 1004 | | 20 | | 1005 | | 20 | | 1006 | | 20 | | 1007 | | 20 | | 1008 | | 20 | | 1009 | | 20 | | 1010 | | 20 |
|
This is number assigned by user in order to link questions with answers in excel. |
| ST_ANSWER |
ANSWER_TEXT |
NVARCHAR2[2000] |
|
YES |
YES |
N/A |
|
ANSWER_TEXT |
| ST_ANSWER |
ORDINAL_NUMBER |
NUMBER[0] |
|
YES |
NO |
5
(0.83%) |
| Value | Length | Count | | 2 | | 123 | | 1 | | 121 | | 4 | | 121 | | 5 | | 121 | | 3 | | 119 |
|
This number determines
the order of this answer as it appears on the test. Lower numbers are
displayed first. If this number is not present then answers will be
diplayed in default order. |
| ST_ANSWER |
CORRECT_ANSWER_IND |
CHAR[1] |
|
YES |
NO |
2
(0.33%) |
| Value | Length | Count | | null | 0 | 485 | | Y | 1 | 120 |
|
Indicates if this is the correct answer. |
| ST_COURSE |
EXCEL_ROW_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
EXCEL_ROW_ID |
| ST_COURSE |
COURSE_CODE |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
COURSE_CODE |
| ST_COURSE |
CATEGORY_NAME_1 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_1 |
| ST_COURSE |
CATEGORY_NAME_2 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_2 |
| ST_COURSE |
CATEGORY_NAME_3 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_3 |
| ST_COURSE |
CATEGORY_NAME_4 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_4 |
| ST_COURSE |
CATEGORY_NAME_5 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_5 |
| ST_COURSE |
CATEGORY_NAME_6 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_6 |
| ST_COURSE |
CATEGORY_NAME_7 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_7 |
| ST_COURSE |
CATEGORY_NAME_8 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_8 |
| ST_COURSE |
CATEGORY_NAME_9 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_9 |
| ST_COURSE |
CATEGORY_NAME_10 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
CATEGORY_NAME_10 |
| ST_COURSE |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| ST_QUESTION |
ST_QUESTION_ID |
NUMBER[10] |
1 |
NO |
YES |
121
(100.00%) |
| Value | Length | Count | | 4 | | 1 | | 8 | | 1 | | 12 | | 1 | | 16 | | 1 | | 20 | | 1 | | 24 | | 1 | | 28 | | 1 | | 32 | | 1 | | 36 | | 1 | | 40 | | 1 |
|
ST_QUESTION_ID |
| ST_QUESTION |
ARTIFICIAL_QUESTION_ID |
NUMBER[10] |
|
NO |
NO |
31
(25.62%) |
| Value | Length | Count | | 1001 | | 4 | | 1002 | | 4 | | 1003 | | 4 | | 1004 | | 4 | | 1005 | | 4 | | 1006 | | 4 | | 1007 | | 4 | | 1008 | | 4 | | 1009 | | 4 | | 1010 | | 4 |
|
This is number assigned by user in order to link questions with answers in excel. |
| ST_QUESTION |
ST_QUIZ_ID |
NUMBER[10] |
|
NO |
NO |
4
(3.31%) |
| Value | Length | Count | | 1 | | 31 | | 2 | | 30 | | 3 | | 30 | | 4 | | 30 |
|
ST_QUIZ_ID |
| ST_QUESTION |
QUESTION_TEXT |
NVARCHAR2[2000] |
|
NO |
YES |
N/A |
|
QUESTION TEXT |
| ST_QUESTION |
PICTURE |
BLOB[4000] |
|
YES |
YES |
N/A |
|
This is picture that is displayed with question. |
| ST_QUESTION |
DURATION |
NUMBER[10] |
|
YES |
NO |
1
(0.83%) |
|
Duration of the question in seconds.
This is optional value and it is intended to be used to limit time avaiable to anwer this question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUESTION |
DIFFICULTY |
NUMBER[0] |
|
YES |
NO |
1
(0.83%) |
|
This is degree of difficulty.
Higher number represents higher difficulty of question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUESTION |
POINTS |
NUMBER[0] |
|
YES |
NO |
1
(0.83%) |
|
Number of points that person gets by answering this question correctly.
For example difficult questions can score more points than the others.
This is the "weight" of the question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUESTION |
ORDINAL_NUMBER |
NUMBER[0] |
|
YES |
NO |
31
(25.62%) |
| Value | Length | Count | | 1 | | 4 | | 2 | | 4 | | 3 | | 4 | | 4 | | 4 | | 5 | | 4 | | 6 | | 4 | | 7 | | 4 | | 8 | | 4 | | 9 | | 4 | | 10 | | 4 |
|
This number determines
the order of this questionas it appears on the test. Lower numbers are
displayed first. If this number is not present then questions will be
diplayed in default order. |
| ST_QUIZ |
ST_QUIZ_ID |
NUMBER[10] |
1 |
NO |
YES |
4
(100.00%) |
|
ST_QUIZ_ID |
| ST_QUIZ |
USERNAME |
NVARCHAR2[100] |
|
NO |
NO |
1
(25.00%) |
| Value | Length | Count | | zkukoljac | 9 | 4 |
|
Username has to be
unique across the system.
Use of email adress is encouraged however it cannot be enforced because
many user will not have e-mail addresses or they will not provide it for
various reasons. |
| ST_QUIZ |
PASSWORD |
CHAR[10] |
|
YES |
NO |
1
(25.00%) |
| Value | Length | Count | | zkukoljac2 | 10 | 4 |
|
PASSWORD |
| ST_QUIZ |
USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
USER ID |
| ST_QUIZ |
QUIZ_NAME |
NVARCHAR2[100] |
|
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | History | 7 | 1 | | North American Geogr... | 23 | 1 | | Science | 7 | 1 | | Sport | 5 | 1 |
|
Name (Title) of this test. |
| ST_QUIZ |
DEFAULT_DURATION |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
Test duration in seconds.
This is time available to complete the test once test instance started. |
| ST_QUIZ |
USERS_COMMENT |
NVARCHAR2[2000] |
|
YES |
YES |
N/A |
|
USERS COMMENT |
| ST_QUIZ |
DEFAULT_ENABLED_FROM |
DATE[7] |
|
YES |
NO |
1
(25.00%) |
|
DEFAULT ENABLED FROM |
| ST_QUIZ |
DEFAULT_ENABLED_TO |
DATE[7] |
|
YES |
NO |
1
(25.00%) |
|
DEFAULT ENABLED TO |
| ST_QUIZ |
RESULT_TRANSPARENCY |
VARCHAR2[20] |
|
YES |
NO |
1
(25.00%) |
|
RESULT TRANSPARENCY |
| ST_QUIZ |
DURATION_FACTOR |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
Factor (in percents,
for example: -40%, +120%, +300%) - how much the available time for
anwsering the questions should be shortened or prolonged.
Apply duration factor to the length of every question.
On this way duration of the questions can be parametrized. |
| ST_QUIZ |
STATUS |
CHAR[1] |
|
NO |
NO |
1
(25.00%) |
|
"S" - Loaded only in staging tables
"L" - Loaded into permanent tables, data from stagin tables can be deleted |
| ST_QUIZ |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(25.00%) |
|
CREATE USER ID |
| ST_QUIZ |
CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:50:51.0000 | | 1 | | Sun Feb 23, 2014 09:50:54.0000 | | 1 | | Sun Feb 23, 2014 09:50:57.0000 | | 1 | | Sun Feb 23, 2014 09:51:00.0000 | | 1 |
|
CREATE DATETIME |
| ST_QUIZ_CATEGORY |
EXCEL_ROW_ID |
NUMBER[10] |
1 |
NO |
YES |
69
(100.00%) |
| Value | Length | Count | | 10 | | 1 | | 20 | | 1 | | 30 | | 1 | | 40 | | 1 | | 50 | | 1 | | 60 | | 1 | | 70 | | 1 | | 80 | | 1 | | 90 | | 1 | | 100 | | 1 |
|
EXCEL_ROW_ID |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_1 |
VARCHAR2[50] |
|
YES |
NO |
8
(11.59%) |
| Value | Length | Count | | Sports | 6 | 14 | | Hollywood | 10 | 13 | | Science | 7 | 11 | | History | 7 | 9 | | Geography | 9 | 7 | | Technology | 10 | 7 | | Philosophy | 10 | 4 | | Religion | 8 | 4 |
|
CATEGORY_NAME_1 |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_2 |
VARCHAR2[50] |
|
YES |
NO |
29
(42.03%) |
| Value | Length | Count | | Action movies | 13 | 8 | | null | 0 | 8 | | Cricket | 7 | 7 | | Biology | 7 | 4 | | Horror movies | 13 | 4 | | Physics | 7 | 4 | | Soccer | 6 | 4 | | Canada | 6 | 3 | | India | 5 | 3 | | Regions | 7 | 3 |
|
CATEGORY_NAME_2 |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_3 |
VARCHAR2[50] |
|
YES |
NO |
26
(37.68%) |
| Value | Length | Count | | null | 0 | 36 | | Latest | 6 | 6 | | 1900s | 5 | 2 | | 2000s | 5 | 2 | | South | 5 | 2 | | Australia | 9 | 1 | | Botany | 6 | 1 | | European | 8 | 1 | | Human | 5 | 1 | | India | 5 | 1 |
|
CATEGORY_NAME_3 |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_4 |
VARCHAR2[50] |
|
YES |
NO |
3
(4.35%) |
| Value | Length | Count | | null | 0 | 65 | | Actors | 6 | 2 | | Actresses | 9 | 2 |
|
CATEGORY_NAME_4 |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_5 |
VARCHAR2[50] |
|
YES |
NO |
2
(2.90%) |
| Value | Length | Count | | null | 0 | 67 | | Biography | 9 | 2 |
|
CATEGORY_NAME_5 |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_6 |
VARCHAR2[50] |
|
YES |
NO |
1
(1.45%) |
|
CATEGORY_NAME_6
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_7 |
VARCHAR2[50] |
|
YES |
NO |
1
(1.45%) |
|
CATEGORY_NAME_7
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_8 |
VARCHAR2[50] |
|
YES |
NO |
1
(1.45%) |
|
CATEGORY_NAME_8
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_9 |
VARCHAR2[50] |
|
YES |
NO |
1
(1.45%) |
|
CATEGORY_NAME_9
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUIZ_CATEGORY |
CATEGORY_NAME_10 |
VARCHAR2[50] |
|
YES |
NO |
1
(1.45%) |
|
CATEGORY_NAME_10
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| ST_QUIZ_CATEGORY |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
4
(5.80%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:50:52.0000 | | 27 | | Sun Feb 23, 2014 09:50:51.0000 | | 17 | | Sun Feb 23, 2014 09:50:50.0000 | | 14 | | Sun Feb 23, 2014 09:50:49.0000 | | 11 |
|
CREATE DATETIME |
| SURVEY_DEFINITION |
SURVEY_DEFINITION_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
SURVEY_DEFINITION_ID |
| SURVEY_DEFINITION |
GRADING_SYSTEM_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
Primarry Key |
| SURVEY_DEFINITION |
SURVEY_CATEGORY_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
SURVEY_CATEGORY_ID |
| SURVEY_DEFINITION |
SURVEY_NAME |
NVARCHAR2[100] |
|
NO |
N/A |
N/A |
|
Name (Title) of this test. |
| SURVEY_DEFINITION |
SURVEY_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
Quiz Long Decsription |
| SURVEY_DEFINITION |
DEFAULT_DURATION |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
Test duration in seconds.
This is time available to complete the test once test instance started. |
| SURVEY_DEFINITION |
USERS_COMMENT |
NVARCHAR2[2000] |
|
YES |
N/A |
N/A |
|
USERS COMMENT |
| SURVEY_DEFINITION |
SURVEY_DEFINITION_STATUS |
VARCHAR2[3] |
|
NO |
N/A |
N/A |
|
Examples:
- Active
- Inactive
- Under Construction
|
| SURVEY_DEFINITION |
POINTS_EASY |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
POINTS_EASY |
| SURVEY_DEFINITION |
POINTS_MEDIUM |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
POINTS_MEDIUM |
| SURVEY_DEFINITION |
POINTS_HARD |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
POINTS_HARD |
| SURVEY_DEFINITION |
DURATION_EASY |
NUMBER[0] |
|
YES |
N/A |
N/A |
|
DURATION_EASY |
| SURVEY_DEFINITION |
DURATION_MEDIUM |
NUMBER[0] |
|
YES |
N/A |
N/A |
|
DURATION_MEDIUM |
| SURVEY_DEFINITION |
DURATION_HARD |
NUMBER[0] |
|
YES |
N/A |
N/A |
|
DURATION_HARD |
| SURVEY_DEFINITION |
DURATION_FACTOR |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
Factor (in percents,
for example: -40%, +120%, +300%) - how much the available time for
anwsering the questions should be shortened or prolonged.
Apply duration factor to the length of every question.
On this way duration of the questions can be parametrized. |
| SURVEY_DEFINITION |
DEFAULT_ENABLED_FROM |
DATE[7] |
|
YES |
N/A |
N/A |
|
DEFAULT ENABLED FROM |
| SURVEY_DEFINITION |
DEFAULT_ENABLED_TO |
DATE[7] |
|
YES |
N/A |
N/A |
|
DEFAULT ENABLED TO |
| SURVEY_DEFINITION |
DISPLAY_ANSWER_IND |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Determines if the correct answer is displayed after every question is answered. |
| SURVEY_DEFINITION |
DISPLAY_CORRECT_IND |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered. |
| SURVEY_DEFINITION |
CREATE_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
GEN (Generated), MAN (Manual) |
| SURVEY_DEFINITION |
REPORT_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
OPA (On professor approval),
IMM (Immediatly after finishing whole quiz)
IQT (After every question - works only for wizard type of quiz) |
| SURVEY_DEFINITION |
LOOK_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
AOP (All questions on page), OPP (One question per page) |
| SURVEY_DEFINITION |
DURATION_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz) |
| SURVEY_DEFINITION |
RESOLVE_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
Shows if quiz contains questions that need to be resolved by professor himself.
QRY - quiz can be resolved by system
QRN- quiz cannot be resolved by system - must professor. |
| SURVEY_DEFINITION |
RAND_QUESTION_ORDER |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Indicates whether the order of questions is randomized when instance of the quiz is created. |
| SURVEY_DEFINITION |
RAND_ANSWER_ORDER |
CHAR[1] |
|
YES |
N/A |
N/A |
|
Indicates whether the order of answers within the question is randomized when instance of the quiz is created. |
| SURVEY_DEFINITION |
RESULTS_DISPLAY_CODE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
This code determines how the results are displayed:
FUL (grade and preview),
GRA (only grade) |
| SURVEY_DEFINITION |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| SURVEY_DEFINITION |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| SURVEY_DEFINITION |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| SURVEY_DEFINITION |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| SURVEY_INSTANCE |
SURVEY_INSTANCE_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
SURVEY_INSTANCE_ID |
| SURVEY_INSTANCE |
SURVEY_DEFINITION_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
SURVEY_DEFINITION_ID |
| SURVEY_INSTANCE |
USER_ID_TESTED |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
USER ID TESTED |
| SURVEY_INSTANCE |
COURSE_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
This quiz is taken as a
part of this Course.
Both COURSE_ID and CLASS_ID are optional in this table ant they link to
COURSE and CLASS table (vs. CLASS_COURSE) and this is done intentionaly
for maximum flexibility.
If the FKs are linked to CLASS that would impose that class has to
belong to the course which may ne the situation when test is taken but
the it may change after that. This is one scenario. In any case this is
done for maximum flexibility.
|
| SURVEY_INSTANCE |
CLASS_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
User tested may belong to the class.
THis class may be independent of course (may not belong to the course at all).
This is done for maximum flexibility. |
| SURVEY_INSTANCE |
DURATION |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
DURATION |
| SURVEY_INSTANCE |
ENABLED_FROM |
DATE[7] |
|
YES |
N/A |
N/A |
|
ENABLED FROM |
| SURVEY_INSTANCE |
ENABLED_TO |
DATE[7] |
|
YES |
N/A |
N/A |
|
ENABLED TO |
| SURVEY_INSTANCE |
QUIZ_STARTED |
DATE[7] |
|
YES |
N/A |
N/A |
|
Date and time when user started the quiz (received first question).
This data will be used to calculate quiz duration. |
| SURVEY_INSTANCE |
QUIZ_FINISHED |
DATE[7] |
|
YES |
N/A |
N/A |
|
QUIZ FINISHED |
| SURVEY_INSTANCE |
QUIZ_INSTANCE_STATUS |
VARCHAR2[3] |
|
NO |
N/A |
N/A |
|
Describes the status of the Quiz instance:
- Not sent
- Not attempted
- Attempted No Report
- Attempted With Report
- Expired
|
| SURVEY_INSTANCE |
ACTIVATION_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
Indicates when this quiz instance is activated.
Quiz instance has to be activated in order for person to take the quiz.
When QUIZ_INSTANCE is activated all quations linked to this QUIZ_INSTANCE
record are marked as "read only" (QUESTION.READ_ONLY_IND is set to "Y")
Questions with QUESTION.READ_ONLY_IND set to "Y" cannot be edited any more.
Quiz can be taken by individual if:
1. QUIZ_INSTANCE.ACTIVATION_DATETIME is not null (quiz instance is activated
and questions are locked)
2. QUIZ_INSTANCE.ENABLED_FROM is greated than SYSDATE
3. QUIZ_INSTANCE.ENABLED_FROM is lesser than SYSDATE |
| SURVEY_INSTANCE |
RESOLVE_TYPE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
Shows if quiz contains questions that need to be resolved by professor himself.
QRY - quiz can be resolved by system
QRN- quiz cannot be resolved by system - must professor. |
| SURVEY_INSTANCE |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
CREATE USER ID |
| SURVEY_INSTANCE |
CREATE_DATETIME |
DATE[7] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| SURVEY_INSTANCE |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
UPDATE USER ID |
| SURVEY_INSTANCE |
UPDATE_DATETIME |
DATE[7] |
|
YES |
N/A |
N/A |
|
UPDATE DATETIME |
| SURVEY_QUESTION |
QUESTION_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
QUESTION ID |
| SURVEY_QUESTION |
SURVEY_INSTANCE_ID |
NUMBER[10] |
2 |
NO |
N/A |
N/A |
|
SURVEY_INSTANCE_ID |
| TIME_ZONE |
TIME_ZONE_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
TIME_ZONE_ID |
| TIME_ZONE |
TIME_ZONE |
NUMBER[0] |
|
NO |
N/A |
N/A |
|
This is actualy difference from ZULU time (GMT). |
| TIME_ZONE |
TIME_ZONE_CODE |
VARCHAR2[10] |
|
YES |
N/A |
N/A |
|
For Example:
"EST"
"PST"
etc. |
| TIME_ZONE |
TIME_ZONE_NAME |
VARCHAR2[100] |
|
YES |
N/A |
N/A |
|
For example:
"Eastern Standard Time" |
| UNIQUE_QUIZ |
UNIQUE_QUIZ_ID |
NUMBER[10] |
1 |
NO |
YES |
4
(100.00%) |
|
UNIQUE_QUIZ_ID |
| UNIQUE_QUIZ |
QUIZ_DEFINITION_ID |
NUMBER[10] |
|
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | 1000 | | 1 | | 1001 | | 1 | | 1002 | | 1 | | 1003 | | 1 |
|
QUIZ_DEFINITION_ID |
| UNIQUE_QUIZ |
UNIQUE_QUIZ_NAME |
NVARCHAR2[100] |
|
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | UNIQUE QUIZ NAME 1 | 18 | 1 | | UNIQUE QUIZ NAME 2 | 18 | 1 | | UNIQUE QUIZ NAME 3 | 18 | 1 | | UNIQUE QUIZ NAME 4 | 18 | 1 |
|
Name (Title) of this test. |
| UNIQUE_QUIZ |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(25.00%) |
|
CREATE USER ID |
| UNIQUE_QUIZ |
CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
4
(100.00%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:51:07.0000 | | 1 | | Sun Feb 23, 2014 09:51:08.0000 | | 1 | | Sun Feb 23, 2014 09:51:09.0000 | | 1 | | Sun Feb 23, 2014 09:51:10.0000 | | 1 |
|
CREATE DATETIME |
| UNIQUE_QUIZ |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(25.00%) |
|
UPDATE USER ID |
| UNIQUE_QUIZ |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(25.00%) |
|
UPDATE DATETIME |
| USERS |
USER_ID |
NUMBER[10] |
1 |
NO |
YES |
236
(100.00%) |
| Value | Length | Count | | 1 | | 1 | | 2 | | 1 | | 3 | | 1 | | 4 | | 1 | | 5 | | 1 | | 6 | | 1 | | 7 | | 1 | | 8 | | 1 | | 9 | | 1 | | 10 | | 1 |
|
USER ID |
| USERS |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
236
(100.00%) |
| Value | Length | Count | | abono | 5 | 1 | | agibbs | 6 | 1 | | ahall | 5 | 1 | | akelly | 6 | 1 | | aliu | 4 | 1 | | aperry | 6 | 1 | | aroberts | 8 | 1 | | asmith | 6 | 1 | | cbagley | 7 | 1 | | cbagwell | 8 | 1 |
|
Username has to be
unique across the system.
Use of email adress is encouraged however it cannot be enforced because
many user will not have e-mail addresses or they will not provide it for
various reasons. |
| USERS |
LANGUAGE_ID |
NUMBER[10] |
|
YES |
NO |
2
(0.85%) |
|
User can have a language other than English.
If this field is empty then default language is english. |
| USERS |
ORGANIZATION_ID |
NUMBER[10] |
|
YES |
NO |
1
(0.42%) |
|
ORGANIZATION ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
PASSWORD |
VARCHAR2[50] |
|
NO |
YES |
236
(100.00%) |
| Value | Length | Count | | +hS11lHmJuKiAAVpuZOk... | 23 | 1 | | +pgGqnk5MOzclD96B/Kd... | 23 | 1 | | +sGK9U2zUGLDZRi5Kzb5... | 23 | 1 | | +ueT03F8OaE9Pl15wGVQ... | 23 | 1 | | /4LbZNB1Z9DNIzpJwphr... | 23 | 1 | | /Xt7PL2WOTeEcoVKQddQ... | 23 | 1 | | /afLICJw9uMIeP0tuFER... | 23 | 1 | | 02rks2l+D/0DF52eoZP8... | 23 | 1 | | 05u/buw21oweiNucGspl... | 23 | 1 | | 09kRdhtH07ZUbSAX9LSr... | 23 | 1 |
|
PASSWORD |
| USERS |
MUST_CHANGE_PW_ON_NEXT_LOGIN |
CHAR[1] |
|
YES |
NO |
1
(0.42%) |
|
Indicates if user has to change password on next login.
As soon as user changes password this flag should be set to "N" or NULL
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
PW_EXPIRY_DATETIME |
DATE[7] |
|
YES |
NO |
1
(0.42%) |
|
Date and time when password expires.
When user logs in after that date it will be forced to change password.
NULL - password never expires.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
FIRST_NAME |
VARCHAR2[50] |
|
NO |
NO |
149
(63.14%) |
| Value | Length | Count | | Perry | 5 | 6 | | Pat | 3 | 4 | | Peggy | 5 | 3 | | Pete | 4 | 3 | | Alec | 4 | 2 | | Alexa | 5 | 2 | | Clark | 5 | 2 | | Claude | 6 | 2 | | Cliff | 5 | 2 | | Clint | 5 | 2 |
|
FIRST NAME |
| USERS |
LAST_NAME |
VARCHAR2[50] |
|
NO |
NO |
154
(65.25%) |
| Value | Length | Count | | Baldwin | 7 | 3 | | Barber | 6 | 3 | | Benson | 6 | 3 | | Bowen | 5 | 3 | | Cummings | 8 | 3 | | Daniel | 6 | 3 | | Griffith | 8 | 3 | | Hines | 5 | 3 | | Hubbard | 7 | 3 | | Lyons | 5 | 3 |
|
LAST NAME |
| USERS |
GENDER_CODE |
VARCHAR2[3] |
|
YES |
NO |
1
(0.42%) |
|
GENDER_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
DATE_OF_BIRTH |
DATE[7] |
|
YES |
NO |
4
(1.69%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:50:37.0000 | | 96 | | Sun Feb 23, 2014 09:50:36.0000 | | 67 | | Sun Feb 23, 2014 09:50:38.0000 | | 59 | | Sun Feb 23, 2014 09:50:39.0000 | | 14 |
|
DATE_OF_BIRTH |
| USERS |
SEMESTER |
NUMBER[0] |
|
YES |
NO |
1
(0.42%) |
|
Current semester the Student is inroleed into.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
NO |
1
(0.42%) |
|
Current Year of study
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
LAST_LOGON |
DATE[7] |
|
YES |
NO |
1
(0.42%) |
|
LAST LOGON
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
FAILED_LOGINS |
NUMBER[10] |
|
YES |
NO |
1
(0.42%) |
|
Number of censequtive failed logons since last succesfull log in.
null means that tyhis user never logged in to the system.
This number is always updated - either with "0" or other positive number.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
TOTAL_LOGONS |
NUMBER[10] |
|
YES |
NO |
1
(0.42%) |
|
Total number of succesfull logons to the system.
Null if user never logged in to the system.
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
EMAIL |
NVARCHAR2[100] |
|
YES |
NO |
234
(99.15%) |
| Value | Length | Count | | zoran@mallocinc.com | 19 | 3 | | Nancy4927@hotmail.co... | 23 | 1 | | aurie@yahoo.ca | 14 | 1 | | avel@yahoo.ca | 13 | 1 | | baker4809@hotmail.ca | 20 | 1 | | clinthill4722@yahoo.... | 23 | 1 | | cmdron2794@hotmail.c... | 23 | 1 | | colin6913@yahoo.ca | 18 | 1 | | corybain@yahoo.com | 18 | 1 | | craig4791@hotmail.co... | 23 | 1 |
|
EMAIL |
| USERS |
EMAIL2 |
NVARCHAR2[100] |
|
YES |
NO |
234
(99.15%) |
| Value | Length | Count | | zoran@rogers.com | 16 | 3 | | bandere09@hotmail.ca | 20 | 1 | | barkingme8461@hotmai... | 23 | 1 | | clinno232@yahoo.ca | 18 | 1 | | coldhot13@yahoo.ca | 18 | 1 | | coldtrain482@yahoo.c... | 23 | 1 | | coolpret4783@yahoo.c... | 23 | 1 | | cotyain@yahoo.com | 17 | 1 | | craihe791@hotmail.co... | 23 | 1 | | cravingpie492@hotmai... | 23 | 1 |
|
EMAIL2 |
| USERS |
DAYTIME_PHONE |
VARCHAR2[50] |
|
YES |
NO |
1
(0.42%) |
|
DAYTIME PHONE
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
EVENING_PHONE |
VARCHAR2[50] |
|
YES |
NO |
1
(0.42%) |
|
EVENING PHONE
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
USER_TYPE |
VARCHAR2[3] |
|
YES |
NO |
3
(1.27%) |
| Value | Length | Count | | STU | 3 | 181 | | ADS | 3 | 29 | | PRO | 3 | 26 |
|
This field is currently not used. |
| USERS |
USER_STATUS |
VARCHAR2[3] |
|
YES |
NO |
1
(0.42%) |
|
USER_STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
TIME_ZONE |
NUMBER[10] |
|
YES |
NO |
17
(7.20%) |
| Value | Length | Count | | -3 | | 46 | | 2 | | 25 | | 4 | | 23 | | 6 | | 23 | | -4 | | 20 | | 9 | | 15 | | -7 | | 12 | | -5 | | 12 | | -2 | | 12 | | 8 | | 11 |
|
TIME ZONE |
| USERS |
COMMENTS |
VARCHAR2[2000] |
|
YES |
YES |
N/A |
|
Comments associated to this user |
| USERS |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
NO |
1
(0.42%) |
|
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
CREATE_DATETIME |
DATE[7] |
|
NO |
NO |
4
(1.69%) |
| Value | Length | Count | | Sun Feb 23, 2014 09:50:34.0000 | | 94 | | Sun Feb 23, 2014 09:50:33.0000 | | 65 | | Sun Feb 23, 2014 09:50:35.0000 | | 62 | | Sun Feb 23, 2014 09:50:36.0000 | | 15 |
|
CREATE DATETIME |
| USERS |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
NO |
1
(0.42%) |
|
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS |
UPDATE_DATETIME |
DATE[7] |
|
YES |
NO |
1
(0.42%) |
|
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS_CLASS |
USER_ID |
NUMBER[10] |
1 |
NO |
NO |
236
(4.00%) |
| Value | Length | Count | | 1 | | 25 | | 2 | | 25 | | 3 | | 25 | | 4 | | 25 | | 5 | | 25 | | 6 | | 25 | | 7 | | 25 | | 8 | | 25 | | 9 | | 25 | | 10 | | 25 |
|
USER ID |
| USERS_CLASS |
CLASS_ID |
NUMBER[10] |
2 |
NO |
NO |
25
(0.42%) |
| Value | Length | Count | | 1 | | 236 | | 2 | | 236 | | 3 | | 236 | | 4 | | 236 | | 5 | | 236 | | 6 | | 236 | | 7 | | 236 | | 8 | | 236 | | 9 | | 236 | | 10 | | 236 |
|
CLASS_ID |
| USERS_CLASS |
USER_CLASS_ROLE |
VARCHAR2[3] |
|
YES |
NO |
1
(0.02%) |
| Value | Length | Count | | ADM | 3 | 5,900 |
|
Defines the primary role of the user associated with the class.
Defined in code type "USER CLASS ROLE"
For example:
'ADM' - Administrator - it can administrer class (add or remove users form the class)
null - simple member of the class
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USERS_POOLS |
POOL_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
Pool of questions Primary Key |
| USERS_POOLS |
USER_ID |
NUMBER[10] |
2 |
NO |
N/A |
N/A |
|
USER ID |
| USERS_POOLS |
USERS_POOL_ROLE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
Defines the role of the user for this pool of questions. for example:
- can edit pool
- can use pool
- etc. |
| USER_ACTION_LOG |
USER_ACTION_LOG_ID |
NUMBER[0] |
1 |
NO |
N/A |
N/A |
|
USER ACTION LOG ID |
| USER_ACTION_LOG |
USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
USER ID |
| USER_ACTION_LOG |
ACTION_CODE |
VARCHAR2[10] |
|
NO |
N/A |
N/A |
|
ACTION CODE |
| USER_ACTION_LOG |
COMMENTS |
VARCHAR2[1000] |
|
YES |
N/A |
N/A |
|
COMMENTS |
| USER_ACTION_LOG |
CREATE_DATETIME |
TIMESTAMP(6)[11,6] |
|
NO |
N/A |
N/A |
|
CREATE DATETIME |
| USER_COURSE |
USER_ID |
NUMBER[10] |
1 |
NO |
NO |
236
(1.69%) |
| Value | Length | Count | | 1 | | 59 | | 2 | | 59 | | 3 | | 59 | | 4 | | 59 | | 5 | | 59 | | 6 | | 59 | | 7 | | 59 | | 8 | | 59 | | 9 | | 59 | | 10 | | 59 |
|
USER ID |
| USER_COURSE |
COURSE_ID |
NUMBER[10] |
2 |
NO |
NO |
59
(0.42%) |
| Value | Length | Count | | 2 | | 236 | | 3 | | 236 | | 4 | | 236 | | 5 | | 236 | | 6 | | 236 | | 7 | | 236 | | 8 | | 236 | | 9 | | 236 | | 11 | | 236 | | 12 | | 236 |
|
COURSE_ID |
| USER_COURSE |
USER_COURSE_ROLE |
VARCHAR2[3] |
|
YES |
NO |
1
(0.01%) |
| Value | Length | Count | | AAA | 3 | 13,924 |
|
Primary Role of the user for that course
USER_ROLE_CODE is populated with codes where CODE_TYPE_NAME = 'USER_COURSE_ROLE'
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| USER_PREFERENCES |
USER_PREFERENCES_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
USER PREFERENCES ID |
| USER_PREFERENCES |
USER_ID |
NUMBER[10] |
|
NO |
N/A |
N/A |
|
USER ID |
| USER_PREFERENCES |
USER_PREFERENCES_NAME |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
USER_PREFERENCES_NAME |
| USER_PREFERENCES |
MAX_RECORDS_RETURNED |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
MAX RECORDS RETURNED |
| USER_PREFERENCES |
ANSWER_TABLE_WIDTH |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
ANSWER TABLE WIDTH |
| USER_PREFERENCES |
TABLE_CHECK_BOX_COLUMN_WIDTH |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
TABLE CHECK BOX COLUMN WIDTH |
| USER_PREFERENCES |
TABLE_BG_ALT_COLOR1 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
TABLE BG ALT COLOR1 |
| USER_PREFERENCES |
TABLE_BG_ALT_COLOR2 |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
TABLE BG ALT COLOR2 |
| USER_PREFERENCES |
TABLE_BODY_FONT_SIZE |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
TABLE BODY FONT SIZE |
| USER_PREFERENCES |
TABLE_BODY_FONT_FACE |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
TABLE BODY FONT FACE |
| USER_PREFERENCES |
TABLE_HEADER_BG_COLOR |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
TABLE HEADER BG COLOR |
| USER_PREFERENCES |
TABLE_HEADER_FONT_SIZE |
NUMBER[10] |
|
YES |
N/A |
N/A |
|
TABLE HEADER FONT SIZE |
| USER_PREFERENCES |
TABLE_HEADER_FONT_FACE |
VARCHAR2[50] |
|
YES |
N/A |
N/A |
|
TABLE HEADER FONT FACE |
| USER_PREFERENCES |
USER_LOGO |
BLOB[4000] |
|
YES |
N/A |
N/A |
|
User's logo that may appear on his pages and Quizzes |
| USER_PREFERENCES |
USER_PREFERENCES_STATUS |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
USER_PREFERENCES_STATUS |
| USER_QUIZ |
USER_ID |
NUMBER[10] |
1 |
NO |
N/A |
N/A |
|
USER ID |
| USER_QUIZ |
QUIZ_DEFINITION_ID |
NUMBER[10] |
2 |
NO |
N/A |
N/A |
|
QUIZ_DEFINITION_ID |
| USER_QUIZ |
USER_QUIZ_ROLE |
VARCHAR2[3] |
|
YES |
N/A |
N/A |
|
-QMN - Quiz manager
|
| USER_ROLE |
USER_ID |
NUMBER[10] |
2 |
NO |
YES |
236
(100.00%) |
| Value | Length | Count | | 1 | | 1 | | 2 | | 1 | | 3 | | 1 | | 4 | | 1 | | 5 | | 1 | | 6 | | 1 | | 7 | | 1 | | 8 | | 1 | | 9 | | 1 | | 10 | | 1 |
|
USER ID |
| USER_ROLE |
ROLE_CODE |
VARCHAR2[3] |
1 |
NO |
NO |
3
(1.27%) |
| Value | Length | Count | | STU | 3 | 136 | | PRF | 3 | 90 | | ADM | 3 | 10 |
|
ROLE CODE |
| USER_ROLE |
ENABLED |
CHAR[1] |
|
NO |
NO |
1
(0.42%) |
|
ENABLED
SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
| V_CLASS_COURSE |
CLASS_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_NAME |
VARCHAR2[200] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_ACTIVE_FROM |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_ACTIVE_TO |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_STATUS |
CHAR[3] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
PARENT_COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_NAME |
VARCHAR2[300] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_CATEGORY_LEVEL |
NUMBER[0] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_DESCRIPTION |
VARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_CREDITS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_DURATION_IN_HRS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_DEPARTMENT_ID |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
COURSE_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_COURSE_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_COURSE_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_COURSE_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_CLASS_COURSE |
CLASS_COURSE_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_CODES |
CODE_TYPE_ID |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_CODES |
CODE_TYPE_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_CODES |
CODE_TYPE_DESCRIPTION |
VARCHAR2[200] |
|
NO |
YES |
N/A |
|
|
| V_CODES |
CODE_ID |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_CODES |
CODE_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_CODES |
CODE_DESCRIPTION |
VARCHAR2[200] |
|
NO |
YES |
N/A |
|
|
| V_COURSES |
COURSE_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_COURSES |
COURSE_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
CATEGORY |
VARCHAR2[300] |
|
NO |
YES |
N/A |
|
|
| V_COURSES |
TOP_COURSE |
VARCHAR2[300] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
COURSE_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
TABLE_LEVEL |
NUMBER[0] |
|
NO |
YES |
N/A |
|
|
| V_COURSES |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
COURSE_DESCRIPTION |
VARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_COURSES |
PARENT_COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
COURSE_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
CREDITS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
DURATION_IN_HRS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
DEPARTMENT_ID |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES |
YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_NAME |
VARCHAR2[300] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
TOP_COURSE |
VARCHAR2[300] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_TREE |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
TABLE_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_DESCRIPTION |
VARCHAR2[2000] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
PARENT_COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
CREDITS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
DURATION_IN_HRS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
DEPARTMENT_ID |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_COURSES_SUM |
COURSE_COUNT |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_DOCUMENT |
DOCUMENT_ID |
NUMBER[0] |
|
NO |
YES |
N/A |
|
|
| V_DOCUMENT |
DOCUMENT_TITLE |
VARCHAR2[400] |
|
NO |
YES |
N/A |
|
|
| V_DOCUMENT |
DOCUMENT_DESCRIPTION |
VARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_DOCUMENT |
DOCUMENT_BINARY_CONTENT_SIZE |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_DOCUMENT |
DOCUMENT_CHAR_CONTENT_SIZE |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_DOCUMENT |
FILE_NAME |
VARCHAR2[400] |
|
YES |
YES |
N/A |
|
|
| V_DOCUMENT |
FILE_PATH |
VARCHAR2[400] |
|
YES |
YES |
N/A |
|
|
| V_DOCUMENT |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_DOCUMENT |
CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_DOCUMENT |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_DOCUMENT |
UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
POOL_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
POOL_NAME |
VARCHAR2[100] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
TOP_POOL |
VARCHAR2[100] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
POOL_TREE |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
POOL_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
POOL_DESCRIPTION |
VARCHAR2[500] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
PARENT_POOL_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_POOLS_SUM |
POOL_COUNT |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_POOL_QUESTION_INFO |
POOL_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_POOL_QUESTION_INFO |
POOL_NAME |
VARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_POOL_QUESTION_INFO |
NUMBER_OF_QUESTIONS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_POOL_QUESTION_SUM |
POOL_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_POOL_QUESTION_SUM |
POOL_NAME |
VARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_POOL_QUESTION_SUM |
NUMBER_OF_QUESTIONS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
POOL_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
POOL_NAME |
VARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
QUESTION_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
QUESTION_TEXT |
NVARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
DIFFICULTY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUESTIONS_IN_POOLS |
POINTS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUIZ_DEFINITION_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUIZ_NAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
DEFAULT_DURATION |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
USERS_COMMENT |
NVARCHAR2[2000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
DEFAULT_ENABLED_FROM |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
DEFAULT_ENABLED_TO |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
DISPLAY_ANSWER_IND |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
DISPLAY_CORRECT_IND |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
DURATION_FACTOR |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUIZ_DEF_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
QUIZ_DEF_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
QUIZ_DEF_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUIZ_DEF_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_TEXT |
NVARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
DURATION |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
DIFFICULTY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
POINTS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
EXCEL_QUESTION_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_MUL_CHOICE_IND |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
READ_ONLY_IND |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
QUESTION_ORDINAL_NUMBER |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
STATUS |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ |
ANSWER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
ANSWER_TEXT |
VARCHAR2[2000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
ANSWER_ORDINAL_NUMBER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
CORRECT_ANSWER_IND |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
ANSWER_CREATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
ANSWER_CREATA_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
ANSWER_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ |
ANSWER_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
QUIZ_CATEGORY_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
CATEGORY |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
TOP_CATEGORY |
VARCHAR2[50] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
CATEGORY_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
TABLE_LEVEL |
NUMBER[0] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
QUIZ_CATEGORY_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES |
PARENT_QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
CATEGORY |
VARCHAR2[50] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
TOP_CATEGORY |
VARCHAR2[50] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
CATEGORY_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
CATEGORY_TREE |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
TABLE_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
QUIZ_CATEGORY_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
PARENT_QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM |
SUB_CATEGORIES_COUNT |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
CATEGORY |
VARCHAR2[50] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
TOP_CATEGORY |
VARCHAR2[50] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
CATEGORY_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
CATEGORY_TREE |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
TABLE_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
QUIZ_CATEGORY_DESCRIPTION |
VARCHAR2[1000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
PARENT_QUIZ_CATEGORY_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_CATEGORIES_SUM2 |
QUIZ_COUNT |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUIZ_INSTANCE_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_ID_TESTED |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUIZ_RESULT_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_TEXT |
NVARCHAR2[2000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
NOT_SURE_FLAG |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
POINTS_ASSIGNED |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
Q_RESULT_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
Q_RESULT_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
Q_RESULT_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
Q_RESULT_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_TEXT |
NVARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
PICTURE |
BLOB[4000] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_DURATION |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_DIFFICULTY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_POINTS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
EXCEL_QUESTION_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_MULTI_CHOICE_IND |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
QUESTION_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_ANSWERED_TEXT |
VARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_ORDINAL_NUMBER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
CORRECT_ANSWER_IND |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
ANSWER_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT_SUM |
QUIZ_INSTANCE_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT_SUM |
USER_ID_TESTED |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_QUIZ_RESULT_SUM |
MAX_POINTS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT_SUM |
POINTS_ASSIGNED |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_QUIZ_RESULT_SUM |
PERCENT_SCORED |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
ROLE_CODE |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
ROLE_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
ROLE_DESCRIPTION |
VARCHAR2[400] |
|
YES |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
GRANTABLE |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
ROLE_ENABLED |
CHAR[1] |
|
NO |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
FUNCTION_CODE |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
FUNCTION_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
FUNCTION_DESCRIPTION |
VARCHAR2[400] |
|
YES |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
FUNCTION_ENABLED |
CHAR[1] |
|
NO |
YES |
N/A |
|
|
| V_ROLES_PERMISSIONS |
ROLE_FUNCTION_ENABLED |
CHAR[1] |
|
NO |
YES |
N/A |
|
|
| V_ST_QUIZ |
ST_QUIZ_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
Primary key |
| V_ST_QUIZ |
ST_QUESTION_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
Primary key of table table ST_QUESTION_ID |
| V_ST_QUIZ |
ST_ANSWER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
Primary key of table table ST_ANSWER |
| V_ST_QUIZ |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
Username has to be unique across the system.
Use of email adress is encouraged however it cannot be enforced because many
user will not have e-mail addresses or they will not provide it for various
reasons. |
| V_ST_QUIZ |
PASSWORD |
CHAR[10] |
|
YES |
YES |
N/A |
|
PASSWORD |
| V_ST_QUIZ |
USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
USER ID |
| V_ST_QUIZ |
QUIZ_NAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
Name (Title) of this test. |
| V_ST_QUIZ |
DEFAULT_DURATION |
NUMBER[10] |
|
YES |
YES |
N/A |
|
Test duration in seconds.
This is time available to complete the test once test instance started. |
| V_ST_QUIZ |
USERS_COMMENT |
NVARCHAR2[2000] |
|
YES |
YES |
N/A |
|
USERS COMMENT |
| V_ST_QUIZ |
DEFAULT_ENABLED_FROM |
DATE[7] |
|
YES |
YES |
N/A |
|
DEFAULT ENABLED FROM |
| V_ST_QUIZ |
DEFAULT_ENABLED_TO |
DATE[7] |
|
YES |
YES |
N/A |
|
DEFAULT ENABLED TO |
| V_ST_QUIZ |
RESULT_TRANSPARENCY |
VARCHAR2[20] |
|
YES |
YES |
N/A |
|
RESULT TRANSPARENCY |
| V_ST_QUIZ |
DURATION_FACTOR |
NUMBER[10] |
|
YES |
YES |
N/A |
|
Factor (in percents, for example: -40%, +120%, +300%) - how much the available
time for answering the questions should be shortened or prolonged.
Apply duration factor to the length of every question.
On this way duration of the questions can be parametrized. |
| V_ST_QUIZ |
STATUS |
CHAR[1] |
|
NO |
YES |
N/A |
|
"S" - Loaded only in staging tables
"L" - Loaded into permanent tables, data from staging tables can be deleted |
| V_ST_QUIZ |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
CREATE USER ID |
| V_ST_QUIZ |
CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
CREATE DATETIME |
| V_ST_QUIZ |
QST_ARTIFICIAL_QUESTION_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
This is number assigned by user in order to link questions with answers in
excel. |
| V_ST_QUIZ |
QUESTION_TEXT |
NVARCHAR2[2000] |
|
NO |
YES |
N/A |
|
QUESTION TEXT |
| V_ST_QUIZ |
PICTURE |
BLOB[4000] |
|
YES |
YES |
N/A |
|
This is picture that is displayed with question. |
| V_ST_QUIZ |
DURATION |
NUMBER[10] |
|
YES |
YES |
N/A |
|
Duration of the question in seconds.
This is optional value and it is intended to be used to limit time available to
answer this question. |
| V_ST_QUIZ |
DIFFICULTY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
This is degree of difficulty.
Higher number represents higher difficulty of question. |
| V_ST_QUIZ |
POINTS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
Number of points that person gets by answering this question correctly.
For example difficult questions can score more points than the others.
This is the "weight" of the question. |
| V_ST_QUIZ |
QUESTION_ORDINAL_NUMBER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
This number determines the order of this question as it appears on the test.
Lower numbers are displayed first. If this number is not present then questions
will be displayed in default order. |
| V_ST_QUIZ |
ANS_ARTIFICIAL_QUESTION_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
This is number assigned by user in order to link questions with answers in
excel. |
| V_ST_QUIZ |
ANSWER_TEXT |
NVARCHAR2[2000] |
|
YES |
YES |
N/A |
|
ANSWER_TEXT |
| V_ST_QUIZ |
ANSWER_ORDINAL_NUMBER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
This number determines the order of this answer as it appears on the test.
Lower numbers are displayed first. If this number is not present then answers
will be displayed in default order. |
| V_ST_QUIZ |
CORRECT_ANSWER_IND |
CHAR[1] |
|
YES |
YES |
N/A |
|
Indicates if this is the correct answer. |
| V_SUBCAT_AND_COURSES_SUM |
QUIZ_COUNT |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_SUBCAT_AND_COURSES_SUM |
PARENT_QUIZ_CAT |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_ACTIONS |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_ACTIONS |
PASSWORD |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ACTIONS |
ACTION_CODE |
VARCHAR2[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_ACTIONS |
CREATE_DATETIME |
TIMESTAMP(6)[11,6] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_NAME |
VARCHAR2[200] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_ACTIVE_FROM |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_ACTIVE_TO |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_STATUS |
CHAR[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
USER_CLASS_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS |
CLASS_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USERNAME |
NVARCHAR2[100] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_FIRST_NAME |
VARCHAR2[50] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_LAST_NAME |
VARCHAR2[50] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
CLASS_ID |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
CLASS_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
CLASS_NAME |
VARCHAR2[200] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_CLASS_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
CLASS_ACTIVE_FROM |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
CLASS_ACTIVE_TO |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
CLASS_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
PARENT_COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_NAME |
VARCHAR2[300] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_CATEGORY_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_DESCRIPTION |
VARCHAR2[2000] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_CREDITS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_DURATION_IN_HRS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_DEPARTMENT_ID |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
COURSE_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_CLASS_COURSE |
USER_COURSE_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
USER_COURSE_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
PARENT_COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_NAME |
VARCHAR2[300] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_CATEGORY_LEVEL |
NUMBER[0] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_DESCRIPTION |
VARCHAR2[2000] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_CREDITS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_DURATION_IN_HRS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_DEPARTMENT_ID |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE |
COURSE_UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_ROLE |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_ROLE |
USER_FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_ROLE |
USER_LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_ROLE |
USER_ROLE_CODE |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_ROLE |
COURSE_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
USER_COURSE_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
PARENT_COURSE_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_NAME |
VARCHAR2[300] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_CODE |
VARCHAR2[30] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
TOP_COURSE |
VARCHAR2[300] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_DESCRIPTION |
VARCHAR2[2000] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
TABLE_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_COUNT |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_TREE |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
COURSE_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
CREDITS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
DURATION_IN_HRS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
DEPARTMENT_ID |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_COURSE_TREE |
YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS |
USER_POOL_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS |
POOL_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
POOL_NAME |
VARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
POOL_DESCRIPTION |
VARCHAR2[500] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS |
UPDATE_USER_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS |
UPDATE_DATETIME |
DATE[7] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USER_FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USER_LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USER_SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USER_YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
USERS_POOL_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
POOL_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
PARENT_POOL_ID |
NUMBER[10] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
POOL_NAME |
VARCHAR2[100] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
TOP_POOL |
VARCHAR2[100] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
POOL_DESCRIPTION |
VARCHAR2[500] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
SYSTEM_LEVEL |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
IS_LEAF |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
POOL_COUNT |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
POOL_TREE |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOLS_TREE |
POOL_PATH |
VARCHAR2[4000] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
POOL_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
POOL_NAME |
VARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
POOL_DESCRIPTION |
VARCHAR2[500] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
CREATE_USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
CREATE_DATETIME |
DATE[7] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
USERS_POOL_ROLE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_POOL_SUM_QUESTIONS |
NUMBER_OF_QUESTIONS |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES |
FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES |
LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES |
SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES |
YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES |
ROLE_CODE |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES |
ROLE_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES |
ROLE_DESCRIPTION |
VARCHAR2[400] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES |
GRANTABLE |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES |
ROLE_ENABLED |
CHAR[1] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
USER_ID |
NUMBER[10] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
USERNAME |
NVARCHAR2[100] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
FIRST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
LAST_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
SEMESTER |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
YEAR_OF_STUDY |
NUMBER[0] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
USER_TYPE |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
USER_STATUS |
VARCHAR2[3] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
ROLE_CODE |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
ROLE_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
ROLE_DESCRIPTION |
VARCHAR2[400] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
GRANTABLE |
CHAR[1] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
ROLE_ENABLED |
CHAR[1] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
FUNCTION_CODE |
VARCHAR2[3] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
FUNCTION_NAME |
VARCHAR2[50] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
FUNCTION_DESCRIPTION |
VARCHAR2[400] |
|
YES |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
FUNCTION_ENABLED |
CHAR[1] |
|
NO |
YES |
N/A |
|
|
| V_USER_ROLES_PERMISSIONS |
ROLE_FUNCTION_ENABLED |
CHAR[1] |
|
NO |
YES |
N/A |
|
|