fz223_organization_classification_fz223types – organization-organizationtype relationship

Столбцы

• id integer NOT NULL PRIMARY KEY

  ID

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

  organization

• organizationtype_id integer NOT NULL FOREIGN KEY REFERENCES fz223_organizationtype(id)

  organizationtype

Ограничения

• UNIQUE KEY (organization_id, organizationtype_id)

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

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

  organization

• organizationtype_id integer NOT NULL FOREIGN KEY REFERENCES fz223_organizationtype(id)

  organizationtype