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