diff options
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/rfqLast.ts | 17 | ||||
| -rw-r--r-- | db/schema/vendorDocu.ts | 3 |
2 files changed, 20 insertions, 0 deletions
diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts index 34c61cd0..a9f91308 100644 --- a/db/schema/rfqLast.ts +++ b/db/schema/rfqLast.ts @@ -315,6 +315,23 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => { LIMIT 1 )`.as("major_item_material_code"), + majorItemMaterialDescription: sql<string | null>`( + SELECT material_description + FROM rfq_pr_items + WHERE rfqs_last_id = ${rfqsLast.id} + AND major_yn = true + LIMIT 1 + )`.as("major_item_materialD_description"), + + + majorItemMaterialCategory: sql<string | null>`( + SELECT material_category + FROM rfq_pr_items + WHERE rfqs_last_id = ${rfqsLast.id} + AND major_yn = true + LIMIT 1 + )`.as("major_item_material_category"), + majorItemPrNo: sql<string | null>`( SELECT pr_no FROM rfq_pr_items diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 927c566d..c37bc2ec 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -73,10 +73,12 @@ export const documents = pgTable( uniqueContractDocStatus: uniqueIndex("unique_contract_doc_status").on( table.contractId, table.docNumber, + table.discipline, table.status ), uniqueContractVendorDoc: uniqueIndex("unique_contract_vendor_doc").on( table.contractId, + table.discipline, table.vendorDocNumber ).where(sql`${table.vendorDocNumber} IS NOT NULL`), @@ -92,6 +94,7 @@ export const documents = pgTable( uniqueProjectDocStatus: uniqueIndex("unique_project_doc_status").on( table.projectId, table.docNumber, + table.discipline, table.status ), // uniqueProjectVendorDoc: uniqueIndex("unique_project_vendor_doc").on( |