rendered paste bodyasterisk=# \d ast_monitor
Table "public.ast_monitor"
Column | Type | Modifiers
-------------+---------+-------------------------------------------------------------
id | integer | not null default nextval('public.ast_monitor_id_seq'::text)
ast_user_id | bigint | not null
Indexes:
"ast_monitor_pk" primary key, btree (id)
Foreign-key constraints:
"ast_user_id_fk" FOREIGN KEY (ast_user_id) REFERENCES ast_user(id) ON UPDATE CASCADE ON DELETE CASCADE
asterisk=# \d cdr
Table "public.cdr"
Column | Type | Modifiers
-------------+--------------------------+-----------
calldate | timestamp with time zone |
clid | character varying(80) |
src | character varying(80) |
dst | character varying(80) |
dcontext | character varying(80) |
channel | character varying(80) |
dstchannel | character varying(80) |
lastapp | character varying(80) |
lastdata | character varying(80) |
duration | integer |
billsec | integer |
accountcode | character varying(20) |
uniqueid | character varying(15) | not null
userfield | character varying(255) |
answer | timestamp with time zone |
disposition | character varying(20) |
amaflags | character varying(20) |
Indexes:
"cdr_pk" primary key, btree (uniqueid)