Pay
Bank System ER Diagram

Bank System ER Diagram

ARF_QUESTION_TYPE_GROUP

PK

ID


I1

I2

NAME

HASH_VALUE

LENGTH

ARF_QUESTION_TYPE

PK

ID

U1

NAME

NAME_EN

ARF_QUESTION_TYPE_GROUP_MBRS

PK,FK2,I1

PK,FK1

QUESTION TYPE GROUP ID

QUESTION TYPE ID

ARF_IU_DIR_LVL

PK

ID

FK1, I1

NAME_EN

DPTH

PARENT_ID

ARF_SEARCH_NUMBER_GROUR

PK

ID


I1

I2

NAME

HASH_VALUE

LENGTH

ARF_QUESTION

PK

ID

I2


FK1, I1

I3

FK2,I4

NORMAL_QUESTION

QUESTION

QUESTION_TYPE_GROUP_ID

WORD_COUNT

QUESTION_NUMBER_GROUP_ID

ARF_IU_ORG

PK

ID

I5

I4


FK2,I6

FK1,I2

I3

I1

ORG_ID

NAME_EN

DESCRIPTION_EN

PARENT_ORG_ID

DIR_LVL_ID

LAST_UPDATED

DELETED

ARF_QUESTION_TYPE_GROUP_MBRS

PK,FK2,I1

PK,FK1

SEARCH NUMBER GROUP ID

SEARCH NUMBER ID

ARF_SEARCH_NUMBER

PK

ID

QUANTITY

ARF_IU_USER

PK

ID

I8

I4

I2

I5

FK2,I7

FK1,I3

I6

I1

USER_ID

LOGIN

FIRST_NAME

LAST_NAME

PARENT_ORG_ID

DIR_LVL_ID

LAST_UPDATED

DELETED

ARF_CAL_QOY

PK

ID

I1

I2

I3

QTR_OF_YEAR

SHORT_NAME_EN

LONG_NAME_EN

ARF_TIME_QTR

PK

ID

FK2,I3

FK1,I1

U1

I2

YEAR_ID

QOY_ID

QTR_TIMESTAMP

QTR_OF_YEAR

ARF_TIME_YEAR

PK

ID

U1

I1

YEAR_TIMESTAMP

YEAR_OF_ERA

ARF_TIME_WEEK

PK

ID

FKI,I2

U1

I1

YEAR_ID

WEEK_TIMESTAMP

WEEK_OF_YEAR

ARF_CAL_MOY

PK

ID

I1

I2

I3

MONTH_OF_YEAR

SHORT_NAME_EN

LONG_NAME_EN

ARF_TIME_MONTH

PK

ID

FK3,I4

FK2,I3

FK1,I1

U1

I2

YEAR_ID

QTR_ID

MOY_ID

MONTH_TIMESTAMP

MONTH_OF_YEAR

ARF_CURRENCY

PK

ID

I1

I2

CURRENCY_NAME

CURRENCY_NAME_EN

ISO4217_NUM3

RECORD_START_DATE

RECORD_END_DATE

ARF_CAL_DOW

PK

ID

I1

I2

I3

DAY_OF_WEEK

SHORTNAME_EN

LONG_NAME_EN

ARF_SEGMENT

PK

ID

I1

NSEGMENT_ID

SEGMENT_NAME

SEGMENT_DESC

RECORD_LAST_UPDATE

RECORD_START_DATE

RECORD_END_DATE

MOST_RECENT

DELETED

ARF_LANGUAGE

PK

ID

I1 I2

LANG_NAME

LANG_NAME_EN

ISO639_1_ALPHA2

ISO639_2_ALPHA3

RECORD_START_DATE

RECORD_END_DATE

ARF_GEO_COUNTRY

PK

ID

I1

I2

I3

COUNTRY_NAME

COUNTRY_NAME_EN

ISO3166_1_ALPHA2

ISO3166_1_NUM3

FIPS10_4_CODE

RECORD_START_DATE

RECORD_END_DATE

ARF_USER

PK

ID

FK3,I3

FK1,I1

FK4,I4

FK2,I2

NUSER_ID

