gz_tenderplan_notifications – tenderplan-notification relationship

Столбцы

• id integer NOT NULL PRIMARY KEY

  ID

• notification_id bigint NOT NULL FOREIGN KEY REFERENCES gz_notification(id)

  notification

• tenderplan_id bigint NOT NULL FOREIGN KEY REFERENCES gz_tenderplan(id)

  tenderplan

Ограничения

• UNIQUE KEY (tenderplan_id, notification_id)

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

• notification_id bigint NOT NULL FOREIGN KEY REFERENCES gz_notification(id)

  notification

• tenderplan_id bigint NOT NULL FOREIGN KEY REFERENCES gz_tenderplan(id)

  tenderplan