Here is my Database Design
Create Table UserPost
(
PostId int Primary Key Identity,
Post Nvarchar(300)
)
GO
Create Table Employee
(
EmpId int Primary Key Identity,
Email Nvarchar(50),
[Address] Nvarchar(150),
Phone Nvarchar(20),
Dob Date,
ReferID int Foreign Key References UserPost(PostId)
)
I want to review user post before final submit and to request Employee for accept or reject user post.
How can i solve it.. please someone help me