냠냠관통
테이블 (5)
board_posts
- id — BIGINT — 기본 키
- title — VARCHAR(200) — NOT NULL
- nick — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- version — INT
comments
- id — BIGINT — 기본 키
- bord_post_id — BIGINT — 외래 키 → board_posts.id
- nick — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
diets
- id — BIGINT — 기본 키
- user_id — BIGINT — 외래 키 → users.id
- date — DATE — NOT NULL
- type — VARCHAR(50)
- food_name — VARCHAR(200) — NOT NULL
- kcal — INT
- carb — DECIMAL(10,2)
- protein — DECIMAL(10,2)
- fat — DECIMAL(10,2)
- nutrition_raw — JSON
- created_at — DATETIME
- updated_at — DATETIME
- version — INT
foods
- food_name — VARCHAR(200) — 기본 키 — NOT NULL
- kcal — INT
- carb — DECIMAL(10,2)
- protein — DECIMAL(10,2)
- fat — DECIMAL(10,2)
users
- id — BIGINT — 기본 키
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100)
- height — DECIMAL(10,2)
- weight — DECIMAL(10,2)
- role — VARCHAR(50)
- status — VARCHAR(50)