High performance self-hosted photo and video management solution.
TypeScript backup-toolfluttergoogle-photosgoogle-photos-alternativejavascriptmobile-appnestjsnodejsphoto-galleryphotosphotos-managementself-hostedsveltesveltekittypescriptvideos
import { Check } from '@immich/sql-tools';
import {
AfterInsertTrigger,
Column,
CreateDateColumn,
ForeignKeyColumn,
ForeignKeyConstraint,
type Generated,
PrimaryColumn,
Table,
Timestamp,
UpdateDateColumn,
} from '@immich/sql-tools';
import { UpdateIdColumn, UpdatedAtTrigger } from 'src/decorators.js';
import { PersonUserRole } from 'src/dtos/person.dto.js';
import { person_user_role_enum } from 'src/schema/enums.js';
import { person_user_after_insert } from 'src/schema/functions.js';
import { PersonTable } from 'src/schema/tables/person.table.js';
import { UserTable } from 'src/schema/tables/user.table.js';
@Table('person_user')
@UpdatedAtTrigger('person_user_updatedAt')
@AfterInsertTrigger({
name: 'person_user_after_insert',
scope: 'statement',
referencingNewTableAs: 'inserted_rows',
function: person_user_after_insert,
})
@ForeignKeyConstraint({
columns: ['sharedById', 'personGroupId'],
referenceColumns: ['ownerId', 'personGroupId'],
referenceTable: () => PersonTable,
onUpdate: 'CASCADE',
onDelete: 'CASCADE',
})
@Check({ name: 'person_user_sharedBy_sharedWith_chk', expression: `"sharedById" != "sharedWithId"` })
export class PersonUserTable {
@PrimaryColumn({ type: 'uuid' })
personGroupId!: string;
@PrimaryColumn({ type: 'uuid' })
sharedById!: string;
@ForeignKeyColumn(() => UserTable, {
onDelete: 'CASCADE',
onUpdate: 'CASCADE',
primary: true,
})
sharedWithId!: string;
@Column({ enum: person_user_role_enum })
role!: PersonUserRole;
@CreateDateColumn()
createdAt!: Generated<Timestamp>;
@UpdateDateColumn()
updatedAt!: Generated<Timestamp>;
@UpdateIdColumn({ index: true })
updateId!: Generated<string>;
}