titleauthors

auJd char(11) not null

titlejd char(6) not null

au ord tinyint null

royaltyshare

float

null

unique composite index taind

409-56-7008

BU1032

0.6Q0Q00OOO

486-29-1786

PS7777

1.000000000

486-29-1786

PC9999

1.000000000

712-45-1867

MC2222

1.000000000

172-32-1176

PS3333

1.000000000

213-46-8915

BU1032

0.400000000

238-95-7766

PC1035

1.000000000

213-46-8915

BU2075

1.000000000

998-72-3567

PS2091

0.500000000

899-46-2035

PS2091

0.500000000

998-72-3567

PS2106

1.000000000

722-51-5454

MC3021

0.750000000

899-46-2035

MC3021

0.250000000

807-91-6654

TC3218

1.000000000

274-80-9391

BU7832

l.OOOOOOOOO

427-17-2319

PC8888

0.500000000

846-92-7186

PC8888

0.500000000

756-30-7391

PS1372

0.750000000

724-80-9391

PS1372

0.250000000

724-80-9391

BUllll

0.600000000

267-41-2394

BUllll

0.400000000

672-71-3249

TC7777

0.400000000

267-41-2394

TC7777

0.300000000

472-27-2349

TC7777

0.300000000

648-92-1872

TC4203

1.000000000

sales

sonum

storjd

ponum

sdate

char(4)

varchar(20)

date

not null

not null

not null

null

7066

QA7442.3

Sep 13 1985 12:00AM

7067

D4482

Sep 14 1985 12:00AM

7131

N914008

Sep 14 1985 12:00AM

7131

N914014

Sep 14 1985 12:00AM

8042

423LL922

Sep 14 1985 12:00AM

8042

423LL930

Sep 14 1985 12:00AM

6380

722a

Sep 13 1985 12:00AM

6380

6871

Sep 14 1985 12:00AM

8042

P723

Mar U 1988 12:00AM

7896

X999

Feb 21 1988 12:00AM

7896

QQ2299

Oct 28 1987 12:00AM

7896

TQ456

Dec 12 1987 12:00AM

8042

QA879.1

May 22 1987 12:00AM

7066

A2976

May 24 1987 12:00AM

7131

P3087a

May 29 1987 12:00AM

7067

P2121

Jun 15 1987 12:00AM

salesdetails

sonum

qtyjardered

qtyjshipped

title id

datejshipped

int

smallint

smallint

char(6)

date

not null

not null

null

not null

null

1

PS2091

Sep 15 1985 12:00AM

, 2

PS2091

Sep 15 1985 12:00AM

3

PS2091

Sep 18 1985 12:00AM

4

MC3021

Sep 18 1985 12:00AM

. 5

MC3021

Sep 14 1985 12:00AM

6

BU1032

Sep 22 1985 12:00AM

salesdatails

sonum

qtyjordered

qty shipped

title id

datejshipped

smallint

smallint

char(6)

date

not null

not null

null

not null

null

PS2091

Sep 20 1985 12:00AM

BU1032

Sep 14 1985 12:0OAH

BUllll

Mar 28 1988 12:00AH

BU2075

Mar 15 1988 12:00AM

BU7832

Oct 29 1987 12:00AM

MC2222

Jan 12 1988 12:00AM

PCI 035

May 24 1987 12:00AM

PC8888

May 24 1987 12:00AM

PS1372

May 29 1987 12:00AM

PS2106

Apr 29 1987 12;O0AM

PS3333

May 29 1987 12:00AM

PS7777

Jun 13 1987 12:00AM

TC3218

Jun 15 1987 12:00AM

TC4203

May 30 1987 12:00AM

TC7777

Jun 17 1987 12:00AM

editors

ed id cttar(ll) not null

edjname varchar(40) not null

edjname varcliar(20) not null

edjios

varchar(12)

null

phone

char(IS)

null

address

varchar(40)

null

city

