trim_avatar
Tables (14)
Cloth (옷)
- PK (cloth_id) — Long — Primary key — NOT NULL
- 아바타넘버 (avatar_number) — ENUM
- 가격 (price) — int
Cloth_parts (옷 개별 요소)
- PK (hair_parts_id) — Long — Primary key — NOT NULL
- 옷색 (cloth_color) — ENUM
- FK (cloth_id) — Long — Foreign key → Cloth.PK — NOT NULL
- 이미지 url (image_url) — String
Eyes (눈)
- PK (eyes_id) — Long — Primary key — NOT NULL
- 아바타넘버 (avatar_number) — ENUM
- 가격 (price) — int
Eyes_parts (눈 개별 요소)
- PK (hair_parts_id) — Long — Primary key — NOT NULL
- FK (eyes_id) — Long — Foreign key → Eyes.PK — NOT NULL
- 이미지 url (image_url) — String
Hair (머리)
- PK (hair_id) — Long — Primary key — NOT NULL
- 아바타넘버 (avatar_number) — ENUM
- 가격 (price) — int
Hair_parts (머리 개별 요소)
- PK (hair_parts_id) — Long — Primary key — NOT NULL
- 머리 색 (hair_color) — ENUM
- FK (hair_id) — Long — Foreign key → Hair.PK — NOT NULL
- 이미지 url (image_url) — String
Mouth (입)
- PK (mouth_id) — Long — Primary key — NOT NULL
- 아바타넘버 (avatar_number) — ENUM
- 가격 (price) — int
Mouth_parts (입 개별 요소)
- PK (hair_parts_id) — Long — Primary key — NOT NULL
- FK (mouth_id) — Long — Foreign key → Mouth.PK — NOT NULL
- 이미지 url (image_url) — String
member (사용자)
- PK (member_id) — Long — Primary key — NOT NULL
- 포인트 (point) — int
possessed_cloth (소유 옷)
- PK (possessed_eyes_id) — Long — Primary key — NOT NULL
- FK (member_id) — Long — Foreign key → member.PK — NOT NULL
- PK (cloth_id) — Long — Foreign key → Cloth.PK — NOT NULL
possessed_eyes (소유 눈)
- PK (possessed_eyes_id) — Long — Primary key — NOT NULL
- FK (avatar_id) — Long — Foreign key → Eyes.PK — NOT NULL
- FK (member_id) — Long — Foreign key → member.PK — NOT NULL
possessed_hair (소유 머리)
- PK (possessed_hair_id) — Long — Primary key — NOT NULL
- FK (avatar_id) — Long — Foreign key → Hair.PK — NOT NULL
- FK (member_id) — Long — Foreign key → member.PK — NOT NULL
possessed_mouth (소유 입)
- PK (possessed_eyes_id) — Long — Primary key — NOT NULL
- FK (member_id) — Long — Foreign key → member.PK — NOT NULL
- FK (mouth_id) — Long — Foreign key → Mouth.PK — NOT NULL
stored_avatar (Untitled)
- PK (stored_avatar_id) — Long — Primary key — NOT NULL
- 선택여부 (is_selected) — boolean
- 머리색 (hair_color_number) — ENUM
- 옷색 (cloth_color_number) — ENUM
- 바탕색 (background_color_number) — ENUM
- FK (hair_parts_id) — Long — Foreign key → Hair_parts.PK — NOT NULL
- FK (hair_parts_id2) — Long — Foreign key → Eyes_parts.PK — NOT NULL
- FK (hair_parts_id3) — Long — Foreign key → Mouth_parts.PK — NOT NULL
- FK (hair_parts_id4) — Long — Foreign key → Cloth_parts.PK — NOT NULL