erd

Tables (10)

admin

  • admin_id — VARCHAR(10) — Primary key
  • password — VARCHAR(10) — NOT NULL

attendance_appeal_request

  • attendance_appeal_request_id — LONG — Primary key
  • status — VARCHAR(10) — NOT NULL
  • reason — TEXT — NOT NULL
  • attendance_info_id — LONG
  • appealed_start_time — DATETIME — NOT NULL
  • appealed_end_time — DATETIME — NOT NULL
  • employee_id — VARCHAR(10)
  • attendance_appeal_request_time — DATETIME

attendance_approval

  • attendance_approval_id — LONG — Primary key
  • attendance_info_id — LONG
  • attendance_approval_date — DATETIME — NOT NULL
  • employee_id — VARCHAR(10)

attendance_info

  • attendance_info_id — LONG — Primary key
  • attendance_status_category — VARCHAR(10)
  • employee_id — VARCHAR(10)
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME
  • date — DATE — NOT NULL

employee

  • employee_id — VARCHAR(10) — Primary key
  • password — VARCHAR(10) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • attendance_manager — BOOLEAN — NOT NULL
  • hire_year — DATE

image

  • file_id — LONG — Primary key
  • employee_id — VARCHAR(10)
  • file_name — VARCHAR(255) — NOT NULL
  • uuid — VARCHAR(255) — NOT NULL
  • upload_date — DATETIME

vacation_category

  • vacation_category_key — VARCHAR(10) — Primary key
  • admit_time — INT — NOT NULL

vacation_quantity_setting

  • setting_key — INT — Primary key
  • freshman — INT — NOT NULL
  • senior — INT — NOT NULL

vacation_request

  • vacation_request_key — LONG — Primary key
  • vacation_category_key — VARCHAR(10)
  • employee_id — VARCHAR(10)
  • result — VARCHAR(10) — NOT NULL
  • vacation_quantity — INT — NOT NULL
  • vacation_start_time — DATETIME — NOT NULL
  • vacation_end_time — DATETIME — NOT NULL
  • vacation_related_start_time — DATETIME — NOT NULL
  • vacation_related_end_time — DATETIME — NOT NULL
  • reason — TEXT — NOT NULL

vocation_adjusted_history

  • vocation_adjusted_history_id — LONG — Primary key
  • employee_id — VARCHAR(10)
  • adjust_type — VARCHAR(10) — NOT NULL
  • adjust_date — DATE — NOT NULL
  • adjust_quantity — INT — NOT NULL