app_grade_categories

0 rows


Description

This table keeps information about categories, used for grouping items.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_grade_categories_id_seq'::regclass)
app_grade_categories.parent Defined in XML R
app_grade_categories_history.oldid Defined in XML R
app_grade_categories_history.parent Defined in XML R
app_grade_items.categoryid Defined in XML R
app_grade_items_history.categoryid Defined in XML R
courseid int8 19 null
app_course.id Defined in XML R
parent int8 19 √ null
app_grade_categories.id Defined in XML R
depth int8 19 0
path varchar 255 √ null
fullname varchar 255 ''::character varying
aggregation int8 19 0
keephigh int8 19 0
droplow int8 19 0
aggregateonlygraded int2 5 0
aggregateoutcomes int2 5 0
timecreated int8 19 null
timemodified int8 19 null
hidden int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_gradcate_id_pk Primary key Asc id
app_gradcate_cou_ix Performance Asc courseid
app_gradcate_par_ix Performance Asc parent

Relationships

Close relationships within degrees of separation