Fashion_Scanner_BlackPink_Version

Tables (9)

blackpink_member (CopyOfCopyOfUntitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • member_name (Field) — VARCHAR(32)
  • color_id (Key2) — INT — Foreign key → color.id — NOT NULL

clothes_attribute (CopyOfUntitled)

  • id (Key) — INT — Primary key — NOT NULL
  • attribute_name_en (Field) — VARCHAR(32)
  • attribute_name_kr (Field2) — VARCHAR(32)

clothes_category (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • category_name_en (Field) — VARCHAR(32)
  • category_name_kr (Field2) — VARCHAR(32)

clothes_image_attribute (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • id (Key2) — INT — Primary key — NOT NULL
  • lookbook_image_id (Key4) — INT — Foreign key → lookbook_clothes.id — NOT NULL
  • clothes_attribute_id (Key3) — INT — Foreign key → clothes_attribute.id — NOT NULL

color (CopyOfCopyOfUntitled)

  • id (Key) — INT — Primary key — NOT NULL
  • hex_code (Field) — CHAR(8)

lookbook_clothes (CopyOfCopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • image (Field2) — URL
  • registered_date (Field) — TIMESTAMP
  • member_id (Key2) — INT — Foreign key → blackpink_member.id — NOT NULL
  • category_id (Key3) — INT — Foreign key → clothes_category.id — NOT NULL
  • color_id (Key5) — INT — Foreign key → color.id — NOT NULL

shop_clothes (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • image (Field2) — URL
  • webpage_url (Field) — TEXT
  • lookbook_clothes_id (Key2) — INT — Foreign key → lookbook_clothes.id — NOT NULL

user (CopyOfUntitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • password (Field4) — VARCHAR(255)
  • registered_date (Field2) — TIMESTAMP
  • role (Field3) — CHAR(8)

user_request_clothes (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • image (Field2) — URL
  • upload_date (Field) — TIMESTAMP
  • lookbook_clothes_id (Key2) — INT — Foreign key → lookbook_clothes.id — NOT NULL
  • user_id (Key4) — INT — Foreign key → user.id — NOT NULL