Harbard asked
Hi, it’s me again !
So I’m using my DB to handle translation, and I’d like to set foreign keys as primary values to avoid getting IDs in my tables.
I see in the code https://github.com/nocodb/nocodb/blob/master/packages/nc-gui/components/project/spreadsheet/components/virtualHeaderCell.vue#L69 that the setAsPrimaryValue is not available for foreign keys, is there a technical reason. Is it worth that I spend some time trying to implement this in a PR ?
```sql
drop table if exists labels cascade;
CREATE TABLE labels (
id serial primary key,
en text,
fr text,
de text
);
drop table if exists schools cascade;
CREATE TABLE schools (
id serial primary key,
school_label int references labels(id)
);
drop table if exists class_rooms cascade;
CREATE TABLE class_rooms (
id serial primary key,
class_label int references labels(id),
school_id int references schools(id)
);
drop table if exists students cascade;
CREATE TABLE students (
id serial primary key,
std_label int references labels(id),
class_id int references class_rooms(id)
);
INSERT INTO public.labels (en,fr,de) VALUES
(‘school_1’,‘ecole_1’,NULL),
(‘school_2’,‘ecole_2’,NULL),
(‘class_1’,‘classe_1’,NULL),
(‘class_2’,‘classe_2’,NULL),
(‘class_3’,‘classe_3’,NULL),
(‘std_1’,‘eleve_1’,NULL),
(‘std_2’,‘eleve_2’,NULL),
(‘std_3’,‘eleve_3’,NULL),
(‘std_4’,‘eleve_4’,NULL),
(‘std_5’,‘eleve_5’,NULL);
INSERT INTO public.schools (school_label) VALUES
(1),
(2);
INSERT INTO public.class_rooms (class_label,school_id) VALUES
(3,1),
(4,1),
(5,2);
INSERT INTO public.students (std_label,class_id) VALUES
(6,1),
(7,1),
(8,2),
(9,3),
(10,3);
```
o1lab replied
and hence we are avoiding that to be set as primary values
