Jump to content

Database Examples/Pubs/Sales

From Wikiversity

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
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