oxen

erd oxen

Tables (3)

Machine (기계)

  • component_id (PK) — Primary key — NOT NULL
  • machinery (분류) — char(255)
  • maker (브랜드) — char(255)
  • type (타입) — char(255)

Quotation (견적)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10

part (부품)

  • part_id (PK) — Primary key — NOT NULL
  • component_id (FK) — Foreign key → Machine.component_id — NOT NULL
  • part_number (부품번호) — char(255)
  • part_name (부품이름) — char(255)
  • description (부품설명) — char(255)