LOGIN

FIRST_NAME

MIDDLE_NAME

LAST_NAME

EMAIL

DATE_OF_BIRTH

LANG_ID

GENDER_ID

MARITAL_STATUS_ID

HOME_REGION_ID

RECORD_LAST_UPDATE

RECORD_START_DATE

RECORD_END_DATE

MOST_RECENT

DELETED

ARF_CURRENCY

PK

ID

I1

I2

CURRENCY_NAME

CURRENCY_NAME_EN

ISO4217_NUM3

RECORD_START_DATE

RECORD_END_DATE

ARF_TIME_DAY

PK

ID

FK3,I4

FK2,I3

FK1,I1

U1

I2

WEEK_ID

MONTH_ID

DOW_ID

DAY_TIMESTAMP

DAY_OF_WEEK

DAY_OF_MONTH

DAY_OF_YEAR

ARF_TIME_TOD

PK

ID

I2

I4


I1

I3

HOUR_OF_DAY

NIN_OF_HOUR

MIN_OF_DAY

HALFDAY_OF_DAY

HOUR_OF_HALFDAY

ARF_GENDER

PK

ID

GENDER_NAME

GENDER_NAME_EN

ARF_TIME_GROUP

PK

ID

AGE_GROUP_NAME

AGE_GROUP_NAME_EN

AGE_MIN

AGE_MAX

ARF_GEO_REGION

PK

ID

FK1,I1




I3

I2

COUNTRY_ID

REGION_NAME

REGION_NAME

ISO3166_2_CODE

FIPS10_4_CODE

RECORD_START_DATE

RECORD_END_DATE

ARF_MARITAL_STATUS

PK

ID

MARITAL_STATUS_NAME

MARITAL_STATUS_NAME_EN

ARF_DEMOGRAPHIC

PK

ID

FK2,I1

FK1,I2

FK4,I3

FK3,I4

GENDER_ID

AGE_GROUP_ID

MARITAL_STATUS_ID

REGION_ID

ARF_STIMGRP_MBRS

PK,FK1

PK,FK2,I1

STIMGRP ID

STIMULUS ID

ARF_SEGCLSTR

PK

ID

I1

NAME

HASH_VALUE

LENGTH

ARF_TIME_HOUR

PK

ID

FK1, I1

U1

I2

DAY_ID

HOUR_TIMETAMP

HOUR_OF_DAY

ARF_STIMULUS

PK

ID

I1

NSTIMULUS_ID

STIMLUS_NAME

STIMULUS_DESC

STIMULUS_TYPE

RECORD_LAST_UPDATE

RECORD_END_DATE

MOST_RECENT

DELETED

ARF_STIMGRP

PK

ID

I1

NAME

HASH_VALUE

LENGTH

ARF_SEGCLSTR_MBRS

PK,FK1

PK,FK2,I1

PK

SEGCLSTR ID

SEGMENT ID

MEMBER

ARF_SITE_VISIT

PK

SITE VISIT ID

FK3,I1

FK6,I2

FK4,I7

FK5,I8

FK7,I3

FK2,I4

FK1,I5

I6

START_DAY_ID

START_TIME_ID

END_DAY_ID

END_TIME_ID

VISITOR_ID

DEMOGRAPHIC_ID

SESSION_ID

NUM_PAGE_VIEWS

DURATION_SECONDS

0
0
0
publish time: 2021-06-04
Viro

Bank System Entity-Relationship (ER) Diagram is used to analyze the structure of the banking system. Use EdrawMax to create the Bank System ER Diagram as it has all the required symbols and figures essential to develop the banking system entity-relationship templates. The below bank system ER diagram illustrates critical information about banks, including branches, customers, accounts, and loans. The ER diagram of the banking system has customers, banks identified by the name, code, and address of the main office. A bank's branch is also determined by a branch_no., branch_name, address, and others. At the same time, Customers are identified by name, customer_id, phone_number, and customer_address. At the same time, accounts are identified by account_no., account_type, and account_balance. Any loan segment is identified by loan_id, loan_type, and loan_amount.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
22
0
0
DILSHAN SACHINDRA