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