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