-- CreateEnum
CREATE TYPE "ProjectBillingModel" AS ENUM ('FixedCost', 'Hourly');

-- CreateEnum
CREATE TYPE "UserBillingModel" AS ENUM ('Hourly', 'FTE');

-- CreateEnum
CREATE TYPE "FTEType" AS ENUM ('FullSeat', 'HalfSeat', 'QuarterSeat');

-- AlterTable
ALTER TABLE "project_users" ADD COLUMN     "fteType" "FTEType",
ADD COLUMN     "userBillingModel" "UserBillingModel";

-- AlterTable
ALTER TABLE "projects" ADD COLUMN     "projectBillingModel" "ProjectBillingModel" NOT NULL DEFAULT 'Hourly';

-- AlterTable
ALTER TABLE "users" ADD COLUMN     "hourlyRate" DECIMAL(10,2),
ADD COLUMN     "monthlyFTERate" DECIMAL(10,2);
