Page Comparison

Groups

{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}

ADDRESS

1

Column Name	Data Type	Field Length	Null?	Data Def.	Comments
ID	NUMBER	22	N		Primary key2
TITLE	VARCHAR2	20			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		30
STREET_UNIT_TYPE	VARCHAR2	1000 BYTEBYTES	Y		With 9.9
31	STREET_TYPE	VARCHAR2	1000 BYTEBYTES	Y		With 9.932
BUILDING	VARCHAR2	1000 BYTEBYTES	Y		With 9.9
ADDRESS1	VARCHAR2	150 BYTES			With 10.3.1
ADDRESS2	VARCHAR2	150 BYTES			With 10.3.1