ㅁㅁㅁ

Tables (6)

admin

  • admin_id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20)
  • password — VARCHAR(100) — NOT NULL

customer

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

inbound

  • inbound_id — SERIAL
  • 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 — SERIAL
  • 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 — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10,2)
  • stock_qty — INT
  • storage_loc — VARCHAR(100)

supplier

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