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