math_farmer_notice

Tables (11)

Copy Of board (CopyOfboard)

  • pid — INT — Primary key — NOT NULL
  • title — VARCHAR — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • type — VARCHAR — NOT NULL — NOTICE, FQA
  • deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — INT — NOT NULL — 사용자 ID
  • modified_at — DATETIME — NOT NULL
  • modified_by — INT — NOT NULL — 사용자 ID

Copy Of question (CopyOfquestion)

  • pid — INT — Primary key — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — INT — NOT NULL — 사용자 ID
  • modified_at — DATETIME — NOT NULL
  • modified_by — INT — NOT NULL — 사용자 ID

board

  • pid — INT — Primary key — NOT NULL
  • title — VARCHAR — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • type — VARCHAR — NOT NULL — NOTICE, FQA
  • deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — INT — NOT NULL — 사용자 ID
  • modified_at — DATETIME — NOT NULL
  • modified_by — INT — NOT NULL — 사용자 ID

board_file

  • pid — INT — Primary key — NOT NULL
  • notice_pid — INT — Foreign key → board.pid — NOT NULL
  • real_name — VARCHAR — NOT NULL
  • virtual_name — VARCHAR — NOT NULL
  • content_type — VARCHAR — 파일 확장자
  • file_size — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL

board_file (board_file_)

  • pid — INT — Primary key — NOT NULL
  • board_pid — INT — Foreign key → Copy Of board.pid — NOT NULL
  • file_pid — INT — Foreign key → file.pid — NOT NULL

comment

  • pid — INT — Primary key — NOT NULL
  • question_id — INT — Foreign key → Copy Of question.pid — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — INT — NOT NULL — 사용자 ID
  • modified_at — DATETIME — NOT NULL
  • modified_by — INT — NOT NULL — 사용자 ID
  • parent_id — INT — comment 아래 comment가 오는 경우

comment_file

  • pid — INT — Primary key — NOT NULL
  • comment_pid — INT — Foreign key → comment.pid — NOT NULL
  • file_pid — INT — Foreign key → file.pid — NOT NULL

file

  • pid — INT — Primary key — NOT NULL
  • real_name — VARCHAR — NOT NULL
  • virtual_name — VARCHAR — NOT NULL
  • content_type — VARCHAR — 파일 확장자
  • file_size — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL

question

  • pid — INT — Primary key — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — INT — NOT NULL — 사용자 ID
  • modified_at — DATETIME — NOT NULL
  • modified_by — INT — NOT NULL — 사용자 ID
  • comment — MEDIUMTEXT
  • comment_created_at — DATETIME
  • comment_created_by — INT
  • comment_modified_at — DATETIME
  • comment_modified_by — INT

question_file

  • pid — INT — Primary key — NOT NULL
  • question_id — INT — Foreign key → question.pid — NOT NULL
  • real_name — VARCHAR — NOT NULL
  • virtual_name — VARCHAR — NOT NULL
  • content_type — VARCHAR — 파일 확장자
  • file_size — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • type — VARCHAR — NOT NULL — QUESTION, COMMENT

question_file (question_file_)

  • pid — INT — Primary key — NOT NULL
  • question_pid — INT — Foreign key → Copy Of question.pid — NOT NULL
  • file_pid — INT — Foreign key → file.pid — NOT NULL