SRILANKA_COMMENT
Tables (34)
Not
- Key — VARCHAR(255) — Primary key — NOT NULL
sri_auth
- auth_id — VARCHAR(32) — Primary key — NOT NULL
- auth_nm — VARCHAR(50)
- autn_desc — VARCHAR(100)
- use_yn — VARCHAR(1)
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
- upd_dt — TIMESTAMP
- upd_id — VARCHAR(32)
sri_auth_menu
- auth_menu_id — VARCHAR(32) — Primary key — NOT NULL
- auth_id — VARCHAR(32) — NOT NULL
- menu_id — VARCHAR(32) — NOT NULL
- creat_yn — VARCHAR(1)
- read_yn — VARCHAR(1)
- update_yn — VARCHAR(1)
- delete_yn — VARCHAR(1)
sri_cm_cd
- cd_id — VARCHAR(32) — Primary key — NOT NULL
- grp_cd_id — VARCHAR(32) — Foreign key → sri_cm_grp_cd.grp_cd_id — NOT NULL
- cd — VARCHAR(20)
- cd_desc — VARCHAR(100)
- cd_nm — VARCHAR(50)
- use_yn — VARCHAR(1)
- crt_dt — TIMESTAMP — NOT NULL
- crt_id — VARCHAR(32)
sri_cm_grp_cd
- grp_cd_id — VARCHAR(32) — Primary key — NOT NULL
- grp_cd — VARCHAR(50)
- grp_cd_nm — VARCHAR(100)
- grp_cd_desc — VARCHAR(1000)
- crt_dt — TIMESTAMP — NOT NULL
- crt_id — VARCHAR(32)
sri_file_mng
- file_id — VARCHAR(32) — Primary key — NOT NULL
- file_group_id — VARCHAR(32) — Foreign key → sri_group_file_mng.file_group_id — NOT NULL
- file_nm — VARCHAR(200)
- file_origin_nm — VARCHAR(400)
- file_ext — VARCHAR(20)
- file_path — VARCHAR(200)
- file_size — NUMERIC
- crt_dt — TIMESTAMP — NOT NULL
- crt_id — VARCHAR(32)
sri_group_file_mng
- file_group_id — VARCHAR(32) — Primary key — NOT NULL
- ntc_id — VARCHAR(32) — NOT NULL
- crt_dt — TIMESTAMP — NOT NULL
- crt_id — VARCHAR(32)
sri_grp_invst_master
- grp_invst_id — VARCHAR(32) — Primary key — NOT NULL
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_invst_master
- invst_id — VARCHAR(32) — Primary key — NOT NULL
- grp_invst_id — VARCHAR(32) — NOT NULL
- invst_nm — VARCHAR(100)
- invst_knd_cd — VARCHAR(20) — 설문/교통량
- invst_mngr — VARCHAR(50)
- lat — NUMERIC
- lon — NUMERIC
- invst_location — VARCHAR(50)
- invst_location_radius — INTEGER
- road — VARCHAR(100)
- invst_type — VARCHAR(50)
- invst_person_cnt — INTEGER
- color_cd — VARCHAR(32)
- invst_str_dt — TIMESTAMP
- invst_end_dt — TIMESTAMP
- invst_str_time — VARCHAR(4)
- invst_end_time — VARCHAR(4)
- geom — GEOMETRY
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_invst_rslt_master
- invst_rslt_id — VARCHAR(32) — Primary key — NOT NULL
- invster_id — VARCHAR(32) — NOT NULL
- invst_id — VARCHAR(32) — NOT NULL
- invst_nm — VARCHAR(100)
- invst_mngr — VARCHAR(50)
- lat — NUMERIC
- lon — NUMERIC
- invst_location — VARCHAR(50)
- geom — geometry
- invst_rslt_knd_cd — VARCHAR(20) — 통행/설문/교통량
- rslt_lon — NUMERIC
- rslt_lat — NUMERIC
- rslt_location — VARCHAR(50)
- rlst_location_radius — INTEGER
- rlst_location_chng_rsn — VARCHAR(1000)
- rslt_geom — GEOMETRY
- rslt_weather_cd — VARCHAR(20) — 맑음
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_invster
- invster_id — VARCHAR(32) — Primary key — NOT NULL
- sch_id — VARCHAR(32) — NOT NULL
- invst_id2 — VARCHAR(32) — NOT NULL
- user_id — VARCHAR(32)
- invster_nm — VARCHAR(50)
- invster_email — VARCHAR(50)
- invster_tel — VARCHAR(20)
- invster_birth — DATE
- prtcp_code — VARCHAR(50)
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_menu
- menu_id — VARCHAR(32) — Primary key — NOT NULL
- menu_cd — VARCHAR(20)
- upper_menu_cd — VARCHAR(20)
- menu_nm — VARCHAR(50)
- menu_desc — VARCHAR(100)
- menu_ordr — INTEGER
- menu_url_pattrn — VARCHAR(100)
- menu_url — VARCHAR(100)
- use_yn — VARCHAR(1)
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
- upd_dt — TIMESTAMP
- upd_id — VARCHAR(32)
sri_mngr
- mngr_id — VARCHAR(32) — Primary key — NOT NULL
- auth_id — VARCHAR(32)
- mngr_account_id — VARCHAR(30)
- mngr_account_pwd — VARCHAR(255)
- mngr_permission — VARCHAR(10)
- mngr_nm — VARCHAR(50)
- mngr_tel — VARCHAR(20)
- mngr_email — VARCHAR(50)
- mngr_dept — VARCHAR(50)
- mngr_stts_cd — VARCHAR(20) — 승인
- mngr_type_cd — VARCHAR(20) — 슈퍼관리자
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
- upd_dt — TIMESTAMP
- upd_id — VARCHAR(32)
sri_ntc_mng
- ntc_id — VARCHAR(32) — Primary key — NOT NULL
- ntc_title — VARCHAR(100)
- ntc_content — VARCHAR(400)
- use_yn — VARCHAR(1)
- ntc_wrtr — VARCHAR(50)
- crt_dt — TIMESTAMP — NOT NULL
- crt_id — VARCHAR(32)
sri_rslt_trfc
- rslt_trfc_id — VARCHAR(32) — Primary key — NOT NULL
- trfc_invst_rslt_id — VARCHAR(32) — Foreign key → sri_trfc_invst_rslt.trfc_invst_rslt_id — NOT NULL
- rslt_trfc — INTEGER
- trnsp_type — VARCHAR(20) — 승용차
sri_sch_mng
- sch_id — VARCHAR(32) — Primary key — NOT NULL
- invst_id — VARCHAR(32) — Foreign key → sri_invst_master.invst_id — NOT NULL
- sch_invst_str_dt — TIMESTAMP
- sch_invst_end_dt — TIMESTAMP
- sch_invst_str_time — varchar(4)
- sch_invst_end_time — varchar(4)
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_srvy_answ
- srvy_answ_id — VARCHAR(32) — Primary key — NOT NULL
- srvy_qstn_id — VARCHAR(32) — Foreign key → sri_srvy_invst_qstn.srvy_qstn_id — NOT NULL
- srvy_content — VARCHAR(2000)
sri_srvy_invst
- srvy_invst_id — VARCHAR(32) — Primary key — NOT NULL
- invst_id — VARCHAR(32) — Foreign key → sri_invst_master.invst_id — NOT NULL
- srvy_invst_knd_cd — VARCHAR(20) — AXLE
- srvry_invst_trgt_nbr — INTEGER
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_srvy_invst_qstn
- srvy_qstn_id — VARCHAR(32) — Primary key — NOT NULL
- srvy_invst_rslt_id — VARCHAR(32) — Foreign key → sri_srvy_invst_rslt.srvy_invst_rslt_id — NOT NULL
- srvy_qstn_title — VARCHAR(100)
- srvy_qstn_ordr — INTEGER
sri_srvy_invst_rslt
- srvy_invst_rslt_id — VARCHAR(32) — Primary key — NOT NULL
- invst_rslt_id — VARCHAR(32) — Foreign key → sri_invst_rslt_master.invst_rslt_id — NOT NULL
- invst_id — VARCHAR(32) — Foreign key → sri_invst_rslt_master.invst_id — NOT NULL
- srvy_invst_str_dt — TIMESTAMP
- srvy_invst_end_sdt — TIMESTAMP
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_srvy_qstn
- srvy_qstn_id — VARCHAR(32) — Primary key — NOT NULL
- srvy_sctn_id — VARCHAR(32) — Foreign key → sri_srvy_sctn.srvy_sctn_id — NOT NULL
- qstn_title — VARCHAR(100)
- qstn_type — VARCHAR(10) — 주관식/라디오/드롭다운/날짜/지도/시간
- qstn_ordr — INTEGER
sri_srvy_qstn_answ
- srvy_qstn_answ_id — VARCHAR(32) — Primary key — NOT NULL
- srvy_qstn_id — VARCHAR(32) — NOT NULL
- qstn_answ_content — VARCHAR(400)
- qstn_answ_ordr — INTEGER
sri_srvy_sctn
- srvy_sctn_id — VARCHAR(32) — Primary key — NOT NULL
- srvy_invst_id — VARCHAR(32) — Foreign key → sri_srvy_invst.srvy_invst_id — NOT NULL
- srvy_sub_title — VARCHAR(100)
- srvy_sctn_knd_cd — VARCHAR(20) — 일반/통행실태
- srvy_sctn_ordr — INTEGER
sri_trfc_invst
- trfc_invst_id — VARCHAR(32) — Primary key — NOT NULL
- invst_id — VARCHAR(32) — Foreign key → sri_invst_master.invst_id — NOT NULL
- trfc_invst_knd_cd — VARCHAR(20) — MCC/TM
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_trfc_invst_rslt
- trfc_invst_rslt_id — VARCHAR(32) — Primary key — NOT NULL
- invst_rslt_id — VARCHAR(32) — Foreign key → sri_invst_rslt_master.invst_rslt_id — NOT NULL
- invster_id — VARCHAR(32) — NOT NULL
- trfc_invst_str_dt — TIMESTAMP
- trfc_invst_end_sdt — TIMESTAMP
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_trfc_srvy_answ
- trfc_srvy_answ_id — VARCHAR(32) — Primary key — NOT NULL
- trfc_qstn_id — VARCHAR(32) — Foreign key → sri_trfc_srvy_invst_qstn.trfc_qstn_id — NOT NULL
- trfc_srvy_content — VARCHAR(2000)
sri_trfc_srvy_invst_qstn
- trfc_qstn_id — VARCHAR(32) — Primary key — NOT NULL
- trfc_srvy_invst_rslt_id — VARCHAR(32) — Foreign key → sri_trfc_srvy_invst_rslt.trfc_srvy_invst_rslt_id — NOT NULL
- trfc_qstn_title — VARCHAR(100)
- trfc_qstn_ordr — INTEGER
sri_trfc_srvy_invst_rslt
- trfc_srvy_invst_rslt_id — VARCHAR(32) — Primary key — NOT NULL
- invst_rslt_id — VARCHAR(32) — Foreign key → sri_invst_rslt_master.invst_rslt_id — NOT NULL
- invst_id — VARCHAR(32) — Foreign key → sri_invst_rslt_master.invst_id — NOT NULL
- trfc_str_dt — TIMESTAMP
- trfc_location — VARCHAR(50)
- lat — NUMERIC
- lon — NUMERIC
- geom — GEOMETRY
- trfc_str_type_cd — VARCHAR(20) — 집/직장/학교/기타
- str_other_answ — VARCHAR(200)
- str_time — VARCHAR(4)
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_trfc_srvy_qstn
- trfc_srvy_qstn_id — VARCHAR(32) — Primary key — NOT NULL
- srvy_sctn_id — VARCHAR(32) — Foreign key → sri_srvy_sctn.srvy_sctn_id — NOT NULL
- trfc_srvy_invst_rslt_id — VARCHAR(32)
- trfc_qstn_title — VARCHAR(100)
- trfc_qstn_type — VARCHAR(10) — 주관식/라디오/드롭다운/날짜/지도/시간
- trfc_qstn_ordr — INTEGER
sri_trfc_srvy_qstn_answ
- trfc_srvy_qstn_answ_id — VARCHAR(32) — Primary key — NOT NULL
- trfc_srvy_qstn_id — VARCHAR(32) — NOT NULL
- trfc_qstn_answ_content — VARCHAR(400)
- trfc_qstn_answ_ordr — INTEGER
sri_user
- user_id — VARCHAR(32) — Primary key — NOT NULL
- user_account_id — VARCHAR(30)
- user_account_pwd — VARCHAR(255)
- user_permission — VARCHAR(10)
- user_nm — VARCHAR(50)
- user_tel — VARCHAR(20)
- user_email — VARCHAR(50)
- user_stts_cd — VARCHAR(20) — 승인
- mac_address — VHARCAR(32)
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
- upd_dt — TIMESTAMP
- upd_id — VARCHAR(32)
sri_user_fvrts
- fvrts_id — VARCHAR(32) — Primary key — NOT NULL
- user_id — VARCHAR(32) — Foreign key → sri_user.user_id — NOT NULL
- location_cd — VARCHAR(20) — 집
- lat — NUMERIC
- lon — NEMERIC
- fvrts_location — VARCHAR(50)
- geom — GEOMETRY
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_user_trfc
- trfc_id — VARCHAR(32) — Primary key — NOT NULL
- trfc_log_id — VARCHAR(32) — Foreign key → sri_user_trfc_log_master.trfc_log_id — NOT NULL
- user_id — VARCHAR(32) — Foreign key → sri_user_trfc_log_master.user_id — NOT NULL
- trnsp_cd — VARCHAR(20) — MCL/CAR/TWL/MBU
- location_cd — VARCHAR(20) — 집
- trfc_time — VARCHAR(4)
- lat — NUMERIC
- lon — NEMERIC
- location — VARCHAR(50)
- geom — GEOMETRY
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)
sri_user_trfc_log_master
- trfc_log_id — VARCHAR(32) — Primary key — NOT NULL
- user_id — VARCHAR(32) — Foreign key → sri_user.user_id — NOT NULL
- trfc_log_dt — TIMESTAMP
- crt_dt — TIMESTAMP
- crt_id — VARCHAR(32)