꼬북목
테이블 (5)
Category (category)
- Category Id (category_id) — int — 기본 키 — NOT NULL
- Name (name) — char(50)
Posture (posture)
- Posture Id (posture_id) — int — 기본 키 — NOT NULL
- User Id (user_id) — int — 외래 키 → User.User Id — NOT NULL
- Date (date) — datetime
- Total Time (total_time) — time
Posture Level (posture level)
- Posture Level Id (posture_level_id) — int — 기본 키 — NOT NULL
- Posture Id (posture_id) — int — 외래 키 → Posture.Posture Id — NOT NULL
- User Id (user_id) — int — 외래 키 → Posture.User Id — NOT NULL
- Level (level) — int
- Time (time) — time
Stretching (stretching)
- Stretching Id (stretching_id) — int — 기본 키 — NOT NULL
- Category Id (category_id) — int — 외래 키 → Category.Category Id — NOT NULL
- Title (title) — char(100)
- Content (content) — text
- Image (image) — image
- Url (url) — char(200)
User (user)
- User Id (user_id) — int — 기본 키 — NOT NULL
- Email (email) — char(100)
- Password (password) — char(50)
- Last Name (last_name) — char(50)
- First Name (first_name) — char(50)
- Gender (gender) — int
- Age (age) — int
- Break Time (break_time) — int
- Desired Humidity (desired_humidity) — int
- Auto Setting (auto_setting) — boolean
- Is Superuser (is_superuser) — boolean
- Friend Id (friend_id) — int — 외래 키 → User.User Id — NOT NULL