ㅇㅁㄹㅇㄴ
Tables (10)
Article
- id — SERIAL
- user_id — INTEGER — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Comment
- id — SERIAL
- article_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- content — VARCHAR(200)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
DepositOptions
- id — SERIAL
- product_id — INTEGER — NOT NULL
- fin_prdt_cd — TEXT
- intr_rate_type_nm — VARCHAR(100)
- intr_rate — FLOAT
- intr_rate2 — FLOAT
- save_trm — INTEGER
DepositProducts
- id — SERIAL
- type — VARCHAR(10)
- fin_prdt_cd — TEXT
- fin_co_no — TEXT
- kor_co_nm — TEXT
- fin_prdt_nm — TEXT
- etc_note — TEXT
- join_deny — INTEGER
- join_member — TEXT
- join_way — TEXT
- max_limit — INTEGER
- spcl_cnd — TEXT
Exchange
- id — SERIAL
- cur_unit — VARCHAR(20)
- cur_nm — VARCHAR(50)
- ttb — DECIMAL(10, 2)
- tts — DECIMAL(10, 2)
- deal_bas_r — DECIMAL(10, 2)
- bkpr — DECIMAL(10, 2)
- yy_efee_r — DECIMAL(5, 2)
- ten_dd_efee_r — DECIMAL(5, 2)
- kftc_bkpr — DECIMAL(10, 2)
- kftc_deal_bas_r — DECIMAL(10, 2)
Product
- id — SERIAL
- type — VARCHAR(10)
- fin_prdt_cd — VARCHAR(255)
- fin_co_no — TEXT
- kor_co_nm — TEXT
- fin_prdt_nm — TEXT
- etc_note — TEXT
- join_deny — INTEGER
- join_member — TEXT
- join_way — TEXT
- max_limit — INTEGER
- spcl_cnd — TEXT
- intr_rate_type_nm — VARCHAR(100)
- rsrv_type_nm — VARCHAR(100)
- save_trm — INTEGER
- intr_rate — FLOAT
- intr_rate2 — FLOAT
SavingOptions
- id — SERIAL
- product_id — INTEGER — NOT NULL
- fin_prdt_cd — TEXT
- intr_rate_type_nm — VARCHAR(100)
- rsrv_type_nm — VARCHAR(100)
- save_trm — INTEGER
- intr_rate — FLOAT
- intr_rate2 — FLOAT
SavingProducts
- id — SERIAL
- type — VARCHAR(10)
- fin_prdt_cd — TEXT
- fin_co_no — TEXT
- kor_co_nm — TEXT
- fin_prdt_nm — TEXT
- etc_note — TEXT
- join_deny — INTEGER
- join_member — TEXT
- join_way — TEXT
- max_limit — INTEGER
- spcl_cnd — TEXT
User
- id — SERIAL
- username — VARCHAR(150) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- nickname — VARCHAR(100)
- age — INTEGER
- earn — INTEGER
- family — INTEGER
- location — VARCHAR(100)
- risk — INTEGER
- term — INTEGER
- saving — INTEGER
- patience — INTEGER
- know — INTEGER
User_Product
- user_id — INTEGER — Primary key — NOT NULL
- product_id — INTEGER — Primary key — NOT NULL