3팀

테이블 (5)

inquiry (문의 사항)

  • Key (BIGINT) — BIGINT — 기본 키 — NOT NULL
  • title (VARCHART) — VARCHART
  • quantity (INTEGER) — INTEGER
  • status (DECIMAL) — DECIMAL
  • min_quantity (Field5) — INTEGER
  • inventory (BIGINT2) — BIGINT — 외래 키 → inventory.inventory — NOT NULL — FK 외래키 inventory

inventory (재고)

  • inventory (BIGINT) — BIGINT — 기본 키 — NOT NULL
  • product_name (VARCHART) — VARCHART
  • quantity (INTEGER) — INTEGER
  • unit_price (DECIMAL) — DECIMAL
  • min_quantity (Field5) — INTEGER
  • Field

inventory_arrival (재고 도착 정보)

  • Key (BIGINT) — BIGINT — 기본 키 — NOT NULL
  • product_name (VARCHART) — VARCHART
  • quantity (INTEGER) — INTEGER
  • supplier_name (DECIMAL) — DECIMAL
  • min_quantity (Field5) — INTEGER
  • inventory (inventory_id) — BIGINT — 외래 키 → inventory.inventory — NOT NULL — FK 재고 외래키

notification (알림)

  • Key (BIGINT) — BIGINT — 기본 키 — NOT NULL
  • title (VARCHART) — VARCHART
  • quantity (INTEGER) — INTEGER
  • status (DECIMAL) — DECIMAL
  • min_quantity (Field5) — INTEGER
  • inventory (BIGINT2) — BIGINT — 외래 키 → inventory.inventory — NOT NULL

notification (모니터링)

  • monitoring_id — BIGINT — 기본 키 — NOT NULL
  • check_date (VARCHART) — TIMESTAMP
  • quantity (INTEGER) — INTEGER
  • status (DECIMAL) — VARCHAR
  • notes (Field5) — TEXT
  • inventory (BIGINT) — BIGINT — 외래 키 → inventory.inventory — NOT NULL