CompanyCreditInventories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyId uuid 2147483647 null
Companies.id CompanyCreditInventories_companyId_fkey C
amount int4 10 null

Represents current credit balance of a company.
expiryDateTime timestamptz 35,6 √ null

Represents the end date of a company credit balance.
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CompanyCreditInventories_pkey Primary key Asc companyId

Check Constraints

Constraint Name Constraint
CompanyCreditInventories_amount_check ((amount >= 0))

Relationships

Close relationships within degrees of separation