_1188.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 The name of the URL
pu_desc text NO A text description of the URL
pu_url text NO The full URL
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