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