Database Examples/Pubs/Sales
Appearance
< Database Examples | Pubs
Fields
[edit | edit source]Field Name | Field Type | Length | Index | Constraint | Default |
---|---|---|---|---|---|
orderid | Integer | Primary Key | Not Null | ||
ord_detail | Text | 20 | Yes | Not Null | |
stor_id | Integer | Yes | Foreign Key | ||
ord_date | Date | 20 | Yes | Today | |
qty | Integer | ||||
payterms | Text | 12 | |||
title_id | Text | 6 | Yes | Foreign Key |
Data
[edit | edit source]orderid | ord_detail | stor_id | ord_date | qty | payterms | title_id |
---|---|---|---|---|---|---|
1 | 6871 | 6380 | 9/14/2024 | 5 | Net 60 | BU1032 |
2 | 722a | 6380 | 9/13/2024 | 3 | Net 60 | PS2091 |
3 | A2976 | 7066 | 5/24/2023 | 50 | Net 30 | PC8888 |
4 | QA7442.3 | 7066 | 9/13/2024 | 75 | ON invoice | PS2091 |
5 | D4482 | 7067 | 9/14/2024 | 10 | Net 60 | PS2091 |
6 | P2121 | 7067 | 6/15/2022 | 40 | Net 30 | TC3218 |
7 | P2121 | 7067 | 6/15/2022 | 20 | Net 30 | TC4203 |
8 | P2121 | 7067 | 6/15/2022 | 20 | Net 30 | TC7777 |
9 | N914008 | 7131 | 9/14/2024 | 20 | Net 30 | PS2091 |
10 | N914014 | 7131 | 9/14/2024 | 25 | Net 30 | MC3021 |
11 | P3087a | 7131 | 5/29/2023 | 20 | Net 60 | PS1372 |
12 | P3087a | 7131 | 5/29/2023 | 25 | Net 60 | PS2106 |
13 | P3087a | 7131 | 5/29/2023 | 15 | Net 60 | PS3333 |
14 | P3087a | 7131 | 5/29/2023 | 25 | Net 60 | PS7777 |
15 | QQ2299 | 7896 | 10/28/2023 | 15 | Net 60 | BU7832 |
16 | TQ456 | 7896 | 12/12/2023 | 10 | Net 60 | MC2222 |
17 | X999 | 7896 | 2/21/2023 | 35 | ON invoice | BU2075 |
18 | 423LL922 | 8042 | 9/14/2024 | 15 | ON invoice | MC3021 |
19 | 423LL930 | 8042 | 9/14/2024 | 10 | ON invoice | BU1032 |
20 | P723 | 8042 | 3/11/2023 | 25 | Net 30 | BU1111 |
21 | QA879.1 | 8042 | 5/22/2023 | 30 | Net 30 | PC1035 |