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