crony

Tables (7)

Comments

  • id — BIGINT
  • review_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Product_Images

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • storage_path — TEXT — NOT NULL
  • image_url — TEXT
  • is_thumbnail — BOOLEAN
  • created_at — TIMESTAMP

Products

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • average_rating — DECIMAL(3, 1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Replies

  • id — BIGINT
  • comment_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Reviews

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT — NOT NULL
  • rating — INT — NOT NULL
  • created_at — TIMESTAMP
  • id (id2) — BIGINT — Foreign key → Users.id
  • updated_at — TIMESTAMP

Reviews_Products

  • id — BIGINT
  • review_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL

Users

  • id — BIGINT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP