ㅇㄹㅇ

테이블 (6)

CLOSET (Untitled2)

  • CLOSET_ID (Key) — 기본 키 — NOT NULL
  • OWNER_USER_ID (USER_ID) — 외래 키 → 회원정보.USER_ID — NOT NULL
  • CLOSET_NAME (Field)

CLOSET_MEMBER (Untitled8)

  • MEMBER_ID (Key) — 기본 키 — NOT NULL
  • USER_ID — 외래 키 → 회원정보.USER_ID — NOT NULL
  • CLOSET_ID (Key2) — 외래 키 → CLOSET.CLOSET_ID — NOT NULL
  • OWNER_USER_ID (USER_ID2) — 외래 키 → CLOSET.OWNER_USER_ID — NOT NULL

CLOTHES (Untitled4)

  • CLOTHES_ID (Key) — 기본 키 — NOT NULL
  • CLOSET_ID (Key2) — 외래 키 → CLOSET.CLOSET_ID — NOT NULL
  • OWNER_USER_ID (USER_ID) — 외래 키 → CLOSET.OWNER_USER_ID — NOT NULL
  • CATEGORY (Field)
  • SEASON (Field2)
  • COLOR (Field3)
  • STATUS (Field4)
  • IMG_URL (Field5)
  • LAST_WORN (Field6)

OUTFIT (Untitled5)

  • OUTFIT_ID (Key) — 기본 키 — NOT NULL
  • USER_ID — 외래 키 → 회원정보.USER_ID — NOT NULL
  • OUTFIT_NAME (Field)
  • TPO_TAG (Field2)
  • CREATED_AT (Field3)

OUTFIT_ITEM (Untitled7)

  • ITEM_ID (Key) — 기본 키 — NOT NULL
  • OUTFIT_ID (Key2) — 외래 키 → OUTFIT.OUTFIT_ID — NOT NULL
  • USER_ID — 외래 키 → OUTFIT.USER_ID — NOT NULL
  • CLOTHES_ID (Key3) — 외래 키 → CLOTHES.CLOTHES_ID — NOT NULL
  • CLOSET_ID (Key22) — 외래 키 → CLOTHES.CLOSET_ID — NOT NULL
  • OWNER_USER_ID (USER_ID2) — 외래 키 → CLOTHES.OWNER_USER_ID — NOT NULL

회원정보 (Untitled)

  • USER_ID — 기본 키 — NOT NULL
  • PASSWORD (Field)
  • NICKNAME (Field2)
  • GENDER (Field3)