YouTestMe Database Report |
Feature | Value |
Connection Description | YouTestMe Database |
Analysis date | 2014-02-23 09:51:53 PM EST |
DB Analyzer software version | 6.0 |
DB Analyzer software demo version | No |
Product Name | Oracle |
Database product name: | Oracle |
Catalog term: | |
Schema term: | schema |
Identifier Quote String: | Oracle |
Search String Escape: | / |
"Extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _): | $# |
Database Major Version: | 11 |
Database Minor Version: | 2 |
Database Product Version: | Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options |
Driver Major Version: | 11 |
Driver Name: | Oracle JDBC driver |
Driver Version: | 11.2.0.3.0 |
Numeric Functions: | ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, ROUND, SIGN, SIN, SQRT, TAN, TRUNCATE |
String Functions | ASCII, CHAR, CHAR_LENGTH, CHARACTER_LENGTH, CONCAT, LCASE, LENGTH, LTRIM, OCTET_LENGTH, REPLACE, RTRIM, SOUNDEX, SUBSTRING, UCASE |
Database URL | jdbc:oracle:thin:@zserver:1521:zoracle |
User name used for this connection | YTM11 |
Database is read only | No |
Database is case sensitive | N |
Data definition statement within a transaction forces the transaction to commit | Y |
Database ignores a data definition statement within a transaction | N |
String used to quote SQL identifiers | " |
Feature | Value (zero means that there is no limit or the limit is not known) |
Max Row Size: | 0 |
Max Row Size includes BLOB(s) (includes the SQL data types LONGVARCHAR and LONGVARBINARY) | Y |
Max Table Name Length: | 30 |
Max User Name Length: | 30 |
Max Tables In Select | 0 |
Maximum length (in hex characters) for a binary literal | 1000 |
Maximum number of characters allowed in a catalog name | 0 |
Maximum number of characters allowed for a character literal | 2000 |
Maximum number of characters this database allows for a column name | 30 |
Maximum number of columns this database allows in a GROUP BY clause | 0 |
Maximum number of columns this database allows in an index | 32 |
Maximum number of columns this database allows in an ORDER BY clause | 0 |
Maximum number of columns this database allows in a SELECT list | 0 |
Maximum number of columns this database allows in a table | 1000 |
Maximum number of concurrent connections to this database that are possible | 0 |
Maximum number of characters that this database allows in a cursor name | 0 |
Maximum number of characters that this database allows in a cursor name | 0 |
Maximum number of characters that this database allows in a procedure name | 30 |
Maximum number of characters that this database allows in a schema name | 30 |
Maximum number of characters this database allows in an SQL statement | 65535 |
Maximum number of active statements to this database that can be open at the same time | 0 |
Feature | Supported |
Mixed Case Identifiers | N |
Mixed Case Quoted Identifiers | Y |
Alter Table With Add Column | Y |
Alter Table With Drop Column | N |
Column Aliasing | Y |
Convert | N |
Table Correlation Names | Y |
Different Table Correlation Names | Y |
Expressions in Order By | Y |
Order By Unrelated | Y |
Group by | Y |
Group by Unrelated | Y |
Group by Beyond Select | Y |
Like Escape Clause | Y |
Multiple Result Sets | N |
Multiple Transactions | Y |
Non Nullable Columns | Y |
Minimum SQL Grammar | Y |
Core SQL Grammar | Y |
Extended SQL Grammar | Y |
ANSI 92 Entry Level SQL | Y |
ANSI 92 Intermediate SQL | N |
ANSI 92 Full SQL | N |
Integrity Enhancement Facility | Y |
Outer Joins | Y |
Full Outer Joins | Y |
Limited Outer Joins | Y |
Schemas in Data Manipulation | Y |
Schemas in Procedure Calls | Y |
Schemas in Table Definitions | Y |
Schemas in Index Definitions | Y |
Schemas in Privilege Definitions | Y |
Catalogs in Data Manipulation | N |
Catalogs in Procedure Calls | N |
Catalogs in Table Definitions | N |
Catalogs in Index Definitions | N |
Catalogs in Privilege Definitions | N |
Positioned Delete | N |
Positioned Update | N |
Select for Update | Y |
Stored Procedures | Y |
Subqueries in Comparisons | Y |
Subqueries in Exists | Y |
Subqueries in Ins | Y |
Subqueries in Quantifieds | Y |
Correlated Subqueries | Y |
Union | Y |
Union All | Y |
Open Cursors Across Commit | N |
Open Cursors Across Rollback | N |
Open Statements Across Commit | N |
OpenStatements Across Rollback | N |
Transactions | Y |
Transaction Isolation Level | Y |
Data Definition and Data Manipulation Transactions | Y |
Supports only data manipulation statements within a transaction | Y |
Batch Updates | Y |
Savepoints | Y |
Named SessionParameters | Y |
Multiple Open Results | N |
Get Generated Keys | Y |
Statement Pooling | Y |
Result Set Type: Forward Only | Y |
Result Set Type: Scroll Insensitive | Y |
Result Set Type: Scroll Sensitive | Y |
Result Set Type: Forward Only Read Only | Y |
Result Set Type: Forward Only Updateable | Y |
Result Set Type: Scroll Insensitive Read Only | Y |
Result Set Type: Scroll Insensitive Updateable | Y |
Result Set Concurrency: Scroll Sensitive Read Only | Y |
Result Set Concurrency: Scroll Sensitive Updateable | Y |
Batch Updates | Y |
Named SessionParameters | Y |
Multiple Open Results | N |
Get Generated Keys | Y |
Result Set Holdability: Hold Cursos Over Commit | Y |
Result Set Holdability: Close Cursors At Commit | N |
# | Database |
1. | DEFAULT_DATABASE |
Database DEFAULT_DATABASE | Schema |
1. | ANONYMOUS |
2. | APEX_030200 |
3. | APEX_PUBLIC_USER |
4. | APPQOSSYS |
5. | BI |
6. | CTXSYS |
7. | DBSNMP |
8. | DIP |
9. | EXFSYS |
10. | FLOWS_FILES |
11. | GDAODEMO |
12. | HR |
13. | IX |
14. | LOUI |
15. | MDDATA |
16. | MDSYS |
17. | MGMT_VIEW |
18. | OE |
19. | OLAPSYS |
20. | ORACLE_OCM |
21. | ORDDATA |
22. | ORDPLUGINS |
23. | ORDSYS |
24. | OUTLN |
25. | OWBSYS |
26. | OWBSYS_AUDIT |
27. | PM |
28. | SCOTT |
29. | SH |
30. | SI_INFORMTN_SCHEMA |
31. | SPATIAL_CSW_ADMIN_USR |
32. | SPATIAL_WFS_ADMIN_USR |
33. | SYS |
34. | SYSMAN |
35. | SYSTEM |
36. | WMSYS |
37. | XDB |
38. | XS$NULL |
39. | YOUTESTME |
40. | YTM1 |
41. | YTM10 |
42. | YTM11 |
43. | YTM12 |
44. | YTM13 |
45. | YTM14 |
46. | YTM15 |
47. | YTM16 |
48. | YTM17 |
49. | YTM18 |
50. | YTM19 |
51. | YTM2 |
52. | YTM20 |
53. | YTM3 |
54. | YTM4 |
55. | YTM5 |
56. | YTM6 |
57. | YTM7 |
58. | YTM8 |
59. | YTM9 |
60. | ZDBA |
61. | ZORAN |
62. | ZORAN1 |
63. | ZORAN2 |
64. | ZORAN3 |
Schema YTM11 |
Table | Type | Rows | Columns |
1. | ADDRESS | TABLE | 0 | 22 |
2. | ANSWER | TABLE | 605 | 10 |
3. | CLASS | TABLE | 25 | 11 |
4. | CLASS_COURSE | TABLE | 93 | 6 |
5. | CODE | TABLE | 71 | 6 |
6. | CODE_TYPE | TABLE | 24 | 4 |
7. | COURSE | TABLE | 65 | 16 |
8. | DOCUMENT | TABLE | 0 | 11 |
9. | EMAIL_SENT | TABLE | 0 | 4 |
10. | EMAIL_TEMPLATE | TABLE | 0 | 2 |
11. | FUNCTION | TABLE | 14 | 4 |
12. | GRADING_SYSTEM | TABLE | 0 | 7 |
13. | GRADING_SYSTEM_LABEL | TABLE | 0 | 10 |
14. | LANGUAGE | TABLE | 72 | 3 |
15. | ORGANIZATION | TABLE | 0 | 10 |
16. | POOL | TABLE | 70 | 8 |
17. | POOL_QUESTION | TABLE | 0 | 2 |
18. | QUESTION | TABLE | 121 | 18 |
19. | QUIZ_CATEGORY | TABLE | 69 | 9 |
20. | QUIZ_DEFINITION | TABLE | 4 | 33 |
21. | QUIZ_DEFINITION_POOL | TABLE | 0 | 6 |
22. | QUIZ_EMAIL_ACTION | TABLE | 0 | 5 |
23. | QUIZ_INSTANCE | TABLE | 0 | 17 |
24. | QUIZ_QUESTION | TABLE | 121 | 6 |
25. | QUIZ_RESULT | TABLE | 0 | 13 |
26. | QUIZ_RESULT_ANSWER | TABLE | 0 | 3 |
27. | QUIZ_TEMPLATE | TABLE | 0 | 27 |
28. | QUIZ_TEMPLATE_POOL | TABLE | 0 | 6 |
29. | REPORT_DEFINITION | TABLE | 0 | 10 |
30. | REPORT_INSTANCE | TABLE | 0 | 7 |
31. | ROLE | TABLE | 3 | 5 |
32. | ROLE_FUNCTION | TABLE | 9 | 3 |
33. | ST_ANSWER | TABLE | 605 | 6 |
34. | ST_COURSE | TABLE | 0 | 13 |
35. | ST_QUESTION | TABLE | 121 | 9 |
36. | ST_QUIZ | TABLE | 4 | 14 |
37. | ST_QUIZ_CATEGORY | TABLE | 69 | 12 |
38. | SURVEY_DEFINITION | TABLE | 0 | 31 |
39. | SURVEY_INSTANCE | TABLE | 0 | 17 |
40. | SURVEY_QUESTION | TABLE | 0 | 2 |
41. | TIME_ZONE | TABLE | 0 | 4 |
42. | UNIQUE_QUIZ | TABLE | 4 | 7 |
43. | USERS | TABLE | 236 | 28 |
44. | USERS_CLASS | TABLE | 5,900 | 3 |
45. | USERS_POOLS | TABLE | 0 | 3 |
46. | USER_ACTION_LOG | TABLE | 0 | 5 |
47. | USER_COURSE | TABLE | 13,924 | 3 |
48. | USER_PREFERENCES | TABLE | 0 | 15 |
49. | USER_QUIZ | TABLE | 0 | 3 |
50. | USER_ROLE | TABLE | 236 | 3 |
51. | V_CLASS_COURSE | VIEW | N/A | 30 |
52. | V_CODES | VIEW | N/A | 6 |
53. | V_COURSES | VIEW | N/A | 16 |
54. | V_COURSES_SUM | VIEW | N/A | 18 |
55. | V_DOCUMENT | VIEW | N/A | 11 |
56. | V_POOLS_SUM | VIEW | N/A | 10 |
57. | V_POOL_QUESTION_INFO | VIEW | N/A | 3 |
58. | V_POOL_QUESTION_SUM | VIEW | N/A | 3 |
59. | V_QUESTIONS_IN_POOLS | VIEW | N/A | 8 |
60. | V_QUIZ | VIEW | N/A | 36 |
61. | V_QUIZ_CATEGORIES | VIEW | N/A | 9 |
62. | V_QUIZ_CATEGORIES_SUM | VIEW | N/A | 11 |
63. | V_QUIZ_CATEGORIES_SUM2 | VIEW | N/A | 11 |
64. | V_QUIZ_RESULT | VIEW | N/A | 37 |
65. | V_QUIZ_RESULT_SUM | VIEW | N/A | 5 |
66. | V_ROLES_PERMISSIONS | VIEW | N/A | 10 |
67. | V_ST_QUIZ | VIEW | N/A | 27 |
68. | V_SUBCAT_AND_COURSES_SUM | VIEW | N/A | 2 |
69. | V_USER_ACTIONS | VIEW | N/A | 4 |
70. | V_USER_CLASS | VIEW | N/A | 19 |
71. | V_USER_CLASS_COURSE | VIEW | N/A | 28 |
72. | V_USER_COURSE | VIEW | N/A | 25 |
73. | V_USER_COURSE_ROLE | VIEW | N/A | 5 |
74. | V_USER_COURSE_TREE | VIEW | N/A | 27 |
75. | V_USER_POOLS | VIEW | N/A | 16 |
76. | V_USER_POOLS_TREE | VIEW | N/A | 19 |
77. | V_USER_POOL_SUM_QUESTIONS | VIEW | N/A | 8 |
78. | V_USER_ROLES | VIEW | N/A | 13 |
79. | V_USER_ROLES_PERMISSIONS | VIEW | N/A | 18 |
Detailed Table Information
# | 1 |
Table Name | ADDRESS |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | ADDRESS WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | ADDRESS_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
ADDRESS ID | |
2. | USER_ID | NUMBER[10] | NO | N/A | N/A |
|
USER ID | ||
3. | STREET | VARCHAR2[100] | NO | N/A | N/A |
|
STREET | ||
4. | ADDITIONAL_ADDRESS_INFORMATION | VARCHAR2[200] | YES | N/A | N/A |
|
ADDITIONAL ADDRESS INFORMATION | ||
5. | BUILDING_NUMBER | VARCHAR2[10] | YES | N/A | N/A |
|
BUILDING NUMBER | ||
6. | 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) | ||
7. | CITY | VARCHAR2[50] | NO | N/A | N/A |
|
CITY | ||
8. | 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 | ||
9. | STATE | VARCHAR2[50] | YES | N/A | N/A |
|
STATE | ||
10. | COUNTRY | VARCHAR2[50] | NO | N/A | N/A |
|
COUNTRY | ||
11. | ADDRESS_URL | VARCHAR2[1000] | YES | N/A | N/A |
|
URL of the Address. For example, GOOGLE mal URL. | ||
12. | ADDRESS_TYPE | CHAR[1] | NO | N/A | N/A |
|
P - Personal (Home) B - Business (Office) | ||
13. | SHIPPING_ADDRESS_IND | CHAR[1] | YES | N/A | N/A |
|
Indicated if this is a shipping address. | ||
14. | BILLING_ADDRESS_IND | CHAR[1] | YES | N/A | N/A |
|
Indicates if this is a Billing address | ||
15. | SHIPP_BILL_ADR_SAME_IND | CHAR[1] | YES | N/A | N/A |
|
Indicates if shipping and billing addresses are the same | ||
16. | ACTIVE_FROM | DATE[7] | NO | N/A | N/A |
|
ACTIVE FROM | ||
17. | ACTIVE_TO | DATE[7] | YES | N/A | N/A |
|
In this value is NULL then this recor represents the current address | ||
18. | ADDRESS_STATUS | VARCHAR2[3] | YES | N/A | N/A |
|
Status of this address | ||
19. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
20. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
21. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
22. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 2 |
Table Name | ANSWER |
Owner | YTM11 |
Type | TABLE |
Row Count | 605 |
Remarks | ANSWER |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | ANSWER_ID | NUMBER[10] | 1 | NO | YES | 605 (100.00%) |
|
ANSWER ID | |||||||||||||||||||||||||||||||||
2. | QUESTION_ID | NUMBER[10] | NO | NO | 121 (20.00%) |
|
QUESTION ID | ||||||||||||||||||||||||||||||||||
3. | 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. | ||||||||||||||||||||||||||||||||||
4. | ANSWER_ORDINAL_NUMBER | NUMBER[0] | YES | NO | 5 (0.83%) |
|
Determines the order in which question will appear in the list under the question. | ||||||||||||||||||||||||||||||||||
5. | CORRECT_ANSWER_IND | CHAR[1] | YES | NO | 2 (0.33%) |
|
Indicates if this is the correct answer. | ||||||||||||||||||||||||||||||||||
6. | 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. | ||||||||||||||||||||||||||||||||||
7. | 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. |
||||||||||||||||||||||||||||||||||
8. | CREATE_DATETIME | DATE[7] | NO | NO | 5 (0.83%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
9. | 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. |
||||||||||||||||||||||||||||||||||
10. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (0.17%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 3 |
Table Name | CLASS |
Owner | YTM11 |
Type | TABLE |
Row Count | 25 |
Remarks | Describes a class of users (usually Students). |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | CLASS_ID | NUMBER[10] | 1 | NO | YES | 25 (100.00%) |
|
CLASS_ID | |||||||||||||||||||||||||||||||||
2. | CLASS_NAME | VARCHAR2[200] | NO | YES | 25 (100.00%) |
|
CLASS_NAME | ||||||||||||||||||||||||||||||||||
3. | CLASS_CODE | VARCHAR2[30] | YES | NO | 1 (4.00%) |
|
CLASS_CODE SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
4. | 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. |
||||||||||||||||||||||||||||||||||
5. | ACTIVE_FROM | DATE[7] | YES | NO | 5 (20.00%) |
|
Witch column "ACTIVE_TO" describes the period when this Student Class is active. For example it could be specifict school year. | ||||||||||||||||||||||||||||||||||
6. | ACTIVE_TO | DATE[7] | YES | YES | 25 (100.00%) |
|
With column "ACTIVE_FROM" describes the period when this Student Class is active. For example it could be specifict school year. | ||||||||||||||||||||||||||||||||||
7. | 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. |
||||||||||||||||||||||||||||||||||
8. | 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. |
||||||||||||||||||||||||||||||||||
9. | CREATE_DATETIME | DATE[7] | NO | NO | 2 (8.00%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
10. | 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. |
||||||||||||||||||||||||||||||||||
11. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (4.00%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 4 |
Table Name | CLASS_COURSE |
Owner | YTM11 |
Type | TABLE |
Row Count | 93 |
Remarks | Describes which classes of users are assigned to what Courses. User can be enrolled to the Course only through the Class |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | CLASS_ID | NUMBER[10] | 1 | NO | NO | 3 (3.23%) |
|
CLASS_ID | |||||||||||||||||||||||||||||||||
2. | COURSE_ID | NUMBER[10] | 2 | NO | NO | 31 (33.33%) |
|
COURSE_ID | |||||||||||||||||||||||||||||||||
3. | 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. |
||||||||||||||||||||||||||||||||||
4. | CREATE_DATETIME | DATE[7] | NO | NO | 2 (2.15%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
5. | 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. |
||||||||||||||||||||||||||||||||||
6. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (1.08%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 5 |
Table Name | CODE |
Owner | YTM11 |
Type | TABLE |
Row Count | 71 |
Remarks | CODE |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | CODE_ID | VARCHAR2[3] | 1 | NO | YES | 71 (100.00%) |
|
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?") | |||||||||||||||||||||||||||||||||
2. | CODE_TYPE_ID | VARCHAR2[3] | NO | NO | 23 (32.39%) |
|
CODE TYPE ID | ||||||||||||||||||||||||||||||||||
3. | CODE_NAME | VARCHAR2[50] | NO | NO | 60 (84.51%) |
|
CODE NAME | ||||||||||||||||||||||||||||||||||
4. | CODE_DESCRIPTION | VARCHAR2[200] | NO | NO | 65 (91.55%) |
|
CODE DESCRIPTION | ||||||||||||||||||||||||||||||||||
5. | 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. |
||||||||||||||||||||||||||||||||||
6. | 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. |
# | 6 |
Table Name | CODE_TYPE |
Owner | YTM11 |
Type | TABLE |
Row Count | 24 |
Remarks | CODE TYPE |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | CODE_TYPE_ID | VARCHAR2[3] | 1 | NO | YES | 24 (100.00%) |
|
CODE TYPE ID | |||||||||||||||||||||||||||||||||
2. | CODE_TYPE_NAME | VARCHAR2[50] | NO | YES | 24 (100.00%) |
|
CODE TYPE NAME | ||||||||||||||||||||||||||||||||||
3. | CODE_TYPE_DESCRIPTION | VARCHAR2[200] | NO | YES | 24 (100.00%) |
|
CODE TYPE DESCRIPTION | ||||||||||||||||||||||||||||||||||
4. | 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. |
# | 7 |
Table Name | COURSE |
Owner | YTM11 |
Type | TABLE |
Row Count | 65 |
Remarks | School Courses |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | COURSE_ID | NUMBER[10] | 1 | NO | YES | 65 (100.00%) |
|
COURSE_ID | |||||||||||||||||||||||||||||||||
2. | PARENT_COURSE_ID | NUMBER[10] | YES | NO | 16 (24.62%) |
|
Course may have a parent course. This is made for flexibility, it may not be used very frequently. | ||||||||||||||||||||||||||||||||||
3. | COURSE_NAME | VARCHAR2[300] | NO | YES | 65 (100.00%) |
|
COURSE_NAME | ||||||||||||||||||||||||||||||||||
4. | COURSE_CODE | VARCHAR2[30] | YES | NO | 51 (78.46%) |
|
Code may have a code used by the school. | ||||||||||||||||||||||||||||||||||
5. | COURSE_STATUS | VARCHAR2[3] | YES | NO | 1 (1.54%) |
|
COURSE_STATUS SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
6. | 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. | ||||||||||||||||||||||||||||||||||
7. | COURSE_DESCRIPTION | VARCHAR2[2000] | NO | YES | N/A |
|
COURSE_DESCRIPTION | ||||||||||||||||||||||||||||||||||
8. | 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. |
||||||||||||||||||||||||||||||||||
9. | 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. |
||||||||||||||||||||||||||||||||||
10. | DEPARTMENT_ID | VARCHAR2[3] | YES | NO | 1 (1.54%) |
|
DEPARTMENT_ID SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
11. | SEMESTER | NUMBER[0] | YES | NO | 1 (1.54%) |
|
SEMESTER SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
12. | 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. |
||||||||||||||||||||||||||||||||||
13. | 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. |
||||||||||||||||||||||||||||||||||
14. | CREATE_DATETIME | DATE[7] | NO | NO | 2 (3.08%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
15. | 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. |
||||||||||||||||||||||||||||||||||
16. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (1.54%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 8 |
Table Name | DOCUMENT |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | DOCUMENT WARNING: Table is empty. WARNING: Table is orphan. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | DOCUMENT_ID | NUMBER[0] | 1 | NO | N/A | N/A |
|
DOCUMENT ID | |
2. | DOCUMENT_TITLE | VARCHAR2[400] | NO | N/A | N/A |
|
DOCUMENT TITLE | ||
3. | DOCUMENT_DESCRIPTION | VARCHAR2[2000] | NO | N/A | N/A |
|
DOCUMENT DESCRIPTION | ||
4. | DOCUMENT_BINARY_CONTENT | BLOB[4000] | YES | N/A | N/A |
|
DOCUMENT BINARY CONTENT | ||
5. | DOCUMENT_CHAR_CONTENT | CLOB[4000] | YES | N/A | N/A |
|
DOCUMENT CHAR CONTENT | ||
6. | FILE_NAME | VARCHAR2[400] | YES | N/A | N/A |
|
FILE_NAME | ||
7. | FILE_PATH | VARCHAR2[400] | YES | N/A | N/A |
|
document path to in the file system. This can be source or destination path. | ||
8. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
9. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
10. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
11. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 9 |
Table Name | EMAIL_SENT |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Records every email sent. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | EMAIL_SENT_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
EMAIL_SENT_ID | |
2. | QUIZ_EMAIL_ACTION_ID | NUMBER[10] | NO | N/A | N/A |
|
QUIZ_EMAIL ACTION_ID | ||
3. | EVENT_DATE_TIME | DATE[7] | NO | N/A | N/A |
|
EVENT_DATE_TIME | ||
4. | EMAIL_SENT_STATUS | VARCHAR2[3] | YES | N/A | N/A |
|
Email Sent Status |
# | 10 |
Table Name | EMAIL_TEMPLATE |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Template of the e-mail.
Contain the textual template of the e-mail which is used to contruct the e-mail to be sent to the user. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | EMAIL_TEMPLATE_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
EMAIL_TEMPLATE_ID | |
2. | EMAIL_TEMPLATE | BLOB[4000] | YES | N/A | N/A |
|
Email template may be in a rich text format. |
# | 11 |
Table Name | FUNCTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 14 |
Remarks | Permission to accss or execute certain functionality of the system. For example: 1. Create User 2. Delete user 3. Create Quiz 4. Reports |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | FUNCTION_CODE | VARCHAR2[3] | 1 | NO | YES | 14 (100.00%) |
|
FUNCTION CODE | |||||||||||||||||||||||||||||||||
2. | FUNCTION_NAME | VARCHAR2[50] | NO | YES | 14 (100.00%) |
|
This is the name (short description) of the system function: For example: 1. Create User 2. Delete user 3. Create Quiz 4. Reports | ||||||||||||||||||||||||||||||||||
3. | FUNCTION_DESCRIPTION | VARCHAR2[400] | YES | YES | 14 (100.00%) |
|
Description of the system function. | ||||||||||||||||||||||||||||||||||
4. | ENABLED | CHAR[1] | NO | NO | 1 (7.14%) |
|
ENABLED SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 12 |
Table Name | GRADING_SYSTEM |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Master table of the GRADING SYSTEM WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | GRADING_SYSTEM_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
Primarry Key | |
2. | GRADING_SYSTEM_NAME | VARCHAR2[50] | NO | N/A | N/A |
|
GRADING_SYSTEM_NAME | ||
3. | GRADING_SYSTEM_DESCRIPTION | VARCHAR2[1000] | NO | N/A | N/A |
|
GRADING_SYSTEM_DESCRIPTION | ||
4. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
5. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
6. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
7. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 13 |
Table Name | GRADING_SYSTEM_LABEL |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | GRADING_SYSTEM_LABEL WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | GRADING_SYSTEM_LABEL_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
Primary Key | |
2. | GRADING_SYSTEM_ID | NUMBER[10] | NO | N/A | N/A |
|
Primarry Key | ||
3. | GRADING_SYSTEM_LABEL_CODE | VARCHAR2[50] | NO | N/A | N/A |
|
GRADING_SYSTEM_LABEL_CODE | ||
4. | GRADING_SYSTEM_LABEL_NAME | VARCHAR2[50] | NO | N/A | N/A |
|
GRADING_SYSTEM_LABEL_NAME | ||
5. | PERCENT_MINIMUM | NUMBER[0] | NO | N/A | N/A |
|
PERCENT_MINIMUM | ||
6. | PERCENT_MAXIMUM | NUMBER[0] | NO | N/A | N/A |
|
PERCENT_MAXIMUM | ||
7. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
8. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
9. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
10. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 14 |
Table Name | LANGUAGE |
Owner | YTM11 |
Type | TABLE |
Row Count | 72 |
Remarks | Preferred language. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | LANGUAGE_ID | NUMBER[10] | 1 | NO | YES | 72 (100.00%) |
|
LANGUAGE ID | |||||||||||||||||||||||||||||||||
2. | LANGUAGE | VARCHAR2[100] | NO | YES | 72 (100.00%) |
|
LANGUAGE | ||||||||||||||||||||||||||||||||||
3. | LANGUAGE_CODE | CHAR[2] | YES | NO | 1 (1.39%) |
|
LANGUAGE_CODE SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 15 |
Table Name | ORGANIZATION |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | ORGANIZATION WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | ORGANIZATION_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
ORGANIZATION ID | |
2. | PARENT_ORGANIZATION_ID | NUMBER[10] | YES | N/A | N/A |
|
PARENT_ORGANIZATION_ID | ||
3. | ORGANIZATION_NAME | VARCHAR2[250] | NO | N/A | N/A |
|
ORGANIZATION NAME | ||
4. | ORGANIZATION_DESCRIPTION | NVARCHAR2[250] | YES | N/A | N/A |
|
ORGANIZATION DESCRIPTION | ||
5. | ORGANIZATION_CATEGORY_CODE | VARCHAR2[3] | YES | N/A | N/A |
|
Identifies category og organization: - Univesity - College - Community College - High School - Commercial - Manufacturing | ||
6. | ORGANIZATION_STATUS | VARCHAR2[3] | NO | N/A | N/A |
|
Status of the Organization: - Active - Inactive - Deleted | ||
7. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
8. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
9. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
10. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 16 |
Table Name | POOL |
Owner | YTM11 |
Type | TABLE |
Row Count | 70 |
Remarks | Pool of questions. Users can create their own pool of questions and use them later to make tests. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | POOL_ID | NUMBER[10] | 1 | NO | YES | 70 (100.00%) |
|
Pool of questions Primary Key | |||||||||||||||||||||||||||||||||
2. | PARENT_POOL_ID | NUMBER[10] | YES | NO | 13 (18.57%) |
|
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. | ||||||||||||||||||||||||||||||||||
3. | POOL_NAME | VARCHAR2[100] | NO | YES | 70 (100.00%) |
|
POOL NAME | ||||||||||||||||||||||||||||||||||
4. | POOL_DESCRIPTION | VARCHAR2[500] | NO | YES | 70 (100.00%) |
|
POOL_DESCRIPTION | ||||||||||||||||||||||||||||||||||
5. | 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. |
||||||||||||||||||||||||||||||||||
6. | CREATE_DATETIME | DATE[7] | NO | NO | 2 (2.86%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
7. | 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. |
||||||||||||||||||||||||||||||||||
8. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (1.43%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 17 |
Table Name | POOL_QUESTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | POOL QUESTION WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUESTION_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
QUESTION ID | |
2. | POOL_ID | NUMBER[10] | 2 | NO | N/A | N/A |
|
Pool of questions Primary Key |
# | 18 |
Table Name | QUESTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 121 |
Remarks | Default duration. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | QUESTION_ID | NUMBER[10] | 1 | NO | YES | 121 (100.00%) |
|
QUESTION ID | |||||||||||||||||||||||||||||||||
2. | QUESTION_TEXT | NVARCHAR2[2000] | NO | YES | N/A |
|
QUESTION TEXT | ||||||||||||||||||||||||||||||||||
3. | 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 | ||||||||||||||||||||||||||||||||||
4. | PICTURE | BLOB[4000] | YES | YES | N/A |
|
This is picture that is displayed with question. | ||||||||||||||||||||||||||||||||||
5. | 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. |
||||||||||||||||||||||||||||||||||
6. | 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. |
||||||||||||||||||||||||||||||||||
7. | 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. |
||||||||||||||||||||||||||||||||||
8. | EXCEL_QUESTION_ID | NUMBER[10] | YES | NO | 31 (25.62%) |
|
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. | ||||||||||||||||||||||||||||||||||
9. | 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. |
||||||||||||||||||||||||||||||||||
10. | 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. |
||||||||||||||||||||||||||||||||||
11. | 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. |
||||||||||||||||||||||||||||||||||
12. | 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. |
||||||||||||||||||||||||||||||||||
13. | 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. |
||||||||||||||||||||||||||||||||||
14. | 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. |
||||||||||||||||||||||||||||||||||
15. | 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. |
||||||||||||||||||||||||||||||||||
16. | CREATE_DATETIME | DATE[7] | NO | NO | 5 (4.13%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
17. | 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. |
||||||||||||||||||||||||||||||||||
18. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (0.83%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 19 |
Table Name | QUIZ_CATEGORY |
Owner | YTM11 |
Type | TABLE |
Row Count | 69 |
Remarks | Quiz Category. Quiz category structure. For example: 1. Science 1.1. Astronomy 1.2. Physics 1.2.1. Nuclear Physics 1.2.2. Quantum Physics 1.3 Medicine 2. Sports 2.1. Olympics 2.2. Soccer 2.2.1. European Soccer 2.2.2. South American Soccer 2.2.3. North American Soccer 2.3 NBA 3. History |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | QUIZ_CATEGORY_ID | NUMBER[10] | 1 | NO | YES | 69 (100.00%) |
|
QUIZ_CATEGORY_ID | |||||||||||||||||||||||||||||||||
2. | PARENT_QUIZ_CATEGORY_ID | NUMBER[10] | YES | NO | 22 (31.88%) |
|
PARENT_QUIZ CATEGORY ID | ||||||||||||||||||||||||||||||||||
3. | CATEGORY_NAME | VARCHAR2[50] | NO | NO | 62 (89.86%) |
|
CATEGORY_NAME | ||||||||||||||||||||||||||||||||||
4. | QUIZ_CATEGORY_DESCRIPTION | VARCHAR2[1000] | YES | NO | 62 (89.86%) |
|
QUIZ_CATEGORY_DESCRIPTION | ||||||||||||||||||||||||||||||||||
5. | CATEGORY_LEVEL | NUMBER[0] | NO | NO | 5 (7.25%) |
|
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. | ||||||||||||||||||||||||||||||||||
6. | 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. |
||||||||||||||||||||||||||||||||||
7. | CREATE_DATETIME | DATE[7] | NO | NO | 2 (2.90%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
8. | 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. |
||||||||||||||||||||||||||||||||||
9. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (1.45%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 20 |
Table Name | QUIZ_DEFINITION |
Owner | YTM11 |
Type | TABLE |
Row Count | 4 |
Remarks | Quiz Definition Table. This is the blue print of the Quiz. Quiz definition can be: 1. Created Manually 2. Generated by Quiz Generator (in that case it has to have a parent record in table GENERATOR) QUIZ_DEFINITION nema vezu sa QUESTIONS nego samo UNIQUE_TESTS imaju vezu sa QUESTIONS. Svrha tabele UNIQUE_TEST je samo da bi sadrzala razlicita pitanja – sve ostalo je isto |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||
1. | QUIZ_DEFINITION_ID | NUMBER[10] | 1 | NO | YES | 4 (100.00%) |
|
QUIZ_DEFINITION_ID | |||||||||||||||
2. | GRADING_SYSTEM_ID | NUMBER[10] | YES | NO | 1 (25.00%) |
|
Primarry Key | ||||||||||||||||
3. | QUIZ_CATEGORY_ID | NUMBER[10] | YES | NO | 1 (25.00%) |
|
QUIZ_CATEGORY_ID | ||||||||||||||||
4. | QUIZ_TEMPLATE_ID | NUMBER[10] | YES | NO | 1 (25.00%) |
|
QUIZ_TEMPLATE_ID | ||||||||||||||||
5. | QUIZ_NAME | NVARCHAR2[100] | NO | YES | 4 (100.00%) |
|
Name (Title) of this test. | ||||||||||||||||
6. | QUIZ_DESCRIPTION | VARCHAR2[1000] | YES | NO | 1 (25.00%) |
|
Quiz Long Decsription | ||||||||||||||||
7. | 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. | ||||||||||||||||
8. | USERS_COMMENT | NVARCHAR2[2000] | YES | YES | N/A |
|
USERS COMMENT | ||||||||||||||||
9. | QUIZ_DEFINITION_STATUS | VARCHAR2[3] | NO | NO | 1 (25.00%) |
|
Examples: - Active - Inactive - Under Construction | ||||||||||||||||
10. | NUM_OF_UNIQUE_TESTS | NUMBER[10] | NO | NO | 1 (25.00%) |
|
Has to be minimum of 1. | ||||||||||||||||
11. | POINTS_EASY | NUMBER[10] | NO | NO | 1 (25.00%) |
|
POINTS_EASY | ||||||||||||||||
12. | POINTS_MEDIUM | NUMBER[10] | NO | NO | 1 (25.00%) |
|
POINTS_MEDIUM | ||||||||||||||||
13. | POINTS_HARD | NUMBER[10] | NO | NO | 1 (25.00%) |
|
POINTS_HARD | ||||||||||||||||
14. | DURATION_EASY | NUMBER[0] | YES | NO | 1 (25.00%) |
|
DURATION_EASY | ||||||||||||||||
15. | DURATION_MEDIUM | NUMBER[0] | YES | NO | 1 (25.00%) |
|
DURATION_MEDIUM | ||||||||||||||||
16. | DURATION_HARD | NUMBER[0] | YES | NO | 1 (25.00%) |
|
DURATION_HARD | ||||||||||||||||
17. | 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. | ||||||||||||||||
18. | DEFAULT_ENABLED_FROM | DATE[7] | YES | NO | 1 (25.00%) |
|
DEFAULT ENABLED FROM | ||||||||||||||||
19. | DEFAULT_ENABLED_TO | DATE[7] | YES | NO | 1 (25.00%) |
|
DEFAULT ENABLED TO | ||||||||||||||||
20. | DISPLAY_ANSWER_IND | CHAR[1] | YES | NO | 1 (25.00%) |
|
Determines if the correct answer is displayed after every question is answered. | ||||||||||||||||
21. | DISPLAY_CORRECT_IND | CHAR[1] | YES | NO | 1 (25.00%) |
|
Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered. | ||||||||||||||||
22. | CREATE_TYPE | VARCHAR2[3] | YES | NO | 1 (25.00%) |
|
GEN (Generated), MAN (Manual) | ||||||||||||||||
23. | 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) | ||||||||||||||||
24. | LOOK_TYPE | VARCHAR2[3] | YES | NO | 1 (25.00%) |
|
AOP (All questions on page), OPP (One question per page) | ||||||||||||||||
25. | DURATION_TYPE | VARCHAR2[3] | YES | NO | 1 (25.00%) |
|
UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz) | ||||||||||||||||
26. | 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. | ||||||||||||||||
27. | 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. | ||||||||||||||||
28. | 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. | ||||||||||||||||
29. | 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) | ||||||||||||||||
30. | CREATE_USER_ID | NUMBER[10] | NO | NO | 1 (25.00%) |
|
CREATE USER ID | ||||||||||||||||
31. | CREATE_DATETIME | DATE[7] | NO | YES | 4 (100.00%) |
|
CREATE DATETIME | ||||||||||||||||
32. | UPDATE_USER_ID | NUMBER[10] | YES | NO | 1 (25.00%) |
|
UPDATE USER ID | ||||||||||||||||
33. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (25.00%) |
|
UPDATE DATETIME |
# | 21 |
Table Name | QUIZ_DEFINITION_POOL |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Associative table.
Identifies Pools of Questions that will participare in generating new Quizzes. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | POOL_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
Pool of questions Primary Key | |
2. | QUIZ_DEFINITION_ID | NUMBER[10] | 2 | NO | N/A | N/A |
|
QUIZ_DEFINITION_ID | |
3. | NUM_OF_HARD_QUESTIONS | NUMBER[10] | NO | N/A | N/A |
|
NUM_OF_HARD_QUESTIONS | ||
4. | NUM_OF_MEDIUM_QUESTIONS | NUMBER[10] | NO | N/A | N/A |
|
NUM_OF_MEDIUM_QUESTIONS | ||
5. | NUM_OF_EASY_QUESTIONS | NUMBER[10] | NO | N/A | N/A |
|
NUM_OF_EASY_QUESTIONS | ||
6. | CUT_OFF_DATE | NUMBER[10] | NO | N/A | N/A |
|
CUT_OFF_DATE |
# | 22 |
Table Name | QUIZ_EMAIL_ACTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Email is sent to certain recipients (User_id) when Quiz Instance changes the Status.
Foe example:
- student can receive e-mail from the system when quiz is assigned to him/her
- professor may receive e-mail from the system when studen compoletes the quiz WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_EMAIL_ACTION_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
QUIZ_EMAIL ACTION_ID | |
2. | QUIZ_INSTANCE_ID | NUMBER[10] | NO | N/A | N/A |
|
QUIZ_INSTANCE_ID | ||
3. | EMAIL_TEMPLATE_ID | NUMBER[10] | NO | N/A | N/A |
|
Specifies the template to be used to contruct the e-mail. | ||
4. | USER_ID | NUMBER[10] | NO | N/A | N/A |
|
USER ID | ||
5. | QUIZ_INSTANCE_STATUS | VARCHAR2[3] | NO | N/A | N/A |
|
e-Mail is sent when the Quiz Instance changes status to this value. |
# | 23 |
Table Name | QUIZ_INSTANCE |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Occurance of the particular Quiz.
Whenever somebody takes a test a record is created in this table. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_INSTANCE_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
QUIZ_INSTANCE_ID | |
2. | UNIQUE_QUIZ_ID | NUMBER[10] | NO | N/A | N/A |
|
UNIQUE_QUIZ_ID | ||
3. | USER_ID_TESTED | NUMBER[10] | NO | N/A | N/A |
|
USER ID TESTED | ||
4. | 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. | ||
5. | 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. | ||
6. | DURATION | NUMBER[10] | YES | N/A | N/A |
|
DURATION | ||
7. | ENABLED_FROM | DATE[7] | YES | N/A | N/A |
|
ENABLED FROM | ||
8. | ENABLED_TO | DATE[7] | YES | N/A | N/A |
|
ENABLED TO | ||
9. | 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. | ||
10. | QUIZ_FINISHED | DATE[7] | YES | N/A | N/A |
|
QUIZ FINISHED | ||
11. | 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 | ||
12. | 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 | ||
13. | 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. | ||
14. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
15. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
16. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
17. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 24 |
Table Name | QUIZ_QUESTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 121 |
Remarks | Associative table. All User's questions will become available to be associated with other tests so that is why we have this associative table. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | UNIQUE_QUIZ_ID | NUMBER[10] | 2 | NO | NO | 4 (3.31%) |
|
UNIQUE_QUIZ_ID | |||||||||||||||||||||||||||||||||
2. | QUESTION_ID | NUMBER[10] | 1 | NO | YES | 121 (100.00%) |
|
QUESTION ID | |||||||||||||||||||||||||||||||||
3. | QUESTION_ORDINAL_NUMBER | NUMBER[10] | YES | NO | 31 (25.62%) |
|
This is the number that determines order of the question in test. Lower numbers are displayed first in the test. | ||||||||||||||||||||||||||||||||||
4. | STATUS | VARCHAR2[3] | NO | NO | 1 (0.83%) |
|
STATUS SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
5. | 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. |
||||||||||||||||||||||||||||||||||
6. | 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. |
# | 25 |
Table Name | QUIZ_RESULT |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Every record in this table represents the
answer on particular question of the certain Quiz Occurence.
In case that user has to key in the answer in free form text - column
"ANSWER_TEXT" will have an text of the user's answer on particular
question.
In case of "Multiple Choices" Questions - options that are picked by the
user being tested are store in table "QUIZ_RESULT_ANSWER". In that case
value in column "ANSWER_TEXT" will be blank.
Record in this table does not have to be associated with any record in
table "Answer". The example is question that required free form text as
an answer.
WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_RESULT_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
QUIZ RESULT ID | |
2. | QUIZ_INSTANCE_ID | NUMBER[10] | NO | N/A | N/A |
|
QUIZ_INSTANCE_ID | ||
3. | QUESTION_ID | NUMBER[10] | NO | N/A | N/A |
|
QUESTION ID | ||
4. | 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. | ||
5. | ANSWER_CLOB | CLOB[4000] | YES | N/A | N/A |
|
This field provides capability to create textual answers of unlimited length. | ||
6. | 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. | ||
7. | 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. | ||
8. | NOT_SURE_FLAG | CHAR[1] | YES | N/A | N/A |
|
NOT SURE FLAG | ||
9. | 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. | ||
10. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
11. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
12. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
13. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 26 |
Table Name | QUIZ_RESULT_ANSWER |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Associative table with Quiz Results.
The reson why this table is required is because this is many to many relatiosnhip because:
One question can have a multiple answers - for example:
"Check all that apply" on multiple choices test.
Every test occurence has test results.
Test results consist of list of questions answered and associated answers.
There may be questions witth multiple answers. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | ANSWER_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
ANSWER ID | |
2. | QUIZ_RESULT_ID | NUMBER[10] | 2 | NO | N/A | N/A |
|
QUIZ RESULT ID | |
3. | TIME_TO_ANSWER | NUMBER[8] | YES | N/A | N/A |
|
Time that user has taken to answer the question - for stats. |
# | 27 |
Table Name | QUIZ_TEMPLATE |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | This table is used as a template for making the quiz definition.
Several quizzes definitions can be linked to one template.
It is analogy similar to CLASS and OBJECT.
QUIZ_TEMPLATE is CLASS, QUIZ_DEFINITION is OBJECT.
WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_TEMPLATE_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
QUIZ_TEMPLATE_ID | |
2. | QUIZ_CATEGORY_ID | NUMBER[10] | NO | N/A | N/A |
|
QUIZ_CATEGORY_ID | ||
3. | GRADING_SYSTEM_ID | NUMBER[10] | NO | N/A | N/A |
|
Primarry Key | ||
4. | NUM_OF_UNIQUE_TESTS | NUMBER[10] | NO | N/A | N/A |
|
Has to be minimum of 1. | ||
5. | TEMPLATE_NAME | NVARCHAR2[100] | NO | N/A | N/A |
|
Name (Title) of this template | ||
6. | TEMPLATE_DESCRIPTION | VARCHAR2[1000] | YES | N/A | N/A |
|
Quiz Long Decsription | ||
7. | TEMPLATE_STATUS | VARCHAR2[3] | NO | N/A | N/A |
|
Examples: - Active - Inactive - Under Construction | ||
8. | POINTS_EASY | NUMBER[10] | NO | N/A | N/A |
|
POINTS_EASY | ||
9. | POINTS_MEDIUM | NUMBER[10] | NO | N/A | N/A |
|
POINTS_MEDIUM | ||
10. | POINTS_HARD | NUMBER[10] | NO | N/A | N/A |
|
POINTS_HARD | ||
11. | DURATION_EASY | NUMBER[0] | YES | N/A | N/A |
|
DURATION_EASY | ||
12. | DURATION_MEDIUM | NUMBER[0] | YES | N/A | N/A |
|
DURATION_MEDIUM | ||
13. | DURATION_HARD | NUMBER[0] | YES | N/A | N/A |
|
DURATION_HARD | ||
14. | 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. | ||
15. | DISPLAY_ANSWER_IND | CHAR[1] | YES | N/A | N/A |
|
Determines if the correct answer is displayed after every question is answered. | ||
16. | DISPLAY_CORRECT_IND | CHAR[1] | YES | N/A | N/A |
|
Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered. | ||
17. | 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) | ||
18. | LOOK_TYPE | VARCHAR2[3] | YES | N/A | N/A |
|
AOP (All questions on page), OPP (One question per page) | ||
19. | DURATION_TYPE | VARCHAR2[3] | YES | N/A | N/A |
|
UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz) | ||
20. | 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. | ||
21. | 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. | ||
22. | 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. | ||
23. | 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 | ||
24. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
25. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
26. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
27. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 28 |
Table Name | QUIZ_TEMPLATE_POOL |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Associative table.
Identifies Pools of Questions that will participare in generating new Quizzes. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | POOL_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
Pool of questions Primary Key | |
2. | QUIZ_TEMPLATE_ID | NUMBER[10] | 2 | NO | N/A | N/A |
|
QUIZ_TEMPLATE_ID | |
3. | NUM_OF_HARD_QUESTIONS | NUMBER[10] | NO | N/A | N/A |
|
NUM_OF_HARD_QUESTIONS | ||
4. | NUM_OF_MEDIUM_QUESTIONS | NUMBER[10] | NO | N/A | N/A |
|
NUM_OF_MEDIUM_QUESTIONS | ||
5. | NUM_OF_EASY_QUESTIONS | NUMBER[10] | NO | N/A | N/A |
|
NUM_OF_EASY_QUESTIONS | ||
6. | CUT_OFF_DATE | NUMBER[10] | NO | N/A | N/A |
|
CUT_OFF_DATE |
# | 29 |
Table Name | REPORT_DEFINITION |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Definition of the report WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | REPORT_DEFINITION_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
REPORT_DEFINITION_ID | |
2. | REPORT_NAME | VARCHAR2[50] | NO | N/A | N/A |
|
REPORT_NAME | ||
3. | REPORT_DESCRIPTION | VARCHAR2[1000] | YES | N/A | N/A |
|
Report description with more details | ||
4. | DEFAULT_REPORT_TITLE | VARCHAR2[1000] | YES | N/A | N/A |
|
This is title that will appear in the report. | ||
5. | DEFAULT_LOCATION | VARCHAR2[1000] | YES | N/A | N/A |
|
This is the default location where report will be created in the file system | ||
6. | 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 | ||
7. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
8. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
9. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
10. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 30 |
Table Name | REPORT_INSTANCE |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | This is the particular report instance (produced report with concrete data) WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | REPORT_INSTANCE_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
REPORT_INSTANCE_ID | |
2. | REPORT_DEFINITION_ID | NUMBER[10] | NO | N/A | N/A |
|
REPORT_DEFINITION_ID | ||
3. | REPORT_LOCATION | VARCHAR2[1000] | NO | N/A | N/A |
|
Location of the report in the file system | ||
4. | 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. | ||
5. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
6. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
7. | 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 |
# | 31 |
Table Name | ROLE |
Owner | YTM11 |
Type | TABLE |
Row Count | 3 |
Remarks | Roles can be (just an example): 1. Admin 2. Professor 3. Student 4. Guest |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | ||||||||||||
1. | ROLE_CODE | VARCHAR2[3] | 1 | NO | YES | 3 (100.00%) |
|
ROLE CODE | ||||||||||||
2. | ROLE_NAME | VARCHAR2[50] | NO | YES | 3 (100.00%) |
|
ROLE NAME | |||||||||||||
3. | ROLE_DESCRIPTION | VARCHAR2[400] | YES | YES | 3 (100.00%) |
|
ROLE_DESCRIPTION | |||||||||||||
4. | GRANTABLE | CHAR[1] | YES | NO | 2 (66.67%) |
|
If 'Y' then this Role can grant Roles to other users. | |||||||||||||
5. | ENABLED | CHAR[1] | NO | NO | 1 (33.33%) |
|
ENABLED |
# | 32 |
Table Name | ROLE_FUNCTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 9 |
Remarks | Role can have multiple permissions and same permission can be granted to multiple roles. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | ||||||||||||
1. | ROLE_CODE | VARCHAR2[3] | 1 | NO | NO | 3 (33.33%) |
|
ROLE CODE | ||||||||||||
2. | FUNCTION_CODE | VARCHAR2[3] | 2 | NO | NO | 3 (33.33%) |
|
FUNCTION CODE | ||||||||||||
3. | ENABLED | CHAR[1] | NO | NO | 1 (11.11%) |
|
ENABLED SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 33 |
Table Name | ST_ANSWER |
Owner | YTM11 |
Type | TABLE |
Row Count | 605 |
Remarks | Staging table for loading Answer data from Excel file. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | ST_ANSWER_ID | NUMBER[10] | 1 | NO | YES | 605 (100.00%) |
|
ST_ANSWER_ID | |||||||||||||||||||||||||||||||||
2. | ST_QUIZ_ID | NUMBER[10] | NO | NO | 4 (0.66%) |
|
ST_QUIZ_ID | ||||||||||||||||||||||||||||||||||
3. | ARTIFICIAL_QUESTION_ID | NUMBER[10] | NO | NO | 31 (5.12%) |
|
This is number assigned by user in order to link questions with answers in excel. | ||||||||||||||||||||||||||||||||||
4. | ANSWER_TEXT | NVARCHAR2[2000] | YES | YES | N/A |
|
ANSWER_TEXT | ||||||||||||||||||||||||||||||||||
5. | ORDINAL_NUMBER | NUMBER[0] | YES | NO | 5 (0.83%) |
|
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. | ||||||||||||||||||||||||||||||||||
6. | CORRECT_ANSWER_IND | CHAR[1] | YES | NO | 2 (0.33%) |
|
Indicates if this is the correct answer. |
# | 34 |
Table Name | ST_COURSE |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Staging table that facilitates load into table COURSE.
Course category structure.
For example:
1. Science
1.1. Astronomy
1.2. Physics
1.2.1. Nuclear Physics
1.2.2. Quantum Physics
1.3 Medicine
2. Sports
2.1. Olympics
2.2. Soccer
2.2.1. European Soccer
2.2.2. South American Soccer
2.2.3. North American Soccer
2.3 NBA
3. History
WARNING: Table is empty. WARNING: Table is orphan. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | EXCEL_ROW_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
EXCEL_ROW_ID | |
2. | COURSE_CODE | VARCHAR2[50] | YES | N/A | N/A |
|
COURSE_CODE | ||
3. | CATEGORY_NAME_1 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_1 | ||
4. | CATEGORY_NAME_2 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_2 | ||
5. | CATEGORY_NAME_3 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_3 | ||
6. | CATEGORY_NAME_4 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_4 | ||
7. | CATEGORY_NAME_5 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_5 | ||
8. | CATEGORY_NAME_6 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_6 | ||
9. | CATEGORY_NAME_7 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_7 | ||
10. | CATEGORY_NAME_8 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_8 | ||
11. | CATEGORY_NAME_9 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_9 | ||
12. | CATEGORY_NAME_10 | VARCHAR2[50] | YES | N/A | N/A |
|
CATEGORY_NAME_10 | ||
13. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME |
# | 35 |
Table Name | ST_QUESTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 121 |
Remarks | Staging table for loading Question data from Excel file. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | ST_QUESTION_ID | NUMBER[10] | 1 | NO | YES | 121 (100.00%) |
|
ST_QUESTION_ID | |||||||||||||||||||||||||||||||||
2. | ARTIFICIAL_QUESTION_ID | NUMBER[10] | NO | NO | 31 (25.62%) |
|
This is number assigned by user in order to link questions with answers in excel. | ||||||||||||||||||||||||||||||||||
3. | ST_QUIZ_ID | NUMBER[10] | NO | NO | 4 (3.31%) |
|
ST_QUIZ_ID | ||||||||||||||||||||||||||||||||||
4. | QUESTION_TEXT | NVARCHAR2[2000] | NO | YES | N/A |
|
QUESTION TEXT | ||||||||||||||||||||||||||||||||||
5. | PICTURE | BLOB[4000] | YES | YES | N/A |
|
This is picture that is displayed with question. | ||||||||||||||||||||||||||||||||||
6. | 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. |
||||||||||||||||||||||||||||||||||
7. | 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. |
||||||||||||||||||||||||||||||||||
8. | 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. |
||||||||||||||||||||||||||||||||||
9. | ORDINAL_NUMBER | NUMBER[0] | YES | NO | 31 (25.62%) |
|
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. |
# | 36 |
Table Name | ST_QUIZ |
Owner | YTM11 |
Type | TABLE |
Row Count | 4 |
Remarks | Staging table for loading Quiz data from Excel file. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||
1. | ST_QUIZ_ID | NUMBER[10] | 1 | NO | YES | 4 (100.00%) |
|
ST_QUIZ_ID | |||||||||||||||
2. | USERNAME | NVARCHAR2[100] | NO | NO | 1 (25.00%) |
|
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. | ||||||||||||||||
3. | PASSWORD | CHAR[10] | YES | NO | 1 (25.00%) |
|
PASSWORD | ||||||||||||||||
4. | USER_ID | NUMBER[10] | YES | NO | 1 (25.00%) |
|
USER ID | ||||||||||||||||
5. | QUIZ_NAME | NVARCHAR2[100] | NO | YES | 4 (100.00%) |
|
Name (Title) of this test. | ||||||||||||||||
6. | 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. | ||||||||||||||||
7. | USERS_COMMENT | NVARCHAR2[2000] | YES | YES | N/A |
|
USERS COMMENT | ||||||||||||||||
8. | DEFAULT_ENABLED_FROM | DATE[7] | YES | NO | 1 (25.00%) |
|
DEFAULT ENABLED FROM | ||||||||||||||||
9. | DEFAULT_ENABLED_TO | DATE[7] | YES | NO | 1 (25.00%) |
|
DEFAULT ENABLED TO | ||||||||||||||||
10. | RESULT_TRANSPARENCY | VARCHAR2[20] | YES | NO | 1 (25.00%) |
|
RESULT TRANSPARENCY | ||||||||||||||||
11. | 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. | ||||||||||||||||
12. | 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 | ||||||||||||||||
13. | CREATE_USER_ID | NUMBER[10] | NO | NO | 1 (25.00%) |
|
CREATE USER ID | ||||||||||||||||
14. | CREATE_DATETIME | DATE[7] | NO | YES | 4 (100.00%) |
|
CREATE DATETIME |
# | 37 |
Table Name | ST_QUIZ_CATEGORY |
Owner | YTM11 |
Type | TABLE |
Row Count | 69 |
Remarks | Staging table that facilitates load into table QUIZ_CATEGORY.
Quiz category structure.
For example:
1. Science
1.1. Astronomy
1.2. Physics
1.2.1. Nuclear Physics
1.2.2. Quantum Physics
1.3 Medicine
2. Sports
2.1. Olympics
2.2. Soccer
2.2.1. European Soccer
2.2.2. South American Soccer
2.2.3. North American Soccer
2.3 NBA
3. History
WARNING: Table is orphan. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | EXCEL_ROW_ID | NUMBER[10] | 1 | NO | YES | 69 (100.00%) |
|
EXCEL_ROW_ID | |||||||||||||||||||||||||||||||||
2. | CATEGORY_NAME_1 | VARCHAR2[50] | YES | NO | 8 (11.59%) |
|
CATEGORY_NAME_1 | ||||||||||||||||||||||||||||||||||
3. | CATEGORY_NAME_2 | VARCHAR2[50] | YES | NO | 29 (42.03%) |
|
CATEGORY_NAME_2 | ||||||||||||||||||||||||||||||||||
4. | CATEGORY_NAME_3 | VARCHAR2[50] | YES | NO | 26 (37.68%) |
|
CATEGORY_NAME_3 | ||||||||||||||||||||||||||||||||||
5. | CATEGORY_NAME_4 | VARCHAR2[50] | YES | NO | 3 (4.35%) |
|
CATEGORY_NAME_4 | ||||||||||||||||||||||||||||||||||
6. | CATEGORY_NAME_5 | VARCHAR2[50] | YES | NO | 2 (2.90%) |
|
CATEGORY_NAME_5 | ||||||||||||||||||||||||||||||||||
7. | 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. |
||||||||||||||||||||||||||||||||||
8. | 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. |
||||||||||||||||||||||||||||||||||
9. | 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. |
||||||||||||||||||||||||||||||||||
10. | 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. |
||||||||||||||||||||||||||||||||||
11. | 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. |
||||||||||||||||||||||||||||||||||
12. | CREATE_DATETIME | DATE[7] | NO | NO | 4 (5.80%) |
|
CREATE DATETIME |
# | 38 |
Table Name | SURVEY_DEFINITION |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Quiz Survey Table.
This is the blue print of the Survey.
WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | SURVEY_DEFINITION_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
SURVEY_DEFINITION_ID | |
2. | GRADING_SYSTEM_ID | NUMBER[10] | YES | N/A | N/A |
|
Primarry Key | ||
3. | SURVEY_CATEGORY_ID | NUMBER[10] | YES | N/A | N/A |
|
SURVEY_CATEGORY_ID | ||
4. | SURVEY_NAME | NVARCHAR2[100] | NO | N/A | N/A |
|
Name (Title) of this test. | ||
5. | SURVEY_DESCRIPTION | VARCHAR2[1000] | YES | N/A | N/A |
|
Quiz Long Decsription | ||
6. | 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. | ||
7. | USERS_COMMENT | NVARCHAR2[2000] | YES | N/A | N/A |
|
USERS COMMENT | ||
8. | SURVEY_DEFINITION_STATUS | VARCHAR2[3] | NO | N/A | N/A |
|
Examples: - Active - Inactive - Under Construction | ||
9. | POINTS_EASY | NUMBER[10] | NO | N/A | N/A |
|
POINTS_EASY | ||
10. | POINTS_MEDIUM | NUMBER[10] | NO | N/A | N/A |
|
POINTS_MEDIUM | ||
11. | POINTS_HARD | NUMBER[10] | NO | N/A | N/A |
|
POINTS_HARD | ||
12. | DURATION_EASY | NUMBER[0] | YES | N/A | N/A |
|
DURATION_EASY | ||
13. | DURATION_MEDIUM | NUMBER[0] | YES | N/A | N/A |
|
DURATION_MEDIUM | ||
14. | DURATION_HARD | NUMBER[0] | YES | N/A | N/A |
|
DURATION_HARD | ||
15. | 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. | ||
16. | DEFAULT_ENABLED_FROM | DATE[7] | YES | N/A | N/A |
|
DEFAULT ENABLED FROM | ||
17. | DEFAULT_ENABLED_TO | DATE[7] | YES | N/A | N/A |
|
DEFAULT ENABLED TO | ||
18. | DISPLAY_ANSWER_IND | CHAR[1] | YES | N/A | N/A |
|
Determines if the correct answer is displayed after every question is answered. | ||
19. | DISPLAY_CORRECT_IND | CHAR[1] | YES | N/A | N/A |
|
Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered. | ||
20. | CREATE_TYPE | VARCHAR2[3] | YES | N/A | N/A |
|
GEN (Generated), MAN (Manual) | ||
21. | 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) | ||
22. | LOOK_TYPE | VARCHAR2[3] | YES | N/A | N/A |
|
AOP (All questions on page), OPP (One question per page) | ||
23. | DURATION_TYPE | VARCHAR2[3] | YES | N/A | N/A |
|
UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz) | ||
24. | 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. | ||
25. | 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. | ||
26. | 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. | ||
27. | 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) | ||
28. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
29. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
30. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
31. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 39 |
Table Name | SURVEY_INSTANCE |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Occurance of the particular Survey.
Whenever somebody takes a test a record is created in this table. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | SURVEY_INSTANCE_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
SURVEY_INSTANCE_ID | |
2. | SURVEY_DEFINITION_ID | NUMBER[10] | NO | N/A | N/A |
|
SURVEY_DEFINITION_ID | ||
3. | USER_ID_TESTED | NUMBER[10] | NO | N/A | N/A |
|
USER ID TESTED | ||
4. | 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. | ||
5. | 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. | ||
6. | DURATION | NUMBER[10] | YES | N/A | N/A |
|
DURATION | ||
7. | ENABLED_FROM | DATE[7] | YES | N/A | N/A |
|
ENABLED FROM | ||
8. | ENABLED_TO | DATE[7] | YES | N/A | N/A |
|
ENABLED TO | ||
9. | 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. | ||
10. | QUIZ_FINISHED | DATE[7] | YES | N/A | N/A |
|
QUIZ FINISHED | ||
11. | 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 | ||
12. | 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 | ||
13. | 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. | ||
14. | CREATE_USER_ID | NUMBER[10] | NO | N/A | N/A |
|
CREATE USER ID | ||
15. | CREATE_DATETIME | DATE[7] | NO | N/A | N/A |
|
CREATE DATETIME | ||
16. | UPDATE_USER_ID | NUMBER[10] | YES | N/A | N/A |
|
UPDATE USER ID | ||
17. | UPDATE_DATETIME | DATE[7] | YES | N/A | N/A |
|
UPDATE DATETIME |
# | 40 |
Table Name | SURVEY_QUESTION |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | SURVEY_QUESTION WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUESTION_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
QUESTION ID | |
2. | SURVEY_INSTANCE_ID | NUMBER[10] | 2 | NO | N/A | N/A |
|
SURVEY_INSTANCE_ID |
# | 41 |
Table Name | TIME_ZONE |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | TIME_ZONE WARNING: Table is empty. WARNING: Table is orphan. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | TIME_ZONE_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
TIME_ZONE_ID | |
2. | TIME_ZONE | NUMBER[0] | NO | N/A | N/A |
|
This is actualy difference from ZULU time (GMT). | ||
3. | TIME_ZONE_CODE | VARCHAR2[10] | YES | N/A | N/A |
|
For Example: "EST" "PST" etc. | ||
4. | TIME_ZONE_NAME | VARCHAR2[100] | YES | N/A | N/A |
|
For example: "Eastern Standard Time" |
# | 42 |
Table Name | UNIQUE_QUIZ |
Owner | YTM11 |
Type | TABLE |
Row Count | 4 |
Remarks | Table that we use for connecting unique tests to generated sets of questions. If quiz is manualy created then we have only one unique test. QUIZ_DEFINITION nema vezu sa QUESTIONS nego samo UNIQUE_TESTS imaju vezu sa QUESTIONS. Svrha tabele UNIQUE_TEST je samo da bi sadrzala razlicita pitanja – sve ostalo je isto The purpose of this normalization is to have parent Quiz Definition which for many unique etsts given to the same group of peolple. This structure is also required for reporting. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||
1. | UNIQUE_QUIZ_ID | NUMBER[10] | 1 | NO | YES | 4 (100.00%) |
|
UNIQUE_QUIZ_ID | |||||||||||||||
2. | QUIZ_DEFINITION_ID | NUMBER[10] | NO | YES | 4 (100.00%) |
|
QUIZ_DEFINITION_ID | ||||||||||||||||
3. | UNIQUE_QUIZ_NAME | NVARCHAR2[100] | NO | YES | 4 (100.00%) |
|
Name (Title) of this test. | ||||||||||||||||
4. | CREATE_USER_ID | NUMBER[10] | NO | NO | 1 (25.00%) |
|
CREATE USER ID | ||||||||||||||||
5. | CREATE_DATETIME | DATE[7] | NO | YES | 4 (100.00%) |
|
CREATE DATETIME | ||||||||||||||||
6. | UPDATE_USER_ID | NUMBER[10] | YES | NO | 1 (25.00%) |
|
UPDATE USER ID | ||||||||||||||||
7. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (25.00%) |
|
UPDATE DATETIME |
# | 43 |
Table Name | USERS |
Owner | YTM11 |
Type | TABLE |
Row Count | 236 |
Remarks | System users: - Testers - People being tested - Administrators |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | USER_ID | NUMBER[10] | 1 | NO | YES | 236 (100.00%) |
|
USER ID | |||||||||||||||||||||||||||||||||
2. | USERNAME | NVARCHAR2[100] | NO | YES | 236 (100.00%) |
|
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. | ||||||||||||||||||||||||||||||||||
3. | 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. | ||||||||||||||||||||||||||||||||||
4. | ORGANIZATION_ID | NUMBER[10] | YES | NO | 1 (0.42%) |
|
ORGANIZATION ID SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
5. | PASSWORD | VARCHAR2[50] | NO | YES | 236 (100.00%) |
|
PASSWORD | ||||||||||||||||||||||||||||||||||
6. | 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. |
||||||||||||||||||||||||||||||||||
7. | 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. |
||||||||||||||||||||||||||||||||||
8. | FIRST_NAME | VARCHAR2[50] | NO | NO | 149 (63.14%) |
|
FIRST NAME | ||||||||||||||||||||||||||||||||||
9. | LAST_NAME | VARCHAR2[50] | NO | NO | 154 (65.25%) |
|
LAST NAME | ||||||||||||||||||||||||||||||||||
10. | GENDER_CODE | VARCHAR2[3] | YES | NO | 1 (0.42%) |
|
GENDER_CODE SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
11. | DATE_OF_BIRTH | DATE[7] | YES | NO | 4 (1.69%) |
|
DATE_OF_BIRTH | ||||||||||||||||||||||||||||||||||
12. | 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. |
||||||||||||||||||||||||||||||||||
13. | 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. |
||||||||||||||||||||||||||||||||||
14. | LAST_LOGON | DATE[7] | YES | NO | 1 (0.42%) |
|
LAST LOGON SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
15. | 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. |
||||||||||||||||||||||||||||||||||
16. | 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. |
||||||||||||||||||||||||||||||||||
17. | NVARCHAR2[100] | YES | NO | 234 (99.15%) |
|
||||||||||||||||||||||||||||||||||||
18. | EMAIL2 | NVARCHAR2[100] | YES | NO | 234 (99.15%) |
|
EMAIL2 | ||||||||||||||||||||||||||||||||||
19. | DAYTIME_PHONE | VARCHAR2[50] | YES | NO | 1 (0.42%) |
|
DAYTIME PHONE SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
20. | EVENING_PHONE | VARCHAR2[50] | YES | NO | 1 (0.42%) |
|
EVENING PHONE SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
21. | USER_TYPE | VARCHAR2[3] | YES | NO | 3 (1.27%) |
|
This field is currently not used. | ||||||||||||||||||||||||||||||||||
22. | USER_STATUS | VARCHAR2[3] | YES | NO | 1 (0.42%) |
|
USER_STATUS SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
||||||||||||||||||||||||||||||||||
23. | TIME_ZONE | NUMBER[10] | YES | NO | 17 (7.20%) |
|
TIME ZONE | ||||||||||||||||||||||||||||||||||
24. | COMMENTS | VARCHAR2[2000] | YES | YES | N/A |
|
Comments associated to this user | ||||||||||||||||||||||||||||||||||
25. | 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. |
||||||||||||||||||||||||||||||||||
26. | CREATE_DATETIME | DATE[7] | NO | NO | 4 (1.69%) |
|
CREATE DATETIME | ||||||||||||||||||||||||||||||||||
27. | 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. |
||||||||||||||||||||||||||||||||||
28. | UPDATE_DATETIME | DATE[7] | YES | NO | 1 (0.42%) |
|
UPDATE DATETIME SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 44 |
Table Name | USERS_CLASS |
Owner | YTM11 |
Type | TABLE |
Row Count | 5,900 |
Remarks | User can belong to many classes. Many users can be in the same class. Class may have many administrators. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | USER_ID | NUMBER[10] | 1 | NO | NO | 236 (4.00%) |
|
USER ID | |||||||||||||||||||||||||||||||||
2. | CLASS_ID | NUMBER[10] | 2 | NO | NO | 25 (0.42%) |
|
CLASS_ID | |||||||||||||||||||||||||||||||||
3. | USER_CLASS_ROLE | VARCHAR2[3] | YES | NO | 1 (0.02%) |
|
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. |
# | 45 |
Table Name | USERS_POOLS |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | Associative Table WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | POOL_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
Pool of questions Primary Key | |
2. | USER_ID | NUMBER[10] | 2 | NO | N/A | N/A |
|
USER ID | |
3. | 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. |
# | 46 |
Table Name | USER_ACTION_LOG |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | This table will have a purp[ose to track user activity.
It will be used to produce reports about the system load.
Whenever user logs in new record will be inserted in this table.
Some more statistical information could be captured here. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ACTION_LOG_ID | NUMBER[0] | 1 | NO | N/A | N/A |
|
USER ACTION LOG ID | |
2. | USER_ID | NUMBER[10] | NO | N/A | N/A |
|
USER ID | ||
3. | ACTION_CODE | VARCHAR2[10] | NO | N/A | N/A |
|
ACTION CODE | ||
4. | COMMENTS | VARCHAR2[1000] | YES | N/A | N/A |
|
COMMENTS | ||
5. | CREATE_DATETIME | TIMESTAMP(6)[11,6] | NO | N/A | N/A |
|
CREATE DATETIME |
# | 47 |
Table Name | USER_COURSE |
Owner | YTM11 |
Type | TABLE |
Row Count | 13,924 |
Remarks | THis table describes the role of the user in certain Course. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | USER_ID | NUMBER[10] | 1 | NO | NO | 236 (1.69%) |
|
USER ID | |||||||||||||||||||||||||||||||||
2. | COURSE_ID | NUMBER[10] | 2 | NO | NO | 59 (0.42%) |
|
COURSE_ID | |||||||||||||||||||||||||||||||||
3. | USER_COURSE_ROLE | VARCHAR2[3] | YES | NO | 1 (0.01%) |
|
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. |
# | 48 |
Table Name | USER_PREFERENCES |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | User preferences.
User can have more than one profile that define look and feel of his quizzes.
If dos not have it, theen default preferences are used. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_PREFERENCES_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
USER PREFERENCES ID | |
2. | USER_ID | NUMBER[10] | NO | N/A | N/A |
|
USER ID | ||
3. | USER_PREFERENCES_NAME | VARCHAR2[50] | YES | N/A | N/A |
|
USER_PREFERENCES_NAME | ||
4. | MAX_RECORDS_RETURNED | NUMBER[10] | YES | N/A | N/A |
|
MAX RECORDS RETURNED | ||
5. | ANSWER_TABLE_WIDTH | NUMBER[10] | YES | N/A | N/A |
|
ANSWER TABLE WIDTH | ||
6. | TABLE_CHECK_BOX_COLUMN_WIDTH | NUMBER[10] | YES | N/A | N/A |
|
TABLE CHECK BOX COLUMN WIDTH | ||
7. | TABLE_BG_ALT_COLOR1 | VARCHAR2[50] | YES | N/A | N/A |
|
TABLE BG ALT COLOR1 | ||
8. | TABLE_BG_ALT_COLOR2 | VARCHAR2[50] | YES | N/A | N/A |
|
TABLE BG ALT COLOR2 | ||
9. | TABLE_BODY_FONT_SIZE | NUMBER[10] | YES | N/A | N/A |
|
TABLE BODY FONT SIZE | ||
10. | TABLE_BODY_FONT_FACE | VARCHAR2[50] | YES | N/A | N/A |
|
TABLE BODY FONT FACE | ||
11. | TABLE_HEADER_BG_COLOR | VARCHAR2[50] | YES | N/A | N/A |
|
TABLE HEADER BG COLOR | ||
12. | TABLE_HEADER_FONT_SIZE | NUMBER[10] | YES | N/A | N/A |
|
TABLE HEADER FONT SIZE | ||
13. | TABLE_HEADER_FONT_FACE | VARCHAR2[50] | YES | N/A | N/A |
|
TABLE HEADER FONT FACE | ||
14. | USER_LOGO | BLOB[4000] | YES | N/A | N/A |
|
User's logo that may appear on his pages and Quizzes | ||
15. | USER_PREFERENCES_STATUS | VARCHAR2[3] | YES | N/A | N/A |
|
USER_PREFERENCES_STATUS |
# | 49 |
Table Name | USER_QUIZ |
Owner | YTM11 |
Type | TABLE |
Row Count | 0 |
Remarks | -Defines relationship between users and quiz. One quiz can have several managers. WARNING: Table is empty. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | 1 | NO | N/A | N/A |
|
USER ID | |
2. | QUIZ_DEFINITION_ID | NUMBER[10] | 2 | NO | N/A | N/A |
|
QUIZ_DEFINITION_ID | |
3. | USER_QUIZ_ROLE | VARCHAR2[3] | YES | N/A | N/A |
|
-QMN - Quiz manager |
# | 50 |
Table Name | USER_ROLE |
Owner | YTM11 |
Type | TABLE |
Row Count | 236 |
Remarks | User may have multiple roles. |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |||||||||||||||||||||||||||||||||
1. | USER_ID | NUMBER[10] | 2 | NO | YES | 236 (100.00%) |
|
USER ID | |||||||||||||||||||||||||||||||||
2. | ROLE_CODE | VARCHAR2[3] | 1 | NO | NO | 3 (1.27%) |
|
ROLE CODE | |||||||||||||||||||||||||||||||||
3. | ENABLED | CHAR[1] | NO | NO | 1 (0.42%) |
|
ENABLED SUGGESTION: All rows have the same data value in this column. Consider normalizing. |
# | 51 |
Table Name | V_CLASS_COURSE |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | CLASS_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | CLASS_NAME | VARCHAR2[200] | NO | YES | N/A |
|
|||
3. | CLASS_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
4. | CLASS_ACTIVE_FROM | DATE[7] | YES | YES | N/A |
|
|||
5. | CLASS_ACTIVE_TO | DATE[7] | YES | YES | N/A |
|
|||
6. | CLASS_STATUS | CHAR[3] | YES | YES | N/A |
|
|||
7. | CLASS_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
8. | CLASS_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
9. | CLASS_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
10. | CLASS_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
11. | COURSE_ID | NUMBER[10] | NO | YES | N/A |
|
|||
12. | PARENT_COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
13. | COURSE_NAME | VARCHAR2[300] | NO | YES | N/A |
|
|||
14. | COURSE_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
15. | COURSE_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
16. | COURSE_CATEGORY_LEVEL | NUMBER[0] | NO | YES | N/A |
|
|||
17. | COURSE_DESCRIPTION | VARCHAR2[2000] | NO | YES | N/A |
|
|||
18. | COURSE_CREDITS | NUMBER[0] | YES | YES | N/A |
|
|||
19. | COURSE_DURATION_IN_HRS | NUMBER[0] | YES | YES | N/A |
|
|||
20. | COURSE_DEPARTMENT_ID | VARCHAR2[3] | YES | YES | N/A |
|
|||
21. | COURSE_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
22. | COURSE_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
23. | COURSE_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
24. | COURSE_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
25. | COURSE_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
26. | COURSE_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
27. | CLASS_COURSE_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
28. | CLASS_COURSE_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
29. | CLASS_COURSE_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
30. | CLASS_COURSE_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
# | 52 |
Table Name | V_CODES |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | CODE_TYPE_ID | VARCHAR2[3] | NO | YES | N/A |
|
|||
2. | CODE_TYPE_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
3. | CODE_TYPE_DESCRIPTION | VARCHAR2[200] | NO | YES | N/A |
|
|||
4. | CODE_ID | VARCHAR2[3] | NO | YES | N/A |
|
|||
5. | CODE_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
6. | CODE_DESCRIPTION | VARCHAR2[200] | NO | YES | N/A |
|
# | 53 |
Table Name | V_COURSES |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | COURSE_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | COURSE_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
3. | CATEGORY | VARCHAR2[300] | NO | YES | N/A |
|
|||
4. | TOP_COURSE | VARCHAR2[300] | YES | YES | N/A |
|
|||
5. | COURSE_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
|||
6. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
7. | TABLE_LEVEL | NUMBER[0] | NO | YES | N/A |
|
|||
8. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
9. | COURSE_DESCRIPTION | VARCHAR2[2000] | NO | YES | N/A |
|
|||
10. | PARENT_COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
11. | COURSE_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
12. | CREDITS | NUMBER[0] | YES | YES | N/A |
|
|||
13. | DURATION_IN_HRS | NUMBER[0] | YES | YES | N/A |
|
|||
14. | DEPARTMENT_ID | VARCHAR2[3] | YES | YES | N/A |
|
|||
15. | SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
16. | YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
# | 54 |
Table Name | V_COURSES_SUM |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
2. | COURSE_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
3. | COURSE_NAME | VARCHAR2[300] | YES | YES | N/A |
|
|||
4. | COURSE_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
5. | TOP_COURSE | VARCHAR2[300] | YES | YES | N/A |
|
|||
6. | COURSE_TREE | VARCHAR2[4000] | YES | YES | N/A |
|
|||
7. | COURSE_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
|||
8. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
9. | TABLE_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
10. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
11. | COURSE_DESCRIPTION | VARCHAR2[2000] | YES | YES | N/A |
|
|||
12. | PARENT_COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
13. | CREDITS | NUMBER[0] | YES | YES | N/A |
|
|||
14. | DURATION_IN_HRS | NUMBER[0] | YES | YES | N/A |
|
|||
15. | DEPARTMENT_ID | VARCHAR2[3] | YES | YES | N/A |
|
|||
16. | SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
17. | YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
18. | COURSE_COUNT | NUMBER[0] | YES | YES | N/A |
|
# | 55 |
Table Name | V_DOCUMENT |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | DOCUMENT_ID | NUMBER[0] | NO | YES | N/A |
|
|||
2. | DOCUMENT_TITLE | VARCHAR2[400] | NO | YES | N/A |
|
|||
3. | DOCUMENT_DESCRIPTION | VARCHAR2[2000] | NO | YES | N/A |
|
|||
4. | DOCUMENT_BINARY_CONTENT_SIZE | NUMBER[0] | YES | YES | N/A |
|
|||
5. | DOCUMENT_CHAR_CONTENT_SIZE | NUMBER[0] | YES | YES | N/A |
|
|||
6. | FILE_NAME | VARCHAR2[400] | YES | YES | N/A |
|
|||
7. | FILE_PATH | VARCHAR2[400] | YES | YES | N/A |
|
|||
8. | CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
9. | CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
10. | UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
11. | UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
# | 56 |
Table Name | V_POOLS_SUM |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | POOL_ID | NUMBER[10] | YES | YES | N/A |
|
|||
2. | POOL_NAME | VARCHAR2[100] | YES | YES | N/A |
|
|||
3. | TOP_POOL | VARCHAR2[100] | YES | YES | N/A |
|
|||
4. | POOL_TREE | VARCHAR2[4000] | YES | YES | N/A |
|
|||
5. | POOL_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
|||
6. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
7. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
8. | POOL_DESCRIPTION | VARCHAR2[500] | YES | YES | N/A |
|
|||
9. | PARENT_POOL_ID | NUMBER[10] | YES | YES | N/A |
|
|||
10. | POOL_COUNT | NUMBER[0] | YES | YES | N/A |
|
# | 57 |
Table Name | V_POOL_QUESTION_INFO |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | POOL_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | POOL_NAME | VARCHAR2[100] | NO | YES | N/A |
|
|||
3. | NUMBER_OF_QUESTIONS | NUMBER[0] | YES | YES | N/A |
|
# | 58 |
Table Name | V_POOL_QUESTION_SUM |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | POOL_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | POOL_NAME | VARCHAR2[100] | NO | YES | N/A |
|
|||
3. | NUMBER_OF_QUESTIONS | NUMBER[0] | YES | YES | N/A |
|
# | 59 |
Table Name | V_QUESTIONS_IN_POOLS |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | POOL_ID | NUMBER[10] | NO | YES | N/A |
|
|||
4. | POOL_NAME | VARCHAR2[100] | NO | YES | N/A |
|
|||
5. | QUESTION_ID | NUMBER[10] | NO | YES | N/A |
|
|||
6. | QUESTION_TEXT | NVARCHAR2[2000] | NO | YES | N/A |
|
|||
7. | DIFFICULTY | NUMBER[0] | YES | YES | N/A |
|
|||
8. | POINTS | NUMBER[0] | YES | YES | N/A |
|
# | 60 |
Table Name | V_QUIZ |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_DEFINITION_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | QUIZ_CATEGORY_ID | NUMBER[10] | YES | YES | N/A |
|
|||
3. | QUIZ_NAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
4. | DEFAULT_DURATION | NUMBER[10] | YES | YES | N/A |
|
|||
5. | USERS_COMMENT | NVARCHAR2[2000] | YES | YES | N/A |
|
|||
6. | DEFAULT_ENABLED_FROM | DATE[7] | YES | YES | N/A |
|
|||
7. | DEFAULT_ENABLED_TO | DATE[7] | YES | YES | N/A |
|
|||
8. | DISPLAY_ANSWER_IND | CHAR[1] | YES | YES | N/A |
|
|||
9. | DISPLAY_CORRECT_IND | CHAR[1] | YES | YES | N/A |
|
|||
10. | DURATION_FACTOR | NUMBER[10] | YES | YES | N/A |
|
|||
11. | QUIZ_DEF_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
12. | QUIZ_DEF_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
13. | QUIZ_DEF_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
14. | QUIZ_DEF_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
15. | QUESTION_ID | NUMBER[10] | NO | YES | N/A |
|
|||
16. | QUESTION_TEXT | NVARCHAR2[2000] | NO | YES | N/A |
|
|||
17. | DURATION | NUMBER[10] | YES | YES | N/A |
|
|||
18. | DIFFICULTY | NUMBER[0] | YES | YES | N/A |
|
|||
19. | POINTS | NUMBER[0] | YES | YES | N/A |
|
|||
20. | EXCEL_QUESTION_ID | NUMBER[10] | YES | YES | N/A |
|
|||
21. | QUESTION_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
22. | QUESTION_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
23. | QUESTION_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
24. | QUESTION_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
25. | QUESTION_MUL_CHOICE_IND | VARCHAR2[3] | YES | YES | N/A |
|
|||
26. | READ_ONLY_IND | CHAR[1] | YES | YES | N/A |
|
|||
27. | QUESTION_ORDINAL_NUMBER | NUMBER[10] | YES | YES | N/A |
|
|||
28. | STATUS | VARCHAR2[3] | NO | YES | N/A |
|
|||
29. | ANSWER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
30. | ANSWER_TEXT | VARCHAR2[2000] | YES | YES | N/A |
|
|||
31. | ANSWER_ORDINAL_NUMBER | NUMBER[0] | YES | YES | N/A |
|
|||
32. | CORRECT_ANSWER_IND | CHAR[1] | YES | YES | N/A |
|
|||
33. | ANSWER_CREATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
34. | ANSWER_CREATA_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
35. | ANSWER_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
36. | ANSWER_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
# | 61 |
Table Name | V_QUIZ_CATEGORIES |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_CATEGORY_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | CATEGORY | VARCHAR2[50] | NO | YES | N/A |
|
|||
3. | TOP_CATEGORY | VARCHAR2[50] | YES | YES | N/A |
|
|||
4. | CATEGORY_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
|||
5. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
6. | TABLE_LEVEL | NUMBER[0] | NO | YES | N/A |
|
|||
7. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
8. | QUIZ_CATEGORY_DESCRIPTION | VARCHAR2[1000] | YES | YES | N/A |
|
|||
9. | PARENT_QUIZ_CATEGORY_ID | NUMBER[10] | YES | YES | N/A |
|
# | 62 |
Table Name | V_QUIZ_CATEGORIES_SUM |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_CATEGORY_ID | NUMBER[10] | YES | YES | N/A |
|
|||
2. | CATEGORY | VARCHAR2[50] | YES | YES | N/A |
|
|||
3. | TOP_CATEGORY | VARCHAR2[50] | YES | YES | N/A |
|
|||
4. | CATEGORY_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
|||
5. | CATEGORY_TREE | VARCHAR2[4000] | YES | YES | N/A |
|
|||
6. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
7. | TABLE_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
8. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
9. | QUIZ_CATEGORY_DESCRIPTION | VARCHAR2[1000] | YES | YES | N/A |
|
|||
10. | PARENT_QUIZ_CATEGORY_ID | NUMBER[10] | YES | YES | N/A |
|
|||
11. | SUB_CATEGORIES_COUNT | NUMBER[0] | YES | YES | N/A |
|
# | 63 |
Table Name | V_QUIZ_CATEGORIES_SUM2 |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_CATEGORY_ID | NUMBER[10] | YES | YES | N/A |
|
|||
2. | CATEGORY | VARCHAR2[50] | YES | YES | N/A |
|
|||
3. | TOP_CATEGORY | VARCHAR2[50] | YES | YES | N/A |
|
|||
4. | CATEGORY_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
|||
5. | CATEGORY_TREE | VARCHAR2[4000] | YES | YES | N/A |
|
|||
6. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
7. | TABLE_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
8. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
9. | QUIZ_CATEGORY_DESCRIPTION | VARCHAR2[1000] | YES | YES | N/A |
|
|||
10. | PARENT_QUIZ_CATEGORY_ID | NUMBER[10] | YES | YES | N/A |
|
|||
11. | QUIZ_COUNT | NUMBER[0] | YES | YES | N/A |
|
# | 64 |
Table Name | V_QUIZ_RESULT |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_INSTANCE_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USER_ID_TESTED | NUMBER[10] | NO | YES | N/A |
|
|||
3. | QUIZ_RESULT_ID | NUMBER[10] | NO | YES | N/A |
|
|||
4. | QUESTION_ID | NUMBER[10] | NO | YES | N/A |
|
|||
5. | ANSWER_TEXT | NVARCHAR2[2000] | YES | YES | N/A |
|
|||
6. | NOT_SURE_FLAG | CHAR[1] | YES | YES | N/A |
|
|||
7. | POINTS_ASSIGNED | NUMBER[10] | YES | YES | N/A |
|
|||
8. | Q_RESULT_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
9. | Q_RESULT_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
10. | Q_RESULT_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
11. | Q_RESULT_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
12. | QUESTION_TEXT | NVARCHAR2[2000] | NO | YES | N/A |
|
|||
13. | PICTURE | BLOB[4000] | YES | YES | N/A |
|
|||
14. | QUESTION_DURATION | NUMBER[10] | YES | YES | N/A |
|
|||
15. | QUESTION_DIFFICULTY | NUMBER[0] | YES | YES | N/A |
|
|||
16. | QUESTION_POINTS | NUMBER[0] | YES | YES | N/A |
|
|||
17. | EXCEL_QUESTION_ID | NUMBER[10] | YES | YES | N/A |
|
|||
18. | QUESTION_MULTI_CHOICE_IND | VARCHAR2[3] | YES | YES | N/A |
|
|||
19. | QUESTION_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
20. | QUESTION_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
21. | QUESTION_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
22. | QUESTION_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
23. | ANSWER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
24. | ANSWER_ANSWERED_TEXT | VARCHAR2[2000] | NO | YES | N/A |
|
|||
25. | ANSWER_ORDINAL_NUMBER | NUMBER[0] | YES | YES | N/A |
|
|||
26. | CORRECT_ANSWER_IND | CHAR[1] | YES | YES | N/A |
|
|||
27. | ANSWER_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
28. | ANSWER_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
29. | ANSWER_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
30. | ANSWER_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
|||
31. | USER_USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
32. | USER_FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
33. | USER_LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
34. | USER_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
35. | USER_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
36. | USER_USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
37. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
# | 65 |
Table Name | V_QUIZ_RESULT_SUM |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_INSTANCE_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USER_ID_TESTED | NUMBER[10] | NO | YES | N/A |
|
|||
3. | MAX_POINTS | NUMBER[0] | YES | YES | N/A |
|
|||
4. | POINTS_ASSIGNED | NUMBER[0] | YES | YES | N/A |
|
|||
5. | PERCENT_SCORED | NUMBER[0] | YES | YES | N/A |
|
# | 66 |
Table Name | V_ROLES_PERMISSIONS |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | ROLE_CODE | VARCHAR2[3] | NO | YES | N/A |
|
|||
2. | ROLE_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
3. | ROLE_DESCRIPTION | VARCHAR2[400] | YES | YES | N/A |
|
|||
4. | GRANTABLE | CHAR[1] | YES | YES | N/A |
|
|||
5. | ROLE_ENABLED | CHAR[1] | NO | YES | N/A |
|
|||
6. | FUNCTION_CODE | VARCHAR2[3] | NO | YES | N/A |
|
|||
7. | FUNCTION_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
8. | FUNCTION_DESCRIPTION | VARCHAR2[400] | YES | YES | N/A |
|
|||
9. | FUNCTION_ENABLED | CHAR[1] | NO | YES | N/A |
|
|||
10. | ROLE_FUNCTION_ENABLED | CHAR[1] | NO | YES | N/A |
|
# | 67 |
Table Name | V_ST_QUIZ |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks | Used during load from staging tables into permanent tables in the database |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | ST_QUIZ_ID | NUMBER[10] | NO | YES | N/A |
|
Primary key | ||
2. | ST_QUESTION_ID | NUMBER[10] | NO | YES | N/A |
|
Primary key of table table ST_QUESTION_ID | ||
3. | ST_ANSWER_ID | NUMBER[10] | NO | YES | N/A |
|
Primary key of table table ST_ANSWER | ||
4. | 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. | ||
5. | PASSWORD | CHAR[10] | YES | YES | N/A |
|
PASSWORD | ||
6. | USER_ID | NUMBER[10] | YES | YES | N/A |
|
USER ID | ||
7. | QUIZ_NAME | NVARCHAR2[100] | NO | YES | N/A |
|
Name (Title) of this test. | ||
8. | DEFAULT_DURATION | NUMBER[10] | YES | YES | N/A |
|
Test duration in seconds. This is time available to complete the test once test instance started. | ||
9. | USERS_COMMENT | NVARCHAR2[2000] | YES | YES | N/A |
|
USERS COMMENT | ||
10. | DEFAULT_ENABLED_FROM | DATE[7] | YES | YES | N/A |
|
DEFAULT ENABLED FROM | ||
11. | DEFAULT_ENABLED_TO | DATE[7] | YES | YES | N/A |
|
DEFAULT ENABLED TO | ||
12. | RESULT_TRANSPARENCY | VARCHAR2[20] | YES | YES | N/A |
|
RESULT TRANSPARENCY | ||
13. | 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. | ||
14. | 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 | ||
15. | CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
CREATE USER ID | ||
16. | CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
CREATE DATETIME | ||
17. | 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. | ||
18. | QUESTION_TEXT | NVARCHAR2[2000] | NO | YES | N/A |
|
QUESTION TEXT | ||
19. | PICTURE | BLOB[4000] | YES | YES | N/A |
|
This is picture that is displayed with question. | ||
20. | 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. | ||
21. | DIFFICULTY | NUMBER[0] | YES | YES | N/A |
|
This is degree of difficulty. Higher number represents higher difficulty of question. | ||
22. | 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. | ||
23. | 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. | ||
24. | 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. | ||
25. | ANSWER_TEXT | NVARCHAR2[2000] | YES | YES | N/A |
|
ANSWER_TEXT | ||
26. | 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. | ||
27. | CORRECT_ANSWER_IND | CHAR[1] | YES | YES | N/A |
|
Indicates if this is the correct answer. |
# | 68 |
Table Name | V_SUBCAT_AND_COURSES_SUM |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | QUIZ_COUNT | NUMBER[0] | YES | YES | N/A |
|
|||
2. | PARENT_QUIZ_CAT | NUMBER[10] | YES | YES | N/A |
|
# | 69 |
Table Name | V_USER_ACTIONS |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
2. | PASSWORD | VARCHAR2[50] | NO | YES | N/A |
|
|||
3. | ACTION_CODE | VARCHAR2[10] | NO | YES | N/A |
|
|||
4. | CREATE_DATETIME | TIMESTAMP(6)[11,6] | NO | YES | N/A |
|
# | 70 |
Table Name | V_USER_CLASS |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | USER_FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | USER_LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
5. | USER_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | USER_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | CLASS_ID | NUMBER[10] | NO | YES | N/A |
|
|||
10. | CLASS_NAME | VARCHAR2[200] | NO | YES | N/A |
|
|||
11. | CLASS_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
12. | CLASS_ACTIVE_FROM | DATE[7] | YES | YES | N/A |
|
|||
13. | CLASS_ACTIVE_TO | DATE[7] | YES | YES | N/A |
|
|||
14. | CLASS_STATUS | CHAR[3] | YES | YES | N/A |
|
|||
15. | USER_CLASS_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
|||
16. | CLASS_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
17. | CLASS_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
18. | CLASS_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
19. | CLASS_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
# | 71 |
Table Name | V_USER_CLASS_COURSE |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | YES | YES | N/A |
|
|||
3. | USER_FIRST_NAME | VARCHAR2[50] | YES | YES | N/A |
|
|||
4. | USER_LAST_NAME | VARCHAR2[50] | YES | YES | N/A |
|
|||
5. | USER_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | USER_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | CLASS_ID | NUMBER[0] | YES | YES | N/A |
|
|||
10. | CLASS_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
11. | CLASS_NAME | VARCHAR2[200] | YES | YES | N/A |
|
|||
12. | USER_CLASS_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
|||
13. | CLASS_ACTIVE_FROM | DATE[7] | YES | YES | N/A |
|
|||
14. | CLASS_ACTIVE_TO | DATE[7] | YES | YES | N/A |
|
|||
15. | CLASS_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
16. | COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
17. | PARENT_COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
18. | COURSE_NAME | VARCHAR2[300] | YES | YES | N/A |
|
|||
19. | COURSE_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
20. | COURSE_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
21. | COURSE_CATEGORY_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
22. | COURSE_DESCRIPTION | VARCHAR2[2000] | YES | YES | N/A |
|
|||
23. | COURSE_CREDITS | NUMBER[0] | YES | YES | N/A |
|
|||
24. | COURSE_DURATION_IN_HRS | NUMBER[0] | YES | YES | N/A |
|
|||
25. | COURSE_DEPARTMENT_ID | VARCHAR2[3] | YES | YES | N/A |
|
|||
26. | COURSE_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
27. | COURSE_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
28. | USER_COURSE_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
# | 72 |
Table Name | V_USER_COURSE |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | USER_FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | USER_LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
5. | USER_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | USER_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | USER_COURSE_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
|||
10. | COURSE_ID | NUMBER[10] | NO | YES | N/A |
|
|||
11. | PARENT_COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
12. | COURSE_NAME | VARCHAR2[300] | NO | YES | N/A |
|
|||
13. | COURSE_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
14. | COURSE_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
15. | COURSE_CATEGORY_LEVEL | NUMBER[0] | NO | YES | N/A |
|
|||
16. | COURSE_DESCRIPTION | VARCHAR2[2000] | NO | YES | N/A |
|
|||
17. | COURSE_CREDITS | NUMBER[0] | YES | YES | N/A |
|
|||
18. | COURSE_DURATION_IN_HRS | NUMBER[0] | YES | YES | N/A |
|
|||
19. | COURSE_DEPARTMENT_ID | VARCHAR2[3] | YES | YES | N/A |
|
|||
20. | COURSE_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
21. | COURSE_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
22. | COURSE_CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
23. | COURSE_CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
24. | COURSE_UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
25. | COURSE_UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
# | 73 |
Table Name | V_USER_COURSE_ROLE |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USER_FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
3. | USER_LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | USER_ROLE_CODE | VARCHAR2[3] | NO | YES | N/A |
|
|||
5. | COURSE_ID | NUMBER[10] | NO | YES | N/A |
|
# | 74 |
Table Name | V_USER_COURSE_TREE |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | USER_FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | USER_LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
5. | USER_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | USER_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | USER_COURSE_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
|||
10. | COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
11. | PARENT_COURSE_ID | NUMBER[10] | YES | YES | N/A |
|
|||
12. | COURSE_NAME | VARCHAR2[300] | YES | YES | N/A |
|
|||
13. | COURSE_CODE | VARCHAR2[30] | YES | YES | N/A |
|
|||
14. | COURSE_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
15. | TOP_COURSE | VARCHAR2[300] | YES | YES | N/A |
|
|||
16. | COURSE_DESCRIPTION | VARCHAR2[2000] | YES | YES | N/A |
|
|||
17. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
18. | TABLE_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
19. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
20. | COURSE_COUNT | NUMBER[0] | YES | YES | N/A |
|
|||
21. | COURSE_TREE | VARCHAR2[4000] | YES | YES | N/A |
|
|||
22. | COURSE_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
|||
23. | CREDITS | NUMBER[0] | YES | YES | N/A |
|
|||
24. | DURATION_IN_HRS | NUMBER[0] | YES | YES | N/A |
|
|||
25. | DEPARTMENT_ID | VARCHAR2[3] | YES | YES | N/A |
|
|||
26. | SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
27. | YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
# | 75 |
Table Name | V_USER_POOLS |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | USER_FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | USER_LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
5. | USER_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | USER_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | USER_POOL_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
|||
10. | POOL_ID | NUMBER[10] | NO | YES | N/A |
|
|||
11. | POOL_NAME | VARCHAR2[100] | NO | YES | N/A |
|
|||
12. | POOL_DESCRIPTION | VARCHAR2[500] | NO | YES | N/A |
|
|||
13. | CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
14. | CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
15. | UPDATE_USER_ID | NUMBER[10] | YES | YES | N/A |
|
|||
16. | UPDATE_DATETIME | DATE[7] | YES | YES | N/A |
|
# | 76 |
Table Name | V_USER_POOLS_TREE |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | USER_FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | USER_LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
5. | USER_SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | USER_YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | USERS_POOL_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
|||
10. | POOL_ID | NUMBER[10] | YES | YES | N/A |
|
|||
11. | PARENT_POOL_ID | NUMBER[10] | YES | YES | N/A |
|
|||
12. | POOL_NAME | VARCHAR2[100] | YES | YES | N/A |
|
|||
13. | TOP_POOL | VARCHAR2[100] | YES | YES | N/A |
|
|||
14. | POOL_DESCRIPTION | VARCHAR2[500] | YES | YES | N/A |
|
|||
15. | SYSTEM_LEVEL | NUMBER[0] | YES | YES | N/A |
|
|||
16. | IS_LEAF | NUMBER[0] | YES | YES | N/A |
|
|||
17. | POOL_COUNT | NUMBER[0] | YES | YES | N/A |
|
|||
18. | POOL_TREE | VARCHAR2[4000] | YES | YES | N/A |
|
|||
19. | POOL_PATH | VARCHAR2[4000] | YES | YES | N/A |
|
# | 77 |
Table Name | V_USER_POOL_SUM_QUESTIONS |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | POOL_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | POOL_NAME | VARCHAR2[100] | NO | YES | N/A |
|
|||
3. | POOL_DESCRIPTION | VARCHAR2[500] | NO | YES | N/A |
|
|||
4. | CREATE_USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
5. | CREATE_DATETIME | DATE[7] | NO | YES | N/A |
|
|||
6. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
7. | USERS_POOL_ROLE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | NUMBER_OF_QUESTIONS | NUMBER[0] | YES | YES | N/A |
|
# | 78 |
Table Name | V_USER_ROLES |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
5. | SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | ROLE_CODE | VARCHAR2[3] | NO | YES | N/A |
|
|||
10. | ROLE_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
11. | ROLE_DESCRIPTION | VARCHAR2[400] | YES | YES | N/A |
|
|||
12. | GRANTABLE | CHAR[1] | YES | YES | N/A |
|
|||
13. | ROLE_ENABLED | CHAR[1] | NO | YES | N/A |
|
# | 79 |
Table Name | V_USER_ROLES_PERMISSIONS |
Owner | YTM11 |
Type | VIEW |
Row Count | N/A |
Remarks |
# | Column | Type | PK | Null | Unique | Cardinality | Sample Data | Comment | |
1. | USER_ID | NUMBER[10] | NO | YES | N/A |
|
|||
2. | USERNAME | NVARCHAR2[100] | NO | YES | N/A |
|
|||
3. | FIRST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
4. | LAST_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
5. | SEMESTER | NUMBER[0] | YES | YES | N/A |
|
|||
6. | YEAR_OF_STUDY | NUMBER[0] | YES | YES | N/A |
|
|||
7. | USER_TYPE | VARCHAR2[3] | YES | YES | N/A |
|
|||
8. | USER_STATUS | VARCHAR2[3] | YES | YES | N/A |
|
|||
9. | ROLE_CODE | VARCHAR2[3] | NO | YES | N/A |
|
|||
10. | ROLE_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
11. | ROLE_DESCRIPTION | VARCHAR2[400] | YES | YES | N/A |
|
|||
12. | GRANTABLE | CHAR[1] | YES | YES | N/A |
|
|||
13. | ROLE_ENABLED | CHAR[1] | NO | YES | N/A |
|
|||
14. | FUNCTION_CODE | VARCHAR2[3] | NO | YES | N/A |
|
|||
15. | FUNCTION_NAME | VARCHAR2[50] | NO | YES | N/A |
|
|||
16. | FUNCTION_DESCRIPTION | VARCHAR2[400] | YES | YES | N/A |
|
|||
17. | FUNCTION_ENABLED | CHAR[1] | NO | YES | N/A |
|
|||
18. | ROLE_FUNCTION_ENABLED | CHAR[1] | NO | YES | N/A |
|
Orphan table | This is table with no relationships |
Invalid view | SQL Query that creates this view is invalid. Tables or columns referenced in this view don't exist. |
No primary key | If table does not have a primary key then records cannot be uniquely identified. Operations like update and delete cannot be safely performed record. Unique index is not reliable way to uniquely identify records if any column of that index is not mandatory field. |