Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
//! The one catalog every stage's tests run against.
use models_databases::{ColumnId, DatabaseId, OptionId, TableId, ViewId};
use uuid::Uuid;
use crate::catalog::{
Catalog, Column, ColumnKind, EntityKind, SelectOption, Table, TableSource, people_table,
};
pub const CRM: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb0));
pub const SALES: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb1));
pub const MACRO: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb2));
pub const DEALS: TableId = TableId::from_uuid(Uuid::from_u128(0xd0));
pub const PEOPLE: TableId = TableId::from_uuid(Uuid::from_u128(0xd1));
pub const SALES_DEALS: TableId = TableId::from_uuid(Uuid::from_u128(0xd2));
pub const NAME: Uuid = Uuid::from_u128(0x01);
pub const AMOUNT: Uuid = Uuid::from_u128(0x02);
pub const STAGE: Uuid = Uuid::from_u128(0x03);
pub const CLOSED_AT: Uuid = Uuid::from_u128(0x04);
pub const OWNER: Uuid = Uuid::from_u128(0x05);
pub const TAGS: Uuid = Uuid::from_u128(0x06);
pub const DONE: Uuid = Uuid::from_u128(0x07);
pub const WEBSITE: Uuid = Uuid::from_u128(0x08);
pub const LEAD: OptionId = OptionId::from_uuid(Uuid::from_u128(0x31));
pub const WON: OptionId = OptionId::from_uuid(Uuid::from_u128(0x30));
pub const VIP: OptionId = OptionId::from_uuid(Uuid::from_u128(0x32));
pub const TASKS: TableId = TableId::from_uuid(Uuid::from_u128(0xd3));
pub const TITLE: Uuid = Uuid::from_u128(0x11);
pub const PRIORITY: Uuid = Uuid::from_u128(0x12);
pub const ASSIGNEES: Uuid = Uuid::from_u128(0x13);
pub const DEAL: Uuid = Uuid::from_u128(0x14);
pub const HIGH: OptionId = OptionId::from_uuid(Uuid::from_u128(0x41));
pub const LOW: OptionId = OptionId::from_uuid(Uuid::from_u128(0x42));
/// `crm.deals` with one column of every kind, `crm.people` (sharing the
/// `name` definition with `crm.deals`), a second `deals` table in another
/// database so bare names can be ambiguous, `macro.tasks` with people
/// assigned and a deal linked, and the platform `macro.people`.
pub fn catalog() -> Catalog {
Catalog {
scope: None,
tables: vec![
Table {
id: DEALS,
database_id: CRM,
database: "crm".into(),
name: "deals".into(),
columns: vec![
Column {
id: NAME,
placement: ColumnId::from_uuid(NAME),
name: "name".into(),
kind: ColumnKind::Text,
formula: None,
},
Column {
id: AMOUNT,
placement: ColumnId::from_uuid(AMOUNT),
name: "amount".into(),
kind: ColumnKind::Number,
formula: None,
},
Column {
id: STAGE,
placement: ColumnId::from_uuid(STAGE),
name: "stage".into(),
kind: ColumnKind::Select {
multi: false,
options: vec![
SelectOption {
id: LEAD,
label: "Lead".into(),
},
SelectOption {
id: WON,
label: "Won".into(),
},
],
},
formula: None,
},
Column {
id: CLOSED_AT,
placement: ColumnId::from_uuid(CLOSED_AT),
name: "closed at".into(),
kind: ColumnKind::Date,
formula: None,
},
Column {
id: OWNER,
placement: ColumnId::from_uuid(OWNER),
name: "owner".into(),
kind: ColumnKind::Entity {
multi: false,
target: EntityKind::User,
},
formula: None,
},
Column {
id: TAGS,
placement: ColumnId::from_uuid(TAGS),
name: "tags".into(),
kind: ColumnKind::Select {
multi: true,
options: vec![SelectOption {
id: VIP,
label: "vip".into(),
}],
},
formula: None,
},
Column {
id: DONE,
placement: ColumnId::from_uuid(DONE),
name: "done".into(),
kind: ColumnKind::Boolean,
formula: None,
},
Column {
id: WEBSITE,
placement: ColumnId::from_uuid(WEBSITE),
name: "website".into(),
kind: ColumnKind::Link,
formula: None,
},
],
source: TableSource::Database,
},
Table {
id: PEOPLE,
database_id: CRM,
database: "crm".into(),
name: "people".into(),
columns: vec![Column {
id: NAME,
placement: ColumnId::from_uuid(NAME),
name: "name".into(),
kind: ColumnKind::Text,
formula: None,
}],
source: TableSource::Database,
},
Table {
id: SALES_DEALS,
database_id: SALES,
database: "sales".into(),
name: "deals".into(),
columns: vec![],
source: TableSource::Database,
},
Table {
id: TASKS,
database_id: MACRO,
database: "macro".into(),
name: "tasks".into(),
columns: vec![
Column {
id: TITLE,
placement: ColumnId::from_uuid(TITLE),
name: "title".into(),
kind: ColumnKind::Text,
formula: None,
},
Column {
id: PRIORITY,
placement: ColumnId::from_uuid(PRIORITY),
name: "priority".into(),
kind: ColumnKind::Select {
multi: false,
options: vec![
SelectOption {
id: HIGH,
label: "High".into(),
},
SelectOption {
id: LOW,
label: "Low".into(),
},
],
},
formula: None,
},
Column {
id: ASSIGNEES,
placement: ColumnId::from_uuid(ASSIGNEES),
name: "assignees".into(),
kind: ColumnKind::Entity {
multi: true,
target: EntityKind::User,
},
formula: None,
},
Column {
id: DEAL,
placement: ColumnId::from_uuid(DEAL),
name: "deal".into(),
kind: ColumnKind::Entity {
multi: false,
target: EntityKind::Row,
},
formula: None,
},
],
source: TableSource::Database,
},
people_table(),
],
}
}
pub const WORK: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb3));
pub const ISSUES: TableId = TableId::from_uuid(Uuid::from_u128(0xd4));
pub const SUMMARY: Uuid = Uuid::from_u128(0x51);
pub const SUMMARY_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x61));
pub const POINTS: Uuid = Uuid::from_u128(0x52);
pub const POINTS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x62));
pub const STATUS: Uuid = Uuid::from_u128(0x53);
pub const STATUS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x63));
pub const DUE: Uuid = Uuid::from_u128(0x54);
pub const DUE_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x64));
pub const BLOCKED: Uuid = Uuid::from_u128(0x55);
pub const BLOCKED_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x65));
pub const LABELS: Uuid = Uuid::from_u128(0x56);
pub const LABELS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x66));
pub const ASSIGNEE: Uuid = Uuid::from_u128(0x57);
pub const ASSIGNEE_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x67));
pub const REVIEWERS: Uuid = Uuid::from_u128(0x58);
pub const REVIEWERS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x68));
pub const SPEC: Uuid = Uuid::from_u128(0x59);
pub const SPEC_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x69));
pub const PARENT: Uuid = Uuid::from_u128(0x5a);
pub const PARENT_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x6a));
pub const TODO: OptionId = OptionId::from_uuid(Uuid::from_u128(0x71));
pub const DOING: OptionId = OptionId::from_uuid(Uuid::from_u128(0x72));
pub const WONT_DO: OptionId = OptionId::from_uuid(Uuid::from_u128(0x73));
pub const BUG: OptionId = OptionId::from_uuid(Uuid::from_u128(0x74));
pub const FEATURE: OptionId = OptionId::from_uuid(Uuid::from_u128(0x75));
/// `work.issues`, the table views are tested on: one column of every kind,
/// each placed under an id of its own, so a view (which names placements)
/// and a query (which names definitions) can be told apart.
pub fn issues_catalog() -> Catalog {
Catalog {
scope: None,
tables: vec![Table {
id: ISSUES,
database_id: WORK,
database: "work".into(),
name: "issues".into(),
columns: vec![
Column {
id: SUMMARY,
placement: SUMMARY_PLACEMENT,
name: "summary".into(),
kind: ColumnKind::Text,
formula: None,
},
Column {
id: POINTS,
placement: POINTS_PLACEMENT,
name: "points".into(),
kind: ColumnKind::Number,
formula: None,
},
Column {
id: STATUS,
placement: STATUS_PLACEMENT,
name: "status".into(),
kind: ColumnKind::Select {
multi: false,
options: vec![
SelectOption {
id: TODO,
label: "Todo".into(),
},
SelectOption {
id: DOING,
label: "Doing".into(),
},
SelectOption {
id: WONT_DO,
label: "Won't do".into(),
},
],
},
formula: None,
},
Column {
id: DUE,
placement: DUE_PLACEMENT,
name: "due date".into(),
kind: ColumnKind::Date,
formula: None,
},
Column {
id: BLOCKED,
placement: BLOCKED_PLACEMENT,
name: "blocked".into(),
kind: ColumnKind::Boolean,
formula: None,
},
Column {
id: LABELS,
placement: LABELS_PLACEMENT,
name: "labels".into(),
kind: ColumnKind::Select {
multi: true,
options: vec![
SelectOption {
id: BUG,
label: "bug".into(),
},
SelectOption {
id: FEATURE,
label: "feature".into(),
},
],
},
formula: None,
},
Column {
id: ASSIGNEE,
placement: ASSIGNEE_PLACEMENT,
name: "assignee".into(),
kind: ColumnKind::Entity {
multi: false,
target: EntityKind::User,
},
formula: None,
},
Column {
id: REVIEWERS,
placement: REVIEWERS_PLACEMENT,
name: "reviewers".into(),
kind: ColumnKind::Entity {
multi: true,
target: EntityKind::User,
},
formula: None,
},
Column {
id: SPEC,
placement: SPEC_PLACEMENT,
name: "\"spec\" link".into(),
kind: ColumnKind::Link,
formula: None,
},
Column {
id: PARENT,
placement: PARENT_PLACEMENT,
name: "parent".into(),
kind: ColumnKind::Entity {
multi: false,
target: EntityKind::Row,
},
formula: None,
},
],
source: TableSource::Database,
}],
}
}
pub const ISSUES_VIEW: ViewId = ViewId::from_uuid(Uuid::from_u128(0x7e1));
/// A view of `work.issues`.
pub fn issues_view(
query: models_databases::views::ViewQuery,
layout: models_databases::views::ViewLayout,
) -> models_databases::views::DatabaseView {
use chrono::{TimeZone, Utc};
models_databases::views::DatabaseView {
id: ISSUES_VIEW,
database_id: WORK,
table_id: ISSUES,
name: "Open work".into(),
position: "80".parse().unwrap(),
query,
layout,
created_at: Utc.with_ymd_and_hms(2026, 9, 1, 0, 0, 0).unwrap(),
updated_at: Utc.with_ymd_and_hms(2026, 9, 1, 0, 0, 0).unwrap(),
}
}