Snippet content copied to clipboard.
Are you sure to delete this snippet? No, don't delete
  1. -- DDL generated by Postico 1.5.20
  2. -- Not all database features are supported. Do not use for backup.
  3. ​
  4. -- Table Definition ----------------------------------------------
  5. ​
  6. CREATE TABLE articles (
  7. id uuid DEFAULT uuid_generate_v4() PRIMARY KEY,
  8. iid SERIAL,
  9. path text NOT NULL,
  10. domain text NOT NULL,
  11. title text,
  12. referenced_domains jsonb DEFAULT '[]'::jsonb,
  13. created_at timestamp without time zone,
  14. updated_at timestamp without time zone,
  15. published_at timestamp without time zone,
  16. sentiment_score double precision,
  17. sentiment_magnitude double precision,
  18. excerpt text,
  19. referenced_domains_array text[],
  20. metadata jsonb
  21. );
  22. ​
  23. -- Indices -------------------------------------------------------
  24. ​
  25. CREATE UNIQUE INDEX articles_pkey ON articles(id uuid_ops);
  26. CREATE INDEX articles_domain_index ON articles(domain text_ops);
  27. CREATE UNIQUE INDEX articles_domain_path_index ON articles(domain text_ops,path text_ops);
  28. CREATE UNIQUE INDEX articles_iid_index ON articles(iid int4_ops);
  29. CREATE INDEX articles_path_gin_index ON articles USING GIN (path gin_trgm_ops);
  30. CREATE INDEX articles_published_at_index ON articles(published_at timestamp_ops);
  31. CREATE INDEX articles_referenced_domains_array_index ON articles USING GIN (referenced_domains_array array_ops);
  32. CREATE INDEX articles_referenced_domains_index ON articles USING GIN (referenced_domains jsonb_ops);
  33. CREATE INDEX articles_referenced_domains_po ON articles USING GIN (referenced_domains jsonb_path_ops);
  34. CREATE INDEX articles_title_gin_index ON articles USING GIN (title gin_trgm_ops);

Edit this Snippet