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