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