Refit
Tables (8)
Item (Untitled5)
- Key — Primary key — NOT NULL
- Field
character (Untitled4)
- Key — Primary key — NOT NULL
- exp (Field)
- level (Field2)
- Field3
- Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL
exercise (Untitled3)
- exercise Id (Key) — Primary key — NOT NULL
- youtubeUrl (Field)
- 운동설명 (Field2)
- 제목 (Field3)
- 썸네일 (Field4)
- duration (Field5)
- Field6
- Routine Id (routine_id) — int — Foreign key → routines.Routine Id — NOT NULL
member (Untitled)
- Member Id (member_id) — int — Primary key — NOT NULL
- 나이 (age) — int
- 몸무게 (weight) — int
- 성별 (gender) — enum
- 신장 (height) — double
- 이름 (name) — string
- 근력
- 유연성
- 심폐지구력 (Field)
- 순발력 (Field2)
- 평형성 (Field3)
- 이메일 (Field4)
- 패스워드 (Field5)
- Field6
point (Untitled6)
- Key — Primary key — NOT NULL
purchase (Untitled8)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Item.Key — NOT NULL
- Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL
routine_access (Untitled7)
- Key — Primary key — NOT NULL
- Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL
- Routine Id (routine_id) — int — Foreign key → routines.Routine Id — NOT NULL
- isCompleted (Field)
- Field2
routines (Untitled2)
- Routine Id (routine_id) — int — Primary key — NOT NULL
- Field
- Field2
- Field3
- Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL