prod
Tables (3)
bom (제품별자재리스트)
- id (PK) — int — Primary key — NOT NULL
- p_id (제품정보PK) — int — Foreign key → product_info.id — NOT NULL
- m_id (자재정보PK) — int — Foreign key → material_info.id — NOT NULL
- quantity (개수) — int
material_info (자재정보)
- id (PK) — int — Primary key — NOT NULL
- item (품명) — varchar
- standard (규격) — varchar
- spec (스펙) — varchar
product_info (제품정보)
- id (PK) — int — Primary key — NOT NULL
- product (제품) — varchar