USER_CONS_COLUMNS is the Oracle view that shows the mapping between constraints and the columns they reference. It contains constraint names, table names, column names, and position - essential for understanding which columns participate in multi-column constraints like composite primary keys.