diff options
Diffstat (limited to 'db/schema/legal.ts')
| -rw-r--r-- | db/schema/legal.ts | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/db/schema/legal.ts b/db/schema/legal.ts index e4880517..3047bc2a 100644 --- a/db/schema/legal.ts +++ b/db/schema/legal.ts @@ -1,6 +1,7 @@ import { pgView,pgTable, serial, varchar, boolean, date, text, timestamp, integer, decimal } from 'drizzle-orm/pg-core'; import { vendors } from './vendors'; import { eq , sql, relations} from "drizzle-orm"; +import { basicContract } from './basicContractDocumnet'; // 법무 업무 테이블 export const legalWorks = pgTable('legal_works', { @@ -38,6 +39,8 @@ export const legalWorks = pgTable('legal_works', { // 메타데이터 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), + basicContractId: integer("basic_contract_id") + .references(() => basicContract.id, { onDelete: "set null" }), }); // 타입 정의 |