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