Versions Compared

Old Version 2

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

ADDRESS

Col #

Column Name

Data Type

Field Length

Not Null?

Data Def.

Comments

1

ID

NUMBER

22

N

 Primary key2
TITLEVARCHAR220  With 10.3.1 to add title column to Address table

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

  

STREET_UNIT_TYPE

VARCHAR2

1000 BYTES

Y With 9.9

STREET_TYPE

VARCHAR2

1000 BYTES

Y With 9.9

BUILDING

VARCHAR2

1000 BYTES

Y With 9.9
ADDRESS1VARCHAR2150 BYTES  With 10.3.1
ADDRESS2VARCHAR2150 BYTES  With 10.3.1
Column
width33%