Spaces:
Sleeping
Sleeping
File size: 1,243 Bytes
525d39f | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | import { Entity, PrimaryGeneratedColumn, Column, CreateDateColumn, Index } from 'typeorm';
import { jsonColumnType } from '../../../common/utils/column-types';
export enum MessageDirection {
INCOMING = 'incoming',
OUTGOING = 'outgoing',
}
export enum MessageStatus {
PENDING = 'pending',
SENT = 'sent',
DELIVERED = 'delivered',
READ = 'read',
FAILED = 'failed',
}
@Entity('messages')
@Index(['sessionId', 'createdAt'])
@Index(['chatId'])
export class Message {
@PrimaryGeneratedColumn('uuid')
id: string;
@Column()
@Index()
sessionId: string;
@Column({ nullable: true })
waMessageId: string;
@Column()
chatId: string;
@Column()
from: string;
@Column()
to: string;
@Column({ type: 'text', nullable: true })
body: string;
@Column({ default: 'text' })
type: string;
@Column({
type: 'varchar',
default: MessageDirection.OUTGOING,
})
direction: MessageDirection;
@Column({ type: 'bigint', nullable: true })
timestamp: number;
@Column({ type: jsonColumnType(), nullable: true })
metadata: Record<string, unknown>;
@Column({
type: 'varchar',
default: MessageStatus.SENT,
})
@Index()
status: MessageStatus;
@CreateDateColumn()
createdAt: Date;
}
|