F4C_시연/발표
테이블 (33)
BlockchainCoolings
- id — INT
- coolingId — INT — NOT NULL
- isActive — BOOLEAN — NOT NULL
- transactionHash — VARCHAR(255)
- cteId — VARCHAR(255)
- tlc — VARCHAR(255)
- blockchainData — TEXT
- uploadedAt — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
BlockchainHarvestings
- id — INT
- harvestingId — INT — NOT NULL
- isActive — BOOLEAN — NOT NULL
- transactionHash — VARCHAR(255) — NOT NULL
- cteId — VARCHAR(255) — NOT NULL
- tlc — VARCHAR(255)
- nextRcptCode — VARCHAR(255)
- nextRcptBusinessName — VARCHAR(255) — NOT NULL
- nextRcptPhoneNumber — VARCHAR(255) — NOT NULL
- nextRcptAddrGeoLoc — VARCHAR(255) — NOT NULL
- nextRcptCity — VARCHAR(255) — NOT NULL
- nextRcptStateRegion — VARCHAR(255) — NOT NULL
- nextRcptPostalCode — VARCHAR(255) — NOT NULL
- nextRcptCountry — VARCHAR(255) — NOT NULL
- itemCode — VARCHAR(255) — NOT NULL
- commodity — VARCHAR(255) — NOT NULL
- variety — VARCHAR(255)
- quantity — DECIMAL(15, 2) — NOT NULL
- unitOfMeasure — VARCHAR(255) — NOT NULL
- farmCode — VARCHAR(255)
- farmBusinessName — VARCHAR(255) — NOT NULL
- farmPhoneNumber — VARCHAR(255) — NOT NULL
- farmAddrGeoLoc — VARCHAR(255) — NOT NULL
- farmCity — VARCHAR(255) — NOT NULL
- farmStateRegion — VARCHAR(255) — NOT NULL
- farmPostalCode — VARCHAR(255) — NOT NULL
- farmCountry — VARCHAR(255) — NOT NULL
- farmingArea — VARCHAR(255) — NOT NULL
- harvestDate — VARCHAR(255) — NOT NULL
- refDocType — VARCHAR(255) — NOT NULL
- refDocNumber — VARCHAR(255) — NOT NULL
- refDocType2 — VARCHAR(255)
- refDocNumber2 — VARCHAR(255)
- blockchainMetadata — JSON
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
BlockchainInitialPackings
- id — INT
- initialPackingId — INT — NOT NULL
- isActive — BOOLEAN — NOT NULL
- transactionHash — VARCHAR(255)
- cteId — VARCHAR(255)
- tlc — VARCHAR(255)
- blockchainStatus — VARCHAR(255) — NOT NULL
- blockchainData — TEXT
- apiResponse — TEXT
- errorMessage — TEXT
- uploadedAt — DATETIME — NOT NULL
- apiVersion — VARCHAR(255)
- endpointCalled — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
BlockchainReceivings
- id — INT
- receivingId — INT — NOT NULL
- isActive — BOOLEAN
- cteId — VARCHAR(36)
- tlc — VARCHAR(255)
- transactionHash — VARCHAR(255)
- transactionHashURL — VARCHAR(512)
- blockchainId — VARCHAR(255)
- uploadDate — DATETIME
- status — ENUM('Pending', 'Success', 'Failed', 'None')
- isCompliant — BOOLEAN
- blockchainData — JSON
- retries — INT
- errorMessage — TEXT
- blockNumber — BIGINT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
BlockchainShippings
- id — INT
- shippingId — INT — NOT NULL
- status — ENUM('Pending', 'Success', 'Failed') — NOT NULL
- txHash — VARCHAR(255)
- cteId — VARCHAR(255)
- tlc — VARCHAR(255)
- blockNumber — BIGINT
- payloadSnapshot — LONGTEXT
- errorMessage — TEXT
- uploadedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
BlockchainTransformations
- id — INT
- transformationId — INT — NOT NULL
- isActive — BOOLEAN
- cteId — VARCHAR(255)
- tlc — VARCHAR(255)
- transactionHash — VARCHAR(255)
- transactionHashURL — VARCHAR(255)
- blockchainData — JSON
- status — ENUM('Pending', 'Success', 'Failed')
- errorMessage — TEXT
- uploadedAt — DATETIME
- blockNumber — BIGINT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Companies
- id — INT
- businessNumber — VARCHAR(255) — NOT NULL
- businessNumberType — VARCHAR(255) — NOT NULL
- category — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone — VARCHAR(255) — NOT NULL
- country — VARCHAR(255) — NOT NULL
- state — VARCHAR(255) — NOT NULL
- city — VARCHAR(255) — NOT NULL
- postalCode — VARCHAR(255)
- address — VARCHAR(255)
- status — VARCHAR(255) — NOT NULL
- userId — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
CoolingHarvestings
- id — INT
- coolingId — INT — NOT NULL
- harvestingId — INT — NOT NULL
- quantity — FLOAT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Coolings
- id — INT
- userId — INT — NOT NULL
- itemId — INT — NOT NULL
- facilityId — INT — NOT NULL
- companyId — INT — NOT NULL
- lotCode — VARCHAR(255) — NOT NULL
- coolingDate — DATE — NOT NULL
- quantity — FLOAT — NOT NULL
- unit — VARCHAR(255) — NOT NULL
- referenceDoc1Type — VARCHAR(255) — NOT NULL
- referenceDoc1Number — VARCHAR(255) — NOT NULL
- referenceDoc2Type — VARCHAR(255)
- referenceDoc2Number — VARCHAR(255)
- blockchainCompliant — BOOLEAN — NOT NULL
- complianceIssues — JSON
- blockchainStatus — ENUM('pending', 'in_progress', 'completed', 'failed', 'archived') — NOT NULL
- transactionHash — VARCHAR(255)
- cteId — VARCHAR(255)
- blockchainUploadedAt — DATETIME
- tlc — VARCHAR(255)
- isActive — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Facilities
- id — INT
- facilityCode — VARCHAR(255) — NOT NULL
- siteName — VARCHAR(255) — NOT NULL
- fdaFfrn — VARCHAR(255)
- usage — VARCHAR(255)
- phone — VARCHAR(255) — NOT NULL
- registrationNumber — VARCHAR(255) — NOT NULL
- referenceDoc1Type — VARCHAR(255)
- referenceDoc1Number — VARCHAR(255)
- streetAddress — VARCHAR(255) — NOT NULL
- city — VARCHAR(255) — NOT NULL
- stateRegion — VARCHAR(255)
- postalCode — VARCHAR(255)
- country — VARCHAR(255)
- address — VARCHAR(255)
- status — VARCHAR(255) — NOT NULL
- userId — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Harvestings
- id — INT
- userId — INT — NOT NULL
- itemId — INT — NOT NULL
- facilityId — INT — NOT NULL
- companyId — INT — NOT NULL
- previousVersionId — INT
- lotCode — VARCHAR(255) — NOT NULL
- harvestDate — DATE — NOT NULL
- quantity — FLOAT — NOT NULL
- unit — VARCHAR(255) — NOT NULL
- referenceDoc1Type — VARCHAR(255) — NOT NULL
- referenceDoc1Number — VARCHAR(255) — NOT NULL
- referenceDoc2Type — VARCHAR(255)
- referenceDoc2Number — VARCHAR(255)
- blockchainCompliant — BOOLEAN — NOT NULL
- complianceIssues — JSON
- blockchainStatus — ENUM('pending', 'in_progress', 'completed', 'failed') — NOT NULL
- transactionHash — VARCHAR(255)
- cteId — VARCHAR(255)
- blockchainUploadedAt — DATETIME
- tlc — VARCHAR(255)
- usedQuantity — FLOAT — NOT NULL
- isActive — BOOLEAN — NOT NULL
- isStockAvailable — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
InitialPackingCoolings
- initialPackingId — INT — 기본 키 — NOT NULL
- coolingId — INT — 기본 키 — NOT NULL
- allocatedQuantity — DECIMAL(10, 2) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
InitialPackingHarvestings
- id — INT
- initialPackingId — INT — NOT NULL
- harvestingId — INT — NOT NULL
- allocatedQuantity — DECIMAL(10, 2) — NOT NULL
InitialPackings
- id — INT
- userId — INT — NOT NULL
- itemId — INT — NOT NULL
- facilityId — INT — NOT NULL
- productId — INT
- lotCode — VARCHAR(255) — NOT NULL
- initialPackingDate — DATEONLY — NOT NULL
- initialPackingQuantity — DECIMAL(10, 2) — NOT NULL
- unit — VARCHAR(255) — NOT NULL
- referenceDoc1Type — VARCHAR(255)
- referenceDoc1Number — VARCHAR(255)
- referenceDoc2Type — VARCHAR(255)
- referenceDoc2Number — VARCHAR(255)
- status — ENUM('Registered', 'Uploaded', 'Pending')
- blockchainStatus — ENUM('Pending', 'Success', 'Failed', 'None', 'completed')
- txHash — VARCHAR(255)
- tlc — VARCHAR(255)
- isActive — BOOLEAN
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ItemCompany
- itemId — INT — 기본 키 — NOT NULL
- companyId — INT — 기본 키 — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ItemFacility
- itemId — INT — 기본 키 — NOT NULL
- facilityId — INT — 기본 키 — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Items
- id — INT
- productCode — VARCHAR(255) — NOT NULL
- item — VARCHAR(255) — NOT NULL
- commodity — VARCHAR(255) — NOT NULL
- variety — VARCHAR(255)
- unit — VARCHAR(255) — NOT NULL
- movementType — VARCHAR(255) — NOT NULL
- status — VARCHAR(255) — NOT NULL
- species — VARCHAR(255)
- packagingStyle — VARCHAR(255)
- packagingSize — VARCHAR(255)
- packagingUnit — VARCHAR(255)
- userId — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ProductCompany
- productId — INT — 기본 키 — NOT NULL
- companyId — INT — 기본 키 — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ProductFacility
- productId — INT — 기본 키 — NOT NULL
- facilityId — INT — 기본 키 — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ProductItem
- productId — INT — 기본 키 — NOT NULL
- itemId — INT — 기본 키 — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Products
- id — INT
- productCode — VARCHAR(255) — NOT NULL
- productName — VARCHAR(255) — NOT NULL
- brandName — VARCHAR(255)
- commodity — VARCHAR(255)
- variety — VARCHAR(255)
- packagingSize — VARCHAR(255)
- packagingUnit — VARCHAR(255)
- packagingStyle — VARCHAR(255)
- unit — VARCHAR(255)
- movementType — VARCHAR(255)
- status — VARCHAR(255) — NOT NULL
- userId — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ReceivingCoolings
- id — INT
- receivingId — INT — NOT NULL
- coolingId — INT — NOT NULL
- allocatedQuantity — DECIMAL(10, 2) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ReceivingHarvestings
- id — INT
- receivingId — INT — NOT NULL
- harvestingId — INT — NOT NULL
- allocatedQuantity — DECIMAL(10, 2) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ReceivingInitialPackings
- id — INT
- receivingId — INT — NOT NULL
- initialPackingId — INT — NOT NULL
- allocatedQuantity — DECIMAL(10, 2) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Receivings
- id — INT
- userId — INT — NOT NULL
- companyId — INT — NOT NULL
- itemId — INT — NOT NULL
- facilityId — INT — NOT NULL
- productId — INT
- lotCode — VARCHAR(255) — NOT NULL
- receivingDate — DATEONLY — NOT NULL
- receivingQuantity — DECIMAL(10, 2) — NOT NULL
- unit — VARCHAR(255) — NOT NULL
- referenceDoc1Type — VARCHAR(255)
- referenceDoc1Number — VARCHAR(255)
- referenceDoc2Type — VARCHAR(255)
- referenceDoc2Number — VARCHAR(255)
- status — ENUM('Registered', 'Uploaded', 'Pending')
- blockchainStatus — ENUM('None', 'Pending', 'Success', 'Failed', 'completed')
- txHash — VARCHAR(255)
- tlc — VARCHAR(255)
- isCompliant — BOOLEAN
- isActive — BOOLEAN
- blockchainUploadedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ShippingInputInitialPacking
- shippingId — INT — 기본 키 — NOT NULL
- initialPackingId — INT — 기본 키 — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ShippingInputReceivings
- id — INT
- shippingId — INT — NOT NULL
- receivingId — INT — NOT NULL
- usedQuantity — DECIMAL(10, 2) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ShippingInputTransformations
- id — INT
- shippingId — INT — NOT NULL
- transformationId — INT — NOT NULL
- usedQuantity — DECIMAL(10, 2) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Shippings
- id — INT
- userId — INT — NOT NULL
- facilityId — INT — NOT NULL
- itemId — INT — NOT NULL
- productId — INT
- destinationCompanyId — INT — NOT NULL
- sourceLotCode — VARCHAR(255)
- shippingDate — DATEONLY — NOT NULL
- shippedQuantity — DECIMAL(10, 2) — NOT NULL
- unit — VARCHAR(255) — NOT NULL
- carrierName — VARCHAR(255)
- trackingNumber — VARCHAR(255)
- referenceDoc1Type — VARCHAR(255)
- referenceDoc1Number — VARCHAR(255)
- referenceDoc2Type — VARCHAR(255)
- referenceDoc2Number — VARCHAR(255)
- notes — TEXT
- tlc — VARCHAR(255)
- blockchainStatus — ENUM('None', 'Pending', 'Success', 'Failed') — NOT NULL
- txHash — VARCHAR(255)
- cteId — VARCHAR(255)
- blockchainUploadedAt — DATETIME
- isCompliant — BOOLEAN — NOT NULL
- isActive — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
TransformationInputInitialPacking
- transformationId — INT — 기본 키 — NOT NULL
- initialPackingId — INT — 기본 키 — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
TransformationInputReceivings
- transformationId — INT — 기본 키 — NOT NULL
- receivingId — INT — 기본 키 — NOT NULL
- usedQuantity — DECIMAL(10, 2) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Transformations
- id — INT
- userId — INT — NOT NULL
- facilityId — INT — NOT NULL
- itemId — INT — NOT NULL
- lotCode — VARCHAR(255) — NOT NULL
- transformationDate — DATEONLY — NOT NULL
- quantity — DECIMAL(10, 2) — NOT NULL
- unit — VARCHAR(255) — NOT NULL
- tlc — VARCHAR(255)
- referenceDoc1Type — VARCHAR(255)
- referenceDoc1Number — VARCHAR(255)
- referenceDoc2Type — VARCHAR(255)
- referenceDoc2Number — VARCHAR(255)
- notes — TEXT
- blockchainStatus — ENUM('None', 'Pending', 'Success', 'Failed', 'completed')
- txHash — VARCHAR(255)
- isCompliant — BOOLEAN
- isActive — BOOLEAN
- blockchainUploadedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Users
- id — INT
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- companyName — VARCHAR(255) — NOT NULL
- businessNumberType — VARCHAR(255) — NOT NULL
- businessNumber — VARCHAR(255) — NOT NULL
- contact — VARCHAR(255) — NOT NULL
- streetAddress — VARCHAR(255)
- city — VARCHAR(255)
- stateRegion — VARCHAR(255)
- postalCode — VARCHAR(255)
- country — VARCHAR(255)
- address — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL