workspace.sql.ts 644 B

1234567891011121314151617181920
  1. import { sqliteTable, text, integer } from "drizzle-orm/sqlite-core"
  2. import { ProjectTable } from "../project/sql"
  3. import { ProjectV2 } from "../project"
  4. import { WorkspaceV2 } from "../workspace"
  5. export const WorkspaceTable = sqliteTable("workspace", {
  6. id: text().$type<WorkspaceV2.ID>().primaryKey(),
  7. type: text().notNull(),
  8. name: text().notNull().default(""),
  9. branch: text(),
  10. directory: text(),
  11. extra: text({ mode: "json" }),
  12. project_id: text()
  13. .$type<ProjectV2.ID>()
  14. .notNull()
  15. .references(() => ProjectTable.id, { onDelete: "cascade" }),
  16. time_used: integer()
  17. .notNull()
  18. .$default(() => Date.now()),
  19. })