Quellcode Tabelle btrkonto (btk)

Das DB-Objekt selbst

create table "demoadm".btrkonto
  (
    btk_pkto integer not null constraint "demoadm".btk_con_n_pkto,
    btk_ibtrkto integer not null constraint "demoadm".btk_con_n_ibtrkto,
    btk_btrkto char(6) not null constraint "demoadm".btk_con_n_btrkto,
    btk_fibukto char(7) not null constraint "demoadm".btk_con_n_fibukto,
    btk_user char(8)
      default user not null constraint "demoadm".btk_con_n_user,
    btk_time datetime year to second
      default current year to second not null constraint "demoadm".btk_con_n_time,
    check (((((((btk_ibtrkto - btk_btrkto ) = 0. ) AND ((btk_pkto - btk_fibukto )
        = 0. ) ) AND (btk_btrkto MATCHES '[0-9][0-9][0-9][0-9][0-9][0-9]' )
        ) AND (btk_fibukto MATCHES '[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' )
        ) AND (btk_ibtrkto = mod(btk_pkto , 1000000 ) ) ) AND ((btk_pkto >=
        7000000 ) AND (btk_pkto <= 7999999 ) ) ) constraint "demoadm".btk_con_c_equiv
  ) extent size 464 next size 8 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".btk_idx_p on "demoadm".btrkonto
    (btk_ibtrkto);
create unique index "demoadm".btk_idx_u_btrkto on "demoadm".btrkonto
    (btk_btrkto);
create unique index "demoadm".btk_idx_u_fibukto on "demoadm".btrkonto
    (btk_fibukto);
create unique index "demoadm".btk_idx_u_pkto on "demoadm".btrkonto
    (btk_pkto);
alter table "demoadm".btrkonto add constraint unique (btk_fibukto)
    constraint "demoadm".btk_con_u_fibukto  ;
alter table "demoadm".btrkonto add constraint unique (btk_pkto)
    constraint "demoadm".btk_con_u_pkto  ;
alter table "demoadm".btrkonto add constraint unique (btk_btrkto)
    constraint "demoadm".btk_con_u_btrkto  ;
alter table "demoadm".btrkonto add constraint primary key (btk_ibtrkto)
    constraint "demoadm".btk_con_p  ;

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