CREATE TYPE "public"."education_level" AS ENUM('secondary', 'undergraduate', 'graduate', 'postgraduate', 'other');--> statement-breakpoint
CREATE TYPE "public"."gender" AS ENUM('male', 'female', 'prefer_not_to_say');--> statement-breakpoint
CREATE TYPE "public"."stack" AS ENUM('data_analytics', 'digital_marketing', 'web_development', 'product_design', 'ai_automation');--> statement-breakpoint
CREATE TABLE "registrations" (
	"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
	"full_name" text NOT NULL,
	"email" text NOT NULL,
	"phone" text NOT NULL,
	"gender" "gender" NOT NULL,
	"date_of_birth" text NOT NULL,
	"state" text NOT NULL,
	"education_level" "education_level" NOT NULL,
	"institution" text NOT NULL,
	"stack" "stack" NOT NULL,
	"motivation" text NOT NULL,
	"experience" text,
	"heard_from" text NOT NULL,
	"created_at" timestamp DEFAULT now() NOT NULL,
	CONSTRAINT "registrations_email_unique" UNIQUE("email")
);
