![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-02-06T11:35:28+00:00","default:iseki","iseki") - mdl_apply 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) - mdl_apply_submit 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) - mdl_apply_value 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) - mdl_apply_item 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) - mdl_apply_template （未使用） 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)
