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