CREATE TABLE reviews ( id INT PRIMARY KEY AUTO_INCREMENT, business_id INT NOT NULL, rating INT CHECK (rating BETWEEN 1 AND 5), comment TEXT, reviewer_name VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (business_id) REFERENCES businesses(id) ON DELETE CASCADE );
Pay a one-time license fee instead of thousands in custom development. business directory script