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