pjt1
Tables (8)
anonymous (Untitled8)
- id (Key2) — integer — Primary key — NOT NULL
- user_id (Key) — integer — Foreign key → article.id — NOT NULL
- article_id (id) — integer — Foreign key → user.id — NOT NULL
- number (Field) — integer
- id (Key3) — integer — Foreign key → article.id — NOT NULL
article (Untitled3)
- id (Key) — integer — Primary key — NOT NULL
- title (Field) — varchar(50)
- content (Field2) — text
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
- category_id (Key2) — integer — Foreign key → category.id — NOT NULL
- user_id (id) — integer — Foreign key → user.id — NOT NULL
category (Untitled5)
- id (Key) — integer — Primary key — NOT NULL
- name (Field) — varchar(15)
comment (Untitled6)
- id (Key) — integer — Primary key — NOT NULL
- user_id (id) — integer — Foreign key → user.id — NOT NULL
- article_id (Key2) — integer — Foreign key → article.id — NOT NULL
- content (Field) — varchar(200)
- anonymous (Field2) — integer
follow (Untitled7)
- id (Key) — integer — Primary key — NOT NULL
- from_user_id (id) — integer — Foreign key → user.id — NOT NULL
- to_user_id (id2) — integer — Foreign key → user.id — NOT NULL
like (Untitled4)
- id (Key2) — integer — Primary key — NOT NULL
- article_id (Key) — integer — Foreign key → article.id — NOT NULL
- user_id (id) — integer — Foreign key → user.id — NOT NULL
oauthid (Untitled2)
- id (Key) — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
- access_token (Field) — varchar(255)
- provider (Field2) — varchar(255)
user (Untitled)
- id — integer — Primary key — NOT NULL
- username — varchar(15)
- password — varchar(128)
- mbti (Field) — varchar(10)