I'm writing this app in ASP.NET/C#, with a MySQL backend. Should I set up a foreign key constraint? How would I go about doing this within a table (to tie the parentid field to the folderid field)?

CREATE TABLE products ( product_id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR (255) NOT NULL, description TEXT, price DECIMAL (10, 2) NOT NULL, stock INT NOT NULL ); ...