Entities

entity User {
    id: uuid primary,
    email: string unique,
    name: string,
    created_at: timestamp default now(),
}

entity User { ... }          // ✓ Good
entity OrderItem { ... }     // ✓ Good
entity user { ... }          // ✗ Bad - lowercase
entity Users { ... }         // ✗ Bad - plural

entity Product {
    id: uuid primary,
    name: string,
    price: decimal,
    stock: int,
}

entity Order {
    id: uuid primary,
    user_id: uuid,
    user: User,              // belongs-to relation
    items: [OrderItem] via order_id,  // has-many relation
}

entity User {
    id: uuid primary,
    session: string @cache,
    monthly_spent: decimal @olap,
}

entity User {
    id: uuid primary,
    email: string unique,
    name: string,
    age: int nullable,
    created_at: timestamp default now(),
    
    // Relations
    orders: [Order] via user_id,
    posts: [Post] via author_id,
    
    // Backend optimizations
    session: string @cache,
    monthly_spent: decimal @olap,
}

entity Order {
    id: uuid primary,
    total: decimal,
    status: string,
    created_at: timestamp default now(),
    user_id: uuid,
    
    // Relations
    user: User,
    items: [OrderItem] via order_id,
}

entity OrderItem {
    id: uuid primary,
    quantity: int,
    price: decimal,
    order_id: uuid,
    
    // Relations
    order: Order,
}

entity Post {
    id: uuid primary,
    title: string,
    content: string,
    author_id: uuid,
    created_at: timestamp default now(),
    
    // Relations
    author: User,
}

entity Product {
    // Identity
    id: uuid primary,
    name: string,
    
    // Pricing
    price: decimal,
    stock: int,
    
    // Backend optimizations
    views_today: int @cache,
    monthly_sales: decimal @olap,
    embedding: vector(384) @vector,
}