add database

[shadil-rayyan]

currently there is no database basically anyone can login and add project but cannot edit or delete it so we need solve this

[shadil-rayyan]

Database Schema Tree

• users

  • uid (PK)
  • name
  • email
  • is_admin

• projects

  • project_id (PK)
  • project_name
  • project_description
  • year_of_submission
  • project_type
  • department
  • domain
  • custom_domain (nullable)
  • project_link
  • created_at
  • created_by_uid (FK → users.uid)

• team_members

  • member_id (PK)
  • project_id (FK → projects.project_id)
  • name
  • linkedin

• dropdown_options

  • id (PK)
  • category (e.g., "Project Type", "Department", "Domain", "Year of Submission")
  • option_value

[shadil-rayyan]

convert the project from json to neon database postgres and also make a admin page where all the admin can edit or delete any projects as well