Definition
a product table is a structured database that contains information about various products. It includes fields like product name, unique identifier, supplier details, unit price, quantity per unit, stock levels, orders, reorder level, and a flag to indicate if the product is discontinued.
Temporal and Spatial Information
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| Product Name | Product: Name, Text X(10) |
A distinct and typically descriptive label or title given to a specific product to identify and promote it to consumers is recorded as Text X(10).
Specific Information:
This is the name of the Product. |
- | X(10) |
| Product_id | Product: Unique Idenitifier, Identifier X(10) | Unique Number Assigned to a product is recorded as Identifier X(10). | CHARACTERSTRING | X(10) |
| Supplier_id | Supplier: Unique Identifier, Identifier X(10) |
A specific code or number assigned to a supplier or vendor to distinguish them from other suppliers in a business's records or databases is recorded as Identifier X(10). |
CHARACTERSTRING | X(10) |