MyFit
Tables (5)
Body_Shot (Untitled3)
- id (Key) — Bigint — Primary key — NOT NULL — index
- user_id (Key2) — Bigint — Foreign key → User.id — NOT NULL
- photo_path (Field) — varchar(255) — NOT NULL — S3 bucket url
- create_at (Field2) — DATETIME — NOT NULL
Closet (Untitled4)
- id (Key) — Bigint — Primary key — NOT NULL — index
- user_id (Key2) — Bigint — Foreign key → User.id — NOT NULL
- cloth_path (Field) — varchar(255) — NOT NULL — S3 bucket url
- create_at (Field2) — DATETIME — NOT NULL
Fitting (Untitled5)
- id (Key) — Bigint — Primary key — NOT NULL — index
- user_id (Key2) — Bigint — Foreign key → User.id — NOT NULL
- body_id (Key3) — Bigint — Foreign key → Body_Shot.id — NOT NULL
- closet_id (Key4) — Bigint — Foreign key → Closet.id — NOT NULL
- result_path (Field) — varchar(255) — NOT NULL — S3 bucket url
- create_at (Field2) — DATETIME — NOT NULL
User (Untitled)
- id (Key) — Bigint — Primary key — NOT NULL — Index
- user_id (Field) — varchar(20) — NOT NULL — 유저 아이디
- password (Field2) — varchar(255) — NOT NULL — 유저 비밀번호
- user_name (Field4) — varchar(20) — NOT NULL — 유저 이름 & 닉네임
- user_gender (Field5) — boolean — NOT NULL — 성별
- user_birth (Field6) — varchar(6) — NOT NULL — 생년월일
- create_at (Field3) — DATETIME — NOT NULL — 생성일
User_detail (Untitled2)
- id (Key) — Bigint — Primary key — NOT NULL — index
- id (Key2) — Bigint — Foreign key → User.id — NOT NULL — Index
- height (Field) — Float — NOT NULL — 키
- weight (Field2) — Float — NOT NULL — 몸무게
- waist_line (Field3) — Float — NOT NULL — 허리둘레
- create_at (Field4) — DATETIME — NOT NULL — 생성일