온라인 뱅킹 ERD 설계

테이블 (6)

Account(계좌) (Account)

  • account_id — VARCHAR(36) — 기본 키 — NOT NULL
  • customer_id — VARCHAR(36) — 외래 키 → Customer(고객).customer_id — NOT NULL
  • balance — DECIMAL(15,2)
  • opened_at — DATETIME
  • registered_at — DATETIME
  • registered_by — VARCHAR(50)
  • updated_at — DATETIME
  • updated_by — VARCHAR(50)

Consulting(상담) (Consulting)

  • consulting_id — VARCHAR(36) — 기본 키 — NOT NULL
  • customer_id (customer_id2) — VARCHAR(36) — 외래 키 → Customer(고객).customer_id — NOT NULL
  • employee_id — VARCHAR(36)
  • consulting_type — VARCHAR(50)
  • consulting_at — DATETIME
  • content — TEXT
  • registered_at — DATETIME
  • registered_by — VARCHAR(50)
  • updated_at — DATETIME
  • updated_by — VARCHAR(50)

Customer(고객) (Customer)

  • customer_id — VARCHAR(36) — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • registered_at — DATETIME
  • registered_by — VARCHAR(50)
  • updated_at — DATETIME
  • updated_by — VARCHAR(50)

CustomerProduct(고객-상품) (CustomerProduct)

  • customer_product_id — VARCHAR(36) — 기본 키 — NOT NULL
  • customer_id (customer_id2) — VARCHAR(36) — 외래 키 → Customer(고객).customer_id — NOT NULL
  • product_id (product_id2) — VARCHAR(36) — 외래 키 → Product(상품).product_id — NOT NULL
  • subscribed_at — DATETIME
  • registered_at — DATETIME
  • registered_by — VARCHAR(50)
  • updated_at — DATETIME
  • updated_by — VARCHAR(50)

Product(상품) (Product)

  • product_id — VARCHAR(36) — 기본 키 — NOT NULL
  • product_name — VARCHAR(100)
  • product_type — VARCHAR(50)
  • interest_rate — FLOAT
  • minimum_amount — DECIMAL(15,2)
  • registered_at — DATETIME
  • registered_by — VARCHAR(50)
  • updated_at — DATETIME
  • updated_by — VARCHAR(50)

Transaction(거래) (Transaction)

  • transaction_id — VARCHAR(36) — 기본 키 — NOT NULL
  • account_id (account_id2) — VARCHAR(36) — 외래 키 → Account(계좌).account_id — NOT NULL
  • transaction_type — VARCHAR(10)
  • amount — DECIMAL(15,2)
  • transaction_at — DATETIME
  • registered_at — DATETIME
  • registered_by — VARCHAR(50)
  • updated_at — DATETIME
  • updated_by — VARCHAR(50)