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