Health_Routine_1
Tables (4)
comments
- comment_id — BIGINT — Primary key — NOT NULL
- routine_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
likes
- like_id — BIGINT — Primary key — NOT NULL
- routine_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
routines
- routine_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- routine_date — DATE — NOT NULL
- sleep_hours — DECIMAL(3,1)
- exercise_type — VARCHAR(30)
- exercise_minutes — INT
- meals — VARCHAR(1000)
- water_ml — INT
- note — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50)
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP