week1
Tables (3)
comments
- id — INTEGER — Primary key — NOT NULL
- post_id — INTEGER — Foreign key → postss.author_id — NOT NULL
- author_id — INTEGER — Foreign key → users.id — NOT NULL
- text — TEXT — NOT NULL
- created_at — DATETIME
postss (posts)
- id — INTEGER — Primary key — NOT NULL
- author_id — INTEGER — Foreign key → users.id — NOT NULL
- image_url — VARCHAR(255)
- content — TEXT
- like_count — INTEGER
- created_at — DATETIME
users
- id — INTEGER — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- avatar — VARCHAR(255)
- created_at — DATETIME