summaryrefslogtreecommitdiff
path: root/db/schema/companies.ts
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema/companies.ts')
-rw-r--r--db/schema/companies.ts10
1 files changed, 10 insertions, 0 deletions
diff --git a/db/schema/companies.ts b/db/schema/companies.ts
index 60f8a0ce..b24acef0 100644
--- a/db/schema/companies.ts
+++ b/db/schema/companies.ts
@@ -11,3 +11,13 @@ export const companies = pgTable("companies", {
});
export type Company = typeof companies.$inferSelect
+
+export const ownerCompanies = pgTable("owner_companies", {
+ id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
+ name: varchar("name", { length: 255 }).notNull(),
+ createdAt: timestamp("created_at", { withTimezone: true })
+ .defaultNow()
+ .notNull(),
+});
+
+export type OwnerCompany = typeof ownerCompanies.$inferSelect