fz223_organization_classification_activities_okved – organization-okved relationship

Столбцы

• id integer NOT NULL PRIMARY KEY

  ID

• okved_id text NOT NULL FOREIGN KEY REFERENCES fz223_okved(code)

  okved

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

  organization

Ограничения

• UNIQUE KEY (organization_id, okved_id)

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

• okved_id text NOT NULL FOREIGN KEY REFERENCES fz223_okved(code)

  okved

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

  organization