dbo.order_lines
Documentation | Sample GDPR Database Documentation |
Schema | dbo |
Name | order_lines |
Personal Data Level | No Personal Data |
Customer order lines.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Personal Data Level | ||
---|---|---|---|---|---|---|---|---|---|
1 | line_id | int | Identity | Row ID | No Personal Data | ||||
Row ID Identity Personal Data Level: No Personal Data |
|||||||||
2 | order_id | int | dbo.orders | Line order header. | No Personal Data | ||||
Line order header. References: dbo.orders Personal Data Level: No Personal Data |
|||||||||
3 | line_no | int | Line number within order, starting with 1. | No Personal Data | |||||
Line number within order, starting with 1. Personal Data Level: No Personal Data |
|||||||||
4 | product_id | int | dbo.products | Line product | No Personal Data | ||||
Line product References: dbo.products Personal Data Level: No Personal Data |
|||||||||
5 | quantity | int | Quantity of product | No Personal Data | |||||
Quantity of product Personal Data Level: No Personal Data |
|||||||||
6 | price | int | Price of product | No Personal Data | |||||
Price of product Personal Data Level: No Personal Data |
Exported: 2018-12-04 20:05, Last imported: 2018-12-03 17:00