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