123

Tables (9)

Copy Of Untitled (SavingProducts)

  • Key (id) — int — Primary key — NOT NULL
  • Field (fin_prdt_cd) — text(unique)
  • Field (kor_co_nm) — text
  • Field (fin_prdt_nm) — text
  • Field (join_deny) — int
  • Field (join_way) — text
  • Field (spcl_cnd) — text

Copy Of Untitled2 (SavingOptions)

  • Key (id) — int — Primary key — NOT NULL
  • Key (product) — int — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (fin_prdt_cd) — text
  • Field (intr_rate_type_nm) — varchar(100)
  • Field (intr_rate) — float
  • Field (intr_rate2) — float
  • Field (rsrv_type_nm) — text
  • Field (save_trm) — int

Loan (LoanProducts)

  • Key (id) — int — Primary key — NOT NULL
  • Field (fin_prdt_cd) — text
  • Field (cb_name) — text
  • Field (fin_co_no) — text
  • Field (kor_co_nm) — text
  • Field (fin_prdt_nm) — text
  • Field (crdt_prdt_type) — int
  • Field (join_way) — text

LoanOption (LoanOptions)

  • Key (id) — int — Primary key — NOT NULL
  • Key (product) — int — Foreign key → Loan.Key — NOT NULL
  • Field (crdt_lend_rate_type_nm) — text
  • Field (crdt_grad_1) — float
  • Field2 (crdt_grad_4) — float
  • Field3 (crdt_grad_5) — float
  • Field4 (crdt_grad_6) — float
  • Field5 (crdt_grad_10) — float
  • Field6 (crdt_grad_11) — float
  • Field7 (crdt_grad_12) — float
  • Field8 (crdt_grad_13) — float
  • Field9 (crdt_grad_avg) — float

Untitled (DepositProducts)

  • Key (id) — int — Primary key — NOT NULL
  • Field (fin_prdt_cd) — text(unique)
  • Field (kor_co_nm) — text
  • Field (fin_prdt_nm) — text
  • Field (join_deny) — int
  • Field (join_way) — text
  • Field (spcl_cnd) — text

Untitled (DepositOptions)

  • Key (id) — int — Primary key — NOT NULL
  • Key (product) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (fin_prdt_cd) — text
  • Field (intr_rate_type_nm) — varchar(100)
  • Field (intr_rate) — float
  • Field (intr_rate2) — float
  • Field (save_trm) — int

Untitled (Articles)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user) — int — Foreign key → User.Key — NOT NULL
  • Field (title) — varchar(100)
  • Field (content) — text
  • Field (created_at) — DateTime
  • Field (updated_at) — DateTime

Untitled (Comments)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user) — int — Foreign key → User.Key — NOT NULL
  • Key (article) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — text
  • Field (created_at) — DateTime
  • Field (updated_at) — DateTime

User

  • Key (id) — int — Primary key — NOT NULL
  • Field2 (salary) — int
  • Field3 (asset) — int
  • Field (age) — int
  • Field (financial_products) — TEXT