schema.ts

import { Selectable, Insertable, ColumnType } from 'kysely';

const DEFAULT = {};

export const docketEntryTableDefinition = {
  action: DEFAULT as string | null,
  additionalInfo: DEFAULT as string | null,
  additionalInfo2: DEFAULT as string | null,
  addToCoversheet: DEFAULT as boolean | null,
  archived: DEFAULT as boolean | null,
  attachments: DEFAULT as boolean | null,
  caseType: DEFAULT as string | null,
  certificateOfService: DEFAULT as boolean | null,
  certificateOfServiceDate: DEFAULT as Date | null,
  createdAt: DEFAULT as Date,
  date: DEFAULT as Date | null,
  docketEntryId: DEFAULT as string,
  docketNumber: DEFAULT as string,
  docketNumbers: DEFAULT as string | null,
  documentContentsId: DEFAULT as string | null,
  documentIdBeforeSignature: DEFAULT as string | null,
  documentStorageId: DEFAULT as string | null,
  documentTitle: DEFAULT as string,
  documentType: DEFAULT as string | null,
  draftOrderState: DEFAULT as ColumnType<
    Record<string, any>,
    string,
    string
  > | null,
  editState: DEFAULT as string | null,
  eventCode: DEFAULT as string,
  filedBy: DEFAULT as string | null,
  filedByRole: DEFAULT as string | null,
  filers: DEFAULT as ColumnType<string[], string, string>,
  filingDate: DEFAULT as Date,
  freeText: DEFAULT as string | null,
  hasOtherFilingParty: DEFAULT as boolean | null,
  hasSupportingDocuments: DEFAULT as boolean | null,
  index: DEFAULT as number | null,
  isAutoGenerated: DEFAULT as boolean | null,
  isDraft: DEFAULT as boolean | null,
  isFileAttached: DEFAULT as boolean | null,
  isLegacy: DEFAULT as boolean | null,
  isLegacySealed: DEFAULT as boolean | null,
  isLegacyServed: DEFAULT as boolean | null,
  isOnDocketRecord: DEFAULT as boolean,
  isPaper: DEFAULT as boolean | null,
  isPendingService: DEFAULT as boolean | null,
  isSealed: DEFAULT as boolean | null,
  isStricken: DEFAULT as boolean | null,
  judge: DEFAULT as string | null,
  lodged: DEFAULT as boolean | null,
  mailingDate: DEFAULT as string | null,
  noticeIssuedDate: DEFAULT as Date | null,
  numberOfPages: DEFAULT as number | null,
  objections: DEFAULT as string | null,
  ordinalValue: DEFAULT as string | null,
  otherFilingParty: DEFAULT as string | null,
  otherIteration: DEFAULT as string | null,
  partyIrsPractitioner: DEFAULT as boolean | null,
  pending: DEFAULT as boolean | null,
  previousDocument: DEFAULT as ColumnType<
    {
      docketEntryId?: string;
      documentTitle: string;
      documentType: string;
    },
    string,
    string
  > | null,
  privatePractitioners: DEFAULT as ColumnType<
    {
      name: string;
      partyPrivatePractitioner?: boolean;
    }[],
    string,
    string
  > | null,
  processingStatus: DEFAULT as string,
  receivedAt: DEFAULT as Date,
  redactionAcknowledgement: DEFAULT as boolean | null,
  relationship: DEFAULT as string | null,
  scenario: DEFAULT as string | null,
  sealedTo: DEFAULT as string | null,
  secondaryDocument: DEFAULT as ColumnType<
    Record<string, any>,
    string,
    string
  > | null,
  servedAt: DEFAULT as Date | null,
  servedParties: DEFAULT as ColumnType<
    {
      name: string;
      role?: string;
      email?: string;
    }[],
    string,
    string
  > | null,
  servedPartiesCode: DEFAULT as string | null,
  serviceDate: DEFAULT as Date | null,
  serviceStamp: DEFAULT as string | null,
  signedAt: DEFAULT as string | null,
  signedByUserId: DEFAULT as string | null,
  signedJudgeName: DEFAULT as string | null,
  stampData: DEFAULT as ColumnType<Record<string, any>, string, string> | null,
  strickenAt: DEFAULT as Date | null,
  strickenBy: DEFAULT as string | null,
  strickenByUserId: DEFAULT as string | null,
  supportingDocument: DEFAULT as string | null,
  taxYear: DEFAULT as string | null,
  trialLocation: DEFAULT as string | null,
  userId: DEFAULT as string | null,
};

export type DocketEntryTable = typeof docketEntryTableDefinition;

export const DW_DOCKET_ENTRY_COLUMNS = Object.keys(
  docketEntryTableDefinition,
) as Array<keyof DocketEntryTable>;

export type DocketEntryKysely = Selectable<DocketEntryTable>;
export type NewDocketEntryKysely = Insertable<DocketEntryTable>;

///////////////////////////////////

export const docketEntryRelatedDocketEntryTableDefinition = {
  docketNumber: DEFAULT as string,
  primaryDocketEntryId: DEFAULT as string,
  secondaryDocketEntryId: DEFAULT as string,
  disposition: DEFAULT as string,
  served: DEFAULT as boolean,
};

export type DocketEntryRelatedDocketEntryTable =
  typeof docketEntryRelatedDocketEntryTableDefinition;
export const DW_DOCKET_ENTRY_ORDER_MOTION_COLUMNS = Object.keys(
  docketEntryRelatedDocketEntryTableDefinition,
) as Array<keyof DocketEntryRelatedDocketEntryTable>;

export type DocketEntryOrderMotionKysely =
  Selectable<DocketEntryRelatedDocketEntryTable>;
export type NewDocketEntryOrderMotionKysely =
  Insertable<DocketEntryRelatedDocketEntryTable>;