20240507_PMS
Tables (10)
PMS_10_POSITION (포장상태-좌표)
- id — int4 — Primary key — NOT NULL — nextval('auto_increment_pp_seq'::regclass)
- geom (좌표) — geometry(polygonz, 5186) — NOT NULL
- pk_key (Field) — varchar(30) — NOT NULL — FK
- cell_id (Field2) — varchar(30) — NOT NULL — FK
- trace_la (위도) — float8 — NOT NULL
- trace_lo (경도) — float8 — NOT NULL
- endpt (거리) — int4 — NOT NULL
PMS_CARE_LIST (보수대상 TABLE)
- id — serial4 — Primary key — NOT NULL — nextval('pms_pk_10_status_id_seq'::regclass)
- pk_key (Field) — varchar(30)
- srvy_y (년) — varchar(10)
- srvy_m (월) — varchar(10)
- srvy_d (일) — varvhar(10)
- route_00 (Field34) — varchar(30)
- route_01 (Field35) — varchar(30)
- route_02 (Field37) — varchar(30)
- route_03 (Field36) — varchar(30)
- direct (행선) — ud_eum — [ 'E', 'S']
- lane (차로) — int4
- strtpt (시점) — int4
- endpt (종점) — int4
- length (길이) — int4
- area (영역) — int4
- start_adr (시점 주소) — varchar
- end_adr (종점 주소) — varchar
- local_code (지역 코드) — varchar(35)
- road_level_code (도로등급 코드) — int8
- reg_date (등록 날짜) — date
- reg_name (등록자) — varchar(15)
- start_id (시점 ID) — varchar
- end_id (종점 ID) — varchar
- budget (Field2) — float4
- pci (포장상태지수) — float4
- cr (균열률) — float4
- iri (종단평탄성) — float4
- rut (소성변형) — float4
- dept (Field33) — varchar(50)
- facil_code (Field32) — varchar(50)
- start_la (시점 위도) — float8
- start_lo (시점 경도) — float8
- end_la (종점 위도) — float8
- end_lo (종점 경도) — float8
- srvy_ve (Field3) — float4
- lcr_l (Field4) — float4
- lcr_m (Field5) — float4
- lcr_h (Field10) — float4
- lcr_sum (Field6) — float4
- tcr_l (Field7) — float4
- tcr_m (Field8) — float4
- tcr_h (Field9) — float4
- tcr_sum (Field11) — float4
- cjcr_l (Field12) — float4
- cjcr_m (Field13) — float4
- cjcr_h (Field14) — float4
- cjcr_sum (Field15) — float4
- acr_l (Field16) — float4
- acr_m (Field17) — float4
- acr_h (Field18) — float4
- acr_sum (Field19) — float4
- patch_l (Field20) — float4
- patch_m (Field21) — float4
- patch_h (Field22) — float4
- patch_sum (Field23) — float4
- pot_l (Field24) — float4
- pot_m (Field25) — float4
- pot_h (Field26) — float4
- pot_sum (Field27) — float4
- etc_l (Field28) — float4
- … +5
PMS_COM_RANK (도로구분)
- road_level_code (도로 구분 코드) — int8 — NOT NULL
- road_level (도로 구분 명칭) — varchar(20) — NOT NULL
- road_level_type (도로 구분 타입) — varchar(20)
PMS_DEFECT_TRANSITION (결함 정보 공법 범례)
- id — Primary key — NOT NULL — nextval('auto_increment_pdt_seq'::regclass)
- statname (항목 명칭) — varchar(15)
- method (범위) — varchar(50)
- transition (범위 기준 점수) — float4
- local_code (지역 코드) — varchar(35)
PMS_EACH_DEFECT_TRANSITION (결함 세부 정보 공법 범례)
- id — int4 — Primary key — NOT NULL — nextval('auto_increment_pedt_seq'::regclass)
- exponent (json 범례) — jsonb
- local_code (지역 코드) — varchar(35)
PMS_EX_HISTORY (엑셀 등록 이력)
- id — int4 — Primary key — NOT NULL — nextval('auto_increment_ex_seq'::regclass)
- ex_nm (엑셀 파일명) — varchar — NOT NULL
- reg_name (등록자) — varchar(35) — NOT NULL
- reg_date (등록 일자) — varchar — NOT NULL
- local_code (지역 코드) — varchar(35) — NOT NULL
- menu_name (메뉴 명칭) — varchar(35) — NOT NULL — 포장 / 보수 / 유지
PMS_MAINTENANCE_HISTORY (유지보수 이력 정보)
- id — serial4 — Primary key — NOT NULL — nextval('pms_pk_10_status_id_seq'::regclass)
- mtn_y (년) — varchar(10)
- mtn_m (월) — varchar(10)
- mtn_d (일) — varvhar(10)
- road_level (도로등급) — varchar(50)
- road_level_code (도로등급 코드) — int8
- dept (Field33) — varchar(50)
- route_00 (Field34) — varchar(30)
- route_01 (Field35) — varchar(30)
- route_02 (Field36) — varchar(30)
- route_03 (Field37) — varchar(30)
- facil_code (Field32) — varchar(50)
- direct (행선) — ud_eum — [ 'E', 'S']
- lane (차로) — int4
- strtpt (시점) — int4
- endpt (종점) — int4
- pk_key (Field) — varchar(30)
- start_id (시점 ID) — varchar
- end_id (종점 ID) — varchar
- start_adr (시점 주소) — varchar
- end_adr (종점 주소) — varchar
- width (면적) — float4
- length (길이) — float4
- area (영역) — float4
- cost (비용) — float4
- plant (Field38) — varchar
- mtn_const (Field39) — varchar
- start_day (시작 일) — varchar(35)
- end_day (종료 일) — varchar(35)
- thick_sur (Field4) — float4
- thick_mid (Field5) — float4
- thick_base (Field6) — float4
- thick_sum (Field7) — float4
- mat_sur (Field8) — varchar(25)
- mat_mid (Field9) — varchar(25)
- mat_base (Field10) — varchar(25)
- info (비고) — varchar
- local_code (지역 코드) — varchar(35)
- ex_nm (excel파일 명) — varchar
- reg_name (등록 날짜) — varchar(35)
PMS_MAINT_INITIAL (유지보수 이력 초기값)
- id — Primary key — NOT NULL — nextval('auto_increment_pmi_seq'::regclass)
- cr (균열률) — float4
- rut (소성변형) — float4
- iri (종단평탄성) — float4
- pci (포장상태지수) — float4
- local_code (지역 코드) — varchar(35)
- srvy_y (년도) — varchar(10)
- srvy_m (월) — varchar(10)
PMS_MANAGE_BOUNDARY (지역 경계선)
- id — int4 — Primary key — NOT NULL — nextval('auto_increment_pmb'::regclass)
- local_code (지역 코드) — varchar(35) — NOT NULL — FK
- bound_name (지역 명칭) — varchar(30) — NOT NULL
- geom (좌표) — geometry( linestring, 5186) — NOT NULL
PMS_PK_10_STATUS (포장상태 10M 정보 TABLE)
- id — serial4 — Primary key — NOT NULL — nextval('pms_pk_10_status_id_seq'::regclass)
- pk_key (Field) — varchar(30)
- cr (균열률) — float4
- rut (소성변형) — float4
- iri (종단평탄성) — float4
- pci (포장상태지수) — float4
- surface_img (노면 이미지) — varchar
- front_img (전방 이미지) — varchar
- trace_la (위도) — float8
- trace_lo (경도) — float8
- cell_id (Field2) — varchar(30)
- strtpt (시점) — int4
- endpt (종점) — int4
- width (면적) — float4
- area (영역) — float4
- srvy_ve (Field3) — float4
- lcr_l (Field4) — float4
- lcr_m (Field5) — float4
- lcr_h (Field10) — float4
- lcr_sum (Field6) — float4
- tcr_l (Field7) — float4
- tcr_m (Field8) — float4
- tcr_h (Field9) — float4
- tcr_sum (Field11) — float4
- cjcr_l (Field12) — float4
- cjcr_m (Field13) — float4
- cjcr_h (Field14) — float4
- cjcr_sum (Field15) — float4
- acr_l (Field16) — float4
- acr_m (Field17) — float4
- acr_h (Field18) — float4
- acr_sum (Field19) — float4
- patch_l (Field20) — float4
- patch_m (Field21) — float4
- patch_h (Field22) — float4
- patch_sum (Field23) — float4
- pot_l (Field24) — float4
- pot_m (Field25) — float4
- pot_h (Field26) — float4
- pot_sum (Field27) — float4
- etc_l (Field28) — float4
- etc_m (Field29) — float4
- etc_h (Field30) — float4
- etc_sum (Field31) — float4
- info (비고) — varchar
- srvy_y (년) — varchar(10)
- srvy_m (월) — varchar(10)
- srvy_d (일) — varvhar(10)
- road_level (도로등급) — varchar(50)
- road_level_code (도로등급 코드) — int8
- facil_code (Field32) — varchar(50)
- direct (행선) — ud_eum — [ 'E', 'S']
- lane (차로) — int4
- local_code (지역 코드) — varchar(35)
- ex_nm (excel파일 명) — varchar
- reg_name (등록 날짜) — varchar(35)
- dept (Field33) — varchar(50)
- route_00 (Field34) — varchar(30)
- route_01 (Field35) — varchar(30)
- route_02 (Field36) — varchar(30)
- … +1