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 | 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x | import {
BelongsTo,
Column,
CreatedAt,
DataType,
ForeignKey,
Model,
Table,
UpdatedAt,
} from 'sequelize-typescript';
import User from './user.entity';
import GroupModel from './group.entity';
@Table({
tableName: 'sso_UserGroup',
timestamps: true,
createdAt: 'CreatedAt',
updatedAt: 'UpdatedAt',
})
export default class UserGroupModel extends Model {
@Column({
primaryKey: true,
type: DataType.INTEGER,
allowNull: false,
})
UserGroupId: number;
@ForeignKey(() => User)
@Column({
type: DataType.INTEGER,
field: 'UserId',
})
UserId: number;
@ForeignKey(() => GroupModel)
@Column({
primaryKey: true,
type: DataType.STRING(10),
allowNull: false,
})
GroupCode: string;
@Column({
type: DataType.CHAR(20),
defaultValue: 'Active',
})
Status: string;
@Column({
type: DataType.CHAR(1),
defaultValue: 'Y',
})
InheritGroupPrivilegeYN: string;
@Column({
type: DataType.CHAR(1),
defaultValue: 'Y',
})
InheritGroupSystemAccessYN: string;
@ForeignKey(() => User)
@Column({
type: DataType.INTEGER,
})
CreatedById: number;
@ForeignKey(() => User)
@Column({
type: DataType.INTEGER,
})
UpdatedById: number;
@CreatedAt
CreatedAt: Date;
@UpdatedAt
UpdatedAt: Date;
@BelongsTo(() => User, 'UserId')
User: User;
@BelongsTo(() => GroupModel)
Group: GroupModel;
@BelongsTo(() => User, 'CreatedById')
CreatedByUser: User;
@BelongsTo(() => User, 'UpdatedById')
UpdatedByUser: User;
}
|