CREATE TABLE "training_surveys" (
	"id" serial PRIMARY KEY NOT NULL,
	"firstname" text NOT NULL,
	"lastname" text NOT NULL,
	"visit_date" timestamp NOT NULL,
	"productive_activity" text NOT NULL,
	"financial_requirement_description" text NOT NULL,
	"situr_code_commune" text NOT NULL,
	"communal_council" text NOT NULL,
	"situr_code_communal_council" text NOT NULL,
	"osp_name" text NOT NULL,
	"osp_address" text NOT NULL,
	"osp_rif" text NOT NULL,
	"osp_type" text NOT NULL,
	"current_status" text NOT NULL,
	"company_constitution_year" integer NOT NULL,
	"producer_count" integer NOT NULL,
	"product_description" text NOT NULL,
	"installed_capacity" text NOT NULL,
	"operational_capacity" text NOT NULL,
	"osp_responsible_fullname" text NOT NULL,
	"osp_responsible_cedula" text NOT NULL,
	"osp_responsible_rif" text NOT NULL,
	"osp_responsible_phone" text NOT NULL,
	"civil_state" text NOT NULL,
	"family_burden" integer NOT NULL,
	"number_of_children" integer NOT NULL,
	"general_observations" text NOT NULL,
	"photo1" text NOT NULL,
	"photo2" text NOT NULL,
	"photo3" text NOT NULL,
	"paralysis_reason" text NOT NULL,
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp (3)
);
--> statement-breakpoint
CREATE INDEX "training_surveys_index_00" ON "training_surveys" USING btree ("firstname");