echo
Tables (15)
comments
- idx — int(11) — Primary key — NOT NULL
- post_idx — int(11) — Foreign key → posts.idx — NOT NULL
- writer_idx — int(11) — Foreign key → user.idx — NOT NULL
- replies — int(11)
- status — ENUM
- added_date — datetime — NOT NULL
- content — text — NOT NULL
mentions
- idx — int(11) — Primary key — NOT NULL
- user_idx — int(11) — Foreign key → user.idx — NOT NULL
- 추가된 날짜 (added_date) — datetime — NOT NULL
- target_type — ENUM — NOT NULL
- target_idx — int(11) — NOT NULL
notifications
- idx — int(11) — Primary key — NOT NULL
- user_idx — int(11) — Foreign key → user.idx — NOT NULL
- added_date — datetime — NOT NULL
- notification_type — ENUM — NOT NULL
- target_type — ENUM — NOT NULL
- target_idx — int(11) — NOT NULL
permission
- idx — int(11) — Foreign key → user.idx — NOT NULL
- user_idx — int(11) — NOT NULL
- 구역 (section) — varchar(50) — NOT NULL
- 레벨 (level) — int(11) — NOT NULL
post_and_tags
- idx — int(11) — Primary key — NOT NULL
- post_idx — int(11) — Foreign key → posts.idx — NOT NULL
- tag_idx — int(11) — Foreign key → tags.idx — NOT NULL
post_assessments
- idx — int(11) — Primary key — NOT NULL
- user_idx — int(11) — Foreign key → user.idx — NOT NULL
- post_idx — int(11) — Foreign key → posts.idx — NOT NULL
- assessment — ENUM — NOT NULL
- added_date — datetime — NOT NULL
post_not_tags
- idx — int(11) — Primary key — NOT NULL
- post_idx — int(11) — Foreign key → posts.idx — NOT NULL
- tag_idx — int(11) — Foreign key → tags.idx — NOT NULL
post_or_tags
- idx — int(11) — Primary key — NOT NULL
- post_idx — int(11) — Foreign key → posts.idx — NOT NULL
- tag_idx — int(11) — Foreign key → tags.idx — NOT NULL
post_reports
- idx — int(11) — Primary key — NOT NULL
- user_idx — int(11) — Foreign key → user.idx — NOT NULL
- post_idx — int(11) — Foreign key → posts.idx — NOT NULL
- added_date — datetime — NOT NULL
- report_type — ENUM — NOT NULL
- describe — text
posts
- idx — int(11) — Primary key — NOT NULL
- writer_idx — int(11) — Foreign key → user.idx — NOT NULL
- added_date — datetime — NOT NULL
- title — text — NOT NULL
- content — text — NOT NULL
replies
- idx — int(11) — Foreign key → comments.replies — NOT NULL
- writer_idx — int(11) — Foreign key → user.idx — NOT NULL
- status — ENUM
- added_date — datetime — NOT NULL
- content — text — NOT NULL
student
- idx — int(11) — Foreign key → user.idx — NOT NULL
- 학년 (grade) — int(11) — NOT NULL
- 반 (klass) — int(11) — NOT NULL — class 로 쓰면 파이썬에서 작업하기 귀찮아지므로 klass 라고 적음
- 번호 (number) — int(11) — NOT NULL
- 학번 (serial) — varchar(10) — NOT NULL
tags
- idx — int(11) — Primary key — NOT NULL
- 이름 (name) — varchar(20) — NOT NULL
- 소유자의 idx (owner_idx) — int(11) — Foreign key → user.idx — NOT NULL
- 추가된 날짜 (added_date) — datetime — NOT NULL
- 설명 (description) — text — NOT NULL
- 가입 옵션 (join_option) — ENUM
user
- idx — int(11) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- id — varchar(50)
- email — varchar(50)
- user_type — ENUM
- gender — ENUM
user_tags
- idx — int(11) — Primary key — NOT NULL
- tag_idx — int(11) — Foreign key → tags.idx — NOT NULL
- user_idx — int(11) — Foreign key → user.idx — NOT NULL
- admin — tinyint(1)
- modification_allowed — tinyint(1)
- invitation_allowed — tinyint(1)
- post_allowed — tinyint(1)
- acceptance_allowed — tinyint(1)
- status — ENUM