loan

Tables (3)

organization_info (기관정보)

  • id (기관ID) — bigint — Primary key — NOT NULL
  • org_cd (기관코드) — varchar(5)

product_info (상품정보)

  • id (상품ID) — bigint — Primary key — NOT NULL
  • org_id (기관ID) — bigint — Foreign key → organization_info.id — NOT NULL
  • prod_cd (상품코드) — varchar(3)
  • prod_nm (상품명) — varchar(100)
  • prod_min_intr (최소이자) — double
  • prod_max_intr (최대이자) — double

user_info (유저정보)

  • id (유저ID) — bigint — Primary key — NOT NULL
  • usr_key (키) — varchar(255)
  • usr_nm (이름) — varchar(255)
  • usr_reg_num (주민번호) — varchar(255)
  • usr_icm_amt (수입) — bigint