import { EntitySchema } from "typeorm";
export const Product = new EntitySchema({
name: "Product",
tableName: "PRODUCTS",
columns: {
id: {
primary: true,
name: "ID",
type: "uuid",
generated: "uuid",
},
createdAt: {
name: "CREATED_AT",
type: "timestamp",
default: () => "CURRENT_TIMESTAMP",
},
updatedAt: {
name: "UPDATED_AT",
type: "timestamp",
default: () => "CURRENT_TIMESTAMP",
},
createdBy: {
name: "CREATED_BY",
type: "varchar",
length: 255,
nullable: true,
},
updatedBy: {
name: "UPDATED_BY",
type: "varchar",
length: 255,
nullable: true,
},
name: {
name: "NAME",
type: "varchar",
length: 255,
nullable: false,
},
description: {
name: "DESCRIPTION",
type: "text",
nullable: true,
},
amount: {
name: "AMOUNT",
type: "int",
default: 0,
},
validity: {
name: "VALIDITY",
type: "date",
nullable: true,
},
active: {
name: "ACTIVE",
type: "boolean",
default: true,
},
companyId: {
name: "companyId",
type: "uuid",
nullable: true,
},
averageCost: {
name: "AVERAGE_COST",
type: "decimal",
precision: 10,
scale: 2,
nullable: true,
},
unit: {
name: "UNIT",
type: "varchar",
length: 50,
nullable: true,
},
},
});