vacation
Tables (6)
user (유저)
- id (유저아이디) — BIGINT — Primary key — NOT NULL
- role (역할) — ENUM — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME — NOT NULL
- deleted_at (삭제일) — DATETIME
vacation_application (휴가신청)
- id (휴가신청아이디) — BIGINT — Primary key — NOT NULL
- id (유저아이디) — BIGINT — Foreign key → user.id — NOT NULL
- id (휴가종류아이디) — BIGINT — Foreign key → vacation_type.id — NOT NULL
- application_date (휴가신청일자) — DATETIME — NOT NULL
- reason (사유) — VARCHAR
- remaining_day (잔여일) — FLOAT — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME — NOT NULL
- deleted_at (삭제일) — DATETIME
vacation_days (휴가일수)
- id (휴가일수아이디) — BIGINT — Primary key — NOT NULL
- id (유저아이디) — BIGINT — Foreign key → user.id — NOT NULL
- total_deduction_date (총 차감일) — DOUBLE — NOT NULL
- total_use_date (총 사용일) — DOUBLE — NOT NULL
- remaining_date (잔여일) — DOUBLE — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME — NOT NULL
- deleted_at (삭제일) — DATETIME
vacation_grant (휴가부여)
- id (휴가부여아이디) — BIGINT — Primary key — NOT NULL
- id (유저아이디) — BIGINT — Foreign key → user.id — NOT NULL
- id (휴가종류아이디) — BIGINT — Foreign key → vacation_type.id — NOT NULL
- deduction_date (차감일) — FLOAT — NOT NULL
- reason (사유) — VARCHAR
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME — NOT NULL
- deleted_at (삭제일) — DATETIME
vacation_type (휴가종류)
- id (휴가종류아이디) — BIGINT — Primary key — NOT NULL
- vacation_type_name (휴가이름) — VARCHAR — NOT NULL
- deduction_date (차감일) — FLOAT — NOT NULL
- is_paid (급여제공여부) — BOOLEAN — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME — NOT NULL
- deleted_at (삭제일) — DATETIME
work_schedule (근무일정)
- id (근무일정아이디) — BIGINT — Primary key — NOT NULL
- id (유저아이디) — BIGINT — Foreign key → user.id — NOT NULL
- work_place_name (근무장소이름) — VARCHAR — NOT NULL
- work_date (근무날짜) — DATETIME — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME — NOT NULL
- deleted_at (삭제일) — DATETIME