AG 포탈 관리자
테이블 (4)
게시판테이블 (notice_table)
- Index (index) — INT — 기본 키
- Registrant (registrant) — VARCHAR
- RegDate (reg_date) — DATE
- Agent (agent) — VARCHAR
- Category (category) — VARCHAR
- ConsultNum (consult_num) — VARCHAR
- ReseptStatus (resept_status) — VARCHAR
- ProgressStatus (progress_status) — VARCHAR
- Title (title) — VARCHAR
- Content (content) — VARCHAR
- PostingDate (posting_date) — DATE
- PostingStatus (posting_status) — VARCHAR
- Views (views) — INT
게시판파일테이블 (notice_file_table)
- FileIndex (file_index) — INT — 기본 키
- FileName (file_name) — VARCHAR
- FilePath (file_path) — VARCHAR
- FileType (file_type) — VARCHAR
- Index (index2) — INT — 외래 키 → 게시판테이블.Index
답변테이블 (answer_table)
- AnswerIndex (answer_index) — INT — 기본 키 — NOT NULL
- RegDate (reg_date) — VARCHAR
- Registrant (registrant) — VARCHAR
- Content (content) — VARCHAR
- Index (index) — INT — 외래 키 → 게시판테이블.Index
답변파일테이블 (answer_file_table)
- FileIndex (file_index) — INT — 기본 키
- FileName (file_name) — VARCHAR
- FilePath (file_path) — VARCHAR
- FileType (file_type) — VARCHAR
- AnswerIndex (answer_index) — INT — 외래 키 → 답변테이블.AnswerIndex — NOT NULL