Quellcode Tabelle dwe_k_buch

[ Überblick   Tabellen  Views  Prozeduren  Trigger  dwe_k_buch ]

Das DB-Objekt selbst

create table "demoadm".dwe_k_buch
  (
    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_journr integer,
    lv_periode integer,
    lv_kto char(15),
    lv_gktr char(15),
    lv_gkst char(15),
    lv_betrag decimal(13,2),
    lv_menge decimal(22,7),
    primary key (er_id)
  ) extent size 10 next size 8 lock mode row;

Abhängige Objekte, Rechte

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

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