과제
테이블 (6)
bookmarks
- user_id — INT — 외래 키 → users.id — NOT NULL
- post_id — INT — 외래 키 → posts.id — NOT NULL
- created_at — TIMESTAMP
comments
- id — INT
- post_id — INT — 외래 키 → posts.id — NOT NULL
- user_id — INT — 외래 키 → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
post_tags
- post_id — INT — 외래 키 → posts.id — NOT NULL
- tag_id — INT — 외래 키 → tags.id — NOT NULL
posts
- id — INT
- user_id — INT — 외래 키 → users.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- media_url — VARCHAR(500) — NOT NULL
- media_type — VARCHAR(10) — NOT NULL
- original_link — VARCHAR(500)
- category — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
tags
- id — INT
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20)
- created_at — TIMESTAMP