ERD sample

Tables (4)

COUNTRY BENEFITS (TB_CTR_BEN)

  • COUNTRY BENEFICIAL ID (CTRY_BEN_ID) — VARCHAR(500) — Primary key
  • Key (COUNTRY_CODE) — VARCHAR(500) — Foreign key → PH MANDATORY BENEFITS.Key — NOT NULL
  • BENEFICIAL TYPE ID (BENEFIT_TYPE_ID) — VARCHAR(500)
  • LOCAL BENEFITS NAME (LOC_BEN_NM) — VARCHAR(200)
  • LOCAL BENEFITS CODE (LOC_BEN_CD) — VARCHAR(50)
  • Field

KO MANDATORY BENEFITS (KO_MAN-BEN)

  • Key — Primary key — NOT NULL

PH MANDATORY BENEFITS (PH_MAN_BEN)

  • Key — Primary key — NOT NULL
  • Field

Untitled (TB_BEN_TYPES)

  • Key (BEN_TYPE_ID) — VARCHAR(500) — Primary key — NOT NULL
  • Field (BEN_CODE) — VARCHAR(50)
  • Field (BEN_CATEGORY) — VARCHAR(50)
  • Field (IS_STATUTORY) — CHAR(1)
  • Field