Changes
Page history
Update database tables
authored
Sep 27, 2024
by
Elke Kreim
Hide whitespace changes
Inline
Side-by-side
database-tables.md
View page @
343c3866
...
...
@@ -72,5 +72,27 @@ Indexes:
"mdl_roleassi_useconrol_ix"
btree
(
userid, contextid, roleid
)
```
### mdl_context
```
bash
Table
"public.mdl_context"
Column | Type | Collation | Nullable | Default
--------------
+------------------------+-----------+----------+-----------------------------------------
id
| bigint | | not null | nextval
(
'mdl_context_id_seq'
::regclass
)
contextlevel | bigint | | not null | 0
instanceid | bigint | | not null | 0
path | character varying
(
255
)
| | |
depth | smallint | | not null | 0
locked | smallint | | not null | 0
Indexes:
"mdl_cont_id_pk"
PRIMARY KEY, btree
(
id
)
"mdl_cont_conins_uix"
UNIQUE, btree
(
contextlevel, instanceid
)
"mdl_cont_ins_ix"
btree
(
instanceid
)
"mdl_cont_pat_ix"
btree
(
path
)
"mdl_cont_pat_ix_pattern"
btree
(
path varchar_pattern_ops
)
```