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