ttest
Tables (11)
tb_admin_upload
- upload_id — serial — NOT NULL
- upload_type — varchar(20)
- upload_yn — bool — NOT NULL
- upload_de — timestamp
- create_upload_de — date
- upload_skip_yn — bool — NOT NULL
- upload_path — varchar(255)
- user_id — varchar(30)
tb_asf_danger_m
- dagner_id — int8
- tb_region_id — varchar(10) — NOT NULL
- danger_year — int8 — NOT NULL
- danger_month — int8 — NOT NULL
- risk1 — numeric(6,4)
- risk2 — numeric(6,4)
- risk3 — float8
- risk_all — float8
tb_asf_outbreak_density_m_bak
- asf_outbreak_density_id — serial — Primary key — NOT NULL
- asf_outbreak_density_year — int4
- asf_outbreak_density_month — int4
- asf_outbreak_density — numeric(6,4)
- tb_region_id — varchar(10)
tb_asf_outbreak_m
- outbreak_logt — float8
- outbreak_lat — float8
- tb_region_id — text — NOT NULL
- outbreak_year — int8 — NOT NULL
- outbreak_month — int8 — NOT NULL
- outbreak_cnt — int8
tb_hunter
- hunter_year — float8
- hunter_month — float8
- hunter_member_cnt — float8
- hunter_insert_member_cnt — float8
- tb_region_id — text
tb_pig_data_density_m_bak
- pig_density_id — serial — Primary key — NOT NULL
- year — int4
- month — int4
- density — numeric(6,4)
- tb_region_id — varchar(10)
tb_pig_data_m
- pig_data_id — serial — Primary key — NOT NULL
- farm_nm — varchar(20)
- pig_data_lat — numeric(16,13)
- pig_data_logt — numeric(16,13)
- pig_data_bread_cnt — int4
- tb_region_id — varchar(10)
- pig_year — int4
- year_half_cd — int4
tb_raw_data_d
- raw_id — serial — Primary key — NOT NULL
- capture_cnt — int4
- sample_taek_cnt — int4
- capture_de — date
- collecting_de — date
- request_de — date
- collecting_org — varchar(20)
- request_org — varchar(20)
- sido_nm — varchar(3)
- sgg_nm — varchar(10)
- emd_nm — varchar(10)
- dl_nm — varchar(10)
- discovery_place — varchar(20)
- gps_api_yn — int4
- lat — numeric(16,13)
- logt — numeric(16,13)
- bruial_site — varchar(20)
- border_classification — varchar(15)
- area_devision — varchar(15)
- military_base — varchar(15)
- boar_type — varchar(10)
- carcass_classification — varchar(10)
- sample — varchar(10)
- other_sample — varchar(10)
- weight — int4
- office_tn — varchar(15)
- inspection_agency — varchar(20)
- inspection_completion_de — date
- antigen_result — varchar(10)
- antibody_result — varchar(10)
- remark — text
tb_region_c
- region_id — varchar(10) — Primary key — NOT NULL
- sgg_nm — varchar(10)
- sgg_cd — varchar(5)
- emd_nm — varchar(10)
- emd_cd — varchar(5)
- dl_nm — varchar(10)
- dl_cd — varchar(5)
- geo — portal.geometry
- sido_nm — varchar(10)
- sido_cd — varchar(5)
tb_wildboar_captured
- capture_year — int8 — NOT NULL
- capture_month — int8 — NOT NULL
- capture_cnt — int8
- capture_lat — float8
- capture_logt — float8
- mountains_lat — float8
- mountains_logt — float8
- tb_region_id — text — NOT NULL
tb_wildboar_density
- density_id — serial — Primary key — NOT NULL
- density_year — int4
- density — numeric(6,4)
- tb_region_id — varchar(10)