회사상품
테이블 (4)
Component (component)
- Component_id — VARCHAR — 기본 키 — NOT NULL
- Producer_ID (producer_id) — VARCHAR — 외래 키 → Producer.Producer_ID — NOT NULL
- ComponentDescription (componentdescription) — VARCHAR
- ComponentSpecification (componentspecification) — VARCHAR
- ComponentWeight (componentweight) — DECIMAL
- ProducerID (producerid) — INT
Producer (producer)
- Producer_ID (producer_id) — VARCHAR — 기본 키 — NOT NULL
- Producer_Name (producer_name) — VARCHAR
- Producer_Address (producer—address) — TEXT
- Phone_Number (phone_number) — VARCHAR
- Email (email) — VARCHAR
- Contact_Name (contact_name) — VARCHAR
Product (product)
- Product_id (product_id) — VARCHAR — 기본 키 — NOT NULL
- Association_ID (association_id) — VARCHAR — 외래 키 → ProductComponent.Association_ID — NOT NULL
- Product_id (product_id2) — VARCHAR — 외래 키 → ProductComponent.Product_id — NOT NULL
- Product Description (product description) — TEXT
- ProductPrice (productprice) — NUMERIC
- ProductionDate (productiondate) — DATE
- ProductStatus (productstatus) — VARCHAR
ProductComponent (productcomponent)
- Association_ID (association_id) — VARCHAR — 기본 키 — NOT NULL
- Product_id (product_id2) — VARCHAR — 외래 키 → Product.Product_id — NOT NULL
- Association_ID (association_id2) — VARCHAR — 외래 키 → Product.Association_ID — NOT NULL
- Product_id (product_id22) — VARCHAR — 외래 키 → Product.Product_id — NOT NULL
- Product_ID (product_id) — INT — NOT NULL
- Component_ID (component_id) — INT
- Quantity (quantity) — INT
- Batch_Number (batch_number) — VARCHAR