CREATE TABLE ams_list_attribute_map (
	list_id	 integer NOT NULL,
	attribute_id	 integer NOT NULL,
	sort_order	 integer NOT NULL,
	required_p	 bool NOT NULL,
	section_heading	 varchar(200),
	html_options	 varchar(1000),
	CONSTRAINT ams_list_attribute_map_attribute_id_fk REFERENCES acs_attributes (),
	CONSTRAINT ams_list_attribute_map_list_id_fk REFERENCES ams_lists ()
);

CREATE UNIQUE INDEX ams_list_attribute_map_list_id_key ON ams_list_attribute_map (list_id, attribute_id);
CREATE UNIQUE INDEX ams_list_attribute_map_list_id_key1 ON ams_list_attribute_map (list_id, sort_order);

-- Table size: 8,192 bytes
-- Table rows: 15

Tables: