ㅇ

Tables (11)

admin

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

attendance_appeal_request

  • attendance_appeal_request_id — LONG
  • status — VARCHAR(10) — NOT NULL
  • reason — TEXT — NOT NULL
  • attendance_info_id — LONG — Foreign key → attendance_info.attendance_info_id
  • appealed_start_time — DATETIME — NOT NULL
  • appealed_end_time — DATETIME — NOT NULL
  • employee_id — VARCHAR(10) — Foreign key → employee.employee_id
  • attendance_appeal_request_time — DATETIME

attendance_approval

  • attendance_approval_id — LONG
  • attendance_info_id — LONG — Foreign key → attendance_info.attendance_info_id
  • attendance_approval_date — DATETIME — NOT NULL
  • employee_id — VARCHAR(10) — Foreign key → employee.employee_id

attendance_info

  • attendance_info_id — LONG
  • attendance_status_category — VARCHAR(10) — Foreign key → attendance_status_category.key
  • employee_id — VARCHAR(10) — Foreign key → employee.employee_id
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME
  • date — DATE — NOT NULL

attendance_status_category

  • key — VARCHAR(10)

employee

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

image

  • file_id — LONG
  • employee_id — VARCHAR(10) — Foreign key → employee.employee_id
  • file_name — VARCHAR(255) — NOT NULL
  • uuid — VARCHAR(255) — NOT NULL
  • upload_date — DATETIME

vacation_category

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

vacation_quantity_setting

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

vacation_request

  • vacation_request_key — LONG
  • vacation_category_key — VARCHAR(10) — Foreign key → vacation_category.vacation_category_key
  • employee_id — VARCHAR(10) — Foreign key → employee.employee_id
  • 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
  • employee_id — VARCHAR(10) — Foreign key → employee.employee_id
  • adjust_type — VARCHAR(10) — NOT NULL
  • adjust_date — DATE — NOT NULL
  • adjust_quantity — INT — NOT NULL