Product Design

Tables (14)

Assured Rate (Untitled6)

  • ASU_ID (Key) — Primary key — NOT NULL

Benefit (Untitled8)

  • BENID (Key) — Primary key — NOT NULL
  • ASU_ID (Key2) — Foreign key → Assured Rate.ASU_ID — NOT NULL

Cov_Bnf_Rel (CopyOfCopyOfCopyOfUntitled7)

  • REL_ID (Key) — Primary key — NOT NULL
  • COVID (Key2) — Foreign key → Coverage.COVID — NOT NULL
  • BENID (Key3) — Foreign key → Benefit.BENID — NOT NULL

Cov_Inf_Rel (CopyOfCopyOfUntitled7)

  • REL_ID (Key) — Primary key — NOT NULL
  • COVID (Key2) — Foreign key → Coverage.COVID — NOT NULL
  • INFID (Key3) — Foreign key → Info Item.INFID — NOT NULL

Cov_Obj_Rel (CopyOfUntitled7)

  • REL_ID (Key) — Primary key — NOT NULL
  • COVID (Key2) — Foreign key → Coverage.COVID — NOT NULL
  • OBJID (Key3) — Foreign key → Object.OBJID — NOT NULL

Coverage (Untitled)

  • COVID (Key) — Primary key — NOT NULL
  • RISKID (Key2) — Foreign key → Risk.RISKID — NOT NULL

Info Item (Untitled4)

  • INFID (Key) — Primary key — NOT NULL

Object (Untitled7)

  • OBJID (Key) — Primary key — NOT NULL

Premium Rate (Untitled5)

  • PRMID (Key) — Primary key — NOT NULL
  • COVID (Key2) — Foreign key → Coverage.COVID — NOT NULL

Product

  • PRODID (Key) — Primary key — NOT NULL

Risk (Untitled2)

  • RISKID (Key) — Primary key — NOT NULL

Sales Coverage (Untitled3)

  • SCOVID (Key) — Primary key — NOT NULL
  • PRODID (Key2) — Foreign key → Product.PRODID — NOT NULL

Sales Phrase (CopyOfUntitled3)

  • SP_ID (Key) — Primary key — NOT NULL
  • SCOVID (Key2) — Foreign key → Sales Coverage.SCOVID — NOT NULL

Scov_Cov_Rel (CopyOfUntitled6)

  • REL_ID (Key) — Primary key — NOT NULL
  • SCOVID (Key2) — Foreign key → Sales Coverage.SCOVID — NOT NULL
  • COVID (Key3) — Foreign key → Coverage.COVID — NOT NULL