/
hans-gluck
/
WorkBook
Обзор
Документация
Войти
/
hans-gluck
/
WorkBook
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
sql/schema/02_dictionaries.sql
183 строки
6 KB
Иван
upload files
22 окт 2025, 00:37
22 окт 2025, 00:37
a657147
Код
Авторство
О чём код?
-- ===================================================== -- SPRAVOCHNIKI (DICTIONARIES) -- ===================================================== -- Spravochnik: Vid RM CREATE TABLE dict_vid_rm ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_vid_rm IS 'Spravochnik vidov rabochikh mest'; -- Spravochnik: Kategoriya RM CREATE TABLE dict_kategoria_rm ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_kategoria_rm IS 'Kategoriya RM'; -- Spravochnik: Sostoyanie RM CREATE TABLE dict_sostoyanie_rm ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_sostoyanie_rm IS 'Sostoyanie RM'; -- Spravochnik: Status RM CREATE TABLE dict_status_rm ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_status_rm IS 'Status RM'; -- Spravochnik: Tip zon CREATE TABLE dict_tip_zon ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_tip_zon IS 'Spravochnik tipov zon'; -- Spravochnik: Tip oborudovaniya CREATE TABLE dict_tip_oborudovania ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_tip_oborudovania IS 'Tipy oborudovaniya'; -- Spravochnik: Rol polzovatelya CREATE TABLE dict_rol_polzovatelya ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_rol_polzovatelya IS 'Roli polzovateley sistemy'; -- Spravochnik: Status zanyatiya CREATE TABLE dict_status_zanyatia ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_status_zanyatia IS 'Status zanyatiya'; -- Spravochnik: Svyaz GOSB CREATE TABLE dict_svyaz_gosb ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, gosb_code VARCHAR(100), name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_svyaz_gosb IS 'Svyaz koda GOSB s polnomochiyami administratora'; -- Spravochnik: Sostoyanie CREATE TABLE dict_sostoyanie ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_sostoyanie IS 'Sostoyanie'; -- Spravochnik: Status polzovaniya CREATE TABLE dict_status_polzovania ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_status_polzovania IS 'Status polzovaniya'; -- Spravochnik: Prednaznachenie pomescheniya CREATE TABLE dict_prednaznachenie_pomeshenia ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), code VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(500) NOT NULL, description TEXT, is_active BOOLEAN DEFAULT true, sort_order INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP ); COMMENT ON TABLE dict_prednaznachenie_pomeshenia IS 'Prednaznachenie pomescheniya';