Object descriptions
Schema Name Object Description
public schema_info table Migration info is stored here

(1 row)

Table "public.schema_info"
Column Type Modifiers Description
version integer   The current migration version

Has OIDs: no

Object descriptions
Schema Name Object Description
public user_variables table Variables for each user are stored here as key/value pairs

(1 row)

Table "public.user_variables"
Column Type Modifiers Description
id integer not null default nextval('user_variables_id_seq'::regclass)  
name text    
value text   The variable's value
user_id integer not null  

Indexes:
    "user_variables_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "user_variables_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
Has OIDs: no

Object descriptions
Schema Name Object Description
public targets table Store the endpoints which calls can be redirected to here

(1 row)

Table "public.targets"
Column Type Modifiers Description
id integer not null default nextval('targets_id_seq'::regclass)  
value text not null  
type text not null default 'landline'::text  
priority integer not null default 1  
user_id integer   A user target, references users.id
did_id integer   A DID target, references dids.id

Indexes:
    "targets_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "targets_did_id_fkey" FOREIGN KEY (did_id) REFERENCES dids(id) ON DELETE CASCADE
    "targets_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
Has OIDs: no

Object descriptions
Schema Name Object Description
public dids table Store each indbound DID (Direct Inward Dial) we accept here

(1 row)

Table "public.dids"
Column Type Modifiers Description
id integer not null default nextval('dids_id_seq'::regclass)  
number text not null  
primary boolean default false  
description text    
clid_name text   The name to send when redirecting calls from this DID
user_id integer    

Indexes:
    "dids_pkey" PRIMARY KEY, btree (id)
Has OIDs: no

Object descriptions
Schema Name Object Description
public users table Store each user of the system here

(1 row)

Table "public.users"
Column Type Modifiers Description
id integer not null default nextval('users_id_seq'::regclass)  
cidr text default '0.0.0.0/0'::text The cidr mask a user can authenticate from
mailbox text   The mailbox shortcut for a user
password text   The password to authenticate the username to FreeSWITCH (SIP/MENUS)
active boolean default false  
dialstring text default '{presence_id=${dialed_user}@${dialed_domain}}${sofia_contact(default/${dialed_user}@${dialed_domain})}'::text The default dialstring for a user
first_name text    
last_name text    
extension character varying(10) not null The user's extension. must be numeric to log in via phone, accepting leading zeros forces String
pin character varying(10)   The pin number used for authentication on phone applications (same rules as pin, d+)
username character varying(40)    

Indexes:
    "users_pkey" PRIMARY KEY, btree (id)
Has OIDs: no