diff options
Diffstat (limited to 'db/schema/generalContract.ts')
| -rw-r--r-- | db/schema/generalContract.ts | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/db/schema/generalContract.ts b/db/schema/generalContract.ts index 4d1de750..29479b20 100644 --- a/db/schema/generalContract.ts +++ b/db/schema/generalContract.ts @@ -146,6 +146,8 @@ export const generalContractItems = pgTable('general_contract_items', { // ═══════════════════════════════════════════════════════════════
quantity: decimal('quantity', { precision: 15, scale: 3 }), // 수량
quantityUnit: varchar('quantity_unit', { length: 50 }), // 수량단위
+ totalWeight: decimal('total_weight', { precision: 15, scale: 3 }), // 총 중량
+ weightUnit: varchar('weight_unit', { length: 50 }), // 중량단위
contractDeliveryDate: date('contract_delivery_date'), // 계약납기일
contractUnitPrice: decimal('contract_unit_price', { precision: 15, scale: 2 }), // 계약단가
contractAmount: decimal('contract_amount', { precision: 15, scale: 2 }), // 계약금액
|