Quellcode Tabelle dwe_journal

[ Überblick Tabellen Views Prozeduren Trigger dwe_journal ]

Das DB-Objekt selbst

create table "demoadm".dwe_journal
  (
    er_id serial not null ,
    er_no integer,
    er_txt varchar(250),
    er_retry integer,
    er_rel char(18),
    lv_action char(1),
    lv_mandant char(2),
    lv_skto_nr 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 72 next size 8 lock mode row;

Abhängige Objekte, Rechte

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

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