beauty_analytics_erd
Tables (5)
item (상품 정보)
- id (PK) — int — Primary key — NOT NULL
- id (FK) — int — Foreign key → item_category.id — NOT NULL
- name (Field2)
- brand (Field3)
- description (Field9) — text
- ingredients (Field5)
- is_on_ad (Field6) — bool
- thumbnail_url (Field10)
- detail_image_url (Field)
- created_at (Field4) — timestamp
- updated_at (Field7) — timestamp
item_category (상품 카테고리)
- id (PK) — int — Primary key — NOT NULL
- category_no (Field1)
- parent_category_no (Field2)
- name (Field3)
- description (Field7) — text
- is_active (Field6) — bool
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
item_ingredient (화장품 전성분)
- id (PK) — int — Primary key — NOT NULL
- cas_no (Field) — int
- name (Field2)
- e_name (Field3)
- description (Field4)
- sate_grade (Field5)
item_review (상품 리뷰)
- id (PK) — int — Primary key — NOT NULL
- id (FK2) — int — Foreign key → item.id — NOT NULL
- member_id (FK3) — int
- title (Field2) — text
- comment (Field) — text
- rating (Field3) — int
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
mapped_item_and_ingredient (상품 별 전성분 매핑)
- id (PK) — int — Primary key — NOT NULL
- item_id (FK) — int — Foreign key → item.id — NOT NULL
- ingredient_id (FK2) — int — Foreign key → item_ingredient.id — NOT NULL
- created_at (Field) — timestamp
- updated_at (Field2) — timestamp
- Field3