create_group_tables.sql

CREATE SCHEMA core;

CREATE TABLE core.group (
    group_is serial  NOT NULL PRIMARY KEY,
    name varchar (255),
    type integer REFERENCES public.cvterm(cvterm_id)
    );


CREATE TABLE core.groupmember (
    groupmember_id serial NOT NULL PRIMARY KEY,
    group_id integer REFERENCES group,
    member_id integer ,
    member_table varchar (64)
    );