ssafy_final_pjt
Tables (3)
Options (Untitled2)
- OptionId (id) — INT — Primary key — NOT NULL
- FinPrdtCd (fin_prdt_cd) — Text
- IntrRateTypeNm (intr_rate_type_nm) — VARCHAR(100)(
- IntrRate (intr_rate) — Float
- IntrRate2 (intr_rate2) — Float
- SaveTrm (save_trm) — INT
- Field
- Product (product) — INT — Foreign key → Products.Id — NOT NULL
- UserId (id2) — INT — Foreign key → User.UserId — NOT NULL
- OptionId (id3) — INT — Foreign key → Options.OptionId — NOT NULL
- UserId (id4) — INT — Foreign key → User.UserId — NOT NULL
Products (Untitled)
- Id (id) — INT — Primary key — NOT NULL
- FinPrdtCd (fin_prdt_cd) — Text
- KorCoNm (kor_co_nm) — Text
- FinPrdtNm (fin_prdt_nm) — Text
- EtcNote (etc_note) — Text
- JoinDeny (join_deny) — INT
- JoinMember (join_member) — Text
- JoinWay (join_way) — Text
- SpclCnd (spcl_cnd) — Text
- MtrtInt (mtrt_int) — Text
- DSname — Text
- UserId (id2) — INT — Foreign key → User.UserId — NOT NULL
User
- UserId (id) — INT — Primary key — NOT NULL
- Username (username) — VARCHAR(30)
- Nickname (nickname) — VARCHAR(30)
- Email (email) — VARCHAR(254)
- Age (age) — INT
- Money (money) — INT
- Salary (salary) — INT
- JoinProducts (join_products) — INT
- Key — INT — NOT NULL
- FinancialProducts (financial_products) — INT — Foreign key → Products.Id — NOT NULL