Quellcode Tabelle numverw (nmv)

Das DB-Objekt selbst

create table "demoadm".numverw
  (
    nmv_nmvid integer not null constraint "demoadm".nmv_con_n_nmvid,
    nmv_uniqname char(40) not null constraint "demoadm".nmv_con_n_uniqname,
    nmv_name char(30) not null constraint "demoadm".nmv_con_n_name,
    nmv_kurz char(5)
      default ' ' not null constraint "demoadm".nmv_con_n_kurz,
    nmv_text varchar(254)
      default '-' not null constraint "demoadm".nmv_con_n_text,
    nmv_user char(8)
      default user not null constraint "demoadm".nmv_con_n_user,
    nmv_time datetime year to second
      default current year to second not null constraint "demoadm".nmv_con_n_time
  ) extent size 184 next size 16 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".nmv_idx_u on "demoadm".numverw (nmv_uniqname);
create unique index "demoadm".nmv_idx_p on "demoadm".numverw (nmv_nmvid);
alter table "demoadm".numverw add constraint unique (nmv_uniqname)
    constraint "demoadm".nmv_con_u  ;
alter table "demoadm".numverw add constraint primary key (nmv_nmvid)
    constraint "demoadm".nmv_con_p  ;

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