Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
If you want to see English page, please click "English" Button at Left.
[
タイトル一覧
|
ページ一覧
|
新規
|
単語検索
|
最終更新
|
ヘルプ
]
autoattend/devel
をテンプレートにして作成
[
トップ
]
[ ]
開始行:
** autoattend devel
*** DB
**** autoattend_sessions
mysql> show columns from mdl_autoattend_sessions;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| courseid | bigint(10) | NO | MUL | 0 | ...
| classid | bigint(10) | NO | | 0 | ...
| creator | bigint(10) | NO | | 0 | ...
| sessdate | bigint(10) | NO | MUL | 0 | ...
| starttime | bigint(10) | NO | MUL | 0 | ...
| endtime | bigint(10) | NO | | 0 | ...
| latetime | bigint(10) | NO | | 0 | ...
| takenby | bigint(10) | NO | | 0 | ...
| timetaken | bigint(10) | NO | | 0 | ...
| method | varchar(1) | NO | | S | ...
| attendkey | varchar(36) | YES | | NULL | ...
| denysameip | tinyint(2) | NO | | 1 | ...
| allowip | varchar(128) | YES | | NULL | ...
| description | varchar(255) | YES | | NULL | ...
| state | varchar(1) | NO | | N | ...
| timemodified | bigint(10) | NO | | 0 | ...
+--------------+--------------+------+-----+---------+--...
17 rows in set (0.01 sec)
**** autoattend_settings
mysql> show columns from mdl_autoattend_settings;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| courseid | bigint(10) | NO | MUL | 0 | ...
| classid | bigint(10) | NO | | 0 | ...
| status | varchar(1) | NO | | Y | ...
| acronym | varchar(10) | NO | | | ...
| title | varchar(24) | NO | | | ...
| description | varchar(64) | NO | | | ...
| grade | mediumint(5) | NO | | 0 | ...
+-------------+--------------+------+-----+---------+---...
8 rows in set (0.00 sec)
**** autoattend_students
mysql> show columns from mdl_autoattend_students;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| id | bigint(10) | NO | PRI | NULL | auto...
| attsid | bigint(10) | NO | MUL | 0 | ...
| studentid | bigint(10) | NO | MUL | 0 | ...
| status | varchar(1) | NO | | Y | ...
| called | varchar(1) | NO | | D | ...
| calledby | bigint(10) | NO | | 0 | ...
| calledtime | bigint(10) | NO | | 0 | ...
| remarks | varchar(50) | YES | | NULL | ...
| ipaddress | varchar(20) | NO | | | ...
+------------+-------------+------+-----+---------+-----...
9 rows in set (0.00 sec)
**** autoattend_classes
mysql> show columns from mdl_autoattend_classes;
+--------------+-------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+--------------+-------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| courseid | bigint(10) | NO | MUL | 0 | ...
| creator | bigint(10) | NO | | 0 | ...
| name | varchar(50) | NO | | default | ...
| timemodified | bigint(10) | NO | | 0 | ...
+--------------+-------------+------+-----+---------+---...
5 rows in set (0.00 sec)
**** autoattend_classifies
mysql> show columns from mdl_autoattend_classifies;
+-----------+------------+------+-----+---------+-------...
| Field | Type | Null | Key | Default | Extra ...
+-----------+------------+------+-----+---------+-------...
| id | bigint(10) | NO | PRI | NULL | auto_i...
| courseid | bigint(10) | NO | MUL | 0 | ...
| studentid | bigint(10) | NO | MUL | 0 | ...
| classid | bigint(10) | NO | | 0 | ...
+-----------+------------+------+-----+---------+-------...
4 rows in set (0.00 sec)
**** autoattendmod
mysql> show columns from mdl_autoattendmod;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| course | bigint(10) | NO | MUL | 0 | ...
| name | varchar(255) | NO | | | ...
| intro | longtext | NO | | NULL | ...
| introformat | smallint(4) | YES | | 0 | ...
| timemodified | bigint(10) | NO | | 0 | ...
+--------------+--------------+------+-----+---------+--...
6 rows in set (0.00 sec)
#br
*** attendance
**** attendance
mysql> show columns from mdl_attendance ;
+--------+--------------+------+-----+---------+--------...
| Field | Type | Null | Key | Default | Extra ...
+--------+--------------+------+-----+---------+--------...
| id | bigint(10) | NO | PRI | NULL | auto_in...
| 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
mysql> show columns from mdl_attendance_log;
+-----------+--------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+-----------+--------------+------+-----+---------+-----...
| id | bigint(10) | NO | PRI | NULL | auto...
| 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
mysql> show columns from mdl_attendance_sessions;
+-------------------+------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-------------------+------------+------+-----+---------...
| id | bigint(10) | NO | PRI | NULL ...
| 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
mysql> show columns from mdl_attendance_statuses;
+--------------+-------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+--------------+-------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| 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
終了行:
** autoattend devel
*** DB
**** autoattend_sessions
mysql> show columns from mdl_autoattend_sessions;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| courseid | bigint(10) | NO | MUL | 0 | ...
| classid | bigint(10) | NO | | 0 | ...
| creator | bigint(10) | NO | | 0 | ...
| sessdate | bigint(10) | NO | MUL | 0 | ...
| starttime | bigint(10) | NO | MUL | 0 | ...
| endtime | bigint(10) | NO | | 0 | ...
| latetime | bigint(10) | NO | | 0 | ...
| takenby | bigint(10) | NO | | 0 | ...
| timetaken | bigint(10) | NO | | 0 | ...
| method | varchar(1) | NO | | S | ...
| attendkey | varchar(36) | YES | | NULL | ...
| denysameip | tinyint(2) | NO | | 1 | ...
| allowip | varchar(128) | YES | | NULL | ...
| description | varchar(255) | YES | | NULL | ...
| state | varchar(1) | NO | | N | ...
| timemodified | bigint(10) | NO | | 0 | ...
+--------------+--------------+------+-----+---------+--...
17 rows in set (0.01 sec)
**** autoattend_settings
mysql> show columns from mdl_autoattend_settings;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| courseid | bigint(10) | NO | MUL | 0 | ...
| classid | bigint(10) | NO | | 0 | ...
| status | varchar(1) | NO | | Y | ...
| acronym | varchar(10) | NO | | | ...
| title | varchar(24) | NO | | | ...
| description | varchar(64) | NO | | | ...
| grade | mediumint(5) | NO | | 0 | ...
+-------------+--------------+------+-----+---------+---...
8 rows in set (0.00 sec)
**** autoattend_students
mysql> show columns from mdl_autoattend_students;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| id | bigint(10) | NO | PRI | NULL | auto...
| attsid | bigint(10) | NO | MUL | 0 | ...
| studentid | bigint(10) | NO | MUL | 0 | ...
| status | varchar(1) | NO | | Y | ...
| called | varchar(1) | NO | | D | ...
| calledby | bigint(10) | NO | | 0 | ...
| calledtime | bigint(10) | NO | | 0 | ...
| remarks | varchar(50) | YES | | NULL | ...
| ipaddress | varchar(20) | NO | | | ...
+------------+-------------+------+-----+---------+-----...
9 rows in set (0.00 sec)
**** autoattend_classes
mysql> show columns from mdl_autoattend_classes;
+--------------+-------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+--------------+-------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| courseid | bigint(10) | NO | MUL | 0 | ...
| creator | bigint(10) | NO | | 0 | ...
| name | varchar(50) | NO | | default | ...
| timemodified | bigint(10) | NO | | 0 | ...
+--------------+-------------+------+-----+---------+---...
5 rows in set (0.00 sec)
**** autoattend_classifies
mysql> show columns from mdl_autoattend_classifies;
+-----------+------------+------+-----+---------+-------...
| Field | Type | Null | Key | Default | Extra ...
+-----------+------------+------+-----+---------+-------...
| id | bigint(10) | NO | PRI | NULL | auto_i...
| courseid | bigint(10) | NO | MUL | 0 | ...
| studentid | bigint(10) | NO | MUL | 0 | ...
| classid | bigint(10) | NO | | 0 | ...
+-----------+------------+------+-----+---------+-------...
4 rows in set (0.00 sec)
**** autoattendmod
mysql> show columns from mdl_autoattendmod;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| course | bigint(10) | NO | MUL | 0 | ...
| name | varchar(255) | NO | | | ...
| intro | longtext | NO | | NULL | ...
| introformat | smallint(4) | YES | | 0 | ...
| timemodified | bigint(10) | NO | | 0 | ...
+--------------+--------------+------+-----+---------+--...
6 rows in set (0.00 sec)
#br
*** attendance
**** attendance
mysql> show columns from mdl_attendance ;
+--------+--------------+------+-----+---------+--------...
| Field | Type | Null | Key | Default | Extra ...
+--------+--------------+------+-----+---------+--------...
| id | bigint(10) | NO | PRI | NULL | auto_in...
| 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
mysql> show columns from mdl_attendance_log;
+-----------+--------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+-----------+--------------+------+-----+---------+-----...
| id | bigint(10) | NO | PRI | NULL | auto...
| 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
mysql> show columns from mdl_attendance_sessions;
+-------------------+------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-------------------+------------+------+-----+---------...
| id | bigint(10) | NO | PRI | NULL ...
| 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
mysql> show columns from mdl_attendance_statuses;
+--------------+-------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+--------------+-------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| 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
ページ名:
サイト内 検索
高度な検索
ログイン
ユーザー名:
パスワード:
パスワード紛失
新規登録
サブ メニュー
新着情報
Books
リンク
サイトマップ
e-Learning
TUIS 認証局証明書
ミニカレンダー
2024年 5月
日
月
火
水
木
金
土
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<今日>
オンライン状況
112 人のユーザが現在オンラインです。 (24 人のユーザが xpwiki を参照しています。)
登録ユーザ: 0
ゲスト: 112
もっと...
アクセスカウンタ
今日 :
昨日 :
総計 :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com