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