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