_435.patients_urls

Field Type Null Default Key Extra Comment
pu_id int(11) NO PRI auto_increment primary key
pu_cus_id int(11) NO MUL Customer ID
pu_cli_id int(11) NO MUL Client ID
pu_pat_id int(11) NO MUL Associated Patient ID
pu_name text NO
pu_desc text NO
pu_url text NO
pu_pic_id int(11) NO MUL Which category this URL falls under
pu_lbl_id int(11) NO MUL A client specific label for this url
pu_usr_created int(11) NO MUL User ID of the creator
pu_disabled tinyint(1) NO 0 Whether or not the URL has been disabled
pu_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
pu_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
pu_id
TableColumn
common.portal_users_accesspua_pu_id