대리미
테이블 (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)