Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- teamsoft_test=# \d info_user
- isreg | integer | | |
- position_id | integer | | |
- isholiday | integer | | |
- adjcol | integer | | |
- birthdate | timestamp without time zone | | |
- phonehome | character varying(255) | | |
- mobil_id | integer | | |
- phonemob | character varying(255) | | |
- email | character varying(255) | | |
- koef | money | | |
- description | bytea | | |
- time | bytea | | |
- guid | uuid | | |
- currenttime | timestamp without time zone | | | '2018-11-08 10:27:47.859104'::timestamp without time zone
- moduser | character varying(16) | | | '[dbo].[Get_CurrentCode]()'::character varying
- phone2 | character varying(255) | | |
- iscitydep | integer | | |
- isnowork | integer | | | 0
- ncard | character varying(255) | | |
- car | character varying(255) | | |
- po_login | character varying(255) | | |
- po_password | character varying(255) | | |
- export | integer | | |
- primeryimei | character varying(50) | | |
- alterimei | character varying(50) | | |
- gmt | integer | | | 2
- flags | integer | | |
- is_gps_disabled | integer | | |
- city_id | integer | | |
- iskam | integer | | |
- localname | character varying(255) | | |
- url | character varying(255) | | |
- carnum_id | integer | | |
- hexcolor | character varying(20) | | |
- iscontactsignenabled | integer | | |
- passportseries | character varying(5) | | |
- passportnumber | character varying(20) | | |
- identificationcode | character varying(10) | | |
- carmodel_id | integer | | |
- isabled | integer | | |
- clientappplatform | character varying(10) | | |
- inheritance_id | integer | | |
- area_approved | integer | | |
- flags_due_date | timestamp without time zone | | |
- Индексы:
- "pk_info_user" PRIMARY KEY, btree (id)
- "ix_info_user_guid" btree (guid)
- "ix_info_user_mobil_id" btree (mobil_id)
- "ix_info_user_position_id" btree (position_id)
- "ix_info_user_submission_id" btree (submission_id)
- "ix_info_user_time" btree ("time")
- Ограничения внешнего ключа:
- "fk_info_user_carmodel_id" FOREIGN KEY (carmodel_id) REFERENCES info_carmodel(id)
- "fk_info_user_carnum_info_car" FOREIGN KEY (carnum_id) REFERENCES info_car(id)
- "fk_info_user_info_city" FOREIGN KEY (city_id) REFERENCES info_city(id)
- "fk_info_user_info_user_inheritance" FOREIGN KEY (inheritance_id) REFERENCES info_user(id)
- Ссылки извне:
- TABLE "po_access_token" CONSTRAINT "fk__po_access__user___2108f5f7" FOREIGN KEY (user_id) REFERENCES info_user(id)
- TABLE "po_auth_code" CONSTRAINT "fk__po_auth_c__user___1d386513" FOREIGN KEY (user_id) REFERENCES info_user(id)
- TABLE "po_refresh_token" CONSTRAINT "fk__po_refres__user___24d986db" FOREIGN KEY (user_id) REFERENCES info_user(id)
- TABLE "info_actrevival" CONSTRAINT "fk_info_actrevival_info_user" FOREIGN KEY (user_id) REFERENCES info_user(id)
- TABLE "info_cheatentity" CONSTRAINT "fk_info_cheatentity_info_user" FOREIGN KEY (user_id) REFERENCES info_user(id) ON UPDATE CASCA:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement