Network System Laboratory - Backup source of mod_apply(No. 5)

View the diff.
View the diff current.
Go to mod_apply.
** mod_apply [#i080b5b2]
- moodle用 申請書類提出モジュール (moodle-2.4 以降)
- feedback モジュールを改造
- 開発中

#br
*** 特殊ラベル [#za88df2d]
- submit_title
-- テキストフィールド（短文回答）にこのラベルが付いた場合，申請書のタイトルとして扱われる．
- submit_only
-- 申請時のみに表示される項目．利用許諾などに使用する．
- admin_reply
-- 申請時にユーザには表示されないが，申請後の画面には表示される．管理者は編集可能なので，管理者からのコメントなどに用いる．
- admin_only
-- 管理者だけが，表示・編集可能な項目．管理者のメモなどに使用する．

#br

*** DB [#l2928f94]
- 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)

*** Bug [#zffe431e]
- captcha
#br
« Prev Next »
Backup list of mod_apply
Backup source of mod_apply(No. All)
Backup source of mod_apply (No. 5)

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter
