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)