Quellcode Tabelle sachsachkto (ssk)

Das DB-Objekt selbst

create table "demoadm".sachsachkto
  (
    ssk_kto integer not null constraint "demoadm".ssk_con_n_kto,
    ssk_skto integer not null constraint "demoadm".ssk_con_n_skto,
    ssk_jahr smallint not null constraint "demoadm".ssk_con_n_jahr,
    ssk_periode smallint not null constraint "demoadm".ssk_con_n_periode,
    ssk_mandant char(2)
      default '01' not null constraint "demoadm".ssk_con_n_mandant,
    ssk_soll decimal(12,2)
      default 0.00 not null constraint "demoadm".ssk_con_n_soll,
    ssk_haben decimal(12,2)
      default 0.00 not null constraint "demoadm".ssk_con_n_haben,
    ssk_anzbu integer
      default 0 not null constraint "demoadm".ssk_con_n_anzbu,
    check ((((ssk_kto >= 1 ) AND (ssk_kto <= 999999 ) ) AND ((ssk_skto >= 1 ) AND
        (ssk_skto <= 999999 ) ) ) AND (ssk_kto < ssk_skto ) ) constraint "demoadm"
  .ssk_con_c_kto,
    check ((ssk_jahr >= 1990 ) AND (ssk_jahr <= 2010 ) ) constraint "demoadm"
  .ssk_con_c_jahr,
    check ((ssk_periode >= 1 ) AND (ssk_periode <= 99 ) ) constraint "demoadm"
  .ssk_con_c_periode,
    check (ssk_anzbu >= 0 ) constraint "demoadm".ssk_con_c_anzbu
  ) extent size 608 next size 16 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".ssk_idx_p on "demoadm".sachsachkto
    (ssk_mandant,ssk_jahr,ssk_periode,ssk_skto,ssk_kto);
alter table "demoadm".sachsachkto add constraint primary key
    (ssk_mandant,ssk_jahr,ssk_periode,ssk_skto,ssk_kto) constraint
    "demoadm".ssk_con_p  ;

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