APIs-guru.github.io/schema.sql at main · APIs-guru/APIs-guru.github.io

37 lines (32 loc) · 1.01 KB

-- D1 Schema for APIs Guru data
DROP TABLE IF EXISTS Apis;

CREATE TABLE Apis (
  name TEXT PRIMARY KEY,
  categories TEXT, -- JSON string, e.g., '["finance","banking"]'
  tags TEXT, -- JSON string, e.g., '["api","transactions"]'
  added TEXT,
  updated TEXT,
  swaggerUrl TEXT,
  swaggerYamlUrl TEXT,
  description TEXT,
  title TEXT,
  version TEXT,
  logoUrl TEXT,
  externalUrl TEXT,
  contact TEXT, -- JSON string for contact info
  license TEXT, -- JSON string for license info

  created_at TEXT DEFAULT CURRENT_TIMESTAMP,
  updated_at TEXT DEFAULT CURRENT_TIMESTAMP

);
CREATE TABLE ApiVisits (
  api_name TEXT PRIMARY KEY,
  visits INTEGER DEFAULT 0,
  FOREIGN KEY (api_name) REFERENCES Apis(name) ON DELETE CASCADE
);

-- Create indexes for better query performance
CREATE INDEX idx_categories ON Apis(categories);
CREATE INDEX idx_tags ON Apis(tags);
CREATE INDEX idx_added ON Apis(added);
CREATE INDEX idx_updated ON Apis(updated);
CREATE INDEX idx_name_search ON Apis(name);

CREATE INDEX idx_visits ON ApiVisits(visits);

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Expand file tree

Search code, repositories, users, issues, pull requests...

Uh oh!

FilesExpand file tree

schema.sql

Latest commit

History

schema.sql

File metadata and controls

Expand file tree