EDIT

        iso639_2 varchar(3),

        istechnical bit,

        orderindex integer,

        transitive bit,

        defaultcolor varchar(255),

        supportscategoricaldata bit,

        orderindex integer,

        iso639_1 varchar(2),

        iso639_2 varchar(3),

        transitive bit,

        pointapproximation_errorradius integer,

        pointapproximation_latitude double,

        inreference_id integer,

        institution_id integer,

        school_id integer,

        primary key (id),

        unique (uuid)

    );

        inreference_id integer,

        institution_id integer,

        school_id integer,

        primary key (id, REV)

    );