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