Quellcode Tabelle fibuktogrp (fkg)

Das DB-Objekt selbst

create table "demoadm".fibuktogrp
  (
    fkg_n_gruppe integer not null constraint "demoadm".fkg_con_n_n_gruppe,
    fkg_kto integer not null constraint "demoadm".fkg_con_n_kto,
    fkg_user char(8)
      default user not null constraint "demoadm".fkg_con_n_user,
    fkg_time datetime year to second
      default current year to second not null constraint "demoadm".fkg_con_n_time,
    check ((fkg_n_gruppe >= 260015 ) AND (fkg_n_gruppe <= 262999 ) ) constraint "demoadm"
  .fkg_con_c_n_gruppe
  ) extent size 104 next size 8 lock mode row;

Abhängige Objekte, Rechte

create index "demoadm".fkg_idx_d_grp on "demoadm".fibuktogrp (fkg_n_gruppe);
create unique index "demoadm".fkg_idx_u_ktogrp on "demoadm".fibuktogrp
    (fkg_kto,fkg_n_gruppe);
create unique index "demoadm".fkg_idx_cu_grpkto on "demoadm".fibuktogrp
    (fkg_n_gruppe,fkg_kto);
alter table "demoadm".fibuktogrp add constraint unique (fkg_n_gruppe,
    fkg_kto) constraint "demoadm".fkg_con_u_grpkto  ;

alter table "demoadm".fibuktogrp add constraint (foreign key
    (fkg_n_gruppe) references "demoadm".numverw  constraint "demoadm"
    .fkg_con_r_nmv);

grant update on "demoadm".fibuktogrp to "dbadmin" as "demoadm";
grant insert on "demoadm".fibuktogrp to "dbadmin" as "demoadm";
grant delete on "demoadm".fibuktogrp to "dbadmin" as "demoadm";
grant select on "demoadm".fibuktogrp to "public" as "demoadm";
grant update on "demoadm".fibuktogrp to "public" as "demoadm";
grant insert on "demoadm".fibuktogrp to "public" as "demoadm";
grant delete on "demoadm".fibuktogrp to "public" as "demoadm";
grant index on "demoadm".fibuktogrp to "public" as "demoadm";
grant update on "demoadm".fibuktogrp to "rohloff" as "demoadm";
grant insert on "demoadm".fibuktogrp to "rohloff" as "demoadm";
grant delete on "demoadm".fibuktogrp to "rohloff" as "demoadm";