vms_holdings

Tables (7)

medicine_aliases

  • id — BIGSERIAL
  • medicine_id — BIGINT — Foreign key — NOT NULL
  • alias — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

medicine_requests

  • id — BIGSERIAL
  • vessel_id — BIGINT — Foreign key → vessels.id — NOT NULL
  • medicine_id — BIGINT — Foreign key → medicines.id — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • requested_quantity — INT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL
  • note — TEXT
  • created_at — TIMESTAMP — NOT NULL

medicines

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • unit — VARCHAR(50) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

stock_lots

  • id — BIGSERIAL
  • vessel_id — BIGINT — Foreign key → vessels.id — NOT NULL
  • medicine_id — BIGINT — Foreign key → medicines.id — NOT NULL
  • lot_number — VARCHAR(100) — NOT NULL
  • quantity — INT — NOT NULL
  • remaining_quantity — INT — NOT NULL
  • expiration_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • received_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

usage_records

  • id — BIGSERIAL
  • medicine_request_id — BIGINT — Foreign key → medicine_requests.id — NOT NULL
  • vessel_id — BIGINT — Foreign key → vessels.id — NOT NULL
  • medicine_id — BIGINT — Foreign key → medicines.id — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • stock_lot_id — BIGINT — Foreign key → stock_lots.id
  • quantity_used — INT — NOT NULL
  • dispensed_at — TIMESTAMP — NOT NULL
  • note — TEXT
  • created_at — TIMESTAMP — NOT NULL

vessel_medicine_requirements

  • id — BIGSERIAL
  • vessel_id — BIGINT — Foreign key → vessels.id — NOT NULL
  • medicine_id — BIGINT — Foreign key → medicines.id — NOT NULL
  • minimum_quantity — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

vessels

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • imo_number — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL