Address_book

Columns

Name Type Length Precision Scale References In Description
address VARCHAR2 999 Address
address_book_id NUMBER 39 0 Address book ID
address_id NUMBER 39 0 address_id
Addresses
address_line_1 VARCHAR2 150 Address line 1
address_line_2 VARCHAR2 150 Address line 2
address_line_3 VARCHAR2 150 Address line 3
attention VARCHAR2 150 Attention
city VARCHAR2 50 City
company VARCHAR2 100 Company
country VARCHAR2 50 Country
date_last_modified TIMESTAMP Date last modified
entity_id NUMBER 39 0 Entity ID
is_default_bill_address VARCHAR2 3 Default billing address
is_default_ship_address VARCHAR2 3 Default shipping address
is_inactive VARCHAR2 3 Whether is inactive
name VARCHAR2 150 Name
phone VARCHAR2 100 Phone number
state VARCHAR2 50 State
zip VARCHAR2 36 Zip

Primary key

PK Column Name
address_book_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
address_book_addresses_fk address_id Addresses address_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Billing_accounts_address_book_fk_1 address_book_id Billing_accounts bill_to_address_book_id 1
Billing_accounts_address_book_fk_2 address_book_id Billing_accounts ship_to_address_book_id 1