GRM-26-AN1 - 시설관리 (물리-실제FK·DB구분없음)
테이블 (15)
DEPT_INFO
- DEPT_CD — VARCHAR2(50) — 기본 키 — NOT NULL — 부서코드
- UP_DEPT_CD — VARCHAR2(50) — 상위부서코드
- DEPT_NM — VARCHAR2(100) — NOT NULL — 부서명
- DEPT_LEVEL — NUMBER(2,0) — NOT NULL — 부서수준
- SORT_CRTR — NUMBER(10,0) — NOT NULL — 정렬기준
- USE_YN — CHAR(1) — NOT NULL — 사용여부
- DEPT_EXPLN — VARCHAR2(500) — 부서설명
- REG_DT — TIMESTAMP (6) — NOT NULL — 등록일시
- REG_USER_ID — VARCHAR2(50) — NOT NULL — 등록사용자아이디
- UPDT_DT — TIMESTAMP (6) — 갱신일시
- UPDT_USER_ID — VARCHAR2(50) — 갱신사용자아이디
- KID — NUMBER — NOT NULL — 인덱스아이디
- DEL_YN — CHAR(1) — NOT NULL — 삭제여부
RLWY_DTL_INFO
- RLWY_DTL_ID — NUMBER — 기본 키 — NOT NULL — 선로상세아이디
- ORGNL_LYR — VARCHAR2(40) — NOT NULL — 원본계층
- ORGNL_OBJT_ID — NUMBER(19,0) — NOT NULL — 원본객체아이디
- RLWY_CD — VARCHAR2(50) — 선로코드
- RLWY_NM — VARCHAR2(200) — 선로명
- BGNG_STAN_NM — VARCHAR2(200) — 시작역명
- END_STATN_NM — VARCHAR2(200) — 종료역명
- RLWY_TYPE_CD — VARCHAR2(30) — 선로유형코드
- TRACK_TYPE_CD — VARCHAR2(30) — 궤도유형코드
- OPER_STTS_CD — VARCHAR2(30) — 운영상태코드
- MNG_PIC_NM — VARCHAR2(100) — 관리담당자명
- EXPLN — VARCHAR2(2000) — 설명
- USE_YN — CHAR(1) — NOT NULL — 사용여부
- VER_NO — NUMBER — NOT NULL — 버전번호
- REG_USER_ID — VARCHAR2(50) — NOT NULL — 등록사용자아이디
- REG_DT — TIMESTAMP (6) — NOT NULL — 최초등록일시
- UPDT_USER_ID — VARCHAR2(50) — 갱신사용자아이디
- UPDT_DT — TIMESTAMP (6) — 갱신일시
- KID — NUMBER — NOT NULL — 인덱스아이디
- DEL_YN — CHAR(1) — NOT NULL — 삭제여부
TN_GEORAIL_EDTR_CURVE
- edtr_id — int8 — 기본 키 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- kid — int8 — NOT NULL
- job_id — int8 — 외래 키 → TN_GEORAIL_EDTR_JOB_LIST.job_id — NOT NULL
- sou_fclty_cd — varchar(50) — NOT NULL
- chg_bfr_geom — geometry(geometry, 5179) — NOT NULL
- chg_aftr_geom — geometry(geometry, 5179)
- strt_pnt — geometry(point, 5179)
- end_pnt — geometry(point, 5179)
- strt_dstnc — numeric(14, 3)
- end_dstnc — numeric(14, 3)
- node_intvl_dstnc — numeric(10, 3) — NOT NULL
- curve_mth — varchar(30) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_CURVE_PART
- curve_part_id — int8 — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- edtr_id — int8 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- job_id — int8 — 외래 키 → TN_GEORAIL_EDTR_CURVE.job_id — NOT NULL — PG DDL 및 FK 제약조건 기준 보완
- curve_sctn_seq — int4 — NOT NULL
- fclty_cd — varchar(50) — NOT NULL
- revs_yn — bpchar(1) — NOT NULL
- chn_strt_dstnc — numeric(14, 3)
- chn_end_dstnc — numeric(14, 3)
- chg_bfr_geom — geometry(geometry, 5179) — NOT NULL
- chg_aftr_geom — geometry(geometry, 5179)
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_CURVE_PNT
- curve_pnt_id — int8 — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- edtr_id — int8 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- job_id — int8 — 외래 키 → TN_GEORAIL_EDTR_CURVE.job_id — NOT NULL — PG DDL 및 FK 제약조건 기준 보완
- pnt_type — varchar(30) — NOT NULL
- pnt_role — varchar(30) — NOT NULL
- pnt_seq — int4 — NOT NULL
- curve_seq — int4
- fix_yn — bpchar(1) — NOT NULL
- geom — geometry(point, 5179) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_JOB_LIST
- job_id — int8 — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- edtr_id — int8 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- job_seq — int4 — NOT NULL
- job_type — varchar(20) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_MERG
- edtr_id — int8 — 기본 키 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- kid — int8 — NOT NULL
- job_id — int8 — NOT NULL
- keep_fclty_cd — varchar(50) — NOT NULL
- prm_err_m — numeric(10, 3) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_MERG_PART
- merg_part_id — int8 — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- edtr_id — int8 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- job_id — int8 — 외래 키 → TN_GEORAIL_EDTR_MERG.job_id — NOT NULL — PG DDL 및 FK 제약조건 기준 보완
- merg_sctn_seq — int4 — NOT NULL
- fclty_cd — varchar(50) — NOT NULL
- revs_yn — bpchar(1) — NOT NULL
- chn_strt_dstnc — numeric(14, 3)
- chn_end_dstnc — numeric(14, 3)
- part_geom — geometry(geometry, 5179) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_MNG_LIST
- edtr_id — int8 — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- atrz_no — varchar(50) — NOT NULL
- edtr_type — varchar(20) — NOT NULL
- edtr_stts — varchar(20) — NOT NULL
- trgt_fclty_cd_list — jsonb — NOT NULL
- chg_bfr_geom — geometry(geometry, 5179) — NOT NULL
- chg_aftr_geom — geometry(geometry, 5179)
- ver_no — int4 — NOT NULL
- use_yn — bpchar(1) — NOT NULL
- reg_dt — timestamp — NOT NULL
- updt_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_user_id — varchar(50)
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_RLWY_RSLT
- rlwy_rslt_id — int8 — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- edtr_id — int8 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- sou_fclty_cd — varchar(50)
- fclty_cd — varchar(50) — NOT NULL
- rlwy_chg_type — varchar(20) — NOT NULL
- geom — geometry(geometry, 5179)
- use_yn — bpchar(1) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_SPLT
- edtr_id — int8 — 기본 키 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- kid — int8 — NOT NULL
- job_id — int8 — 외래 키 → TN_GEORAIL_EDTR_JOB_LIST.job_id — NOT NULL
- sou_fclty_cd — varchar(50) — NOT NULL
- keep_orgnl_part — bpchar(1) — NOT NULL
- new_fclty_cd — varchar(50) — NOT NULL
- splt_pnt — geometry(point, 5179) — NOT NULL
- splt_dstnc — numeric(14, 3) — NOT NULL
- tot_len — numeric(14, 3) — NOT NULL
- min_part_len — numeric(14, 3) — NOT NULL
- chg_bfr_geom — geometry(geometry, 5179) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_EDTR_SPLT_PART
- splt_part_id — int8 — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- edtr_id — int8 — 외래 키 → TN_GEORAIL_EDTR_MNG_LIST.edtr_id — NOT NULL
- job_id — int8 — 외래 키 → TN_GEORAIL_EDTR_SPLT.job_id — NOT NULL — PG DDL 및 FK 제약조건 기준 보완
- part_cd — varchar(20) — NOT NULL
- fclty_cd — varchar(50) — NOT NULL
- orgnl_hld_yn — bpchar(1) — NOT NULL
- rlwy_chg_type — varchar(20) — NOT NULL
- chn_strt_dstnc — numeric(14, 3)
- chn_end_dstnc — numeric(14, 3)
- geom — geometry(geometry, 5179) — NOT NULL
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_GEORAIL_RLWY
- fclty_cd — varchar(50) — 기본 키 — NOT NULL
- kid — int8 — NOT NULL
- rlwy_type — varchar
- rlwy_nm — varchar
- geom — geometry(geometry, 5179)
- reg_dt — timestamp — NOT NULL
- reg_user_id — varchar(50)
- updt_dt — timestamp — NOT NULL
- updt_user_id — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- del_yn — bpchar(1) — NOT NULL
TN_STAN
- stan_sn — int8 — 기본 키 — NOT NULL
- kid — int8
- stan_nm — varchar(100)
- stan_knd_se — varchar(6)
- mng_dept_cd — varchar(50)
- rte_info — varchar(300) — NOT NULL
- geom — geometry(multipoint, 5179)
- telno — varchar(20)
- addr — varchar(300)
- use_yn — bpchar(1)
- register_id — varchar(20)
- regist_dt — timestamptz
- updusr_id — varchar(20)
- updt_dt — timestamptz
TN_STAN_HSTRY
- stan_hstry_sn — int8 — 기본 키 — NOT NULL
- stan_sn — int8 — NOT NULL
- kid — int8
- stan_nm — varchar(100)
- stan_knd_se — varchar(6)
- mng_dept_cd — varchar(50) — NOT NULL
- rte_info — varchar(300)
- geom — geometry(multipoint, 5179)
- telno — varchar(20)
- addr — varchar(300)
- atrz_no — varchar(50) — NOT NULL
- bfr_atrz_no — varchar(50)
- edtr_stts — varchar(20) — NOT NULL
- use_yn — bpchar(1) — NOT NULL
- register_id — varchar(20) — NOT NULL
- regist_dt — timestamptz — NOT NULL
- updusr_id — varchar(20)
- updt_dt — timestamptz