금융상품
테이블 (5)
ARTICLE (article)
- article_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- title — VARCHAR
- content — VARCHAR
- created_at — DATETIME
- updated_at — DATETIME
COMMENT (comment)
- comment_id — INT — 기본 키 — NOT NULL
- article_id — INT — 외래 키 → ARTICLE.article_id — NOT NULL
- user_id (user_id2) — INT — 외래 키 → USER.user_id — NOT NULL
DepositProducts (depositproducts)
- dcls_month — TEXT
- kor_co_nm — TEXT
- fin_prdt_cd — TEXT
- join_member — TEXT
- fin_prdt_nm — TEXT
- etc_note — TEXT
- join_deny — INT
- join_way — TEXT
- spcl_cnd — TEXT
SavingProducts (savingproducts)
- dcls_month — TEXT
- kor_co_nm — TEXT
- fin_prdt_cd — TEXT
- join_member — TEXT
- fin_prdt_nm — TEXT
- etc_note — TEXT
- join_deny — INT
- join_way — TEXT
- spcl_cnd — TEXT
USER (user)
- user_id — INT — 기본 키 — NOT NULL
- password — VARCHAR
- email — VARCHAR
- nickname — VARCHAR
- age — INT
- asset — INT
- month_wage — INT