CompanyProductInventoryUsageFromBalanceLogs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyProductInventoryLogId uuid 2147483647 null
CompanyProductInventoryLogs.id CompanyProductInventoryUsageF_companyProductInventoryLogId_fkey C
userId uuid 2147483647 √ null
Users.id CompanyProductInventoryUsageFromBalanceLogs_userId_fkey N

Foreign key to Users table. Represents the user who use a job product from balance
relatedJobId uuid 2147483647 √ null
Jobs.id CompanyProductInventoryUsageFromBalanceLogs_relatedJobId_fkey N

Foreign key to Jobs table. Represents a job that is applied with a job product that user used
relatedApplicationId uuid 2147483647 √ null
Applications.id CompanyProductInventoryUsageFromBalan_relatedApplicationId_fkey N

Foreign key to Applications table. Represents an application that is applied with a product that user used

Indexes

Constraint Name Type Sort Column(s)
CompanyProductInventoryUsageFromBalanceLogs_pkey Primary key Asc companyProductInventoryLogId

Relationships

Close relationships within degrees of separation