Entity-Relationship Diagram9 entities · 10 foreign key relationships

Click diagram to enlarge · Generated from AG schema DDL
Foreign Key Relationships
| Constraint | Child Table | Child Column | Parent Table | Parent Column | Cardinality |
|---|---|---|---|---|---|
| FK_AG_ACC_PERSON | AG_SYSTEM_ACCOUNT | EMPLOYEE_ID | AG_PERSON | EMPLOYEE_ID | Many → One |
| FK_AG_ACC_SYS | AG_SYSTEM_ACCOUNT | SYSTEM_CODE | AG_SYSTEM | SYSTEM_CODE | Many → One |
| FK_AG_AE_ACC | AG_ACCOUNT_ENTITLEMENT | ACCOUNT_ID | AG_SYSTEM_ACCOUNT | ACCOUNT_ID | Many → One |
| FK_AG_AE_ENT | AG_ACCOUNT_ENTITLEMENT | ENTITLEMENT_ID | AG_ENTITLEMENT | ENTITLEMENT_ID | Many → One |
| FK_AG_AE_BATCH | AG_ACCOUNT_ENTITLEMENT | IMPORT_BATCH_ID | AG_IMPORT_BATCH | IMPORT_BATCH_ID | Many → One |
| FK_AG_ENT_SYS | AG_ENTITLEMENT | SYSTEM_CODE | AG_SYSTEM | SYSTEM_CODE | Many → One |
| FK_AG_ENT_BATCH | AG_ENTITLEMENT | IMPORT_BATCH_ID | AG_IMPORT_BATCH | IMPORT_BATCH_ID | Many → One |
| FK_AG_ENTC_ENT | AG_ENTITLEMENT_CLASSIFICATION | ENTITLEMENT_ID | AG_ENTITLEMENT | ENTITLEMENT_ID | Many → One |
| FK_AG_ENTC_BATCH | AG_ENTITLEMENT_CLASSIFICATION | IMPORT_BATCH_ID | AG_IMPORT_BATCH | IMPORT_BATCH_ID | Many → One |
| FK_AG_REQ_BATCH | AG_ACCESS_REQUEST | IMPORT_BATCH_ID | AG_IMPORT_BATCH | IMPORT_BATCH_ID | Many → One |