회사상품

테이블 (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