50 lines
845 B
TypeScript
50 lines
845 B
TypeScript
import { DataTypes, Model } from 'sequelize'
|
|
import path from 'path'
|
|
import db from '../config/sequelize.config'
|
|
import User from './User'
|
|
import Client from './Client'
|
|
|
|
class Instance extends Model {}
|
|
|
|
Instance.init(
|
|
{
|
|
_id: {
|
|
type: DataTypes.UUID,
|
|
defaultValue: DataTypes.UUIDV4,
|
|
primaryKey: true,
|
|
allowNull: false,
|
|
unique: true
|
|
},
|
|
name: {
|
|
type: DataTypes.STRING,
|
|
allowNull: false
|
|
},
|
|
hourlyRate: {
|
|
type: DataTypes.INTEGER,
|
|
allowNull: true
|
|
},
|
|
client_id: {
|
|
type: DataTypes.UUID,
|
|
allowNull: false,
|
|
references: {
|
|
model: Client,
|
|
key: '_id'
|
|
}
|
|
},
|
|
author_id: {
|
|
type: DataTypes.UUID,
|
|
allowNull: false,
|
|
references: {
|
|
model: User,
|
|
key: '_id'
|
|
}
|
|
}
|
|
},
|
|
{
|
|
sequelize: db,
|
|
tableName: path.basename(__filename).split('.')[0].toLowerCase()
|
|
}
|
|
)
|
|
|
|
export default Instance
|