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