IAM-Inventory
Tables (7)
AppleClassification (사과분류내역)
- ac_id (PK) — Long — Primary key — NOT NULL
- apple_code (사과식별코드) — VARCHAR
- weight (사과무게) — INTEGER
- rotten (부패 여부) — Boolean
- image_class (품질모델결과) — ENUM
- quality (최종 품질) — ENUM
MonitoringData (공장모니터링정보)
- monitoring_data_id (PK) — LONG — Primary key — NOT NULL
- temperature (온도) — FLOAT
- humidity (습도) — FLOAT
- timestamp (시각) — DATETIME
Products (제품 정보)
- products_id (PK) — Long — Primary key — NOT NULL
- name (이름) — VARCHAR
- description (정보) — VARCHAR
- category (카테고리) — VARCHAR
- created_at (생성일) — DATETIME
- updated_at (수정일) — DATETIME
- deleted_at (삭제일) — DATETIME
- deleted (삭제 여부) — Boolean
QualityClassification (품질분류내역)
- qc_id (PK) — Long — Primary key — NOT NULL
- products_id (제품정보) — Long — Foreign key → Products.products_id — NOT NULL
- image_identifier (이미지식별자) — VARCHAR
- classification_result (두번째분류결과) — ENUM
- weight (무게) — FLOAT
- timestamp (시각) — DATETIME
RottenClassification (부패판별내역)
- qc_id (PK) — Long — Primary key — NOT NULL
- products_id (제품정보) — Long — Foreign key → Products.products_id — NOT NULL
- image_identifier (이미지식별자) — VARCHAR
- classification_result (첫번째분류결과) — ENUM
- timestamp (시각) — DATETIME
Transactions (입출고내역)
- transactions_id (PK) — Long — Primary key — NOT NULL
- type (입/출고) — ENUM
- quantity (품목 수) — INTEGER
- timestamp (시각) — DATETIME
- automated (자동화된 기록) — Boolean
- memo (메모) — VARCHAR
- variation (총 변화량) — INTEGER
TransactionsDetail (입출고 상세 내역)
- inventory_id (PK) — Long — Primary key — NOT NULL
- transactions_id (속한 트랜잭션) — Long — Foreign key → Transactions.transactions_id — NOT NULL
- products_id (상품 정보) — Long — Foreign key → Products.products_id — NOT NULL
- previous_stock (이전 재고) — INTEGER
- current_stock (현재 재고) — INTEGER