YouTestMe Database Report


Feature Value
Connection Description YouTestMe Database
Analysis date 2014-02-23 09:51:53 PM EST
DB Analyzer software version 6.0
DB Analyzer software demo version No
Product Name Oracle
Database product name: Oracle
Catalog term:
Schema term: schema
Identifier Quote String: Oracle
Search String Escape: /
"Extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _): $#
Database Major Version: 11
Database Minor Version: 2
Database Product Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Driver Major Version: 11
Driver Name: Oracle JDBC driver
Driver Version: 11.2.0.3.0
Numeric Functions: ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, ROUND, SIGN, SIN, SQRT, TAN, TRUNCATE
String Functions ASCII, CHAR, CHAR_LENGTH, CHARACTER_LENGTH, CONCAT, LCASE, LENGTH, LTRIM, OCTET_LENGTH, REPLACE, RTRIM, SOUNDEX, SUBSTRING, UCASE
Database URL jdbc:oracle:thin:@zserver:1521:zoracle
User name used for this connection YTM11
Database is read only No
Database is case sensitive N
Data definition statement within a transaction forces the transaction to commit Y
Database ignores a data definition statement within a transaction N
String used to quote SQL identifiers "


Feature Value (zero means that there is no limit or the limit is not known)
Max Row Size: 0
Max Row Size includes BLOB(s) (includes the SQL data types LONGVARCHAR and LONGVARBINARY) Y
Max Table Name Length: 30
Max User Name Length: 30
Max Tables In Select 0
Maximum length (in hex characters) for a binary literal 1000
Maximum number of characters allowed in a catalog name 0
Maximum number of characters allowed for a character literal 2000
Maximum number of characters this database allows for a column name 30
Maximum number of columns this database allows in a GROUP BY clause 0
Maximum number of columns this database allows in an index 32
Maximum number of columns this database allows in an ORDER BY clause 0
Maximum number of columns this database allows in a SELECT list 0
Maximum number of columns this database allows in a table 1000
Maximum number of concurrent connections to this database that are possible 0
Maximum number of characters that this database allows in a cursor name 0
Maximum number of characters that this database allows in a cursor name 0
Maximum number of characters that this database allows in a procedure name 30
Maximum number of characters that this database allows in a schema name 30
Maximum number of characters this database allows in an SQL statement 65535
Maximum number of active statements to this database that can be open at the same time 0


Feature Supported
Mixed Case Identifiers N
Mixed Case Quoted Identifiers Y
Alter Table With Add Column Y
Alter Table With Drop Column N
Column Aliasing Y
Convert N
Table Correlation Names Y
Different Table Correlation Names Y
Expressions in Order By Y
Order By Unrelated Y
Group by Y
Group by Unrelated Y
Group by Beyond Select Y
Like Escape Clause Y
Multiple Result Sets N
Multiple Transactions Y
Non Nullable Columns Y
Minimum SQL Grammar Y
Core SQL Grammar Y
Extended SQL Grammar Y
ANSI 92 Entry Level SQL Y
ANSI 92 Intermediate SQL N
ANSI 92 Full SQL N
Integrity Enhancement Facility Y
Outer Joins Y
Full Outer Joins Y
Limited Outer Joins Y
Schemas in Data Manipulation Y
Schemas in Procedure Calls Y
Schemas in Table Definitions Y
Schemas in Index Definitions Y
Schemas in Privilege Definitions Y
Catalogs in Data Manipulation N
Catalogs in Procedure Calls N
Catalogs in Table Definitions N
Catalogs in Index Definitions N
Catalogs in Privilege Definitions N
Positioned Delete N
Positioned Update N
Select for Update Y
Stored Procedures Y
Subqueries in Comparisons Y
Subqueries in Exists Y
Subqueries in Ins Y
Subqueries in Quantifieds Y
Correlated Subqueries Y
Union Y
Union All Y
Open Cursors Across Commit N
Open Cursors Across Rollback N
Open Statements Across Commit N
OpenStatements Across Rollback N
Transactions Y
Transaction Isolation Level Y
Data Definition and Data Manipulation Transactions Y
Supports only data manipulation statements within a transaction Y
Batch Updates Y
Savepoints Y
Named SessionParameters Y
Multiple Open Results N
Get Generated Keys Y
Statement Pooling Y
Result Set Type: Forward Only Y
Result Set Type: Scroll Insensitive Y
Result Set Type: Scroll Sensitive Y
Result Set Type: Forward Only Read Only Y
Result Set Type: Forward Only Updateable Y
Result Set Type: Scroll Insensitive Read Only Y
Result Set Type: Scroll Insensitive Updateable Y
Result Set Concurrency: Scroll Sensitive Read Only Y
Result Set Concurrency: Scroll Sensitive Updateable Y
Batch Updates Y
Named SessionParameters Y
Multiple Open Results N
Get Generated Keys Y
Result Set Holdability: Hold Cursos Over Commit Y
Result Set Holdability: Close Cursors At Commit N


# Database
1. DEFAULT_DATABASE


Database DEFAULT_DATABASE Schema
1. ANONYMOUS
2. APEX_030200
3. APEX_PUBLIC_USER
4. APPQOSSYS
5. BI
6. CTXSYS
7. DBSNMP
8. DIP
9. EXFSYS
10. FLOWS_FILES
11. GDAODEMO
12. HR
13. IX
14. LOUI
15. MDDATA
16. MDSYS
17. MGMT_VIEW
18. OE
19. OLAPSYS
20. ORACLE_OCM
21. ORDDATA
22. ORDPLUGINS
23. ORDSYS
24. OUTLN
25. OWBSYS
26. OWBSYS_AUDIT
27. PM
28. SCOTT
29. SH
30. SI_INFORMTN_SCHEMA
31. SPATIAL_CSW_ADMIN_USR
32. SPATIAL_WFS_ADMIN_USR
33. SYS
34. SYSMAN
35. SYSTEM
36. WMSYS
37. XDB
38. XS$NULL
39. YOUTESTME
40. YTM1
41. YTM10
42. YTM11
43. YTM12
44. YTM13
45. YTM14
46. YTM15
47. YTM16
48. YTM17
49. YTM18
50. YTM19
51. YTM2
52. YTM20
53. YTM3
54. YTM4
55. YTM5
56. YTM6
57. YTM7
58. YTM8
59. YTM9
60. ZDBA
61. ZORAN
62. ZORAN1
63. ZORAN2
64. ZORAN3


Schema
YTM11
Table Type Rows Columns
1. ADDRESS TABLE 0 22
2. ANSWER TABLE 605 10
3. CLASS TABLE 25 11
4. CLASS_COURSE TABLE 93 6
5. CODE TABLE 71 6
6. CODE_TYPE TABLE 24 4
7. COURSE TABLE 65 16
8. DOCUMENT TABLE 0 11
9. EMAIL_SENT TABLE 0 4
10. EMAIL_TEMPLATE TABLE 0 2
11. FUNCTION TABLE 14 4
12. GRADING_SYSTEM TABLE 0 7
13. GRADING_SYSTEM_LABEL TABLE 0 10
14. LANGUAGE TABLE 72 3
15. ORGANIZATION TABLE 0 10
16. POOL TABLE 70 8
17. POOL_QUESTION TABLE 0 2
18. QUESTION TABLE 121 18
19. QUIZ_CATEGORY TABLE 69 9
20. QUIZ_DEFINITION TABLE 4 33
21. QUIZ_DEFINITION_POOL TABLE 0 6
22. QUIZ_EMAIL_ACTION TABLE 0 5
23. QUIZ_INSTANCE TABLE 0 17
24. QUIZ_QUESTION TABLE 121 6
25. QUIZ_RESULT TABLE 0 13
26. QUIZ_RESULT_ANSWER TABLE 0 3
27. QUIZ_TEMPLATE TABLE 0 27
28. QUIZ_TEMPLATE_POOL TABLE 0 6
29. REPORT_DEFINITION TABLE 0 10
30. REPORT_INSTANCE TABLE 0 7
31. ROLE TABLE 3 5
32. ROLE_FUNCTION TABLE 9 3
33. ST_ANSWER TABLE 605 6
34. ST_COURSE TABLE 0 13
35. ST_QUESTION TABLE 121 9
36. ST_QUIZ TABLE 4 14
37. ST_QUIZ_CATEGORY TABLE 69 12
38. SURVEY_DEFINITION TABLE 0 31
39. SURVEY_INSTANCE TABLE 0 17
40. SURVEY_QUESTION TABLE 0 2
41. TIME_ZONE TABLE 0 4
42. UNIQUE_QUIZ TABLE 4 7
43. USERS TABLE 236 28
44. USERS_CLASS TABLE 5,900 3
45. USERS_POOLS TABLE 0 3
46. USER_ACTION_LOG TABLE 0 5
47. USER_COURSE TABLE 13,924 3
48. USER_PREFERENCES TABLE 0 15
49. USER_QUIZ TABLE 0 3
50. USER_ROLE TABLE 236 3
51. V_CLASS_COURSE VIEW N/A 30
52. V_CODES VIEW N/A 6
53. V_COURSES VIEW N/A 16
54. V_COURSES_SUM VIEW N/A 18
55. V_DOCUMENT VIEW N/A 11
56. V_POOLS_SUM VIEW N/A 10
57. V_POOL_QUESTION_INFO VIEW N/A 3
58. V_POOL_QUESTION_SUM VIEW N/A 3
59. V_QUESTIONS_IN_POOLS VIEW N/A 8
60. V_QUIZ VIEW N/A 36
61. V_QUIZ_CATEGORIES VIEW N/A 9
62. V_QUIZ_CATEGORIES_SUM VIEW N/A 11
63. V_QUIZ_CATEGORIES_SUM2 VIEW N/A 11
64. V_QUIZ_RESULT VIEW N/A 37
65. V_QUIZ_RESULT_SUM VIEW N/A 5
66. V_ROLES_PERMISSIONS VIEW N/A 10
67. V_ST_QUIZ VIEW N/A 27
68. V_SUBCAT_AND_COURSES_SUM VIEW N/A 2
69. V_USER_ACTIONS VIEW N/A 4
70. V_USER_CLASS VIEW N/A 19
71. V_USER_CLASS_COURSE VIEW N/A 28
72. V_USER_COURSE VIEW N/A 25
73. V_USER_COURSE_ROLE VIEW N/A 5
74. V_USER_COURSE_TREE VIEW N/A 27
75. V_USER_POOLS VIEW N/A 16
76. V_USER_POOLS_TREE VIEW N/A 19
77. V_USER_POOL_SUM_QUESTIONS VIEW N/A 8
78. V_USER_ROLES VIEW N/A 13
79. V_USER_ROLES_PERMISSIONS VIEW N/A 18


Detailed Table Information



# 1
Table Name ADDRESS
Owner YTM11
Type TABLE
Row Count 0
Remarks ADDRESS
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. ADDRESS_ID NUMBER[10] 1 NO N/A N/A

N/A

ADDRESS ID
2. USER_ID NUMBER[10] NO N/A N/A

N/A

USER ID
3. STREET VARCHAR2[100] NO N/A N/A

N/A

STREET
4. ADDITIONAL_ADDRESS_INFORMATION VARCHAR2[200] YES N/A N/A

N/A

ADDITIONAL ADDRESS INFORMATION
5. BUILDING_NUMBER VARCHAR2[10] YES N/A N/A

N/A

BUILDING NUMBER
6. UNIT VARCHAR2[10] YES N/A N/A

N/A

