온라인 뱅킹 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)