import { boolean, jsonb, text, timestamp, } from "drizzle-orm/pg-core";
import { knoxSchema } from "./employee";

export const approval = knoxSchema.table("approval", {
  apInfId: text("ap_inf_id").primaryKey(),
  userId: text("user_id").notNull(),
  epId: text("ep_id").notNull(),
  emailAddress: text("email_address").notNull(),
  subject: text("subject").notNull(),
  content: text("content").notNull(),
  status: text("status").notNull(),
  aplns: jsonb("aplns").notNull(),
  isDeleted: boolean("is_deleted").notNull().default(false),
  createdAt: timestamp("created_at").notNull().defaultNow(),
  updatedAt: timestamp("updated_at").notNull().defaultNow(),
});