new

Tables (19)

ACTIVITY_TYPE

  • TypeCode — VARCHAR(50)
  • TypeName — VARCHAR(100) — NOT NULL

APPLICATION_STATUS

  • StatusCode — VARCHAR(50)
  • StatusName — VARCHAR(100) — NOT NULL

APPROVAL_ACTIVITY

  • ActivityId — INT
  • ApplicationId — INT — NOT NULL
  • Timestamp — DATETIME
  • EmployeeId — INT — NOT NULL
  • ActivityTypeCode — VARCHAR(50) — NOT NULL
  • Comments — TEXT

CORPORATE_CUSTOMER_DETAILS

  • CustomerId — INT
  • Name — VARCHAR(100) — NOT NULL
  • Identifier — VARCHAR(50) — NOT NULL
  • IndustryCode — VARCHAR(50)
  • FoundingDate — DATE
  • RepresentativeName — VARCHAR(100)

CUSTOMER

  • CustomerId — INT
  • CustomerType — VARCHAR(10) — NOT NULL
  • ContactInfo — VARCHAR(255)

DEPARTMENT

  • DepartmentId — INT
  • DepartmentName — VARCHAR(100) — NOT NULL

EMPLOYEE

  • EmployeeId — INT
  • Name — VARCHAR(100) — NOT NULL
  • RoleId — INT
  • DepartmentId — INT

GUARANTEE_CONDITION

  • ConditionCode — VARCHAR(50)
  • ConditionDescription — VARCHAR(255) — NOT NULL

GUARANTEE_REVIEW

  • GuaranteeReviewId — INT
  • ApplicationId — INT — NOT NULL
  • GuarantorId — INT — NOT NULL
  • RequestTimestamp — DATETIME
  • ResponseTimestamp — DATETIME
  • StatusCode — VARCHAR(50)
  • ApprovedAmount — DECIMAL(18, 2)
  • GuaranteeRate — DECIMAL(5, 2)
  • ReasonCode — VARCHAR(50)

GUARANTEE_REVIEW_CONDITION

  • GuaranteeReviewId — INT — Primary key — NOT NULL
  • ConditionCode — VARCHAR(50) — Primary key — NOT NULL

GUARANTEE_STATUS

  • StatusCode — VARCHAR(50)
  • StatusName — VARCHAR(100) — NOT NULL

GUARANTOR

  • GuarantorId — INT
  • Name — VARCHAR(100) — NOT NULL
  • ContactInfo — VARCHAR(255)

INDIVIDUAL_CUSTOMER_DETAILS

  • CustomerId — INT
  • Name — VARCHAR(100) — NOT NULL
  • Identifier — VARCHAR(50) — NOT NULL
  • WorkplaceName — VARCHAR(100)
  • WorkplaceBusinessNumber — VARCHAR(50)
  • IncomeAmount — DECIMAL(18, 2)
  • IncomeType — VARCHAR(50)

INTEREST_RATE_TYPE

  • TypeCode — VARCHAR(50)
  • TypeName — VARCHAR(100) — NOT NULL

LOAN_APPLICATION

  • ApplicationId — INT
  • CustomerId — INT — NOT NULL
  • ProductId — INT — NOT NULL
  • RequestedAmount — DECIMAL(18, 2) — NOT NULL
  • RequestedTerm — INT — NOT NULL
  • ApplicationDate — DATETIME
  • StatusCode — VARCHAR(50)
  • FinalAmount — DECIMAL(18, 2)
  • FinalRate — DECIMAL(5, 2)
  • FinalTerm — INT
  • DecisionDate — DATETIME

LOAN_PRODUCT

  • ProductId — INT
  • Name — VARCHAR(150) — NOT NULL
  • Description — TEXT
  • Version — INT — NOT NULL
  • StatusCode — VARCHAR(50)
  • CreatedAt — DATETIME
  • CreatedByEmployeeId — INT
  • ApprovedAt — DATETIME
  • ApprovedByEmployeeId — INT
  • MinLoanAmount — DECIMAL(18, 2)
  • MaxLoanAmount — DECIMAL(18, 2)
  • MinTermMonths — INT
  • MaxTermMonths — INT
  • InterestRateTypeCode — VARCHAR(50)
  • BaseInterestRate — DECIMAL(5, 2)
  • InterestRateSpread — DECIMAL(5, 2)
  • InterestRateDescription — VARCHAR(255)

PRODUCT_STATUS

  • StatusCode — VARCHAR(50)
  • StatusName — VARCHAR(100) — NOT NULL

REJECTION_REASON

  • ReasonCode — VARCHAR(50)
  • ReasonDescription — VARCHAR(255) — NOT NULL

ROLE

  • Key — Primary key — NOT NULL
  • RoleId — INT
  • RoleName — VARCHAR(100) — NOT NULL
  • Field (아이런) — 뭔데
  • Field2