call_billing
Детальная тарификация исходящих звонков
Записей: ~325
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('call_billing_id_se... | |
| cdr_id | integer(32) | NOT NULL | → call_detail_records(id) | |
| organization_id | integer(32) | NOT NULL | → organizations(id) | |
| call_category | character varying(50) | NOT NULL | Категория: zone, long_distance, mobile | |
| duration | integer(32) | NOT NULL | ||
| billed_duration | integer(32) | NOT NULL | Длительность с учётом шага тарификации (секунды) | |
| price_per_minute | numeric(10,2) | NOT NULL | ||
| billing_step | integer(32) | NOT NULL | ||
| cost | numeric(10,2) | NOT NULL | Стоимость звонка | |
| created_at | timestamp without time zone | NOT NULL | CURRENT_TIMESTAMP |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| call_billing_cdr_id_key | CREATE UNIQUE INDEX call_billing_cdr_id_key ON public.call_billing USING btre... |
| call_billing_pkey | CREATE UNIQUE INDEX call_billing_pkey ON public.call_billing USING btree (id) |
| idx_call_billing_call_category | CREATE INDEX idx_call_billing_call_category ON public.call_billing USING btre... |
| idx_call_billing_cdr_id | CREATE INDEX idx_call_billing_cdr_id ON public.call_billing USING btree (cdr_id) |
| idx_call_billing_created_at | CREATE INDEX idx_call_billing_created_at ON public.call_billing USING btree (... |
| idx_call_billing_org_date | CREATE INDEX idx_call_billing_org_date ON public.call_billing USING btree (or... |
| idx_call_billing_organization_id | CREATE INDEX idx_call_billing_organization_id ON public.call_billing USING bt... |
Foreign Keys
| Колонка | Ссылка на |
|---|---|
| cdr_id | call_detail_records(id) |
| organization_id | organizations(id) |