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 — 생성자