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