les

Tables (17)

AIClippingSuggestion

  • id — INT
  • comment — VARCHAR(2000) — ARCHAR(2000
  • notes — TEXT
  • clippingType — ENUM('REPUTED', 'ENFORCED', 'REASON', 'EVIDENCE_REQUEST', 'OTHER') — NOT NULL
  • importanceLevel — ENUM('LOW', 'MEDIUM', 'HIGH') — NOT NULL
  • isSaved — BOOLEAN — NOT NULL
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)
  • clippingId — INT
  • documentId — INT — NOT NULL
  • createdById — INT

AIWrittenDocument

  • id — INT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('PENDING', 'IN_PROGRESS', 'COMPLETED', 'FAILED') — NOT NULL
  • notes — TEXT
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • caseId — INT — NOT NULL
  • forderId — INT — NOT NULL
  • documentId — INT
  • createdById — INT

Attachment

  • id — INT
  • category — ENUM('CASE_DOCUMENT', 'WRITTEN_DOCUMENT', 'EVIDENCE', 'CLIPPING')
  • createdById — INT
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

AttachmentFile

  • id — INT
  • fileName — VARCHAR(500) — NOT NULL
  • filePath — VARCHAR(1000) — NOT NULL
  • fileSize — INT
  • mimeType — VARCHAR(50)
  • fileDate — TIMESTAMP — NOT NULL
  • attachmentId — INT — NOT NULL
  • uploadedById — INT
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

CaseDocument

  • id — INT
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT
  • ocrStep — ENUM('PENDING', 'STEP1_COMPLETED', 'STEP2_COMPLETED', 'STEP3_COMPLETED', 'STEP4_COMPLETED', 'STEP5_COMPLETED', 'FAILED') — NOT NULL
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)
  • folderId — INT
  • caseId — INT — NOT NULL
  • attId — INT — NOT NULL

CaseDocumentFolder

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)
  • caseId — INT — NOT NULL
  • createdById — INT

CaseDocumentSummary

  • id — INT
  • summaryText — TEXT — NOT NULL
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)
  • documentId — INT — NOT NULL
  • createdById — INT

ChatMessage

  • id — INT
  • content — TEXT — NOT NULL
  • messageType — ENUM('USER', 'BOT', 'SYSTEM') — NOT NULL
  • sentAt — TIMESTAMP — NOT NULL
  • senderId — INT
  • roomId — INT — NOT NULL
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

ChatRoom

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • caseId — INT
  • createdById — INT
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

CivilCase

  • id — INT
  • title — VARCHAR(100) — NOT NULL
  • caseNumber — VARCHAR(100)
  • description — VARCHAR(500)
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

Clipping

  • id — INT
  • comment — VARCHAR(2000) — ARCHAR(2000
  • notes — TEXT
  • x — FLOAT
  • y — FLOAT
  • pageNumber — INT
  • attachmentId — INT
  • clippingType — ENUM('REPUTED', 'ENFORCED', 'REASON', 'EVIDENCE_REQUEST', 'OTHER') — NOT NULL
  • importanceLevel — ENUM('LOW', 'MEDIUM', 'HIGH')
  • isAiGenerated — BOOLEAN — NOT NULL
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)
  • documentId — INT — NOT NULL
  • createdById — INT

ClippingWord

  • id — INT
  • word — TEXT — NOT NULL
  • x — FLOAT
  • y — FLOAT
  • pageNumber — INT
  • clippingId — INT — NOT NULL
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

DocumentOCRStep

  • id — INT
  • step — ENUM('PENDING', 'STEP1_COMPLETED', 'STEP2_COMPLETED', 'STEP3_COMPLETED', 'STEP4_COMPLETED', 'STEP5_COMPLETED', 'FAILED') — NOT NULL
  • startedAt — TIMESTAMP
  • completedAt — TIMESTAMP
  • errorMsg — VARCHAR(500)
  • caseDocumentId — INT — NOT NULL
  • updatedById — INT
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

EvidenceRequest

  • id — INT
  • requestComment — VARCHAR(2000) — ARCHAR(2000
  • responseComment — VARCHAR(2000) — ARCHAR(2000
  • requestedAt — TIMESTAMP — NOT NULL
  • respondedAt — TIMESTAMP
  • responseAttId — INT
  • requestStatus — ENUM('PENDING', 'SENT', 'RESPONDED', 'CANCELLED', 'FAILED') — NOT NULL
  • documentId — INT
  • caseId — INT — NOT NULL
  • requestedById — INT
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

User

  • id — INT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(500) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)

WrittenDocument

  • id — INT
  • title — VARCHAR(100) — NOT NULL
  • notes — TEXT
  • submittedAt — TIMESTAMP
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)
  • caseId — INT — NOT NULL
  • folderId — INT — NOT NULL
  • documentId — INT
  • createdById — INT

WrittenDocumentSource

  • id — INT
  • title — VARCHAR(200) — NOT NULL
  • notes — TEXT
  • status — ENUM('ACTIVATED', 'DEACTIVATED') — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • etc — VARCHAR(500)
  • WrittenDocumentId — INT
  • createdById — INT