study_attend_erd
Tables (4)
ATTENDANCE
- ATD_ID_PK — VARCHAR(20) — Primary key
- DEPT_ID_FK — VARCHAR(20) — Foreign key → DEPARTMENT.DEPT_ID_PK
- ATD_TYPE_FK — VARCHAR(20) — Foreign key → ATTENDTYPE.ATD_TYPE_PK
- EMP_ID_FK — VARCHAR(20) — Foreign key → EMPLOYEE.EMP_ID
- DATE — VARCHAR(20)
ATTENDTYPE
- ATD_TYPE_PK — VARCHAR(20) — Primary key
- ATD_TYPE — VARCHAR(20)
DEPARTMENT
- DEPT_ID_PK — VARCHAR(20) — Primary key
- DEPT_NAME — VARCHAR(50)
EMPLOYEE
- EMP_ID — VARCHAR(20) — Primary key
- DEPT_ID_FK — VARCHAR(20) — Foreign key → DEPARTMENT.DEPT_ID_PK
- EMP_NAME — VARCHAR(50)