K-BANK
Tables (5)
ACCOUNT
- account_id — NUMBER — Primary key — NOT NULL
- customer_id — NUMBER — Foreign key → CUSTOMER.customer_id — NOT NULL
- emp_id — NUMBER — Foreign key → EMPLOYEE.emp_id — NOT NULL
- account_type — VARCHAR2(10) — NOT NULL
- balance — NUMBER(15,2) — NOT NULL
- interest_rate — NUMBER(5,2) — NOT NULL
- open_date — DATE — NOT NULL
- expire_date — DATE
- status — VARCHAR2(10) — NOT NULL
BRANCH
- branch_id — NUMBER — Primary key — NOT NULL
- branch_name — VARCHAR2(50) — NOT NULL
- address — VARCHAR2(200) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
CUSTOMER
- customer_id — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- ssn — VARCHAR2(14) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- email — VARCHAR2(100)
- address — VARCHAR2(200)
- grade — VARCHAR2(10) — NOT NULL
- reg_date — DATE — NOT NULL
EMPLOYEE
- emp_id — NUMBER — Primary key — NOT NULL
- branch_id — NUMBER — Foreign key → BRANCH.branch_id — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- dept — VARCHAR2(50) — NOT NULL
- position — VARCHAR2(30) — NOT NULL
- hire_date — DATE — NOT NULL
TRANSACTION_HISTORY
- txn_id — NUMBER — Primary key — NOT NULL
- account_id — NUMBER — Foreign key → ACCOUNT.account_id — NOT NULL
- related_account_id — NUMBER — Foreign key → ACCOUNT.account_id
- txn_type — VARCHAR2(10) — NOT NULL
- amount — NUMBER(15,2) — NOT NULL
- balance_after — NUMBER(15,2) — NOT NULL
- txn_date — DATE — NOT NULL
- memo — VARCHAR2(200)