Yet Another ERD
Add Entity
N
1
N
1
N
1
N
1
N
1
users
id
PK
AI
BIGINT UNSIGNED
name
VARCHAR
email
VARCHAR
email_verified_at?
TIMESTAMP
password
VARCHAR
remember_token?
VARCHAR(100)
created_at?
TIMESTAMP
updated_at?
TIMESTAMP
8
2
posts
comments
posts
id
PK
AI
BIGINT UNSIGNED
user_id
FK
BIGINT UNSIGNED
title
VARCHAR
body
TEXT
slug
VARCHAR
status
ENUM
is_featured
BOOLEAN
created_at?
TIMESTAMP
updated_at?
TIMESTAMP
deleted_at?
TIMESTAMP
10
3
users
comments
comments
id
PK
AI
BIGINT UNSIGNED
post_id
FK
BIGINT UNSIGNED
user_id
FK
BIGINT UNSIGNED
body
TEXT
is_approved
BOOLEAN
created_at?
TIMESTAMP
updated_at?
TIMESTAMP
7
2
posts
users
tags
id
PK
AI
BIGINT UNSIGNED
name
VARCHAR
slug
VARCHAR
created_at?
TIMESTAMP
updated_at?
TIMESTAMP
5
1
post_tag
post_tag
id
PK
AI
BIGINT UNSIGNED
post_id
FK
BIGINT UNSIGNED
tag_id
FK
BIGINT UNSIGNED
created_at?
TIMESTAMP
updated_at?
TIMESTAMP
5
2
posts
tags
100%