countyGeoStratum.ts

Filename	Percent	Threshold	Total	Covered	Uncovered
src/db/schema/countyGeoStratum.ts	100.00%	80%	62	62	0

import { boolean, integer, varchar } from 'drizzle-orm/pg-core';

import { county } from './county.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';

export const countyGeoStratum = schema.table('CountyGeoStratum', {
  uid: varchar('uid').primaryKey(),
  schemaAbbr: varchar('schemaAbbr').notNull(),
  schemaName: varchar('schemaName').notNull(),
  schemaCode: integer('schemaCode').notNull(),
  abbr: varchar('abbr').notNull(),
  name: varchar('name').notNull(),
  code: integer('code').notNull(),
  isBlk: boolean('isBlk'),
  totalPrecincts: integer('totalPrecincts'),

  state: integer('state')
    .notNull()
    .references(() => state.uid, { onDelete: 'cascade' }),
});

export type NewCountyGeoStratum = typeof countyGeoStratum.$inferInsert;

export const countyGeoStratumRelations = relations(
  countyGeoStratum,
  ({ one, many }) => ({
    state: one(state, {
      fields: [countyGeoStratum.state],
      references: [state.uid],
    }),
    counties: many(county),
  })
);

[]

TypeScript Coverage Report generated by type-coverage and typescript-coverage-report at Thu, 04 Apr 2024 19:50:44 GMT

TypeScript coverage report