Groupware
Tables (20)
t_AnnualLeave (Untitled10)
- Employee_Id (id) — Integer — Foreign key → t_Employee.Employee_Id — NOT NULL
- TotalAnnualLeave (Field) — NUMERIC(2, 1) — NOT NULL — 총 연차
- UsedAnnualLeave (Field2) — NUMER(2,1) — NOT NULL — 사용 연차
t_Approval (approval)
- Id (id) — Integer — Primary key — NOT NULL
- Request_Id (id2) — Integer — Foreign key → t_Request.Id
- Approver_Id (approver_id) — integer — NOT NULL — 결재자
- Order (order) — Integer — NOT NULL — 결재 순서, 숫자 작은 사람이 선결재
- Approval_Status (approval_status) — character varying(50) — NOT NULL — 미결, 대기, 승인, 반려 등
- Approval_Date (approval_date) — timestamp without time zone — 승인/반려 일시
- Comment (comment) — character varying(50)
- RequestCancel_Id (id3) — Integer — Foreign key → t_RequestCancel.Id
t_Attendance (attendance)
- Id (id) — Integer — Primary key — NOT NULL
- Employee_Id (id2) — Integer — Foreign key → t_Employee.Employee_Id — NOT NULL
- Check_In (check_in) — timestamp without time zone — NOT NULL — 출근
- Check_Out (check_out) — timestamp without time zone — 퇴근
- AttendanceStatus (Key) — Intger — Foreign key → t_AttendanceStatus.Id — NOT NULL — 1:지각/2:무단결근/3:조기퇴근/4:근무시수 미달
t_AttendanceStatus (Untitled11)
- Id (Key) — Intger — Primary key — NOT NULL — 1:지각/2:무단결근/3:조기퇴근/4:근무시수 미달
- Attendance_Status (Field) — character varying(50) — NOT NULL
t_Department (department)
- Id (id) — Integer — Primary key — NOT NULL — 부서 - 전략기획팀, 경영지원팀 등
- Department (department) — character varying(50) — NOT NULL
t_Employee (employee)
- Employee_Id (id) — Integer — Primary key — NOT NULL
- Department_Id (id2) — Integer — Foreign key → t_Department.Id — NOT NULL
- Rank_Id (id3) — Integer — Foreign key → t_Rank.Id — NOT NULL
- Role (role) — character varying(50) — NOT NULL
- Name (Field2) — character varying(50) — NOT NULL
- Mob (Field) — Integer — NOT NULL
- Email (Field3) — character varying(50) — NOT NULL
t_Project (Untitled5)
- Id (Key) — Integer — Primary key — NOT NULL
- Code (Field) — Integer — NOT NULL
- Client (Field2) — character varying(50) — NOT NULL
- Project (Field3) — character varying(50) — NOT NULL
- Contract_Period (Field7) — Date
- Contract_Amount (Field4) — Integer
- Man_Month (Field5) — Integer
- Description (Field6) — character varying(50)
- Project_Status_Id (Key2) — Integer — Foreign key → t_ProjectStatus.Id — NOT NULL
t_ProjectStatus (Untitled8)
- Id (Key) — Integer — Primary key — NOT NULL — 1:계약 전/2: 계약 중/ 계약 종료 등등
- Project_Status (Field) — character varying(50) — NOT NULL
t_Rank (rank)
- Id (id) — Integer — Primary key — NOT NULL — 직급 - 소장, 대리, 사원 등
- Rank (rank) — character varying(50) — NOT NULL
t_Request (request)
- Id (id) — Integer — Primary key — NOT NULL
- Employee_Id (id2) — Integer — Foreign key → t_Employee.Employee_Id — NOT NULL
- WorkStatus_Id (Key) — Integer — Foreign key → t_WorkStatus.Id — NOT NULL
- Start_Date (start_date) — timestamp without time zone — NOT NULL — 시작날짜
- End_Date (end_date) — timestamp without time zone — NOT NULL — 종료날짜
- Location (Field) — character varying(50) — 장소 //외근시 기입
- Reason (reason) — character varying(50) — NOT NULL — 사유
- Submission_Date (submission_date) — timestamp without time zone — NOT NULL — 신청일시
- Approver_Id (approver_id) — character varying(50) — NOT NULL — 결재자
- Approval_Date (approval_date) — timestamp without time zone — 승인/반려 일시
- Approval_Status (approval_status) — character varying(50) — NOT NULL — 미결, 대기, 승인, 반려 등
- RequestCancel_Id (requestcancel_id) — Integer — 취소 신청_ID
t_RequestCancel (requestcancel)
- Id (id) — Integer — Primary key — NOT NULL
- Request_Id (Field) — Integer — NOT NULL
- Cancellatuon_Reason (cancellation_reason) — character varying(100) — NOT NULL — 취소 사유
- Submission_Date (submission_date) — timestamp withou time zone — NOT NULL — 취소 신청 일시
- Approver_Id (approver_id) — character varying(50) — NOT NULL — 결재자
- Approval_Date (approval_date) — timestamp without time zone — 승인/반려 일시
- Approval_Status (approval_status) — character varying(50) — NOT NULL — 미결, 대기, 승인, 반려 등
t_WebId (Untitled)
- Employee_Id (id) — Integer — Foreign key → t_Employee.Employee_Id — NOT NULL
- Web_Id (Field) — character varying(50) — NOT NULL
- Pw (Field2) — character varying(50) — NOT NULL
t_Week (week)
- Id (id) — Integer — Primary key — NOT NULL
- Week_Start (week_start) — date — NOT NULL — 주 시작/ 기준 : 일 or 월
- Week_End (week_end) — date — NOT NULL — 주 끝/ 토 or 일
t_WeeklyRecords (weeklyrecords)
- Id (id) — Integer — Primary key — NOT NULL
- Employee_Id (id3) — Integer — Foreign key → t_Employee.Employee_Id — NOT NULL
- Week_Id (id2) — Integer — Foreign key → t_Week.Id — NOT NULL
- Cumulative (cumulative) — timestamp without time zone — 누적
- Remaining (remaining) — timestamp without time zone — NOT NULL — 잔여
- Overtime (overtime) — timestamp without time zone — 연장
t_WorkDetailType (Untitled6)
- Id (Key) — Integer — Primary key — NOT NULL — 작업내용 카테고리_ex-UI작성, 코드 작성 등등
- Work_Detail (Field) — character varying(50) — NOT NULL
t_WorkDiary (Untitled4)
- Id (Key) — Integer — Primary key — NOT NULL
- Employee_Id (id) — Integer — Foreign key → t_Employee.Employee_Id — NOT NULL
- Date (Field2) — date — NOT NULL
- Client (Field3) — character varying(50) — NOT NULL — //프로젝트 작성 시 자동 기입
- Project_Id (Key2) — Integer — Foreign key → t_Project.Id — NOT NULL
- Work_Type_Id (Key3) — Integer — Foreign key → t_WorkDetailType.Id — NOT NULL — 작업 내용
- Detail (Field6) — character varying(100) — NOT NULL — 상세 내용
- Time_Spent (Field) — Integer — NOT NULL — 업무 소요시간
- Approval_Status (Field8) — character varying(50) — NOT NULL
- Approval_Date (Field4) — timestamp without time zone
t_WorkLocation (Untitled9)
- Id (Key) — Integer — Primary key — NOT NULL — 근무지-빔피어스, 삼우
- Location (Field) — character varying(50) — NOT NULL — 근무지 이름
- Ip (Field2) — character varying(15) — NOT NULL — 근무지_IP
- GPS (Field3) — character varying(50) — NOT NULL — 주소 작성 후 반경 설정
t_WorkStatus (Untitled3)
- Id (Key) — Integer — Primary key — NOT NULL — 1:휴가/2:외근/3:출장/4:재택근무
- Type (Field) — character varying(50) — NOT NULL
t_WorkType (Untitled2)
- Id (Key) — Integer — Primary key — NOT NULL
- Type_Name (Field) — character varying(50) — NOT NULL — 관리자기입_ex-선택적 근로제(전략기획팀)
- Work_Type (Key2) — Integer — Foreign key → t_WorkTypeList.Id — NOT NULL
- Employee_Id (id) — Integer — Foreign key → t_Employee.Employee_Id — NOT NULL
- Week_Work_Hour (Field2) — Integer — NOT NULL — 주 근로시간
- Work_Day (Field3) — character varying(50) — NOT NULL — 근무일(월,화,수,목,금)
- 1Day_Work_Hour (Field4) — time — NOT NULL — 1일 근무시간
- Break_Start_Time (Field5) — time — NOT NULL — 휴게 시작시간
- Break_End_Time (Field6) — time — NOT NULL — 휴게 종료시간
- Work_Location_Id (Key3) — Integer — Foreign key → t_WorkLocation.Id — NOT NULL
- Check_In_Start (Field8) — time — 출근시작시간 //고정근무 시 미기입
- Check_In_End (Field9) — time — NOT NULL — 출근 종료시간
- Auto_Check_Out (Field10) — Boolean — NOT NULL — 자동퇴근
- Modified_Date (Field11) — timestamp without time zone — NOT NULL — 수정일시
t_WorkTypeList (Untitled7)
- Id (Key) — Integer — Primary key — NOT NULL — 고정근무, 유연근무, 자율근무
- Type (Field) — character varying(50) — NOT NULL