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