Quellcode Tabelle dwe_perskto

[ Überblick   Tabellen  Views  Prozeduren  Trigger  dwe_perskto ]

Das DB-Objekt selbst

create table "demoadm".dwe_perskto
  (
    er_id serial not null ,
    er_no integer,
    er_isam integer,
    er_txt varchar(255),
    er_retry integer,
    er_rel char(18),
    lv_action char(1),
    lv_mandant char(2),
    lv_pkto char(15),
    lv_jahr decimal(4,0),
    lv_periode decimal(2,0),
    lv_soll decimal(13,2),
    lv_haben decimal(13,2),
    primary key (er_id)
  ) extent size 10 next size 8 lock mode row;

Abhängige Objekte, Rechte

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

HTML-Autor: Rohloff, Datenbank: demodb, Datenstand: 31.05.00 17:07