Transaction_address

Columns

Name	Type	Length	Precision	Scale	References	In	Description
bill_address_line_1	VARCHAR2	150					Billing address line 1
bill_address_line_2	VARCHAR2	150					Billing address line 2
bill_address_line_3	VARCHAR2	150					Billing address line 3
bill_city	VARCHAR2	50					Billing city
bill_company	VARCHAR2	100					Billing company
bill_country	VARCHAR2	50					Billing country
bill_name	VARCHAR2	150					Billing name
bill_phone_number	VARCHAR2	100					Billing phone number
bill_state	VARCHAR2	50					Billing state
bill_zip	VARCHAR2	36					Billing zip
return_address_line_1	VARCHAR2	150					Return address line 1
return_address_line_2	VARCHAR2	150					Return address line 2
return_city	VARCHAR2	50					Return city
return_country	VARCHAR2	50					Return country
return_state	VARCHAR2	36					Return state
return_zipcode	VARCHAR2	10					Return zip code
ship_address_line_1	VARCHAR2	150					Shipping address line 1
ship_address_line_2	VARCHAR2	150					Shipping address line 2
ship_address_line_3	VARCHAR2	150					Shipping address line 3
ship_city	VARCHAR2	50					Shipping city
ship_company	VARCHAR2	100					Shipping company
ship_country	VARCHAR2	50					Shipping country
ship_name	VARCHAR2	150					Shipping name
ship_phone_number	VARCHAR2	100					Shipping phone number
ship_state	VARCHAR2	50					Shipping state
ship_zip	VARCHAR2	36					Shipping zip code
transaction_address_id	NUMBER		22	0			Transaction address ID
transaction_id	NUMBER		22	0	transaction_id	Transactions	Transaction ID

Primary key (Composite)

PK Column Name
transaction_id
transaction_address_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
transaction_address_transactions_fk	transaction_id	Transactions	transaction_id	1