| 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 |
