Unique-constraint is an index that sets one or multiple fields to be unique in a data entity
Does the UNIQUE constraint specified on a column or group of columns affect the write performance of Postgres DB in …
performance postgresql unique-constraintI'm trying to create a UNIQUE INDEX constraint for two columns, but only when another column contains the value 1. For …
mysql unique-constraintI have a basic users table I want to create in MySQL. I do not want duplicate emails or duplicate …
mysql database-design unique create-table unique-constraintI have two models with a HABTM relationship - User and Role. user - has_and_belongs_to_many :roles …
ruby-on-rails has-and-belongs-to-many unique-constraintI have created the following entity bean, and specified two columns as being unique. Now my problem is that the …
mysql jpa jboss unique-constraintOn one of my PostgreSQL tables, I have a set of two fields that will be defined as being unique …
postgresql indexing unique-constraint unique-indexI'm trying to come up with a PostgreSQL schema for host data that's currently in an LDAP store. Part of …
arrays postgresql database-design ldap unique-constraintI want to make sure that all rows in my table have a unique combination of two fields, and I …
hibernate jpa annotations unique-constraintI keep getting: SQL error: ERROR: could not create unique index "service_import_checksum_key" DETAIL: Key (checksum)=() is duplicated. …
postgresql constraints unique-constraint unique-keyI created the table t1t2 which connects tables t1 and t2 as follows: CREATE TABLE t1t2( id integer …
sqlite constraints unique-constraint