lavuebd

테이블 (11)

boards

  • id — int(10) — 기본 키 — NOT NULL
  • group_id — int(10) — 외래 키 → groups.id — NOT NULL
  • name — varchar(255) — NOT NULL
  • mobile_name — varchar(255) — NOT NULL
  • order — tinyint(4) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

comments

  • id — int(10) — 기본 키 — NOT NULL
  • member_id — int(10) — NOT NULL
  • board_id — int(10) — 외래 키 → boards.id — NOT NULL
  • post_id — int(10) — NOT NULL
  • content — mediumtext — NOT NULL
  • username — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

groups

  • id — int(10) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • order — tinyint(4) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

migrations

  • id — int(10) — 기본 키 — NOT NULL
  • migration — varchar(255) — NOT NULL
  • batch — int(11) — NOT NULL

password_resets

  • email — varchar(255) — NOT NULL
  • token — varchar(255) — NOT NULL
  • created_at — timestamp

posts

  • id — int(10) — 기본 키 — NOT NULL
  • member_id — int(10) — NOT NULL
  • board_id — int(10) — 외래 키 → boards.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — mediumtext — NOT NULL
  • username — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

users

  • id — int(10) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • email_verified_at — timestamp
  • password — varchar(255) — NOT NULL
  • remember_token — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp

게시판 (board)

  • id — 기본 키 — NOT NULL
  • group_id — 외래 키 → 그룹.id — NOT NULL

그룹 (group)

  • id — 기본 키 — NOT NULL

글 (post)

  • id — int(11) — 기본 키 — NOT NULL — 키 자동 increments
  • member_id — 외래 키 → 회원.id — NOT NULL
  • board_id — 외래 키 → 게시판.id — NOT NULL
  • title — vschar(255)
  • content — mediumtext
  • Field

회원 (member)

  • id — 기본 키 — NOT NULL
  • username
  • email
  • password
  • nickname (Field)