export const users = sqliteTable('users', {
id: text('id').$default(() => createId()).primaryKey(),
username: text('username').unique().notNull(),
email: text('email'),
//...
});
export const usersRelations = relations(users, ({ one, many }) => ({
auditLogs: many(auditLogs),
//...
}));
export const auditLogs = sqliteTable('audit_logs', {
userId: text('user_id').references(() => users.id, { onDelete: 'cascade' }),
action: text('action'),
timeStamp: text('time_stamp').$default(() => toISO8601(new Date())),
}, (table) => ({
unq: unique().on(table.userId, table.action, table.timeStamp),
}));
export const auditLogsRelations = relations(auditLogs, ({ one }) => ({
users: one(users),
}));
export const users = sqliteTable('users', {
id: text('id').$default(() => createId()).primaryKey(),
username: text('username').unique().notNull(),
email: text('email'),
//...
});
export const usersRelations = relations(users, ({ one, many }) => ({
auditLogs: many(auditLogs),
//...
}));
export const auditLogs = sqliteTable('audit_logs', {
userId: text('user_id').references(() => users.id, { onDelete: 'cascade' }),
action: text('action'),
timeStamp: text('time_stamp').$default(() => toISO8601(new Date())),
}, (table) => ({
unq: unique().on(table.userId, table.action, table.timeStamp),
}));
export const auditLogsRelations = relations(auditLogs, ({ one }) => ({
users: one(users),
}));