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)