Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | bigserial | 19 | √ | nextval('app_grade_items_id_seq'::regclass) |
|
|
||||||||||||
courseid | int8 | 19 | √ | null |
|
|
||||||||||||
categoryid | int8 | 19 | √ | null |
|
|
||||||||||||
itemname | varchar | 255 | √ | null |
|
|
||||||||||||
itemtype | varchar | 30 | ''::character varying |
|
|
|||||||||||||
itemmodule | varchar | 30 | √ | null |
|
|
||||||||||||
iteminstance | int8 | 19 | √ | null |
|
|
||||||||||||
itemnumber | int8 | 19 | √ | null |
|
|
||||||||||||
iteminfo | text | 2147483647 | √ | null |
|
|
||||||||||||
idnumber | varchar | 255 | √ | null |
|
|
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
app_graditem_id_pk | Primary key | Asc | id |
app_graditem_cat_ix | Performance | Asc | categoryid |
app_graditem_cou_ix | Performance | Asc | courseid |
app_graditem_gra_ix | Performance | Asc | gradetype |
app_graditem_idncou_ix | Performance | Asc/Asc | idnumber + courseid |
app_graditem_itenee_ix | Performance | Asc/Asc | itemtype + needsupdate |
app_graditem_locloc_ix | Performance | Asc/Asc | locked + locktime |
app_graditem_out_ix | Performance | Asc | outcomeid |
app_graditem_sca_ix | Performance | Asc | scaleid |