Cursor rule

1---
2description: Schema and data model documentation for LIMS system focusing on experimental data and user authentication
3globs: /db/**/*.{sql,ts},/packages/db/**/*,/lims-core/src/models/**/*
4alwaysApply: false
5---
6 
7 
8# data-models
9 
10## Core Database Schema
11 
12### Experiment Data Model
13- Customized schema for CRISPR experiments tracking:
14  - Sequences and guide RNAs
15  - Off-target sites
16  - Experimental metadata
17  - DNA sequence validation (ATCGN pattern)
18 
19File path: `/db/migrations/*`
20Importance: 95
21 
22### Guide RNA Data Model
23- Stores guide RNA information:
24  - Efficiency and specificity scores (0-1 range)
25  - Target sequence data
26  - On/off-target predictions
27  - Associated experimental metadata
28 
29File path: `/packages/db/src/types.ts`
30Importance: 90
31 
32### Sequence Analysis Model
33- Captures AI-generated analysis results:
34  - GC content analysis
35  - Quality assessment scores
36  - Optimization suggestions
37  - Sequence transformations
38 
39File path: `/packages/db/src/column-types.ts`
40Importance: 85
41 
42### User Authentication Model
43- Manages user data and authentication:
44  - Role-based access control
45  - Session management
46  - OAuth integration data
47  - User preferences
48 
49File path: `/packages/db/src/db.ts`
50Importance: 75
51 
52### Data Relationships
53- Experiment to Guide RNA: One-to-many
54- Guide RNA to Off-target Sites: One-to-many
55- Users to Experiments: Many-to-many
56- Sequences to Analysis Results: One-to-one
57 
58File path: `/packages/db/src/types.gen.ts`
59Importance: 80
60 
61$END$
62 
63 If you're using this file in context, clearly say in italics in one small line that "Context added by Giga data-models".