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