SNS Database
changes – Database version 7
Following WRC12 Decisions
New timestamp column called change_ts
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
attch_no |
Integer |
2 |
|
attch_type |
Text |
1 |
|
file_name |
Text |
255 |
Mod |
extension |
Text |
3 |
Del |
text_info |
Text |
255 |
|
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
grp_id |
Long Integer |
4 |
seq_emiss |
Integer |
2 |
seq_no |
Integer |
2 |
freq_carr |
Double |
8 |
change_ts |
Date/Time |
8 |
Name |
Type |
Size |
ntc_id |
Long Integer |
4 |
itu_scraft_id |
Long
Integer |
4 |
seq_no |
Long
Integer |
4 |
reg_st |
Text |
1 |
d_reg_st |
Date/Time |
8 |
rsn_susp |
Text |
255 |
wic_no |
Integer |
2 |
change_ts |
Date/Time |
8 |
Name |
Type |
Size |
ntc_id |
Long Integer |
4 |
itu_scraft_id |
Long
Integer |
4 |
d_reg_st |
Date/Time |
8 |
reg_st |
Text |
1 |
rsn_susp |
Text |
255 |
change_ts |
Date/Time |
8 |
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
seq_no |
Integer |
2 |
|
ntwk_name |
Text |
20 |
|
lsp_name |
Text |
20 |
|
vehicle |
Text |
20 |
|
d_exe |
Date/Time |
8 |
|
d_deliv_fr |
Date/Time |
8 |
|
d_deliv_to |
Date/Time |
8 |
|
facility |
Text |
20 |
|
ctry |
Text |
3 |
delete |
long_deg |
Integer |
2 |
delete |
long_ew |
Text |
1 |
delete |
long_min |
Integer |
2 |
delete |
long_sec |
Integer |
2 |
delete |
lat_deg |
Integer |
2 |
delete |
lat_ns |
Text |
1 |
delete |
lat_min |
Integer |
2 |
delete |
lat_sec |
Integer |
2 |
delete |
mfct_name |
Text |
20 |
|
nbr_sat |
Integer |
2 |
|
d_exe_m |
Date/Time |
8 |
|
d_deliv_fr_m |
Date/Time |
8 |
|
d_deliv_to_m |
Date/Time |
8 |
|
long_dec |
Single |
4 |
delete |
lat_dec |
Single |
4 |
delete |
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
grp_id |
Long Integer |
4 |
diag_type |
Text |
5 |
diag_no |
Integer |
2 |
attch_no |
Integer |
2 |
change_ts |
Date/Time |
8 |
Mask_info
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
add |
mask_id |
Long
Integer |
4 |
|
freq_min |
Double |
8 |
|
freq_max |
Double |
8 |
|
f_mask |
Text |
1 |
|
f_mask_type |
Text |
1 |
|
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
emi_rcp |
Text |
1 |
|
beam_name |
Text |
8 |
|
act_code |
Text |
1 |
|
beam_old |
Text |
8 |
|
bmwdth |
Single |
4 |
|
attch_e |
Integer |
2 |
name
change from diag_e |
attch_e_x |
Integer |
2 |
name
change from diag_e_x |
gain |
Single |
4 |
|
pattern_id |
Integer |
2 |
|
pattern_id_x |
Integer |
2 |
|
ant_diam |
Single |
4 |
|
dgso |
Double |
8 |
add |
attch_crdn |
Integer |
2 |
name
change from diag_crdn |
f_fdg_reqd |
Text |
1 |
|
cmp_ntc_id |
Long
Integer |
4 |
|
cmp_beam |
Text |
8 |
|
f_cmp_str |
Text |
1 |
|
f_cmp_rec |
Text |
1 |
|
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
Action |
grp_id |
Long Integer |
4 |
|
seq_no |
Integer |
2 |
|
stn_name |
Text |
20 |
|
ctry |
Text |
3 |
|
act_code |
Text |
1 |
|
stn_type |
Text |
1 |
|
long_deg |
Integer |
2 |
|
long_ew |
Text |
1 |
|
long_min |
Integer |
2 |
|
long_sec |
Integer |
2 |
|
lat_deg |
Integer |
2 |
|
lat_ns |
Text |
1 |
|
lat_min |
Integer |
2 |
|
lat_sec |
Integer |
2 |
|
noise_t |
Long
Integer |
4 |
|
gain |
Single |
4 |
|
bmwdth |
Single |
4 |
|
attch_e |
Integer |
2 |
add |
attch_e_x |
Integer |
2 |
add |
diag_e |
Integer |
2 |
|
diag_e_x |
Integer |
2 |
|
pattern_id |
Integer |
2 |
|
pattern_id_x |
Integer |
2 |
|
stn_old |
Text |
20 |
|
long_dec |
Single |
4 |
|
lat_dec |
Single |
4 |
|
ant_diam |
Single |
4 |
|
ant_alt |
Integer |
2 |
|
clim_zone |
Text |
1 |
|
rcp_type |
Text |
1 |
|
pwr_max |
Single |
4 |
|
bdwdth_aggr |
Long
Integer |
4 |
|
dgso |
Single |
4 |
add |
f_trp_band |
Text |
1 |
|
f_cmp_rec |
Text |
1 |
|
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
Action |
grp_id |
Long Integer |
4 |
|
seq_no |
Integer |
2 |
|
design_emi |
Text |
9 |
|
pep_max |
Single |
4 |
|
pwr_ds_max |
Single |
4 |
|
pep_min |
Single |
4 |
|
pwr_ds_min |
Single |
4 |
|
c_to_n |
Single |
4 |
|
pwr_ds_nbw |
Single |
4 |
|
pwr_ctrl |
Double |
8 |
|
pulse_length |
Double |
8 |
|
pulse_rep |
Double |
8 |
|
f_emi_type |
Text |
1 |
|
attch_pep |
Integer |
2 |
|
attch_mpd |
Integer |
2 |
|
attch_c2n |
Integer |
2 |
|
pwr_ds_nbc |
Single |
4 |
add |
f_cmp_rec |
Text |
1 |
|
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
stn_name |
Text |
20 |
|
ctry |
Text |
3 |
|
long_deg |
Integer |
2 |
|
long_ew |
Text |
1 |
|
long_min |
Integer |
2 |
|
long_sec |
Integer |
2 |
|
lat_deg |
Integer |
2 |
|
lat_ns |
Text |
1 |
|
lat_min |
Integer |
2 |
|
lat_sec |
Integer |
2 |
|
sat_name |
Text |
20 |
|
long_nom |
Single |
4 |
|
attch_hor |
Integer |
2 |
name
change from diag_hor |
elev_min |
Single |
4 |
|
elev_max |
Single |
4 |
|
azm_fr |
Single |
4 |
|
azm_to |
Single |
4 |
|
ant_alt |
Long
Integer |
4 |
|
f_active |
Text |
1 |
|
long_dec |
Single |
4 |
|
lat_dec |
Single |
4 |
|
f_pfd_se |
Text |
1 |
|
change_ts |
Date/Time |
8 |
|
Name |
Type |
Size |
Action |
grp_id |
Long Integer |
4 |
|
seq_no |
Integer |
2 |
|
pub_ref |
Text |
12 |
|
pub_no |
Integer |
2 |
|
ssn_type |
Text |
1 |
|
ssn_rev |
Text |
1 |
|
ssn_rev_no |
Integer |
2 |
|
wic_no |
Long
Integer |
4 |
add |
d_wic |
Date/Time |
8 |
add |
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
Action |
grp_id |
Long Integer |
4 |
|
ntc_id |
Long
Integer |
4 |
|
emi_rcp |
Text |
1 |
|
beam_name |
Text |
8 |
|
sr_type |
Text |
1 |
|
page_no |
Integer |
2 |
|
act_code |
Text |
1 |
|
adm_resp |
Text |
2 |
|
bdwdth |
Long
Integer |
4 |
|
d_inuse |
Date/Time |
8 |
|
noise_t |
Long
Integer |
4 |
|
op_agcy |
Integer |
2 |
|
polar_type |
Text |
2 |
|
polar_ang |
Single |
4 |
|
prd_valid |
Integer |
2 |
|
diag_area |
Integer |
2 |
delete |
diag_spect |
Integer |
2 |
delete |
attch_mux |
Integer |
2 |
delete |
attch_reg |
Integer |
2 |
delete |
remark |
Text |
30 |
|
tgt_grp_id |
Long
Integer |
4 |
|
pwr_max |
Single |
4 |
|
bdwdth_aggr |
Long
Integer |
4 |
|
f_trp_band |
Text |
1 |
|
area_no |
Integer |
2 |
|
observ_cls |
Text |
2 |
|
reg_op_fr |
Long
Integer |
4 |
|
reg_op_to |
Long
Integer |
4 |
|
d_upd |
Date/Time |
8 |
|
st_cur |
Text |
2 |
|
d_st_cur |
Date/Time |
8 |
|
wic_no |
Integer |
2 |
|
wic_part |
Text |
1 |
|
d_wic |
Date/Time |
8 |
|
d_prot_eff |
Date/Time |
8 |
|
fdg_reg |
Text |
2 |
|
fdg_plan |
Text |
2 |
|
fdg_tex |
Text |
2 |
|
fdg_observ |
Text |
4 |
|
spl_grp_id |
Long
Integer |
4 |
|
comment |
Text |
30 |
|
area_name |
Text |
20 |
|
elev_min |
Single |
4 |
|
gso_sep |
Single |
4 |
|
prov |
Text |
12 |
|
srv_code |
Text |
6 |
|
freq_min |
Double |
8 |
|
freq_max |
Double |
8 |
|
f_no_intfr |
Text |
1 |
|
f_ap30b_art6 |
Text |
1 |
|
plan_categ |
Text |
4 |
|
plan_status |
Text |
4 |
|
pfd_pk_7g |
Single |
4 |
|
d_rcv |
Date/Time |
8 |
|
d_rcv_start |
Date/Time |
8 |
Add |
d_reg_limit |
Date/Time |
8 |
Add |
st_biu |
Text |
1 |
Add |
Text |
1 |
|
|
ra_stn_type |
Text |
1 |
|
eirp_nom |
Single |
4 |
|
sensitivity |
Single |
4 |
|
f_fdg_reqd |
Text |
1 |
|
cmp_grp_id |
Long
Integer |
4 |
|
f_cost_rec |
Text |
1 |
|
f_cmp_str |
Text |
1 |
|
f_cmp_rec |
Text |
1 |
|
f_cmp_freq |
Text |
1 |
|
f_cmp_emi |
Text |
1 |
|
f_cmp_eas |
Text |
1 |
|
f_cmp_prov |
Text |
1 |
|
f_cmp_sas |
Text |
1 |
|
f_cmp_gpub |
Text |
1 |
|
f_cmp_fdg |
Text |
1 |
|
change_ts |
Date/Time |
8 |
Add |
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
sat_name |
Text |
20 |
|
ref_body |
Text |
1 |
|
nbr_sat_nh |
Integer |
2 |
|
nbr_sat_sh |
Integer |
2 |
|
nbr_plane |
Integer |
2 |
|
nbr_sat_td |
Integer |
2 |
|
density |
Double |
8 |
Change
format |
avg_dist |
Single |
4 |
|
f_x_zone |
Text |
1 |
|
x_zone |
Single |
4 |
|
f_epfd |
Text |
1 |
|
f_active |
Text |
1 |
|
attch_x_zone |
Integer |
2 |
|
f_pfd_lim |
Text |
1 |
|
change_ts |
Date/Time |
8 |
|
Name |
Type |
Size |
|
ntc_id |
Long Integer |
4 |
|
ntc_type |
Text |
1 |
|
adm_ref_id |
Text |
20 |
|
d_adm |
Date/Time |
8 |
|
prov |
Text |
12 |
|
act_code |
Text |
1 |
|
adm |
Text |
3 |
|
ntwk_org |
Text |
3 |
|
ntf_occurs |
Text |
1 |
|
tgt_ntc_id |
Long
Integer |
4 |
|
d_rcv |
Date/Time |
8 |
|
wic_no |
Integer |
2 |
|
wic_part |
Text |
1 |
|
d_wic |
Date/Time |
8 |
|
d_upd |
Date/Time |
8 |
|
f_basic |
Text |
1 |
|
f_int_ext |
Text |
1 |
|
ntf_rsn |
Text |
1 |
|
st_cur |
Text |
2 |
|
d_st_cur |
Date/Time |
8 |
|
st_prv |
Text |
2 |
|
f_spl |
Text |
1 |
|
spl_ntc_id |
Long
Integer |
4 |
|
plan_id |
Text |
5 |
|
ntwk_pack |
Text |
4 |
|
f_mod_type |
Text |
1 |
|
f_aa_type |
Text |
1 |
|
f_adm_proxi |
Text |
1 |
|
f_rs46 |
Text |
1 |
delete |
f_val_cat |
Text |
1 |
|
cmp_ntc_id |
Long
Integer |
4 |
|
f_cmp_str |
Text |
1 |
|
f_cmp_rec |
Text |
1 |
|
f_cmp_orb |
Text |
1 |
|
f_cmp_strp |
Text |
1 |
|
f_cmp_ngma |
Text |
1 |
|
f_cmp_hori |
Text |
1 |
|
f_cmp_elev |
Text |
1 |
|
f_cmp_pfd |
Text |
1 |
|
f_cmp_oper |
Text |
1 |
|
f_cfex |
Text |
1 |
|
f_val |
Text |
1 |
|
f_mod |
Text |
1 |
|
f_aes_char |
Text |
1 |
|
prov_desc |
Text |
50 |
add |
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
orb_id |
Integer |
2 |
|
nbr_sat_pl |
Integer |
2 |
|
right_asc |
Single |
4 |
|
inclin_ang |
Single |
4 |
|
prd_ddd |
Integer |
2 |
|
prd_hh |
Integer |
2 |
|
prd_mm |
Integer |
2 |
|
apog |
Double |
8 |
|
apog_exp |
Integer |
2 |
|
perig |
Double |
8 |
|
perig_exp |
Integer |
2 |
|
perig_arg |
Single |
4 |
|
op_ht |
Double |
8 |
Change format |
op_ht_exp |
Integer |
2 |
|
f_stn_keep |
Text |
1 |
|
rpt_prd_dd |
Integer |
2 |
|
rpt_prd_hh |
Integer |
2 |
|
rpt_prd_mm |
Integer |
2 |
|
rpt_prd_ss |
Integer |
2 |
|
f_precess |
Text |
1 |
|
precession |
Single |
4 |
|
long_asc |
Single |
4 |
|
keep_rnge |
Single |
4 |
|
f_cmp_rec |
Text |
1 |
|
f_cmp_pha |
Text |
1 |
|
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
emi_rcp |
Text |
1 |
|
beam_name |
Text |
8 |
|
f_steer |
Text |
1 |
|
sr_type |
Text |
1 |
|
act_code |
Text |
1 |
|
ang_alpha |
Single |
4 |
|
ang_beta |
Single |
4 |
|
attch_alpha_beta |
Integer |
2 |
add |
beam_old |
Text |
8 |
|
attch_e |
Integer |
2 |
name
change from diag_e |
attch_e_x |
Integer |
2 |
name
change from diag_e_x |
attch_elev |
Integer |
2 |
name
change from diag_elev |
attch_gain |
Integer |
2 |
name
change from diag_gain |
attch_orb_e |
Integer |
2 |
name
change from diag_orb_e |
pattern_id |
Integer |
2 |
|
pattern_id_x |
Integer |
2 |
|
gain |
Single |
4 |
|
attch_loss |
Integer |
2 |
name
change from loss_attch |
pnt_acc |
Single |
4 |
|
pwr_max_4k |
Single |
4 |
|
pwr_avg_4k |
Single |
4 |
|
pwr_max_1m |
Single |
4 |
|
pwr_avg_1m |
Single |
4 |
|
beamlet |
Single |
4 |
|
bore_long |
Single |
4 |
|
bore_lat |
Single |
4 |
|
maj_axis |
Single |
4 |
|
min_axis |
Single |
4 |
|
orient |
Single |
4 |
|
rot_acc |
Single |
4 |
|
gain_x |
Single |
4 |
|
prot_ratio |
Single |
4 |
|
attch_gain_x |
Integer |
2 |
name
change from diag_gainx |
freq_min |
Double |
8 |
|
freq_max |
Double |
8 |
|
f_fdg_reqd |
Text |
1 |
|
f_tx_vis |
Text |
1 |
add |
tx_ang_min |
Single |
4 |
add |
cmp_ntc_id |
Long
Integer |
4 |
|
cmp_beam |
Text |
8 |
|
f_cmp_str |
Text |
1 |
|
f_cmp_rec |
Text |
1 |
|
change_ts |
Date/Time |
8 |
add |
Name |
Type |
Size |
itu_scraft_id |
Long Integer |
4 |
seq_no |
Long
Integer |
4 |
freq_min |
Double |
8 |
freq_max |
Double |
8 |
freq_ sym |
Text |
1 |
change_ts |
Date/Time |
8 |
Name |
Type |
Size |
itu_scraft_id |
Long Integer |
4 |
ntwk_name |
Text |
20 |
lsp_name |
Text |
20 |
vehicle |
Text |
20 |
d_exe |
Date/Time |
8 |
facility |
Text |
20 |
mfct_name |
Text |
20 |
nbr_sat |
Integer |
2 |
d_exe_m |
Date/Time |
8 |
d_deliv |
Date/Time |
8 |
d_launch |
Date/Time |
8 |
change_ts |
Date/Time |
8 |
Name |
Type |
Size |
Action |
ntc_id |
Long Integer |
4 |
|
coord_prov |
Text |
12 |
|
agree_st |
Text |
1 |
|
aff_ntc_id |
Long Integer |
4 |
|
adm |
Text |
3 |
|
ntwk_org |
Text |
3 |
|
ctry |
Text |
3 |
|
sat_name |
Text |
20 |
|
long_nom |
Single |
4 |
|
ntf_rsn |
Text |
1 |
|
coord_st |
Text |
1 |
|
st_aff |
Text |
2 |
|
f_cause |
Text |
1 |
|
f_rec |
Text |
1 |
|
d_prot_inc |
Date/Time |
8 |
add |
wic_no |
Integer |
2 |
add |
change_ts |
Date/Time |
8 |
add |
table in sns |
table in spacerefdb |
adm_addr |
not used |
adm_info |
rf_adm |
agency |
rf_op_agcy |
channels |
rf_channels |
charact |
rf_charact |
clscode |
rf_srv_cls |
country |
rf_ctry |
facility |
rf_facility |
natsrv |
rf_nat_srv |
satsys |
rf_sat_org |
st_queue |
rf_status |
vehicle |
rf_vehicle |