FITLIFE
Tables (3)
calender
- postId — INT — Primary key — NOT NULL
- userId — VARCHAR(20) — Foreign key → users.userId — NOT NULL — User ID
- type — ENUM('운동', '식단') — NOT NULL
- month — INT — NOT NULL
- date — INT — NOT NULL
diary
- postId — INT — Primary key — NOT NULL
- userId — VARCHAR(20) — Foreign key → users.userId — NOT NULL — User ID
- mood — ENUM('좋음', '보통', '나쁨') — NOT NULL
- title — VARCHAR(20) — NOT NULL
- content — TEXT
- view_cnt — INT
- reg_date — TIMESTAMP
users
- userId — varchar(40) — Primary key — NOT NULL
- password — varchar(40) — NOT NULL
- name — varchar(40) — NOT NULL
- email — varchar(40) — NOT NULL
- height — INT(3) — NOT NULL
- weight — INT(3) — NOT NULL
- BMI — INT(3) — 키,몸무게 입력시 자동산출