sys_users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id INT 10 √ null
action_trigger_log.proxy_user_id FK_smqpikec6m62sx16l491kuvlq R
action_trigger_log.user_id FK_k3ah5v112nc8vh7wsxgkdwtq5 R
action_trigger_queue.user_id FK_qdg1csppw8fek4tjfo8udiy1j R
asset_log.proxy_user_id FK4E6AC575A1B485D2 R
asset_log.user_id FK4E6AC57528C762A3 R
asset_warranty_note.user_id FK7B5B7E4628C762A3 R
contract_holder_support.user_id FK503B5F0928C762A3 R
dashboard.user_id FKC18AEA9428C762A3 R
dealer_request.assigned_user_id fk_assigned_user_id R
dealer_request.created_by_id FK_n287624sgt1287ltwkry7k189 R
dealer_request.last_update_by_id FK_sjp7m071bthllv1ev5ore64f1 R
dealer_request_clarification.created_by_id fk_dealer_request_clarification_created_by R
dealer_request_clarification.last_updated_by_id fk_dealer_request_clarification_last_updated_by R
dealer_request_lease.created_by_id fk_dealer_request_lease_created_by R
dealer_request_log.proxy_user_id fk_dealer_request_log_proxy_user_id R
dealer_request_log.user_id fk_dealer_request_log_user_id R
dealer_request_note.created_by_id fk_dr_note_created_by R
dealer_request_note.last_updated_by_id fk_dr_note_last_updated_by R
feed_export.user_id FK1BA73D7528C762A3 R
feed_log.proxy_user_id FKF494B923A1B485D2 R
file_extract_job.user_id FK_kcgosi7hupastpro89k58ovjg R
intake.assigned_id FKB971272C99605DC0 R
intake_attachment.user_id fk_intake_attachment_user R
intake_consultation.user_id fk_intake_consult_user R
intake_log.proxy_user_id FK_intakelogproxy R
intake_log.user_id FK_intakeloguser R
intake_note.proxy_user_id FK_ko46nkcjuprpckpupa1b552q R
intake_note.user_id FK_9fsjxba23fpkoe7ksr6p73p37 R
intake_request_type.default_user_id FK_sqkki9h9pfch04qucx9st80th R
iterative_note.created_by_id FK_mlh1tirn7il2x4pmlve9u8pl8 R
iterative_note.created_by_proxy_id FK_kwytvlbkpirfdve7r0bx2jash R
iterative_note.last_update_by_id FK_ay4xx489qy1jgv3nbi8lpqpx4 R
iterative_note.last_update_by_proxy_id FK_n2221lhag064vj075ian4k1cy R
ivueit_survey_request.requested_by_id FK_survey_request_requested_by_id R
legal.attorney_id FK62162B9D72362B0 R
legal.managing_attorney_id FK62162B9E74672D3 R
legal.paralegal_id FK62162B957AFE0D5 R
legal.signer_id FK62162B971C12EE4 R
legal_approver.user_id FK416A358B28C762A3 R
legal_note.user_id FK228AD1B828C762A3 R
locale_contact.user_id FK_1s8g7146rxe9fmiguuj25hu8h R
lookup_table_log.proxy_user_id FK_701fak7fvokprb2ih0l17pe7 R
lookup_table_log.user_id FK_fc917yhypt9og0bf0r5cd11vh R
manual_task.accountable_user_id fk_manual_task_sys_user_accountable_idx R
manual_task.assigned_user_id fk_manual_task_sys_user_assigned_idx R
manual_task.created_by_id fk_manual_task_created_by_idx R
manual_task.last_update_by_id fk_manual_task_updated_by_idx R
manual_task_log.proxy_user_id fk_manual_task_log_proxy_user_idx R
manual_task_log.user_id fk_manual_task_log_user_idx R
milestone_task_log.proxy_user_id FK_9ydsy0hxacmkcu4idsg85tkna R
milestone_task_log.user_id FK_lfradrxholoftrlnm5tm3teqm R
milestone_template_log.proxy_user_id FK_nbmi0qpdm0iia559ex0xonvfh R
milestone_template_log.user_id FK_2wv5s8edptkly0yp0qjqc22wj R
notification_group_user.user_id FKC983815F28C762A3 R
notification_log.proxy_user_id FK6012EDF0A1B485D2 R
notification_log.user_id FK6012EDF028C762A3 R
notification_template.created_by_id FK_1h5yj7tft18qlxff1s3wxs2vx R
notification_template.updated_by_id FK_9jm491wa0asv8i9ol6wywq3b2 R
notification_user_message.user_id FK12F48E6728C762A3 R
notification_user_preference.user_id FK_nup_user_id C
permit_usage_log.user_id fk_permit_usage_log_user_id C
powerbi_entry.created_by_id fk_created_by R
process_library_log.proxy_user_id FK7E3A6FF0A1B485D2 R
process_library_log.user_id FK7E3A6FF028C762A3 R
process_library_user_permits.user_id FKDAC14C1828C762A3 R
program.manager_id FK_n9jmarp1n8tq1g959gd55knxo R
program_company_contact.user_id FK_fkdl5pmtlwknr5ndyd7vhtvy0 R
program_file.last_update_user_id FK_xhg8cvicwaj2e2od1ngcwq4j R
program_log.proxy_user_id FK_s7i7bf30hqs2tj7varkf1xfc6 R
program_log.user_id FK_1yrrxwie3f2ll8sekhjiq9r8i R
program_milestone_note.proxy_user_id FK_h1s4pi3nrj9khds2rlu3bhjt1 R
program_milestone_note.user_id FK_jb07xi2c80h4vjkmi2igexp9b R
program_support.user_id FK_cs1ohekyphrvivg16uyg7hon7 R
program_workflow_log.actor_id FK_croe3r4g0q4yt2g5ie53dr39 R
program_workflow_log.proxy_user_id FK_k0ryptxgmp5wpo2qqato40s62 R
program_workflow_participant.user_id FK_su2pap5il1sqrd3xu3bqr44gk R
program_workflow_participant_history.proxy_user_id FK_1x00qjf60alcfyegwhf6adkj2 R
program_workflow_participant_history.user_id FK_75ds9xcr7w00pt5d3filw04cj R
program_workflow_participant_type.default_user_id FK_bqurf790aytjy49u073vptees R
program_workflow_type_history.proxy_user_id FK_692v62ie46mebyc1kq3w8r6a9 R
program_workflow_type_history.user_id FK_lxmo578rqafhent5ng933brg8 R
project_company_contact.user_id FKFDAE893828C762A3 R
project_field_change_approver.default_user_id FK_project_field_change_approver_user R
project_field_pending_change_approver.approver_id FK_project_field_pending_change_approver_user R
project_field_pending_change_request.requestor_id FK_project_field_pending_change_requestor R
project_form_log.proxy_user_id FK_ih3x3hlhe79hami66i7jkrtka R
project_form_log.user_id FK_ihbyj7oa5wpucgatsswj1w6jw R
project_log.proxy_user_id FKC7FFE91EA1B485D2 R
project_log.user_id FKC7FFE91E28C762A3 R
project_note.update_proxy_user_id FK_tm1vyu1bq9y6v3vuifo4ai8iy R
project_note.update_user_id FK_2y4dip11fk3flautkoh31qx2c R
project_note.user_id FK37FE255828C762A3 R
project_plg_item.completed_by FK_project_plg_item_completed_by R
project_plg_recipient.user_id FK_project_plg_recipient_user R
project_plg_signature.user_id FK_project_plg_signature_user R
project_subcontractor_contact.user_id FK_l3qjc7srva8lxl541na0mn3kx R
project_support.user_id FK2C648A928C762A3 R
project_support_auto.user_id FK_project_support_auto_user R
projectlist_custom.user_id FKC4A3857928C762A3 R
projectlist_export.user_id FK_1mqriro6em5okync3a0uivo90 R
projectlist_group.user_id FK_d1n2dy2fq6y0udj5bnnvx8v1g R
projectlist_run_history.user_id FK484595D828C762A3 R
punch_list_item.marked_complete_by_id FK_3xihx7o0b8djj2qoc12or1uy2 R
punch_list_item_history.proxy_user_id FK_m8ls0xyo42a6wjfp8mvrko72p R
punch_list_item_history.user_id FK_41da01jis0i8wpyxlkwiwjpfp R
punch_list_item_note.proxy_user_id FK_16l1n5gh0terwokut71n74y35 R
punch_list_item_note.update_proxy_user_id FK_3r56e6xqus4o8vu5u8l1p47x9 R
punch_list_item_note.update_user_id FK_78tb6yp4re873ttcwk5lff6my R
punch_list_item_note.user_id FK_ahjko0qr5o2d4nti2fe3hsec4 R
punch_list_item_recipients_company_user.user_id FKE69058F628C762A3 R
punch_list_item_recipients_role_user.user_id FK35F87BEB28C762A3 R
recent_view.user_id fk_recent_view_user_id R
report_run_history.user_id FK_report_history_user R
site_file.project_manager_id FK_j1ne6x668vgh8py3yy7t3753h R
site_file.uploader_id FK_dn5oc32uovgkoaq0bghjdfyj0 R
site_sampson.cam_user_id FKB298AA89FABF4A33 R
site_support.user_id FKD4E3CED728C762A3 R
sitepack.attorney_id FK284B45E0D72362B0 R
sitepack.builder_id FK284B45E015D60CD3 R
sitepack_approval_user.user_id FK7C8A002828C762A3 R
sitepack_security.ordered_user_id FKC5CCFEBFE0F44D1 R
sitepack_security.received_user_id FKC5CCFEBF234F8245 R
sitepack_security.recommended_user_id FKC5CCFEBF23A15CBF R
sitepack_security.requested_user_id FKC5CCFEBFD59452D2 R
srs_report.created_by_id FK_m1xwes4got6cocoo4v4v1iti9 R
srs_report.last_update_by_id FK_q3hm3gvudyaxr6tslxnpomsfx R
srs_snapshot.created_by_id FK_bu8x0jcb9h5wm6fplt8o4jnk7 R
subcontractor_user.user_id FK_id3pxl21lxnbwmtuq3odt5uii R
survey_response.respondent_id FK_krba9o9mplas321hyf6da29u4 R
sys_activity_log.proxy_user_id FK27978646A1B485D2 R
sys_admin_job.notify_user_id FK5322EBDB255B47AD R
sys_admin_job.user_id FK5322EBDB28C762A3 R
sys_alert.created_by_user_id FK_idn65a84bh2xkulh8glvqlvni R
sys_companies.principal_id FKFD9A3EE967CE5F60 R
sys_companies.secondary_id FK_1vqanfqlxucybv9714neuv3is R
sys_company_users.user_id FK5B9741D428C762A3 R
sys_monitor_sessions.user_id FK8F98211428C762A3 C
sys_role_users.user_id FK553305B128C762A3 C
sys_security_log.current_user_id FK_mgexfecmpun44enma9pd43pu1 R
sys_security_log.proxy_user_id FKF6AE89F7A1B485D2 R
sys_temporary_role_users.user_id FK_otufayypbliy9781hucvy0fuc R
sys_user_notes.user_id FK5B459DFF28C762A3 R
sys_user_password_history.user_id FK_6km105la331glgcuheq2otbyl R
sys_user_proxies.assigner_id fk_sys_user_proxies_assigner_id R
sys_user_proxies.proxy_user_id FKF032F4AA1B485D2 R
sys_user_proxies.user_id FKF032F4A28C762A3 R
sys_user_setting_history.user_id FK_i6exiavy1dtc06650pbgpj24l R
sys_user_values.user_id FK1A4C35A428C762A3 C
sys_users.sponsor_id FK205BA2165C9984F4 R
sys_users.token_created_by_user_id FK205BA21665383478 R
target_area_document.last_update_user_id FK_qehxlv74jodsx7lf7yw723v38 R
target_area_log.proxy_user_id FK_798fr6qghgtewex2b78c6ek1i R
target_area_log.user_id FK_8ayryxth5wx1m0gg487ewu13r R
user_favorite.user_id fk_fav_user_id R
user_wiki_page_visit.user_id fk_visit_user_id R
vendor_task.last_checkin_user_id FK_dnfa31cnqwelri4drtfvfe8 R
vendor_task_comment.proxy_user_id FK_53gugjjxm7hxar0d3fysuu0xa R
vendor_task_comment.user_id FK_ov4ry1kdhtaebrudra9n1vpga R
vendor_task_history.proxy_user_id FK_orou2mp2xrrltwxqcce69klo3 R
vendor_task_history.user_id FK_4bgp7por47y9v8ea4ancyfchq R
visibility_group_log.proxy_user_id FK_vglog_proxy_user_id R
visibility_group_log.user_id FK_vglog_user_id R
warranty_log.proxy_user_id FK_kcymmeo48e81utf648p0xyfre R
warranty_log.user_id FK_e2r7igtp6lkwl92pf38sd19k8 R
wiki_page_history.proxy_user_id fk_proxy_user_id R
wiki_page_history.user_id fk_user_id R
workflow_log.actor_id FK5D08B2C4CF2AFC39 R
workflow_log.proxy_user_id FK5D08B2C4A1B485D2 R
workflow_participant.user_id FKB87D7EB328C762A3 R
workflow_participant_history.proxy_user_id FK_nesa3b0lexo9uqotv96r9hiq3 R
workflow_participant_history.user_id FK_ldkprfuhkcyipyqnwj1iarxxm R
workflow_participant_type.default_user_id FK_pttcs4ccgxc8l0014t1cp2jay R
workflow_type_history.proxy_user_id FK_fxisf46jhcd5dxaotmp5v93ri R
workflow_type_history.user_id FK_5itt3jbleifdpbx4yseu28vlm R
alias VARCHAR 70 √ null
first_name VARCHAR 20 null
last_name VARCHAR 20 √ null
email VARCHAR 70 √ null
password_timestamp DATETIME 19 √ null
password_salt CHAR 32 √ null
password_hash CHAR 32 √ null
password_expired INT 10 1
locked INT 10 0
disabled INT 10 0
created DATETIME 19 √ null
expires DATETIME 19 √ null
last_login DATETIME 19 √ null
last_ip_id INT 10 √ null
sys_ip_addrs.ip_id FK205BA216AEBF15EE R
phone VARCHAR 20 √ null
title VARCHAR 100 √ null
address VARCHAR 50 √ null
address2 VARCHAR 50 √ null
city VARCHAR 30 √ null
state CHAR 2 √ null
zip VARCHAR 10 √ null
fax VARCHAR 20 √ null
last_reactivated_on DATETIME 19 √ null
last_validated_on DATETIME 19 √ null
INT 10 √ null
sys_users.user_id FK205BA2165C9984F4 R
archived BIT 1 b'0'
cell_phone VARCHAR 20 √ null
contact_id INT 10 √ null
contact.contact_id FK205BA21651C65451 R
token VARCHAR 512 √ null
token_create_date DATETIME 23 √ null
token_created_by_user_id INT 10 √ null
sys_users.user_id FK205BA21665383478 R
token_expiration_date DATETIME 23 √ null
token_last_used_date DATETIME 23 √ null
subcontractor BIT 1 √ null
inactive BIT 1 √ null
api_user BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_id
alias Must be unique Asc alias
contact_id Must be unique Asc contact_id
email Must be unique Asc email
FK205BA21651C65451 Performance Asc contact_id
FK205BA2165C9984F4 Performance Asc sponsor_id
FK205BA21665383478 Performance Asc token_created_by_user_id
FK205BA216AEBF15EE Performance Asc last_ip_id
idx_user_id Performance Asc user_id
ix_title Performance Asc title

Relationships

Close relationships within degrees of separation