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