1: 2016-04-29 (金) 17:58:57 iseki  |
現: 2016-07-20 (水) 16:37:05 iseki |
| - | ** group_list ; [#jb9c0cdc] | + | *** mdl_modlos_group_list [#jb9c0cdc] |
| | +----------------+--------------+------+-----+---------+----------------+ | | +----------------+--------------+------+-----+---------+----------------+ |
| | | Field | Type | Null | Key | Default | Extra | | | | Field | Type | Null | Key | Default | Extra | |
| | | id | bigint(11) | NO | PRI | NULL | auto_increment | | | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| | | groupid | varchar(64) | NO | UNI | | | | | | groupid | varchar(64) | NO | UNI | | | |
| - | | name | varchar(255) | NO | UNI | | | | + | | name | varchar(255) | NO | UNI | | | グループの名前 |
| | | charter | longtext | NO | | NULL | | | | | charter | longtext | NO | | NULL | | |
| | | insigniaid | varchar(64) | NO | | | | | | | insigniaid | varchar(64) | NO | | | | |
| | | ownerroleid | varchar(128) | NO | | | | | | | ownerroleid | varchar(128) | NO | | | | |
| | +----------------+--------------+------+-----+---------+----------------+ | | +----------------+--------------+------+-----+---------+----------------+ |
| | + | |
| | + | +----+--------------------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| | + | | id | groupid | name | charter | insigniaid | founderid | member... | opene... | show... | allow... | matur... | ownerroleid | |
| | + | +----+--------------------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| | + | | 1 | bab01d9a-68b0-427c-87b4-9b28ac885bb5 | admin | 管理者グループ | 00000000-0000-0000-0000-000000000000 | 64bdf6f6-f5f3-4bea-9ca2-dd763a19b68a | 0 | 0 | 1 | 0 | 1 | ccae5ff7-7a5f-499c-9958-6ba3bf578e3c | |
| | + | | 2 | 36309c7f-8dd5-46f2-94b6-bdd312265835 | TUIS | 情報大 スタッフ | 00000000-0000-0000-0000-000000000000 | 64bdf6f6-f5f3-4bea-9ca2-dd763a19b68a | 0 | 0 | 1 | 0 | 1 | 6af32d95-cad1-4e19-8668-83cb593ce976 | |
| | + | | 3 | bb409864-6527-42b1-ad5d-e8d8d6cad446 | Resonant | | 8dacb5c9-80bc-aae4-6a12-d792b6eb7dc4 | b1a59dbd-64f0-4b0d-b408-d556eaac6ec7 | 0 | 0 | 1 | 0 | 1 | 705ac567-7a55-4c51-a203-cf03fbdaf75c | |
