Databases > pubs > Tables > sales

pubs

sales

Created: Modified:

Columns

  • stor_id
    [char](4) NOT NULL
  • ord_num
    [varchar](20) NOT NULL
  • ord_date
    [datetime] NOT NULL
  • qty
    [smallint] NOT NULL
  • payterms
    [varchar](12) NOT NULL
  • title_id
    [tid] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [varchar](6) NOT NULL

Indexes

  • UPKCL_sales
    UNIQUE CLUSTERED
    stor_id , ord_num , title_id
  • titleidind
    NONCLUSTERED
    title_id

Foreign Keys

  • FK__sales__stor_id__37A5467C
    stores
    stor_id ⥱ stor_id
  • FK__sales__title_id__38996AB5
    titles
    title_id ⥱ title_id

Sample Data

stor_id
ord_num
ord_date
qty
payterms
title_id
6380
6871
5
Net 60
BU1032
6380
722a
3
Net 60
PS2091
7066
A2976
50
Net 30
PC8888
7066
QA7442.3
75
ON invoice
PS2091
7067
D4482
10
Net 60
PS2091
7067
P2121
40
Net 30
TC3218
7067
P2121
20
Net 30
TC4203
7067
P2121
20
Net 30
TC7777
7131
N914008
20
Net 30
PS2091
7131
N914014
25
Net 30
MC3021
7131
P3087a
20
Net 60
PS1372
7131
P3087a
25
Net 60
PS2106
7131
P3087a
15
Net 60
PS3333
7131
P3087a
25
Net 60
PS7777
7896
QQ2299
15
Net 60
BU7832
7896
TQ456
10
Net 60
MC2222
7896
X999
35
ON invoice
BU2075
8042
423LL922
15
ON invoice
MC3021
8042
423LL930
10
ON invoice
BU1032
8042
P723
25
Net 30
BU1111
8042
QA879.1
30
Net 30
PC1035