1021
Tables (6)
Ariticle (Article)
- Key — Primary key — NOT NULL
- title (Field) — varchar(10)
- content (Field2) — text
- created_at (Field3) — date
- updated_at (Field4) — date
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
Comment
- Key — Primary key — NOT NULL
- content (Field) — text
- created_at (Field2) — date
- updated_at (Field3) — date
- article_id (Key2) — integer — Foreign key → Ariticle.Key — NOT NULL
- user_id (Key3) — Foreign key → User.user_id — NOT NULL
Follow
- Key — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
Like
- Key — Primary key — NOT NULL
- article_id (Key2) — int — Foreign key → Ariticle.Key — NOT NULL
- user_id (Key3) — int — Foreign key → User.user_id — NOT NULL
Profile
- Key — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- image (Field)
- nickname (Field2) — text
User
- user_id (Key) — Primary key — NOT NULL
- username (Field) — text
- first_name (Field2) — text
- last_name (Field3) — text
- email (Field4) — text