대리미

테이블 (7)

Board (boards)

  • id — int(10) — 기본 키 — NOT NULL
  • board_group — int(10) — 외래 키 → BoardGroup.id — NOT NULL
  • name — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • code — varchar(255)
  • explanation — varchar(255)

BoardGroup (board_groups)

  • id — int(10) — 기본 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code — varchar(255)

Comment (comments)

  • id — int(10) — 기본 키 — NOT NULL
  • like — int(10) — 외래 키 → Like.post — NOT NULL
  • post — int(10) — 외래 키 → Post.id — NOT NULL
  • Field

Like (likes)

  • id — int(10) — 기본 키 — NOT NULL
  • comment — int(10) — 외래 키 → Comment.id — NOT NULL
  • post — int(10) — 외래 키 → Post.id — NOT NULL

Post (posts)

  • id — int(10) — 기본 키 — NOT NULL
  • author — int(10) — 외래 키 → User.id — NOT NULL
  • board — int(10) — 외래 키 → Board.id — NOT NULL
  • post_label — int(10) — 외래 키 → PostLabel.id — NOT NULL
  • like — int(10) — 외래 키 → Like.id — NOT NULL
  • title — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • view — int(10)
  • content — longtext

PostLabel (post-labels)

  • id — int(10) — 기본 키 — NOT NULL
  • color — varchar(255) — NOT NULL
  • label — varchar(255) — NOT NULL

User (users-permissions)

  • id — int(10) — 기본 키 — NOT NULL
  • username — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • provider — varchar(255)
  • password — varchar(255)
  • resetPasswordToken — varchar(255)
  • confirmationToken — varchar(255)
  • confirmed — tinyint(1)
  • blocked — tinyint(1)
  • role — int(10)
  • created_by — timestamp
  • updated_at — timestamp
  • post — int(10)
  • nickname — varchar(255)