gz_tenderplanposition_purchaseConditions_preferensesRequireca39 – tenderplanposition-requirementdetail relationship

Столбцы

• id integer NOT NULL PRIMARY KEY

  ID

• requirementdetail_id integer NOT NULL FOREIGN KEY REFERENCES gz_requirementdetail(id)

  requirementdetail

• tenderplanposition_id bigint NOT NULL FOREIGN KEY REFERENCES gz_tenderplanposition(id)

  tenderplanposition

Ограничения

• UNIQUE KEY (tenderplanposition_id, requirementdetail_id)

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

• requirementdetail_id integer NOT NULL FOREIGN KEY REFERENCES gz_requirementdetail(id)

  requirementdetail

• tenderplanposition_id bigint NOT NULL FOREIGN KEY REFERENCES gz_tenderplanposition(id)

  tenderplanposition