캡스톤

테이블 (5)

Comments

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (shortform_id) — int — 외래 키 → Contents.Key — NOT NULL
  • Key (user_id) — int — 외래 키 → UserInfo.Key — NOT NULL
  • Field (comments) — varchar
  • Field (created_at) — datetimeN — NOT NULL

Competitor

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (from) — int — 외래 키 → UserInfo.Key — NOT NULL
  • Field (to) — int — NOT NULL

Contents

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → UserInfo.Key — NOT NULL
  • Field (contents) — varchar — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (datatype) — varchar — NOT NULL
  • Field (content_text) — varchar

Exercise

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (exercise_name) — varchar(10) — NOT NULL
  • Field (record) — varchar — NOT NULL
  • Field (contents) — varchar
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Key (user_id) — int — 외래 키 → UserInfo.Key — NOT NULL

UserInfo

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (email) — varchar — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field (profile) — varchar
  • Field (height) — float
  • Field (weight) — float
  • Field (muscle_mass) — float
  • Field (fat_mass) — float
  • Field (body_score) — float
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (is_dummy) — bool — NOT NULL