ㅇㄹㅇ
테이블 (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)