Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 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 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 | 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x | import {
BelongsTo,
Column,
CreatedAt,
DataType,
ForeignKey,
HasMany,
Model,
Table,
UpdatedAt,
} from 'sequelize-typescript';
import User from './user.entity';
@Table({
tableName: 'sso_Staff',
timestamps: true,
createdAt: 'CreatedAt',
updatedAt: 'UpdatedAt',
})
export default class Staff extends Model {
@Column({
primaryKey: true,
allowNull: false,
type: DataType.STRING(10),
})
StaffNo: string;
@ForeignKey(() => User)
@Column({
allowNull: false,
type: DataType.INTEGER,
})
UserId: number;
@Column({
allowNull: false,
type: DataType.STRING(200),
})
FullName: string;
@Column({
allowNull: false,
type: DataType.STRING(200),
})
PreferredName: string;
@Column({
allowNull: true,
type: DataType.STRING(20),
})
IdNo: string;
@Column({
allowNull: false,
type: DataType.STRING(100),
})
StaffType: string;
@Column({
allowNull: false,
type: DataType.STRING(100),
})
JobTitle: string;
@Column({
allowNull: true,
type: DataType.STRING(20),
})
CarPlate: string;
@Column({
allowNull: true,
type: DataType.STRING(20),
})
Mobile: string;
@Column({
allowNull: true,
type: DataType.INTEGER,
})
Floor: string;
@Column({
allowNull: true,
type: DataType.STRING(20),
})
Extension: number;
@Column({
allowNull: false,
type: DataType.STRING(100),
})
Status: string;
@CreatedAt
CreatedAt: Date;
@UpdatedAt
UpdatedAt: Date;
@BelongsTo(() => User, 'UserId')
User: User;
@BelongsTo(() => User, 'CreatedById')
CreatedByUser: User;
@BelongsTo(() => User, 'UpdatedById')
UpdatedByUser: User;
}
|