backend/annualVestingStatement.js at main · Vesting-Vault/backend · GitHub

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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
const { DataTypes } = require('sequelize');

module.exports = (sequelize) => {
  const AnnualVestingStatement = sequelize.define('AnnualVestingStatement', {
    id: {
      type: DataTypes.UUID,
      defaultValue: DataTypes.UUIDV4,
      primaryKey: true
    },
    userAddress: {
      type: DataTypes.STRING,
      allowNull: false,
      field: 'user_address'
    },
    year: {
      type: DataTypes.INTEGER,
      allowNull: false
    },
    statementData: {
      type: DataTypes.JSONB,
      allowNull: false,
      field: 'statement_data'
    },
    pdfFilePath: {
      type: DataTypes.STRING,
      field: 'pdf_file_path'
    },
    digitalSignature: {
      type: DataTypes.TEXT,
      field: 'digital_signature'
    },
    transparencyKeyPublicAddress: {
      type: DataTypes.STRING,
      field: 'transparency_key_public_address'
    },
    generatedAt: {
      type: DataTypes.DATE,
      defaultValue: DataTypes.NOW,
      field: 'generated_at'
    },
    accessedAt: {
      type: DataTypes.DATE,
      field: 'accessed_at'
    },
    isArchived: {
      type: DataTypes.BOOLEAN,
      defaultValue: false,
      field: 'is_archived'
    },
    totalVestedAmount: {
      type: DataTypes.DECIMAL(36, 18),
      defaultValue: 0,
      field: 'total_vested_amount'
    },
    totalClaimedAmount: {
      type: DataTypes.DECIMAL(36, 18),
      defaultValue: 0,
      field: 'total_claimed_amount'
    },
    totalUnclaimedAmount: {
      type: DataTypes.DECIMAL(36, 18),
      defaultValue: 0,
      field: 'total_unclaimed_amount'
    },
    totalFMVUSD: {
      type: DataTypes.DECIMAL(36, 18),
      defaultValue: 0,
      field: 'total_fmv_usd'
    },
    totalRealizedGainsUSD: {
      type: DataTypes.DECIMAL(36, 18),
      defaultValue: 0,
      field: 'total_realized_gains_usd'
    },
    numberOfVaults: {
      type: DataTypes.INTEGER,
      defaultValue: 0,
      field: 'number_of_vaults'
    },
    numberOfClaims: {
      type: DataTypes.INTEGER,
      defaultValue: 0,
      field: 'number_of_claims'
    }
  }, {
    tableName: 'annual_vesting_statements',
    timestamps: false
  });

  return AnnualVestingStatement;
};