test
Tables (6)
Clothes (의상)
- id (의상ID) — UUID — Primary key — NOT NULL
- name (의상이름) — VARCHAR(255) — NOT NULL
- type (의상타입) — VARCHAR(255) — NOT NULL
- user_id (사용자ID) — UUID — Foreign key → Users.id — NOT NULL
ClothesOutfit (의상아웃핏)
- id (의상아웃핏ID) — UUID — Primary key — NOT NULL
- id (의상ID) — UUID — Foreign key → Clothes.id — NOT NULL
- id (아웃핏ID2) — UUID — Foreign key → Outfit.id — NOT NULL
OOTD (오늘의아웃핏)
- id (아웃핏ID) — UUID — Foreign key → Outfit.id — NOT NULL
- weather (날씨정보) — VARCHAR(255) — NOT NULL
- date (날짜) — TIMESTAMPTZ(6) — NOT NULL
Outfit (아웃핏)
- id (아웃핏ID) — UUID — Primary key — NOT NULL
- name (아웃핏이름) — VARCHAR(255) — NOT NULL
- category (카테고리) — VARCHAR(255) — NOT NULL
Profile (프로필)
- id (사용자ID) — UUID — Foreign key → Users.id — NOT NULL
- location (위치) — VARCHAR(20)
- gender (성별) — VARCHAR(50) — NOT NULL
Users (사용자)
- id (사용자ID) — UUID — Primary key — NOT NULL
- name (이름) — VARCHAR(255) — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(500) — NOT NULL