실습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