不要混合独特的概念键和主键。您可以很好地添加一个唯一键，跨越三个等级，路径和 class_id 。这样，可能没有两行这三列相同的值。当你写的时候，你不想把这三个作为一个复合的主键，我不知道一个复合的唯一的补充键是否会更好。如果没有，您必须澄清复合键是否可以接受。

要创建唯一键，可以使用以下SQL 声明：

  ALTER TABLE学生ADD UNIQUE gsc（成绩，路基，class_id）; 
 

单词 gsc 只有一个名字我从主要专栏的缩写组成;使用您想要的任何名称，因为除非您想要识别某些 EXPLAIN 输出或类似的密钥，否则几乎不起作用。

I am making a database of students in one school.Here is what I have so far:

If you don't like reading jump to the "In short" part

The problem is that I'm not happy with this design. I want the combination of grade, subgrade and id_class to be unique and to serve as a primary key for the students table. I can remove the student_id and make a composite key from the 3 but I don't want that either. Maybe I should make another table lets say combination_id where grade, subgrade and id_class are foreign keys and there is one extra column comb_id that serves as ID for the table. And all the columns will be Primary Keys. But the problem is that those 3 columns can still repeat because of that extra column (comb_id). For example I can have the same grade, subgrade and class_id but different comb_id which will make the row valid because of the composite key of the 4 columns of the table (combination_id).

In short I want students_id to remain the only primary key of the table but to be a foreign key to another table which is somehow unique combination of grades, subgrade and class_id.

If I was not clear enough ask in the comments below and thank you in advance.

PS I'm sorry for the indescriptive title but I'm bad at naming

EDIT 1: To be more clear: grade can be 1 to 12 subgrade can be a to j id_class can be 1 to 30 and it is your number in class

So a student can be from 7b class and his number in class - 5

Don't mix the concepts of unique keys and primary keys. You can very well add a unique key spanning the three columns grades, subgrade and class_id. That way, no two rows could have the same values for these three columns. As you write that you don't want to have these three as a composite primary key, I'm not sure whether a composite unique supplemental key would be any better. If not, you'll have to clarify when composite keys are acceptable.

To create a unique key, you can use the following SQL statement:

ALTER TABLE students ADD UNIQUE gsc (grades, subgrade, class_id);

The word gsc there is just a name I made up from the initials of the key columns; use whatever name you want, as it hardly matters unless you want to identify the key in some EXPLAIN output or similar.