asterisk=# \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)