server/models/video/video-views.ts

   1 import { AllowNull, BelongsTo, Column, CreatedAt, ForeignKey, Model, Table } from 'sequelize-typescript'
   2 import { VideoModel } from './video'
   3 import * as Sequelize from 'sequelize'
   4
   5 @Table({
   6   tableName: 'videoView',
   7   indexes: [
   8     {
   9       fields: [ 'videoId' ]
  10     }
  11   ]
  12 })
  13 export class VideoViewModel extends Model<VideoViewModel> {
  14   @CreatedAt
  15   createdAt: Date
  16
  17   @AllowNull(false)
  18   @Column(Sequelize.DATE)
  19   startDate: Date
  20
  21   @AllowNull(false)
  22   @Column(Sequelize.DATE)
  23   endDate: Date
  24
  25   @AllowNull(false)
  26   @Column
  27   views: number
  28
  29   @ForeignKey(() => VideoModel)
  30   @Column
  31   videoId: number
  32
  33   @BelongsTo(() => VideoModel, {
  34     foreignKey: {
  35       allowNull: false
  36     },
  37     onDelete: 'CASCADE'
  38   })
  39   Video: VideoModel
  40
  41 }