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