👕 Data Model: Clothing (Damit)
Entity: Clothing_Item
| Field Name |
Data Type |
Description |
| clothing_id |
INTEGER (PK) |
Unique identifier ng damit |
| name |
VARCHAR(150) |
Pangalan o design name |
| category |
VARCHAR(100) |
Casual, Formal, Sportswear, Traditional |
| clothing_type |
VARCHAR(100) |
Shirt, Pants, Dress, Jacket, etc. |
| gender |
VARCHAR(50) |
Male, Female, Unisex |
| age_group |
VARCHAR(50) |
Child, Teen, Adult |
| primary_material |
VARCHAR(100) |
Cotton, Polyester, Silk, Wool |
| secondary_material |
VARCHAR(100) |
Optional additional material |
| color |
VARCHAR(100) |
Pangunahing kulay |
| size |
VARCHAR(50) |
XS, S, M, L, XL |
| fit_type |
VARCHAR(100) |
Slim, Regular, Loose |
| season |
VARCHAR(50) |
Summer, Winter, All-season |
| origin_country |
VARCHAR(100) |
Bansang pinagmulan |
| cultural_significance |
VARCHAR(200) |
Cultural or symbolic meaning |
| usage |
VARCHAR(150) |
Daily wear, Office, Ceremony |
| price |
DECIMAL(10,2) |
Presyo |
| sustainability |
BOOLEAN |
Eco-friendly material |
| notes |
TEXT |
Karagdagang detalye |
Optional Entity: Clothing_Brand
| Field Name |
Data Type |
Description |
| brand_id |
INTEGER (PK) |
Unique brand identifier |
| brand_name |
VARCHAR(150) |
Pangalan ng brand |
| country |
VARCHAR(100) |
Bansa |
| market_type |
VARCHAR(100) |
Mass, Premium, Luxury |
Junction Table: Brand_Clothing
| Field Name |
Data Type |
| brand_id |
INTEGER (FK) |
| clothing_id |
INTEGER (FK) |
Example Record
clothing_id: 1
name: Barong Tagalog
category: Traditional
clothing_type: Formal Shirt
gender: Male
age_group: Adult
primary_material: Piña
secondary_material: Jusi
color: White
size: M
fit_type: Regular
season: All-season
origin_country: Philippines
cultural_significance: National formal attire
usage: Ceremony, Formal Events
price: 8500
sustainability: true
