ㅇ
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
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