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