import { relations } from "drizzle-orm";
import { serial, text, pgTable, timestamp, integer, varchar, uuid } from "drizzle-orm/pg-core";
export const user = pgTable('user', {
uuid: uuid('uuid').defaultRandom().primaryKey(),
name: text('name'),
email: text('email').notNull(),
surname: text('surname'),
password: text('password'),
role: text('role').$type<'admin' | 'user'>(),
createdAt: timestamp('created_at'),
updatedAt: timestamp('updated_at'),
});
export const event = pgTable('event', {
id: serial('id').primaryKey(),
name: text('name'),
category: text('email').notNull(),
description: varchar('description', { length: 256 }),
createdAt: timestamp('created_at'),
updatedAt: timestamp('updated_at'),
user_id: integer('user_id')
});
export const userRelations = relations(user, ({ many }) => ({
event: many(event)
}));
export const eventRelations = relations(event, ({ one }) => ({
user: one(user, {
fields: [event.user_id],
references: [user.uuid]
})
}));
import { relations } from "drizzle-orm";
import { serial, text, pgTable, timestamp, integer, varchar, uuid } from "drizzle-orm/pg-core";
export const user = pgTable('user', {
uuid: uuid('uuid').defaultRandom().primaryKey(),
name: text('name'),
email: text('email').notNull(),
surname: text('surname'),
password: text('password'),
role: text('role').$type<'admin' | 'user'>(),
createdAt: timestamp('created_at'),
updatedAt: timestamp('updated_at'),
});
export const event = pgTable('event', {
id: serial('id').primaryKey(),
name: text('name'),
category: text('email').notNull(),
description: varchar('description', { length: 256 }),
createdAt: timestamp('created_at'),
updatedAt: timestamp('updated_at'),
user_id: integer('user_id')
});
export const userRelations = relations(user, ({ many }) => ({
event: many(event)
}));
export const eventRelations = relations(event, ({ one }) => ({
user: one(user, {
fields: [event.user_id],
references: [user.uuid]
})
}));