realworld
Tables (6)
Article
- id — Primary key — NOT NULL
- tag_id — int — Foreign key → Tags.id — NOT NULL
- user_id — int — Foreign key → Users.id — NOT NULL
- comment_id — int — Foreign key → Comment.id — NOT NULL
- title — varchar(50)
- description — varchar(50)
- body — varchar(50)
- slug — varchar(50)
- createdAt — datetime
- updatedAt — datetime
- favorited — boolean
- favorites_count — int
Comment
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → Users.id — NOT NULL
- id (id2) — int — Foreign key → Users.profile_id — NOT NULL
- article_id — int
- createdAt — datetime
- updatedAt — datetime
- body — varchar(50)
Profile
- id — int — Primary key — NOT NULL
- name — varchar(50)
- bio
- image — TEXT
- following — boolean
Tags
- id — int — Primary key — NOT NULL
- name — varchar(50)
Users
- id — int — Primary key — NOT NULL
- profile_id — int — Foreign key → Profile.id — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(50)
- username — varchar(50)
- token — varchar(50)
favorites
- id — int — Primary key — NOT NULL
- article_id — int — Foreign key → Article.id — NOT NULL
- user_id — int — Foreign key → Users.id — NOT NULL