CREATE GRAIN umk VERSION '1.03';

-- *** TABLES ***


/**Специальности*/
CREATE TABLE speciality(
  uid VARCHAR(36) NOT NULL,
  /**Наименование*/
  name TEXT,
  shortname TEXT,
  /**Уровень образования: ВУЗ, Средне-специальное,...*/
  education_level INT,
  sort TEXT,
  is_actual BIT DEFAULT 'TRUE',
  CONSTRAINT pk_speciality PRIMARY KEY (uid)
);


-- *** FOREIGN KEYS ***
ALTER TABLE speciality ADD CONSTRAINT fk_nci_speciality_nci_2D115F4B FOREIGN KEY (education_level) REFERENCES nci.education_level(id);