실습1
테이블 (6)
Account (계좌)
- accountId (계좌번호) — varchar — 기본 키 — NOT NULL
- customerId (고객 ID) — int — 외래 키 → Customer.customerId — NOT NULL
- balance (잔액) — int
- open_date (계좌계설일) — date
- created_at (등록일시) — timestamp
- creator (등록자ID) — varchar
- updated_at (변경일시) — timestamp
- updater (변경자ID) — varchar
Consulting (상담)
- consultingId (상담ID) — int — 기본 키 — NOT NULL
- customerId (고객 ID) — int — 외래 키 → Customer.customerId — NOT NULL
- consultantId (상담직원번호) — varchar
- consultingType (상담유형) — varchar
- consultingDate (상담일자) — date
- consultingContent (상담내용) — json
- created_at (등록일시) — timestamp
- creator (등록자ID) — varchar
- updated_at (변경일시) — timestamp
- updater (변경자ID) — varchar
Customer (고객)
- customerId (고객 ID) — int — 기본 키 — NOT NULL
- name (고객 이름) — varchar
- phoneNumber (연락처) — varchar
- email (이메일) — varchar
- created_at (등록일시) — timestamp
- creator (등록자ID) — varchar
- updated_at (변경일시) — timestamp
- updater (변경자ID) — varchar
Product (상품)
- productId (상품ID) — varchar — 기본 키 — NOT NULL
- productName (상품명) — varchar
- productType (상품유형) — varchar
- interestRate (이율) — float
- minimum_money (최소가입금액) — int
- created_at (등록일시) — timestamp
- creator (등록자ID) — varchar
- updated_at (변경일시) — timestamp
- updater (변경자ID) — varchar
Transaction (거래)
- transactionId (거레ID) — int — 기본 키 — NOT NULL
- accountId (계좌번호) — varchar — 외래 키 → Account.accountId — NOT NULL
- customerId (고객 ID) — int — 외래 키 → Account.customerId — NOT NULL
- transactionTime (거래일시) — timstamp
- amount (금액) — int
- transactionType (거래유형(입금/출금)) — enum
- created_at (등록일시) — timestamp
- creator (등록자ID) — varchar
- updated_at (변경일시) — timestamp
- updater (변경자ID) — varchar
buy (구매)
- accountId (계좌번호) — varchar — 외래 키 → Account.accountId — NOT NULL
- customerId (고객 ID) — int — 외래 키 → Account.customerId — NOT NULL
- productId (상품ID) — varchar — 외래 키 → Product.productId — NOT NULL