curation
Tables (3)
Comment
- id — INT — Primary key — NOT NULL
- nickname — VARCHAR(8)
- passwd — VARCHAR(20)
- content — TEXT
- curationId — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- curationId (curationId2) — INT — Foreign key → Curating.id — NOT NULL
Curating
- id — INT — Primary key — NOT NULL
- nickname — VARCHAR(8)
- passwd — VARCHAR(20)
- content — TEXT
- trendy — INT
- personality — INT
- practicality — INT
- costEffectiveness — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- styleId (styleId2) — INT — Foreign key → Style.id — NOT NULL
Style
- id — INT — Primary key — NOT NULL
- title — VARCHAR(30)
- description — VARCHAR(255)
- content — TEXT
- imegeUrl — TEXT
- thumbnail — TEXT
- tags — TEXT
- nickname — VARCHAR(8)
- viewCount — INT
- curationCount — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP