countyDemographic.ts

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

import { integer, real, 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 countyDemographic = schema.table('CountyDemographic', {
  uid: varchar('uid').primaryKey(),
  medianAge: real('medianAge'),
  percentBlack: real('percentBlack'),
  percentDemBaseRace: real('percentDemBaseRace'),
  percentEducation4YearDegree: real('percentEducation4YearDegree'),
  percentHispanic: real('percentHispanic'),
  population: integer('population'),
  populationDensity: real('populationDensity'),

  state: integer('state')
    .notNull()
    .references(() => state.uid),
  county: varchar('county')
    .notNull()
    .references(() => county.uid),
});

export type NewCountyDemographic = typeof countyDemographic.$inferInsert;

export const countyDemographicRelations = relations(
  countyDemographic,
  ({ one }) => ({
    county: one(county, {
      fields: [countyDemographic.county],
      references: [county.uid],
    }),
    state: one(state, {
      fields: [countyDemographic.state],
      references: [state.uid],
    }),
  })
);

[]

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

TypeScript coverage report