ㅓㅓ

테이블 (8)

거래 (Transaction)

  • transaction_id (INT) — 기본 키 — NOT NULL
  • transaction_type (VARCHAR(20))
  • amount (DECIMAL(15,2))
  • category (VARCHAR(100))
  • transaction_date (DATE)
  • description (VARCHAR(200))
  • account_id (INT2) — 외래 키 → 계좌.account_id — NOT NULL

계좌 (Account)

  • account_id (INT) — 기본 키 — NOT NULL
  • account_type (VARCHAR(20))
  • balance (DECIMAL(15,2))
  • created_at (DATE)
  • customer_id (INT2) — 외래 키 → 고객.customer_id — NOT NULL

고객 (Customer)

  • customer_id (INT) — 기본 키 — NOT NULL
  • name (VARCHAR(30))
  • birth (DATE)
  • email (VARCHAR(50))
  • phone (VARCHAR(20))
  • join_date (DATE2)

금융상품 (Product)

  • product_id (INT) — 기본 키 — NOT NULL
  • product_name (VARCHAR(30))
  • product_type (VARCHAR(20))
  • description (VARCHAR(200))
  • benefit_score (INT2)

보안로그 (Security_Log)

  • log_id (INT) — 기본 키 — NOT NULL
  • event_type (VARCHAR(20))
  • occurred_at (DATE)
  • customer_id (INT2) — 외래 키 → 고객.customer_id — NOT NULL

소비요약 (Summary)

  • summary_id (INT) — 기본 키 — NOT NULL
  • year (INT2)
  • month (INT3)
  • total_amount (INT4)
  • top_category (VARCHAR(30))
  • highest_usage_day (DATE)
  • customer_id (INT5) — 외래 키 → 고객.customer_id — NOT NULL

조언 (Advice)

  • advice_id (INT) — 기본 키 — NOT NULL
  • advice_type (VARCHAR(20))
  • content (VARCHAR(200))
  • created_at (DATE)
  • customer_id (INT2) — 외래 키 → 고객.customer_id — NOT NULL
  • transaction_id (Key2) — 외래 키 → 거래.transaction_id — NOT NULL

추천결과 (Recommendation)

  • recommendation_id (ITN) — 기본 키 — NOT NULL
  • recommended_at (DATE)
  • reason (VARCHAR(200))
  • customer_id (INT2) — 외래 키 → 고객.customer_id — NOT NULL
  • product_id (INT3) — 외래 키 → 금융상품.product_id — NOT NULL