realworld
Tables (8)
Copy Of user (CopyOfuser)
- id — bigint — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- username — varchar(20) — NOT NULL
- password — varchar(255) — NOT NULL
- bio — varchar
- image — varchar
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
article
- id — bigint — Primary key — NOT NULL
- author_id — bigint — Foreign key → user.id — NOT NULL
- slug (sllug) — varchar(50) — NOT NULL
- title — varchar(50) — NOT NULL
- description — varchar(255) — NOT NULL
- body — text — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
article_tag
- article_id — bigint — Foreign key → article.id — NOT NULL
- tag_id — bigint — Foreign key → tag.id — NOT NULL
comment
- id — bigint — Primary key — NOT NULL
- article_id — bigint — Foreign key → article.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- body — text — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
favorite
- article_id — bigint — Foreign key → article.id — NOT NULL
- users_id — bigint — Foreign key → user.id — NOT NULL
follow
- user_id — bigint — Foreign key → user.id — NOT NULL
- follow_id — bigint — Foreign key → user.id — NOT NULL
tag
- id — bigint — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- username — varchar(20) — NOT NULL
- password — varchar(255) — NOT NULL
- bio — varchar
- image — varchar
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME