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