CREATE TABLE acs_enum_values (
	attribute_id	 integer NOT NULL,
	enum_value	 varchar(1000) NOT NULL,
	pretty_name	 varchar(100) NOT NULL,
	sort_order	 integer NOT NULL,
	PRIMARY KEY (attribute_id, enum_value),
	CONSTRAINT asc_enum_values_attr_id_fk REFERENCES acs_attributes ()
);

CREATE INDEX acs_enum_values_attr_id_idx ON acs_enum_values (attribute_id);
CREATE UNIQUE INDEX acs_enum_values_pretty_name_un ON acs_enum_values (attribute_id, pretty_name);
CREATE UNIQUE INDEX acs_enum_values_sort_order_un ON acs_enum_values (attribute_id, sort_order);

-- Table size: 0 bytes
-- Table rows: 0

Tables: