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 References Sample Data Comment
Name ADDRESS_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A

N/A

ADDRESS ID
Name USER_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
USERS USER_ID

N/A

USER ID
Name STREET
Ordinal # 3
Data Type VARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

STREET
Name ADDITIONAL_ADDRESS_INFORMATION
Ordinal # 4
Data Type VARCHAR2[200]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

ADDITIONAL ADDRESS INFORMATION
Name BUILDING_NUMBER
Ordinal # 5
Data Type VARCHAR2[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

BUILDING NUMBER
Name UNIT
Ordinal # 6
Data Type VARCHAR2[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

This is apartment or townhouse number. It may have an alphanumeric values such as "PH 4" (penthouse #4)
Name CITY
Ordinal # 7
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CITY
Name POSTAL_CODE
Ordinal # 8
Data Type VARCHAR2[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

This field will contain: Postal Code (Canada) ZIP (US) Postanski Broj (Balkan countries) Equivalent information for other countries
Name STATE
Ordinal # 9
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

STATE
Name COUNTRY
Ordinal # 10
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

COUNTRY
Name ADDRESS_URL
Ordinal # 11
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

URL of the Address. For example, GOOGLE mal URL.
Name ADDRESS_TYPE
Ordinal # 12
Data Type CHAR[1]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

P - Personal (Home) B - Business (Office)
Name SHIPPING_ADDRESS_IND
Ordinal # 13
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Indicated if this is a shipping address.
Name BILLING_ADDRESS_IND
Ordinal # 14
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Indicates if this is a Billing address
Name SHIPP_BILL_ADR_SAME_IND
Ordinal # 15
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Indicates if shipping and billing addresses are the same
Name ACTIVE_FROM
Ordinal # 16
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

ACTIVE FROM
Name ACTIVE_TO
Ordinal # 17
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

In this value is NULL then this recor represents the current address
Name ADDRESS_STATUS
Ordinal # 18
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Status of this address
Name CREATE_USER_ID
Ordinal # 19
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 20
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 21
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 22
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE DATETIME


# 2
Table Name ANSWER
Owner YTM11
Type TABLE
Row Count 605
Remarks ANSWER

Column References Sample Data Comment
Name ANSWER_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 605
(100.00%)
Unique YES
Referenced by FK columns
Table Column
QUIZ_RESULT_ANSWER ANSWER_ID
ValueLengthCount
50001
50011
50021
50031
50041
50051
50061
50071
50081
50091
ANSWER ID
Name QUESTION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 121
(20.00%)
Unique NO
References PK column
Table Column
QUESTION QUESTION_ID
ValueLengthCount
50005
50015
50025
50035
50045
50055
50065
50075
50085
50095
QUESTION ID
Name ANSWER_TEXT
Ordinal # 3
Data Type VARCHAR2[2000]
PK Seq. #
Nullable NO
Cardinality N/A
Unique YES

N/A

This is free form text for "essay" answers. It is also used for "FILL IN BLANKS" type of questions.
Name ANSWER_ORDINAL_NUMBER
Ordinal # 4
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 5
(0.83%)
Unique NO
ValueLengthCount
2123
1121
4121
5121
3119
Determines the order in which question will appear in the list under the question.
Name CORRECT_ANSWER_IND
Ordinal # 5
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 2
(0.33%)
Unique NO
ValueLengthCount
null0485
Y1120
Indicates if this is the correct answer.
Name ANSWER_ADDITIONAL_INFO
Ordinal # 6
Data Type VARCHAR2[2000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique YES

N/A

This is additional inforamtion that can be used to explain the answer. It may be used for educational purposes.
Name CREATE_USER_ID
Ordinal # 7
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(0.17%)
Unique NO
ValueLengthCount
0605
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 5
(0.83%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:51:08.0000137
Sun Feb 23, 2014 09:51:09.0000121
Sun Feb 23, 2014 09:51:11.0000120
Sun Feb 23, 2014 09:51:07.0000118
Sun Feb 23, 2014 09:51:10.0000109
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 9
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(0.17%)
Unique NO
ValueLengthCount
null605
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name UPDATE_DATETIME
Ordinal # 10
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(0.17%)
Unique NO
ValueLengthCount
null605
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 References Sample Data Comment
Name CLASS_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 25
(100.00%)
Unique YES
Referenced by FK columns
Table Column
CLASS_COURSE CLASS_ID
QUIZ_INSTANCE CLASS_ID
USERS_CLASS CLASS_ID
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
CLASS_ID
Name CLASS_NAME
Ordinal # 2
Data Type VARCHAR2[200]
PK Seq. #
Nullable NO
Cardinality 25
(100.00%)
Unique YES
ValueLengthCount
Class I-a91
Class I-b91
Class I-c91
Class I-d91
Class I-e91
Class II-a101
Class II-b101
Class II-c101
Class II-d101
Class II-e101
CLASS_NAME
Name CLASS_CODE
Ordinal # 3
Data Type VARCHAR2[30]
PK Seq. #
Nullable YES
Cardinality 1
(4.00%)
Unique NO
ValueLengthCount
null025
CLASS_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CLASS_DESCRIPTION
Ordinal # 4
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality 1
(4.00%)
Unique NO
ValueLengthCount
null025
Description of the CLASS or the comment about the CLASS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name ACTIVE_FROM
Ordinal # 5
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 5
(20.00%)
Unique NO
ValueLengthCount
Mon Feb 24, 2003 08:10:05.00005
Fri Apr 23, 2004 08:18:25.00005
Fri Dec 24, 2004 05:10:55.00005
Fri Dec 24, 2004 10:10:55.00005
Thu Dec 25, 2008 06:10:17.00005
Witch column "ACTIVE_TO" describes the period when this Student Class is active. For example it could be specifict school year.
Name ACTIVE_TO
Ordinal # 6
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 25
(100.00%)
Unique YES
ValueLengthCount
Fri Dec 25, 2015 06:10:17.00001
Sat Dec 26, 2015 06:10:17.00001
Sun Dec 27, 2015 06:10:17.00001
Mon Dec 28, 2015 06:10:17.00001
Tue Dec 29, 2015 06:10:17.00001
Wed Dec 30, 2015 06:10:17.00001
Thu Dec 31, 2015 06:10:17.00001
Fri Jan 1, 2016 06:10:17.00001
Sat Jan 2, 2016 06:10:17.00001
Sun Jan 3, 2016 06:10:17.00001
With column "ACTIVE_FROM" describes the period when this Student Class is active. For example it could be specifict school year.
Name CLASS_STATUS
Ordinal # 7
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(4.00%)
Unique NO
ValueLengthCount
ATV325
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.
Name CREATE_USER_ID
Ordinal # 8
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(4.00%)
Unique NO
ValueLengthCount
125
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 9
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 2
(8.00%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:50:47.000024
Sun Feb 23, 2014 09:50:46.00001
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 10
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(4.00%)
Unique NO
ValueLengthCount
null25
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name UPDATE_DATETIME
Ordinal # 11
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(4.00%)
Unique NO
ValueLengthCount
null25
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 References Sample Data Comment
Name CLASS_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 3
(3.23%)
Unique NO
References PK column
Table Column
CLASS CLASS_ID
ValueLengthCount
131
231
331
CLASS_ID
Name COURSE_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. # 2
Nullable NO
Cardinality 31
(33.33%)
Unique NO
References PK column
Table Column
COURSE COURSE_ID
ValueLengthCount
23
33
43
53
63
73
83
93
263
273
COURSE_ID
Name CREATE_USER_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(1.08%)
Unique NO
ValueLengthCount
093
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 4
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 2
(2.15%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:51:14.000086
Sun Feb 23, 2014 09:51:13.00007
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(1.08%)
Unique NO
ValueLengthCount
null93
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name UPDATE_DATETIME
Ordinal # 6
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(1.08%)
Unique NO
ValueLengthCount
null93
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 References Sample Data Comment
Name CODE_ID
Ordinal # 1
Data Type VARCHAR2[3]
PK Seq. # 1
Nullable NO
Cardinality 71
(100.00%)
Unique YES
ValueLengthCount
AAL31
ACE31
ACT31
ADS31
AOL31
AOP31
APR31
ATN31
ATR31
ATV31
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?")
Name CODE_TYPE_ID
Ordinal # 2
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality 23
(32.39%)
Unique NO
References PK column
Table Column
CODE_TYPE CODE_TYPE_ID
ValueLengthCount
QST38
QUT37
USS35
QAS34
QDS34
AST33
COS33
CST33
DUT33
ESS33
CODE TYPE ID
Name CODE_NAME
Ordinal # 3
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality 60
(84.51%)
Unique NO
ValueLengthCount
ACTIVE64
DELETED73
CANCELLED92
DEFFERED82
EXPIRED72
INACTIVE82
MANAGER72
SUSPENDED92
ADMINISTRATOR131
ALL ON PAGE111
CODE NAME
Name CODE_DESCRIPTION
Ordinal # 4
Data Type VARCHAR2[200]
PK Seq. #
Nullable NO
Cardinality 65
(91.55%)
Unique NO
ValueLengthCount
Active64
Cancelled92
Deleted72
Inactive82
ATTEMPTED NO REPORT191
ATTEMPTED WITH REPOR...231
Administrator131
All questions on one...231
Alternate91
Assigned81
CODE DESCRIPTION
Name CODE_LONG_DESCRIPTION
Ordinal # 5
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality 1
(1.41%)
Unique NO
ValueLengthCount
null071
CODE LONG DESCRIPTION
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name ALTERNATE_CODE_VALUE
Ordinal # 6
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 1
(1.41%)
Unique NO
ValueLengthCount
null071
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 References Sample Data Comment
Name CODE_TYPE_ID
Ordinal # 1
Data Type VARCHAR2[3]
PK Seq. # 1
Nullable NO
Cardinality 24
(100.00%)
Unique YES
Referenced by FK columns
Table Column
CODE CODE_TYPE_ID
ValueLengthCount
ADT31
AST31
COS31
CRT31
CST31
DUT31
ESS31
GEN31
LOT31
QAS31
CODE TYPE ID
Name CODE_TYPE_NAME
Ordinal # 2
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality 24
(100.00%)
Unique YES
ValueLengthCount
ADDRESS STATUS141
ADDRESS TYPE121
CLASS STATUS121
COURSE STATUS131
CREATE TYPE111
DURATION TYPE131
EMAIL SENT STATUS171
GENDER CODE111
LOOK TYPE91
QUESTION DIFFICULTY191
CODE TYPE NAME
Name CODE_TYPE_DESCRIPTION
Ordinal # 3
Data Type VARCHAR2[200]
PK Seq. #
Nullable NO
Cardinality 24
(100.00%)
Unique YES
ValueLengthCount
Address Status141
Address Type121
Class of Users Statu...231
Course Status131
Describes User's ro...231
Describes User's ro...231
Describes how the re...231
Describes type of th...231
Describes when the r...231
Email Sent Status171
CODE TYPE DESCRIPTION
Name CODE_TYPE_LONG_DESCRIPTION
Ordinal # 4
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality 1
(4.17%)
Unique NO
ValueLengthCount
null024
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 References Sample Data Comment
Name COURSE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 65
(100.00%)
Unique YES
Referenced by FK columns
Table Column
CLASS_COURSE COURSE_ID
COURSE PARENT_COURSE_ID
QUIZ_INSTANCE COURSE_ID
USER_COURSE COURSE_ID
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
COURSE_ID
Name PARENT_COURSE_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 16
(24.62%)
Unique NO
References PK column
Table Column
COURSE COURSE_ID
ValueLengthCount
168
27
427
517
356
null6
605
114
263
303
Course may have a parent course. This is made for flexibility, it may not be used very frequently.
Name COURSE_NAME
Ordinal # 3
Data Type VARCHAR2[300]
PK Seq. #
Nullable NO
Cardinality 65
(100.00%)
Unique YES
ValueLengthCount
Advanced Accounting ...231
Advanced Auditing171
Advanced Financial A...231
Animal Behaviour161
Animal Physiology La...231
Art and Culture151
Astronomy91
Astrophysics Researc...231
Astrophysics of Plan...231
Astrophysics of Star...231
COURSE_NAME
Name COURSE_CODE
Ordinal # 4
Data Type VARCHAR2[30]
PK Seq. #
Nullable YES
Cardinality 51
(78.46%)
Unique NO
ValueLengthCount
null015
ASTA01H381
ASTA02H381
ASTB03H381
ASTB23H381
ASTC25H381
ASTD01H381
ASTD02H381
BIOA01H381
BIOA02H381
Code may have a code used by the school.
Name COURSE_STATUS
Ordinal # 5
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
ACE365
COURSE_STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CATEGORY_LEVEL
Ordinal # 6
Data Type NUMBER[0]
PK Seq. #
Nullable NO
Cardinality 3
(4.62%)
Unique NO
ValueLengthCount
350
29
16
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.
Name COURSE_DESCRIPTION
Ordinal # 7
Data Type VARCHAR2[2000]
PK Seq. #
Nullable NO
Cardinality N/A
Unique YES

N/A

COURSE_DESCRIPTION
Name CREDITS
Ordinal # 8
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
null65
Number of Credits carried by this course.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name DURATION_IN_HRS
Ordinal # 9
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
null65
Duration of the course in hours
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name DEPARTMENT_ID
Ordinal # 10
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
null065
DEPARTMENT_ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name SEMESTER
Ordinal # 11
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
null65
SEMESTER
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name YEAR_OF_STUDY
Ordinal # 12
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
null65
YEAR_OF_STUDY
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_USER_ID
Ordinal # 13
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
165
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 14
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 2
(3.08%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:51:13.000048
Sun Feb 23, 2014 09:51:12.000017
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 15
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
null65
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name UPDATE_DATETIME
Ordinal # 16
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(1.54%)
Unique NO
ValueLengthCount
null65
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 References Sample Data Comment
Name DOCUMENT_ID
Ordinal # 1
Data Type NUMBER[0]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A

N/A

DOCUMENT ID
Name DOCUMENT_TITLE
Ordinal # 2
Data Type VARCHAR2[400]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

DOCUMENT TITLE
Name DOCUMENT_DESCRIPTION
Ordinal # 3
Data Type VARCHAR2[2000]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

DOCUMENT DESCRIPTION
Name DOCUMENT_BINARY_CONTENT
Ordinal # 4
Data Type BLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DOCUMENT BINARY CONTENT
Name DOCUMENT_CHAR_CONTENT
Ordinal # 5
Data Type CLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DOCUMENT CHAR CONTENT
Name FILE_NAME
Ordinal # 6
Data Type VARCHAR2[400]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

FILE_NAME
Name FILE_PATH
Ordinal # 7
Data Type VARCHAR2[400]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

document path to in the file system. This can be source or destination path.
Name CREATE_USER_ID
Ordinal # 8
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 9
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 10
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 11
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name EMAIL_SENT_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A

N/A

EMAIL_SENT_ID
Name QUIZ_EMAIL_ACTION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUIZ_EMAIL_ACTION QUIZ_EMAIL_ACTION_ID

N/A

QUIZ_EMAIL ACTION_ID
Name EVENT_DATE_TIME
Ordinal # 3
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

EVENT_DATE_TIME
Name EMAIL_SENT_STATUS
Ordinal # 4
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name EMAIL_TEMPLATE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
QUIZ_EMAIL_ACTION EMAIL_TEMPLATE_ID

N/A

EMAIL_TEMPLATE_ID
Name EMAIL_TEMPLATE
Ordinal # 2
Data Type BLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name FUNCTION_CODE
Ordinal # 1
Data Type VARCHAR2[3]
PK Seq. # 1
Nullable NO
Cardinality 14
(100.00%)
Unique YES
Referenced by FK columns
Table Column
ROLE_FUNCTION FUNCTION_CODE
ValueLengthCount
CCL31
CHP31
COD31
CPD31
CRC31
CRQ31
CRR31
CRU31
EDC31
EDE31
FUNCTION CODE
Name FUNCTION_NAME
Ordinal # 2
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality 14
(100.00%)
Unique YES
ValueLengthCount
Change Others Person...231
Change Own Personal ...231
Change Password151
Create Class121
Create Course131
Create Quiz111
Create Role111
Create User111
Edit Class101
Edit Course111
This is the name (short description) of the system function: For example: 1. Create User 2. Delete user 3. Create Quiz 4. Reports
Name FUNCTION_DESCRIPTION
Ordinal # 3
Data Type VARCHAR2[400]
PK Seq. #
Nullable YES
Cardinality 14
(100.00%)
Unique YES
ValueLengthCount
Change Others Person...231
Change Own Personal ...231
Change Password151
Create Class121
Create Course131
Create Quiz111
Create Role111
Create User111
Edit Class101
Edit Course111
Description of the system function.
Name ENABLED
Ordinal # 4
Data Type CHAR[1]
PK Seq. #
Nullable NO
Cardinality 1
(7.14%)
Unique NO
ValueLengthCount
Y114
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 References Sample Data Comment
Name GRADING_SYSTEM_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
GRADING_SYSTEM_LABEL GRADING_SYSTEM_ID
QUIZ_DEFINITION GRADING_SYSTEM_ID
QUIZ_TEMPLATE GRADING_SYSTEM_ID

N/A

Primarry Key
Name GRADING_SYSTEM_NAME
Ordinal # 2
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

GRADING_SYSTEM_NAME
Name GRADING_SYSTEM_DESCRIPTION
Ordinal # 3
Data Type VARCHAR2[1000]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

GRADING_SYSTEM_DESCRIPTION
Name CREATE_USER_ID
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 5
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 7
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name GRADING_SYSTEM_LABEL_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A

N/A

Primary Key
Name GRADING_SYSTEM_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
GRADING_SYSTEM GRADING_SYSTEM_ID

N/A

Primarry Key
Name GRADING_SYSTEM_LABEL_CODE
Ordinal # 3
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

GRADING_SYSTEM_LABEL_CODE
Name GRADING_SYSTEM_LABEL_NAME
Ordinal # 4
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

GRADING_SYSTEM_LABEL_NAME
Name PERCENT_MINIMUM
Ordinal # 5
Data Type NUMBER[0]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

PERCENT_MINIMUM
Name PERCENT_MAXIMUM
Ordinal # 6
Data Type NUMBER[0]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

PERCENT_MAXIMUM
Name CREATE_USER_ID
Ordinal # 7
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 9
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 10
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE DATETIME


# 14
Table Name LANGUAGE
Owner YTM11
Type TABLE
Row Count 72
Remarks Preferred language.

Column References Sample Data Comment
Name LANGUAGE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 72
(100.00%)
Unique YES
Referenced by FK columns
Table Column
USERS LANGUAGE_ID
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
LANGUAGE ID
Name LANGUAGE
Ordinal # 2
Data Type VARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality 72
(100.00%)
Unique YES
ValueLengthCount
Afrikanns91
Albanian81
Arabic61
Armenian81
Basque61
Bengali71
Bulgarian91
Cambodian91
Catalan71
Chinese (Mandarin)181
LANGUAGE
Name LANGUAGE_CODE
Ordinal # 3
Data Type CHAR[2]
PK Seq. #
Nullable YES
Cardinality 1
(1.39%)
Unique NO
ValueLengthCount
null072
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 References Sample Data Comment
Name ORGANIZATION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
ORGANIZATION PARENT_ORGANIZATION_ID
USERS ORGANIZATION_ID

N/A

ORGANIZATION ID
Name PARENT_ORGANIZATION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A
References PK column
Table Column
ORGANIZATION ORGANIZATION_ID

N/A

PARENT_ORGANIZATION_ID
Name ORGANIZATION_NAME
Ordinal # 3
Data Type VARCHAR2[250]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

ORGANIZATION NAME
Name ORGANIZATION_DESCRIPTION
Ordinal # 4
Data Type NVARCHAR2[250]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

ORGANIZATION DESCRIPTION
Name ORGANIZATION_CATEGORY_CODE
Ordinal # 5
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Identifies category og organization: - Univesity - College - Community College - High School - Commercial - Manufacturing
Name ORGANIZATION_STATUS
Ordinal # 6
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Status of the Organization: - Active - Inactive - Deleted
Name CREATE_USER_ID
Ordinal # 7
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 9
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 10
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name POOL_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 70
(100.00%)
Unique YES
Referenced by FK columns
Table Column
POOL PARENT_POOL_ID
POOL_QUESTION POOL_ID
QUIZ_DEFINITION_POOL POOL_ID
QUIZ_TEMPLATE_POOL POOL_ID
USERS_POOLS POOL_ID
ValueLengthCount
501
511
521
571
581
591
601
611
631
641
Pool of questions Primary Key
Name PARENT_POOL_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 13
(18.57%)
Unique NO
References PK column
Table Column
POOL POOL_ID
ValueLengthCount
5016
6012
586
596
645
665
675
685
574
null3
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.
Name POOL_NAME
Ordinal # 3
Data Type VARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality 70
(100.00%)
Unique YES
ValueLengthCount
Accounting101
Accounting 1121
Accounting 2121
Accounting 3121
Accounting 4121
Business81
Engineering111
English71
English 191
English 291
POOL NAME
Name POOL_DESCRIPTION
Ordinal # 4
Data Type VARCHAR2[500]
PK Seq. #
Nullable NO
Cardinality 70
(100.00%)
Unique YES
ValueLengthCount
Accounting101
Accounting 1121
Accounting 2121
Accounting 3121
Accounting 4121
Business81
Engineering111
English71
English 191
English 291
POOL_DESCRIPTION
Name CREATE_USER_ID
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(1.43%)
Unique NO
ValueLengthCount
070
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 6
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 2
(2.86%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:51:16.000068
Sun Feb 23, 2014 09:51:17.00002
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 7
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(1.43%)
Unique NO
ValueLengthCount
null70
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name UPDATE_DATETIME
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(1.43%)
Unique NO
ValueLengthCount
null70
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 References Sample Data Comment
Name QUESTION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUESTION QUESTION_ID

N/A

QUESTION ID
Name POOL_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. # 2
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
POOL POOL_ID

N/A

Pool of questions Primary Key


# 18
Table Name QUESTION
Owner YTM11
Type TABLE
Row Count 121
Remarks Default duration.

Column References Sample Data Comment
Name QUESTION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 121
(100.00%)
Unique YES
Referenced by FK columns
Table Column
ANSWER QUESTION_ID
POOL_QUESTION QUESTION_ID
QUIZ_QUESTION QUESTION_ID
QUIZ_RESULT QUESTION_ID
SURVEY_QUESTION QUESTION_ID
ValueLengthCount
50001
50011
50021
50031
50041
50051
50061
50071
50081
50091
QUESTION ID
Name QUESTION_TEXT
Ordinal # 2
Data Type NVARCHAR2[2000]
PK Seq. #
Nullable NO
Cardinality N/A
Unique YES

N/A

QUESTION TEXT
Name QUESTION_BLOB
Ordinal # 3
Data Type BLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique YES

N/A

This field is used to create more complex questions, for example: - formatted text - formulas - videos - sounds - animations - diagrams
Name PICTURE
Ordinal # 4
Data Type BLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique YES

N/A

This is picture that is displayed with question.
Name DURATION
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name DIFFICULTY_CODE
Ordinal # 6
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null0121
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.
Name DIFFICULTY
Ordinal # 7
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name EXCEL_QUESTION_ID
Ordinal # 8
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 31
(25.62%)
Unique NO
ValueLengthCount
10014
10024
10034
10044
10054
10064
10074
10084
10094
10104
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.
Name POINTS
Ordinal # 9
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name QUESTION_TYPE
Ordinal # 10
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null0121
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.
Name READ_ONLY_IND
Ordinal # 11
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null0121
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.
Name FREQUENCY_FACTOR
Ordinal # 12
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name PENALTY
Ordinal # 13
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name LARNING_FEEDBACK
Ordinal # 14
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null0121
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.
Name CREATE_USER_ID
Ordinal # 15
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
0121
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 16
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 5
(4.13%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:51:08.000027
Sun Feb 23, 2014 09:51:09.000025
Sun Feb 23, 2014 09:51:07.000024
Sun Feb 23, 2014 09:51:11.000023
Sun Feb 23, 2014 09:51:10.000022
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 17
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name UPDATE_DATETIME
Ordinal # 18
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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 References Sample Data Comment
Name QUIZ_CATEGORY_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 69
(100.00%)
Unique YES
Referenced by FK columns
Table Column
QUIZ_CATEGORY PARENT_QUIZ_CATEGORY_ID
QUIZ_DEFINITION QUIZ_CATEGORY_ID
QUIZ_TEMPLATE QUIZ_CATEGORY_ID
ValueLengthCount
10001
10011
10021
10031
10041
10051
10061
10071
10081
10091
QUIZ_CATEGORY_ID
Name PARENT_QUIZ_CATEGORY_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 22
(31.88%)
Unique NO
References PK column
Table Column
QUIZ_CATEGORY QUIZ_CATEGORY_ID
ValueLengthCount
null8
10176
10346
10004
10114
10254
10023
10073
10133
10413
PARENT_QUIZ CATEGORY ID
Name CATEGORY_NAME
Ordinal # 3
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality 62
(89.86%)
Unique NO
ValueLengthCount
1900s52
2000s52
Australia92
Biography92
India52
Latest62
South52
Action movies131
Actors61
Actresses91
CATEGORY_NAME
Name QUIZ_CATEGORY_DESCRIPTION
Ordinal # 4
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality 62
(89.86%)
Unique NO
ValueLengthCount
1900s52
2000s52
Australia92
Biography92
India52
Latest62
South52
Action movies131
Actors61
Actresses91
QUIZ_CATEGORY_DESCRIPTION
Name CATEGORY_LEVEL
Ordinal # 5
Data Type NUMBER[0]
PK Seq. #
Nullable NO
Cardinality 5
(7.25%)
Unique NO
ValueLengthCount
329
228
18
42
52
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.
Name CREATE_USER_ID
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
269
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 7
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 2
(2.90%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:50:50.000048
Sun Feb 23, 2014 09:50:51.000021
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 8
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
null69
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name UPDATE_DATETIME
Ordinal # 9
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
null69
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 References Sample Data Comment
Name QUIZ_DEFINITION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 4
(100.00%)
Unique YES
Referenced by FK columns
Table Column
QUIZ_DEFINITION_POOL QUIZ_DEFINITION_ID
UNIQUE_QUIZ QUIZ_DEFINITION_ID
USER_QUIZ QUIZ_DEFINITION_ID
ValueLengthCount
10001
10011
10021
10031
QUIZ_DEFINITION_ID
Name GRADING_SYSTEM_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
References PK column
Table Column
GRADING_SYSTEM GRADING_SYSTEM_ID
ValueLengthCount
null4
Primarry Key
Name QUIZ_CATEGORY_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
References PK column
Table Column
QUIZ_CATEGORY QUIZ_CATEGORY_ID
ValueLengthCount
null4
QUIZ_CATEGORY_ID
Name QUIZ_TEMPLATE_ID
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
References PK column
Table Column
QUIZ_TEMPLATE QUIZ_TEMPLATE_ID
ValueLengthCount
null4
QUIZ_TEMPLATE_ID
Name QUIZ_NAME
Ordinal # 5
Data Type NVARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality 4
(100.00%)
Unique YES
ValueLengthCount
History71
North American Geogr...231
Science71
Sport51
Name (Title) of this test.
Name QUIZ_DESCRIPTION
Ordinal # 6
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
Quiz Long Decsription
Name DEFAULT_DURATION
Ordinal # 7
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
Test duration in seconds. This is time available to complete the test once test instance started.
Name USERS_COMMENT
Ordinal # 8
Data Type NVARCHAR2[2000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique YES

N/A

USERS COMMENT
Name QUIZ_DEFINITION_STATUS
Ordinal # 9
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
A14
Examples: - Active - Inactive - Under Construction
Name NUM_OF_UNIQUE_TESTS
Ordinal # 10
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
14
Has to be minimum of 1.
Name POINTS_EASY
Ordinal # 11
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
54
POINTS_EASY
Name POINTS_MEDIUM
Ordinal # 12
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
104
POINTS_MEDIUM
Name POINTS_HARD
Ordinal # 13
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
154
POINTS_HARD
Name DURATION_EASY
Ordinal # 14
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
DURATION_EASY
Name DURATION_MEDIUM
Ordinal # 15
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
DURATION_MEDIUM
Name DURATION_HARD
Ordinal # 16
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
DURATION_HARD
Name DURATION_FACTOR
Ordinal # 17
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
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.
Name DEFAULT_ENABLED_FROM
Ordinal # 18
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
DEFAULT ENABLED FROM
Name DEFAULT_ENABLED_TO
Ordinal # 19
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
DEFAULT ENABLED TO
Name DISPLAY_ANSWER_IND
Ordinal # 20
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
Determines if the correct answer is displayed after every question is answered.
Name DISPLAY_CORRECT_IND
Ordinal # 21
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.
Name CREATE_TYPE
Ordinal # 22
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
GEN (Generated), MAN (Manual)
Name REPORT_TYPE
Ordinal # 23
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
OPA (On professor approval), IMM (Immediatly after finishing whole quiz) IQT (After every question - works only for wizard type of quiz)
Name LOOK_TYPE
Ordinal # 24
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
AOP (All questions on page), OPP (One question per page)
Name DURATION_TYPE
Ordinal # 25
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)
Name RESOLVE_TYPE
Ordinal # 26
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
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.
Name RAND_QUESTION_ORDER
Ordinal # 27
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
Indicates whether the order of questions is randomized when instance of the quiz is created.
Name RAND_ANSWER_ORDER
Ordinal # 28
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
Indicates whether the order of answers within the question is randomized when instance of the quiz is created.
Name RESULTS_DISPLAY_CODE
Ordinal # 29
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
?14
This code determines how the results are displayed: FUL (grade and preview), GRA (only grade)
Name CREATE_USER_ID
Ordinal # 30
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
04
CREATE USER ID
Name CREATE_DATETIME
Ordinal # 31
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 4
(100.00%)
Unique YES
ValueLengthCount
Sun Feb 23, 2014 09:51:06.00001
Sun Feb 23, 2014 09:51:08.00001
Sun Feb 23, 2014 09:51:09.00001
Sun Feb 23, 2014 09:51:10.00001
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 32
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 33
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
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 References Sample Data Comment
Name POOL_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
POOL POOL_ID

N/A

Pool of questions Primary Key
Name QUIZ_DEFINITION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. # 2
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUIZ_DEFINITION QUIZ_DEFINITION_ID

N/A

QUIZ_DEFINITION_ID
Name NUM_OF_HARD_QUESTIONS
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

NUM_OF_HARD_QUESTIONS
Name NUM_OF_MEDIUM_QUESTIONS
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

NUM_OF_MEDIUM_QUESTIONS
Name NUM_OF_EASY_QUESTIONS
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

NUM_OF_EASY_QUESTIONS
Name CUT_OFF_DATE
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique 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 References Sample Data Comment
Name QUIZ_EMAIL_ACTION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
EMAIL_SENT QUIZ_EMAIL_ACTION_ID

N/A

QUIZ_EMAIL ACTION_ID
Name QUIZ_INSTANCE_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUIZ_INSTANCE QUIZ_INSTANCE_ID

N/A

QUIZ_INSTANCE_ID
Name EMAIL_TEMPLATE_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
EMAIL_TEMPLATE EMAIL_TEMPLATE_ID

N/A

Specifies the template to be used to contruct the e-mail.
Name USER_ID
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
USERS USER_ID

N/A

USER ID
Name QUIZ_INSTANCE_STATUS
Ordinal # 5
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality N/A
Unique 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 References Sample Data Comment
Name QUIZ_INSTANCE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
QUIZ_EMAIL_ACTION QUIZ_INSTANCE_ID
QUIZ_RESULT QUIZ_INSTANCE_ID

N/A

QUIZ_INSTANCE_ID
Name UNIQUE_QUIZ_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
UNIQUE_QUIZ UNIQUE_QUIZ_ID

N/A

UNIQUE_QUIZ_ID
Name USER_ID_TESTED
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
USERS USER_ID

N/A

USER ID TESTED
Name COURSE_ID
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A
References PK column
Table Column
COURSE COURSE_ID

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.
Name CLASS_ID
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A
References PK column
Table Column
CLASS CLASS_ID

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.
Name DURATION
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION
Name ENABLED_FROM
Ordinal # 7
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

ENABLED FROM
Name ENABLED_TO
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

ENABLED TO
Name QUIZ_STARTED
Ordinal # 9
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Date and time when user started the quiz (received first question). This data will be used to calculate quiz duration.
Name QUIZ_FINISHED
Ordinal # 10
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

QUIZ FINISHED
Name QUIZ_INSTANCE_STATUS
Ordinal # 11
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Describes the status of the Quiz instance: - Not sent - Not attempted - Attempted No Report - Attempted With Report - Expired
Name ACTIVATION_DATETIME
Ordinal # 12
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique 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
Name RESOLVE_TYPE
Ordinal # 13
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name CREATE_USER_ID
Ordinal # 14
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 15
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 16
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 17
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name UNIQUE_QUIZ_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 2
Nullable NO
Cardinality 4
(3.31%)
Unique NO
References PK column
Table Column
UNIQUE_QUIZ UNIQUE_QUIZ_ID
ValueLengthCount
131
230
330
430
UNIQUE_QUIZ_ID
Name QUESTION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 121
(100.00%)
Unique YES
References PK column
Table Column
QUESTION QUESTION_ID
ValueLengthCount
50001
50011
50021
50031
50041
50051
50061
50071
50081
50091
QUESTION ID
Name QUESTION_ORDINAL_NUMBER
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 31
(25.62%)
Unique NO
ValueLengthCount
14
24
34
44
54
64
74
84
94
104
This is the number that determines order of the question in test. Lower numbers are displayed first in the test.
Name STATUS
Ordinal # 4
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
L1121
STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name FREQUENCY_FACTOR
Ordinal # 5
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name DURATION
Ordinal # 6
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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 References Sample Data Comment
Name QUIZ_RESULT_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
QUIZ_RESULT_ANSWER QUIZ_RESULT_ID

N/A

QUIZ RESULT ID
Name QUIZ_INSTANCE_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUIZ_INSTANCE QUIZ_INSTANCE_ID

N/A

QUIZ_INSTANCE_ID
Name QUESTION_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUESTION QUESTION_ID

N/A

QUESTION ID
Name ANSWER_TEXT
Ordinal # 4
Data Type NVARCHAR2[2000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name ANSWER_CLOB
Ordinal # 5
Data Type CLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

This field provides capability to create textual answers of unlimited length.
Name ANSWER_BLOB
Ordinal # 6
Data Type BLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

This field provides capability to create more "complex" answers that would invlove formuulas, specific tect formatting, diagrams, pictures, etc.
Name ANSWER_FEEDBACK
Ordinal # 7
Data Type VARCHAR2[2000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name NOT_SURE_FLAG
Ordinal # 8
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

NOT SURE FLAG
Name POINTS_ASSIGNED
Ordinal # 9
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name CREATE_USER_ID
Ordinal # 10
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 11
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 12
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 13
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name ANSWER_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
ANSWER ANSWER_ID

N/A

ANSWER ID
Name QUIZ_RESULT_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. # 2
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUIZ_RESULT QUIZ_RESULT_ID

N/A

QUIZ RESULT ID
Name TIME_TO_ANSWER
Ordinal # 3
Data Type NUMBER[8]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name QUIZ_TEMPLATE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
QUIZ_DEFINITION QUIZ_TEMPLATE_ID
QUIZ_TEMPLATE_POOL QUIZ_TEMPLATE_ID

N/A

QUIZ_TEMPLATE_ID
Name QUIZ_CATEGORY_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUIZ_CATEGORY QUIZ_CATEGORY_ID

N/A

QUIZ_CATEGORY_ID
Name GRADING_SYSTEM_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
GRADING_SYSTEM GRADING_SYSTEM_ID

N/A

Primarry Key
Name NUM_OF_UNIQUE_TESTS
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Has to be minimum of 1.
Name TEMPLATE_NAME
Ordinal # 5
Data Type NVARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Name (Title) of this template
Name TEMPLATE_DESCRIPTION
Ordinal # 6
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Quiz Long Decsription
Name TEMPLATE_STATUS
Ordinal # 7
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Examples: - Active - Inactive - Under Construction
Name POINTS_EASY
Ordinal # 8
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

POINTS_EASY
Name POINTS_MEDIUM
Ordinal # 9
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

POINTS_MEDIUM
Name POINTS_HARD
Ordinal # 10
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

POINTS_HARD
Name DURATION_EASY
Ordinal # 11
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION_EASY
Name DURATION_MEDIUM
Ordinal # 12
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION_MEDIUM
Name DURATION_HARD
Ordinal # 13
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION_HARD
Name DEFAULT_DURATION
Ordinal # 14
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Test duration in seconds. This is time available to complete the test once test instance started.
Name DISPLAY_ANSWER_IND
Ordinal # 15
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Determines if the correct answer is displayed after every question is answered.
Name DISPLAY_CORRECT_IND
Ordinal # 16
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.
Name REPORT_TYPE
Ordinal # 17
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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)
Name LOOK_TYPE
Ordinal # 18
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

AOP (All questions on page), OPP (One question per page)
Name DURATION_TYPE
Ordinal # 19
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)
Name DURATION_FACTOR
Ordinal # 20
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name RAND_QUESTION_ORDER
Ordinal # 21
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Indicates whether the order of questions is randomized when instance of the quiz is created.
Name RAND_ANSWER_ORDER
Ordinal # 22
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Indicates whether the order of answers within the question is randomized when instance of the quiz is created.
Name RESULTS_DISPLAY_CODE
Ordinal # 23
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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
Name CREATE_USER_ID
Ordinal # 24
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 25
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 26
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 27
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name POOL_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
POOL POOL_ID

N/A

Pool of questions Primary Key
Name QUIZ_TEMPLATE_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. # 2
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUIZ_TEMPLATE QUIZ_TEMPLATE_ID

N/A

QUIZ_TEMPLATE_ID
Name NUM_OF_HARD_QUESTIONS
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

NUM_OF_HARD_QUESTIONS
Name NUM_OF_MEDIUM_QUESTIONS
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

NUM_OF_MEDIUM_QUESTIONS
Name NUM_OF_EASY_QUESTIONS
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

NUM_OF_EASY_QUESTIONS
Name CUT_OFF_DATE
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique 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 References Sample Data Comment
Name REPORT_DEFINITION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
REPORT_INSTANCE REPORT_DEFINITION_ID

N/A

REPORT_DEFINITION_ID
Name REPORT_NAME
Ordinal # 2
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

REPORT_NAME
Name REPORT_DESCRIPTION
Ordinal # 3
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Report description with more details
Name DEFAULT_REPORT_TITLE
Ordinal # 4
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

This is title that will appear in the report.
Name DEFAULT_LOCATION
Ordinal # 5
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

This is the default location where report will be created in the file system
Name REPORT_FORMAT_CODE
Ordinal # 6
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Identifis the format of the report, for example: - PDF - Excel - Rich Text Format (RTF) - HTML
Name CREATE_USER_ID
Ordinal # 7
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 9
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 10
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name REPORT_INSTANCE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A

N/A

REPORT_INSTANCE_ID
Name REPORT_DEFINITION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
REPORT_DEFINITION REPORT_DEFINITION_ID

N/A

REPORT_DEFINITION_ID
Name REPORT_LOCATION
Ordinal # 3
Data Type VARCHAR2[1000]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Location of the report in the file system
Name COMMENT
Ordinal # 4
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name CREATE_USER_ID
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 6
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name REPORT_TITLE
Ordinal # 7
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name ROLE_CODE
Ordinal # 1
Data Type VARCHAR2[3]
PK Seq. # 1
Nullable NO
Cardinality 3
(100.00%)
Unique YES
Referenced by FK columns
Table Column
ROLE_FUNCTION ROLE_CODE
USER_ROLE ROLE_CODE
ValueLengthCount
ADM31
PRF31
STU31
ROLE CODE
Name ROLE_NAME
Ordinal # 2
Data Type VARCHAR2[50]
PK Seq. #
Nullable NO
Cardinality 3
(100.00%)
Unique YES
ValueLengthCount
Administrator131
Professor91
Student71
ROLE NAME
Name ROLE_DESCRIPTION
Ordinal # 3
Data Type VARCHAR2[400]
PK Seq. #
Nullable YES
Cardinality 3
(100.00%)
Unique YES
ValueLengthCount
Administartor of the...231
Professor91
Student71
ROLE_DESCRIPTION
Name GRANTABLE
Ordinal # 4
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 2
(66.67%)
Unique NO
ValueLengthCount
N12
Y11
If 'Y' then this Role can grant Roles to other users.
Name ENABLED
Ordinal # 5
Data Type CHAR[1]
PK Seq. #
Nullable NO
Cardinality 1
(33.33%)
Unique NO
ValueLengthCount
Y13
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 References Sample Data Comment
Name ROLE_CODE
Ordinal # 1
Data Type VARCHAR2[3]
PK Seq. # 1
Nullable NO
Cardinality 3
(33.33%)
Unique NO
References PK column
Table Column
ROLE ROLE_CODE
ValueLengthCount
ADM33
PRF33
STU33
ROLE CODE
Name FUNCTION_CODE
Ordinal # 2
Data Type VARCHAR2[3]
PK Seq. # 2
Nullable NO
Cardinality 3
(33.33%)
Unique NO
References PK column
Table Column
FUNCTION FUNCTION_CODE
ValueLengthCount
CHP33
LGN33
TAQ33
FUNCTION CODE
Name ENABLED
Ordinal # 3
Data Type CHAR[1]
PK Seq. #
Nullable NO
Cardinality 1
(11.11%)
Unique NO
ValueLengthCount
Y19
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 References Sample Data Comment
Name ST_ANSWER_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 605
(100.00%)
Unique YES
ValueLengthCount
41
81
121
161
201
241
281
321
361
401
ST_ANSWER_ID
Name ST_QUIZ_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 4
(0.66%)
Unique NO
References PK column
Table Column
ST_QUIZ ST_QUIZ_ID
ValueLengthCount
1155
2150
3150
4150
ST_QUIZ_ID
Name ARTIFICIAL_QUESTION_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 31
(5.12%)
Unique NO
ValueLengthCount
100120
100220
100320
100420
100520
100620
100720
100820
100920
101020
This is number assigned by user in order to link questions with answers in excel.
Name ANSWER_TEXT
Ordinal # 4
Data Type NVARCHAR2[2000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique YES

N/A

ANSWER_TEXT
Name ORDINAL_NUMBER
Ordinal # 5
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 5
(0.83%)
Unique NO
ValueLengthCount
2123
1121
4121
5121
3119
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.
Name CORRECT_ANSWER_IND
Ordinal # 6
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality 2
(0.33%)
Unique NO
ValueLengthCount
null0485
Y1120
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 References Sample Data Comment
Name EXCEL_ROW_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A

N/A

EXCEL_ROW_ID
Name COURSE_CODE
Ordinal # 2
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

COURSE_CODE
Name CATEGORY_NAME_1
Ordinal # 3
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_1
Name CATEGORY_NAME_2
Ordinal # 4
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_2
Name CATEGORY_NAME_3
Ordinal # 5
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_3
Name CATEGORY_NAME_4
Ordinal # 6
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_4
Name CATEGORY_NAME_5
Ordinal # 7
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_5
Name CATEGORY_NAME_6
Ordinal # 8
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_6
Name CATEGORY_NAME_7
Ordinal # 9
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_7
Name CATEGORY_NAME_8
Ordinal # 10
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_8
Name CATEGORY_NAME_9
Ordinal # 11
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_9
Name CATEGORY_NAME_10
Ordinal # 12
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

CATEGORY_NAME_10
Name CREATE_DATETIME
Ordinal # 13
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique 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 References Sample Data Comment
Name ST_QUESTION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 121
(100.00%)
Unique YES
ValueLengthCount
41
81
121
161
201
241
281
321
361
401
ST_QUESTION_ID
Name ARTIFICIAL_QUESTION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 31
(25.62%)
Unique NO
ValueLengthCount
10014
10024
10034
10044
10054
10064
10074
10084
10094
10104
This is number assigned by user in order to link questions with answers in excel.
Name ST_QUIZ_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 4
(3.31%)
Unique NO
References PK column
Table Column
ST_QUIZ ST_QUIZ_ID
ValueLengthCount
131
230
330
430
ST_QUIZ_ID
Name QUESTION_TEXT
Ordinal # 4
Data Type NVARCHAR2[2000]
PK Seq. #
Nullable NO
Cardinality N/A
Unique YES

N/A

QUESTION TEXT
Name PICTURE
Ordinal # 5
Data Type BLOB[4000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique YES

N/A

This is picture that is displayed with question.
Name DURATION
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name DIFFICULTY
Ordinal # 7
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name POINTS
Ordinal # 8
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 1
(0.83%)
Unique NO
ValueLengthCount
null121
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.
Name ORDINAL_NUMBER
Ordinal # 9
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality 31
(25.62%)
Unique NO
ValueLengthCount
14
24
34
44
54
64
74
84
94
104
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 References Sample Data Comment
Name ST_QUIZ_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 4
(100.00%)
Unique YES
Referenced by FK columns
Table Column
ST_ANSWER ST_QUIZ_ID
ST_QUESTION ST_QUIZ_ID
ValueLengthCount
11
21
31
41
ST_QUIZ_ID
Name USERNAME
Ordinal # 2
Data Type NVARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
zkukoljac94
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.
Name PASSWORD
Ordinal # 3
Data Type CHAR[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
zkukoljac2104
PASSWORD
Name USER_ID
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
USER ID
Name QUIZ_NAME
Ordinal # 5
Data Type NVARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality 4
(100.00%)
Unique YES
ValueLengthCount
History71
North American Geogr...231
Science71
Sport51
Name (Title) of this test.
Name DEFAULT_DURATION
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
Test duration in seconds. This is time available to complete the test once test instance started.
Name USERS_COMMENT
Ordinal # 7
Data Type NVARCHAR2[2000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique YES

N/A

USERS COMMENT
Name DEFAULT_ENABLED_FROM
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
DEFAULT ENABLED FROM
Name DEFAULT_ENABLED_TO
Ordinal # 9
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
DEFAULT ENABLED TO
Name RESULT_TRANSPARENCY
Ordinal # 10
Data Type VARCHAR2[20]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null04
RESULT TRANSPARENCY
Name DURATION_FACTOR
Ordinal # 11
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
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.
Name STATUS
Ordinal # 12
Data Type CHAR[1]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
L14
"S" - Loaded only in staging tables "L" - Loaded into permanent tables, data from stagin tables can be deleted
Name CREATE_USER_ID
Ordinal # 13
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
04
CREATE USER ID
Name CREATE_DATETIME
Ordinal # 14
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 4
(100.00%)
Unique YES
ValueLengthCount
Sun Feb 23, 2014 09:50:51.00001
Sun Feb 23, 2014 09:50:54.00001
Sun Feb 23, 2014 09:50:57.00001
Sun Feb 23, 2014 09:51:00.00001
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 References Sample Data Comment
Name EXCEL_ROW_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 69
(100.00%)
Unique YES
ValueLengthCount
101
201
301
401
501
601
701
801
901
1001
EXCEL_ROW_ID
Name CATEGORY_NAME_1
Ordinal # 2
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 8
(11.59%)
Unique NO
ValueLengthCount
Sports614
Hollywood 1013
Science711
History79
Geography97
Technology107
Philosophy104
Religion84
CATEGORY_NAME_1
Name CATEGORY_NAME_2
Ordinal # 3
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 29
(42.03%)
Unique NO
ValueLengthCount
Action movies138
null08
Cricket77
Biology74
Horror movies134
Physics74
Soccer64
Canada63
India53
Regions73
CATEGORY_NAME_2
Name CATEGORY_NAME_3
Ordinal # 4
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 26
(37.68%)
Unique NO
ValueLengthCount
null036
Latest66
1900s52
2000s52
South52
Australia91
Botany61
European81
Human51
India51
CATEGORY_NAME_3
Name CATEGORY_NAME_4
Ordinal # 5
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 3
(4.35%)
Unique NO
ValueLengthCount
null065
Actors62
Actresses92
CATEGORY_NAME_4
Name CATEGORY_NAME_5
Ordinal # 6
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 2
(2.90%)
Unique NO
ValueLengthCount
null067
Biography92
CATEGORY_NAME_5
Name CATEGORY_NAME_6
Ordinal # 7
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
null069
CATEGORY_NAME_6
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CATEGORY_NAME_7
Ordinal # 8
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
null069
CATEGORY_NAME_7
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CATEGORY_NAME_8
Ordinal # 9
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
null069
CATEGORY_NAME_8
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CATEGORY_NAME_9
Ordinal # 10
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
null069
CATEGORY_NAME_9
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CATEGORY_NAME_10
Ordinal # 11
Data Type VARCHAR2[50]
PK Seq. #
Nullable YES
Cardinality 1
(1.45%)
Unique NO
ValueLengthCount
null069
CATEGORY_NAME_10
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
Name CREATE_DATETIME
Ordinal # 12
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 4
(5.80%)
Unique NO
ValueLengthCount
Sun Feb 23, 2014 09:50:52.000027
Sun Feb 23, 2014 09:50:51.000017
Sun Feb 23, 2014 09:50:50.000014
Sun Feb 23, 2014 09:50:49.000011
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 References Sample Data Comment
Name SURVEY_DEFINITION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
SURVEY_INSTANCE SURVEY_DEFINITION_ID

N/A

SURVEY_DEFINITION_ID
Name GRADING_SYSTEM_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Primarry Key
Name SURVEY_CATEGORY_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

SURVEY_CATEGORY_ID
Name SURVEY_NAME
Ordinal # 4
Data Type NVARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Name (Title) of this test.
Name SURVEY_DESCRIPTION
Ordinal # 5
Data Type VARCHAR2[1000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Quiz Long Decsription
Name DEFAULT_DURATION
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Test duration in seconds. This is time available to complete the test once test instance started.
Name USERS_COMMENT
Ordinal # 7
Data Type NVARCHAR2[2000]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

USERS COMMENT
Name SURVEY_DEFINITION_STATUS
Ordinal # 8
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Examples: - Active - Inactive - Under Construction
Name POINTS_EASY
Ordinal # 9
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

POINTS_EASY
Name POINTS_MEDIUM
Ordinal # 10
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

POINTS_MEDIUM
Name POINTS_HARD
Ordinal # 11
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

POINTS_HARD
Name DURATION_EASY
Ordinal # 12
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION_EASY
Name DURATION_MEDIUM
Ordinal # 13
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION_MEDIUM
Name DURATION_HARD
Ordinal # 14
Data Type NUMBER[0]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION_HARD
Name DURATION_FACTOR
Ordinal # 15
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name DEFAULT_ENABLED_FROM
Ordinal # 16
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DEFAULT ENABLED FROM
Name DEFAULT_ENABLED_TO
Ordinal # 17
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DEFAULT ENABLED TO
Name DISPLAY_ANSWER_IND
Ordinal # 18
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Determines if the correct answer is displayed after every question is answered.
Name DISPLAY_CORRECT_IND
Ordinal # 19
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.
Name CREATE_TYPE
Ordinal # 20
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

GEN (Generated), MAN (Manual)
Name REPORT_TYPE
Ordinal # 21
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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)
Name LOOK_TYPE
Ordinal # 22
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

AOP (All questions on page), OPP (One question per page)
Name DURATION_TYPE
Ordinal # 23
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)
Name RESOLVE_TYPE
Ordinal # 24
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name RAND_QUESTION_ORDER
Ordinal # 25
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Indicates whether the order of questions is randomized when instance of the quiz is created.
Name RAND_ANSWER_ORDER
Ordinal # 26
Data Type CHAR[1]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Indicates whether the order of answers within the question is randomized when instance of the quiz is created.
Name RESULTS_DISPLAY_CODE
Ordinal # 27
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

This code determines how the results are displayed: FUL (grade and preview), GRA (only grade)
Name CREATE_USER_ID
Ordinal # 28
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 29
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 30
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 31
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name SURVEY_INSTANCE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
Referenced by FK columns
Table Column
SURVEY_QUESTION SURVEY_INSTANCE_ID

N/A

SURVEY_INSTANCE_ID
Name SURVEY_DEFINITION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
SURVEY_DEFINITION SURVEY_DEFINITION_ID

N/A

SURVEY_DEFINITION_ID
Name USER_ID_TESTED
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

USER ID TESTED
Name COURSE_ID
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name CLASS_ID
Ordinal # 5
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name DURATION
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

DURATION
Name ENABLED_FROM
Ordinal # 7
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

ENABLED FROM
Name ENABLED_TO
Ordinal # 8
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

ENABLED TO
Name QUIZ_STARTED
Ordinal # 9
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

Date and time when user started the quiz (received first question). This data will be used to calculate quiz duration.
Name QUIZ_FINISHED
Ordinal # 10
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

QUIZ FINISHED
Name QUIZ_INSTANCE_STATUS
Ordinal # 11
Data Type VARCHAR2[3]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

Describes the status of the Quiz instance: - Not sent - Not attempted - Attempted No Report - Attempted With Report - Expired
Name ACTIVATION_DATETIME
Ordinal # 12
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique 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
Name RESOLVE_TYPE
Ordinal # 13
Data Type VARCHAR2[3]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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.
Name CREATE_USER_ID
Ordinal # 14
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE USER ID
Name CREATE_DATETIME
Ordinal # 15
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 16
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 17
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name QUESTION_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
QUESTION QUESTION_ID

N/A

QUESTION ID
Name SURVEY_INSTANCE_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. # 2
Nullable NO
Cardinality N/A
Unique N/A
References PK column
Table Column
SURVEY_INSTANCE SURVEY_INSTANCE_ID

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 References Sample Data Comment
Name TIME_ZONE_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality N/A
Unique N/A

N/A

TIME_ZONE_ID
Name TIME_ZONE
Ordinal # 2
Data Type NUMBER[0]
PK Seq. #
Nullable NO
Cardinality N/A
Unique N/A

N/A

This is actualy difference from ZULU time (GMT).
Name TIME_ZONE_CODE
Ordinal # 3
Data Type VARCHAR2[10]
PK Seq. #
Nullable YES
Cardinality N/A
Unique N/A

N/A

For Example: "EST" "PST" etc.
Name TIME_ZONE_NAME
Ordinal # 4
Data Type VARCHAR2[100]
PK Seq. #
Nullable YES
Cardinality N/A
Unique 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 References Sample Data Comment
Name UNIQUE_QUIZ_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 4
(100.00%)
Unique YES
Referenced by FK columns
Table Column
QUIZ_INSTANCE UNIQUE_QUIZ_ID
QUIZ_QUESTION UNIQUE_QUIZ_ID
ValueLengthCount
11
21
31
41
UNIQUE_QUIZ_ID
Name QUIZ_DEFINITION_ID
Ordinal # 2
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 4
(100.00%)
Unique YES
References PK column
Table Column
QUIZ_DEFINITION QUIZ_DEFINITION_ID
ValueLengthCount
10001
10011
10021
10031
QUIZ_DEFINITION_ID
Name UNIQUE_QUIZ_NAME
Ordinal # 3
Data Type NVARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality 4
(100.00%)
Unique YES
ValueLengthCount
UNIQUE QUIZ NAME 1181
UNIQUE QUIZ NAME 2181
UNIQUE QUIZ NAME 3181
UNIQUE QUIZ NAME 4181
Name (Title) of this test.
Name CREATE_USER_ID
Ordinal # 4
Data Type NUMBER[10]
PK Seq. #
Nullable NO
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
04
CREATE USER ID
Name CREATE_DATETIME
Ordinal # 5
Data Type DATE[7]
PK Seq. #
Nullable NO
Cardinality 4
(100.00%)
Unique YES
ValueLengthCount
Sun Feb 23, 2014 09:51:07.00001
Sun Feb 23, 2014 09:51:08.00001
Sun Feb 23, 2014 09:51:09.00001
Sun Feb 23, 2014 09:51:10.00001
CREATE DATETIME
Name UPDATE_USER_ID
Ordinal # 6
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
UPDATE USER ID
Name UPDATE_DATETIME
Ordinal # 7
Data Type DATE[7]
PK Seq. #
Nullable YES
Cardinality 1
(25.00%)
Unique NO
ValueLengthCount
null4
UPDATE DATETIME


# 43
Table Name USERS
Owner YTM11
Type TABLE
Row Count 236
Remarks System users: - Testers - People being tested - Administrators

Column References Sample Data Comment
Name USER_ID
Ordinal # 1
Data Type NUMBER[10]
PK Seq. # 1
Nullable NO
Cardinality 236
(100.00%)
Unique YES
Referenced by FK columns
Table Column
ADDRESS USER_ID
QUIZ_EMAIL_ACTION USER_ID
QUIZ_INSTANCE USER_ID_TESTED
USERS_CLASS USER_ID
USERS_POOLS USER_ID
USER_ACTION_LOG USER_ID
USER_COURSE USER_ID
USER_PREFERENCES USER_ID
USER_QUIZ USER_ID
USER_ROLE USER_ID
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
USER ID
Name USERNAME
Ordinal # 2
Data Type NVARCHAR2[100]
PK Seq. #
Nullable NO
Cardinality 236
(100.00%)
Unique YES
ValueLengthCount
abono51
agibbs61
ahall51
akelly61
aliu41
aperry61
aroberts81
asmith61
cbagley71
cbagwell81
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.
Name LANGUAGE_ID
Ordinal # 3
Data Type NUMBER[10]
PK Seq. #
Nullable YES
Cardinality 2
(0.85%)
Unique NO
References PK column