Test

Tables (3)

TB_BANK

  • institute_code — varchar(20) — Primary key — NOT NULL
  • institute_name — varchar(50)
  • create_datetime — datetime
  • use_yn — char(1)

TB_CREDIT_GUARANTEE_HISTORY

  • year — int(4) — Primary key — NOT NULL
  • month — int(2) — Primary key — NOT NULL
  • institute_code (institute_code2) — varchar(20) — Foreign key → TB_BANK.institute_code — NOT NULL
  • amount — int(11)
  • create_datetime — datetime

TB_USER

  • user_seq — int(11) — Primary key — NOT NULL
  • id — varchar(50)
  • password — varchar(100)
  • name — varchar(20) — NOT NULL
  • refresh_token — varchar(200) — NOT NULL
  • create_datetime — datetime