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