6.PostgreSQL: [Электронный ресурс] // Википедия сайт. - URL: https://ru.wikipedia.org/wiki/PostgreSQL.

7.JDK: [Электронный ресурс] // Национальная библиотека им. Н.Э. Баумана сайт. - Режим доступа: https://ru.bmstu.wiki/Java_Development_Kit.

8.TypeScript: [Электронный ресурс] // Википедия сайт. - URL: https://ru.wikipedia.org/wiki/TypeScript.

9. Методика тестирования: [Электронный ресурс] // Блог веб-программиста сайт. - URL: http://juice-health.ru/program/software-testing/495-software-testing-methods.

ПРИЛОЖЕНИЕ

SQL - скрипты создания таблиц и последовательностей

//Последоватьлности

CREATE SEQUENCE public.branches_cod_branch_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 88

CACHE 1;

ALTER TABLE public.branches_cod_branch_seq

OWNER TO postgres;

CREATE SEQUENCE public.comm_equipments_cod_comm_equipment_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 40

CACHE 1;

ALTER TABLE public.comm_equipments_cod_comm_equipment_seq

OWNER TO postgres;

CREATE SEQUENCE public.departments_cod_department_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 63

CACHE 1;

ALTER TABLE public.departments_cod_department_seq

OWNER TO postgres;

CREATE SEQUENCE public.diapasons_cod_diapason_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 23

CACHE 1;

ALTER TABLE public.diapasons_cod_diapason_seq

OWNER TO postgres;

CREATE SEQUENCE public.equipments_cod_equipment_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 56

CACHE 1;

ALTER TABLE public.equipments_cod_equipment_seq

OWNER TO postgres;

CREATE SEQUENCE public.models_cod_model_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 40

CACHE 1;

ALTER TABLE public.models_cod_model_seq

OWNER TO postgres;

CREATE SEQUENCE public.providers_cod_provider_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 19

CACHE 1;

ALTER TABLE public.providers_cod_provider_seq

OWNER TO postgres;

CREATE SEQUENCE public.radiostations_cod_radiostation_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 32

CACHE 1;

ALTER TABLE public.radiostations_cod_radiostation_seq

OWNER TO postgres;

CREATE SEQUENCE public.specificities_cod_specificity_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 25

CACHE 1;

ALTER TABLE public.specificities_cod_specificity_seq

OWNER TO postgres;

CREATE SEQUENCE public.supplies_cod_supply_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 49

CACHE 1;

ALTER TABLE public.supplies_cod_supply_seq

OWNER TO postgres;

CREATE SEQUENCE public.technics_cod_technique_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 8

CACHE 1;

ALTER TABLE public.technics_cod_technique_seq

OWNER TO postgres;

//Таблицы

CREATE TABLE public.departments

