SNS Database changes Database version 7

Following WRC12 Decisions

 

All Notice processing Tables

New timestamp column called change_ts

Attch

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

 

Carrier_fr new table

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

 

Cmr_history new table

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

 

Cmr_notice new table

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

 

 

Cmr_syst

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

 

 

Diag_grp new table

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

 

 

E_ant

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

 

E_as_stn

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

 

emiss

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

 

E_stn

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

 

 

 

gpub

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

 

 

Grp

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

 

Non_geo

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

 

 

Notice

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

 

Orbit

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

 

S_beam

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

Scraft cmr_freq new table

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

 

Scraft_cmr_syst new table

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

 

Tr_aff_ntw - remove primary keys

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

 

Deleted Reference tables which are also in spacerefdb.mdb

 

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