fz223_organization_classification_activities_okved2
– organization-okved2 relationship
Столбцы
id
integer NOT NULL PRIMARY KEYID
okved2_id
text NOT NULL FOREIGN KEY REFERENCESfz223_okved2
(code
)okved2
organization_id
bigint NOT NULL FOREIGN KEY REFERENCESfz223_organization
(synthetic_id
)organization
Ограничения
UNIQUE KEY (organization_id, okved2_id)
Внешние ключи
okved2_id
text NOT NULL FOREIGN KEY REFERENCESfz223_okved2
(code
)okved2
organization_id
bigint NOT NULL FOREIGN KEY REFERENCESfz223_organization
(synthetic_id
)organization