import { sql } from "drizzle-orm";
import { text, integer, sqliteTable, index } from "drizzle-orm/sqlite-core";
export const subjects = sqliteTable(
"subjects",
{
id: integer("id").notNull().primaryKey(),
title: text("title").notNull(),
overview: text("overview").notNull(),
visibility: text("visibility", {
enum: ["Pending", "Public", "Private"],
})
.notNull()
.default("Pending"),
educationLevel: text("education_level", {
enum: ["a_level", "o_level"],
}).notNull(),
createdAt: text("created_at")
.default(sql`CURRENT_TIMESTAMP`)
.notNull(),
},
(table) => {
return {
titleIdx: index("title_idx").on(table.title),
};
},
);
import { sql } from "drizzle-orm";
import { text, integer, sqliteTable, index } from "drizzle-orm/sqlite-core";
export const subjects = sqliteTable(
"subjects",
{
id: integer("id").notNull().primaryKey(),
title: text("title").notNull(),
overview: text("overview").notNull(),
visibility: text("visibility", {
enum: ["Pending", "Public", "Private"],
})
.notNull()
.default("Pending"),
educationLevel: text("education_level", {
enum: ["a_level", "o_level"],
}).notNull(),
createdAt: text("created_at")
.default(sql`CURRENT_TIMESTAMP`)
.notNull(),
},
(table) => {
return {
titleIdx: index("title_idx").on(table.title),
};
},
);