phone_codes
Записей: ~247
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('phone_codes_id_seq... | |
| region_id | integer(32) | NULL | ||
| zone_code | character varying(3) | NOT NULL | ||
| city_code | character varying(5) | NOT NULL | ||
| local_digits | integer(32) | NOT NULL | ||
| name | character varying(200) | NOT NULL | ||
| is_regional_center | boolean | NULL | false | |
| is_active | boolean | NULL | true | |
| created_at | timestamp without time zone | NULL | CURRENT_TIMESTAMP | |
| sort_order | integer(32) | NULL | 0 |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| idx_phone_codes_city | CREATE INDEX idx_phone_codes_city ON public.phone_codes USING btree (city_code) |
| idx_phone_codes_region | CREATE INDEX idx_phone_codes_region ON public.phone_codes USING btree (region... |
| idx_phone_codes_zone | CREATE INDEX idx_phone_codes_zone ON public.phone_codes USING btree (zone_code) |
| phone_codes_city_code_key | CREATE UNIQUE INDEX phone_codes_city_code_key ON public.phone_codes USING btr... |
| phone_codes_pkey | CREATE UNIQUE INDEX phone_codes_pkey ON public.phone_codes USING btree (id) |