Creating a TimescaleDB Hypertable

-- This is an empty migration.

-- Enable TimescaleDB
CREATE EXTENSION IF NOT EXISTS timescaledb;


-- Add TimescaleDB-specific commands below
SELECT create_hypertable('"FundHistory"', '"createdAt"', migrate_data => true);

-- Enable compression
ALTER TABLE '"FundHistory"' SET (timescaledb.compress, timescaledb.compress_segmentby = 'fundId');

-- Add a compression policy
SELECT add_compression_policy('"FundHistory"', INTERVAL '7 days');

-- This is an empty migration.

-- Enable TimescaleDB
CREATE EXTENSION IF NOT EXISTS timescaledb;


-- Add TimescaleDB-specific commands below
SELECT create_hypertable('"FundHistory"', '"createdAt"', migrate_data => true);

-- Enable compression
ALTER TABLE '"FundHistory"' SET (timescaledb.compress, timescaledb.compress_segmentby = 'fundId');

-- Add a compression policy
SELECT add_compression_policy('"FundHistory"', INTERVAL '7 days');

// Tracks the history for a Fund account
model FundHistory {
  id              BigInt  @id @default(autoincrement())
  createdAt       DateTime? @default(now())
  status          Json
  nav             Decimal
  fundId String  @map("fund_id")
  strategyId BigInt  @map("strategy_id") @default(0)

  fund  Fund @relation(fields: [fundId], references: [id])
}

// Tracks the history for a Fund account
model FundHistory {
  id              BigInt  @id @default(autoincrement())
  createdAt       DateTime? @default(now())
  status          Json
  nav             Decimal
  fundId String  @map("fund_id")
  strategyId BigInt  @map("strategy_id") @default(0)

  fund  Fund @relation(fields: [fundId], references: [id])
}