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