pilot project
Tables (4)
article
- id — int(11) — Primary key — NOT NULL
- title — varchar(45) — NOT NULL
- content — longtext — NOT NULL
- author_id — int(11)
- updated_at — datetime
- created_at — datetime
article_category
- id — int(11) — Primary key — NOT NULL
- article_id — int(11) — NOT NULL
- category_id — int(11) — NOT NULL
author
- id — int(11) — Primary key — NOT NULL
- name — varchar(200)
- created_at — datetime
- updated_at — datetime
category
- id — int(11) — Primary key — NOT NULL
- name — varchar(45) — NOT NULL
- tag — varchar(45) — NOT NULL
- created_at — datetime
- updated_at — datetime