mod_apply​/devel​/DB

mysql> show columns from mdl_apply;
+-------------------------+--------------+------+-----+----------+----------------+
| Field                   | Type         | Null | Key | Default  | Extra          |
+-------------------------+--------------+------+-----+----------+----------------+
| id                      | bigint(10)   | NO   | PRI | NULL     | auto_increment |
| course                  | bigint(10)   | NO   | MUL | 0        |                |
| name                    | varchar(255) | NO   |     |          |                |
| intro                   | longtext     | NO   |     | NULL     |                |
| introformat             | smallint(4)  | NO   |     | 0        |                |
| email_notification      | tinyint(1)   | NO   |     | 0        |                |
| email_notification_user | tinyint(1)   | NO   |     | 0        |                |
| multiple_submit         | tinyint(1)   | NO   |     | 0        |                |
| use_calendar            | tinyint(1)   | NO   |     | 0        |                |
| name_pattern            | varchar(16)  | NO   |     | lastname |                |
| only_acked_accept       | tinyint(1)   | NO   |     | 0        |                |
| enable_deletemode       | tinyint(1)   | NO   |     | 0        |                |
| can_discard             | tinyint(1)   | NO   |     | 1        |                |
| date_format             | varchar(32)  | NO   |     |          |                |
| time_open               | bigint(10)   | NO   |     | 0        |                |
| time_close              | bigint(10)   | NO   |     | 0        |                |
| time_modified           | bigint(10)   | NO   |     | 0        |                |
+-------------------------+--------------+------+-----+----------+----------------+
17 rows in set (0.00 sec)

mysql> show columns from mdl_apply_submit;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | bigint(10)   | NO   | PRI | NULL    | auto_increment | 
| apply_id      | bigint(10)   | NO   | MUL | 0       |                |
| user_id       | bigint(10)   | NO   |     | 0       |                |
| version       | mediumint(6) | NO   |     | 0       |                |
| title         | varchar(32)  | NO   |     |         |                |
| class         | tinyint(1)   | NO   |     | 0       |                |
| acked         | tinyint(1)   | NO   |     | 0       |                |
| acked_user    | bigint(10)   | NO   |     | 0       |                |
| acked_time    | bigint(10)   | NO   |     | 0       |                |
| execd         | tinyint(1)   | NO   |     | 0       |                |
| execd_user    | bigint(10)   | NO   |     | 0       |                |
| execd_time    | bigint(10)   | NO   |     | 0       |                |
| time_modified | bigint(10)   | NO   |     | 0       |                |
| otitle        | varchar(32)  | NO   |     |         |                |
| oclass        | tinyint(1)   | NO   |     | 0       |                |
| oacked        | tinyint(1)   | NO   |     | 0       |                |
| oacked_user   | bigint(10)   | NO   |     | 0       |                |
| oacked_time   | bigint(10)   | NO   |     | 0       |                |
| oexecd        | tinyint(1)   | NO   |     | 0       |                |
| oexecd_user   | bigint(10)   | NO   |     | 0       |                |
| oexecd_time   | bigint(10)   | NO   |     | 0       |                |
+---------------+--------------+------+-----+---------+----------------+
21 rows in set (0.00 sec)

mysql> show columns from mdl_apply_value;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | bigint(10)   | NO   | PRI | NULL    | auto_increment |
| submit_id     | bigint(10)   | NO   | MUL | 0       |                |
| item_id       | bigint(10)   | NO   | MUL | 0       |                |
| version       | mediumint(6) | NO   |     | 0       |                |
| value         | longtext     | NO   |     | NULL    |                |
| time_modified | bigint(10)   | NO   |     | 0       |                |
+---------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

mysql> show columns from mdl_apply_item;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | bigint(10)   | NO   | PRI | NULL    | auto_increment |
| apply_id     | bigint(10)   | NO   | MUL | 0       |                |
| template     | bigint(10)   | NO   | MUL | 0       |                |
| name         | varchar(255) | NO   |     |         |                |
| label        | varchar(255) | NO   |     |         |                |
| presentation | longtext     | NO   |     | NULL    |                |
| typ          | varchar(255) | NO   |     |         |                |
| hasvalue     | tinyint(1)   | NO   |     | 0       |                |
| position     | smallint(3)  | NO   |     | 0       |                |
| required     | tinyint(1)   | NO   |     | 0       |                |
| dependitem   | bigint(10)   | NO   |     | 0       |                |
| dependvalue  | varchar(255) | NO   |     |         |                |
| options      | varchar(255) | NO   |     |         |                |
+--------------+--------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

mysql> show columns from mdl_apply_template;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | bigint(10)   | NO   | PRI | NULL    | auto_increment |
| course   | bigint(10)   | NO   | MUL | 0       |                |
| name     | varchar(255) | NO   |     |         |                |
| ispublic | tinyint(1)   | NO   |     | 0       |                |
+----------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)