salryTraker

Tables (3)

Jobtype (근무지)

  • jobtype_id (PK) — bigint — Primary key — NOT NULL
  • user_id (PK2) — bigint — Foreign key → User.user_id — NOT NULL
  • name (이름) — string
  • payrate (시급) — bigint

User (사용자)

  • user_id (PK) — bigint — Primary key — NOT NULL
  • email (이메일) — string
  • password (비밀번호) — string
  • name (이름) — string
  • role (사용자 타입) — ROLE
  • createdAt (생성시간) — timestamp
  • updatedAt (변경시간) — timestamp

Worklog (근무기록)

  • worklog_id (PK) — bigint — Primary key — NOT NULL
  • jobtype_id (PK2) — bigint — Foreign key → Jobtype.jobtype_id — NOT NULL
  • user_id (PK22) — bigint — Foreign key → Jobtype.user_id — NOT NULL
  • start_time (출근시간) — timestamp
  • end_time (퇴근시간) — timestamp
  • payrate (시급) — bigint
  • totalwage (일당) — bigint