schema default values
Posted in 1994
Topics: Security, Permissions & Auditing
hey mike this is the table that I was talking to you about.
create table lhaa
(
esn char(15) not null,
stk_item_cd char(1) default " ",
gen_nomen char(64) default " ",
nsn_nomen char(21) default " ",
lin char(6) default " ",
ecc char(2) default " ",
pec char(12) default " ",
ui char(2) default " ",
cmc char(1) default " ",
army_cd char(1) default " ",
svc_cd char(1) default " ",
cic char(1) default " ",
clbr_cd char(1) default " ",
tamms_cd char(1) default " ",
dodsasp_cd char(1) default " ",
seri_cd char(1) default " ",
av_cd char(1) default " ",
tmde_cd char(1) default " ",
pb_mgt_cd char(1) default " ",
arc char(1) default " ",
rec_cd char(1) default " ",
sp_it_cd char(1) default " ",
ciic char(1) default " ",
sp_rqmt_cd char(1) default " ",
ricc char(1) default " ",
prev_esn char(15) default " ",
yrs_svc_life smallint default 0,
ciic_oth char(1) default " ",
suppl_fsc char(4) default " ",
loc_use char(10) default " ",
ty_util char(1) default " ",
min_pct_util smallint default 0,
obj_pct_util smallint default 0,
mh_life integer default 0,
metric_cd char(1) default "A",
adpe_cl_cd char(2) default "AA"
);
revoke all on lhaa from "public";
create unique index aa_index on lhaa (esn);
create index aa_lin on lhaa (lin);
bill