실습과제#3
테이블 (3)
my_plant
- id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → user.id — NOT NULL
- plant_name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- adopt_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
plant_log
- id — INT — 기본 키 — NOT NULL
- my_plant_id — INT — 외래 키 → my_plant.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- watered — BOOLEAN — NOT NULL
- log_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
user
- id — INT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL