3jo
Tables (4)
products
- product_id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- expiration_date — DATE — NOT NULL
- quantity — INT — NOT NULL
sales
- sale_id — INT — Primary key
- quantity_sold — INT — NOT NULL
- total_price — DECIMAL(10,2) — NOT NULL
- sale_date — TIMESTAMP
- product_id — INT — Foreign key → products.product_id
stock_logs
- log_id — INT — Primary key
- change_type — ENUM('입고', '판매') — NOT NULL
- quantity_change — INT — NOT NULL
- change_time — TIMESTAMP
- product_id — INT — Foreign key → products.product_id
suppliers
- supplier_id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
- contact — VARCHAR(50)
- address — TEXT
- product_id — INT — Foreign key → products.product_id