Fitty-kyle

Tables (13)

digital_closet (디지털옷장온보딩)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • platform_id (Key3) — bigint — Foreign key → platform.id — NOT NULL
  • image_url (Field) — varchar
  • category (Field2) — varchar
  • color (Field3) — varchar
  • manual_upload (Field4) — boolean
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

outfit (코디생성)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • situation_id (Key3) — bigint — Foreign key → situation.id — NOT NULL
  • name (Field6) — varchar
  • memo (Field7) — text
  • target_date (Field) — date
  • prompt (Field3) — varchar
  • result_image_url (Field2) — varchar
  • is_ai_generated (Field4) — boolean
  • created_at (Field5) — timestamp
  • is_favorite (Field8) — boolean

outfit_item (코디물품)

  • id (Key) — bigint — Primary key — NOT NULL
  • outfit_id (Key2) — bigint — Foreign key → outfit.id — NOT NULL
  • digital_closet_id (Key3) — bigint — Foreign key → digital_closet.id — NOT NULL
  • created_at (Field) — timestamp

outfit_tag (코디태그)

  • id (Key) — bigint — Primary key — NOT NULL
  • outfit_id (Key2) — bigint — Foreign key → outfit.id — NOT NULL
  • tag_id (Key3) — bigint — Foreign key → tag.id — NOT NULL

platform (쇼핑플랫폼리스트)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • logo_url (Field2) — varchar
  • status (Field3) — boolean

situation (상황코드)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • image_url (Field2) — varchar
  • status (Field3) — boolean
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

style (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • code (Field) — varchar
  • name (Field2) — varchar
  • image_url (Field3) — varchar
  • status (Field4) — boolean

tag (태그)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar

user (유저)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(50)
  • password (Field2) — varchar(255)
  • nickname (Field3) — varchar(10)
  • status (Field4) — varchar(10)
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

user_OAuth (소셜로그인)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • provider (Field) — varchar
  • provider_user_id (Field2) — varchar
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

user_personal (유저개인화온보딩)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • user_image_url (Field) — varchar
  • ai_image_url (Field2) — varchar
  • body_type (Field3) — varchar
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

user_platform (유저쇼핑플랫폼연동)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • platform_id (Key3) — bigint — Foreign key → platform.id — NOT NULL
  • status (Field) — varchar
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

user_style (유저스타일)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • style_id (Key3) — bigint — Foreign key → style.id — NOT NULL
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp