RDB_data
Tables (12)
agg
- id — bigserial
- agg_id — text — NOT NULL
- ip — text
- sys_grade_code — text
- model_nm — text
- cust_cnt — integer
- cus_rtp_cnt — integer
- cus_nse_cnt — integer
- is_fault_rtp — boolean
- is_fault_nse — boolean
- in_cnt — integer
- out_cnt — integer
ap
- id — bigserial
- ap_id — text — NOT NULL
- customer_id — text — Foreign key → customer.customer_id
- home_id — text
- intr_type — text
- ap_mac_addr — text
- ap_model_nm — text
- ont_mac_addr — text
- ont_model_nm — text
- cm_mac_addr — text
- cm_model_nm — text
- is_fault_rtp — boolean
- is_fault_nse — boolean
- in_cnt — integer
- last_log_time — timestamp
- Key — Foreign key → customer.Key — NOT NULL
apt
- id — bigserial
- apt_id — text — NOT NULL
- ip — text
- sys_grade_code — text
- model_nm — text
- cust_cnt — integer
- cus_rtp_cnt — integer
- cus_nse_cnt — integer
- is_fault_rtp — boolean
- is_fault_nse — boolean
- in_cnt — integer
- out_cnt — integer
customer
- Key — Primary key — NOT NULL
- id — bigserial
- customer_id — text — NOT NULL
- is_fault_rtp — boolean
- is_fault_nse — boolean
- in_cnt — integer
- out_cnt — integer
- Field
device
- id — bigserial
- device_id — text — NOT NULL
- ip — text
- sys_grade_code — text
- model_nm — text
- cust_cnt — integer
- cus_rtp_cnt — integer
- cus_nse_cnt — integer
- is_fault_rtp — boolean
- is_fault_nse — boolean
- in_cnt — integer
- out_cnt — integer
fixed_hm_profile_db_03d
- cust_no — text
- homecd_no — text
- entr_no_intr — text
- entr_no_all — text
- prod_cd — text
- intr_type — text
- stb_mac_addr — text
- stb_model_nm — text
- ap_mac_addr — text
- ap_model_nm — text
- ont_mac_addr — text
- ont_model_nm — text
- cm_mac_addr — text
- cm_model_nm — text
- l2_sys_id — text
- l2_ip_addr — text
- apt_l3_olt_sys_id — text
- apt_l3_olt_ip_addr — text
- apt_l3_olt_model_nm — text
- apt_l3_olt_down_port — text
- agg_l3_olt_sys_id — text
- agg_l3_olt_ip_addr — text
- agg_l3_olt_model_nm — text
- agg_l3_olt_down_port — text
- rn_id — text
- rn_nm — text
- daily_partition — text
fixed_ip_topology
- ctime — text
- d1_device_id — text
- d1_dev_name — text
- d1_dev_ip — text
- d1_sysgrade_code — text
- d1_if_name — text
- d2_device_id — text
- d2_dev_name — text
- d2_dev_ip — text
- d2_sysgrade_code — text
- d2_if_name — text
- hourly_partition — text
l0_qms_cc_hsd_03d_a
- ctime — text
- firstlogtime — text
- lastlogtime — text
- cust_num — text
- model_mac — text
- stb_rtp_errcnt — text
- no_stream_error — text
- logtime — text
- homecd_no — text
- hourly_partition — text
l2
- id — bigserial
- l2_id — text — NOT NULL
- ip — text
- sys_grade_code — text
- cus_rtp_cnt — integer
- cus_nse_cnt — integer
- is_fault_rtp — boolean
- is_fault_nse — boolean
- in_cnt — integer
- out_cnt — integer
rn
- id — bigserial
- rn_id — text — NOT NULL
- nm — text
- cus_rtp_cnt — integer
- cus_nse_cnt — integer
- is_fault_rtp — boolean
- is_fault_nse — boolean
- in_cnt — integer
- out_cnt — integer
srch_swrk_m_fnsh_eqip
- work_trgt_id — text
- swrk_id — text
- swrk_ffil_strt_dttm — text
- swrk_ffil_end_dttm — text
- hourly_partition — text
stb
- id — bigserial
- stb_id — text — NOT NULL
- customer_id — text — Foreign key → customer.customer_id
- home_id — text
- ap_id — text — Foreign key → ap.ap_id
- stb_mac_addr — text
- stb_model_nm — text
- stb_rtp_errcnt — integer
- is_fault_rtp — boolean
- no_stream_error — integer
- is_fault_nse — boolean
- last_log_time — timestamp
- Key — Foreign key → customer.Key — NOT NULL