· 5 years ago · Feb 25, 2020, 09:56 AM
1create table if not exists channels (
2 id serial,
3 device_id integer references devices (id) ,
4 channels_status text not null,
5 number_channel text not null,
6 channel_type_naming text not null,
7 channel_type_parameter text not null,
8 number_telephone text not null,
9 ip_address text,
10 iccid text,
11 ismsi text,
12 telecoms_operator text not null,
13 apn text,
14 gw_gateway text,
15 dialer_number text not null,
16 login text not null,
17 password text
18
19 unique (login),
20 primary key (id)
21);