diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 00:19:38 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 00:19:38 +0000 |
| commit | a383fd2a30f60360ebc0c1b897b3d43cbae178fa (patch) | |
| tree | 98adaae908465697ad627391e66113dc0694abb3 /db/schema | |
| parent | 71f4e15800b0cf771d1dddab6cc46fc7c2a17c51 (diff) | |
| parent | f30678aa2956620177e61cbcc0fb57e9ce6872f1 (diff) | |
Merge branch 'dujinkim' of https://github.com/DTS-Development/SHI_EVCP into dujinkim
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/docu-list-rule.ts | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/db/schema/docu-list-rule.ts b/db/schema/docu-list-rule.ts index 505b1c0d..27cace80 100644 --- a/db/schema/docu-list-rule.ts +++ b/db/schema/docu-list-rule.ts @@ -110,7 +110,7 @@ export const documentNumberTypes = pgTable("document_number_types", { // ===== Document Number Type Configs 테이블 ===== export const documentNumberTypeConfigs = pgTable("document_number_type_configs", { id: serial("id").primaryKey(), - documentNumberTypeId: integer("document_number_type_id").notNull().references(() => documentNumberTypes.id), + documentNumberTypeId: integer("document_number_type_id").notNull().references(() => documentNumberTypes.id, { onDelete: "cascade" }), codeGroupId: integer("code_group_id").references(() => codeGroups.id), // Code Group 참조 sdq: integer("sdq").notNull(), // 순서 번호 (1, 2, 3, 4, 5, 6) description: varchar("description", { length: 200 }), // Description (예: [001] PROJECT NO) @@ -143,7 +143,6 @@ export const codeGroupsRelations = relations(codeGroups, ({ many, one }) => ({ fields: [codeGroups.projectId], references: [projects.id], }), - documentClasses: many(documentClasses), // Code Group에 속한 Document Classes comboBoxSettings: many(comboBoxSettings), // Code Group에 속한 ComboBox Settings documentNumberTypeConfigs: many(documentNumberTypeConfigs), // Code Group을 참조하는 Number Type Configs })) @@ -155,10 +154,6 @@ export const documentClassesRelations = relations(documentClasses, ({ many, one references: [projects.id], }), documentClassOptions: many(documentClassOptions), // Document Class 하위 옵션들 - codeGroup: one(codeGroups, { - fields: [documentClasses.codeGroupId], - references: [codeGroups.id], - }), })) // Document Class Options 관계 |