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