assetCoach

Tables (10)

ACCOUNT

  • account_idx — int — Primary key — NOT NULL
  • user_idx — int — 유저계정의
  • bank_idx — int — 은행
  • bank_branch_idx — int — 은행
  • Dailry_idx — int — Dailry
  • asset_type — char(1) — Foreign key → Asset.asset_type — 자산유형(0:안전자산
  • account_number — varchar(100) — 계좌번호
  • family_name — varchar(100) — 계좌에
  • last_name — varchar(100) — 계좌에
  • nickname — varchar(100) — 계좌별명
  • memo — varchar(100) — 계좌메모
  • holding_sum — numeric(20, 5) — 자산총액(환율
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일_시스템항목
  • logical_del_flag — char(1) — 논리적삭제여부.

Asset

  • asset_idx — int — Primary key — NOT NULL
  • asset_type — char(1)
  • itype_of_ndustry — char(1) — 산업군
  • industry_name — varchar(50) — 산업군
  • type_of_industry_detail — char(1) — 산업군(세부)
  • industry_detail_name — varchar(50) — 산업군(세부)
  • type_of_business — char(1) — 업종
  • business_name — varchar(50) — 업종
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일_시스템항목
  • logical_del_flag — char(1) — 논리적삭제여부.

Dailry

  • Dailry_idx — int — Primary key — NOT NULL
  • user_idx — int — NOT NULL — 유저
  • title — varchar(200) — NOT NULL — 일정
  • contents — varchar(1000) — NOT NULL — 일정
  • date_start — timestamp — NOT NULL — 일정
  • date_end — timestamp — NOT NULL — 일정
  • fixed_day — char(1) — 정기실시일(0:매주
  • transactions_type — char(1) — NOT NULL — 수입/지출
  • my_account_number — varchar(100) — NOT NULL — 해당거래를
  • other_account_number — varchar(100) — 해당거래를
  • currency_type — char(1) — 화폐
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일_시스템항목
  • logical_del_flag — char(1) — 논리적삭제여부.

bank

  • bank_idx — int — Primary key — NOT NULL
  • branch_idx — int — 은행지점번호
  • bank_nation — char(3) — 금융기관의
  • bank_name — varchar(100) — 금융기관
  • branch_name — varchar(100) — 금융기관
  • bank_logo — char(1) — 금융기관
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일_시스템항목
  • logical_del_flag — char(1) — 논리적삭제여부.

cash

  • cash_idx — int — Primary key — NOT NULL — 현금의 index
  • account_idx — int — Foreign key → currency.currency_type — 화폐종류(KRW등)
  • asset_type — char(1) — Foreign key → Asset.asset_type — 자산성격(0:안전자산1:위험자산)
  • account_number — varchar(100) — 계좌번호
  • currency_type — char(1) — 보유/매도
  • cash_name — varchar(100) — 상품
  • rec_create_date — timestamp — 레코드생성일.
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_update_date — timestamp — 레코드갱신일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • logical_del_flag — char(1) — 논리삭제플래그.

currency

  • currency_idx — int — Primary key — NOT NULL
  • asset_type — char(1) — Foreign key → Asset.asset_type
  • currency_type — char(1) — 화폐종류(KRW
  • date_of_exchange — timestamp — 거래일
  • EXCHANGE_RATE — numeric(20, 5) — 환율
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일.
  • logical_del_flag — char(1) — 논리삭제플래그.

gold

  • gold_idx — int — Primary key — NOT NULL
  • currency_type — char(1) — Foreign key → currency.currency_type — 화폐종류(KRW
  • asset_type — char(1) — Foreign key → Asset.asset_type — 자산성격(0:안전자산
  • account_idx — int — 계좌
  • account_number — varchar(100) — 계좌번호
  • date_of_traiding — timestamp — 거래일
  • detail_type — char(1) — 거래성격(0:수입
  • type — char(1) — 상품
  • name — varchar(100) — 상품
  • number_of_trading — numeric(18, 0) — 보유/매도
  • rec_create_date — timestamp — 레코드생성일.
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_update_date — timestamp — 레코드갱신일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • logical_del_flag — char(1) — 논리삭제플래그.

pension

  • pension_idx — int — Primary key — NOT NULL
  • asset_type — char(1) — Foreign key → Asset.asset_type
  • pension_type — char(1) — 연금
  • pension_detail_type — char(1) — 연금
  • pension_name — varchar(100) — 연금
  • limit_of_age — int — 수령가능한
  • account_idx — int — 계좌
  • account_number — varchar(100) — 계좌번호
  • currency_type — char(1) — 화폐종류(KRW
  • status_of_join — char(1) — 가입상태(0:미가입.
  • date_of_join_start — timestamp — 연금가입일
  • date_of_join_end — timestamp — 연금탈퇴일
  • period_of_pension_join — varchar(50) — 연금납입기간
  • mandatory_period — int — 수령가능한
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일.
  • logical_del_flag — char(1) — 논리삭제플래그.
  • date_of_pension — numeric(18, 0) — 연금거래일(납부일)

record_of_transactions

  • record_of_transactions_idx — int — Primary key — NOT NULL
  • account_idx — int
  • account_number — varchar(100) — Foreign key → ACCOUNT.account_number — 계좌번호
  • type — char(1) — Foreign key → currency.currency_type — 거래성격(0:수입
  • currency_type — char(1) — 화폐의
  • purchase — numeric(18, 0) — 금액
  • date_of_traiding — timestamp — 거래일
  • contents — varchar(300) — 거래내용
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일_시스템항목
  • logical_del_flag — char(1) — 논리적삭제여부.

stock

  • stock_idx — int — Primary key — NOT NULL
  • asset_type — char(1) — Foreign key → Asset.asset_type — 자산성격(0:안전자산
  • account_idx — int — 계좌
  • account_number — varchar(100) — 계좌번호
  • ticker_code — varchar(50) — 주식의
  • stock_name — varchar(100) — 주식/ETF명
  • currency_type — char(1) — Foreign key → currency.currency_type — 화폐종류(KRW
  • transactions_type — char(1) — 거래성격(0:수입
  • date_of_traiding — timestamp — 거래일
  • fractional_flag — char(1) — 소수점주식
  • number_of_trading — numeric(18, 0) — 보유/매도
  • purchase — numeric(18, 0) — 개당
  • evaluated_price — numeric(18, 0) — 평가금액(해당
  • rate_of_return — numeric(18, 0) — Foreign key → ACCOUNT.account_number — 수익률(rate
  • rec_create_user_idx — bigint — 레코드생성아이디.
  • rec_create_date — timestamp — 레코드생성일.
  • rec_update_user_idx — bigint — 레코드갱신아이디.
  • rec_update_date — timestamp — 레코드갱신일_시스템항목
  • logical_del_flag — char(1) — 논리적삭제여부.