20211106123100_create_package_components.sql

-- migrate:up
-- A package component is the smallest unit of a Hackage package.
-- Each package may contain a default, top-level library, as well as
-- sub-libraries, executables, test suites & benchmark.
-- All these are components have many dependency requirements
create type component as enum ('library', 'executable', 'test', 'benchmark', 'foreign-library');

create table if not exists package_components (
  package_component_id uuid primary key,
  release_id uuid references releases not null,
  component_name text not null,
  component_type component not null,
  component_metadata jsonb not null default '{}'
);

create index on "package_components" (release_id);