Database Examples/Pubs/Sales
From Wikiversity
Jump to navigation
Jump to search
| 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
|
