CREATE TABLE snsi.nsi_apartment_categories
(
	guid character varying(36),
	nsi_11_code character varying(3) NOT NULL,
	apartment_category_name character varying(2500) NOT NULL,
	insert_date timestamp with time zone NOT NULL,
	update_date timestamp with time zone NOT NULL,
	is_dirty boolean NOT NULL,
	CONSTRAINT pk_nsi_apartment_categories_nsi_11_code PRIMARY KEY (nsi_11_code)
);

ALTER TABLE snsi.nsi_apartment_categories OWNER TO hcs_pafo;

GRANT DELETE, INSERT, SELECT, TRUNCATE, UPDATE ON TABLE snsi.nsi_apartment_categories TO hcs_pafo_etl_rw;

COMMENT ON TABLE snsi.nsi_apartment_categories IS 'Категория помещения';
COMMENT ON COLUMN snsi.nsi_apartment_categories.guid IS 'Уникальный идентификатор';
COMMENT ON COLUMN snsi.nsi_apartment_categories.nsi_11_code IS 'Код категории помещения';
COMMENT ON COLUMN snsi.nsi_apartment_categories.apartment_category_name IS 'Категория помещения';
COMMENT ON COLUMN snsi.nsi_apartment_categories.insert_date IS 'Дата и время вставки записи в stage-таблицу';
COMMENT ON COLUMN snsi.nsi_apartment_categories.update_date IS 'Дата и время последнего обновления записи в stage-таблице';
COMMENT ON COLUMN snsi.nsi_apartment_categories.is_dirty IS 'Признак грязных (необработанных) новых данных';