선박의약품

테이블 (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