sms_billing
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('sms_billing_id_seq... |
|
| customer_uuid |
uuid |
NOT NULL |
|
|
| organization_id |
integer(32) |
NULL |
|
→ organizations(id) |
| recipient_phone |
character varying(20) |
NOT NULL |
|
|
| message_text |
text |
NULL |
|
|
| sms_price |
numeric(10,2) |
NOT NULL |
|
|
| cost |
numeric(10,2) |
NOT NULL |
|
|
| sent_at |
timestamp without time zone |
NOT NULL |
CURRENT_TIMESTAMP |
|
| created_at |
timestamp without time zone |
NOT NULL |
CURRENT_TIMESTAMP |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| idx_sms_billing_customer |
CREATE INDEX idx_sms_billing_customer ON public.sms_billing USING btree (cust... |
| idx_sms_billing_org |
CREATE INDEX idx_sms_billing_org ON public.sms_billing USING btree (organizat... |
| idx_sms_billing_sent_at |
CREATE INDEX idx_sms_billing_sent_at ON public.sms_billing USING btree (sent_at) |
| sms_billing_pkey |
CREATE UNIQUE INDEX sms_billing_pkey ON public.sms_billing USING btree (id) |
Foreign Keys