Quellcode Tabelle perssachkto (psk)

Das DB-Objekt selbst

create table "demoadm".perssachkto
  (
    psk_pkto integer not null constraint "demoadm".psk_con_n_pkto,
    psk_skto integer not null constraint "demoadm".psk_con_n_skto,
    psk_jahr smallint not null constraint "demoadm".psk_con_n_jahr,
    psk_periode smallint not null constraint "demoadm".psk_con_n_periode,
    psk_mandant char(2)
      default '01' not null constraint "demoadm".psk_con_n_mandant,
    psk_soll decimal(12,2)
      default 0.00 not null constraint "demoadm".psk_con_n_soll,
    psk_haben decimal(12,2)
      default 0.00 not null constraint "demoadm".psk_con_n_haben,
    psk_anzbu integer
      default 0 not null constraint "demoadm".psk_con_n_anzbu,
    check (psk_pkto > 999999 ) constraint "demoadm".psk_con_c_pkto,
    check ((psk_skto >= 1 ) AND (psk_skto <= 999999 ) ) constraint "demoadm".psk_con_c_skto,
    check ((psk_jahr >= 1990 ) AND (psk_jahr <= 2010 ) ) constraint "demoadm"
  .psk_con_c_jahr,
    check ((psk_periode >= 1 ) AND (psk_periode <= 99 ) ) constraint "demoadm"
  .psk_con_c_periode,
    check (psk_anzbu >= 0 ) constraint "demoadm".psk_con_c_anzbu
  ) in usrdbs04 extent size 13200 next size 336 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".psk_idx_p on "demoadm".perssachkto
    (psk_mandant,psk_jahr,psk_periode,psk_skto,psk_pkto);
alter table "demoadm".perssachkto add constraint primary key
    (psk_mandant,psk_jahr,psk_periode,psk_skto,psk_pkto) constraint
    "demoadm".psk_con_p  ;

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