This is apartment or townhouse number. It may have an alphanumeric values such as "PH 4" (penthouse #4)
7. CITY VARCHAR2[50] NO N/A N/A

N/A

CITY
8. POSTAL_CODE VARCHAR2[10] YES N/A N/A

N/A

This field will contain: Postal Code (Canada) ZIP (US) Postanski Broj (Balkan countries) Equivalent information for other countries
9. STATE VARCHAR2[50] YES N/A N/A

N/A

STATE
10. COUNTRY VARCHAR2[50] NO N/A N/A

N/A

COUNTRY
11. ADDRESS_URL VARCHAR2[1000] YES N/A N/A

N/A

URL of the Address. For example, GOOGLE mal URL.
12. ADDRESS_TYPE CHAR[1] NO N/A N/A

N/A

P - Personal (Home) B - Business (Office)
13. SHIPPING_ADDRESS_IND CHAR[1] YES N/A N/A

N/A

Indicated if this is a shipping address.
14. BILLING_ADDRESS_IND CHAR[1] YES N/A N/A

N/A

Indicates if this is a Billing address
15. SHIPP_BILL_ADR_SAME_IND CHAR[1] YES N/A N/A

N/A

Indicates if shipping and billing addresses are the same
16. ACTIVE_FROM DATE[7] NO N/A N/A

N/A

ACTIVE FROM
17. ACTIVE_TO DATE[7] YES N/A N/A

N/A

In this value is NULL then this recor represents the current address
18. ADDRESS_STATUS VARCHAR2[3] YES N/A N/A

N/A

Status of this address
19. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
20. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
21. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
22. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


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

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

N/A

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

N/A

This is additional inforamtion that can be used to explain the answer. It may be used for educational purposes.
7. CREATE_USER_ID NUMBER[10] NO NO 1
(0.17%)
ValueLengthCount
0605
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
8. CREATE_DATETIME DATE[7] NO NO 5
(0.83%)
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
9. UPDATE_USER_ID NUMBER[10] YES NO 1
(0.17%)
ValueLengthCount
null605
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
10. UPDATE_DATETIME DATE[7] YES NO 1
(0.17%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. CLASS_ID NUMBER[10] 1 NO YES 25
(100.00%)
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
CLASS_ID
2. CLASS_NAME VARCHAR2[200] NO YES 25
(100.00%)
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
3. CLASS_CODE VARCHAR2[30] YES NO 1
(4.00%)
ValueLengthCount
null025
CLASS_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
4. CLASS_DESCRIPTION VARCHAR2[1000] YES NO 1
(4.00%)
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.
5. ACTIVE_FROM DATE[7] YES NO 5
(20.00%)
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.
6. ACTIVE_TO DATE[7] YES YES 25
(100.00%)
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.
7. CLASS_STATUS VARCHAR2[3] YES NO 1
(4.00%)
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.
8. CREATE_USER_ID NUMBER[10] NO NO 1
(4.00%)
ValueLengthCount
125
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
9. CREATE_DATETIME DATE[7] NO NO 2
(8.00%)
ValueLengthCount
Sun Feb 23, 2014 09:50:47.000024
Sun Feb 23, 2014 09:50:46.00001
CREATE DATETIME
10. UPDATE_USER_ID NUMBER[10] YES NO 1
(4.00%)
ValueLengthCount
null25
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
11. UPDATE_DATETIME DATE[7] YES NO 1
(4.00%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. CLASS_ID NUMBER[10] 1 NO NO 3
(3.23%)
ValueLengthCount
131
231
331
CLASS_ID
2. COURSE_ID NUMBER[10] 2 NO NO 31
(33.33%)
ValueLengthCount
23
33
43
53
63
73
83
93
263
273
COURSE_ID
3. CREATE_USER_ID NUMBER[10] NO NO 1
(1.08%)
ValueLengthCount
093
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
4. CREATE_DATETIME DATE[7] NO NO 2
(2.15%)
ValueLengthCount
Sun Feb 23, 2014 09:51:14.000086
Sun Feb 23, 2014 09:51:13.00007
CREATE DATETIME
5. UPDATE_USER_ID NUMBER[10] YES NO 1
(1.08%)
ValueLengthCount
null93
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
6. UPDATE_DATETIME DATE[7] YES NO 1
(1.08%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. CODE_ID VARCHAR2[3] 1 NO YES 71
(100.00%)
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?")
2. CODE_TYPE_ID VARCHAR2[3] NO NO 23
(32.39%)
ValueLengthCount
QST38
QUT37
USS35
QAS34
QDS34
AST33
COS33
CST33
DUT33
ESS33
CODE TYPE ID
3. CODE_NAME VARCHAR2[50] NO NO 60
(84.51%)
ValueLengthCount
ACTIVE64
DELETED73
CANCELLED92
DEFFERED82
EXPIRED72
INACTIVE82
MANAGER72
SUSPENDED92
ADMINISTRATOR131
ALL ON PAGE111
CODE NAME
4. CODE_DESCRIPTION VARCHAR2[200] NO NO 65
(91.55%)
ValueLengthCount
Active64
Cancelled92
Deleted72
Inactive82
ATTEMPTED NO REPORT191
ATTEMPTED WITH REPOR...231
Administrator131
All questions on one...231
Alternate91
Assigned81
CODE DESCRIPTION
5. CODE_LONG_DESCRIPTION VARCHAR2[1000] YES NO 1
(1.41%)
ValueLengthCount
null071
CODE LONG DESCRIPTION
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
6. ALTERNATE_CODE_VALUE VARCHAR2[50] YES NO 1
(1.41%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. CODE_TYPE_ID VARCHAR2[3] 1 NO YES 24
(100.00%)
ValueLengthCount
ADT31
AST31
COS31
CRT31
CST31
DUT31
ESS31
GEN31
LOT31
QAS31
CODE TYPE ID
2. CODE_TYPE_NAME VARCHAR2[50] NO YES 24
(100.00%)
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
3. CODE_TYPE_DESCRIPTION VARCHAR2[200] NO YES 24
(100.00%)
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
4. CODE_TYPE_LONG_DESCRIPTION VARCHAR2[1000] YES NO 1
(4.17%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. COURSE_ID NUMBER[10] 1 NO YES 65
(100.00%)
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
COURSE_ID
2. PARENT_COURSE_ID NUMBER[10] YES NO 16
(24.62%)
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.
3. COURSE_NAME VARCHAR2[300] NO YES 65
(100.00%)
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
4. COURSE_CODE VARCHAR2[30] YES NO 51
(78.46%)
ValueLengthCount
null015
ASTA01H381
ASTA02H381
ASTB03H381
ASTB23H381
ASTC25H381
ASTD01H381
ASTD02H381
BIOA01H381
BIOA02H381
Code may have a code used by the school.
5. COURSE_STATUS VARCHAR2[3] YES NO 1
(1.54%)
ValueLengthCount
ACE365
COURSE_STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
6. CATEGORY_LEVEL NUMBER[0] NO NO 3
(4.62%)
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.
7. COURSE_DESCRIPTION VARCHAR2[2000] NO YES N/A

N/A

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

N/A

DOCUMENT ID
2. DOCUMENT_TITLE VARCHAR2[400] NO N/A N/A

N/A

DOCUMENT TITLE
3. DOCUMENT_DESCRIPTION VARCHAR2[2000] NO N/A N/A

N/A

DOCUMENT DESCRIPTION
4. DOCUMENT_BINARY_CONTENT BLOB[4000] YES N/A N/A

N/A

DOCUMENT BINARY CONTENT
5. DOCUMENT_CHAR_CONTENT CLOB[4000] YES N/A N/A

N/A

DOCUMENT CHAR CONTENT
6. FILE_NAME VARCHAR2[400] YES N/A N/A

N/A

FILE_NAME
7. FILE_PATH VARCHAR2[400] YES N/A N/A

N/A

document path to in the file system. This can be source or destination path.
8. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
9. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
10. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
11. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 9
Table Name EMAIL_SENT
Owner YTM11
Type TABLE
Row Count 0
Remarks Records every email sent.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. EMAIL_SENT_ID NUMBER[10] 1 NO N/A N/A

N/A

EMAIL_SENT_ID
2. QUIZ_EMAIL_ACTION_ID NUMBER[10] NO N/A N/A

N/A

QUIZ_EMAIL ACTION_ID
3. EVENT_DATE_TIME DATE[7] NO N/A N/A

N/A

EVENT_DATE_TIME
4. EMAIL_SENT_STATUS VARCHAR2[3] YES N/A N/A

N/A

Email Sent Status


# 10
Table Name EMAIL_TEMPLATE
Owner YTM11
Type TABLE
Row Count 0
Remarks Template of the e-mail. Contain the textual template of the e-mail which is used to contruct the e-mail to be sent to the user.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. EMAIL_TEMPLATE_ID NUMBER[10] 1 NO N/A N/A

N/A

EMAIL_TEMPLATE_ID
2. EMAIL_TEMPLATE BLOB[4000] YES N/A N/A

N/A

Email template may be in a rich text format.


# 11
Table Name FUNCTION
Owner YTM11
Type TABLE
Row Count 14
Remarks Permission to accss or execute certain functionality of the system. For example: 1. Create User 2. Delete user 3. Create Quiz 4. Reports

# Column Type PK Null Unique Cardinality Sample Data Comment
1. FUNCTION_CODE VARCHAR2[3] 1 NO YES 14
(100.00%)
ValueLengthCount
CCL31
CHP31
COD31
CPD31
CRC31
CRQ31
CRR31
CRU31
EDC31
EDE31
FUNCTION CODE
2. FUNCTION_NAME VARCHAR2[50] NO YES 14
(100.00%)
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
3. FUNCTION_DESCRIPTION VARCHAR2[400] YES YES 14
(100.00%)
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.
4. ENABLED CHAR[1] NO NO 1
(7.14%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. GRADING_SYSTEM_ID NUMBER[10] 1 NO N/A N/A

N/A

Primarry Key
2. GRADING_SYSTEM_NAME VARCHAR2[50] NO N/A N/A

N/A

GRADING_SYSTEM_NAME
3. GRADING_SYSTEM_DESCRIPTION VARCHAR2[1000] NO N/A N/A

N/A

GRADING_SYSTEM_DESCRIPTION
4. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
5. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
6. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
7. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 13
Table Name GRADING_SYSTEM_LABEL
Owner YTM11
Type TABLE
Row Count 0
Remarks GRADING_SYSTEM_LABEL
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. GRADING_SYSTEM_LABEL_ID NUMBER[10] 1 NO N/A N/A

N/A

Primary Key
2. GRADING_SYSTEM_ID NUMBER[10] NO N/A N/A

N/A

Primarry Key
3. GRADING_SYSTEM_LABEL_CODE VARCHAR2[50] NO N/A N/A

N/A

GRADING_SYSTEM_LABEL_CODE
4. GRADING_SYSTEM_LABEL_NAME VARCHAR2[50] NO N/A N/A

N/A

GRADING_SYSTEM_LABEL_NAME
5. PERCENT_MINIMUM NUMBER[0] NO N/A N/A

N/A

PERCENT_MINIMUM
6. PERCENT_MAXIMUM NUMBER[0] NO N/A N/A

N/A

PERCENT_MAXIMUM
7. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
8. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
9. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
10. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


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

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

N/A

ORGANIZATION ID
2. PARENT_ORGANIZATION_ID NUMBER[10] YES N/A N/A

N/A

PARENT_ORGANIZATION_ID
3. ORGANIZATION_NAME VARCHAR2[250] NO N/A N/A

N/A

ORGANIZATION NAME
4. ORGANIZATION_DESCRIPTION NVARCHAR2[250] YES N/A N/A

N/A

ORGANIZATION DESCRIPTION
5. ORGANIZATION_CATEGORY_CODE VARCHAR2[3] YES N/A N/A

N/A

Identifies category og organization: - Univesity - College - Community College - High School - Commercial - Manufacturing
6. ORGANIZATION_STATUS VARCHAR2[3] NO N/A N/A

N/A

Status of the Organization: - Active - Inactive - Deleted
7. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
8. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
9. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
10. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 16
Table Name POOL
Owner YTM11
Type TABLE
Row Count 70
Remarks Pool of questions. Users can create their own pool of questions and use them later to make tests.

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

N/A

QUESTION ID
2. POOL_ID NUMBER[10] 2 NO N/A N/A

N/A

Pool of questions Primary Key


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

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUESTION_ID NUMBER[10] 1 NO YES 121
(100.00%)
ValueLengthCount
50001
50011
50021
50031
50041
50051
50061
50071
50081
50091
QUESTION ID
2. QUESTION_TEXT NVARCHAR2[2000] NO YES N/A

N/A

QUESTION TEXT
3. QUESTION_BLOB BLOB[4000] YES YES N/A

N/A

This field is used to create more complex questions, for example: - formatted text - formulas - videos - sounds - animations - diagrams
4. PICTURE BLOB[4000] YES YES N/A

N/A

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

N/A

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

N/A

Pool of questions Primary Key
2. QUIZ_DEFINITION_ID NUMBER[10] 2 NO N/A N/A

N/A

QUIZ_DEFINITION_ID
3. NUM_OF_HARD_QUESTIONS NUMBER[10] NO N/A N/A

N/A

NUM_OF_HARD_QUESTIONS
4. NUM_OF_MEDIUM_QUESTIONS NUMBER[10] NO N/A N/A

N/A

NUM_OF_MEDIUM_QUESTIONS
5. NUM_OF_EASY_QUESTIONS NUMBER[10] NO N/A N/A

N/A

NUM_OF_EASY_QUESTIONS
6. CUT_OFF_DATE NUMBER[10] NO N/A N/A

N/A

CUT_OFF_DATE


# 22
Table Name QUIZ_EMAIL_ACTION
Owner YTM11
Type TABLE
Row Count 0
Remarks Email is sent to certain recipients (User_id) when Quiz Instance changes the Status. Foe example: - student can receive e-mail from the system when quiz is assigned to him/her - professor may receive e-mail from the system when studen compoletes the quiz
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_EMAIL_ACTION_ID NUMBER[10] 1 NO N/A N/A

N/A

QUIZ_EMAIL ACTION_ID
2. QUIZ_INSTANCE_ID NUMBER[10] NO N/A N/A

N/A

QUIZ_INSTANCE_ID
3. EMAIL_TEMPLATE_ID NUMBER[10] NO N/A N/A

N/A

Specifies the template to be used to contruct the e-mail.
4. USER_ID NUMBER[10] NO N/A N/A

N/A

USER ID
5. QUIZ_INSTANCE_STATUS VARCHAR2[3] NO N/A N/A

N/A

e-Mail is sent when the Quiz Instance changes status to this value.


# 23
Table Name QUIZ_INSTANCE
Owner YTM11
Type TABLE
Row Count 0
Remarks Occurance of the particular Quiz. Whenever somebody takes a test a record is created in this table.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_INSTANCE_ID NUMBER[10] 1 NO N/A N/A

N/A

QUIZ_INSTANCE_ID
2. UNIQUE_QUIZ_ID NUMBER[10] NO N/A N/A

N/A

UNIQUE_QUIZ_ID
3. USER_ID_TESTED NUMBER[10] NO N/A N/A

N/A

USER ID TESTED
4. COURSE_ID NUMBER[10] YES N/A N/A

N/A

This quiz is taken as a part of this Course. Both COURSE_ID and CLASS_ID are optional in this table ant they link to COURSE and CLASS table (vs. CLASS_COURSE) and this is done intentionaly for maximum flexibility. If the FKs are linked to CLASS that would impose that class has to belong to the course which may ne the situation when test is taken but the it may change after that. This is one scenario. In any case this is done for maximum flexibility.
5. CLASS_ID NUMBER[10] YES N/A N/A

N/A

User tested may belong to the class. THis class may be independent of course (may not belong to the course at all). This is done for maximum flexibility.
6. DURATION NUMBER[10] YES N/A N/A

N/A

DURATION
7. ENABLED_FROM DATE[7] YES N/A N/A

N/A

ENABLED FROM
8. ENABLED_TO DATE[7] YES N/A N/A

N/A

ENABLED TO
9. QUIZ_STARTED DATE[7] YES N/A N/A

N/A

Date and time when user started the quiz (received first question). This data will be used to calculate quiz duration.
10. QUIZ_FINISHED DATE[7] YES N/A N/A

N/A

QUIZ FINISHED
11. QUIZ_INSTANCE_STATUS VARCHAR2[3] NO N/A N/A

N/A

Describes the status of the Quiz instance: - Not sent - Not attempted - Attempted No Report - Attempted With Report - Expired
12. ACTIVATION_DATETIME DATE[7] NO N/A N/A

N/A

Indicates when this quiz instance is activated. Quiz instance has to be activated in order for person to take the quiz. When QUIZ_INSTANCE is activated all quations linked to this QUIZ_INSTANCE record are marked as "read only" (QUESTION.READ_ONLY_IND is set to "Y") Questions with QUESTION.READ_ONLY_IND set to "Y" cannot be edited any more. Quiz can be taken by individual if: 1. QUIZ_INSTANCE.ACTIVATION_DATETIME is not null (quiz instance is activated and questions are locked) 2. QUIZ_INSTANCE.ENABLED_FROM is greated than SYSDATE 3. QUIZ_INSTANCE.ENABLED_FROM is lesser than SYSDATE
13. RESOLVE_TYPE VARCHAR2[3] YES N/A N/A

N/A

Shows if quiz contains questions that need to be resolved by professor himself. QRY - quiz can be resolved by system QRN- quiz cannot be resolved by system - must professor.
14. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
15. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
16. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
17. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 24
Table Name QUIZ_QUESTION
Owner YTM11
Type TABLE
Row Count 121
Remarks Associative table. All User's questions will become available to be associated with other tests so that is why we have this associative table.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. UNIQUE_QUIZ_ID NUMBER[10] 2 NO NO 4
(3.31%)
ValueLengthCount
131
230
330
430
UNIQUE_QUIZ_ID
2. QUESTION_ID NUMBER[10] 1 NO YES 121
(100.00%)
ValueLengthCount
50001
50011
50021
50031
50041
50051
50061
50071
50081
50091
QUESTION ID
3. QUESTION_ORDINAL_NUMBER NUMBER[10] YES NO 31
(25.62%)
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.
4. STATUS VARCHAR2[3] NO NO 1
(0.83%)
ValueLengthCount
L1121
STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
5. FREQUENCY_FACTOR NUMBER[0] YES NO 1
(0.83%)
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.
6. DURATION NUMBER[0] YES NO 1
(0.83%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_RESULT_ID NUMBER[10] 1 NO N/A N/A

N/A

QUIZ RESULT ID
2. QUIZ_INSTANCE_ID NUMBER[10] NO N/A N/A

N/A

QUIZ_INSTANCE_ID
3. QUESTION_ID NUMBER[10] NO N/A N/A

N/A

QUESTION ID
4. ANSWER_TEXT NVARCHAR2[2000] YES N/A N/A

N/A

This field is reserved for questions that require free form text answer. Answer entered by candidate taking test will be saved in this field.
5. ANSWER_CLOB CLOB[4000] YES N/A N/A

N/A

This field provides capability to create textual answers of unlimited length.
6. ANSWER_BLOB BLOB[4000] YES N/A N/A

N/A

This field provides capability to create more "complex" answers that would invlove formuulas, specific tect formatting, diagrams, pictures, etc.
7. ANSWER_FEEDBACK VARCHAR2[2000] YES N/A N/A

N/A

This is the feedback from the examiner on the given answer. examiner may not be able to change Answer text but he/she can write a feedback on the answer.
8. NOT_SURE_FLAG CHAR[1] YES N/A N/A

N/A

NOT SURE FLAG
9. POINTS_ASSIGNED NUMBER[10] YES N/A N/A

N/A

This is number of points assigned by examiner after evaluating the answer. It overrides default number of points in table Answers. Also it is used for free form text answers.
10. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
11. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
12. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
13. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 26
Table Name QUIZ_RESULT_ANSWER
Owner YTM11
Type TABLE
Row Count 0
Remarks Associative table with Quiz Results. The reson why this table is required is because this is many to many relatiosnhip because: One question can have a multiple answers - for example: "Check all that apply" on multiple choices test. Every test occurence has test results. Test results consist of list of questions answered and associated answers. There may be questions witth multiple answers.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. ANSWER_ID NUMBER[10] 1 NO N/A N/A

N/A

ANSWER ID
2. QUIZ_RESULT_ID NUMBER[10] 2 NO N/A N/A

N/A

QUIZ RESULT ID
3. TIME_TO_ANSWER NUMBER[8] YES N/A N/A

N/A

Time that user has taken to answer the question - for stats.


# 27
Table Name QUIZ_TEMPLATE
Owner YTM11
Type TABLE
Row Count 0
Remarks This table is used as a template for making the quiz definition. Several quizzes definitions can be linked to one template. It is analogy similar to CLASS and OBJECT. QUIZ_TEMPLATE is CLASS, QUIZ_DEFINITION is OBJECT.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_TEMPLATE_ID NUMBER[10] 1 NO N/A N/A

N/A

QUIZ_TEMPLATE_ID
2. QUIZ_CATEGORY_ID NUMBER[10] NO N/A N/A

N/A

QUIZ_CATEGORY_ID
3. GRADING_SYSTEM_ID NUMBER[10] NO N/A N/A

N/A

Primarry Key
4. NUM_OF_UNIQUE_TESTS NUMBER[10] NO N/A N/A

N/A

Has to be minimum of 1.
5. TEMPLATE_NAME NVARCHAR2[100] NO N/A N/A

N/A

Name (Title) of this template
6. TEMPLATE_DESCRIPTION VARCHAR2[1000] YES N/A N/A

N/A

Quiz Long Decsription
7. TEMPLATE_STATUS VARCHAR2[3] NO N/A N/A

N/A

Examples: - Active - Inactive - Under Construction
8. POINTS_EASY NUMBER[10] NO N/A N/A

N/A

POINTS_EASY
9. POINTS_MEDIUM NUMBER[10] NO N/A N/A

N/A

POINTS_MEDIUM
10. POINTS_HARD NUMBER[10] NO N/A N/A

N/A

POINTS_HARD
11. DURATION_EASY NUMBER[0] YES N/A N/A

N/A

DURATION_EASY
12. DURATION_MEDIUM NUMBER[0] YES N/A N/A

N/A

DURATION_MEDIUM
13. DURATION_HARD NUMBER[0] YES N/A N/A

N/A

DURATION_HARD
14. DEFAULT_DURATION NUMBER[10] YES N/A N/A

N/A

Test duration in seconds. This is time available to complete the test once test instance started.
15. DISPLAY_ANSWER_IND CHAR[1] YES N/A N/A

N/A

Determines if the correct answer is displayed after every question is answered.
16. DISPLAY_CORRECT_IND CHAR[1] YES N/A N/A

N/A

Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.
17. REPORT_TYPE VARCHAR2[3] YES N/A N/A

N/A

OPA (On professor approval), FUL (Immediatly after finishing user can see his report with preview), GRA (User can see only grade after finishing)
18. LOOK_TYPE VARCHAR2[3] YES N/A N/A

N/A

AOP (All questions on page), OPP (One question per page)
19. DURATION_TYPE VARCHAR2[3] YES N/A N/A

N/A

UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)
20. DURATION_FACTOR NUMBER[10] YES N/A N/A

N/A

Factor (in percents, for example: -40%, +120%, +300%) - how much the available time for anwsering the questions should be shortened or prolonged. Apply duration factor to the length of every question. On this way duration of the questions can be parametrized.
21. RAND_QUESTION_ORDER CHAR[1] YES N/A N/A

N/A

Indicates whether the order of questions is randomized when instance of the quiz is created.
22. RAND_ANSWER_ORDER CHAR[1] YES N/A N/A

N/A

Indicates whether the order of answers within the question is randomized when instance of the quiz is created.
23. RESULTS_DISPLAY_CODE VARCHAR2[3] YES N/A N/A

N/A

This code determines when the results are displayed: - after svery question is answered - after entire quiz is finished - once it is reviewed and apprived by examiner
24. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
25. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
26. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
27. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 28
Table Name QUIZ_TEMPLATE_POOL
Owner YTM11
Type TABLE
Row Count 0
Remarks Associative table. Identifies Pools of Questions that will participare in generating new Quizzes.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. POOL_ID NUMBER[10] 1 NO N/A N/A

N/A

Pool of questions Primary Key
2. QUIZ_TEMPLATE_ID NUMBER[10] 2 NO N/A N/A

N/A

QUIZ_TEMPLATE_ID
3. NUM_OF_HARD_QUESTIONS NUMBER[10] NO N/A N/A

N/A

NUM_OF_HARD_QUESTIONS
4. NUM_OF_MEDIUM_QUESTIONS NUMBER[10] NO N/A N/A

N/A

NUM_OF_MEDIUM_QUESTIONS
5. NUM_OF_EASY_QUESTIONS NUMBER[10] NO N/A N/A

N/A

NUM_OF_EASY_QUESTIONS
6. CUT_OFF_DATE NUMBER[10] NO N/A N/A

N/A

CUT_OFF_DATE


# 29
Table Name REPORT_DEFINITION
Owner YTM11
Type TABLE
Row Count 0
Remarks Definition of the report
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. REPORT_DEFINITION_ID NUMBER[10] 1 NO N/A N/A

N/A

REPORT_DEFINITION_ID
2. REPORT_NAME VARCHAR2[50] NO N/A N/A

N/A

REPORT_NAME
3. REPORT_DESCRIPTION VARCHAR2[1000] YES N/A N/A

N/A

Report description with more details
4. DEFAULT_REPORT_TITLE VARCHAR2[1000] YES N/A N/A

N/A

This is title that will appear in the report.
5. DEFAULT_LOCATION VARCHAR2[1000] YES N/A N/A

N/A

This is the default location where report will be created in the file system
6. REPORT_FORMAT_CODE VARCHAR2[3] NO N/A N/A

N/A

Identifis the format of the report, for example: - PDF - Excel - Rich Text Format (RTF) - HTML
7. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
8. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
9. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
10. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 30
Table Name REPORT_INSTANCE
Owner YTM11
Type TABLE
Row Count 0
Remarks This is the particular report instance (produced report with concrete data)
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. REPORT_INSTANCE_ID NUMBER[10] 1 NO N/A N/A

N/A

REPORT_INSTANCE_ID
2. REPORT_DEFINITION_ID NUMBER[10] NO N/A N/A

N/A

REPORT_DEFINITION_ID
3. REPORT_LOCATION VARCHAR2[1000] NO N/A N/A

N/A

Location of the report in the file system
4. COMMENT VARCHAR2[1000] YES N/A N/A

N/A

This is the comment related to this particulear report instance. It is usually a text entered through Front End by person submitting report.
5. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
6. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
7. REPORT_TITLE VARCHAR2[1000] YES N/A N/A

N/A

This is title that will appear in the report. It overrides value from REPORT_DEFINITION.DEFAULT_REPORT_TITLE


# 31
Table Name ROLE
Owner YTM11
Type TABLE
Row Count 3
Remarks Roles can be (just an example): 1. Admin 2. Professor 3. Student 4. Guest

# Column Type PK Null Unique Cardinality Sample Data Comment
1. ROLE_CODE VARCHAR2[3] 1 NO YES 3
(100.00%)
ValueLengthCount
ADM31
PRF31
STU31
ROLE CODE
2. ROLE_NAME VARCHAR2[50] NO YES 3
(100.00%)
ValueLengthCount
Administrator131
Professor91
Student71
ROLE NAME
3. ROLE_DESCRIPTION VARCHAR2[400] YES YES 3
(100.00%)
ValueLengthCount
Administartor of the...231
Professor91
Student71
ROLE_DESCRIPTION
4. GRANTABLE CHAR[1] YES NO 2
(66.67%)
ValueLengthCount
N12
Y11
If 'Y' then this Role can grant Roles to other users.
5. ENABLED CHAR[1] NO NO 1
(33.33%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. ROLE_CODE VARCHAR2[3] 1 NO NO 3
(33.33%)
ValueLengthCount
ADM33
PRF33
STU33
ROLE CODE
2. FUNCTION_CODE VARCHAR2[3] 2 NO NO 3
(33.33%)
ValueLengthCount
CHP33
LGN33
TAQ33
FUNCTION CODE
3. ENABLED CHAR[1] NO NO 1
(11.11%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. ST_ANSWER_ID NUMBER[10] 1 NO YES 605
(100.00%)
ValueLengthCount
41
81
121
161
201
241
281
321
361
401
ST_ANSWER_ID
2. ST_QUIZ_ID NUMBER[10] NO NO 4
(0.66%)
ValueLengthCount
1155
2150
3150
4150
ST_QUIZ_ID
3. ARTIFICIAL_QUESTION_ID NUMBER[10] NO NO 31
(5.12%)
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.
4. ANSWER_TEXT NVARCHAR2[2000] YES YES N/A

N/A

ANSWER_TEXT
5. ORDINAL_NUMBER NUMBER[0] YES NO 5
(0.83%)
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.
6. CORRECT_ANSWER_IND CHAR[1] YES NO 2
(0.33%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. EXCEL_ROW_ID NUMBER[10] 1 NO N/A N/A

N/A

EXCEL_ROW_ID
2. COURSE_CODE VARCHAR2[50] YES N/A N/A

N/A

COURSE_CODE
3. CATEGORY_NAME_1 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_1
4. CATEGORY_NAME_2 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_2
5. CATEGORY_NAME_3 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_3
6. CATEGORY_NAME_4 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_4
7. CATEGORY_NAME_5 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_5
8. CATEGORY_NAME_6 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_6
9. CATEGORY_NAME_7 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_7
10. CATEGORY_NAME_8 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_8
11. CATEGORY_NAME_9 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_9
12. CATEGORY_NAME_10 VARCHAR2[50] YES N/A N/A

N/A

CATEGORY_NAME_10
13. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME


# 35
Table Name ST_QUESTION
Owner YTM11
Type TABLE
Row Count 121
Remarks Staging table for loading Question data from Excel file.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. ST_QUESTION_ID NUMBER[10] 1 NO YES 121
(100.00%)
ValueLengthCount
41
81
121
161
201
241
281
321
361
401
ST_QUESTION_ID
2. ARTIFICIAL_QUESTION_ID NUMBER[10] NO NO 31
(25.62%)
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.
3. ST_QUIZ_ID NUMBER[10] NO NO 4
(3.31%)
ValueLengthCount
131
230
330
430
ST_QUIZ_ID
4. QUESTION_TEXT NVARCHAR2[2000] NO YES N/A

N/A

QUESTION TEXT
5. PICTURE BLOB[4000] YES YES N/A

N/A

This is picture that is displayed with question.
6. DURATION NUMBER[10] YES NO 1
(0.83%)
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.
7. DIFFICULTY NUMBER[0] YES NO 1
(0.83%)
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.
8. POINTS NUMBER[0] YES NO 1
(0.83%)
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.
9. ORDINAL_NUMBER NUMBER[0] YES NO 31
(25.62%)
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 Type PK Null Unique Cardinality Sample Data Comment
1. ST_QUIZ_ID NUMBER[10] 1 NO YES 4
(100.00%)
ValueLengthCount
11
21
31
41
ST_QUIZ_ID
2. USERNAME NVARCHAR2[100] NO NO 1
(25.00%)
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.
3. PASSWORD CHAR[10] YES NO 1
(25.00%)
ValueLengthCount
zkukoljac2104
PASSWORD
4. USER_ID NUMBER[10] YES NO 1
(25.00%)
ValueLengthCount
null4
USER ID
5. QUIZ_NAME NVARCHAR2[100] NO YES 4
(100.00%)
ValueLengthCount
History71
North American Geogr...231
Science71
Sport51
Name (Title) of this test.
6. DEFAULT_DURATION NUMBER[10] YES NO 1
(25.00%)
ValueLengthCount
null4
Test duration in seconds. This is time available to complete the test once test instance started.
7. USERS_COMMENT NVARCHAR2[2000] YES YES N/A

N/A

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

N/A

SURVEY_DEFINITION_ID
2. GRADING_SYSTEM_ID NUMBER[10] YES N/A N/A

N/A

Primarry Key
3. SURVEY_CATEGORY_ID NUMBER[10] YES N/A N/A

N/A

SURVEY_CATEGORY_ID
4. SURVEY_NAME NVARCHAR2[100] NO N/A N/A

N/A

Name (Title) of this test.
5. SURVEY_DESCRIPTION VARCHAR2[1000] YES N/A N/A

N/A

Quiz Long Decsription
6. DEFAULT_DURATION NUMBER[10] YES N/A N/A

N/A

Test duration in seconds. This is time available to complete the test once test instance started.
7. USERS_COMMENT NVARCHAR2[2000] YES N/A N/A

N/A

USERS COMMENT
8. SURVEY_DEFINITION_STATUS VARCHAR2[3] NO N/A N/A

N/A

Examples: - Active - Inactive - Under Construction
9. POINTS_EASY NUMBER[10] NO N/A N/A

N/A

POINTS_EASY
10. POINTS_MEDIUM NUMBER[10] NO N/A N/A

N/A

POINTS_MEDIUM
11. POINTS_HARD NUMBER[10] NO N/A N/A

N/A

POINTS_HARD
12. DURATION_EASY NUMBER[0] YES N/A N/A

N/A

DURATION_EASY
13. DURATION_MEDIUM NUMBER[0] YES N/A N/A

N/A

DURATION_MEDIUM
14. DURATION_HARD NUMBER[0] YES N/A N/A

N/A

DURATION_HARD
15. DURATION_FACTOR NUMBER[10] YES N/A N/A

N/A

Factor (in percents, for example: -40%, +120%, +300%) - how much the available time for anwsering the questions should be shortened or prolonged. Apply duration factor to the length of every question. On this way duration of the questions can be parametrized.
16. DEFAULT_ENABLED_FROM DATE[7] YES N/A N/A

N/A

DEFAULT ENABLED FROM
17. DEFAULT_ENABLED_TO DATE[7] YES N/A N/A

N/A

DEFAULT ENABLED TO
18. DISPLAY_ANSWER_IND CHAR[1] YES N/A N/A

N/A

Determines if the correct answer is displayed after every question is answered.
19. DISPLAY_CORRECT_IND CHAR[1] YES N/A N/A

N/A

Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.
20. CREATE_TYPE VARCHAR2[3] YES N/A N/A

N/A

GEN (Generated), MAN (Manual)
21. REPORT_TYPE VARCHAR2[3] YES N/A N/A

N/A

OPA (On professor approval), IMM (Immediatly after finishing whole quiz) IQT (After every question - works only for wizard type of quiz)
22. LOOK_TYPE VARCHAR2[3] YES N/A N/A

N/A

AOP (All questions on page), OPP (One question per page)
23. DURATION_TYPE VARCHAR2[3] YES N/A N/A

N/A

UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)
24. RESOLVE_TYPE VARCHAR2[3] YES N/A N/A

N/A

Shows if quiz contains questions that need to be resolved by professor himself. QRY - quiz can be resolved by system QRN- quiz cannot be resolved by system - must professor.
25. RAND_QUESTION_ORDER CHAR[1] YES N/A N/A

N/A

Indicates whether the order of questions is randomized when instance of the quiz is created.
26. RAND_ANSWER_ORDER CHAR[1] YES N/A N/A

N/A

Indicates whether the order of answers within the question is randomized when instance of the quiz is created.
27. RESULTS_DISPLAY_CODE VARCHAR2[3] YES N/A N/A

N/A

This code determines how the results are displayed: FUL (grade and preview), GRA (only grade)
28. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
29. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
30. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
31. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 39
Table Name SURVEY_INSTANCE
Owner YTM11
Type TABLE
Row Count 0
Remarks Occurance of the particular Survey. Whenever somebody takes a test a record is created in this table.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. SURVEY_INSTANCE_ID NUMBER[10] 1 NO N/A N/A

N/A

SURVEY_INSTANCE_ID
2. SURVEY_DEFINITION_ID NUMBER[10] NO N/A N/A

N/A

SURVEY_DEFINITION_ID
3. USER_ID_TESTED NUMBER[10] NO N/A N/A

N/A

USER ID TESTED
4. COURSE_ID NUMBER[10] YES N/A N/A

N/A

This quiz is taken as a part of this Course. Both COURSE_ID and CLASS_ID are optional in this table ant they link to COURSE and CLASS table (vs. CLASS_COURSE) and this is done intentionaly for maximum flexibility. If the FKs are linked to CLASS that would impose that class has to belong to the course which may ne the situation when test is taken but the it may change after that. This is one scenario. In any case this is done for maximum flexibility.
5. CLASS_ID NUMBER[10] YES N/A N/A

N/A

User tested may belong to the class. THis class may be independent of course (may not belong to the course at all). This is done for maximum flexibility.
6. DURATION NUMBER[10] YES N/A N/A

N/A

DURATION
7. ENABLED_FROM DATE[7] YES N/A N/A

N/A

ENABLED FROM
8. ENABLED_TO DATE[7] YES N/A N/A

N/A

ENABLED TO
9. QUIZ_STARTED DATE[7] YES N/A N/A

N/A

Date and time when user started the quiz (received first question). This data will be used to calculate quiz duration.
10. QUIZ_FINISHED DATE[7] YES N/A N/A

N/A

QUIZ FINISHED
11. QUIZ_INSTANCE_STATUS VARCHAR2[3] NO N/A N/A

N/A

Describes the status of the Quiz instance: - Not sent - Not attempted - Attempted No Report - Attempted With Report - Expired
12. ACTIVATION_DATETIME DATE[7] NO N/A N/A

N/A

Indicates when this quiz instance is activated. Quiz instance has to be activated in order for person to take the quiz. When QUIZ_INSTANCE is activated all quations linked to this QUIZ_INSTANCE record are marked as "read only" (QUESTION.READ_ONLY_IND is set to "Y") Questions with QUESTION.READ_ONLY_IND set to "Y" cannot be edited any more. Quiz can be taken by individual if: 1. QUIZ_INSTANCE.ACTIVATION_DATETIME is not null (quiz instance is activated and questions are locked) 2. QUIZ_INSTANCE.ENABLED_FROM is greated than SYSDATE 3. QUIZ_INSTANCE.ENABLED_FROM is lesser than SYSDATE
13. RESOLVE_TYPE VARCHAR2[3] YES N/A N/A

N/A

Shows if quiz contains questions that need to be resolved by professor himself. QRY - quiz can be resolved by system QRN- quiz cannot be resolved by system - must professor.
14. CREATE_USER_ID NUMBER[10] NO N/A N/A

N/A

CREATE USER ID
15. CREATE_DATETIME DATE[7] NO N/A N/A

N/A

CREATE DATETIME
16. UPDATE_USER_ID NUMBER[10] YES N/A N/A

N/A

UPDATE USER ID
17. UPDATE_DATETIME DATE[7] YES N/A N/A

N/A

UPDATE DATETIME


# 40
Table Name SURVEY_QUESTION
Owner YTM11
Type TABLE
Row Count 0
Remarks SURVEY_QUESTION
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUESTION_ID NUMBER[10] 1 NO N/A N/A

N/A

QUESTION ID
2. SURVEY_INSTANCE_ID NUMBER[10] 2 NO N/A N/A

N/A

SURVEY_INSTANCE_ID


# 41
Table Name TIME_ZONE
Owner YTM11
Type TABLE
Row Count 0
Remarks TIME_ZONE
WARNING: Table is empty.
WARNING: Table is orphan.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. TIME_ZONE_ID NUMBER[10] 1 NO N/A N/A

N/A

TIME_ZONE_ID
2. TIME_ZONE NUMBER[0] NO N/A N/A

N/A

This is actualy difference from ZULU time (GMT).
3. TIME_ZONE_CODE VARCHAR2[10] YES N/A N/A

N/A

For Example: "EST" "PST" etc.
4. TIME_ZONE_NAME VARCHAR2[100] YES N/A N/A

N/A

For example: "Eastern Standard Time"


# 42
Table Name UNIQUE_QUIZ
Owner YTM11
Type TABLE
Row Count 4
Remarks Table that we use for connecting unique tests to generated sets of questions. If quiz is manualy created then we have only one unique test. QUIZ_DEFINITION nema vezu sa QUESTIONS nego samo UNIQUE_TESTS imaju vezu sa QUESTIONS. Svrha tabele UNIQUE_TEST je samo da bi sadrzala razlicita pitanja sve ostalo je isto The purpose of this normalization is to have parent Quiz Definition which for many unique etsts given to the same group of peolple. This structure is also required for reporting.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. UNIQUE_QUIZ_ID NUMBER[10] 1 NO YES 4
(100.00%)
ValueLengthCount
11
21
31
41
UNIQUE_QUIZ_ID
2. QUIZ_DEFINITION_ID NUMBER[10] NO YES 4
(100.00%)
ValueLengthCount
10001
10011
10021
10031
QUIZ_DEFINITION_ID
3. UNIQUE_QUIZ_NAME NVARCHAR2[100] NO YES 4
(100.00%)
ValueLengthCount
UNIQUE QUIZ NAME 1181
UNIQUE QUIZ NAME 2181
UNIQUE QUIZ NAME 3181
UNIQUE QUIZ NAME 4181
Name (Title) of this test.
4. CREATE_USER_ID NUMBER[10] NO NO 1
(25.00%)
ValueLengthCount
04
CREATE USER ID
5. CREATE_DATETIME DATE[7] NO YES 4
(100.00%)
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
6. UPDATE_USER_ID NUMBER[10] YES NO 1
(25.00%)
ValueLengthCount
null4
UPDATE USER ID
7. UPDATE_DATETIME DATE[7] YES NO 1
(25.00%)
ValueLengthCount
null4
UPDATE DATETIME


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

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] 1 NO YES 236
(100.00%)
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
USER ID
2. USERNAME NVARCHAR2[100] NO YES 236
(100.00%)
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.
3. LANGUAGE_ID NUMBER[10] YES NO 2
(0.85%)
ValueLengthCount
15230
196
User can have a language other than English. If this field is empty then default language is english.
4. ORGANIZATION_ID NUMBER[10] YES NO 1
(0.42%)
ValueLengthCount
null236
ORGANIZATION ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
5. PASSWORD VARCHAR2[50] NO YES 236
(100.00%)
ValueLengthCount
+hS11lHmJuKiAAVpuZOk...231
+pgGqnk5MOzclD96B/Kd...231
+sGK9U2zUGLDZRi5Kzb5...231
+ueT03F8OaE9Pl15wGVQ...231
/4LbZNB1Z9DNIzpJwphr...231
/Xt7PL2WOTeEcoVKQddQ...231
/afLICJw9uMIeP0tuFER...231
02rks2l+D/0DF52eoZP8...231
05u/buw21oweiNucGspl...231
09kRdhtH07ZUbSAX9LSr...231
PASSWORD
6. MUST_CHANGE_PW_ON_NEXT_LOGIN CHAR[1] YES NO 1
(0.42%)
ValueLengthCount
null0236
Indicates if user has to change password on next login. As soon as user changes password this flag should be set to "N" or NULL
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
7. PW_EXPIRY_DATETIME DATE[7] YES NO 1
(0.42%)
ValueLengthCount
null236
Date and time when password expires. When user logs in after that date it will be forced to change password. NULL - password never expires.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
8. FIRST_NAME VARCHAR2[50] NO NO 149
(63.14%)
ValueLengthCount
Perry56
Pat34
Peggy53
Pete43
Alec42
Alexa52
Clark52
Claude62
Cliff52
Clint52
FIRST NAME
9. LAST_NAME VARCHAR2[50] NO NO 154
(65.25%)
ValueLengthCount
Baldwin73
Barber63
Benson63
Bowen53
Cummings83
Daniel63
Griffith83
Hines53
Hubbard73
Lyons53
LAST NAME
10. GENDER_CODE VARCHAR2[3] YES NO 1
(0.42%)
ValueLengthCount
null0236
GENDER_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
11. DATE_OF_BIRTH DATE[7] YES NO 4
(1.69%)
ValueLengthCount
Sun Feb 23, 2014 09:50:37.000096
Sun Feb 23, 2014 09:50:36.000067
Sun Feb 23, 2014 09:50:38.000059
Sun Feb 23, 2014 09:50:39.000014
DATE_OF_BIRTH
12. SEMESTER NUMBER[0] YES NO 1
(0.42%)
ValueLengthCount
null236
Current semester the Student is inroleed into.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
13. YEAR_OF_STUDY NUMBER[0] YES NO 1
(0.42%)
ValueLengthCount
null236
Current Year of study
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
14. LAST_LOGON DATE[7] YES NO 1
(0.42%)
ValueLengthCount
null236
LAST LOGON
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
15. FAILED_LOGINS NUMBER[10] YES NO 1
(0.42%)
ValueLengthCount
null236
Number of censequtive failed logons since last succesfull log in. null means that tyhis user never logged in to the system. This number is always updated - either with "0" or other positive number.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
16. TOTAL_LOGONS NUMBER[10] YES NO 1
(0.42%)
ValueLengthCount
null236
Total number of succesfull logons to the system. Null if user never logged in to the system.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
17. EMAIL NVARCHAR2[100] YES NO 234
(99.15%)
ValueLengthCount
zoran@mallocinc.com193
Nancy4927@hotmail.co...231
aurie@yahoo.ca141
avel@yahoo.ca131
baker4809@hotmail.ca201
clinthill4722@yahoo....231
cmdron2794@hotmail.c...231
colin6913@yahoo.ca181
corybain@yahoo.com181
craig4791@hotmail.co...231
EMAIL
18. EMAIL2 NVARCHAR2[100] YES NO 234
(99.15%)
ValueLengthCount
zoran@rogers.com163
bandere09@hotmail.ca201
barkingme8461@hotmai...231
clinno232@yahoo.ca181
coldhot13@yahoo.ca181
coldtrain482@yahoo.c...231
coolpret4783@yahoo.c...231
cotyain@yahoo.com171
craihe791@hotmail.co...231
cravingpie492@hotmai...231
EMAIL2
19. DAYTIME_PHONE VARCHAR2[50] YES NO 1
(0.42%)
ValueLengthCount
null0236
DAYTIME PHONE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
20. EVENING_PHONE VARCHAR2[50] YES NO 1
(0.42%)
ValueLengthCount
null0236
EVENING PHONE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
21. USER_TYPE VARCHAR2[3] YES NO 3
(1.27%)
ValueLengthCount
STU3181
ADS329
PRO326
This field is currently not used.
22. USER_STATUS VARCHAR2[3] YES NO 1
(0.42%)
ValueLengthCount
ACT3236
USER_STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
23. TIME_ZONE NUMBER[10] YES NO 17
(7.20%)
ValueLengthCount
-346
225
423
623
-420
915
-712
-512
-212
811
TIME ZONE
24. COMMENTS VARCHAR2[2000] YES YES N/A

N/A

Comments associated to this user
25. CREATE_USER_ID NUMBER[10] NO NO 1
(0.42%)
ValueLengthCount
1236
CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
26. CREATE_DATETIME DATE[7] NO NO 4
(1.69%)
ValueLengthCount
Sun Feb 23, 2014 09:50:34.000094
Sun Feb 23, 2014 09:50:33.000065
Sun Feb 23, 2014 09:50:35.000062
Sun Feb 23, 2014 09:50:36.000015
CREATE DATETIME
27. UPDATE_USER_ID NUMBER[10] YES NO 1
(0.42%)
ValueLengthCount
null236
UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.
28. UPDATE_DATETIME DATE[7] YES NO 1
(0.42%)
ValueLengthCount
null236
UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.


# 44
Table Name USERS_CLASS
Owner YTM11
Type TABLE
Row Count 5,900
Remarks User can belong to many classes. Many users can be in the same class. Class may have many administrators.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] 1 NO NO 236
(4.00%)
ValueLengthCount
125
225
325
425
525
625
725
825
925
1025
USER ID
2. CLASS_ID NUMBER[10] 2 NO NO 25
(0.42%)
ValueLengthCount
1236
2236
3236
4236
5236
6236
7236
8236
9236
10236
CLASS_ID
3. USER_CLASS_ROLE VARCHAR2[3] YES NO 1
(0.02%)
ValueLengthCount
ADM35,900
Defines the primary role of the user associated with the class. Defined in code type "USER CLASS ROLE" For example: 'ADM' - Administrator - it can administrer class (add or remove users form the class) null - simple member of the class
SUGGESTION: All rows have the same data value in this column. Consider normalizing.


# 45
Table Name USERS_POOLS
Owner YTM11
Type TABLE
Row Count 0
Remarks Associative Table
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. POOL_ID NUMBER[10] 1 NO N/A N/A

N/A

Pool of questions Primary Key
2. USER_ID NUMBER[10] 2 NO N/A N/A

N/A

USER ID
3. USERS_POOL_ROLE VARCHAR2[3] YES N/A N/A

N/A

Defines the role of the user for this pool of questions. for example: - can edit pool - can use pool - etc.


# 46
Table Name USER_ACTION_LOG
Owner YTM11
Type TABLE
Row Count 0
Remarks This table will have a purp[ose to track user activity. It will be used to produce reports about the system load. Whenever user logs in new record will be inserted in this table. Some more statistical information could be captured here.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ACTION_LOG_ID NUMBER[0] 1 NO N/A N/A

N/A

USER ACTION LOG ID
2. USER_ID NUMBER[10] NO N/A N/A

N/A

USER ID
3. ACTION_CODE VARCHAR2[10] NO N/A N/A

N/A

ACTION CODE
4. COMMENTS VARCHAR2[1000] YES N/A N/A

N/A

COMMENTS
5. CREATE_DATETIME TIMESTAMP(6)[11,6] NO N/A N/A

N/A

CREATE DATETIME


# 47
Table Name USER_COURSE
Owner YTM11
Type TABLE
Row Count 13,924
Remarks THis table describes the role of the user in certain Course.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] 1 NO NO 236
(1.69%)
ValueLengthCount
159
259
359
459
559
659
759
859
959
1059
USER ID
2. COURSE_ID NUMBER[10] 2 NO NO 59
(0.42%)
ValueLengthCount
2236
3236
4236
5236
6236
7236
8236
9236
11236
12236
COURSE_ID
3. USER_COURSE_ROLE VARCHAR2[3] YES NO 1
(0.01%)
ValueLengthCount
AAA313,924
Primary Role of the user for that course USER_ROLE_CODE is populated with codes where CODE_TYPE_NAME = 'USER_COURSE_ROLE'
SUGGESTION: All rows have the same data value in this column. Consider normalizing.


# 48
Table Name USER_PREFERENCES
Owner YTM11
Type TABLE
Row Count 0
Remarks User preferences. User can have more than one profile that define look and feel of his quizzes. If dos not have it, theen default preferences are used.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_PREFERENCES_ID NUMBER[10] 1 NO N/A N/A

N/A

USER PREFERENCES ID
2. USER_ID NUMBER[10] NO N/A N/A

N/A

USER ID
3. USER_PREFERENCES_NAME VARCHAR2[50] YES N/A N/A

N/A

USER_PREFERENCES_NAME
4. MAX_RECORDS_RETURNED NUMBER[10] YES N/A N/A

N/A

MAX RECORDS RETURNED
5. ANSWER_TABLE_WIDTH NUMBER[10] YES N/A N/A

N/A

ANSWER TABLE WIDTH
6. TABLE_CHECK_BOX_COLUMN_WIDTH NUMBER[10] YES N/A N/A

N/A

TABLE CHECK BOX COLUMN WIDTH
7. TABLE_BG_ALT_COLOR1 VARCHAR2[50] YES N/A N/A

N/A

TABLE BG ALT COLOR1
8. TABLE_BG_ALT_COLOR2 VARCHAR2[50] YES N/A N/A

N/A

TABLE BG ALT COLOR2
9. TABLE_BODY_FONT_SIZE NUMBER[10] YES N/A N/A

N/A

TABLE BODY FONT SIZE
10. TABLE_BODY_FONT_FACE VARCHAR2[50] YES N/A N/A

N/A

TABLE BODY FONT FACE
11. TABLE_HEADER_BG_COLOR VARCHAR2[50] YES N/A N/A

N/A

TABLE HEADER BG COLOR
12. TABLE_HEADER_FONT_SIZE NUMBER[10] YES N/A N/A

N/A

TABLE HEADER FONT SIZE
13. TABLE_HEADER_FONT_FACE VARCHAR2[50] YES N/A N/A

N/A

TABLE HEADER FONT FACE
14. USER_LOGO BLOB[4000] YES N/A N/A

N/A

User's logo that may appear on his pages and Quizzes
15. USER_PREFERENCES_STATUS VARCHAR2[3] YES N/A N/A

N/A

USER_PREFERENCES_STATUS


# 49
Table Name USER_QUIZ
Owner YTM11
Type TABLE
Row Count 0
Remarks -Defines relationship between users and quiz. One quiz can have several managers.
WARNING: Table is empty.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] 1 NO N/A N/A

N/A

USER ID
2. QUIZ_DEFINITION_ID NUMBER[10] 2 NO N/A N/A

N/A

QUIZ_DEFINITION_ID
3. USER_QUIZ_ROLE VARCHAR2[3] YES N/A N/A

N/A

-QMN - Quiz manager


# 50
Table Name USER_ROLE
Owner YTM11
Type TABLE
Row Count 236
Remarks User may have multiple roles.

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] 2 NO YES 236
(100.00%)
ValueLengthCount
11
21
31
41
51
61
71
81
91
101
USER ID
2. ROLE_CODE VARCHAR2[3] 1 NO NO 3
(1.27%)
ValueLengthCount
STU3136
PRF390
ADM310
ROLE CODE
3. ENABLED CHAR[1] NO NO 1
(0.42%)
ValueLengthCount
Y1236
ENABLED
SUGGESTION: All rows have the same data value in this column. Consider normalizing.


# 51
Table Name V_CLASS_COURSE
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. CLASS_ID NUMBER[10] NO YES N/A

N/A

2. CLASS_NAME VARCHAR2[200] NO YES N/A

N/A

3. CLASS_CODE VARCHAR2[30] YES YES N/A

N/A

4. CLASS_ACTIVE_FROM DATE[7] YES YES N/A

N/A

5. CLASS_ACTIVE_TO DATE[7] YES YES N/A

N/A

6. CLASS_STATUS CHAR[3] YES YES N/A

N/A

7. CLASS_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

8. CLASS_CREATE_DATETIME DATE[7] NO YES N/A

N/A

9. CLASS_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

10. CLASS_UPDATE_DATETIME DATE[7] YES YES N/A

N/A

11. COURSE_ID NUMBER[10] NO YES N/A

N/A

12. PARENT_COURSE_ID NUMBER[10] YES YES N/A

N/A

13. COURSE_NAME VARCHAR2[300] NO YES N/A

N/A

14. COURSE_CODE VARCHAR2[30] YES YES N/A

N/A

15. COURSE_STATUS VARCHAR2[3] YES YES N/A

N/A

16. COURSE_CATEGORY_LEVEL NUMBER[0] NO YES N/A

N/A

17. COURSE_DESCRIPTION VARCHAR2[2000] NO YES N/A

N/A

18. COURSE_CREDITS NUMBER[0] YES YES N/A

N/A

19. COURSE_DURATION_IN_HRS NUMBER[0] YES YES N/A

N/A

20. COURSE_DEPARTMENT_ID VARCHAR2[3] YES YES N/A

N/A

21. COURSE_SEMESTER NUMBER[0] YES YES N/A

N/A

22. COURSE_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

23. COURSE_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

24. COURSE_CREATE_DATETIME DATE[7] NO YES N/A

N/A

25. COURSE_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

26. COURSE_UPDATE_DATETIME DATE[7] YES YES N/A

N/A

27. CLASS_COURSE_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

28. CLASS_COURSE_CREATE_DATETIME DATE[7] NO YES N/A

N/A

29. CLASS_COURSE_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

30. CLASS_COURSE_UPDATE_DATETIME DATE[7] YES YES N/A

N/A



# 52
Table Name V_CODES
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. CODE_TYPE_ID VARCHAR2[3] NO YES N/A

N/A

2. CODE_TYPE_NAME VARCHAR2[50] NO YES N/A

N/A

3. CODE_TYPE_DESCRIPTION VARCHAR2[200] NO YES N/A

N/A

4. CODE_ID VARCHAR2[3] NO YES N/A

N/A

5. CODE_NAME VARCHAR2[50] NO YES N/A

N/A

6. CODE_DESCRIPTION VARCHAR2[200] NO YES N/A

N/A



# 53
Table Name V_COURSES
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. COURSE_ID NUMBER[10] NO YES N/A

N/A

2. COURSE_CODE VARCHAR2[30] YES YES N/A

N/A

3. CATEGORY VARCHAR2[300] NO YES N/A

N/A

4. TOP_COURSE VARCHAR2[300] YES YES N/A

N/A

5. COURSE_PATH VARCHAR2[4000] YES YES N/A

N/A

6. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

7. TABLE_LEVEL NUMBER[0] NO YES N/A

N/A

8. IS_LEAF NUMBER[0] YES YES N/A

N/A

9. COURSE_DESCRIPTION VARCHAR2[2000] NO YES N/A

N/A

10. PARENT_COURSE_ID NUMBER[10] YES YES N/A

N/A

11. COURSE_STATUS VARCHAR2[3] YES YES N/A

N/A

12. CREDITS NUMBER[0] YES YES N/A

N/A

13. DURATION_IN_HRS NUMBER[0] YES YES N/A

N/A

14. DEPARTMENT_ID VARCHAR2[3] YES YES N/A

N/A

15. SEMESTER NUMBER[0] YES YES N/A

N/A

16. YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A



# 54
Table Name V_COURSES_SUM
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. COURSE_ID NUMBER[10] YES YES N/A

N/A

2. COURSE_CODE VARCHAR2[30] YES YES N/A

N/A

3. COURSE_NAME VARCHAR2[300] YES YES N/A

N/A

4. COURSE_STATUS VARCHAR2[3] YES YES N/A

N/A

5. TOP_COURSE VARCHAR2[300] YES YES N/A

N/A

6. COURSE_TREE VARCHAR2[4000] YES YES N/A

N/A

7. COURSE_PATH VARCHAR2[4000] YES YES N/A

N/A

8. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

9. TABLE_LEVEL NUMBER[0] YES YES N/A

N/A

10. IS_LEAF NUMBER[0] YES YES N/A

N/A

11. COURSE_DESCRIPTION VARCHAR2[2000] YES YES N/A

N/A

12. PARENT_COURSE_ID NUMBER[10] YES YES N/A

N/A

13. CREDITS NUMBER[0] YES YES N/A

N/A

14. DURATION_IN_HRS NUMBER[0] YES YES N/A

N/A

15. DEPARTMENT_ID VARCHAR2[3] YES YES N/A

N/A

16. SEMESTER NUMBER[0] YES YES N/A

N/A

17. YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

18. COURSE_COUNT NUMBER[0] YES YES N/A

N/A



# 55
Table Name V_DOCUMENT
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. DOCUMENT_ID NUMBER[0] NO YES N/A

N/A

2. DOCUMENT_TITLE VARCHAR2[400] NO YES N/A

N/A

3. DOCUMENT_DESCRIPTION VARCHAR2[2000] NO YES N/A

N/A

4. DOCUMENT_BINARY_CONTENT_SIZE NUMBER[0] YES YES N/A

N/A

5. DOCUMENT_CHAR_CONTENT_SIZE NUMBER[0] YES YES N/A

N/A

6. FILE_NAME VARCHAR2[400] YES YES N/A

N/A

7. FILE_PATH VARCHAR2[400] YES YES N/A

N/A

8. CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

9. CREATE_DATETIME DATE[7] NO YES N/A

N/A

10. UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

11. UPDATE_DATETIME DATE[7] YES YES N/A

N/A



# 56
Table Name V_POOLS_SUM
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. POOL_ID NUMBER[10] YES YES N/A

N/A

2. POOL_NAME VARCHAR2[100] YES YES N/A

N/A

3. TOP_POOL VARCHAR2[100] YES YES N/A

N/A

4. POOL_TREE VARCHAR2[4000] YES YES N/A

N/A

5. POOL_PATH VARCHAR2[4000] YES YES N/A

N/A

6. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

7. IS_LEAF NUMBER[0] YES YES N/A

N/A

8. POOL_DESCRIPTION VARCHAR2[500] YES YES N/A

N/A

9. PARENT_POOL_ID NUMBER[10] YES YES N/A

N/A

10. POOL_COUNT NUMBER[0] YES YES N/A

N/A



# 57
Table Name V_POOL_QUESTION_INFO
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. POOL_ID NUMBER[10] NO YES N/A

N/A

2. POOL_NAME VARCHAR2[100] NO YES N/A

N/A

3. NUMBER_OF_QUESTIONS NUMBER[0] YES YES N/A

N/A



# 58
Table Name V_POOL_QUESTION_SUM
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. POOL_ID NUMBER[10] NO YES N/A

N/A

2. POOL_NAME VARCHAR2[100] NO YES N/A

N/A

3. NUMBER_OF_QUESTIONS NUMBER[0] YES YES N/A

N/A



# 59
Table Name V_QUESTIONS_IN_POOLS
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. POOL_ID NUMBER[10] NO YES N/A

N/A

4. POOL_NAME VARCHAR2[100] NO YES N/A

N/A

5. QUESTION_ID NUMBER[10] NO YES N/A

N/A

6. QUESTION_TEXT NVARCHAR2[2000] NO YES N/A

N/A

7. DIFFICULTY NUMBER[0] YES YES N/A

N/A

8. POINTS NUMBER[0] YES YES N/A

N/A



# 60
Table Name V_QUIZ
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_DEFINITION_ID NUMBER[10] NO YES N/A

N/A

2. QUIZ_CATEGORY_ID NUMBER[10] YES YES N/A

N/A

3. QUIZ_NAME NVARCHAR2[100] NO YES N/A

N/A

4. DEFAULT_DURATION NUMBER[10] YES YES N/A

N/A

5. USERS_COMMENT NVARCHAR2[2000] YES YES N/A

N/A

6. DEFAULT_ENABLED_FROM DATE[7] YES YES N/A

N/A

7. DEFAULT_ENABLED_TO DATE[7] YES YES N/A

N/A

8. DISPLAY_ANSWER_IND CHAR[1] YES YES N/A

N/A

9. DISPLAY_CORRECT_IND CHAR[1] YES YES N/A

N/A

10. DURATION_FACTOR NUMBER[10] YES YES N/A

N/A

11. QUIZ_DEF_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

12. QUIZ_DEF_CREATE_DATETIME DATE[7] NO YES N/A

N/A

13. QUIZ_DEF_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

14. QUIZ_DEF_UPDATE_DATETIME DATE[7] YES YES N/A

N/A

15. QUESTION_ID NUMBER[10] NO YES N/A

N/A

16. QUESTION_TEXT NVARCHAR2[2000] NO YES N/A

N/A

17. DURATION NUMBER[10] YES YES N/A

N/A

18. DIFFICULTY NUMBER[0] YES YES N/A

N/A

19. POINTS NUMBER[0] YES YES N/A

N/A

20. EXCEL_QUESTION_ID NUMBER[10] YES YES N/A

N/A

21. QUESTION_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

22. QUESTION_CREATE_DATETIME DATE[7] NO YES N/A

N/A

23. QUESTION_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

24. QUESTION_UPDATE_DATETIME DATE[7] YES YES N/A

N/A

25. QUESTION_MUL_CHOICE_IND VARCHAR2[3] YES YES N/A

N/A

26. READ_ONLY_IND CHAR[1] YES YES N/A

N/A

27. QUESTION_ORDINAL_NUMBER NUMBER[10] YES YES N/A

N/A

28. STATUS VARCHAR2[3] NO YES N/A

N/A

29. ANSWER_ID NUMBER[10] YES YES N/A

N/A

30. ANSWER_TEXT VARCHAR2[2000] YES YES N/A

N/A

31. ANSWER_ORDINAL_NUMBER NUMBER[0] YES YES N/A

N/A

32. CORRECT_ANSWER_IND CHAR[1] YES YES N/A

N/A

33. ANSWER_CREATE_USER_ID NUMBER[10] YES YES N/A

N/A

34. ANSWER_CREATA_DATETIME DATE[7] YES YES N/A

N/A

35. ANSWER_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

36. ANSWER_UPDATE_DATETIME DATE[7] YES YES N/A

N/A



# 61
Table Name V_QUIZ_CATEGORIES
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_CATEGORY_ID NUMBER[10] NO YES N/A

N/A

2. CATEGORY VARCHAR2[50] NO YES N/A

N/A

3. TOP_CATEGORY VARCHAR2[50] YES YES N/A

N/A

4. CATEGORY_PATH VARCHAR2[4000] YES YES N/A

N/A

5. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

6. TABLE_LEVEL NUMBER[0] NO YES N/A

N/A

7. IS_LEAF NUMBER[0] YES YES N/A

N/A

8. QUIZ_CATEGORY_DESCRIPTION VARCHAR2[1000] YES YES N/A

N/A

9. PARENT_QUIZ_CATEGORY_ID NUMBER[10] YES YES N/A

N/A



# 62
Table Name V_QUIZ_CATEGORIES_SUM
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_CATEGORY_ID NUMBER[10] YES YES N/A

N/A

2. CATEGORY VARCHAR2[50] YES YES N/A

N/A

3. TOP_CATEGORY VARCHAR2[50] YES YES N/A

N/A

4. CATEGORY_PATH VARCHAR2[4000] YES YES N/A

N/A

5. CATEGORY_TREE VARCHAR2[4000] YES YES N/A

N/A

6. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

7. TABLE_LEVEL NUMBER[0] YES YES N/A

N/A

8. IS_LEAF NUMBER[0] YES YES N/A

N/A

9. QUIZ_CATEGORY_DESCRIPTION VARCHAR2[1000] YES YES N/A

N/A

10. PARENT_QUIZ_CATEGORY_ID NUMBER[10] YES YES N/A

N/A

11. SUB_CATEGORIES_COUNT NUMBER[0] YES YES N/A

N/A



# 63
Table Name V_QUIZ_CATEGORIES_SUM2
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_CATEGORY_ID NUMBER[10] YES YES N/A

N/A

2. CATEGORY VARCHAR2[50] YES YES N/A

N/A

3. TOP_CATEGORY VARCHAR2[50] YES YES N/A

N/A

4. CATEGORY_PATH VARCHAR2[4000] YES YES N/A

N/A

5. CATEGORY_TREE VARCHAR2[4000] YES YES N/A

N/A

6. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

7. TABLE_LEVEL NUMBER[0] YES YES N/A

N/A

8. IS_LEAF NUMBER[0] YES YES N/A

N/A

9. QUIZ_CATEGORY_DESCRIPTION VARCHAR2[1000] YES YES N/A

N/A

10. PARENT_QUIZ_CATEGORY_ID NUMBER[10] YES YES N/A

N/A

11. QUIZ_COUNT NUMBER[0] YES YES N/A

N/A



# 64
Table Name V_QUIZ_RESULT
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_INSTANCE_ID NUMBER[10] NO YES N/A

N/A

2. USER_ID_TESTED NUMBER[10] NO YES N/A

N/A

3. QUIZ_RESULT_ID NUMBER[10] NO YES N/A

N/A

4. QUESTION_ID NUMBER[10] NO YES N/A

N/A

5. ANSWER_TEXT NVARCHAR2[2000] YES YES N/A

N/A

6. NOT_SURE_FLAG CHAR[1] YES YES N/A

N/A

7. POINTS_ASSIGNED NUMBER[10] YES YES N/A

N/A

8. Q_RESULT_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

9. Q_RESULT_CREATE_DATETIME DATE[7] NO YES N/A

N/A

10. Q_RESULT_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

11. Q_RESULT_UPDATE_DATETIME DATE[7] YES YES N/A

N/A

12. QUESTION_TEXT NVARCHAR2[2000] NO YES N/A

N/A

13. PICTURE BLOB[4000] YES YES N/A

N/A

14. QUESTION_DURATION NUMBER[10] YES YES N/A

N/A

15. QUESTION_DIFFICULTY NUMBER[0] YES YES N/A

N/A

16. QUESTION_POINTS NUMBER[0] YES YES N/A

N/A

17. EXCEL_QUESTION_ID NUMBER[10] YES YES N/A

N/A

18. QUESTION_MULTI_CHOICE_IND VARCHAR2[3] YES YES N/A

N/A

19. QUESTION_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

20. QUESTION_CREATE_DATETIME DATE[7] NO YES N/A

N/A

21. QUESTION_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

22. QUESTION_UPDATE_DATETIME DATE[7] YES YES N/A

N/A

23. ANSWER_ID NUMBER[10] NO YES N/A

N/A

24. ANSWER_ANSWERED_TEXT VARCHAR2[2000] NO YES N/A

N/A

25. ANSWER_ORDINAL_NUMBER NUMBER[0] YES YES N/A

N/A

26. CORRECT_ANSWER_IND CHAR[1] YES YES N/A

N/A

27. ANSWER_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

28. ANSWER_CREATE_DATETIME DATE[7] NO YES N/A

N/A

29. ANSWER_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

30. ANSWER_UPDATE_DATETIME DATE[7] YES YES N/A

N/A

31. USER_USERNAME NVARCHAR2[100] NO YES N/A

N/A

32. USER_FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

33. USER_LAST_NAME VARCHAR2[50] NO YES N/A

N/A

34. USER_SEMESTER NUMBER[0] YES YES N/A

N/A

35. USER_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

36. USER_USER_TYPE VARCHAR2[3] YES YES N/A

N/A

37. USER_STATUS VARCHAR2[3] YES YES N/A

N/A



# 65
Table Name V_QUIZ_RESULT_SUM
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_INSTANCE_ID NUMBER[10] NO YES N/A

N/A

2. USER_ID_TESTED NUMBER[10] NO YES N/A

N/A

3. MAX_POINTS NUMBER[0] YES YES N/A

N/A

4. POINTS_ASSIGNED NUMBER[0] YES YES N/A

N/A

5. PERCENT_SCORED NUMBER[0] YES YES N/A

N/A



# 66
Table Name V_ROLES_PERMISSIONS
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. ROLE_CODE VARCHAR2[3] NO YES N/A

N/A

2. ROLE_NAME VARCHAR2[50] NO YES N/A

N/A

3. ROLE_DESCRIPTION VARCHAR2[400] YES YES N/A

N/A

4. GRANTABLE CHAR[1] YES YES N/A

N/A

5. ROLE_ENABLED CHAR[1] NO YES N/A

N/A

6. FUNCTION_CODE VARCHAR2[3] NO YES N/A

N/A

7. FUNCTION_NAME VARCHAR2[50] NO YES N/A

N/A

8. FUNCTION_DESCRIPTION VARCHAR2[400] YES YES N/A

N/A

9. FUNCTION_ENABLED CHAR[1] NO YES N/A

N/A

10. ROLE_FUNCTION_ENABLED CHAR[1] NO YES N/A

N/A



# 67
Table Name V_ST_QUIZ
Owner YTM11
Type VIEW
Row Count N/A
Remarks Used during load from staging tables into permanent tables in the database

# Column Type PK Null Unique Cardinality Sample Data Comment
1. ST_QUIZ_ID NUMBER[10] NO YES N/A

N/A

Primary key
2. ST_QUESTION_ID NUMBER[10] NO YES N/A

N/A

Primary key of table table ST_QUESTION_ID
3. ST_ANSWER_ID NUMBER[10] NO YES N/A

N/A

Primary key of table table ST_ANSWER
4. USERNAME NVARCHAR2[100] NO YES N/A

N/A

Username has to be unique across the system. Use of email adress is encouraged however it cannot be enforced because many user will not have e-mail addresses or they will not provide it for various reasons.
5. PASSWORD CHAR[10] YES YES N/A

N/A

PASSWORD
6. USER_ID NUMBER[10] YES YES N/A

N/A

USER ID
7. QUIZ_NAME NVARCHAR2[100] NO YES N/A

N/A

Name (Title) of this test.
8. DEFAULT_DURATION NUMBER[10] YES YES N/A

N/A

Test duration in seconds. This is time available to complete the test once test instance started.
9. USERS_COMMENT NVARCHAR2[2000] YES YES N/A

N/A

USERS COMMENT
10. DEFAULT_ENABLED_FROM DATE[7] YES YES N/A

N/A

DEFAULT ENABLED FROM
11. DEFAULT_ENABLED_TO DATE[7] YES YES N/A

N/A

DEFAULT ENABLED TO
12. RESULT_TRANSPARENCY VARCHAR2[20] YES YES N/A

N/A

RESULT TRANSPARENCY
13. DURATION_FACTOR NUMBER[10] YES YES N/A

N/A

Factor (in percents, for example: -40%, +120%, +300%) - how much the available time for answering the questions should be shortened or prolonged. Apply duration factor to the length of every question. On this way duration of the questions can be parametrized.
14. STATUS CHAR[1] NO YES N/A

N/A

"S" - Loaded only in staging tables "L" - Loaded into permanent tables, data from staging tables can be deleted
15. CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

CREATE USER ID
16. CREATE_DATETIME DATE[7] NO YES N/A

N/A

CREATE DATETIME
17. QST_ARTIFICIAL_QUESTION_ID NUMBER[10] NO YES N/A

N/A

This is number assigned by user in order to link questions with answers in excel.
18. QUESTION_TEXT NVARCHAR2[2000] NO YES N/A

N/A

QUESTION TEXT
19. PICTURE BLOB[4000] YES YES N/A

N/A

This is picture that is displayed with question.
20. DURATION NUMBER[10] YES YES N/A

N/A

Duration of the question in seconds. This is optional value and it is intended to be used to limit time available to answer this question.
21. DIFFICULTY NUMBER[0] YES YES N/A

N/A

This is degree of difficulty. Higher number represents higher difficulty of question.
22. POINTS NUMBER[0] YES YES N/A

N/A

Number of points that person gets by answering this question correctly. For example difficult questions can score more points than the others. This is the "weight" of the question.
23. QUESTION_ORDINAL_NUMBER NUMBER[0] YES YES N/A

N/A

This number determines the order of this question as it appears on the test. Lower numbers are displayed first. If this number is not present then questions will be displayed in default order.
24. ANS_ARTIFICIAL_QUESTION_ID NUMBER[10] NO YES N/A

N/A

This is number assigned by user in order to link questions with answers in excel.
25. ANSWER_TEXT NVARCHAR2[2000] YES YES N/A

N/A

ANSWER_TEXT
26. ANSWER_ORDINAL_NUMBER NUMBER[0] YES YES N/A

N/A

This number determines the order of this answer as it appears on the test. Lower numbers are displayed first. If this number is not present then answers will be displayed in default order.
27. CORRECT_ANSWER_IND CHAR[1] YES YES N/A

N/A

Indicates if this is the correct answer.


# 68
Table Name V_SUBCAT_AND_COURSES_SUM
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. QUIZ_COUNT NUMBER[0] YES YES N/A

N/A

2. PARENT_QUIZ_CAT NUMBER[10] YES YES N/A

N/A



# 69
Table Name V_USER_ACTIONS
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USERNAME NVARCHAR2[100] NO YES N/A

N/A

2. PASSWORD VARCHAR2[50] NO YES N/A

N/A

3. ACTION_CODE VARCHAR2[10] NO YES N/A

N/A

4. CREATE_DATETIME TIMESTAMP(6)[11,6] NO YES N/A

N/A



# 70
Table Name V_USER_CLASS
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. USER_FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

4. USER_LAST_NAME VARCHAR2[50] NO YES N/A

N/A

5. USER_SEMESTER NUMBER[0] YES YES N/A

N/A

6. USER_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. CLASS_ID NUMBER[10] NO YES N/A

N/A

10. CLASS_NAME VARCHAR2[200] NO YES N/A

N/A

11. CLASS_CODE VARCHAR2[30] YES YES N/A

N/A

12. CLASS_ACTIVE_FROM DATE[7] YES YES N/A

N/A

13. CLASS_ACTIVE_TO DATE[7] YES YES N/A

N/A

14. CLASS_STATUS CHAR[3] YES YES N/A

N/A

15. USER_CLASS_ROLE VARCHAR2[3] YES YES N/A

N/A

16. CLASS_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

17. CLASS_CREATE_DATETIME DATE[7] NO YES N/A

N/A

18. CLASS_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

19. CLASS_UPDATE_DATETIME DATE[7] YES YES N/A

N/A



# 71
Table Name V_USER_CLASS_COURSE
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] YES YES N/A

N/A

2. USERNAME NVARCHAR2[100] YES YES N/A

N/A

3. USER_FIRST_NAME VARCHAR2[50] YES YES N/A

N/A

4. USER_LAST_NAME VARCHAR2[50] YES YES N/A

N/A

5. USER_SEMESTER NUMBER[0] YES YES N/A

N/A

6. USER_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. CLASS_ID NUMBER[0] YES YES N/A

N/A

10. CLASS_CODE VARCHAR2[30] YES YES N/A

N/A

11. CLASS_NAME VARCHAR2[200] YES YES N/A

N/A

12. USER_CLASS_ROLE VARCHAR2[3] YES YES N/A

N/A

13. CLASS_ACTIVE_FROM DATE[7] YES YES N/A

N/A

14. CLASS_ACTIVE_TO DATE[7] YES YES N/A

N/A

15. CLASS_STATUS VARCHAR2[3] YES YES N/A

N/A

16. COURSE_ID NUMBER[10] YES YES N/A

N/A

17. PARENT_COURSE_ID NUMBER[10] YES YES N/A

N/A

18. COURSE_NAME VARCHAR2[300] YES YES N/A

N/A

19. COURSE_CODE VARCHAR2[30] YES YES N/A

N/A

20. COURSE_STATUS VARCHAR2[3] YES YES N/A

N/A

21. COURSE_CATEGORY_LEVEL NUMBER[0] YES YES N/A

N/A

22. COURSE_DESCRIPTION VARCHAR2[2000] YES YES N/A

N/A

23. COURSE_CREDITS NUMBER[0] YES YES N/A

N/A

24. COURSE_DURATION_IN_HRS NUMBER[0] YES YES N/A

N/A

25. COURSE_DEPARTMENT_ID VARCHAR2[3] YES YES N/A

N/A

26. COURSE_SEMESTER NUMBER[0] YES YES N/A

N/A

27. COURSE_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

28. USER_COURSE_ROLE VARCHAR2[3] YES YES N/A

N/A



# 72
Table Name V_USER_COURSE
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. USER_FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

4. USER_LAST_NAME VARCHAR2[50] NO YES N/A

N/A

5. USER_SEMESTER NUMBER[0] YES YES N/A

N/A

6. USER_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. USER_COURSE_ROLE VARCHAR2[3] YES YES N/A

N/A

10. COURSE_ID NUMBER[10] NO YES N/A

N/A

11. PARENT_COURSE_ID NUMBER[10] YES YES N/A

N/A

12. COURSE_NAME VARCHAR2[300] NO YES N/A

N/A

13. COURSE_CODE VARCHAR2[30] YES YES N/A

N/A

14. COURSE_STATUS VARCHAR2[3] YES YES N/A

N/A

15. COURSE_CATEGORY_LEVEL NUMBER[0] NO YES N/A

N/A

16. COURSE_DESCRIPTION VARCHAR2[2000] NO YES N/A

N/A

17. COURSE_CREDITS NUMBER[0] YES YES N/A

N/A

18. COURSE_DURATION_IN_HRS NUMBER[0] YES YES N/A

N/A

19. COURSE_DEPARTMENT_ID VARCHAR2[3] YES YES N/A

N/A

20. COURSE_SEMESTER NUMBER[0] YES YES N/A

N/A

21. COURSE_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

22. COURSE_CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

23. COURSE_CREATE_DATETIME DATE[7] NO YES N/A

N/A

24. COURSE_UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

25. COURSE_UPDATE_DATETIME DATE[7] YES YES N/A

N/A



# 73
Table Name V_USER_COURSE_ROLE
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USER_FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

3. USER_LAST_NAME VARCHAR2[50] NO YES N/A

N/A

4. USER_ROLE_CODE VARCHAR2[3] NO YES N/A

N/A

5. COURSE_ID NUMBER[10] NO YES N/A

N/A



# 74
Table Name V_USER_COURSE_TREE
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. USER_FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

4. USER_LAST_NAME VARCHAR2[50] NO YES N/A

N/A

5. USER_SEMESTER NUMBER[0] YES YES N/A

N/A

6. USER_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. USER_COURSE_ROLE VARCHAR2[3] YES YES N/A

N/A

10. COURSE_ID NUMBER[10] YES YES N/A

N/A

11. PARENT_COURSE_ID NUMBER[10] YES YES N/A

N/A

12. COURSE_NAME VARCHAR2[300] YES YES N/A

N/A

13. COURSE_CODE VARCHAR2[30] YES YES N/A

N/A

14. COURSE_STATUS VARCHAR2[3] YES YES N/A

N/A

15. TOP_COURSE VARCHAR2[300] YES YES N/A

N/A

16. COURSE_DESCRIPTION VARCHAR2[2000] YES YES N/A

N/A

17. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

18. TABLE_LEVEL NUMBER[0] YES YES N/A

N/A

19. IS_LEAF NUMBER[0] YES YES N/A

N/A

20. COURSE_COUNT NUMBER[0] YES YES N/A

N/A

21. COURSE_TREE VARCHAR2[4000] YES YES N/A

N/A

22. COURSE_PATH VARCHAR2[4000] YES YES N/A

N/A

23. CREDITS NUMBER[0] YES YES N/A

N/A

24. DURATION_IN_HRS NUMBER[0] YES YES N/A

N/A

25. DEPARTMENT_ID VARCHAR2[3] YES YES N/A

N/A

26. SEMESTER NUMBER[0] YES YES N/A

N/A

27. YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A



# 75
Table Name V_USER_POOLS
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. USER_FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

4. USER_LAST_NAME VARCHAR2[50] NO YES N/A

N/A

5. USER_SEMESTER NUMBER[0] YES YES N/A

N/A

6. USER_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. USER_POOL_ROLE VARCHAR2[3] YES YES N/A

N/A

10. POOL_ID NUMBER[10] NO YES N/A

N/A

11. POOL_NAME VARCHAR2[100] NO YES N/A

N/A

12. POOL_DESCRIPTION VARCHAR2[500] NO YES N/A

N/A

13. CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

14. CREATE_DATETIME DATE[7] NO YES N/A

N/A

15. UPDATE_USER_ID NUMBER[10] YES YES N/A

N/A

16. UPDATE_DATETIME DATE[7] YES YES N/A

N/A



# 76
Table Name V_USER_POOLS_TREE
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. USER_FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

4. USER_LAST_NAME VARCHAR2[50] NO YES N/A

N/A

5. USER_SEMESTER NUMBER[0] YES YES N/A

N/A

6. USER_YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. USERS_POOL_ROLE VARCHAR2[3] YES YES N/A

N/A

10. POOL_ID NUMBER[10] YES YES N/A

N/A

11. PARENT_POOL_ID NUMBER[10] YES YES N/A

N/A

12. POOL_NAME VARCHAR2[100] YES YES N/A

N/A

13. TOP_POOL VARCHAR2[100] YES YES N/A

N/A

14. POOL_DESCRIPTION VARCHAR2[500] YES YES N/A

N/A

15. SYSTEM_LEVEL NUMBER[0] YES YES N/A

N/A

16. IS_LEAF NUMBER[0] YES YES N/A

N/A

17. POOL_COUNT NUMBER[0] YES YES N/A

N/A

18. POOL_TREE VARCHAR2[4000] YES YES N/A

N/A

19. POOL_PATH VARCHAR2[4000] YES YES N/A

N/A



# 77
Table Name V_USER_POOL_SUM_QUESTIONS
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. POOL_ID NUMBER[10] NO YES N/A

N/A

2. POOL_NAME VARCHAR2[100] NO YES N/A

N/A

3. POOL_DESCRIPTION VARCHAR2[500] NO YES N/A

N/A

4. CREATE_USER_ID NUMBER[10] NO YES N/A

N/A

5. CREATE_DATETIME DATE[7] NO YES N/A

N/A

6. USER_ID NUMBER[10] NO YES N/A

N/A

7. USERS_POOL_ROLE VARCHAR2[3] YES YES N/A

N/A

8. NUMBER_OF_QUESTIONS NUMBER[0] YES YES N/A

N/A



# 78
Table Name V_USER_ROLES
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

4. LAST_NAME VARCHAR2[50] NO YES N/A

N/A

5. SEMESTER NUMBER[0] YES YES N/A

N/A

6. YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. ROLE_CODE VARCHAR2[3] NO YES N/A

N/A

10. ROLE_NAME VARCHAR2[50] NO YES N/A

N/A

11. ROLE_DESCRIPTION VARCHAR2[400] YES YES N/A

N/A

12. GRANTABLE CHAR[1] YES YES N/A

N/A

13. ROLE_ENABLED CHAR[1] NO YES N/A

N/A



# 79
Table Name V_USER_ROLES_PERMISSIONS
Owner YTM11
Type VIEW
Row Count N/A
Remarks

# Column Type PK Null Unique Cardinality Sample Data Comment
1. USER_ID NUMBER[10] NO YES N/A

N/A

2. USERNAME NVARCHAR2[100] NO YES N/A

N/A

3. FIRST_NAME VARCHAR2[50] NO YES N/A

N/A

4. LAST_NAME VARCHAR2[50] NO YES N/A

N/A

5. SEMESTER NUMBER[0] YES YES N/A

N/A

6. YEAR_OF_STUDY NUMBER[0] YES YES N/A

N/A

7. USER_TYPE VARCHAR2[3] YES YES N/A

N/A

8. USER_STATUS VARCHAR2[3] YES YES N/A

N/A

9. ROLE_CODE VARCHAR2[3] NO YES N/A

N/A

10. ROLE_NAME VARCHAR2[50] NO YES N/A

N/A

11. ROLE_DESCRIPTION VARCHAR2[400] YES YES N/A

N/A

12. GRANTABLE CHAR[1] YES YES N/A

N/A

13. ROLE_ENABLED CHAR[1] NO YES N/A

N/A

14. FUNCTION_CODE VARCHAR2[3] NO YES N/A

N/A

15. FUNCTION_NAME VARCHAR2[50] NO YES N/A

N/A

16. FUNCTION_DESCRIPTION VARCHAR2[400] YES YES N/A

N/A

17. FUNCTION_ENABLED CHAR[1] NO YES N/A

N/A

18. ROLE_FUNCTION_ENABLED CHAR[1] NO YES N/A

N/A


Orphan tableThis is table with no relationships
Invalid viewSQL Query that creates this view is invalid.
Tables or columns referenced in this view don't exist.
No primary keyIf table does not have a primary key then records cannot be uniquely identified.
Operations like update and delete cannot be safely performed record.
Unique index is not reliable way to uniquely identify records if any column of that index is not mandatory field.