|
1: 2016-04-29 (金) 18:09:29 iseki |
| + | ** group_membership [#kcfd6b30] |
| + | +----------------+-------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +----------------+-------------+------+-----+---------+----------------+ |
| + | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| + | | groupid | varchar(64) | NO | MUL | | | |
| + | | agentid | varchar(64) | NO | | | | |
| + | | selectedroleid | varchar(64) | NO | | | | |
| + | | contribution | bigint(11) | NO | | 0 | | |
| + | | listinprofile | bigint(11) | NO | | 1 | | |
| + | | acceptnotices | bigint(11) | NO | | 1 | | |
| + | +----------------+-------------+------+-----+---------+----------------+ |
| | | |
| + | +-----+--------------------------------------+--------------------------------------+--------------------------------------+ |
| + | | id | groupid | roleid | agentid | |
| + | +-----+--------------------------------------+--------------------------------------+--------------------------------------+ |
| + | | 567 | 04a4785e-c365-4658-8090-10aaa1e99a72 | 00000000-0000-0000-0000-000000000000 | 3565bf25-1e6e-4b94-b84e-e68d4880ecff | |
| + | | 565 | 04a4785e-c365-4658-8090-10aaa1e99a72 | 00000000-0000-0000-0000-000000000000 | 8dfc44af-67db-4c6e-bc43-0fb6a1aba9ea | |
| + | | 581 | 04a4785e-c365-4658-8090-10aaa1e99a72 | 00000000-0000-0000-0000-000000000000 | b4847c23-08ea-46d3-9f29-7f96736c6845 | |
| + | | 566 | 04a4785e-c365-4658-8090-10aaa1e99a72 | b5302b6c-acf5-400e-9a8b-22b33d038d83 | 8dfc44af-67db-4c6e-bc43-0fb6a1aba9ea | |
| + | | 713 | 04f39932-1af4-4f81-beaa-137d71612196 | 00000000-0000-0000-0000-000000000000 | 03995f91-c73f-4407-9fb9-d1e369386400 | |
| + | | 714 | 04f39932-1af4-4f81-beaa-137d71612196 | bd4131b2-6a92-488a-84b6-1423261f5655 | 03995f91-c73f-4407-9fb9-d1e369386400 | |
| + | | 27 | 05d9c164-aa60-4a9a-8966-1a452f6523b1 | 00000000-0000-0000-0000-000000000000 | 55bdfc96-3074-48ce-83ef-cd4ad4596e2f | |