GRID_ERD

Tables (11)

ed_bul_am_100

  • id — serial — Primary key — NOT NULL
  • grid_geom (격자 공간정보) — geometry — NOT NULL
  • grid_cd (격자 코드) — varchar(200) — NOT NULL
  • bd_mgt_sn (기준컬럼) — varchar(25) — NOT NULL
  • value (값) — float8 — NOT NULL
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

origin_jeju_bus (원시데이터_버스정류장)

  • fid — serial — Primary key — NOT NULL
  • the_geom (공간정보) — geometry(POINT, 5174)
  • NODE_ID (공간정보id) — varchar(254)
  • NODE_NM (공간정보 지역명) — varchar(254)
  • GPS_LATI (위도) — float8
  • GPS_LONG (경도) — float8
  • COLLECTD_T (갱신일자) — timestamp
  • CITY_CODE (지역코드) — int4
  • CITY_NAME (지역명) — varchar(254)
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

sd_b_sgg (기준데이터(법정동))

  • fid — serial — Primary key — NOT NULL
  • the_geom (공간정보) — geometry(MULTIPOLYGON, 5179)
  • SGG_CD — varchar(254)
  • SGG_NM — varchar(254)
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

sd_b_sido (시도(법정동))

  • fid — serial — Primary key — NOT NULL
  • the_geom — geometry(MULTIPOLYGON, 5179)
  • SIDO_CD (시도코드) — varchar(254)
  • SIDO_NM (시도명) — varchar(254)
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

sd_b_umd (읍면동(법정동))

  • fid — serial — Primary key — NOT NULL
  • the_geom (공간정보) — geometry(MULTIPOLYGON, 5179)
  • EMD_CD (읍면동코드) — varchar(254)
  • EMD_NM (읍면동명) — varchar(254)
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

sd_h_sgg (시군구(행정동))

  • fid — serial — Primary key — NOT NULL
  • the_geom (공간정보) — geometry(MULTIPOLYGON, 5174)
  • BASE_DATE (갱신일자) — varchar(8)
  • SGG_CD (시군구코드) — varchar(2)
  • SGG_NM (시군구명) — varchar(50)
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

sd_h_sido (시도(행정동))

  • fid — serial — Primary key — NOT NULL
  • the_geom (공간정보) — geometry(MULTIPOLYGON, 5174)
  • BASE_DATE (갱신일자) — varchar(8)
  • SIDO_CD (시도코드) — varchar(2)
  • SIDO_NM (시도명) — varchar(50)
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

sd_h_umd (읍면동(행정동))

  • fid — serial — Primary key — NOT NULL
  • the_geom (공간정보) — geometry(MULTIPOLYGON, 5174)
  • BASE_DATE (갱신일자) — varchar(8)
  • EMD_CD (읍면동코드) — varchar(2)
  • EMD_NM (시군구명) — varchar(50)
  • uuid — varchar(300) — Foreign key → tb_upload_file_meta.uuid — NOT NULL

tb_conditions (조건테이블)

  • no — serial — Primary key — NOT NULL
  • origin_data (원시데이터명) — varchar(200) — NOT NULL
  • anal_area (분석지역) — varchar(200) — NOT NULL
  • anal_field (분석코드) — varchar(200) — NOT NULL
  • grid_size (격자크기) — varchar — NOT NULL
  • anal_area_unit (분석지역단위) — varchar(200) — NOT NULL
  • anal_mapping (매핑방법) — varchar(200) — NOT NULL
  • start_date (분석시작날짜) — timestamp
  • end_date (분석종료날짜) — timestamp
  • status (상태코드) — int4 — NOT NULL
  • table_name (결과테이블명) — varchar(100) — NOT NULL
  • comment (설명) — text
  • json_data — text — NOT NULL
  • anal_area_stand (지역선택기준) — varchar — NOT NULL
  • user_id (사용자ID) — varchar(100) — NOT NULL
  • title (제목) — varchar(200) — NOT NULL

tb_mapping (매핑코드)

  • no — serial — Primary key — NOT NULL
  • mapping_code (매핑코드) — varchar(200) — NOT NULL
  • mapping_type (매핑타입) — varchar(200) — NOT NULL
  • mapping_name (매핑이름) — varchar(100)

tb_upload_file_meta (파일메타정보)

  • uuid — varchar(300) — Primary key — NOT NULL
  • file_name (업로드파일이름) — varchar(300) — NOT NULL
  • full_path (임시경로) — varchar(1000)
  • table_name (테이블이름) — varchar(300) — NOT NULL
  • geo_type (지오메트리타입) — varchar(100) — NOT NULL
  • upload_date (업로드일자) — timestamp(0) — NOT NULL
  • file_type (파일형식) — varchar