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