| id |
serial |
10 |
|
√ |
nextval('role_id_seq'::regclass) |
|
|
| role_name |
varchar |
255 |
√ |
|
null |
|
|
| parent_id |
int4 |
10 |
√ |
|
null |
|
| role.id
|
parent_id_fk_role_id R |
|
| version |
int4 |
10 |
√ |
|
0 |
|
|
| is_locked |
bool |
1 |
|
|
false |
|
|
| owner_id |
int4 |
10 |
√ |
|
null |
|
|
| update_id |
int4 |
10 |
√ |
|
null |
|
|
| status_id |
int4 |
10 |
√ |
|
1 |
|
|
| date_created |
date |
13 |
√ |
|
'2012-02-01'::date |
|
|
| date_updated |
date |
13 |
√ |
|
'2012-02-01'::date |
|
|
| is_used_with_auth_group_study |
bool |
1 |
√ |
|
false |
|
|
| is_used_with_auth_group_site |
bool |
1 |
√ |
|
false |
|
|
| is_used_with_auth_group_crf |
bool |
1 |
√ |
|
false |
|
|
| is_used_with_auth_group_eventcrf |
bool |
1 |
√ |
|
false |
|
|
| is_used_with_auth_group_allstudies |
bool |
1 |
√ |
|
false |
|
|
