ENG_Mozambique ATES
Tables (36)
Administrative Disposition Table (moz_administ_dip)
- Administrative Disposition ID (administ_dip_id) — Primary key — NOT NULL
- Traffic enforcement ID (tfc_enf_id) — Varchar(20) — Foreign key → Traffic Enforcement Master Table.Traffic enforcement ID — NOT NULL — 단속정보 고유번호
- Violator ID (vio_id) — Varchar(20) — Foreign key → Traffic Enforcement Master Table.Violator ID — NOT NULL — 위반자 고유ID
- Traffic law ID (tfc_law_id) — Foreign key → Traffic Enforcement Master Table.Traffic law ID — NOT NULL — 법률아이디
- Case Type (case_ty)
- Count (count)
- Provisional Holding Yn (pro_hold_yn)
- Provisional Holding Address (pro_hold_addr)
- Penalty price (penalty_price)
- Disposition Description (dip_desc)
- Created Date (cr_dt)
- Creator (crtr)
Atch File Table (moz_atch_file)
- File IDX (file_idx) — Primary key — NOT NULL — File Idx
- Atch IDX (atch_idx) — 첨부파일 연결할 상위 테이블
- Operator ID (oprtr_id) — 회원 아이디
- File Original Name (file_org_nm) — 원파일명
- File Save Name (file_save_nm) — 저장 파일 명
- File Path (file_path) — 파일 경로
- File Size (file_size) — 파일 사이즈
- File Extension (file_exts) — 파일 확장자
- Regist Date (cr_dt) — 등록일자
- Update Date (upd_dt) — 수정일자
Authority Menu Table (moz_auth_menu)
- Authority Menu ID (auth_menu_id) — Primary key — NOT NULL
- Menu ID (menu_id) — Foreign key → Menu Table.Menu ID — NOT NULL
- Authority ID (auth_id) — Foreign key → Authority Table.Authority ID — NOT NULL
- Create Yn (create_yn)
- Read Yn (read_yn)
- Update Yn (update_yn)
- Delete Yn (delete_yn)
- Created Date (cr_dt)
- Creator (crtr)
Authority Table (moz_auth)
- Authority ID (auth_id) — Primary key — NOT NULL
- Authority Code (auth_cd)
- Authority Name (auth_nm)
Board Table (moz_brd)
- Board IDX (board_idx) — Primary key — NOT NULL — 게시판 idx
- Board Code Id (board_cd_id) — 게시판 코드 idx
- Operator ID (oprtr_id) — 회원 아이디
- Writer Name (wrtr_nm) — 작성자 이름
- Board Title (board_title)
- Board_contents (board_contents) — 게시글 내용
- View Count (view_cnt) — 조회수
- Create Date (cr_dt) — 등록일
- Update Date (upd_dt) — 수정일자
- Use Yn (use_yn)
- Popup Yn (popup_yn)
- Category Code (cate_cd)
- Post Start Date (post_str_dt)
- Post End Date (post_end_dt)
Common Code Table (moz_cm_cd)
- common code id (cd_id) — Primary key — NOT NULL — 공통코드아이디
- common code group id (cd_group_id) — 공통코드부모아이디
- common code name (cd_nm) — NOT NULL — 공통코드명
- common code description (cd_desc) — 공통코드설명
- use yn (use_yn) — NOT NULL — 사용여부
- creator (crtr) — NOT NULL — 생성자
- create date (cr_dt) — NOT NULL — 생성일
Complaints Registration Table (moz_complaints_reg)
- Complaints IDX (complaints_idx) — Primary key — NOT NULL — 이의신청 idx
- Category Code (cate_cd) — NOT NULL — 카테고리 코드(common_code)
- Writer Email (wrtr_email) — NOT NULL — 문의한 사람 이메일
- Post Title (post_ttl) — NOT NULL — 게시글 제목
- Post Content (post_cn) — NOT NULL — 게시글 내용
- Create Date (cr_dt) — NOT NULL — 작성일시
- Operator ID (oprtr id) — 담당자 아이디
- Answer Email (ans_email) — 답변자 이메일
- Answer Status (ans_stts) — 답변상태 0:미답변,1:답변완료
- Answer Contents (ans_contents) — 답변내용
- Answer Create Date (ans_cr_dt) — 답변 등록 일시
- Answer Update Date (ans_upd_dt) — 답변 수정일시
Driver License DB(TIS) (moz_dvr_lcen)
- Driver license ID (dvr_lcen_id) — Primary key — NOT NULL — 라이센스 고유번호
FAQ Table (moz_faq)
- FAQ IDX (faq_idx) — NOT NULL — faq idx
- FAQ Sequences (faq_seq) — faq 순번
- Category Type (cate_ty) — NOT NULL — 카테고리 타입
- Writer Id (wrtr_id) — NOT NULL — 작성자 id
- Post Title (post_title) — NOT NULL — 게시글 제목
- Post Content (post_content) — NOT NULL — 게시글 내용
- Answer Contents (ans_cn) — 답변내용
- Register Date (reg_dt) — NOT NULL — 작성일시
- Modify Date (mdf_dt) — 수정일시
- Delete Date (del_dt) — 삭제일시
- Delete YN (del_yn) — NOT NULL — 삭제여부
- View Count (view_cnt) — 조회수
Fine Notice Information Table (moz_fine_ntc_info)
- Fine Notice ID (fine_ntc_id) — Primary key — NOT NULL
- Traffic enforcement ID (tfc_enf_id) — Varchar(20) — Foreign key → Traffic Enforcement Master Table.Traffic enforcement ID — NOT NULL — 단속정보 고유번호
- Violator ID (vio_id) — Varchar(20) — Foreign key → Traffic Enforcement Master Table.Violator ID — NOT NULL — 위반자 고유ID
- Traffic law ID (tfc_law_id) — Foreign key → Traffic Enforcement Master Table.Traffic law ID — NOT NULL — 법률아이디
- Operator ID (oprtr_id) — Foreign key → Web Operator Table.Operator ID — NOT NULL — 담당자 고유번호
- Fine Notice Date (fine_ntc_dt)
- Fine Notice Price (fine_ntc_price)
- Fine Notice Deadline (fine_ntc_ddln)
- Notice Type (ntc_ty)
- payment Yn (paymnt_yn)
- Created Date (cr_dt)
- Creator (crtr)
Fine Payment Information Table (moz_fine_pymnt_info)
- Payment ID (pymnt_id) — Primary key — NOT NULL — 결제고유번호
- Traffic enforcement ID (tfc_enf_id) — Varchar(20) — Foreign key → Traffic Enforcement Master Table.Traffic enforcement ID — NOT NULL — 단속정보 고유번호
- Place of Payment ID (place_pymnt_id) — Foreign key → Place of Payment Information Table.Place of Payment ID — NOT NULL — 납부지 고유번호
- Total price (total_price) — 납부총금액
- Payment date (pymnt_dt) — 납부날짜
- Payment price (pymnt_price) — 납부금액
- Payment status (pymnt_stts) — 납부여부
- Payment method (pymnt_method) — 납부방법
- Payment deadline (pymnt_ddln) — 납부기한
- Payer name (payer_nm) — 납부자
- Payment operator (pymnt_oprtr) — 납부담당자
- Created Date (cr_dt) — NOT NULL — 생성날짜
- Creator (crtr) — NOT NULL — 생성자
Menu Table (moz_menu)
- Menu ID (menu_id) — Primary key — NOT NULL
- Parent Menu ID (parent_menu_id)
- Main Sort No (main_sort_no)
- Use Yn (use_yn)
- Sub Sort No (sub_sort_no)
- Menu Url (menu_url)
- Created Date (cr_dt)
- Creator (crtr)
- MenuNamePor (menu_nm_por)
- Menu nameEng (menu_nm_eng)
Objection Registraion Table (moz_obj_reg)
- Objection IDX (obj_idx) — Primary key — NOT NULL — 이의신청 idx
- Traffic enforcement ID (tfc_enf_id) — 단속 고유 번호
- Category Code (cate_cd) — NOT NULL — 카테고리 코드(common_code)
- Writer Email (wrtr_email) — NOT NULL — 문의한 사람 이메일
- Post Title (post_ttl) — NOT NULL — 게시글 제목
- Post Content (post_cn) — NOT NULL — 게시글 내용
- Create Date (cr_dt) — NOT NULL — 작성일시
- Operator ID (oprtr id) — 담당자 아이디
- Answer Email (ans_email) — 답변자 이메일
- Answer Status (ans_stts) — 답변상태 0:미답변,1:답변완료
- Answer Contents (ans_contents) — 답변내용
- Answer Create Date (ans_cr_dt) — 답변 등록 일시
- Answer Update Date (ans_upd_dt) — 답변 수정일시
Operator Audit Log Table (moz_oprtr_aud_log)
- Audit log ID (aud_log_id) — Primary key — NOT NULL — 인덱스
- URL (url) — URL
- Operator ID (oprtr_id) — NOT NULL — 담당자 아이디
- Operator name (oprtr_nm) — 담당자 이름
- Paramters (paramtr) — 파라미터
- Created Date (cr_dt) — NOT NULL — 생성일
Operator Department Table (moz_oprtr_dept)
- Operator department ID (oprtr_dept_id) — Primary key — NOT NULL — 담당자 소속 고유번호
- Operator department name (oprtr_dept_nm) — 소속명
- Operator department address (oprtr_dept_addr) — 주소
- Operator department tel (oprtr_dept_tel) — 연락처
- Use yn (use_yn) — NOT NULL — 사용여부
Payment Statistic Table (moz_pymnt_stats)
- idx — Primary key — NOT NULL — idx
- Date (dt) — NOT NULL — 날짜
- Traffic law ID (tfc_lw_id) — NOT NULL — 법률아이디
- Payment Amount (pymnt_amt) — 납부된금액
Place of Payment Information Table (moz_pl_pymnt_info)
- Place of Payment ID (place_pymnt_id) — Primary key — NOT NULL — 납부지 고유번호
- Place of Payment name (place_pymnt_nm) — 납부지 이름
- Place of Payment address (place_pymnt_addr) — 납부지 주소
- Place of Payment representative name (place_pymnt_rprsv_nm) — 납부 담당자 대표
- Plcae of Payment Type (place_pymnt_ty)
- Place of Payment Contact (place_pymnt_cntc)
- Operate Open Time (oper_str_tm)
- Operate End Time (oper_end_tm)
- Closed Date (clsd _dt)
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
Police officer information table (moz_pol_info)
- Police officer ID (pol_id) — Primary key — NOT NULL — 경찰 고유번호
- Police officer License ID (pol_lcen_id) — Primary key — NOT NULL — 경찰 라이센스번호
- Authority ID (auth_id) — Foreign key → Authority Table.Authority ID — NOT NULL
- Police officer name (pol_nm) — 경찰 이름
- Police officer license date (pol_lcen_dt) — 경찰 라이센스 취득일
- Police officer department name (pol_dept_nm) — 소속
- Class (class) — 계급
- Jurisdiction (jur) — 관할지역
- Birth (brth) — 생년월일
- Address (addr) — 거주지
- Device ID (dev_id) — 단말기 아이디
- Phone (phone) — 핸드폰
- Email (email) — 이메일
- Permission level of device (app_permission) — NOT NULL — 사용권한
- Police officer account id of device (app_pol_id) — 단말기 고유번호
- Police officer password of device (app_pol_pw) — 단말기 비밀번호
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
Traffic Accident Changed History Table (moz_tfc_acdnt_chg_hst)
- History ID (hst_id) — Primary key — NOT NULL — 히스토리 고유번호
- Traffic accident ID (tfc_acdnt_id) — Foreign key → Traffic accident master table.Traffic accident ID — NOT NULL — 교통사고 정보 고유번호
- Operator ID (oprtr_id) — Foreign key → Web Operator Table.Operator ID — NOT NULL — 담당자 고유번호
- Accident process code (acdnt_prc_cd) — 교통사고 프로세스 코드
- Comment (cmnt) — 코멘트
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
Traffic Accident Sum Statistic Table (moz_tfc_acdnt_sum_stats)
- idx — Primary key — NOT NULL — idx
- Date (dt) — NOT NULL — 날짜
- Sum Count (sum_cnt) — 누적수
Traffic Enforcement Equipment Master Table (moz_tfc_enf_eqp_master)
- Traffic enforcement equipment ID (tfc_enf_eqp_id) — Primary key — NOT NULL — 단속장비 고유번호
- Road address (road_addr) — 단속장비 설치위치 도로명
- Latitude (lat) — NOT NULL — 단속장비 위도
- Longtitude (lng) — NOT NULL — 단속장비 경도
- Equipment type (eqp_ty) — 단속장비 타입
- Created Date (cr_dt) — NOT NULL — 생성일
- Created operator ID (cr_oprtr_id) — NOT NULL — 생성자 아이디
- Use yn (use_yn) — NOT NULL — 사용여부
- Manufacturer (mnfctr) — 제조업체
- Status information generation cycle (stts_info_gnr_cy) — 상태정보 생성주기
- Freight vehicle limit speed (freight_vh_lmt_spd) — 화물차량 제한속도
- Normal vehicle limit speend (nr_vh_lmt_spd) — 일반차량 제한속도
- Last sync time (last_sync_time) — 마지막 동기화 시간
- Road lane quantity (road_ln_qy) — 차로수
Traffic Enforcement Equipment Log Table (moz_tfc_enf_eqp_log)
- Log ID (log_id) — Primary key — NOT NULL — 로그 idx
- Traffic enforcement equipment ID (tfc_enf_eqp_id) — Foreign key → Traffic Enforcement Equipment Master Table.Traffic enforcement equipment ID — NOT NULL — 단속장비 고유번호
- Road lane (road_ln) — 차로번호
- Control request type (cntrl_req_ty) — 제어 요청 타입(PTZ, 시간동기화 등)
- Control result (cntrl_result) — 제어결과
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
Traffic Enforcement Equipment Road Lane Control Table (moz_tfc_road_ln_cnrl)
- Road lane number (road_ln_no) — Primary key — NOT NULL — 차로 번호
- Traffic enforcement equipment ID (tfc_enf_eqp_id) — Foreign key → Traffic Enforcement Equipment Master Table.Traffic enforcement equipment ID — NOT NULL — 단속장비 고유번호
- Use Status (use_stts) — NOT NULL — 단속여부
- Traffic enforcement mode (tfc_enf_mode) — 단속모드
Traffic Enforcement Equipment Status Table (moz_tfc_enf_eqp_stts)
- Log ID (log_id) — Primary key — NOT NULL — 로그idx
- Traffic enforcement equipment ID (tfc_enf_eqp_id) — Foreign key → Traffic Enforcement Equipment Master Table.Traffic enforcement equipment ID — NOT NULL — 단속장비 고유번호
- System status (sys_stts) — NOT NULL — 시스템상태(정상/이상)
- Equipment door status (eqp_door_stts) — 함체문상태
- Equipment temperature (eqp_temp) — 함체온도
- Equipment pan status (eqp_pan_stts) — 함체 팬상태
- Equipment heater status (eqp_heater_stts) — 함체 히터상태
- Created Date (cr_dt) — NOT NULL — 생성일
Traffic Enforcement File Information Table (moz_tfc_enf_file_info)
- Violation File Number (vio_file_no) — Primary key — NOT NULL — 위반정보 파일 번호
- Traffic Enforcement Equipment ID (tfc_enf_eqp_id) — Foreign key → Traffic Enforcement Equipment Master Table.Traffic enforcement equipment ID — NOT NULL — 단속장비 고유번호
- File path (file_path) — NOT NULL — 파일Path
- File name (file_nm) — 파일명
- File size (file_size) — 파일크기
- Created Date (cr_dt) — NOT NULL — 생성일
Traffic Enforcement History Table (moz_tfc_enf_hst)
- History ID (hst_id) — Primary key — NOT NULL — 히스토리 고유번호
- Traffic enforcement ID (tfc_enf_id) — Varchar(20) — Foreign key → Traffic Enforcement Master Table.Traffic enforcement ID — NOT NULL — 단속정보 고유번호
- Operator ID (oprtr_id) — Foreign key → Web Operator Table.Operator ID — NOT NULL — 담당자 고유번호
- Traffic enforcement process code (tfc_enf_prc_cd) — 단속정보 프로세스 코드
- Created Date (cr_dt) — NOT NULL — 생성날짜
- Creator (crtr) — NOT NULL — 생성자
- Comment (cmnt) — 코멘트
Traffic Enforcement Master Table (moz_tfc_enf_master)
- Traffic enforcement ID (tfc_enf_id) — Varchar(20) — Primary key — NOT NULL — 단속정보 고유번호
- Violator ID (vio_id) — Varchar(20) — Foreign key → Violator Information Table.Violator ID — NOT NULL — 위반자 고유ID
- Traffic law ID (tfc_law_id) — Foreign key → Traffic Laws Information Table.Traffic law ID — NOT NULL — 법률아이디
- Traffic enforcement equipment ID (tfc_enf_eqp_id) — Foreign key → Traffic Enforcement Equipment Master Table.Traffic enforcement equipment ID — NOT NULL — 단속장비 고유번호
- Police officer ID (pol_id) — Foreign key → Police officer information table.Police officer ID — NOT NULL — 경찰 고유번호
- Traffic accident ID (tfc_acdnt_id) — Foreign key → Traffic accident master table.Traffic accident ID — NOT NULL — 교통사고 정보 고유번호
- Violation file number (vio_file_no) — Foreign key → Traffic Enforcement File Information Table.Violation File Number — NOT NULL — 위반정보 파일 번호
- Traffic enforcement date (tfc_enf_dt) — NOT NULL — 단속날짜시간
- Road address (road_addr) — 단속지역(도로)
- Road lane (road_ln) — 위반 차로
- Vehicle registration number (vh_reg_no) — 차량번호
- Vehicle type (vh_ty) — 차량타입
- Speed limit (spd_lmt) — 제한속도
- Violation speed (vio_spd) — 위반속도
- Overspeed (over_spd) — 초과속도
- Last traffic enforcement process Code (last_tfc_enf_proc_cd) — 단속정보 최종프로세스 코드
- Latitude (lat) — NOT NULL — 위도
- Longtitude (lng) — NOT NULL — 경도
- Created date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
- Violaton Type (vio_ty)
Traffic Enforcement Sum Statistic Table (moz_tfc_enf_sum_stats)
- idx — Primary key — NOT NULL — idx
- Date (dt) — NOT NULL — 날짜
- Traffic law ID (tfc_lw_id) — NOT NULL — 법률아이디
- Sum Count (sum_cnt) — 누적수
- Total Fine (tot_fine) — 벌금누적액
Traffic Facility Log Table (moz_tfc_facility_log)
- Traffic Facility Log ID (tfc_facility_log_id) — Primary key — NOT NULL
- Traffic Facility ID (tfc_facility_id) — Foreign key → Traffic Facility Master Table.Traffic Facility ID — NOT NULL
- Facility Status (facility_stts)
- Created Date (cr_dt)
- Creator (crtr)
Traffic Facility Master Table (moz_tfc_facility_master)
- Traffic Facility ID (tfc_facility_id) — Primary key — NOT NULL
- Facility Type (facility_ty)
- Facility Status (facility_stts)
- Failicy Description (facility_desc)
- Latitude (lat)
- Longtitude (lng)
- Jurisdiction (jur)
- Created Date (cr_dt)
- Creator (crtr)
Traffic Facility Sum Statistic Table (moz_tfc_facility_sum_stats)
- idx — Primary key — NOT NULL
- Date (dt)
- type (ty)
- sum_cnt
Traffic Laws Information Table (moz_tfc_lw_info)
- Traffic law ID (tfc_law_id) — Primary key — NOT NULL — 법률아이디
- Law name (law_nm) — 볍률명
- Law article number (law_article_no) — 법령 번호
- Law description (law_desc) — 법률 설명
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
Traffic accident master table (moz_tfc_acdnt_master)
- Traffic accident ID (tfc_acdnt_id) — Primary key — NOT NULL — 교통사고 정보 고유번호
- Accident vehicle group ID (acdnt_vh_grp_id) — 교통사고차량 그룹아이디
- Vehicle registration number (vh_reg_no) — NOT NULL — 차량번호
- Vehicle type (vh_ty) — 차량타입
- Accident date (acdnt_dt) — NOT NULL — 사고날짜
- Last accident process code (last_acdnt_prc_cd) — 교통사고 최종프로세스 코드
- Latitude (lat) — 위도
- Longtitude (lng) — 경도
- Road address (road_addr) — 사고지역(도로)
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
- Police officer ID (pol_id)
Traffic accident passengers information table (moz_tfc_acdnt_pnr_info)
- Driver ID (dvr_id) — Varchar(20) — Primary key — NOT NULL — 교통사고 운전자 고유아이디
- Traffic accident ID (tfc_acdnt_id) — Foreign key → Traffic accident master table.Traffic accident ID — NOT NULL — 교통사고 정보 고유번호
- Driver license ID (dvr_lcen_id) — Foreign key → Driver License DB(TIS).Driver license ID — NOT NULL — 라이센스 고유번호
- Passenger name (pnr_nm) — 탑승자 이름
- Passenger birthday (pnr_brth) — 탑승자 생년월일
- Passenger address (pnr_addr) — 탑승자 거주지
- Passenger phone number (pnr_pno) — 탑승자 연락처
- Passenger email (pnr_email) — 탑승자 이메일
- Drive yn (dv_yn) — NOT NULL — 운전여부
- Driver license type (dvr_lcen_ty) — 운전면허 타입
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
Violator Information Table (moz_vio_info)
- Violator ID (vio_id) — Varchar(20) — Primary key — NOT NULL — 위반자 고유ID
- Driver license ID (dvr_lcen_id) — Foreign key → Driver License DB(TIS).Driver license ID — NOT NULL — 라이센스 고유번호
- Violator name (vio_nm) — 위반자 이름
- Violator birthday (vio_brth) — 위반자 생년월일
- Violator address (vio_addr) — 위반자 거주지
- Violator phone number (vio_pno) — 위반자 연락처
- Violator email (vio_email) — 위반자 이메일
- Driver license type (dvr_lcen_ty) — 운전면허 타입
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자
Web Operator Table (moz_web_oprtr)
- Operator ID (oprtr_id) — Primary key — NOT NULL — 담당자 고유번호
- Operator department ID (oprtr_dept_id) — Foreign key → Operator Department Table.Operator department ID — NOT NULL — 담당자 소속 고유번호
- Authority ID (auth_id) — Foreign key → Authority Table.Authority ID — NOT NULL
- Operator name (oprtr_nm) — 담당자명
- Operator account id (oprtr_account_id) — NOT NULL — 담당자 아이디
- Operator account password (oprtr_account_pw) — 담당자 비밀번호
- Operator phone number (oprtr_pno) — 담당자 연락처
- Operator email (oprtr_email) — 담당자 이메일
- Operator registration date (oprtr_reg_dt) — 담당자 가입날짜
- Operator permission (oprtr_permission) — 담당자 권한
- Operator department name (oprtr_dept_nm) — 담당자 소속명
- Last login date (last_login_dt) — 최근로그인날짜
- Login failure count (login_fail_cnt) — 로그인실패횟수
- Connect IP (connect_ip) — NOT NULL — 접속가능 아이피
- Created Date (cr_dt) — NOT NULL — 생성일
- Creator (crtr) — NOT NULL — 생성자