YouTestMe Database Report

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

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

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

#	Database
1.	DEFAULT_DATABASE

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

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

Detailed Table Information

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

Column

References

Sample Data

Comment

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

N/A

ADDRESS ID

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

References PK column

Table	Column
USERS	USER_ID

N/A

USER ID

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

N/A

STREET

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

N/A

ADDITIONAL ADDRESS INFORMATION

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

N/A

BUILDING NUMBER

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

N/A

This is apartment or townhouse number. It may have an alphanumeric values such as "PH 4" (penthouse #4)

Name	CITY
Ordinal #	7
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

CITY

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

N/A

This field will contain: Postal Code (Canada) ZIP (US) Postanski Broj (Balkan countries) Equivalent information for other countries

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

N/A

STATE

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

N/A

COUNTRY

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

N/A

URL of the Address. For example, GOOGLE mal URL.

Name	ADDRESS_TYPE
Ordinal #	12
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

P - Personal (Home) B - Business (Office)

Name	SHIPPING_ADDRESS_IND
Ordinal #	13
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Indicated if this is a shipping address.

Name	BILLING_ADDRESS_IND
Ordinal #	14
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Indicates if this is a Billing address

Name	SHIPP_BILL_ADR_SAME_IND
Ordinal #	15
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Indicates if shipping and billing addresses are the same

Name	ACTIVE_FROM
Ordinal #	16
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

ACTIVE FROM

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

N/A

In this value is NULL then this recor represents the current address

Name	ADDRESS_STATUS
Ordinal #	18
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Status of this address

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

Name	ANSWER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	605 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
QUIZ_RESULT_ANSWER	ANSWER_ID

Value	Length	Count
5000		1
5001		1
5002		1
5003		1
5004		1
5005		1
5006		1
5007		1
5008		1
5009		1

ANSWER ID

Name	QUESTION_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	121 (20.00%)
Unique	NO

References PK column

Table	Column
QUESTION	QUESTION_ID

Value	Length	Count
5000		5
5001		5
5002		5
5003		5
5004		5
5005		5
5006		5
5007		5
5008		5
5009		5

QUESTION ID

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

N/A

This is free form text for "essay" answers. It is also used for "FILL IN BLANKS" type of questions.

Name	ANSWER_ORDINAL_NUMBER
Ordinal #	4
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	5 (0.83%)
Unique	NO

Value	Length	Count
2		123
1		121
4		121
5		121
3		119

Determines the order in which question will appear in the list under the question.

Name	CORRECT_ANSWER_IND
Ordinal #	5
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	2 (0.33%)
Unique	NO

Value	Length	Count
null	0	485
Y	1	120

Indicates if this is the correct answer.

Name	ANSWER_ADDITIONAL_INFO
Ordinal #	6
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

This is additional inforamtion that can be used to explain the answer. It may be used for educational purposes.

Name	CREATE_USER_ID
Ordinal #	7
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (0.17%)
Unique	NO

Value	Length	Count
0		605

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	8
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	5 (0.83%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:51:08.0000		137
Sun Feb 23, 2014 09:51:09.0000		121
Sun Feb 23, 2014 09:51:11.0000		120
Sun Feb 23, 2014 09:51:07.0000		118
Sun Feb 23, 2014 09:51:10.0000		109

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	9
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.17%)
Unique	NO

Value	Length	Count
null		605

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	10
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (0.17%)
Unique	NO

Value	Length	Count
null		605

UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	3
Table Name	CLASS
Owner	YTM11
Type	TABLE
Row Count	25
Remarks	Describes a class of users (usually Students).

Column

References

Sample Data

Comment

Name	CLASS_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	25 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
CLASS_COURSE	CLASS_ID
QUIZ_INSTANCE	CLASS_ID
USERS_CLASS	CLASS_ID

Value	Length	Count
1		1
2		1
3		1
4		1
5		1
6		1
7		1
8		1
9		1
10		1

CLASS_ID

Name	CLASS_NAME
Ordinal #	2
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	NO
Cardinality	25 (100.00%)
Unique	YES

Value	Length	Count
Class I-a	9	1
Class I-b	9	1
Class I-c	9	1
Class I-d	9	1
Class I-e	9	1
Class II-a	10	1
Class II-b	10	1
Class II-c	10	1
Class II-d	10	1
Class II-e	10	1

CLASS_NAME

Name	CLASS_CODE
Ordinal #	3
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	1 (4.00%)
Unique	NO

Value	Length	Count
null	0	25

CLASS_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CLASS_DESCRIPTION
Ordinal #	4
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	1 (4.00%)
Unique	NO

Value	Length	Count
null	0	25

Description of the CLASS or the comment about the CLASS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	ACTIVE_FROM
Ordinal #	5
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	5 (20.00%)
Unique	NO

Value	Length	Count
Mon Feb 24, 2003 08:10:05.0000		5
Fri Apr 23, 2004 08:18:25.0000		5
Fri Dec 24, 2004 05:10:55.0000		5
Fri Dec 24, 2004 10:10:55.0000		5
Thu Dec 25, 2008 06:10:17.0000		5

Witch column "ACTIVE_TO" describes the period when this Student Class is active. For example it could be specifict school year.

Name	ACTIVE_TO
Ordinal #	6
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	25 (100.00%)
Unique	YES

Value	Length	Count
Fri Dec 25, 2015 06:10:17.0000		1
Sat Dec 26, 2015 06:10:17.0000		1
Sun Dec 27, 2015 06:10:17.0000		1
Mon Dec 28, 2015 06:10:17.0000		1
Tue Dec 29, 2015 06:10:17.0000		1
Wed Dec 30, 2015 06:10:17.0000		1
Thu Dec 31, 2015 06:10:17.0000		1
Fri Jan 1, 2016 06:10:17.0000		1
Sat Jan 2, 2016 06:10:17.0000		1
Sun Jan 3, 2016 06:10:17.0000		1

With column "ACTIVE_FROM" describes the period when this Student Class is active. For example it could be specifict school year.

Name	CLASS_STATUS
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (4.00%)
Unique	NO

Value	Length	Count
ATV	3	25

Describes the status of the Student Class. For example: - Stand By (prepared for next year) - Active - Finished
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_USER_ID
Ordinal #	8
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (4.00%)
Unique	NO

Value	Length	Count
1		25

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	9
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	2 (8.00%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:50:47.0000		24
Sun Feb 23, 2014 09:50:46.0000		1

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	10
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (4.00%)
Unique	NO

Value	Length	Count
null		25

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	11
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (4.00%)
Unique	NO

Value	Length	Count
null		25

UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	4
Table Name	CLASS_COURSE
Owner	YTM11
Type	TABLE
Row Count	93
Remarks	Describes which classes of users are assigned to what Courses. User can be enrolled to the Course only through the Class

Column

References

Sample Data

Comment

Name	CLASS_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	3 (3.23%)
Unique	NO

References PK column

Table	Column
CLASS	CLASS_ID

Value	Length	Count
1		31
2		31
3		31

CLASS_ID

Name	COURSE_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #	2
Nullable	NO
Cardinality	31 (33.33%)
Unique	NO

References PK column

Table	Column
COURSE	COURSE_ID

Value	Length	Count
2		3
3		3
4		3
5		3
6		3
7		3
8		3
9		3
26		3
27		3

COURSE_ID

Name	CREATE_USER_ID
Ordinal #	3
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (1.08%)
Unique	NO

Value	Length	Count
0		93

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	4
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	2 (2.15%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:51:14.0000		86
Sun Feb 23, 2014 09:51:13.0000		7

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	5
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (1.08%)
Unique	NO

Value	Length	Count
null		93

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	6
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (1.08%)
Unique	NO

Value	Length	Count
null		93

UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	5
Table Name	CODE
Owner	YTM11
Type	TABLE
Row Count	71
Remarks	CODE

Column

References

Sample Data

Comment

Name	CODE_ID
Ordinal #	1
Data Type	VARCHAR2[3]
PK Seq. #	1
Nullable	NO
Cardinality	71 (100.00%)
Unique	YES

Value	Length	Count
AAL	3	1
ACE	3	1
ACT	3	1
ADS	3	1
AOL	3	1
AOP	3	1
APR	3	1
ATN	3	1
ATR	3	1
ATV	3	1

This column is created to be sole column in Primary Key. This is intentional because this way all codes are unique accross the system and there is no posibility for confusion (for example: "what code type is this code?")

Name	CODE_TYPE_ID
Ordinal #	2
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	23 (32.39%)
Unique	NO

References PK column

Table	Column
CODE_TYPE	CODE_TYPE_ID

Value	Length	Count
QST	3	8
QUT	3	7
USS	3	5
QAS	3	4
QDS	3	4
AST	3	3
COS	3	3
CST	3	3
DUT	3	3
ESS	3	3

CODE TYPE ID

Name	CODE_NAME
Ordinal #	3
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	60 (84.51%)
Unique	NO

Value	Length	Count
ACTIVE	6	4
DELETED	7	3
CANCELLED	9	2
DEFFERED	8	2
EXPIRED	7	2
INACTIVE	8	2
MANAGER	7	2
SUSPENDED	9	2
ADMINISTRATOR	13	1
ALL ON PAGE	11	1

CODE NAME

Name	CODE_DESCRIPTION
Ordinal #	4
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	NO
Cardinality	65 (91.55%)
Unique	NO

Value	Length	Count
Active	6	4
Cancelled	9	2
Deleted	7	2
Inactive	8	2
ATTEMPTED NO REPORT	19	1
ATTEMPTED WITH REPOR...	23	1
Administrator	13	1
All questions on one...	23	1
Alternate	9	1
Assigned	8	1

CODE DESCRIPTION

Name	CODE_LONG_DESCRIPTION
Ordinal #	5
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	1 (1.41%)
Unique	NO

Value	Length	Count
null	0	71

CODE LONG DESCRIPTION
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	ALTERNATE_CODE_VALUE
Ordinal #	6
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (1.41%)
Unique	NO

Value	Length	Count
null	0	71

Sometime it is practical to associate some meaningful value to the code in order to do some calculation, sorting or similar. For example Question difficulty alternate values could be: 1, 2, 3 and so on.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	6
Table Name	CODE_TYPE
Owner	YTM11
Type	TABLE
Row Count	24
Remarks	CODE TYPE

Column

References

Sample Data

Comment

Name	CODE_TYPE_ID
Ordinal #	1
Data Type	VARCHAR2[3]
PK Seq. #	1
Nullable	NO
Cardinality	24 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
CODE	CODE_TYPE_ID

Value	Length	Count
ADT	3	1
AST	3	1
COS	3	1
CRT	3	1
CST	3	1
DUT	3	1
ESS	3	1
GEN	3	1
LOT	3	1
QAS	3	1

CODE TYPE ID

Name	CODE_TYPE_NAME
Ordinal #	2
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	24 (100.00%)
Unique	YES

Value	Length	Count
ADDRESS STATUS	14	1
ADDRESS TYPE	12	1
CLASS STATUS	12	1
COURSE STATUS	13	1
CREATE TYPE	11	1
DURATION TYPE	13	1
EMAIL SENT STATUS	17	1
GENDER CODE	11	1
LOOK TYPE	9	1
QUESTION DIFFICULTY	19	1

CODE TYPE NAME

Name	CODE_TYPE_DESCRIPTION
Ordinal #	3
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	NO
Cardinality	24 (100.00%)
Unique	YES

Value	Length	Count
Address Status	14	1
Address Type	12	1
Class of Users Statu...	23	1
Course Status	13	1
Describes User's ro...	23	1
Describes User's ro...	23	1
Describes how the re...	23	1
Describes type of th...	23	1
Describes when the r...	23	1
Email Sent Status	17	1

CODE TYPE DESCRIPTION

Name	CODE_TYPE_LONG_DESCRIPTION
Ordinal #	4
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	1 (4.17%)
Unique	NO

Value	Length	Count
null	0	24

CODE TYPE LONG DESCRIPTION
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	7
Table Name	COURSE
Owner	YTM11
Type	TABLE
Row Count	65
Remarks	School Courses

Column

References

Sample Data

Comment

Name	COURSE_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	65 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
CLASS_COURSE	COURSE_ID
COURSE	PARENT_COURSE_ID
QUIZ_INSTANCE	COURSE_ID
USER_COURSE	COURSE_ID

Value	Length	Count
1		1
2		1
3		1
4		1
5		1
6		1
7		1
8		1
9		1
10		1

COURSE_ID

Name	PARENT_COURSE_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	16 (24.62%)
Unique	NO

References PK column

Table	Column
COURSE	COURSE_ID

Value	Length	Count
16		8
2		7
42		7
51		7
35		6
null		6
60		5
11		4
26		3
30		3

Course may have a parent course. This is made for flexibility, it may not be used very frequently.

Name	COURSE_NAME
Ordinal #	3
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	NO
Cardinality	65 (100.00%)
Unique	YES

Value	Length	Count
Advanced Accounting ...	23	1
Advanced Auditing	17	1
Advanced Financial A...	23	1
Animal Behaviour	16	1
Animal Physiology La...	23	1
Art and Culture	15	1
Astronomy	9	1
Astrophysics Researc...	23	1
Astrophysics of Plan...	23	1
Astrophysics of Star...	23	1

COURSE_NAME

Name	COURSE_CODE
Ordinal #	4
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	51 (78.46%)
Unique	NO

Value	Length	Count
null	0	15
ASTA01H3	8	1
ASTA02H3	8	1
ASTB03H3	8	1
ASTB23H3	8	1
ASTC25H3	8	1
ASTD01H3	8	1
ASTD02H3	8	1
BIOA01H3	8	1
BIOA02H3	8	1

Code may have a code used by the school.

Name	COURSE_STATUS
Ordinal #	5
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
ACE	3	65

COURSE_STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CATEGORY_LEVEL
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	NO
Cardinality	3 (4.62%)
Unique	NO

Value	Length	Count
3		50
2		9
1		6

This is helper field that will indicate level of this category in a tree of categories. For example: top level will be "1", second level (child of level "1") will be "2" and so on.

Name	COURSE_DESCRIPTION
Ordinal #	7
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

COURSE_DESCRIPTION

Name	CREDITS
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
null		65

Number of Credits carried by this course.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	DURATION_IN_HRS
Ordinal #	9
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
null		65

Duration of the course in hours
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	DEPARTMENT_ID
Ordinal #	10
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
null	0	65

DEPARTMENT_ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	SEMESTER
Ordinal #	11
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
null		65

SEMESTER
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	YEAR_OF_STUDY
Ordinal #	12
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
null		65

YEAR_OF_STUDY
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_USER_ID
Ordinal #	13
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
1		65

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	14
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	2 (3.08%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:51:13.0000		48
Sun Feb 23, 2014 09:51:12.0000		17

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	15
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
null		65

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	16
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (1.54%)
Unique	NO

Value	Length	Count
null		65

UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

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

Column

References

Sample Data

Comment

Name	DOCUMENT_ID
Ordinal #	1
Data Type	NUMBER[0]
PK Seq. #	1
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

DOCUMENT ID

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

N/A

DOCUMENT TITLE

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

N/A

DOCUMENT DESCRIPTION

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

N/A

DOCUMENT BINARY CONTENT

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

N/A

DOCUMENT CHAR CONTENT

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

N/A

FILE_NAME

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

N/A

document path to in the file system. This can be source or destination path.

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

N/A

EMAIL_SENT_ID

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

References PK column

Table	Column
QUIZ_EMAIL_ACTION	QUIZ_EMAIL_ACTION_ID

N/A

QUIZ_EMAIL ACTION_ID

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

N/A

EVENT_DATE_TIME

Name	EMAIL_SENT_STATUS
Ordinal #	4
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Email Sent Status

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

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
QUIZ_EMAIL_ACTION	EMAIL_TEMPLATE_ID

N/A

EMAIL_TEMPLATE_ID

Name	EMAIL_TEMPLATE
Ordinal #	2
Data Type	BLOB[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Email template may be in a rich text format.

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

Column

References

Sample Data

Comment

Name	FUNCTION_CODE
Ordinal #	1
Data Type	VARCHAR2[3]
PK Seq. #	1
Nullable	NO
Cardinality	14 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
ROLE_FUNCTION	FUNCTION_CODE

Value	Length	Count
CCL	3	1
CHP	3	1
COD	3	1
CPD	3	1
CRC	3	1
CRQ	3	1
CRR	3	1
CRU	3	1
EDC	3	1
EDE	3	1

FUNCTION CODE

Name	FUNCTION_NAME
Ordinal #	2
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	14 (100.00%)
Unique	YES

Value	Length	Count
Change Others Person...	23	1
Change Own Personal ...	23	1
Change Password	15	1
Create Class	12	1
Create Course	13	1
Create Quiz	11	1
Create Role	11	1
Create User	11	1
Edit Class	10	1
Edit Course	11	1

This is the name (short description) of the system function: For example: 1. Create User 2. Delete user 3. Create Quiz 4. Reports

Name	FUNCTION_DESCRIPTION
Ordinal #	3
Data Type	VARCHAR2[400]
PK Seq. #
Nullable	YES
Cardinality	14 (100.00%)
Unique	YES

Value	Length	Count
Change Others Person...	23	1
Change Own Personal ...	23	1
Change Password	15	1
Create Class	12	1
Create Course	13	1
Create Quiz	11	1
Create Role	11	1
Create User	11	1
Edit Class	10	1
Edit Course	11	1

Description of the system function.

Name	ENABLED
Ordinal #	4
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	1 (7.14%)
Unique	NO

Value	Length	Count
Y	1	14

ENABLED
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	12
Table Name	GRADING_SYSTEM
Owner	YTM11
Type	TABLE
Row Count	0
Remarks	Master table of the GRADING SYSTEM WARNING: Table is empty.

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
GRADING_SYSTEM_LABEL	GRADING_SYSTEM_ID
QUIZ_DEFINITION	GRADING_SYSTEM_ID
QUIZ_TEMPLATE	GRADING_SYSTEM_ID

N/A

Primarry Key

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

N/A

GRADING_SYSTEM_NAME

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

N/A

GRADING_SYSTEM_DESCRIPTION

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

N/A

Primary Key

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

References PK column

Table	Column
GRADING_SYSTEM	GRADING_SYSTEM_ID

N/A

Primarry Key

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

N/A

GRADING_SYSTEM_LABEL_CODE

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

N/A

GRADING_SYSTEM_LABEL_NAME

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

N/A

PERCENT_MINIMUM

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

N/A

PERCENT_MAXIMUM

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

Name	LANGUAGE_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	72 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
USERS	LANGUAGE_ID

Value	Length	Count
1		1
2		1
3		1
4		1
5		1
6		1
7		1
8		1
9		1
10		1

LANGUAGE ID

Name	LANGUAGE
Ordinal #	2
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	72 (100.00%)
Unique	YES

Value	Length	Count
Afrikanns	9	1
Albanian	8	1
Arabic	6	1
Armenian	8	1
Basque	6	1
Bengali	7	1
Bulgarian	9	1
Cambodian	9	1
Catalan	7	1
Chinese (Mandarin)	18	1

LANGUAGE

Name	LANGUAGE_CODE
Ordinal #	3
Data Type	CHAR[2]
PK Seq. #
Nullable	YES
Cardinality	1 (1.39%)
Unique	NO

Value	Length	Count
null	0	72

LANGUAGE_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

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

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
ORGANIZATION	PARENT_ORGANIZATION_ID
USERS	ORGANIZATION_ID

N/A

ORGANIZATION ID

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

References PK column

Table	Column
ORGANIZATION	ORGANIZATION_ID

N/A

PARENT_ORGANIZATION_ID

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

N/A

ORGANIZATION NAME

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

N/A

ORGANIZATION DESCRIPTION

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

N/A

Identifies category og organization: - Univesity - College - Community College - High School - Commercial - Manufacturing

Name	ORGANIZATION_STATUS
Ordinal #	6
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

Status of the Organization: - Active - Inactive - Deleted

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

Name	POOL_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	70 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
POOL	PARENT_POOL_ID
POOL_QUESTION	POOL_ID
QUIZ_DEFINITION_POOL	POOL_ID
QUIZ_TEMPLATE_POOL	POOL_ID
USERS_POOLS	POOL_ID

Value	Length	Count
50		1
51		1
52		1
57		1
58		1
59		1
60		1
61		1
63		1
64		1

Pool of questions Primary Key

Name	PARENT_POOL_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	13 (18.57%)
Unique	NO

References PK column

Table	Column
POOL	POOL_ID

Value	Length	Count
50		16
60		12
58		6
59		6
64		5
66		5
67		5
68		5
57		4
null		3

Pool of question can belong to another pool. This way we can make hierarchy of pools. For example we can have a pool of questions from one lesson. All pools from certain lessons may belong to another Pool from particular Subject Area.

Name	POOL_NAME
Ordinal #	3
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	70 (100.00%)
Unique	YES

Value	Length	Count
Accounting	10	1
Accounting 1	12	1
Accounting 2	12	1
Accounting 3	12	1
Accounting 4	12	1
Business	8	1
Engineering	11	1
English	7	1
English 1	9	1
English 2	9	1

POOL NAME

Name	POOL_DESCRIPTION
Ordinal #	4
Data Type	VARCHAR2[500]
PK Seq. #
Nullable	NO
Cardinality	70 (100.00%)
Unique	YES

Value	Length	Count
Accounting	10	1
Accounting 1	12	1
Accounting 2	12	1
Accounting 3	12	1
Accounting 4	12	1
Business	8	1
Engineering	11	1
English	7	1
English 1	9	1
English 2	9	1

POOL_DESCRIPTION

Name	CREATE_USER_ID
Ordinal #	5
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (1.43%)
Unique	NO

Value	Length	Count
0		70

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	6
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	2 (2.86%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:51:16.0000		68
Sun Feb 23, 2014 09:51:17.0000		2

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	7
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (1.43%)
Unique	NO

Value	Length	Count
null		70

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	8
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (1.43%)
Unique	NO

Value	Length	Count
null		70

UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	17
Table Name	POOL_QUESTION
Owner	YTM11
Type	TABLE
Row Count	0
Remarks	POOL QUESTION WARNING: Table is empty.

Column

References

Sample Data

Comment

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

References PK column

Table	Column
QUESTION	QUESTION_ID

N/A

QUESTION ID

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

References PK column

Table	Column
POOL	POOL_ID

N/A

Pool of questions Primary Key

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

Column

References

Sample Data

Comment

Name	QUESTION_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	121 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
ANSWER	QUESTION_ID
POOL_QUESTION	QUESTION_ID
QUIZ_QUESTION	QUESTION_ID
QUIZ_RESULT	QUESTION_ID
SURVEY_QUESTION	QUESTION_ID

Value	Length	Count
5000		1
5001		1
5002		1
5003		1
5004		1
5005		1
5006		1
5007		1
5008		1
5009		1

QUESTION ID

Name	QUESTION_TEXT
Ordinal #	2
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

QUESTION TEXT

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

N/A

This field is used to create more complex questions, for example: - formatted text - formulas - videos - sounds - animations - diagrams

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

N/A

This is picture that is displayed with question.

Name	DURATION
Ordinal #	5
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Duration of the question in seconds. This is optional value and it is intended to be used to limit time avaiable to anwer this question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	DIFFICULTY_CODE
Ordinal #	6
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null	0	121

Difficulty code indicates difficulty level of the question. It is a code and therefore suitable to be used in the drop down list since display value can be stored in table "CODES".
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	DIFFICULTY
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

This is degree of difficulty. Data type is intentionally left NUMERIC so it is easier for comparison and sorting. It may be used in combination with DIFFICULTY_CODE or totally independent. Higher number represents higher difficulty of question. There could be a various scales of the difficulties, for example: 1-10 1-100 10-500 etc.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	EXCEL_QUESTION_ID
Ordinal #	8
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	31 (25.62%)
Unique	NO

Value	Length	Count
1001		4
1002		4
1003		4
1004		4
1005		4
1006		4
1007		4
1008		4
1009		4
1010		4

This is value used in excel spreadsheet to match Questions with Answers. It is used only for investigation. For questions NOT created by loading from Excel file this value will be NULL.

Name	POINTS
Ordinal #	9
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Number of points that person gets by answering this question correctly. For example difficult questions can score more points than the others. This is the "weight" of the question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	QUESTION_TYPE
Ordinal #	10
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null	0	121

Describes type of the question: SNC - Single Choice Question MLC - Multiple Choice Quesiton TFC - True False Question ESY - Essay Quesiton ORD - Ordering Question FBL - Fill in the Blanks Question MCH - Maching Question "Y" indicates that this is multiple choice question "N" or null indicates that this is not multiple choice answer.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	READ_ONLY_IND
Ordinal #	11
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null	0	121

If set to "Y" indicates that question is already assigned to someone and it cannot be edited any more.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	FREQUENCY_FACTOR
Ordinal #	12
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Factor that indicates how frequently this question should appear in quizzes. It is actually a probability that question will appear in the quiz. It can have values from 0 to 100 For example: 0 - Never 50 - it shoud appear on every other test 100 - Always
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	PENALTY
Ordinal #	13
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Number of points that person looses for choosing or fiving wrong answer.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	LARNING_FEEDBACK
Ordinal #	14
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null	0	121

The purpose of this text is to explain the correct answer or why other answers are incorrect. The value is in accelerated learning and providing explanation to student.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_USER_ID
Ordinal #	15
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
0		121

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	16
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	5 (4.13%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:51:08.0000		27
Sun Feb 23, 2014 09:51:09.0000		25
Sun Feb 23, 2014 09:51:07.0000		24
Sun Feb 23, 2014 09:51:11.0000		23
Sun Feb 23, 2014 09:51:10.0000		22

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	17
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	18
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	19
Table Name	QUIZ_CATEGORY
Owner	YTM11
Type	TABLE
Row Count	69
Remarks	Quiz Category. Quiz category structure. For example: 1. Science 1.1. Astronomy 1.2. Physics 1.2.1. Nuclear Physics 1.2.2. Quantum Physics 1.3 Medicine 2. Sports 2.1. Olympics 2.2. Soccer 2.2.1. European Soccer 2.2.2. South American Soccer 2.2.3. North American Soccer 2.3 NBA 3. History

Column

References

Sample Data

Comment

Name	QUIZ_CATEGORY_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	69 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
QUIZ_CATEGORY	PARENT_QUIZ_CATEGORY_ID
QUIZ_DEFINITION	QUIZ_CATEGORY_ID
QUIZ_TEMPLATE	QUIZ_CATEGORY_ID

Value	Length	Count
1000		1
1001		1
1002		1
1003		1
1004		1
1005		1
1006		1
1007		1
1008		1
1009		1

QUIZ_CATEGORY_ID

Name	PARENT_QUIZ_CATEGORY_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	22 (31.88%)
Unique	NO

References PK column

Table	Column
QUIZ_CATEGORY	QUIZ_CATEGORY_ID

Value	Length	Count
null		8
1017		6
1034		6
1000		4
1011		4
1025		4
1002		3
1007		3
1013		3
1041		3

PARENT_QUIZ CATEGORY ID

Name	CATEGORY_NAME
Ordinal #	3
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	62 (89.86%)
Unique	NO

Value	Length	Count
1900s	5	2
2000s	5	2
Australia	9	2
Biography	9	2
India	5	2
Latest	6	2
South	5	2
Action movies	13	1
Actors	6	1
Actresses	9	1

CATEGORY_NAME

Name	QUIZ_CATEGORY_DESCRIPTION
Ordinal #	4
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	62 (89.86%)
Unique	NO

Value	Length	Count
1900s	5	2
2000s	5	2
Australia	9	2
Biography	9	2
India	5	2
Latest	6	2
South	5	2
Action movies	13	1
Actors	6	1
Actresses	9	1

QUIZ_CATEGORY_DESCRIPTION

Name	CATEGORY_LEVEL
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	NO
Cardinality	5 (7.25%)
Unique	NO

Value	Length	Count
3		29
2		28
1		8
4		2
5		2

This is helper field that will indicate level of this category in a tree of categories. For example: top level will be "1", second level (child of level "1") will be "2" and so on.

Name	CREATE_USER_ID
Ordinal #	6
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
2		69

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	7
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	2 (2.90%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:50:50.0000		48
Sun Feb 23, 2014 09:50:51.0000		21

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	8
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
null		69

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	9
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
null		69

UPDATE DATETIME
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	20
Table Name	QUIZ_DEFINITION
Owner	YTM11
Type	TABLE
Row Count	4
Remarks	Quiz Definition Table. This is the blue print of the Quiz. Quiz definition can be: 1. Created Manually 2. Generated by Quiz Generator (in that case it has to have a parent record in table GENERATOR) QUIZ_DEFINITION nema vezu sa QUESTIONS nego samo UNIQUE_TESTS imaju vezu sa QUESTIONS. Svrha tabele UNIQUE_TEST je samo da bi sadrzala razlicita pitanja – sve ostalo je isto

Column

References

Sample Data

Comment

Name	QUIZ_DEFINITION_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
QUIZ_DEFINITION_POOL	QUIZ_DEFINITION_ID
UNIQUE_QUIZ	QUIZ_DEFINITION_ID
USER_QUIZ	QUIZ_DEFINITION_ID

Value	Length	Count
1000		1
1001		1
1002		1
1003		1

QUIZ_DEFINITION_ID

Name	GRADING_SYSTEM_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

References PK column

Table	Column
GRADING_SYSTEM	GRADING_SYSTEM_ID

Value	Length	Count
null		4

Primarry Key

Name	QUIZ_CATEGORY_ID
Ordinal #	3
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

References PK column

Table	Column
QUIZ_CATEGORY	QUIZ_CATEGORY_ID

Value	Length	Count
null		4

QUIZ_CATEGORY_ID

Name	QUIZ_TEMPLATE_ID
Ordinal #	4
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

References PK column

Table	Column
QUIZ_TEMPLATE	QUIZ_TEMPLATE_ID

Value	Length	Count
null		4

QUIZ_TEMPLATE_ID

Name	QUIZ_NAME
Ordinal #	5
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Value	Length	Count
History	7	1
North American Geogr...	23	1
Science	7	1
Sport	5	1

Name (Title) of this test.

Name	QUIZ_DESCRIPTION
Ordinal #	6
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

Quiz Long Decsription

Name	DEFAULT_DURATION
Ordinal #	7
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

Test duration in seconds. This is time available to complete the test once test instance started.

Name	USERS_COMMENT
Ordinal #	8
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

USERS COMMENT

Name	QUIZ_DEFINITION_STATUS
Ordinal #	9
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
A	1	4

Examples: - Active - Inactive - Under Construction

Name	NUM_OF_UNIQUE_TESTS
Ordinal #	10
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
1		4

Has to be minimum of 1.

Name	POINTS_EASY
Ordinal #	11
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
5		4

POINTS_EASY

Name	POINTS_MEDIUM
Ordinal #	12
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
10		4

POINTS_MEDIUM

Name	POINTS_HARD
Ordinal #	13
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
15		4

POINTS_HARD

Name	DURATION_EASY
Ordinal #	14
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

DURATION_EASY

Name	DURATION_MEDIUM
Ordinal #	15
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

DURATION_MEDIUM

Name	DURATION_HARD
Ordinal #	16
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

DURATION_HARD

Name	DURATION_FACTOR
Ordinal #	17
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

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

Name	DEFAULT_ENABLED_FROM
Ordinal #	18
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

DEFAULT ENABLED FROM

Name	DEFAULT_ENABLED_TO
Ordinal #	19
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

DEFAULT ENABLED TO

Name	DISPLAY_ANSWER_IND
Ordinal #	20
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

Determines if the correct answer is displayed after every question is answered.

Name	DISPLAY_CORRECT_IND
Ordinal #	21
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.

Name	CREATE_TYPE
Ordinal #	22
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

GEN (Generated), MAN (Manual)

Name	REPORT_TYPE
Ordinal #	23
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

OPA (On professor approval), IMM (Immediatly after finishing whole quiz) IQT (After every question - works only for wizard type of quiz)

Name	LOOK_TYPE
Ordinal #	24
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

AOP (All questions on page), OPP (One question per page)

Name	DURATION_TYPE
Ordinal #	25
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)

Name	RESOLVE_TYPE
Ordinal #	26
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

Shows if quiz contains questions that need to be resolved by professor himself. QRY - quiz can be resolved by system QRN- quiz cannot be resolved by system - must professor.

Name	RAND_QUESTION_ORDER
Ordinal #	27
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

Indicates whether the order of questions is randomized when instance of the quiz is created.

Name	RAND_ANSWER_ORDER
Ordinal #	28
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

Indicates whether the order of answers within the question is randomized when instance of the quiz is created.

Name	RESULTS_DISPLAY_CODE
Ordinal #	29
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
?	1	4

This code determines how the results are displayed: FUL (grade and preview), GRA (only grade)

Name	CREATE_USER_ID
Ordinal #	30
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
0		4

CREATE USER ID

Name	CREATE_DATETIME
Ordinal #	31
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Value	Length	Count
Sun Feb 23, 2014 09:51:06.0000		1
Sun Feb 23, 2014 09:51:08.0000		1
Sun Feb 23, 2014 09:51:09.0000		1
Sun Feb 23, 2014 09:51:10.0000		1

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	32
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

UPDATE USER ID

Name	UPDATE_DATETIME
Ordinal #	33
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

References PK column

Table	Column
POOL	POOL_ID

N/A

Pool of questions Primary Key

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

References PK column

Table	Column
QUIZ_DEFINITION	QUIZ_DEFINITION_ID

N/A

QUIZ_DEFINITION_ID

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

N/A

NUM_OF_HARD_QUESTIONS

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

N/A

NUM_OF_MEDIUM_QUESTIONS

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

N/A

NUM_OF_EASY_QUESTIONS

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

N/A

CUT_OFF_DATE

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

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
EMAIL_SENT	QUIZ_EMAIL_ACTION_ID

N/A

QUIZ_EMAIL ACTION_ID

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

References PK column

Table	Column
QUIZ_INSTANCE	QUIZ_INSTANCE_ID

N/A

QUIZ_INSTANCE_ID

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

References PK column

Table	Column
EMAIL_TEMPLATE	EMAIL_TEMPLATE_ID

N/A

Specifies the template to be used to contruct the e-mail.

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

References PK column

Table	Column
USERS	USER_ID

N/A

USER ID

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

N/A

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

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

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
QUIZ_EMAIL_ACTION	QUIZ_INSTANCE_ID
QUIZ_RESULT	QUIZ_INSTANCE_ID

N/A

QUIZ_INSTANCE_ID

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

References PK column

Table	Column
UNIQUE_QUIZ	UNIQUE_QUIZ_ID

N/A

UNIQUE_QUIZ_ID

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

References PK column

Table	Column
USERS	USER_ID

N/A

USER ID TESTED

Name	COURSE_ID
Ordinal #	4
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

References PK column

Table	Column
COURSE	COURSE_ID

N/A

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

Name	CLASS_ID
Ordinal #	5
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

References PK column

Table	Column
CLASS	CLASS_ID

N/A

User tested may belong to the class. THis class may be independent of course (may not belong to the course at all). This is done for maximum flexibility.

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

N/A

DURATION

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

N/A

ENABLED FROM

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

N/A

ENABLED TO

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

N/A

Date and time when user started the quiz (received first question). This data will be used to calculate quiz duration.

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

N/A

QUIZ FINISHED

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

N/A

Describes the status of the Quiz instance: - Not sent - Not attempted - Attempted No Report - Attempted With Report - Expired

Name	ACTIVATION_DATETIME
Ordinal #	12
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

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

Name	RESOLVE_TYPE
Ordinal #	13
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Shows if quiz contains questions that need to be resolved by professor himself. QRY - quiz can be resolved by system QRN- quiz cannot be resolved by system - must professor.

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

Name	UNIQUE_QUIZ_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	2
Nullable	NO
Cardinality	4 (3.31%)
Unique	NO

References PK column

Table	Column
UNIQUE_QUIZ	UNIQUE_QUIZ_ID

Value	Length	Count
1		31
2		30
3		30
4		30

UNIQUE_QUIZ_ID

Name	QUESTION_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	121 (100.00%)
Unique	YES

References PK column

Table	Column
QUESTION	QUESTION_ID

Value	Length	Count
5000		1
5001		1
5002		1
5003		1
5004		1
5005		1
5006		1
5007		1
5008		1
5009		1

QUESTION ID

Name	QUESTION_ORDINAL_NUMBER
Ordinal #	3
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	31 (25.62%)
Unique	NO

Value	Length	Count
1		4
2		4
3		4
4		4
5		4
6		4
7		4
8		4
9		4
10		4

This is the number that determines order of the question in test. Lower numbers are displayed first in the test.

Name	STATUS
Ordinal #	4
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
L	1	121

STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	FREQUENCY_FACTOR
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Spec. of question occurence for current quiz. Default values are in table QUESTION. Will be labeled in application and mapped to numbers after.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	DURATION
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Defualt duration is in table question, But if user wants to change it while making the quiz it will be inserted here.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	25
Table Name	QUIZ_RESULT
Owner	YTM11
Type	TABLE
Row Count	0
Remarks	Every record in this table represents the answer on particular question of the certain Quiz Occurence. In case that user has to key in the answer in free form text - column "ANSWER_TEXT" will have an text of the user's answer on particular question. In case of "Multiple Choices" Questions - options that are picked by the user being tested are store in table "QUIZ_RESULT_ANSWER". In that case value in column "ANSWER_TEXT" will be blank. Record in this table does not have to be associated with any record in table "Answer". The example is question that required free form text as an answer. WARNING: Table is empty.

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
QUIZ_RESULT_ANSWER	QUIZ_RESULT_ID

N/A

QUIZ RESULT ID

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

References PK column

Table	Column
QUIZ_INSTANCE	QUIZ_INSTANCE_ID

N/A

QUIZ_INSTANCE_ID

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

References PK column

Table	Column
QUESTION	QUESTION_ID

N/A

QUESTION ID

Name	ANSWER_TEXT
Ordinal #	4
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

This field is reserved for questions that require free form text answer. Answer entered by candidate taking test will be saved in this field.

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

N/A

This field provides capability to create textual answers of unlimited length.

Name	ANSWER_BLOB
Ordinal #	6
Data Type	BLOB[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

This field provides capability to create more "complex" answers that would invlove formuulas, specific tect formatting, diagrams, pictures, etc.

Name	ANSWER_FEEDBACK
Ordinal #	7
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

This is the feedback from the examiner on the given answer. examiner may not be able to change Answer text but he/she can write a feedback on the answer.

Name	NOT_SURE_FLAG
Ordinal #	8
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

NOT SURE FLAG

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

N/A

This is number of points assigned by examiner after evaluating the answer. It overrides default number of points in table Answers. Also it is used for free form text answers.

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

References PK column

Table	Column
ANSWER	ANSWER_ID

N/A

ANSWER ID

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

References PK column

Table	Column
QUIZ_RESULT	QUIZ_RESULT_ID

N/A

QUIZ RESULT ID

Name	TIME_TO_ANSWER
Ordinal #	3
Data Type	NUMBER[8]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

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

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

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
QUIZ_DEFINITION	QUIZ_TEMPLATE_ID
QUIZ_TEMPLATE_POOL	QUIZ_TEMPLATE_ID

N/A

QUIZ_TEMPLATE_ID

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

References PK column

Table	Column
QUIZ_CATEGORY	QUIZ_CATEGORY_ID

N/A

QUIZ_CATEGORY_ID

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

References PK column

Table	Column
GRADING_SYSTEM	GRADING_SYSTEM_ID

N/A

Primarry Key

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

N/A

Has to be minimum of 1.

Name	TEMPLATE_NAME
Ordinal #	5
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

Name (Title) of this template

Name	TEMPLATE_DESCRIPTION
Ordinal #	6
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Quiz Long Decsription

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

N/A

Examples: - Active - Inactive - Under Construction

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

N/A

POINTS_EASY

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

N/A

POINTS_MEDIUM

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

N/A

POINTS_HARD

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

N/A

DURATION_EASY

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

N/A

DURATION_MEDIUM

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

N/A

DURATION_HARD

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

N/A

Test duration in seconds. This is time available to complete the test once test instance started.

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

N/A

Determines if the correct answer is displayed after every question is answered.

Name	DISPLAY_CORRECT_IND
Ordinal #	16
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.

Name	REPORT_TYPE
Ordinal #	17
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

OPA (On professor approval), FUL (Immediatly after finishing user can see his report with preview), GRA (User can see only grade after finishing)

Name	LOOK_TYPE
Ordinal #	18
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

AOP (All questions on page), OPP (One question per page)

Name	DURATION_TYPE
Ordinal #	19
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)

Name	DURATION_FACTOR
Ordinal #	20
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Name	RAND_QUESTION_ORDER
Ordinal #	21
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Indicates whether the order of questions is randomized when instance of the quiz is created.

Name	RAND_ANSWER_ORDER
Ordinal #	22
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Indicates whether the order of answers within the question is randomized when instance of the quiz is created.

Name	RESULTS_DISPLAY_CODE
Ordinal #	23
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

This code determines when the results are displayed: - after svery question is answered - after entire quiz is finished - once it is reviewed and apprived by examiner

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

References PK column

Table	Column
POOL	POOL_ID

N/A

Pool of questions Primary Key

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

References PK column

Table	Column
QUIZ_TEMPLATE	QUIZ_TEMPLATE_ID

N/A

QUIZ_TEMPLATE_ID

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

N/A

NUM_OF_HARD_QUESTIONS

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

N/A

NUM_OF_MEDIUM_QUESTIONS

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

N/A

NUM_OF_EASY_QUESTIONS

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

N/A

CUT_OFF_DATE

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

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
REPORT_INSTANCE	REPORT_DEFINITION_ID

N/A

REPORT_DEFINITION_ID

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

N/A

REPORT_NAME

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

N/A

Report description with more details

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

N/A

This is title that will appear in the report.

Name	DEFAULT_LOCATION
Ordinal #	5
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

This is the default location where report will be created in the file system

Name	REPORT_FORMAT_CODE
Ordinal #	6
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

Identifis the format of the report, for example: - PDF - Excel - Rich Text Format (RTF) - HTML

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

N/A

REPORT_INSTANCE_ID

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

References PK column

Table	Column
REPORT_DEFINITION	REPORT_DEFINITION_ID

N/A

REPORT_DEFINITION_ID

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

N/A

Location of the report in the file system

Name	COMMENT
Ordinal #	4
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

This is the comment related to this particulear report instance. It is usually a text entered through Front End by person submitting report.

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

Name	REPORT_TITLE
Ordinal #	7
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

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

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

Column

References

Sample Data

Comment

Name	ROLE_CODE
Ordinal #	1
Data Type	VARCHAR2[3]
PK Seq. #	1
Nullable	NO
Cardinality	3 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
ROLE_FUNCTION	ROLE_CODE
USER_ROLE	ROLE_CODE

Value	Length	Count
ADM	3	1
PRF	3	1
STU	3	1

ROLE CODE

Name	ROLE_NAME
Ordinal #	2
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	3 (100.00%)
Unique	YES

Value	Length	Count
Administrator	13	1
Professor	9	1
Student	7	1

ROLE NAME

Name	ROLE_DESCRIPTION
Ordinal #	3
Data Type	VARCHAR2[400]
PK Seq. #
Nullable	YES
Cardinality	3 (100.00%)
Unique	YES

Value	Length	Count
Administartor of the...	23	1
Professor	9	1
Student	7	1

ROLE_DESCRIPTION

Name	GRANTABLE
Ordinal #	4
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	2 (66.67%)
Unique	NO

Value	Length	Count
N	1	2
Y	1	1

If 'Y' then this Role can grant Roles to other users.

Name	ENABLED
Ordinal #	5
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	1 (33.33%)
Unique	NO

Value	Length	Count
Y	1	3

ENABLED

#	32
Table Name	ROLE_FUNCTION
Owner	YTM11
Type	TABLE
Row Count	9
Remarks	Role can have multiple permissions and same permission can be granted to multiple roles.

Column

References

Sample Data

Comment

Name	ROLE_CODE
Ordinal #	1
Data Type	VARCHAR2[3]
PK Seq. #	1
Nullable	NO
Cardinality	3 (33.33%)
Unique	NO

References PK column

Table	Column
ROLE	ROLE_CODE

Value	Length	Count
ADM	3	3
PRF	3	3
STU	3	3

ROLE CODE

Name	FUNCTION_CODE
Ordinal #	2
Data Type	VARCHAR2[3]
PK Seq. #	2
Nullable	NO
Cardinality	3 (33.33%)
Unique	NO

References PK column

Table	Column
FUNCTION	FUNCTION_CODE

Value	Length	Count
CHP	3	3
LGN	3	3
TAQ	3	3

FUNCTION CODE

Name	ENABLED
Ordinal #	3
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	1 (11.11%)
Unique	NO

Value	Length	Count
Y	1	9

ENABLED
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	33
Table Name	ST_ANSWER
Owner	YTM11
Type	TABLE
Row Count	605
Remarks	Staging table for loading Answer data from Excel file.

Column

References

Sample Data

Comment

Name	ST_ANSWER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	605 (100.00%)
Unique	YES

Value	Length	Count
4		1
8		1
12		1
16		1
20		1
24		1
28		1
32		1
36		1
40		1

ST_ANSWER_ID

Name	ST_QUIZ_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	4 (0.66%)
Unique	NO

References PK column

Table	Column
ST_QUIZ	ST_QUIZ_ID

Value	Length	Count
1		155
2		150
3		150
4		150

ST_QUIZ_ID

Name	ARTIFICIAL_QUESTION_ID
Ordinal #	3
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	31 (5.12%)
Unique	NO

Value	Length	Count
1001		20
1002		20
1003		20
1004		20
1005		20
1006		20
1007		20
1008		20
1009		20
1010		20

This is number assigned by user in order to link questions with answers in excel.

Name	ANSWER_TEXT
Ordinal #	4
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

ANSWER_TEXT

Name	ORDINAL_NUMBER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	5 (0.83%)
Unique	NO

Value	Length	Count
2		123
1		121
4		121
5		121
3		119

This number determines the order of this answer as it appears on the test. Lower numbers are displayed first. If this number is not present then answers will be diplayed in default order.

Name	CORRECT_ANSWER_IND
Ordinal #	6
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	2 (0.33%)
Unique	NO

Value	Length	Count
null	0	485
Y	1	120

Indicates if this is the correct answer.

#	34
Table Name	ST_COURSE
Owner	YTM11
Type	TABLE
Row Count	0
Remarks	Staging table that facilitates load into table COURSE. Course category structure. For example: 1. Science 1.1. Astronomy 1.2. Physics 1.2.1. Nuclear Physics 1.2.2. Quantum Physics 1.3 Medicine 2. Sports 2.1. Olympics 2.2. Soccer 2.2.1. European Soccer 2.2.2. South American Soccer 2.2.3. North American Soccer 2.3 NBA 3. History WARNING: Table is empty. WARNING: Table is orphan.

Column

References

Sample Data

Comment

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

N/A

EXCEL_ROW_ID

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

N/A

COURSE_CODE

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

N/A

CATEGORY_NAME_1

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

N/A

CATEGORY_NAME_2

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

N/A

CATEGORY_NAME_3

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

N/A

CATEGORY_NAME_4

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

N/A

CATEGORY_NAME_5

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

N/A

CATEGORY_NAME_6

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

N/A

CATEGORY_NAME_7

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

N/A

CATEGORY_NAME_8

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

N/A

CATEGORY_NAME_9

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

N/A

CATEGORY_NAME_10

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

N/A

CREATE DATETIME

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

Column

References

Sample Data

Comment

Name	ST_QUESTION_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	121 (100.00%)
Unique	YES

Value	Length	Count
4		1
8		1
12		1
16		1
20		1
24		1
28		1
32		1
36		1
40		1

ST_QUESTION_ID

Name	ARTIFICIAL_QUESTION_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	31 (25.62%)
Unique	NO

Value	Length	Count
1001		4
1002		4
1003		4
1004		4
1005		4
1006		4
1007		4
1008		4
1009		4
1010		4

This is number assigned by user in order to link questions with answers in excel.

Name	ST_QUIZ_ID
Ordinal #	3
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	4 (3.31%)
Unique	NO

References PK column

Table	Column
ST_QUIZ	ST_QUIZ_ID

Value	Length	Count
1		31
2		30
3		30
4		30

ST_QUIZ_ID

Name	QUESTION_TEXT
Ordinal #	4
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

QUESTION TEXT

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

N/A

This is picture that is displayed with question.

Name	DURATION
Ordinal #	6
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Name	DIFFICULTY
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

This is degree of difficulty. Higher number represents higher difficulty of question.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	POINTS
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.83%)
Unique	NO

Value	Length	Count
null		121

Name	ORDINAL_NUMBER
Ordinal #	9
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	31 (25.62%)
Unique	NO

Value	Length	Count
1		4
2		4
3		4
4		4
5		4
6		4
7		4
8		4
9		4
10		4

This number determines the order of this questionas it appears on the test. Lower numbers are displayed first. If this number is not present then questions will be diplayed in default order.

#	36
Table Name	ST_QUIZ
Owner	YTM11
Type	TABLE
Row Count	4
Remarks	Staging table for loading Quiz data from Excel file.

Column

References

Sample Data

Comment

Name	ST_QUIZ_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
ST_ANSWER	ST_QUIZ_ID
ST_QUESTION	ST_QUIZ_ID

Value	Length	Count
1		1
2		1
3		1
4		1

ST_QUIZ_ID

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
zkukoljac	9	4

Username has to be unique across the system. Use of email adress is encouraged however it cannot be enforced because many user will not have e-mail addresses or they will not provide it for various reasons.

Name	PASSWORD
Ordinal #	3
Data Type	CHAR[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
zkukoljac2	10	4

PASSWORD

Name	USER_ID
Ordinal #	4
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

USER ID

Name	QUIZ_NAME
Ordinal #	5
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Value	Length	Count
History	7	1
North American Geogr...	23	1
Science	7	1
Sport	5	1

Name (Title) of this test.

Name	DEFAULT_DURATION
Ordinal #	6
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

Test duration in seconds. This is time available to complete the test once test instance started.

Name	USERS_COMMENT
Ordinal #	7
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

USERS COMMENT

Name	DEFAULT_ENABLED_FROM
Ordinal #	8
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

DEFAULT ENABLED FROM

Name	DEFAULT_ENABLED_TO
Ordinal #	9
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

DEFAULT ENABLED TO

Name	RESULT_TRANSPARENCY
Ordinal #	10
Data Type	VARCHAR2[20]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null	0	4

RESULT TRANSPARENCY

Name	DURATION_FACTOR
Ordinal #	11
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

Name	STATUS
Ordinal #	12
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
L	1	4

"S" - Loaded only in staging tables "L" - Loaded into permanent tables, data from stagin tables can be deleted

Name	CREATE_USER_ID
Ordinal #	13
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
0		4

CREATE USER ID

Name	CREATE_DATETIME
Ordinal #	14
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Value	Length	Count
Sun Feb 23, 2014 09:50:51.0000		1
Sun Feb 23, 2014 09:50:54.0000		1
Sun Feb 23, 2014 09:50:57.0000		1
Sun Feb 23, 2014 09:51:00.0000		1

CREATE DATETIME

#	37
Table Name	ST_QUIZ_CATEGORY
Owner	YTM11
Type	TABLE
Row Count	69
Remarks	Staging table that facilitates load into table QUIZ_CATEGORY. Quiz category structure. For example: 1. Science 1.1. Astronomy 1.2. Physics 1.2.1. Nuclear Physics 1.2.2. Quantum Physics 1.3 Medicine 2. Sports 2.1. Olympics 2.2. Soccer 2.2.1. European Soccer 2.2.2. South American Soccer 2.2.3. North American Soccer 2.3 NBA 3. History WARNING: Table is orphan.

Column

References

Sample Data

Comment

Name	EXCEL_ROW_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	69 (100.00%)
Unique	YES

Value	Length	Count
10		1
20		1
30		1
40		1
50		1
60		1
70		1
80		1
90		1
100		1

EXCEL_ROW_ID

Name	CATEGORY_NAME_1
Ordinal #	2
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	8 (11.59%)
Unique	NO

Value	Length	Count
Sports	6	14
Hollywood	10	13
Science	7	11
History	7	9
Geography	9	7
Technology	10	7
Philosophy	10	4
Religion	8	4

CATEGORY_NAME_1

Name	CATEGORY_NAME_2
Ordinal #	3
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	29 (42.03%)
Unique	NO

Value	Length	Count
Action movies	13	8
null	0	8
Cricket	7	7
Biology	7	4
Horror movies	13	4
Physics	7	4
Soccer	6	4
Canada	6	3
India	5	3
Regions	7	3

CATEGORY_NAME_2

Name	CATEGORY_NAME_3
Ordinal #	4
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	26 (37.68%)
Unique	NO

Value	Length	Count
null	0	36
Latest	6	6
1900s	5	2
2000s	5	2
South	5	2
Australia	9	1
Botany	6	1
European	8	1
Human	5	1
India	5	1

CATEGORY_NAME_3

Name	CATEGORY_NAME_4
Ordinal #	5
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	3 (4.35%)
Unique	NO

Value	Length	Count
null	0	65
Actors	6	2
Actresses	9	2

CATEGORY_NAME_4

Name	CATEGORY_NAME_5
Ordinal #	6
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	2 (2.90%)
Unique	NO

Value	Length	Count
null	0	67
Biography	9	2

CATEGORY_NAME_5

Name	CATEGORY_NAME_6
Ordinal #	7
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
null	0	69

CATEGORY_NAME_6
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CATEGORY_NAME_7
Ordinal #	8
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
null	0	69

CATEGORY_NAME_7
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CATEGORY_NAME_8
Ordinal #	9
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
null	0	69

CATEGORY_NAME_8
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CATEGORY_NAME_9
Ordinal #	10
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
null	0	69

CATEGORY_NAME_9
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CATEGORY_NAME_10
Ordinal #	11
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (1.45%)
Unique	NO

Value	Length	Count
null	0	69

CATEGORY_NAME_10
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	12
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	4 (5.80%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:50:52.0000		27
Sun Feb 23, 2014 09:50:51.0000		17
Sun Feb 23, 2014 09:50:50.0000		14
Sun Feb 23, 2014 09:50:49.0000		11

CREATE DATETIME

#	38
Table Name	SURVEY_DEFINITION
Owner	YTM11
Type	TABLE
Row Count	0
Remarks	Quiz Survey Table. This is the blue print of the Survey. WARNING: Table is empty.

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
SURVEY_INSTANCE	SURVEY_DEFINITION_ID

N/A

SURVEY_DEFINITION_ID

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

N/A

Primarry Key

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

N/A

SURVEY_CATEGORY_ID

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

N/A

Name (Title) of this test.

Name	SURVEY_DESCRIPTION
Ordinal #	5
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Quiz Long Decsription

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

N/A

Test duration in seconds. This is time available to complete the test once test instance started.

Name	USERS_COMMENT
Ordinal #	7
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

USERS COMMENT

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

N/A

Examples: - Active - Inactive - Under Construction

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

N/A

POINTS_EASY

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

N/A

POINTS_MEDIUM

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

N/A

POINTS_HARD

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

N/A

DURATION_EASY

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

N/A

DURATION_MEDIUM

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

N/A

DURATION_HARD

Name	DURATION_FACTOR
Ordinal #	15
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

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

N/A

DEFAULT ENABLED FROM

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

N/A

DEFAULT ENABLED TO

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

N/A

Determines if the correct answer is displayed after every question is answered.

Name	DISPLAY_CORRECT_IND
Ordinal #	19
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Wnidicates whether the message "Correct/Incorrect" will pop-up after every question is answered.

Name	CREATE_TYPE
Ordinal #	20
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

GEN (Generated), MAN (Manual)

Name	REPORT_TYPE
Ordinal #	21
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

OPA (On professor approval), IMM (Immediatly after finishing whole quiz) IQT (After every question - works only for wizard type of quiz)

Name	LOOK_TYPE
Ordinal #	22
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

AOP (All questions on page), OPP (One question per page)

Name	DURATION_TYPE
Ordinal #	23
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

UNL (Unlimited), DQS (Duration per question), DQZ (Duration per quiz)

Name	RESOLVE_TYPE
Ordinal #	24
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Shows if quiz contains questions that need to be resolved by professor himself. QRY - quiz can be resolved by system QRN- quiz cannot be resolved by system - must professor.

Name	RAND_QUESTION_ORDER
Ordinal #	25
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Indicates whether the order of questions is randomized when instance of the quiz is created.

Name	RAND_ANSWER_ORDER
Ordinal #	26
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Indicates whether the order of answers within the question is randomized when instance of the quiz is created.

Name	RESULTS_DISPLAY_CODE
Ordinal #	27
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

This code determines how the results are displayed: FUL (grade and preview), GRA (only grade)

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

Referenced by FK columns

Table	Column
SURVEY_QUESTION	SURVEY_INSTANCE_ID

N/A

SURVEY_INSTANCE_ID

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

References PK column

Table	Column
SURVEY_DEFINITION	SURVEY_DEFINITION_ID

N/A

SURVEY_DEFINITION_ID

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

N/A

USER ID TESTED

Name	COURSE_ID
Ordinal #	4
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Name	CLASS_ID
Ordinal #	5
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

User tested may belong to the class. THis class may be independent of course (may not belong to the course at all). This is done for maximum flexibility.

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

N/A

DURATION

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

N/A

ENABLED FROM

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

N/A

ENABLED TO

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

N/A

Date and time when user started the quiz (received first question). This data will be used to calculate quiz duration.

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

N/A

QUIZ FINISHED

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

N/A

Describes the status of the Quiz instance: - Not sent - Not attempted - Attempted No Report - Attempted With Report - Expired

Name	ACTIVATION_DATETIME
Ordinal #	12
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

Name	RESOLVE_TYPE
Ordinal #	13
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

Shows if quiz contains questions that need to be resolved by professor himself. QRY - quiz can be resolved by system QRN- quiz cannot be resolved by system - must professor.

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

N/A

CREATE USER ID

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

N/A

CREATE DATETIME

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

N/A

UPDATE USER ID

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

N/A

UPDATE DATETIME

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

Column

References

Sample Data

Comment

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

References PK column

Table	Column
QUESTION	QUESTION_ID

N/A

QUESTION ID

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

References PK column

Table	Column
SURVEY_INSTANCE	SURVEY_INSTANCE_ID

N/A

SURVEY_INSTANCE_ID

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

Column

References

Sample Data

Comment

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

N/A

TIME_ZONE_ID

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

N/A

This is actualy difference from ZULU time (GMT).

Name	TIME_ZONE_CODE
Ordinal #	3
Data Type	VARCHAR2[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

For Example: "EST" "PST" etc.

Name	TIME_ZONE_NAME
Ordinal #	4
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

For example: "Eastern Standard Time"

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

Column

References

Sample Data

Comment

Name	UNIQUE_QUIZ_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Referenced by FK columns

Table	Column
QUIZ_INSTANCE	UNIQUE_QUIZ_ID
QUIZ_QUESTION	UNIQUE_QUIZ_ID

Value	Length	Count
1		1
2		1
3		1
4		1

UNIQUE_QUIZ_ID

Name	QUIZ_DEFINITION_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

References PK column

Table	Column
QUIZ_DEFINITION	QUIZ_DEFINITION_ID

Value	Length	Count
1000		1
1001		1
1002		1
1003		1

QUIZ_DEFINITION_ID

Name	UNIQUE_QUIZ_NAME
Ordinal #	3
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Value	Length	Count
UNIQUE QUIZ NAME 1	18	1
UNIQUE QUIZ NAME 2	18	1
UNIQUE QUIZ NAME 3	18	1
UNIQUE QUIZ NAME 4	18	1

Name (Title) of this test.

Name	CREATE_USER_ID
Ordinal #	4
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
0		4

CREATE USER ID

Name	CREATE_DATETIME
Ordinal #	5
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	4 (100.00%)
Unique	YES

Value	Length	Count
Sun Feb 23, 2014 09:51:07.0000		1
Sun Feb 23, 2014 09:51:08.0000		1
Sun Feb 23, 2014 09:51:09.0000		1
Sun Feb 23, 2014 09:51:10.0000		1

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	6
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

UPDATE USER ID

Name	UPDATE_DATETIME
Ordinal #	7
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (25.00%)
Unique	NO

Value	Length	Count
null		4

UPDATE DATETIME

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	236 (100.00%)
Unique	YES

Referenced by FK columns

Value	Length	Count
1		1
2		1
3		1
4		1
5		1
6		1
7		1
8		1
9		1
10		1

USER ID

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	236 (100.00%)
Unique	YES

Value	Length	Count
abono	5	1
agibbs	6	1
ahall	5	1
akelly	6	1
aliu	4	1
aperry	6	1
aroberts	8	1
asmith	6	1
cbagley	7	1
cbagwell	8	1

Name	LANGUAGE_ID
Ordinal #	3
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	2 (0.85%)
Unique	NO

References PK column

Table	Column
LANGUAGE	LANGUAGE_ID

Value	Length	Count
15		230
19		6

User can have a language other than English. If this field is empty then default language is english.

Name	ORGANIZATION_ID
Ordinal #	4
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

References PK column

Table	Column
ORGANIZATION	ORGANIZATION_ID

Value	Length	Count
null		236

ORGANIZATION ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	PASSWORD
Ordinal #	5
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	236 (100.00%)
Unique	YES

Value	Length	Count
+hS11lHmJuKiAAVpuZOk...	23	1
+pgGqnk5MOzclD96B/Kd...	23	1
+sGK9U2zUGLDZRi5Kzb5...	23	1
+ueT03F8OaE9Pl15wGVQ...	23	1
/4LbZNB1Z9DNIzpJwphr...	23	1
/Xt7PL2WOTeEcoVKQddQ...	23	1
/afLICJw9uMIeP0tuFER...	23	1
02rks2l+D/0DF52eoZP8...	23	1
05u/buw21oweiNucGspl...	23	1
09kRdhtH07ZUbSAX9LSr...	23	1

PASSWORD

Name	MUST_CHANGE_PW_ON_NEXT_LOGIN
Ordinal #	6
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null	0	236

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.

Name	PW_EXPIRY_DATETIME
Ordinal #	7
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

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.

Name	FIRST_NAME
Ordinal #	8
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	149 (63.14%)
Unique	NO

Value	Length	Count
Perry	5	6
Pat	3	4
Peggy	5	3
Pete	4	3
Alec	4	2
Alexa	5	2
Clark	5	2
Claude	6	2
Cliff	5	2
Clint	5	2

FIRST NAME

Name	LAST_NAME
Ordinal #	9
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	154 (65.25%)
Unique	NO

Value	Length	Count
Baldwin	7	3
Barber	6	3
Benson	6	3
Bowen	5	3
Cummings	8	3
Daniel	6	3
Griffith	8	3
Hines	5	3
Hubbard	7	3
Lyons	5	3

LAST NAME

Name	GENDER_CODE
Ordinal #	10
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null	0	236

GENDER_CODE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	DATE_OF_BIRTH
Ordinal #	11
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	4 (1.69%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:50:37.0000		96
Sun Feb 23, 2014 09:50:36.0000		67
Sun Feb 23, 2014 09:50:38.0000		59
Sun Feb 23, 2014 09:50:39.0000		14

DATE_OF_BIRTH

Name	SEMESTER
Ordinal #	12
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

Current semester the Student is inroleed into.
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	YEAR_OF_STUDY
Ordinal #	13
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

Current Year of study
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	LAST_LOGON
Ordinal #	14
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

LAST LOGON
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	FAILED_LOGINS
Ordinal #	15
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

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.

Name	TOTAL_LOGONS
Ordinal #	16
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

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.

Name	EMAIL
Ordinal #	17
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	234 (99.15%)
Unique	NO

Value	Length	Count
zoran@mallocinc.com	19	3
Nancy4927@hotmail.co...	23	1
aurie@yahoo.ca	14	1
avel@yahoo.ca	13	1
baker4809@hotmail.ca	20	1
clinthill4722@yahoo....	23	1
cmdron2794@hotmail.c...	23	1
colin6913@yahoo.ca	18	1
corybain@yahoo.com	18	1
craig4791@hotmail.co...	23	1

Name	EMAIL2
Ordinal #	18
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	234 (99.15%)
Unique	NO

Value	Length	Count
zoran@rogers.com	16	3
bandere09@hotmail.ca	20	1
barkingme8461@hotmai...	23	1
clinno232@yahoo.ca	18	1
coldhot13@yahoo.ca	18	1
coldtrain482@yahoo.c...	23	1
coolpret4783@yahoo.c...	23	1
cotyain@yahoo.com	17	1
craihe791@hotmail.co...	23	1
cravingpie492@hotmai...	23	1

EMAIL2

Name	DAYTIME_PHONE
Ordinal #	19
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null	0	236

DAYTIME PHONE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	EVENING_PHONE
Ordinal #	20
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null	0	236

EVENING PHONE
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	USER_TYPE
Ordinal #	21
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	3 (1.27%)
Unique	NO

Value	Length	Count
STU	3	181
ADS	3	29
PRO	3	26

This field is currently not used.

Name	USER_STATUS
Ordinal #	22
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
ACT	3	236

USER_STATUS
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	TIME_ZONE
Ordinal #	23
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	17 (7.20%)
Unique	NO

Value	Length	Count
-3		46
2		25
4		23
6		23
-4		20
9		15
-7		12
-5		12
-2		12
8		11

TIME ZONE

Name	COMMENTS
Ordinal #	24
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Comments associated to this user

Name	CREATE_USER_ID
Ordinal #	25
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
1		236

CREATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	CREATE_DATETIME
Ordinal #	26
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	4 (1.69%)
Unique	NO

Value	Length	Count
Sun Feb 23, 2014 09:50:34.0000		94
Sun Feb 23, 2014 09:50:33.0000		65
Sun Feb 23, 2014 09:50:35.0000		62
Sun Feb 23, 2014 09:50:36.0000		15

CREATE DATETIME

Name	UPDATE_USER_ID
Ordinal #	27
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

UPDATE USER ID
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

Name	UPDATE_DATETIME
Ordinal #	28
Data Type	DATE[7]
PK Seq. #
Nullable	YES
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
null		236

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

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	236 (4.00%)
Unique	NO

References PK column

Table	Column
USERS	USER_ID

Value	Length	Count
1		25
2		25
3		25
4		25
5		25
6		25
7		25
8		25
9		25
10		25

USER ID

Name	CLASS_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #	2
Nullable	NO
Cardinality	25 (0.42%)
Unique	NO

References PK column

Table	Column
CLASS	CLASS_ID

Value	Length	Count
1		236
2		236
3		236
4		236
5		236
6		236
7		236
8		236
9		236
10		236

CLASS_ID

Name	USER_CLASS_ROLE
Ordinal #	3
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (0.02%)
Unique	NO

Value	Length	Count
ADM	3	5,900

Defines the primary role of the user associated with the class. Defined in code type "USER CLASS ROLE" For example: 'ADM' - Administrator - it can administrer class (add or remove users form the class) null - simple member of the class
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

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

Column

References

Sample Data

Comment

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

References PK column

Table	Column
POOL	POOL_ID

N/A

Pool of questions Primary Key

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

References PK column

Table	Column
USERS	USER_ID

N/A

USER ID

Name	USERS_POOL_ROLE
Ordinal #	3
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	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

References

Sample Data

Comment

Name	USER_ACTION_LOG_ID
Ordinal #	1
Data Type	NUMBER[0]
PK Seq. #	1
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

USER ACTION LOG ID

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

References PK column

Table	Column
USERS	USER_ID

N/A

USER ID

Name	ACTION_CODE
Ordinal #	3
Data Type	VARCHAR2[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	N/A

N/A

ACTION CODE

Name	COMMENTS
Ordinal #	4
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

COMMENTS

Name	CREATE_DATETIME
Ordinal #	5
Data Type	TIMESTAMP(6)[11,6]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	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

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	1
Nullable	NO
Cardinality	236 (1.69%)
Unique	NO

References PK column

Table	Column
USERS	USER_ID

Value	Length	Count
1		59
2		59
3		59
4		59
5		59
6		59
7		59
8		59
9		59
10		59

USER ID

Name	COURSE_ID
Ordinal #	2
Data Type	NUMBER[10]
PK Seq. #	2
Nullable	NO
Cardinality	59 (0.42%)
Unique	NO

References PK column

Table	Column
COURSE	COURSE_ID

Value	Length	Count
2		236
3		236
4		236
5		236
6		236
7		236
8		236
9		236
11		236
12		236

COURSE_ID

Name	USER_COURSE_ROLE
Ordinal #	3
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	1 (0.01%)
Unique	NO

Value	Length	Count
AAA	3	13,924

Primary Role of the user for that course USER_ROLE_CODE is populated with codes where CODE_TYPE_NAME = 'USER_COURSE_ROLE'
SUGGESTION: All rows have the same data value in this column. Consider normalizing.

#	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

References

Sample Data

Comment

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

N/A

USER PREFERENCES ID

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

References PK column

Table	Column
USERS	USER_ID

N/A

USER ID

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

N/A

USER_PREFERENCES_NAME

Name	MAX_RECORDS_RETURNED
Ordinal #	4
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

MAX RECORDS RETURNED

Name	ANSWER_TABLE_WIDTH
Ordinal #	5
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

ANSWER TABLE WIDTH

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

N/A

TABLE CHECK BOX COLUMN WIDTH

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

N/A

TABLE BG ALT COLOR1

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

N/A

TABLE BG ALT COLOR2

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

N/A

TABLE BODY FONT SIZE

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

N/A

TABLE BODY FONT FACE

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

N/A

TABLE HEADER BG COLOR

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

N/A

TABLE HEADER FONT SIZE

Name	TABLE_HEADER_FONT_FACE
Ordinal #	13
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

TABLE HEADER FONT FACE

Name	USER_LOGO
Ordinal #	14
Data Type	BLOB[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	N/A

N/A

User's logo that may appear on his pages and Quizzes

Name	USER_PREFERENCES_STATUS
Ordinal #	15
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	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

References

Sample Data

Comment

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

References PK column

Table	Column
USERS	USER_ID

N/A

USER ID

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

References PK column

Table	Column
QUIZ_DEFINITION	QUIZ_DEFINITION_ID

N/A

QUIZ_DEFINITION_ID

Name	USER_QUIZ_ROLE
Ordinal #	3
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	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

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #	2
Nullable	NO
Cardinality	236 (100.00%)
Unique	YES

References PK column

Table	Column
USERS	USER_ID

Value	Length	Count
1		1
2		1
3		1
4		1
5		1
6		1
7		1
8		1
9		1
10		1

USER ID

Name	ROLE_CODE
Ordinal #	2
Data Type	VARCHAR2[3]
PK Seq. #	1
Nullable	NO
Cardinality	3 (1.27%)
Unique	NO

References PK column

Table	Column
ROLE	ROLE_CODE

Value	Length	Count
STU	3	136
PRF	3	90
ADM	3	10

ROLE CODE

Name	ENABLED
Ordinal #	3
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	1 (0.42%)
Unique	NO

Value	Length	Count
Y	1	236

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

References

Sample Data

Comment

Name	CLASS_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_NAME
Ordinal #	2
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_CODE
Ordinal #	3
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	CLASS_STATUS
Ordinal #	6
Data Type	CHAR[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

N/A

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

N/A

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

N/A

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

N/A

Name	COURSE_NAME
Ordinal #	13
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CODE
Ordinal #	14
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_STATUS
Ordinal #	15
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CATEGORY_LEVEL
Ordinal #	16
Data Type	NUMBER[0]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DESCRIPTION
Ordinal #	17
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CREDITS
Ordinal #	18
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DURATION_IN_HRS
Ordinal #	19
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DEPARTMENT_ID
Ordinal #	20
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_SEMESTER
Ordinal #	21
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_YEAR_OF_STUDY
Ordinal #	22
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CREATE_USER_ID
Ordinal #	23
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CREATE_DATETIME
Ordinal #	24
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_UPDATE_USER_ID
Ordinal #	25
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	CLASS_COURSE_CREATE_USER_ID
Ordinal #	27
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_COURSE_CREATE_DATETIME
Ordinal #	28
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_COURSE_UPDATE_USER_ID
Ordinal #	29
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	CODE_TYPE_ID
Ordinal #	1
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	CODE_TYPE_DESCRIPTION
Ordinal #	3
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	CODE_ID
Ordinal #	4
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	CODE_DESCRIPTION
Ordinal #	6
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	COURSE_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	CATEGORY
Ordinal #	3
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	TOP_COURSE
Ordinal #	4
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_PATH
Ordinal #	5
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TABLE_LEVEL
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	IS_LEAF
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DESCRIPTION
Ordinal #	9
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	COURSE_STATUS
Ordinal #	11
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	DEPARTMENT_ID
Ordinal #	14
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SEMESTER
Ordinal #	15
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	YEAR_OF_STUDY
Ordinal #	16
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	COURSE_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	COURSE_NAME
Ordinal #	3
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_STATUS
Ordinal #	4
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TOP_COURSE
Ordinal #	5
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_TREE
Ordinal #	6
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_PATH
Ordinal #	7
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TABLE_LEVEL
Ordinal #	9
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	IS_LEAF
Ordinal #	10
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DESCRIPTION
Ordinal #	11
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

N/A

Name	DEPARTMENT_ID
Ordinal #	15
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SEMESTER
Ordinal #	16
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	YEAR_OF_STUDY
Ordinal #	17
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_COUNT
Ordinal #	18
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	DOCUMENT_ID
Ordinal #	1
Data Type	NUMBER[0]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	DOCUMENT_BINARY_CONTENT_SIZE
Ordinal #	4
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	DOCUMENT_CHAR_CONTENT_SIZE
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

N/A

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

N/A

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

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	POOL_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_NAME
Ordinal #	2
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TOP_POOL
Ordinal #	3
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_TREE
Ordinal #	4
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_PATH
Ordinal #	5
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	IS_LEAF
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_DESCRIPTION
Ordinal #	8
Data Type	VARCHAR2[500]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	POOL_COUNT
Ordinal #	10
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	POOL_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	POOL_NAME
Ordinal #	2
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	NUMBER_OF_QUESTIONS
Ordinal #	3
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	POOL_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	POOL_NAME
Ordinal #	2
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	NUMBER_OF_QUESTIONS
Ordinal #	3
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	POOL_NAME
Ordinal #	4
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	QUESTION_TEXT
Ordinal #	6
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	DIFFICULTY
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POINTS
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

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

N/A

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

N/A

Name	QUIZ_NAME
Ordinal #	3
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	USERS_COMMENT
Ordinal #	5
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

N/A

Name	DISPLAY_CORRECT_IND
Ordinal #	9
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	QUIZ_DEF_CREATE_DATETIME
Ordinal #	12
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	QUIZ_DEF_UPDATE_USER_ID
Ordinal #	13
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	QUESTION_ID
Ordinal #	15
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	QUESTION_TEXT
Ordinal #	16
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	DURATION
Ordinal #	17
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	DIFFICULTY
Ordinal #	18
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POINTS
Ordinal #	19
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	EXCEL_QUESTION_ID
Ordinal #	20
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	QUESTION_CREATE_DATETIME
Ordinal #	22
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	QUESTION_UPDATE_USER_ID
Ordinal #	23
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	QUESTION_MUL_CHOICE_IND
Ordinal #	25
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	READ_ONLY_IND
Ordinal #	26
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	QUESTION_ORDINAL_NUMBER
Ordinal #	27
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	STATUS
Ordinal #	28
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_ID
Ordinal #	29
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_TEXT
Ordinal #	30
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_ORDINAL_NUMBER
Ordinal #	31
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CORRECT_ANSWER_IND
Ordinal #	32
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_CREATE_USER_ID
Ordinal #	33
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	ANSWER_UPDATE_USER_ID
Ordinal #	35
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	QUIZ_CATEGORY_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	CATEGORY_PATH
Ordinal #	4
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	IS_LEAF
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	QUIZ_CATEGORY_DESCRIPTION
Ordinal #	8
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	QUIZ_CATEGORY_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	CATEGORY_PATH
Ordinal #	4
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CATEGORY_TREE
Ordinal #	5
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TABLE_LEVEL
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	IS_LEAF
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	QUIZ_CATEGORY_DESCRIPTION
Ordinal #	9
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	QUIZ_CATEGORY_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	CATEGORY_PATH
Ordinal #	4
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CATEGORY_TREE
Ordinal #	5
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TABLE_LEVEL
Ordinal #	7
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	IS_LEAF
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	QUIZ_CATEGORY_DESCRIPTION
Ordinal #	9
Data Type	VARCHAR2[1000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	QUIZ_INSTANCE_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

N/A

Name	ANSWER_TEXT
Ordinal #	5
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	NOT_SURE_FLAG
Ordinal #	6
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POINTS_ASSIGNED
Ordinal #	7
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	Q_RESULT_CREATE_USER_ID
Ordinal #	8
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

N/A

Name	QUESTION_TEXT
Ordinal #	12
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	QUESTION_DIFFICULTY
Ordinal #	15
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	QUESTION_POINTS
Ordinal #	16
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	EXCEL_QUESTION_ID
Ordinal #	17
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	QUESTION_MULTI_CHOICE_IND
Ordinal #	18
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	QUESTION_CREATE_USER_ID
Ordinal #	19
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	QUESTION_CREATE_DATETIME
Ordinal #	20
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	ANSWER_ID
Ordinal #	23
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_ANSWERED_TEXT
Ordinal #	24
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_ORDINAL_NUMBER
Ordinal #	25
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CORRECT_ANSWER_IND
Ordinal #	26
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_CREATE_USER_ID
Ordinal #	27
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_CREATE_DATETIME
Ordinal #	28
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	ANSWER_UPDATE_USER_ID
Ordinal #	29
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	USER_USERNAME
Ordinal #	31
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USER_FIRST_NAME
Ordinal #	32
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USER_LAST_NAME
Ordinal #	33
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USER_SEMESTER
Ordinal #	34
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_YEAR_OF_STUDY
Ordinal #	35
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_USER_TYPE
Ordinal #	36
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	37
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	QUIZ_INSTANCE_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	MAX_POINTS
Ordinal #	3
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POINTS_ASSIGNED
Ordinal #	4
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	PERCENT_SCORED
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	ROLE_CODE
Ordinal #	1
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	ROLE_DESCRIPTION
Ordinal #	3
Data Type	VARCHAR2[400]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	GRANTABLE
Ordinal #	4
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ROLE_ENABLED
Ordinal #	5
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	FUNCTION_CODE
Ordinal #	6
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	FUNCTION_DESCRIPTION
Ordinal #	8
Data Type	VARCHAR2[400]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	FUNCTION_ENABLED
Ordinal #	9
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	ROLE_FUNCTION_ENABLED
Ordinal #	10
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	ST_QUIZ_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Primary key

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

N/A

Primary key of table table ST_QUESTION_ID

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

N/A

Primary key of table table ST_ANSWER

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

N/A

Name	PASSWORD
Ordinal #	5
Data Type	CHAR[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

PASSWORD

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

N/A

USER ID

Name	QUIZ_NAME
Ordinal #	7
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name (Title) of this test.

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

N/A

Test duration in seconds. This is time available to complete the test once test instance started.

Name	USERS_COMMENT
Ordinal #	9
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

USERS COMMENT

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

N/A

DEFAULT ENABLED FROM

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

N/A

DEFAULT ENABLED TO

Name	RESULT_TRANSPARENCY
Ordinal #	12
Data Type	VARCHAR2[20]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

RESULT TRANSPARENCY

Name	DURATION_FACTOR
Ordinal #	13
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Factor (in percents, for example: -40%, +120%, +300%) - how much the available time for answering the questions should be shortened or prolonged. Apply duration factor to the length of every question. On this way duration of the questions can be parametrized.

Name	STATUS
Ordinal #	14
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

"S" - Loaded only in staging tables "L" - Loaded into permanent tables, data from staging tables can be deleted

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

N/A

CREATE USER ID

Name	CREATE_DATETIME
Ordinal #	16
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

CREATE DATETIME

Name	QST_ARTIFICIAL_QUESTION_ID
Ordinal #	17
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

This is number assigned by user in order to link questions with answers in excel.

Name	QUESTION_TEXT
Ordinal #	18
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

QUESTION TEXT

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

N/A

This is picture that is displayed with question.

Name	DURATION
Ordinal #	20
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Duration of the question in seconds. This is optional value and it is intended to be used to limit time available to answer this question.

Name	DIFFICULTY
Ordinal #	21
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

This is degree of difficulty. Higher number represents higher difficulty of question.

Name	POINTS
Ordinal #	22
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Number of points that person gets by answering this question correctly. For example difficult questions can score more points than the others. This is the "weight" of the question.

Name	QUESTION_ORDINAL_NUMBER
Ordinal #	23
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

This number determines the order of this question as it appears on the test. Lower numbers are displayed first. If this number is not present then questions will be displayed in default order.

Name	ANS_ARTIFICIAL_QUESTION_ID
Ordinal #	24
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

This is number assigned by user in order to link questions with answers in excel.

Name	ANSWER_TEXT
Ordinal #	25
Data Type	NVARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

ANSWER_TEXT

Name	ANSWER_ORDINAL_NUMBER
Ordinal #	26
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

This number determines the order of this answer as it appears on the test. Lower numbers are displayed first. If this number is not present then answers will be displayed in default order.

Name	CORRECT_ANSWER_IND
Ordinal #	27
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Indicates if this is the correct answer.

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

Column

References

Sample Data

Comment

Name	QUIZ_COUNT
Ordinal #	1
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	USERNAME
Ordinal #	1
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	ACTION_CODE
Ordinal #	3
Data Type	VARCHAR2[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	CREATE_DATETIME
Ordinal #	4
Data Type	TIMESTAMP(6)[11,6]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	USER_SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	CLASS_NAME
Ordinal #	10
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_CODE
Ordinal #	11
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	CLASS_STATUS
Ordinal #	14
Data Type	CHAR[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_CLASS_ROLE
Ordinal #	15
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	CLASS_UPDATE_USER_ID
Ordinal #	18
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	USER_SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_ID
Ordinal #	9
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_CODE
Ordinal #	10
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CLASS_NAME
Ordinal #	11
Data Type	VARCHAR2[200]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_CLASS_ROLE
Ordinal #	12
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	CLASS_STATUS
Ordinal #	15
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	PARENT_COURSE_ID
Ordinal #	17
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_NAME
Ordinal #	18
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CODE
Ordinal #	19
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_STATUS
Ordinal #	20
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CATEGORY_LEVEL
Ordinal #	21
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DESCRIPTION
Ordinal #	22
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CREDITS
Ordinal #	23
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DURATION_IN_HRS
Ordinal #	24
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DEPARTMENT_ID
Ordinal #	25
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_SEMESTER
Ordinal #	26
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_YEAR_OF_STUDY
Ordinal #	27
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_COURSE_ROLE
Ordinal #	28
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	USER_SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_COURSE_ROLE
Ordinal #	9
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	PARENT_COURSE_ID
Ordinal #	11
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_NAME
Ordinal #	12
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CODE
Ordinal #	13
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_STATUS
Ordinal #	14
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CATEGORY_LEVEL
Ordinal #	15
Data Type	NUMBER[0]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DESCRIPTION
Ordinal #	16
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CREDITS
Ordinal #	17
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DURATION_IN_HRS
Ordinal #	18
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DEPARTMENT_ID
Ordinal #	19
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_SEMESTER
Ordinal #	20
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_YEAR_OF_STUDY
Ordinal #	21
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CREATE_USER_ID
Ordinal #	22
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CREATE_DATETIME
Ordinal #	23
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_UPDATE_USER_ID
Ordinal #	24
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	USER_ROLE_CODE
Ordinal #	4
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	USER_SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_COURSE_ROLE
Ordinal #	9
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	PARENT_COURSE_ID
Ordinal #	11
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_NAME
Ordinal #	12
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_CODE
Ordinal #	13
Data Type	VARCHAR2[30]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_STATUS
Ordinal #	14
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TOP_COURSE
Ordinal #	15
Data Type	VARCHAR2[300]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_DESCRIPTION
Ordinal #	16
Data Type	VARCHAR2[2000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	17
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TABLE_LEVEL
Ordinal #	18
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	IS_LEAF
Ordinal #	19
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_COUNT
Ordinal #	20
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_TREE
Ordinal #	21
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	COURSE_PATH
Ordinal #	22
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	CREDITS
Ordinal #	23
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	DURATION_IN_HRS
Ordinal #	24
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	DEPARTMENT_ID
Ordinal #	25
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SEMESTER
Ordinal #	26
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	YEAR_OF_STUDY
Ordinal #	27
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	USER_SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_POOL_ROLE
Ordinal #	9
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	POOL_NAME
Ordinal #	11
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	POOL_DESCRIPTION
Ordinal #	12
Data Type	VARCHAR2[500]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	CREATE_DATETIME
Ordinal #	14
Data Type	DATE[7]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	USER_SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USERS_POOL_ROLE
Ordinal #	9
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	PARENT_POOL_ID
Ordinal #	11
Data Type	NUMBER[10]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_NAME
Ordinal #	12
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	TOP_POOL
Ordinal #	13
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_DESCRIPTION
Ordinal #	14
Data Type	VARCHAR2[500]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	SYSTEM_LEVEL
Ordinal #	15
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	IS_LEAF
Ordinal #	16
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_COUNT
Ordinal #	17
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_TREE
Ordinal #	18
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	POOL_PATH
Ordinal #	19
Data Type	VARCHAR2[4000]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	POOL_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	POOL_NAME
Ordinal #	2
Data Type	VARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	POOL_DESCRIPTION
Ordinal #	3
Data Type	VARCHAR2[500]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

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

N/A

Name	USERS_POOL_ROLE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	NUMBER_OF_QUESTIONS
Ordinal #	8
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ROLE_CODE
Ordinal #	9
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	ROLE_DESCRIPTION
Ordinal #	11
Data Type	VARCHAR2[400]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	GRANTABLE
Ordinal #	12
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ROLE_ENABLED
Ordinal #	13
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

Column

References

Sample Data

Comment

Name	USER_ID
Ordinal #	1
Data Type	NUMBER[10]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	USERNAME
Ordinal #	2
Data Type	NVARCHAR2[100]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

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

N/A

Name	SEMESTER
Ordinal #	5
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	YEAR_OF_STUDY
Ordinal #	6
Data Type	NUMBER[0]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_TYPE
Ordinal #	7
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	USER_STATUS
Ordinal #	8
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ROLE_CODE
Ordinal #	9
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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

N/A

Name	ROLE_DESCRIPTION
Ordinal #	11
Data Type	VARCHAR2[400]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	GRANTABLE
Ordinal #	12
Data Type	CHAR[1]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	ROLE_ENABLED
Ordinal #	13
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	FUNCTION_CODE
Ordinal #	14
Data Type	VARCHAR2[3]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	FUNCTION_NAME
Ordinal #	15
Data Type	VARCHAR2[50]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	FUNCTION_DESCRIPTION
Ordinal #	16
Data Type	VARCHAR2[400]
PK Seq. #
Nullable	YES
Cardinality	N/A
Unique	YES

N/A

Name	FUNCTION_ENABLED
Ordinal #	17
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

Name	ROLE_FUNCTION_ENABLED
Ordinal #	18
Data Type	CHAR[1]
PK Seq. #
Nullable	NO
Cardinality	N/A
Unique	YES

N/A

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