wishcash

Tables (6)

DepositOption

  • option_id (id) — INT — Primary key — NOT NULL
  • user_id (registered_user) — INT — Foreign key → User.user_id — NOT NULL
  • product_id (product) — INT — Foreign key → DepositProduct.product_id — NOT NULL
  • fin_prdt_cd — TEXT — NOT NULL
  • intr_rate_type_nm — TEXT
  • rsrv_type_nm — TEXT
  • save_trm — INT
  • intr_rate — Float
  • intr_rate2 — Float

DepositProduct

  • product_id (id) — INT — Primary key — NOT NULL
  • fin_prdt_cd — TEXT — NOT NULL
  • dcls_month — TEXT — NOT NULL
  • fin_co_no — TEXT — NOT NULL
  • kor_co_nm — TEXT — NOT NULL
  • fin_prdt_nm — TEXT — NOT NULL
  • join_way — TEXT — NOT NULL
  • spcl_cnd — TEXT — NOT NULL
  • join_deny — INT — NOT NULL
  • join_member — TEXT — NOT NULL
  • etc_note — TEXT — NOT NULL

Exchage (Exchange)

  • exchange_id (id) — INT — Primary key — NOT NULL
  • Field (cur_unit) — TEXT — NOT NULL
  • Field (ttb) — Float — NOT NULL
  • Field (tts) — Float — NOT NULL
  • Field (cur_nm) — TEXT

SavingOption (CopyOfDepositOption)

  • option_id (id) — INT — Primary key — NOT NULL
  • user_id (registered_user) — INT — Foreign key → User.user_id — NOT NULL
  • product_id (product) — INT — Foreign key → SavingProduct.product_id — NOT NULL
  • fin_prdt_cd — TEXT — NOT NULL
  • intr_rate_type_nm — TEXT
  • rsrv_type_nm — TEXT
  • save_trm — INT
  • intr_rate — Float
  • intr_rate2 — Float

SavingProduct (CopyOfDepositProduct)

  • product_id (id) — INT — Primary key — NOT NULL
  • fin_prdt_cd — TEXT — NOT NULL
  • dcls_month — TEXT — NOT NULL
  • fin_co_no — TEXT — NOT NULL
  • kor_co_nm — TEXT — NOT NULL
  • fin_prdt_nm — TEXT — NOT NULL
  • join_way — TEXT — NOT NULL
  • spcl_cnd — TEXT — NOT NULL
  • join_deny — INT — NOT NULL
  • join_member — TEXT — NOT NULL
  • etc_note — TEXT — NOT NULL

User

  • user_id (id) — INT — Primary key — NOT NULL
  • username — TEXT — NOT NULL
  • nickname — TEXT — NOT NULL
  • age — INT — NOT NULL
  • gender — TEXT — NOT NULL
  • birth_date — DateTime — NOT NULL
  • email — Email — NOT NULL
  • house_bank — TEXT — NOT NULL