|
1: 2013-04-19 (金) 16:38:18 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 | | |
| | + | | multiple_submit | tinyint(1) | NO | | 0 | | |
| | + | | use_calendar | tinyint(1) | NO | | 0 | | |
| | + | | name_pattern | varchar(16) | NO | | lastname | | |
| | + | | time_open | bigint(10) | NO | | 0 | | |
| | + | | time_close | bigint(10) | NO | | 0 | | |
| | + | | time_modified | bigint(10) | NO | | 0 | | |
| | + | +--------------------+--------------+------+-----+----------+----------------+ |
| | + | 12 rows in set (0.05 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) |
