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