create database falc;
use falc;
CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  first_name VARCHAR(50) NOT NULL,
  last_name VARCHAR(50) NOT NULL,
  email VARCHAR(100) UNIQUE NOT NULL,
  password_hash VARCHAR(255) NOT NULL,
  role ENUM('intern', 'community_member', 'company_employee') NOT NULL,
  profile_picture VARCHAR(255),
  profession VARCHAR(100),
  interests TEXT,
  skills TEXT,
  affiliations TEXT,
  social_causes TEXT,
  bio TEXT
);
