Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

ADDRESS

Col #

Column Name

Data Type

Field Length

Null?

Data Def.

Comments

1

ID

NUMBER

22

N

 Primary key
2

CODE

VARCHAR2

128

Y

  
3

COMPANY

VARCHAR2

1020

Y

  
4

FIRST_NAME

VARCHAR2

240

Y

  
5

LAST_NAME

VARCHAR2

240

Y

  
6

CITY

VARCHAR2

128

Y

  
7

ZIP

VARCHAR2

128

Y

  
8

PHONE

VARCHAR2

128

Y

  
9

FAX

VARCHAR2

128

Y

  
10

EMAIL

VARCHAR2

512

Y

  
11

STREET

VARCHAR2

1024

Y

  
12

STREET_NUMBER

VARCHAR2

48

Y

  
13

STREET_UNIT

VARCHAR2

48

Y

  
14

FLOOR

VARCHAR2

48

Y

  
15

FLOOR_UNIT

VARCHAR2

128

Y

  
16

COUNTY

VARCHAR2

128

Y

  
17

COUNTRY

VARCHAR2

128

Y

  
18

STREET_CODE

VARCHAR2

128

Y

  
19

ADDRESS_CODE

VARCHAR2

128

Y

  
20

CO

VARCHAR2

255

Y

  
21

STATUS_ID

NUMBER

22

Y

  
22

ADDRESS_CHECK_DATE

DATE

7

Y

  
23

ADDRESS_PROOF

NUMBER

22

Y

  
24

COORDINATE_X

VARCHAR2

128

Y

  
25

COORDINATE_Y

VARCHAR2

128

Y

  
26

COMMENTS

VARCHAR2

4000

Y

  
27

DIRECTION

VARCHAR2

40

Y

  
28

ZIP_EXT

VARCHAR2

40

Y

  
29

ADDRESS_STATE

VARCHAR2

40

Y

  
30

STREET_UNIT_TYPE

VARCHAR2

1000 BYTE

Y With 9.9
31

STREET_TYPE

VARCHAR2

1000 BYTE

Y With 9.9
32

BUILDING

VARCHAR2

1000 BYTE

Y With 9.9

  • No labels