commute

Tables (5)

calender (달력)

  • id (달력ID) — int4 — Primary key — NOT NULL
  • uuid (userID) — VARCHAR2(90) — Foreign key → user.uuid — NOT NULL
  • date (달력날짜) — Date
  • content (내용) — VARCHAR(100)
  • time (근무시간) — int4
  • status (상태) — enum(재택, 외근, 출장)

company (회사)

  • id (회사ID) — int4 — Primary key — NOT NULL
  • name (회사이름) — VARCHAR(100)
  • category (회사종류) — VARCHAR(40)
  • code (회사고유코드) — VARCHAR(100)
  • policy (근로제도) — enum("탄력적", "선택적")

manager (관리자)

  • email (관리자ID) — VARCHAR(100) — Primary key — NOT NULL
  • company_id (회사ID) — int4 — Foreign key → company.id — NOT NULL
  • password (관리자PW) — VARCHAR(100)
  • nickname (관리자이름) — VARCHAR(100)
  • phone (전화번호) — VARCHAR(100)
  • rank (직급) — VARCHAR(100)
  • refreshToken (리프레쉬토큰) — VARCHAR(100)

user (직원)

  • uuid (userID) — VARCHAR2(90) — Primary key — NOT NULL
  • manager_id (관리자ID) — VARCHAR(100) — Foreign key → manager.email — NOT NULL
  • email (유저이메일) — VARCHAR(100)
  • password (유저비밀번호) — VARCHAR(100)
  • nickname (유저이름) — VARCHAR(50)
  • place (근로장소) — enum("company", "autonomy", "businessTrip")
  • refreshToken (리프레쉬토큰) — VARCHAR(100)

work (근무)

  • id (근무ID) — int4 — Primary key — NOT NULL
  • uuid (userID) — VARCHAR2(90) — Foreign key → user.uuid — NOT NULL
  • work_date (출근시간) — Date
  • finish_date (퇴근시간) — Date
  • status (상태) — enum(wait, work, finish)
  • time (시간) — int4