How do i look
Tables (6)
Category
- id — INT — Primary key
- type — VARCHAR(255)
- name — VARCHAR(255)
- brand — VARCHAR(255)
- price — INT
- styleId — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- style_id — INT — Foreign key → Style.id
Comment
- id — INT — Primary key
- content — VARCHAR(150)
- nickname — VARCHAR(20)
- password — VARCHAR(255)
- curationId — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- style_id — INT — Foreign key → Style.id
Curation
- id — INT — Primary key
- content — TEXT
- nickname — VARCHAR(20)
- password — VARCHAR(255)
- trendy — INT
- personality — INT
- practicality — INT
- costEffectiveness — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- style_id — INT — Foreign key → Style.id
Style
- id — INT — Primary key
- name — VARCHAR(255)
- title — VARCHAR(255)
- description — TEXT
- content — TEXT
- imageUrl — TEXT
- thumbnail — TEXT
- nickname — VARCHAR(20)
- password — VARCHAR(255)
- viewCount — INT
- curationCount — INT
- trendy — INT
- practicality — INT
- costEffectiveness — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
Table
- tag_id — INT — Foreign key → Tag.id
- style_id — INT — Foreign key → Style.id
Tag
- id — INT — Primary key
- name — string
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP