What attributes should be in the Feedback table?
First of all I do not require any login for feedback. So I'm putting the following column in my table:
Primary is used to identify a particular row in your table.
Say if you are getting multiple feed back from the same customer,you can't identify them from the fields that you mentioned. You can just list out it based on the name or email of the customer. If there is an ID (primary key) you can tell that this is the first feedback that we received from a particular customer or something like that. Again its better to add a 'feedback date' as a field in your table so that you can track the feedbacks.
Here is the sample schema.
CREATE TABLE dbo.Feedback ([ID] INT IDENTITY(1,1) PRIMARY KEY, --Primary key of your table [Subject] VARCHAR(500), [Message] VARCHAR(MAX),-- limit the datatype as per your allowed characters [Name] VARCHAR(150), [Contactnumber] VARCHAR(20), [Email] VARCHAR(150), [ReceivedDate] DATETIME Default(GETDATE()) --the date you received the feedback )