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
글 (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)