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 — 생성일