sdsds
Tables (11)
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 — 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
- employee_id (employee_id2) — VARCHAR(10) — Foreign key → employee.employee_id
- key — VARCHAR(10) — Foreign key → attendance_info.key
- attendance_info_id (attendance_info_id2) — LONG — Foreign key → attendance_info.attendance_info_id
attendance_approval
- attendance_approval_id — LONG — Primary key
- 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
- employee_id (employee_id2) — VARCHAR(10) — Foreign key → employee.employee_id
- key — VARCHAR(10) — Foreign key → attendance_info.key
- attendance_info_id (attendance_info_id2) — LONG — Foreign key → attendance_info.attendance_info_id
attendance_info
- attendance_info_id — LONG — Primary key
- 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
- employee_id (employee_id2) — VARCHAR(10) — Foreign key → employee.employee_id
- key — VARCHAR(10) — Foreign key → attendance_status_category.key
attendance_status_category
- key — VARCHAR(10) — Primary key
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) — Foreign key → employee.employee_id
- file_name — VARCHAR(255) — NOT NULL
- uuid — VARCHAR(255) — NOT NULL
- upload_date — DATETIME
- employee_id (employee_id2) — VARCHAR(10) — Foreign key → employee.employee_id
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) — 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
- employee_id (employee_id2) — VARCHAR(10) — Foreign key → employee.employee_id
- vacation_category_key (vacation_category_key2) — VARCHAR(10) — Foreign key → vacation_category.vacation_category_key
vocation_adjusted_history
- vocation_adjusted_history_id — LONG — Primary key
- 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
- employee_id (employee_id2) — VARCHAR(10) — Foreign key → employee.employee_id