GroupwareERD_N
Tables (19)
APPROVAL
- APPROVAL_ID — INT — Primary key — NOT NULL
- DRAFTER_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- FORM_TYPE_ID — INT — Foreign key → APPROVAL_FORM_TYPE.FORM_TYPE_ID — NOT NULL
- APPROVAL_TITLE — VARCHAR(200) — NOT NULL
- APPROVAL_CONTENT — TEXT — NOT NULL
- LEAVE_START_DATE — DATE
- LEAVE_END_DATE — DATE
- AMOUNT — BIGINT
- APPROVAL_STATUS — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
APPROVAL_FILE
- FILE_ID — INT — Primary key — NOT NULL
- APPROVAL_ID — INT — Foreign key → APPROVAL.APPROVAL_ID — NOT NULL
- FILE_NAME — VARCHAR(300) — NOT NULL
- FILE_PATH — VARCHAR(500) — NOT NULL
- FILE_SIZE — BIGINT — NOT NULL
- UPLOADED_AT — DATETIME — NOT NULL
APPROVAL_FORM_TYPE
- FORM_TYPE_ID — INT — Primary key — NOT NULL
- FORM_TYPE_NAME — VARCHAR(50) — NOT NULL
- APPROVAL_STEP_COUNT — INT — NOT NULL
APPROVAL_LINE
- LINE_ID — INT — Primary key — NOT NULL
- APPROVAL_ID — INT — Foreign key → APPROVAL.APPROVAL_ID — NOT NULL
- STEP_NO — INT — NOT NULL
- APPROVER_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- LINE_STATUS — VARCHAR(10) — NOT NULL
- LINE_COMMENT — VARCHAR(500)
- DECIDED_AT — DATETIME
APPROVAL_REFERENCE
- REF_ID — INT — Primary key — NOT NULL
- APPROVAL_ID — INT — Foreign key → APPROVAL.APPROVAL_ID — NOT NULL
- DEPT_ID — INT — Foreign key → DEPARTMENT.DEPT_ID
- EMPLOYEE_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID
ARCHIVE
- ARCHIVE_ID — INT — Primary key — NOT NULL
- REPO_ID — INT — Foreign key → REPOSITORY.REPO_ID — NOT NULL
- WRITER_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- ARCHIVE_TITLE — VARCHAR(200) — NOT NULL
- ARCHIVE_CONTENT — TEXT — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
ARCHIVE_FILE
- FILE_ID — INT — Primary key — NOT NULL
- ARCHIVE_ID — INT — Foreign key → ARCHIVE.ARCHIVE_ID — NOT NULL
- FILE_NAME — VARCHAR(300) — NOT NULL
- FILE_PATH — VARCHAR(500) — NOT NULL
- FILE_SIZE — BIGINT — NOT NULL
- UPLOADED_AT — DATETIME — NOT NULL
ATTENDANCE
- ATTENDANCE_ID — INT — Primary key — NOT NULL
- EMPLOYEE_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- WORK_DATE — DATE — NOT NULL
- CHECK_IN_TIME — TIME
- CHECK_OUT_TIME — TIME
- ATTENDANCE_STATUS — VARCHAR(10) — NOT NULL
CALENDAR_EVENT
- EVENT_ID — INT — Primary key — NOT NULL
- EMPLOYEE_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- EVENT_TITLE — VARCHAR(200) — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
- EVENT_CATEGORY — VARCHAR(10) — NOT NULL
- DEPT_ID — INT — Foreign key → DEPARTMENT.DEPT_ID
- IS_HOLIDAY — TINYINT(1) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
CHAT_ATTACHMENT
- ATTACH_ID — INT — Primary key — NOT NULL
- MESSAGE_ID — INT — Foreign key → CHAT_MESSAGE.MESSAGE_ID — NOT NULL
- FILE_NAME — VARCHAR(300) — NOT NULL
- FILE_PATH — VARCHAR(500) — NOT NULL
- FILE_SIZE — BIGINT — NOT NULL
CHAT_MESSAGE
- MESSAGE_ID — INT — Primary key — NOT NULL
- ROOM_ID — INT — Foreign key → CHAT_ROOM.ROOM_ID — NOT NULL
- SENDER_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID
- MESSAGE_TYPE — VARCHAR(10) — NOT NULL
- CONTENT — VARCHAR(1000)
- SENT_AT — DATETIME — NOT NULL
CHAT_ROOM
- ROOM_ID — INT — Primary key — NOT NULL
- ROOM_TYPE — VARCHAR(5) — NOT NULL
- ROOM_NAME — VARCHAR(100)
- CREATED_AT — DATETIME — NOT NULL
CHAT_ROOM_MEMBER
- MEMBER_ROW_ID — INT — Primary key — NOT NULL
- ROOM_ID — INT — Foreign key → CHAT_ROOM.ROOM_ID — NOT NULL
- EMPLOYEE_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- LAST_READ_MESSAGE_ID — INT — Foreign key → CHAT_MESSAGE.MESSAGE_ID
- JOINED_AT — DATETIME — NOT NULL
CHAT_ROOM_MEMBER_SUSPENSION
- SUSPENSION_ID — INT — Primary key — NOT NULL
- ROOM_ID — INT — Foreign key → CHAT_ROOM.ROOM_ID — NOT NULL
- EMPLOYEE_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- HIDDEN_FROM_MESSAGE_ID — INT — NOT NULL
- HIDDEN_TO_MESSAGE_ID — INT
- CREATED_AT — DATETIME — NOT NULL
DEPARTMENT
- DEPT_ID — INT — Primary key — NOT NULL
- DEPT_NAME — VARCHAR(50) — NOT NULL
EMPLOYEE
- EMPLOYEE_ID — INT — Primary key — NOT NULL
- EMPLOYEE_NO — VARCHAR(20) — NOT NULL
- EMPLOYEE_PWD — VARCHAR(300) — NOT NULL
- EMPLOYEE_NAME — VARCHAR(50) — NOT NULL
- DEPT_ID — INT — Foreign key → DEPARTMENT.DEPT_ID
- POSITION_ID — INT — Foreign key → POSITION.POSITION_ID
- EMPLOYEE_ROLE — VARCHAR(10) — NOT NULL
- EMPLOYEE_PHONE — VARCHAR(20)
- EMPLOYEE_EMAIL — VARCHAR(200)
- PROFILE_IMG — VARCHAR(500)
- EMPLOYEE_STATUS — VARCHAR(10) — NOT NULL
- HIRE_DATE — DATE — NOT NULL
- BIRTH_DATE — DATE
- CREATED_AT — DATETIME — NOT NULL
NOTICE
- NOTICE_ID — INT — Primary key — NOT NULL
- WRITER_ID — INT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- NOTICE_TITLE — VARCHAR(200) — NOT NULL
- NOTICE_CONTENT — TEXT — NOT NULL
- IS_PINNED — TINYINT(1) — NOT NULL
- VIEW_COUNT — INT — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
POSITION
- POSITION_ID — INT — Primary key — NOT NULL
- POSITION_NAME — VARCHAR(20) — NOT NULL
- POSITION_RANK — INT — NOT NULL
REPOSITORY
- REPO_ID — INT — Primary key — NOT NULL
- REPO_NAME — VARCHAR(50) — NOT NULL
- DEPT_ID — INT — Foreign key → DEPARTMENT.DEPT_ID
- CREATED_AT — DATETIME — NOT NULL