nops
Tables (8)
api_access_log (API 접근로그)
- seq_no (고유번호) — int8 — Primary key — NOT NULL
- org_id (기관고유번호) — varchar(50)
- log_dt (로그일시) — timestamp — NOT NULL
- access_ip (접근IP) — varchar(20) — NOT NULL
- access_url (접속URL) — varchar(200)
- access_parm (접속파라미터) — varchar(2000)
- access_os (접근OS) — varchar(20)
- access_browser (접근브라우저) — varchar(20)
api_notify_board (NOPS 공지게시판)
- seq_no (고유번호) — int8 — Primary key — NOT NULL
- use_yn (사용여부) — bpchar(1) — NOT NULL
- top_yn (상단여부) — bpchar(1) — NOT NULL
- content_gubun (게시구분) — varchar(20) — NOT NULL
- content_title (제목) — varchar(200) — NOT NULL
- content_body (본문) — text — NOT NULL
- read_cnt (조회수) — int4 — NOT NULL
- reg_dt (등록일시) — timestamp — NOT NULL
- mod_dt (수정일시) — timestamp
api_request_org (API요청기관)
- org_id (기관고유번호) — varchar(50) — Primary key — NOT NULL
- org_nm (기관명) — varchar(100) — NOT NULL
- org_pwd (임시비밀번호) — varchar(250) — NOT NULL
- org_url (기관URL) — varchar(200) — NOT NULL
- org_tel (기관대표번호) — varchar(20) — NOT NULL
- org_email (기관대표이메일) — varchar(100) — NOT NULL
- manager_nm (담당자성명) — varchar(50) — NOT NULL
- manager_tel (담당자전화번호) — varchar(20)
- org_desc (기관소개) — varchar(500)
- reg_dt (생성일시) — timestamp — NOT NULL
- mod_dt (수정일시) — timestamp
- api_key (API키) — varchar(150)
- api_dt (API키발급일자) — timestamp
- block_yn (차단여부) — bpchar(1) — NOT NULL
- block_reason — varchar(300)
- block_dt (차단일시) — timestamp
chatbot_request (챗봇요청)
- seq_no (고유번호) — int8 — Primary key — NOT NULL
- sender (요청자) — varchar(100)
- query (요청질문) — varchar(300)
- status_cd (상태코드) — varchar(20)
- status_txt (상태텍스트) — varchar(300)
- res_txt (응답텍스트) — text
- sel_response_id (선택응답ID) — int4
- req_dt (요청일시) — timestamp
- res_dt (응답일시) — timestamp
- sel_dt (선택일시) — timestamp
- reg_dt (등록일시) — timestamp
- mod_dt (수정일시) — timestamp
chatbot_response (챗봇응답)
- seq_no (고유번호) — int8 — Primary key — NOT NULL
- req_seq_no (요청고유번호) — int8
- choice (선택) — varchar(300)
- response_id (응답ID) — int4
- response (응답텍스트) — text
eac_board (EAC 게시판)
- seq_no (고유번호) — int8 — Primary key — NOT NULL
- board_type (게시판유형) — varchar(20) — NOT NULL
- use_yn (사용여부) — bpchar(1) — NOT NULL
- top_yn (상단여부) — bpchar(1) — NOT NULL
- content_gubun (게시구분) — varchar(20) — NOT NULL
- content_title (제목) — varchar(200) — NOT NULL
- content_body (본문) — text — NOT NULL
- read_cnt (조회수) — int4 — NOT NULL
- reg_dt (등록일시) — timestamp — NOT NULL
- mod_dt (수정일시) — timestamp
eac_board_file (EAC 첨부파일)
- seq_no (고유번호) — int8 — Primary key — NOT NULL
- file_id (파일ID) — varchar(50) — Primary key — NOT NULL
nld_file (공통파일)
- file_id (파일ID) — varchar(50) — Primary key — NOT NULL
- file_path (파일경로) — varchar(100)
- origin_file_nm (원본파일명) — varchar(200)
- save_file_nm (저장파일명) — varchar(50)
- file_extn (파일확장자) — varchar(10)
- file_size (파일크기) — int8
- reg_dt (등록일시) — timestamp
- del_yn (삭제여부) — bpchar(1)
- del_dt (삭제일시) — timestamp