The link table JRUSERJOB is used to assign users to Job Functions. This table lists the user names (username) and the Job Functions (jobfunction) they belong to. Those columns link to the JRUSERS and JRJOBFUNCTIONS table.
The structure of the table:
Column name |
Data type |
Description |
|---|---|---|
username |
(N)VARCHAR(50) |
User name |
jobfunction |
(N)VARCHAR(50) |
Job Function |
modify_date |
DATETIME |
Modify date |
modified_by |
(N)VARCHAR(50) |
Modified by |
create_date |
DATETIME |
Create date |
created_by |
(N)VARCHAR(50) |
Created by |
