...
Code Block |
---|
CREATE TABLE from_grouper_group ( id int8varchar(50) NOT NULL, "name" varchar(1024) NOT NULL, CONSTRAINT from_grouper_group_pk PRIMARY KEY (id) ); CREATE UNIQUE INDEX from_grouper_group_name_idx ON from_grouper_group ("name"); |
Group attribute table
...
Code Block |
---|
CREATE TABLE from_grouper_group_attr ( group_id int8varchar(50) NOT NULL, attribute_name varchar(50) NOT NULL, attribute_value varchar(1000) NOT NULL, CONSTRAINT from_grouper_group_attr_pk PRIMARY KEY (group_id,attribute_name,attribute_value) ); ALTER TABLE from_grouper_group_attr ADD CONSTRAINT from_grouper_group_attr_fk FOREIGN KEY (group_id) REFERENCES from_grouper_group(id) ON DELETE CASCADE; CREATE INDEX from_grouper_group_attr_attribute_name_idx ON public.from_grouper_group_attr (attribute_name,attribute_value); |
Entity table
Code Block |
---|
CREATE TABLE from_grouper_entity ( id int8varchar(50) NOT NULL, subject_id varchar(100) NOT NULL, subject_source_id varchar(20) NOT NULL, CONSTRAINT from_grouper_entity_pk PRIMARY KEY (id) ); CREATE UNIQUE INDEX from_grouper_entity_subject_id_idx ON from_grouper_entity (subject_id,subject_source_id); |
Membership table
Code Block |
---|
CREATE TABLE from_grouper_membership ( group_id varchar(50) NOT NULL, entity_id varchar(50) NOT NULL, CONSTRAINT from_grouper_membership_pk PRIMARY KEY (group_id,entity_id), CONSTRAINT from_grouper_membership_fk FOREIGN KEY (group_id) REFERENCES from_grouper_group(id), CONSTRAINT from_grouper_membership_fk_1 FOREIGN KEY (entity_id) REFERENCES from_grouper_entity(id) ); |
Attribute view for attribute framework
Code Block |
---|
create view from_grouper_attributes_v as
select gg.name as group_name,
(select gaagv.value_integer from grouper_aval_asn_group_v gaagv
where gaagv.attribute_def_name_name = 'test:gidNumber' and gaagv.group_id = gg.id ) as gid_number
from grouper_groups gg; |
Membership view
Code Block |
---|
create view from_grouper_membership_v as
select fgg."name" , fge.subject_id, fge.subject_source_id,
(select fgga.attribute_value from from_grouper_group_attr fgga
where fgga.group_id = fgg.id and fgga.attribute_name = 'gidNumber') as gid_number
from from_grouper_entity fge, from_grouper_group fgg, from_grouper_membership fgm
where fgg.id = fgm.group_id and fge.id = fgm.entity_id |
Provisioner configuration
Expand | ||
---|---|---|
| ||
Expand | ||
---|---|---|
| ||
|