CREATE TABLE students tGroups StudGroup TEXT PRIMARY KEY NOT NULL Lang

1
2
3
4
5
6
7
CREATE TABLE students.tGroups(
StudGroup TEXT PRIMARY KEY NOT NULL,
Language TEXT NOT NULL,
CHECK (StudGroup ~'R+[D|A]+[I|D|B|K|E|P]+[R|M]+[0-9]{2}'),
CHECK (Language in ('rus','eng','est'))
);