import { pgTable, text, serial, timestamp, integer, jsonb } from "drizzle-orm/pg-core";
import { createInsertSchema } from "drizzle-zod";
import { z } from "zod/v4";

// Detailed session plan generated per session row
export const sessionPlansTable = pgTable("session_plans", {
  id: serial("id").primaryKey(),
  sessionRowId: integer("session_row_id").notNull(),
  planId: integer("plan_id").notNull(),
  scheduledDate: text("scheduled_date"),
  scheduledStartTime: text("scheduled_start_time"),
  scheduledEndTime: text("scheduled_end_time"),
  duration: text("duration"),
  venue: text("venue"),
  status: text("status").notNull().default("draft"),
  // Full JSON content: bridge_in, learning_outcomes, resources, safety, pre_assessment,
  // participatory_stages, post_assessment, summary, reflection_prompts
  content: jsonb("content"),
  createdById: text("created_by_id"),
  createdAt: timestamp("created_at", { withTimezone: true }).notNull().defaultNow(),
  updatedAt: timestamp("updated_at", { withTimezone: true }).notNull().defaultNow().$onUpdate(() => new Date()),
});

export const insertSessionPlanSchema = createInsertSchema(sessionPlansTable).omit({ id: true, createdAt: true, updatedAt: true });
export type InsertSessionPlan = z.infer<typeof insertSessionPlanSchema>;
export type SessionPlan = typeof sessionPlansTable.$inferSelect;