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