선박의약품
테이블 (6)
drugs
- id — bigint — 기본 키 — NOT NULL
- name — text — NOT NULL
- category — text
- unit — text — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
lots
- id — bigint — 기본 키 — NOT NULL
- vessel_id — bigint — 외래 키 → vessels.id — NOT NULL
- drug_id — bigint — 외래 키 → drugs.id — NOT NULL
- lot_number — text — NOT NULL
- expiry_date — date — NOT NULL
- initial_quantity — int — NOT NULL
- remaining_quantity — int — NOT NULL
- received_at — timestamptz — NOT NULL
- created_at — timestamptz — NOT NULL
stock_requirements
- id — bigint — 기본 키 — NOT NULL
- vessel_id — bigint — 외래 키 → vessels.id — NOT NULL
- drug_id — bigint — 외래 키 → drugs.id — NOT NULL
- min_quantity — int — NOT NULL
- updated_at — timestamptz — NOT NULL
usage_allocations
- id — bigint — 기본 키 — NOT NULL
- usage_id — bigint — 외래 키 → usages.id — NOT NULL
- lot_id — bigint — 외래 키 → lots.id — NOT NULL
- quantity — int — NOT NULL
usages
- id — bigint — 기본 키 — NOT NULL
- vessel_id — bigint — 외래 키 → vessels.id — NOT NULL
- drug_id — bigint — 외래 키 → drugs.id — NOT NULL
- total_quantity — int — NOT NULL
- user_id — text — NOT NULL
- status — text — NOT NULL
- used_at — timestamptz — NOT NULL
- cancelled_at — timestamptz
- cancelled_by — text
- idempotency_key — text
- created_at — timestamptz — NOT NULL
vessels
- id — bigint — 기본 키 — NOT NULL
- name — text — NOT NULL
- created_at — timestamptz — NOT NULL