Quellcode Tabelle dwe_prop_kost

[ Überblick   Tabellen  Views  Prozeduren  Trigger  dwe_prop_kost ]

Das DB-Objekt selbst

create table "demoadm".dwe_prop_kost
  (
    er_id serial not null ,
    er_no integer,
    er_txt varchar(255),
    er_retry integer,
    er_rel char(18),
    lv_action char(1),
    lv_mandant char(2),
    lv_kst char(15),
    lv_skt char(15),
    lv_gjahr decimal(2,0),
    lv_periode decimal(2,0),
    lv_kosten 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_prop_kost to "public" as "demoadm";
grant update on "demoadm".dwe_prop_kost to "public" as "demoadm";
grant insert on "demoadm".dwe_prop_kost to "public" as "demoadm";
grant delete on "demoadm".dwe_prop_kost to "public" as "demoadm";
grant index on "demoadm".dwe_prop_kost to "public" as "demoadm";

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