fz223_organization_classification_activities_okved2 – organization-okved2 relationship

Столбцы

• id integer NOT NULL PRIMARY KEY

  ID

• okved2_id text NOT NULL FOREIGN KEY REFERENCES fz223_okved2(code)

  okved2

• organization_id bigint NOT NULL FOREIGN KEY REFERENCES fz223_organization(synthetic_id)

  organization

Ограничения

• UNIQUE KEY (organization_id, okved2_id)

Внешние ключи

• okved2_id text NOT NULL FOREIGN KEY REFERENCES fz223_okved2(code)

  okved2

• organization_id bigint NOT NULL FOREIGN KEY REFERENCES fz223_organization(synthetic_id)

  organization