github.com/supabase/cli@v1.168.1/internal/utils/parser/testdata/split_09.sql (about)

     1  
     2  
     3  CREATE TABLE "blocks"."child_blocks"
     4  (
     5      parent_uuid  UUID    NOT NULL,
     6      column_index INT     NOT NULL,
     7      child_uuids  UUID [] NOT NULL,
     8      CONSTRAINT child_blocks_parent_uuid_index_pk PRIMARY KEY (parent_uuid, column_index),
     9      CONSTRAINT child_blocks_block_uuid_fk FOREIGN KEY (parent_uuid) REFERENCES "blocks"."block" (uuid) ON DELETE CASCADE
    10  
    11      -- TODO add a trigger to sanitize child_uuids when a block record is deleted
    12  );