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)