34GmnQ7H

1create sequence blank_distribution_info_seq;
2
3create table if not exists blank_distribution_info
4(
5    blank_distribution_info_id bigint not null default nextval('blank_distribution_info_seq'),
6    one_time_id                bigint not null,
7    blank_distribution_id      bigint not null,
8    blank_type_id              bigint,
9    product_type_id            bigint,
10    distribution_count         bigint not null
11);
12
13alter table blank_distribution_info
14    add constraint blank_distribution_info_pk primary key (blank_distribution_info_id);
15
16alter table blank_distribution_info
17    add constraint fk_blank_dist_info_one_time foreign key (one_time_id)
18        references blank_application_one_time (one_time_id);
19
20alter table blank_distribution_info
21    add constraint fk_blank_dist_info_dist foreign key (blank_distribution_id)
22        references blank_distribution (blank_distribution_id);
23
24comment on table blank_distribution_info
25    is
26        'Информация о бланках/продукции в распределении';
27
28comment on column blank_distribution_info.blank_distribution_info_id
29    is
30        'Идентификатор';
31
32comment on column blank_distribution_info.one_time_id
33    is
34        'Разовая заявка';
35
36comment on column blank_distribution_info.blank_distribution_id
37    is
38        'Идентификатор распределения';
39
40comment on column blank_distribution_info.blank_type_id
41    is
42        'Тип бланков';
43
44comment on column blank_distribution_info.product_type_id
45    is
46        'Тип продукции';
47
48comment on column blank_distribution_info.distribution_count
49    is
50        'Кол-во к распределению';