[Feature] Active, Archived and Soft Deleted records

[evereq]

I think actually most of our entities should have the following standard fields:

1. isActive - when we want to temporarily make some record not active and not be returned by most of the queries, metrics/reports, or disallow login of certain users, etc.

2. isDeleted - when someone removed some record (but we need to keep it for Audit purposes or even for some past periods accounting, etc.) Note: for now we will use the "standard" deletedAt field in TypeORM used for Soft Delete feature, see https://typeorm.io/delete-query-builder#soft-delete

3. isArchived - when something becomes not important anymore and can be archived, e.g. created 3 years ago some expense record.

[rahul-rocket]

@Gramosx So for this feature, We will have to add above columns into BaseEntity file. See below example.

export abstract class BaseEntity extends Model implements IBaseEntityModel {
	@ApiPropertyOptional({ type: () => String })
	@PrimaryGeneratedColumn('uuid')
	id?: string;

	// When record was created in our DB
	@ApiProperty({
		type: 'string',
		format: 'date-time',
		example: '2018-11-21T06:20:32.232Z',
	})
	@CreateDateColumn()
	createdAt?: Date;

	// When record was updated in our DB
	@ApiProperty({
		type: 'string',
		format: 'date-time',
		example: '2018-11-21T06:20:32.232Z',
	})
	@UpdateDateColumn()
	updatedAt?: Date;

	// Indicates if record is active now
	@ApiPropertyOptional({ type: Boolean, default: true })
	@Column({ nullable: false, default: true })
	isActive: boolean;

	// Indicate if record is archived
	@ApiPropertyOptional({ type: Boolean, default: false })
	@Column({ nullable: false, default: false })
	isArchived: boolean;
}

Note: This could be a complex task, so please let me know if you will have any issues or concern about this feature.

[rahul-rocket]

@Gramosx Just for reference https://wanago.io/2021/10/25/api-nestjs-soft-deletes-postgresql-typeorm/