summaryrefslogtreecommitdiff
path: root/db/schema/companies.ts
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-10-15 12:52:11 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-10-15 12:52:11 +0000
commitb54f6f03150dd78d86db62201b6386bf14b72394 (patch)
treeb3092bb34805fdc65eee5282e86a9fb90ba20d6e /db/schema/companies.ts
parentc1bd1a2f499ee2f0742170021b37dab410983ab7 (diff)
(대표님) 커버, 데이터룸, 파일매니저, 담당자할당 등
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