dbo.orders
Documentation | Sample GDPR Database Documentation |
Schema | dbo |
Name | orders |
Personal Data Level | No Personal Data |
List of customer orders.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Personal Data Level | ||
---|---|---|---|---|---|---|---|---|---|
1 | order_id | int | Identity | Row ID | No Personal Data | ||||
Row ID Identity Personal Data Level: No Personal Data |
|||||||||
2 | date | datetime | Order date | No Personal Data | |||||
Order date Personal Data Level: No Personal Data |
|||||||||
3 | customer_id | int | dbo.customers | Customer that placed order | No Personal Data | ||||
Customer that placed order References: dbo.customers Personal Data Level: No Personal Data |
|||||||||
4 | status | nchar(10) | Order status: Pending payment, Paid, Closed | No Personal Data | |||||
Order status: Pending payment, Paid, Closed Personal Data Level: No Personal Data |
Exported: 2018-12-04 20:05, Last imported: 2018-12-03 17:00