inventory-management

Tables (5)

income (입고)

  • date (입고일) — date
  • request (발주번호) — uuid — Foreign key → request.id — NOT NULL
  • item (시약코드) — uuid — Foreign key → item.id — NOT NULL
  • quantity (입고수량) — integer

item (제품)

  • id (시약코드) — uuid — Primary key — NOT NULL
  • name (시약명) — character varying
  • price_recent (최근가격) — bigint

request (발주)

  • id (발주번호) — uuid — Primary key — NOT NULL
  • date (발주일) — timestamp without time zone
  • cost_total (발주총액) — bigint
  • user_id (사원번호) — uuid — Foreign key → user.user_id — NOT NULL
  • create_at (최초발주일) — date
  • last_modify_at (발주변경일) — date

request_item (주문물품)

  • id (시약코드) — uuid — Foreign key → item.id — NOT NULL
  • id (발주번호) — uuid — Foreign key → request.id — NOT NULL
  • price_per_unit (가격) — bigint
  • quantity (총발주량) — integer

user (사원)

  • user_id (사원번호) — uuid — Primary key — NOT NULL
  • name (이름) — character varying