ㅁㅁㅁ
Tables (6)
admin
- admin_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(20)
- password — VARCHAR(100) — NOT NULL
customer
- customer_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(50)
- email — VARCHAR(100)
- address — VARCHAR(200)
inbound
- inbound_id — SERIAL
- supplier_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL
- inbound_date — DATE — NOT NULL
- approved_by — INT
outbound
- outbound_id — SERIAL
- product_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- quantity — INT — NOT NULL
- destination — VARCHAR(200)
- outbound_date — DATE — NOT NULL
- approved_by — INT
product
- product_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2)
- stock_qty — INT
- storage_loc — VARCHAR(100)
supplier
- supplier_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- contact — VARCHAR(50)
- address — VARCHAR(200)