crm_address

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 customer_id character varying 27
4 addr_type character varying 3
5 dpid character varying 27
6 address_line_1 character varying 150
7 address_line_2 character varying 150
8 address_line_3 character varying 150
9 address_line_4 character varying 150
10 address_line_5 character varying 150
11 location character varying 120
12 state character varying 90
13 post_code character varying 30
14 country_code character varying 6
15 addr_ind character varying 3
16 timestampentered character varying 78
17 userentered character varying 30
18 timestampwritten character varying 78
19 userwritten character varying 30
20 delta_type character varying 3
21 effective_strt_dt timestamp without time zone
22 effective_end_dt timestamp without time zone