varchar(20) null

state

char(2)

null

charts) null

unique

index

edind

composite index ednmind

321-55-8906

DeLongue

Martinella

project

415 843-2222

3000 6th St.

Berkeley

94710

723-48-9010

Sparks

Manfred

copy

303 721-3388

15 Sail

Denver

80237

777-02-9831

Samuelson

Bernard

project

415 843-6990

27 Yosemite

Oakland

94609

777-66-9902

Almond

Alfred

copy

312 699-4177

1010 E. Devon

Chicago

60018

826-11-9034

iiimmel

Eleanore

project

617 423-0552

97 Bleaker

Boston

02210

885-23-9140

Rutherford-Hayes

Hannah

project

301 468-3909

32 RockbiU Pike

RockbiU

20852

993-86-0420

McCann

Dennis

acquisition

301 468-3909

32 RockbiU Pike

RockbiU

20852

943-88-7920

Kaspchek

Christof

acquisition

415 549-3909

18 Severe Rd.

Berkeley

94710

234-88-9720

Hunter

Amanda

acquisition

617 432-5586

18 Dowdy Ln.

Boston

02210

titleditors

edjd

title id

edjord

char(11)

char(6)

tinyint

not null

not null

null

unique composite index

teind

826-11-9034

BU2075

826-11-9034

PS2091

826-11-9034

PS2106

826-11-9034

PS3333

826-11-9034

PS7777

826-11-9034

PS1372

885-23-9140

MC2222

885-23-9140

MC3021

885-23-9140

TC3281

885-23-9140

TC4203

885-23-9140

TC7777

32J-55-8906

BO1032

321-55-8906

BUllll

321-55-8906

BU7832

321-55-8906

PC1035

321-55-8906

PC8888

321-55-8906

BU2075

777-02-9831

PC1035

777-02-9831

PC8888

943-88-7920

BU1032

titleditors

edJd

titlejd

ed ord

char(11)

char(6)

tinyint

not null

not null

null

unique composite index

teind

943-88-7920

BUllll

943-88-7920

BU2075

943-88-7920

BU7832

943-88-7920

PC1035

943-88-7920

PC8888

993-86-0420

PS1372

993-86-0420

PS2091

993-86-0420

PS2106

993-86-0420

PS3333

993-86-0420

PS7777

993-86-0420

MC2222

993-86-0420

MC3021

993-86-0420

TC3218

993-86-0420

TC4203

993-86-0420

TC7777

royshed

title id

lorange

hirange

royalty

char(6)

float

not null

null

null

null

index

rstidind

BU1032

5000

0.100000

BU1032

5001

50000

0.120000

PC1035

2000

0.100000

PC1035

2001

4000

0.120000

PC1035

4001

50000

0.160000

BU2075

1000

0.100000

BU2075

1001

5000

0.120000

BU2075

5001

7000

0.160000

BU2075

7001

50000

0.180000

PS9999

50000

0.100000

PS2091

1000

0.100000

PS2091

1001

5000

0.120000

PS2091

5001

50000

0.140000

PS2106

2000

0.100000

PS2106

2001

5000

0.120000

PS2106

5001

50000

0.140000

MC3021

1000

0.100000

HC3021

1001

2000

0.120000

MC3021

2001

6000

0.140000

MC3021

6001

8000

0.180000

MC3021

8001

50000

0.200000

TC3218

2000

0.100000

TC3218

2001

6000

0.120000

TC3218

6001

8000

0.160000

TC3218

8001

50000

0.160000

PC8e88

5000

0.100000

PC8888

5001

50000

0.120000

PS7777

5000

0.100000

PS7777

5001

50000

0.120000

PS3333

5000

0.100000

PS3333

5001

50000

0.120000

MC3026

1000

0.100000

MC3026

lOOl

2000

0.120000

MC3026

2001

6000

0,140000

MC3026

6001

8000

0.180000

MC3026

8001

50000

0.200000