ㅓㅓ
테이블 (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