꼬북목

테이블 (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