Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- waypoint=# \d+ ascentium.leads
- Table "ascentium.leads"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
- -------------------+-----------------------------+-----------+----------+-------------------------------------------------+----------+--------------+-------------
- leadid | bigint | | not null | nextval('ascentium.leads_leadid_seq'::regclass) | plain | |
- firstname | character varying(100) | | | | extended | |
- lastname | character varying(50) | | | | extended | |
- address1 | character varying(250) | | | | extended | |
- address2 | character varying(250) | | | | extended | |
- city | character varying(50) | | | | extended | |
- state | character varying(50) | | | | extended | |
- zip | character varying(50) | | | | extended | |
- phone1 | character varying(25) | | | | extended | |
- phone2 | character varying(25) | | | | extended | |
- phone3 | character varying(25) | | | | extended | |
- email | character varying(50) | | | | extended | |
- inserttime | timestamp without time zone | | | | plain | |
- sourceid | integer | | | | plain | |
- assigned | boolean | | | false | plain | |
- sourceip | character varying(50) | | | | extended | |
- xselect1 | character varying(50) | | | | extended | |
- xselect2 | character varying(50) | | | | extended | |
- xselect3 | character varying(50) | | | | extended | |
- xselect4 | character varying(50) | | | | extended | |
- comments | character varying(500) | | | | extended | |
- dob | character varying(50) | | | | extended | |
- middlename | character varying(50) | | | | extended | |
- gender | character varying(50) | | | | extended | |
- pipolicynum | character varying(50) | | | | extended | |
- submitdate | character varying(50) | | | | extended | |
- xaffid | character varying(50) | | | | extended | |
- posturl | text | | | | extended | |
- leadip | character varying(250) | | | | extended | |
- insertdate | date | | not null | ('now'::text)::date | plain | |
- processed | boolean | | | false | plain | |
- phone1_cell_phone | boolean | | | | plain | |
- phone2_cell_phone | boolean | | | | plain | |
- email_domain | character varying(50) | | | | extended | |
- calculated_gender | character(1) | | | | extended | |
- nationality | character varying(50) | | | | extended | |
- has_full_postal | boolean | | | | plain | |
- campaigns | integer[] | | | | extended | |
- json_store | jsonb | | | | extended | |
- Partition key: RANGE (insertdate)
- Partitions: ascentium.leads_p2018_05 FOR VALUES FROM ('2018-05-01') TO ('2018-06-01'),
- ascentium.leads_p2018_06 FOR VALUES FROM ('2018-06-01') TO ('2018-07-01'),
- ascentium.leads_p2018_07 FOR VALUES FROM ('2018-07-01') TO ('2018-08-01'),
- ascentium.leads_p2018_08 FOR VALUES FROM ('2018-08-01') TO ('2018-09-01'),
- ascentium.leads_p2018_09 FOR VALUES FROM ('2018-09-01') TO ('2018-10-01'),
- ascentium.leads_p2018_10 FOR VALUES FROM ('2018-10-01') TO ('2018-11-01'),
- ascentium.leads_p2018_11 FOR VALUES FROM ('2018-11-01') TO ('2018-12-01'),
- ascentium.leads_p2018_12 FOR VALUES FROM ('2018-12-01') TO ('2019-01-01'),
- ascentium.leads_p2019_01 FOR VALUES FROM ('2019-01-01') TO ('2019-02-01')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement