summaryrefslogtreecommitdiff
path: root/packages/backend/src/models/PromoNote.ts
diff options
context:
space:
mode:
authorsyuilo <Syuilotan@yahoo.co.jp>2023-09-20 11:33:36 +0900
committersyuilo <Syuilotan@yahoo.co.jp>2023-09-20 11:33:36 +0900
commit053da10e94c2412f58215116a958c0922261a610 (patch)
treed608ce6350d5b209178390c3ab56c1fd0d30c438 /packages/backend/src/models/PromoNote.ts
parentfix (diff)
downloadsharkey-053da10e94c2412f58215116a958c0922261a610.tar.gz
sharkey-053da10e94c2412f58215116a958c0922261a610.tar.bz2
sharkey-053da10e94c2412f58215116a958c0922261a610.zip
refactor(backend): update directory structure for models
Diffstat (limited to 'packages/backend/src/models/PromoNote.ts')
-rw-r--r--packages/backend/src/models/PromoNote.ts33
1 files changed, 33 insertions, 0 deletions
diff --git a/packages/backend/src/models/PromoNote.ts b/packages/backend/src/models/PromoNote.ts
new file mode 100644
index 0000000000..f4425fe88b
--- /dev/null
+++ b/packages/backend/src/models/PromoNote.ts
@@ -0,0 +1,33 @@
+/*
+ * SPDX-FileCopyrightText: syuilo and other misskey contributors
+ * SPDX-License-Identifier: AGPL-3.0-only
+ */
+
+import { PrimaryColumn, Entity, Index, JoinColumn, Column, OneToOne } from 'typeorm';
+import { id } from './util/id.js';
+import { MiNote } from './Note.js';
+import type { MiUser } from './User.js';
+
+@Entity('promo_note')
+export class MiPromoNote {
+ @PrimaryColumn(id())
+ public noteId: MiNote['id'];
+
+ @OneToOne(type => MiNote, {
+ onDelete: 'CASCADE',
+ })
+ @JoinColumn()
+ public note: MiNote | null;
+
+ @Column('timestamp with time zone')
+ public expiresAt: Date;
+
+ //#region Denormalized fields
+ @Index()
+ @Column({
+ ...id(),
+ comment: '[Denormalized]',
+ })
+ public userId: MiUser['id'];
+ //#endregion
+}