From 27fc640a9eae70813e9f02cda2c27a4509a04591 Mon Sep 17 00:00:00 2001
From: Xianny <8582774+xianny@users.noreply.github.com>
Date: Tue, 8 Jan 2019 13:50:51 -0800
Subject: fetch and save copper (#1472)

Fetch and save Copper CRM
---
 packages/pipeline/src/entities/copper_activity.ts | 41 +++++++++++++++++++++++
 1 file changed, 41 insertions(+)
 create mode 100644 packages/pipeline/src/entities/copper_activity.ts

(limited to 'packages/pipeline/src/entities/copper_activity.ts')

diff --git a/packages/pipeline/src/entities/copper_activity.ts b/packages/pipeline/src/entities/copper_activity.ts
new file mode 100644
index 000000000..cbc034285
--- /dev/null
+++ b/packages/pipeline/src/entities/copper_activity.ts
@@ -0,0 +1,41 @@
+import { Column, Entity, Index, PrimaryColumn } from 'typeorm';
+
+import { numberToBigIntTransformer } from '../utils';
+
+@Entity({ name: 'copper_activities', schema: 'raw' })
+export class CopperActivity {
+    @PrimaryColumn({ type: 'bigint', transformer: numberToBigIntTransformer })
+    public id!: number;
+
+    @Index()
+    @Column({ name: 'parent_id', type: 'bigint', transformer: numberToBigIntTransformer })
+    public parentId!: number;
+    @Column({ name: 'parent_type', type: 'varchar' })
+    public parentType!: string;
+
+    // join with CopperActivityType
+    @Index()
+    @Column({ name: 'type_id', type: 'bigint', transformer: numberToBigIntTransformer })
+    public typeId!: number;
+    @Column({ name: 'type_category', type: 'varchar' })
+    public typeCategory!: string;
+    @Column({ name: 'type_name', type: 'varchar', nullable: true })
+    public typeName?: string;
+
+    @Column({ name: 'user_id', type: 'bigint', transformer: numberToBigIntTransformer })
+    public userId!: number;
+    @Column({ name: 'old_value_id', type: 'bigint', nullable: true, transformer: numberToBigIntTransformer })
+    public oldValueId?: number;
+    @Column({ name: 'old_value_name', type: 'varchar', nullable: true })
+    public oldValueName?: string;
+    @Column({ name: 'new_value_id', type: 'bigint', nullable: true, transformer: numberToBigIntTransformer })
+    public newValueId?: number;
+    @Column({ name: 'new_value_name', type: 'varchar', nullable: true })
+    public newValueName?: string;
+
+    @Index()
+    @Column({ name: 'date_created', type: 'bigint', transformer: numberToBigIntTransformer })
+    public dateCreated!: number;
+    @PrimaryColumn({ name: 'date_modified', type: 'bigint', transformer: numberToBigIntTransformer })
+    public dateModified!: number;
+}
-- 
cgit