CARID (ID)
CARNO (Card no)
FNAM (First name)
LNAM (Last name)
STA (Status)
CAR
(Cards)
DEPT_ID
CODE
NAME
HR.DEPT
[HR]
(Departments)
EMP_ID
EMP_NO
PER_ID
HR.EMP
(Employees)
ACCID (ID)
ROLID (Role)
AREID (Area)
ACC
(Roles-Areas)
CRAID (ID)
CARID (Card)
CRA
(Cards-Access)
ROLID (ID)
ROLNAM (Name)
ROL
(Roles)
AREID (ID)
ARENAM (Name)
ARE
(Areas)
ARGID (ID)
GATID (Gate)
ARG
(Areas-Doors)
GATID (ID)
BLDID (Buidling)
UID
GAT
(Doors)