it융합

테이블 (6)

Admin

  • admin_id — INT
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('inbound','outbound','super')
  • password — VARCHAR(100) — NOT NULL

Customer

  • customer_id — INT
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(50)
  • email — VARCHAR(100)
  • address — VARCHAR(200)

Inbound

  • inbound_id — INT
  • supplier_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • inbound_date — DATE — NOT NULL
  • approved_by — INT

Outbound

  • outbound_id — INT
  • product_id — INT — NOT NULL
  • customer_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • destination — VARCHAR(200)
  • outbound_date — DATE — NOT NULL
  • approved_by — INT

Product

  • product_id — INT
  • name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10,2)
  • stock_qty — INT
  • storage_loc — VARCHAR(100)

Supplier

  • supplier_id — INT
  • name — VARCHAR(100) — NOT NULL
  • contact — VARCHAR(50)
  • address — VARCHAR(200)