database-tables.md

@@ -92,6 +92,77 @@ Indexes:
     "mdl_cont_pat_ix_pattern" btree (path varchar_pattern_ops)
 ```
 
+### mdl_user
+
+```bash
+     Column       |          Type          | Collation | Nullable |               Default                
+-------------------+------------------------+-----------+----------+--------------------------------------
+ id                | bigint                 |           | not null | nextval('mdl_user_id_seq'::regclass)
+ auth              | character varying(20)  |           | not null | 'manual'::character varying
+ confirmed         | smallint               |           | not null | 0
+ policyagreed      | smallint               |           | not null | 0
+ deleted           | smallint               |           | not null | 0
+ suspended         | smallint               |           | not null | 0
+ mnethostid        | bigint                 |           | not null | 0
+ username          | character varying(100) |           | not null | ''::character varying
+ password          | character varying(255) |           | not null | ''::character varying
+ idnumber          | character varying(255) |           | not null | ''::character varying
+ firstname         | character varying(100) |           | not null | ''::character varying
+ lastname          | character varying(100) |           | not null | ''::character varying
+ email             | character varying(100) |           | not null | ''::character varying
+ emailstop         | smallint               |           | not null | 0
+ phone1            | character varying(20)  |           | not null | ''::character varying
+ phone2            | character varying(20)  |           | not null | ''::character varying
+ institution       | character varying(255) |           | not null | ''::character varying
+ department        | character varying(255) |           | not null | ''::character varying
+ address           | character varying(255) |           | not null | ''::character varying
+ city              | character varying(120) |           | not null | ''::character varying
+ country           | character varying(2)   |           | not null | ''::character varying
+ lang              | character varying(30)  |           | not null | 'en'::character varying
+ calendartype      | character varying(30)  |           | not null | 'gregorian'::character varying
+ theme             | character varying(50)  |           | not null | ''::character varying
+ timezone          | character varying(100) |           | not null | '99'::character varying
+ firstaccess       | bigint                 |           | not null | 0
+ lastaccess        | bigint                 |           | not null | 0
+ lastlogin         | bigint                 |           | not null | 0
+ currentlogin      | bigint                 |           | not null | 0
+ lastip            | character varying(45)  |           | not null | ''::character varying
+ secret            | character varying(15)  |           | not null | ''::character varying
+ picture           | bigint                 |           | not null | 0
+ description       | text                   |           |          | 
+ descriptionformat | smallint               |           | not null | 1
+ mailformat        | smallint               |           | not null | 1
+ maildigest        | smallint               |           | not null | 0
+ maildisplay       | smallint               |           | not null | 2
+ autosubscribe     | smallint               |           | not null | 1
+ trackforums       | smallint               |           | not null | 0
+ timecreated       | bigint                 |           | not null | 0
+ timemodified      | bigint                 |           | not null | 0
+ trustbitmask      | bigint                 |           | not null | 0
+ imagealt          | character varying(255) |           |          | 
+ lastnamephonetic  | character varying(255) |           |          | 
+ firstnamephonetic | character varying(255) |           |          | 
+ middlename        | character varying(255) |           |          | 
+ alternatename     | character varying(255) |           |          | 
+ moodlenetprofile  | character varying(255) |           |          | 
+Indexes:
+    "mdl_user_id_pk" PRIMARY KEY, btree (id)
+    "mdl_user_alt_ix" btree (alternatename)
+    "mdl_user_aut_ix" btree (auth)
+    "mdl_user_cit_ix" btree (city)
+    "mdl_user_con_ix" btree (confirmed)
+    "mdl_user_cou_ix" btree (country)
+    "mdl_user_del_ix" btree (deleted)
+    "mdl_user_ema_ix" btree (email)
+    "mdl_user_fir2_ix" btree (firstnamephonetic)
+    "mdl_user_fir_ix" btree (firstname)
+    "mdl_user_idn_ix" btree (idnumber)
+    "mdl_user_las2_ix" btree (lastaccess)
+    "mdl_user_las3_ix" btree (lastnamephonetic)
+    "mdl_user_las_ix" btree (lastname)
+    "mdl_user_mid_ix" btree (middlename)
+    "mdl_user_mneuse_uix" UNIQUE, btree (mnethostid, username)
+```