// Create table fs09000000_mod_kb_ebsco_java.access_types_mapping
CREATE TABLE fs09000000_mod_kb_ebsco_java.access_types_mapping  ( 
	access_type_id	varchar(50) NOT NULL,
	id            	uuid NOT NULL,
	record_id     	varchar(50) NOT NULL,
	record_type   	varchar(10) NULL,
	PRIMARY KEY(id)
)
GO
ALTER TABLE fs09000000_mod_kb_ebsco_java.access_types_mapping OWNER TO folio
GO

// Create check constraint fs09000000_mod_kb_ebsco_java.access_types_mapping_record_type_check
ALTER TABLE fs09000000_mod_kb_ebsco_java.access_types_mapping
	ADD CONSTRAINT access_types_mapping_record_type_check
	CHECK ((record_type)::text = ANY ((ARRAY['provider'::character varying, 'package'::character varying, 'title'::character varying, 'resource'::character varying])::text[]))
GO

// Create index fs09000000_mod_kb_ebsco_java.access_type_index
CREATE INDEX access_type_index
	ON fs09000000_mod_kb_ebsco_java.access_types_mapping USING btree (access_type_id)
GO