CreditConnect
Tables (6)
Account
- Account ID (id) — uuid — Primary key — NOT NULL
- Login ID (login_id) — string
- Name (name) — string
- Email (email) — email
- Phone (phone) — int
Customer
- Customer ID (id) — uuid — Primary key — NOT NULL
- Name (name) — string
- Vendor ID (vendor_id) — uuid — Foreign key → Vendors.Vendor ID — NOT NULL
Loan Origination
- Origination ID (id) — uuid — Primary key — NOT NULL
- Customer ID (customer_id) — uuid — Foreign key → Customer.Customer ID — NOT NULL
- Vendor ID (vendor_id) — uuid — Foreign key → Vendors.Vendor ID — NOT NULL
- Amount (request_amount) — int
- Approval (approve_yn) — bool
- Originate (origination_yn) — bool
- Reject Code (reject_code) — int — Foreign key → Reject Code.Code Number — NOT NULL
- Expire Date (expire_date) — datetime
Project
- Project ID (id) — uuid — Primary key — NOT NULL
- Project Name (name) — string
Reject Code
- Code Number (code) — int — Primary key — NOT NULL
- Description (description) — string
Vendors
- Vendor ID (id) — uuid — Primary key — NOT NULL
- Name (name) — string
- Category (category) — string