OpenSim​/Flotsam Group​/DB​/group_list

+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | bigint(11)   | NO   | PRI | NULL    | auto_increment |
| groupid        | varchar(64)  | NO   | UNI |         |                |
| name           | varchar(255) | NO   | UNI |         |                |      グループの名前
| charter        | longtext     | NO   |     | NULL    |                |
| insigniaid     | varchar(64)  | NO   |     |         |                |
| founderid      | varchar(64)  | NO   |     |         |                |
| membershipfee  | bigint(11)   | NO   |     | 0       |                |
| openenrollment | varchar(255) | NO   |     |         |                |
| showinlist     | tinyint(1)   | NO   |     | 0       |                |
| allowpublish   | tinyint(1)   | NO   |     | 0       |                |
| maturepublish  | tinyint(1)   | NO   |     | 0       |                |
| 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 |