2: 2013-04-18 (木) 23:28:21 iseki |
現: 2014-06-04 (水) 17:10:45 iseki |
| | | |
| *** DB [#n9de12e3] | | *** DB [#n9de12e3] |
- | - autoattend_sessions | + | **** autoattend_sessions [#l0100cb2] |
| mysql> show columns from mdl_autoattend_sessions; | | mysql> show columns from mdl_autoattend_sessions; |
| +--------------+--------------+------+-----+---------+----------------+ | | +--------------+--------------+------+-----+---------+----------------+ |
| 17 rows in set (0.01 sec) | | 17 rows in set (0.01 sec) |
| | | |
- | - autoattend_settings | + | **** autoattend_settings [#l7cafe8a] |
| mysql> show columns from mdl_autoattend_settings; | | mysql> show columns from mdl_autoattend_settings; |
- | +----------+--------------+------+-----+---------+----------------+ | + | +-------------+--------------+------+-----+---------+----------------+ |
- | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
- | +----------+--------------+------+-----+---------+----------------+ | + | +-------------+--------------+------+-----+---------+----------------+ |
- | | id | bigint(10) | NO | PRI | NULL | auto_increment | | + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
- | | courseid | bigint(10) | NO | MUL | 0 | | | + | | courseid | bigint(10) | NO | MUL | 0 | | |
- | | classid | bigint(10) | NO | | 0 | | | + | | classid | bigint(10) | NO | | 0 | | |
- | | status | varchar(1) | NO | | Y | | | + | | status | varchar(1) | NO | | Y | | |
- | | grade | mediumint(5) | NO | | 0 | | | + | | acronym | varchar(10) | NO | | | | |
- | +----------+--------------+------+-----+---------+----------------+ | + | | title | varchar(24) | NO | | | | |
- | 5 rows in set (0.00 sec) | + | | description | varchar(64) | NO | | | | |
| + | | grade | mediumint(5) | NO | | 0 | | |
| + | +-------------+--------------+------+-----+---------+----------------+ |
| + | 8 rows in set (0.00 sec) |
| | | |
- | - autoattend_students | + | **** autoattend_students [#k82a6bf9] |
| mysql> show columns from mdl_autoattend_students; | | mysql> show columns from mdl_autoattend_students; |
| +------------+-------------+------+-----+---------+----------------+ | | +------------+-------------+------+-----+---------+----------------+ |
| 9 rows in set (0.00 sec) | | 9 rows in set (0.00 sec) |
| | | |
- | - autoattend_classes | + | **** autoattend_classes [#p44f2d27] |
| mysql> show columns from mdl_autoattend_classes; | | mysql> show columns from mdl_autoattend_classes; |
| +--------------+-------------+------+-----+---------+----------------+ | | +--------------+-------------+------+-----+---------+----------------+ |
| 5 rows in set (0.00 sec) | | 5 rows in set (0.00 sec) |
| | | |
- | - autoattend_classifies | + | **** autoattend_classifies [#e948c4be] |
| mysql> show columns from mdl_autoattend_classifies; | | mysql> show columns from mdl_autoattend_classifies; |
| +-----------+------------+------+-----+---------+----------------+ | | +-----------+------------+------+-----+---------+----------------+ |
| 4 rows in set (0.00 sec) | | 4 rows in set (0.00 sec) |
| | | |
- | - autoattendmod | + | **** autoattendmod [#rae03d28] |
| mysql> show columns from mdl_autoattendmod; | | mysql> show columns from mdl_autoattendmod; |
| +--------------+--------------+------+-----+---------+----------------+ | | +--------------+--------------+------+-----+---------+----------------+ |
| 6 rows in set (0.00 sec) | | 6 rows in set (0.00 sec) |
| | | |
| + | #br |
| + | |
| + | *** attendance [#pef550fd] |
| + | **** attendance [#ed57d2db] |
| + | mysql> show columns from mdl_attendance ; |
| + | +--------+--------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +--------+--------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | course | bigint(10) | NO | MUL | 0 | | |
| + | | name | varchar(255) | YES | | NULL | | |
| + | | grade | bigint(10) | NO | | 100 | | |
| + | +--------+--------------+------+-----+---------+----------------+ |
| + | 4 rows in set (0.00 sec) |
| + | |
| + | **** attendance_log [#n99bf917] |
| + | mysql> show columns from mdl_attendance_log; |
| + | +-----------+--------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +-----------+--------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | sessionid | bigint(10) | NO | MUL | 0 | | |
| + | | studentid | bigint(10) | NO | MUL | 0 | | |
| + | | statusid | bigint(10) | NO | MUL | 0 | | |
| + | | statusset | varchar(100) | YES | | NULL | | |
| + | | timetaken | bigint(10) | NO | | 0 | | |
| + | | takenby | bigint(10) | NO | | 0 | | |
| + | | remarks | varchar(255) | YES | | NULL | | |
| + | +-----------+--------------+------+-----+---------+----------------+ |
| + | 8 rows in set (0.00 sec) |
| + | |
| + | **** attendance_sessions [#be1329bb] |
| + | mysql> show columns from mdl_attendance_sessions; |
| + | +-------------------+------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +-------------------+------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | attendanceid | bigint(10) | NO | MUL | 0 | | |
| + | | groupid | bigint(10) | NO | MUL | 0 | | |
| + | | sessdate | bigint(10) | NO | MUL | 0 | | |
| + | | duration | bigint(10) | NO | | 0 | | |
| + | | lasttaken | bigint(10) | YES | | NULL | | |
| + | | lasttakenby | bigint(10) | NO | | 0 | | |
| + | | timemodified | bigint(10) | YES | | NULL | | |
| + | | description | longtext | NO | | NULL | | |
| + | | descriptionformat | tinyint(2) | NO | | 0 | | |
| + | +-------------------+------------+------+-----+---------+----------------+ |
| + | 10 rows in set (0.00 sec) |
| + | |
| + | **** attendance_statuses [#lad8e2d2] |
| + | mysql> show columns from mdl_attendance_statuses; |
| + | +--------------+-------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +--------------+-------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | attendanceid | bigint(10) | NO | MUL | 0 | | |
| + | | acronym | varchar(2) | NO | | | | |
| + | | description | varchar(30) | NO | | | | |
| + | | grade | smallint(3) | NO | | 0 | | |
| + | | visible | tinyint(1) | NO | MUL | 1 | | |
| + | | deleted | tinyint(1) | NO | MUL | 0 | | |
| + | +--------------+-------------+------+-----+---------+----------------+ |
| + | 7 rows in set (0.00 sec) |
| #br | | #br |