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