ai api

Tables (3)

answer (답변)

  • a_seq (답변 pk) — number — Primary key — NOT NULL
  • rgst_id (등록자 id) — varchar2(20) — NOT NULL
  • rgst_dt (등록일) — date — NOT NULL
  • use_yn (사용여부) — char(1) — NOT NULL
  • content (내용) — clob — NOT NULL
  • q_seq (질문 pk) — number — Foreign key → question.q_seq — NOT NULL

information (정보)

  • ctgr_cd (카테고리 코드 pk) — varchar2(20) — Primary key — NOT NULL
  • ctgr_name (카테고리 이름) — varchar2(50) — NOT NULL
  • content (내용) — clob — NOT NULL

question (질문)

  • q_seq (질문 pk) — number — Primary key — NOT NULL
  • rgst_id (등록자 id) — varchar2(20) — NOT NULL
  • rgst_dt (등록일) — date — NOT NULL
  • use_yn (사용여부) — char(1) — NOT NULL
  • title (제목) — varchar2(100) — NOT NULL
  • content (내용) — clob — NOT NULL
  • ans_yn (답변 여부) — char(1) — NOT NULL
  • ctgr_cd (카테고리 코드 pk) — varchar2(20) — Foreign key → information.ctgr_cd — NOT NULL