lv333
Tables (3)
blog
- id — Primary key — NOT NULL
- created_at — timestamp
- modified_at — timestamp
- contents — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- user_id — bigint — NOT NULL
- username — varchar(255) — NOT NULL
- id (id2) — Foreign key → users.id — NOT NULL
comment
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- modified_at — timestamp
- contents — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL
- blog_id — bigint — NOT NULL
- id (id2) — Foreign key → blog.id — NOT NULL
- id (id3) — Foreign key → users.id — NOT NULL
users
- id — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- role — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL