bnk_project02
Tables (5)
deposit_account (입출금 계좌)
- account_id — NUMBER — Primary key
- account_number — VARCHAR2(20) — NOT NULL
- account_name — VARCHAR2(50)
- pin_hash — VARCHAR2(60) — NOT NULL
- balance — NUMBER(18,2) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- status — VARCHAR2(20) — NOT NULL
fund (펀드 기본 정보)
- fund_id — VARCHAR2(20) — Primary key — NOT NULL
- fund_name — VARCHAR2(150)
- fund_type — VARCHAR2(20)
- fund_division — VARCHAR2(20)
- investment_region — VARCHAR2(20)
- sales_region_type — VARCHAR2(20)
- group_code — VARCHAR2(30)
- short_code — VARCHAR2(10)
- issue_date — DATE
- initial_nav_price — NUMBER(10,2)
- trust_term — NUMBER
- accounting_period — NUMBER
- fund_class — VARCHAR2(50)
- public_type — VARCHAR2(20)
- add_unit_type — VARCHAR2(10)
- fund_status — VARCHAR2(20)
- risk_level — NUMBER
- performance_disclosure — VARCHAR2(50)
- management_company — VARCHAR2(100)
- min_subscription_amount — NUMBER(15,2)
fund_bond_types (채권 종류별)
- fund_bond_types_id — NUMBER — Primary key
- base_date — DATE — NOT NULL
- gov_bond_ratio — NUMBER(5,2)
- moa_bond_ratio — NUMBER(5,2)
- fin_bond_ratio — NUMBER(5,2)
- corp_bond_ratio — NUMBER(5,2)
- other_ratio — NUMBER(5,2)
fund_fee_info (보수 및 수수료 정보)
- fund_fee_info_id — NUMBER — Primary key
- management_fee — NUMBER(5,3)
- sales_fee — NUMBER(5,3)
- admin_fee — NUMBER(5,3)
- trust_fee — NUMBER(5,3)
- total_fee — NUMBER(5,3)
- ter — NUMBER(5,3)
- front_load_fee — NUMBER(5,2)
- rear_load_fee — NUMBER(5,2)
fund_product (펀드 상품)
- product_id — NUMBER — Primary key
- fund_id — VARCHAR2(20) — NOT NULL
- terms_doc_id — NUMBER — NOT NULL
- prospectus_doc_id — NUMBER — NOT NULL
- summary_doc_id — NUMBER — NOT NULL
- status — VARCHAR2(20) — NOT NULL