(

cod_department integer NOT NULL DEFAULT nextval('departments_cod_department_seq'::regclass), -- Код подразделения

name_department character varying(255) NOT NULL, -- Имя подразделения

CONSTRAINT departments_pkey PRIMARY KEY (cod_department)

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.departments

OWNER TO postgres;

COMMENT ON TABLE public.departments

IS 'Подразделения';

COMMENT ON COLUMN public.departments.cod_department IS 'Код подразделения';

COMMENT ON COLUMN public.departments.name_department IS 'Имя подразделения';

CREATE TABLE public.branches

(

cod_branch integer NOT NULL DEFAULT nextval('branches_cod_branch_seq'::regclass), -- Код службы

name_branch character varying(255) NOT NULL, -- Имя службы

cod_department integer NOT NULL, -- Код подразделения

CONSTRAINT branches_pkey PRIMARY KEY (cod_branch),

CONSTRAINT branches_fkey0 FOREIGN KEY (cod_department)

REFERENCES public.departments (cod_department) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.branches

OWNER TO postgres;

COMMENT ON TABLE public.branches

IS 'Службы';

COMMENT ON COLUMN public.branches.cod_branch IS 'Код службы';

COMMENT ON COLUMN public.branches.name_branch IS 'Имя службы';

COMMENT ON COLUMN public.branches.cod_department IS 'Код подразделения';

CREATE TABLE public.technics

(

cod_technique integer NOT NULL DEFAULT nextval('technics_cod_technique_seq'::regclass), -- Код техники

name_technique character varying(255) NOT NULL, -- Наименование техники

CONSTRAINT technics_pkey PRIMARY KEY (cod_technique)

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.technics

OWNER TO postgres;

COMMENT ON TABLE public.technics

IS 'Техника';

COMMENT ON COLUMN public.technics.cod_technique IS 'Код техники';

COMMENT ON COLUMN public.technics.name_technique IS 'Наименование техники';

CREATE TABLE public.specificities

(

cod_specificity integer NOT NULL DEFAULT nextval('specificities_cod_specificity_seq'::regclass), -- Код особенности

name_specificity character varying(255) NOT NULL, -- Имя особенности

CONSTRAINT specificities_pkey PRIMARY KEY (cod_specificity)

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.specificities

OWNER TO postgres;

COMMENT ON TABLE public.specificities

IS 'Особенности радиостанций';

COMMENT ON COLUMN public.specificities.cod_specificity IS 'Код особенности';

COMMENT ON COLUMN public.specificities.name_specificity IS 'Имя особенности';

CREATE TABLE public.diapasons

(

cod_diapason integer NOT NULL DEFAULT nextval('diapasons_cod_diapason_seq'::regclass), -- Код диапазона

name_diapason character varying(255) NOT NULL, -- Значение диапазона

CONSTRAINT diapasons_pkey PRIMARY KEY (cod_diapason)

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.diapasons

OWNER TO postgres;

COMMENT ON TABLE public.diapasons

IS 'Диапозоны';

COMMENT ON COLUMN public.diapasons.cod_diapason IS 'Код диапазона';

COMMENT ON COLUMN public.diapasons.name_diapason IS 'Значение диапазона';

CREATE TABLE public.radiostations

(

cod_radiostation integer NOT NULL DEFAULT nextval('radiostations_cod_radiostation_seq'::regclass), -- Код радиостанции

name_radiostation character varying(255) NOT NULL, -- Название радиостанции

cod_specificity integer, -- Код особенности

cod_diapason integer NOT NULL, -- Код диапазона

presence_sc_device boolean NOT NULL, -- Наличие/отсутствие УПР

CONSTRAINT radiostations_pkey PRIMARY KEY (cod_radiostation),

CONSTRAINT radiostations_fkey1 FOREIGN KEY (cod_specificity)

REFERENCES public.specificities (cod_specificity) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION,

CONSTRAINT radiostations_fkey2 FOREIGN KEY (cod_diapason)

REFERENCES public.diapasons (cod_diapason) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.radiostations

OWNER TO postgres;

COMMENT ON TABLE public.radiostations

IS 'Радиостанции';

COMMENT ON COLUMN public.radiostations.cod_radiostation IS 'Код радиостанции';

COMMENT ON COLUMN public.radiostations.name_radiostation IS 'Название радиостанции';

COMMENT ON COLUMN public.radiostations.cod_specificity IS 'Код особенности';

COMMENT ON COLUMN public.radiostations.cod_diapason IS 'Код диапазона';

COMMENT ON COLUMN public.radiostations.presence_sc_device IS 'Наличие/отсутствие УПР';

CREATE TABLE public.models

(

cod_model integer NOT NULL DEFAULT nextval('models_cod_model_seq'::regclass), -- Код модели

name_model character varying(255) NOT NULL, -- Наименование модели

lifetime integer NOT NULL, -- Срок службы средства связи

cod_radiostation integer,

cod_technique integer,

CONSTRAINT models_pkey PRIMARY KEY (cod_model),

CONSTRAINT models_radiostations_cod_radiostation_fk FOREIGN KEY (cod_radiostation)

REFERENCES public.radiostations (cod_radiostation) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION,

CONSTRAINT models_technics_cod_technique_fk FOREIGN KEY (cod_technique)

REFERENCES public.technics (cod_technique) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.models

OWNER TO postgres;

COMMENT ON TABLE public.models

IS 'Модели средств связи';

COMMENT ON COLUMN public.models.cod_model IS 'Код модели

';

COMMENT ON COLUMN public.models.name_model IS 'Наименование модели';

COMMENT ON COLUMN public.models.lifetime IS 'Срок службы средства связи';

CREATE TABLE public.providers

(

cod_provider integer NOT NULL DEFAULT nextval('providers_cod_provider_seq'::regclass), -- Индетификатор поставщика

name_provider character varying(255) NOT NULL, -- Имя поставщика

CONSTRAINT providers_pkey PRIMARY KEY (cod_provider)

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.providers

OWNER TO postgres;

COMMENT ON TABLE public.providers

IS 'Поставщики';

COMMENT ON COLUMN public.providers.cod_provider IS 'Индетификатор поставщика';

COMMENT ON COLUMN public.providers.name_provider IS 'Имя поставщика';

CREATE TABLE public.supplies

(

cod_supply integer NOT NULL DEFAULT nextval('supplies_cod_supply_seq'::regclass), -- Идентификатор поставки

invoice_number character varying(100), -- номер накладной, номер наряда

invoice_date date, -- дата накладной, дата наряда

cod_provider integer NOT NULL, -- Идентификатор поставщика

CONSTRAINT supplies_pkey PRIMARY KEY (cod_supply),

CONSTRAINT supplies_fkey0 FOREIGN KEY (cod_provider)

REFERENCES public.providers (cod_provider) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.supplies

OWNER TO postgres;

COMMENT ON TABLE public.supplies

IS 'Поставки';

COMMENT ON COLUMN public.supplies.cod_supply IS 'Идентификатор поставки';

COMMENT ON COLUMN public.supplies.invoice_number IS 'номер накладной, номер наряда';

COMMENT ON COLUMN public.supplies.invoice_date IS 'дата накладной, дата наряда';

COMMENT ON COLUMN public.supplies.cod_provider IS 'Идентификатор поставщика

';

CREATE TABLE public.equipments

(

cod_equipment integer NOT NULL DEFAULT nextval('equipments_cod_equipment_seq'::regclass), -- Код комплектации

composition text, -- Состав

commentary text, -- Примечание

CONSTRAINT equipments_pkey PRIMARY KEY (cod_equipment)

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.equipments

OWNER TO postgres;

COMMENT ON TABLE public.equipments

IS 'Комплектации';

COMMENT ON COLUMN public.equipments.cod_equipment IS 'Код комплектации';

COMMENT ON COLUMN public.equipments.composition IS 'Состав';

COMMENT ON COLUMN public.equipments.commentary IS 'Примечание';

CREATE TABLE public.comm_equipments

(

cod_comm_equipment integer NOT NULL DEFAULT nextval('comm_equipments_cod_comm_equipment_seq'::regclass), -- Код средства связи

cod_branch integer NOT NULL, -- Код службы

cod_model integer NOT NULL,

serial_number character varying(255),

inventory_number character varying(100),

price numeric,

release_date date,

commissioning_date date,

distribution_plan date,

cod_supply integer,

model_operability boolean,

cod_equipment integer,

CONSTRAINT comm_equipments_pkey PRIMARY KEY (cod_comm_equipment),

CONSTRAINT comm_equipments_fkey0 FOREIGN KEY (cod_branch)

REFERENCES public.branches (cod_branch) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION,

CONSTRAINT comm_equipments_models_cod_model_fk FOREIGN KEY (cod_model)

REFERENCES public.models (cod_model) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION,

CONSTRAINT comm_equipments_supplies_cod_supply_fk FOREIGN KEY (cod_supply)

REFERENCES public.supplies (cod_supply) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION

)

WITH (

OIDS=FALSE

);

ALTER TABLE public.comm_equipments

OWNER TO postgres;

COMMENT ON TABLE public.comm_equipments

IS 'Средства связи.';

COMMENT ON COLUMN public.comm_equipments.cod_comm_equipment IS 'Код средства связи

';

COMMENT ON COLUMN public.comm_equipments.cod_branch IS 'Код службы';

Размещено на Allbest.ru

...