Network System Laboratory - Source of mod_apply/devel/DB

View the diff.
Go to mod_apply/devel/DB.
- 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)
« Prev
Backup list of mod_apply/devel/DB
Backup source of mod_apply/devel/DB(No. All)
- 1: 2013-04-19 (Fri) 16:38:18 iseki
- 2: 2013-04-21 (Sun) 17:50:26 iseki
- Cur: 2018-09-21 (Fri) 10:40:26 iseki
Source of mod_apply/devel/DB

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of mod_apply​/devel​/DB

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of mod_apply/devel/DB
