itosideproject

Tables (7)

Account (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • nickname (회사 계정) — VARCHR — Primary key
  • email (이메일) — VARCHAR — Primary key
  • user_name (이름) — VARCHAR — Primary key
  • company_id (Company 외례키) — BIGINT — Foreign key → Company.id
  • password (비밀번호) — VARCHAR
  • role (권한) — VARCHAR
  • company_name (회사이름) — VARCHAR
  • contact_number (전화번호) — VARCHAR
  • part (부서) — VARCHAR
  • system (맡은시스템) — VARCHAR
  • emergency_number (긴급번호) — VARCHAR
  • end_work_time (퇴사일자) — DATETIME
  • start_work_time (입사일자) — DATETIME
  • company_position (직위) — VARCHAR
  • vacation_count (휴가 갯수) — INT
  • activeAccount (활성화 여부) — VARCHAR

Answer (Untitled4)

  • id — Long — Primary key — NOT NULL
  • writer_id (Account 외래키) — BIGINT — Foreign key → Account.id — NOT NULL
  • question_id (Question 외래키) — BIGINT — Foreign key → Question.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Account.company_id
  • createDate (생성일자) — LocalDateTime
  • modifiedDate (수정일자) — LocalDateTime
  • contents (질문내용) — String

Company (Untitled2)

  • id — BIGINT — Primary key
  • field_manager (현장대리인) — VARCHAR — Primary key
  • company_name (회사이름) — VARCHAR
  • contact_number (전화번호) — VARCHAR
  • manager (관리자) — VARCHAR
  • sales_yn (영업대표여부) — VARCHAR
  • Field

Question (CopyOfUntitled4)

  • id — Long — Primary key — NOT NULL
  • writer_id (Account 외래키) — BIGINT — Foreign key → Account.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Account.company_id
  • createDate (생성일자) — LocalDateTime
  • modifiedDate (수정일자) — LocalDateTime
  • title (제목) — String
  • contents (질문내용) — String
  • countOfAnswer (답변숫자) — Integer
  • answer_id (Field)

ito_report (Untitled5)

  • id — BIGINT — Primary key — NOT NULL
  • writer_id (Account 외래키) — BIGINT — Foreign key → Account.id — NOT NULL
  • create_date (생성일자) — DATETIME
  • modified_date (수정일자) — DATETIME
  • next_week_context (차주 성과 내용) — VARCHAR
  • next_week_end_date_time (차주 종료일자) — DATE
  • next_week_perfection (차주 완성도) — VARCHAR
  • next_week_start_date_time (차주 시작일자) — DATE
  • nickname (회사계정) — VARCHAR
  • this_week_context (이번주 성과내용) — VARCHAR
  • this_week_end_date_time (이번주 종료일자) — DATE
  • this_week_perfection (이번주 완성도) — VARCHAR
  • this_week_start_date_time (이번주 시작일자) — DATE
  • actual_end_date (실제 시작일자) — DATE
  • actual_start_date (실제 종료일자) — DATE
  • category (SR 종류) — VARCHAR
  • mon (월요일 일한시간) — DOUBLE
  • tue (화요일 일한시간) — DOUBLE
  • wed (수요일 일한시간) — DOUBLE
  • thu (목요일 일한시간) — DOUBLE
  • fri (금요일 일한시간) — DOUBLE
  • sat (토요일 일한시간) — DOUBLE
  • sun (일요일 일한시간) — DOUBLE
  • planed_end_date (계획한 종료일자) — DATE
  • planed_start_date (계획한 시작일자) — DATE
  • prediction (SR 예상시간) — DOUBLE
  • projact_nature (프로젝트 세부항목) — VARCHAR
  • ref_no — VARCHAR
  • request_part (요청부서) — VARCHAR
  • sum (요일시간 합계) — DOUBLE
  • sum_total (누적 일한시간) — DOUBLE
  • task (일한 내용) — VARCHAR
  • detail_content (상세종류) — VARCHAR

project_report (Untitled6)

  • id — BIGINT — Primary key — NOT NULL
  • writer_id (Account 외래키) — BIGINT — Foreign key → Account.id — NOT NULL
  • createDate (생성일자) — DATE
  • modifiedDate (수정일자) — DATE
  • this_week_context (이번주 실적내용) — VARCHAR
  • this_week_perfection (이번주 완성도) — VARCHAR
  • this_week_start_date_time (이번주 시작일자) — DATE
  • this_week_end_date_time (이번주 종료일자) — DATE
  • next_week_context (다음주 실적내용) — VARCHAR
  • next_week_perfection (다음주 완성도) — VARCHAR
  • next_week_start_date_time (다음주 시작일자) — DATE
  • next_week_end_date_time (다음주 종료일자) — DATE

vacation (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • account_id (Account 외래키) — BIGINT — Foreign key → Account.company_id
  • over_itme_name (휴가이름) — VARCHAR
  • application_date (접수일자) — DATE
  • emergency_number (비상연락망) — VARCHAR
  • end_date_time (종료일) — VARCHAR
  • end_ot_time (OT종료시각) — TIME
  • part (부서) — VARCHAR
  • remark (비고) — VARCHAR
  • rest_time (OT휴게시간) — INT
  • start_date_time (시작일) — DATE
  • start_ot_time (OT시작시각) — TIME
  • vacation_am (오전) — DOUBLE
  • vacation_pm (오후) — DOUBLE
  • vacation_sum (휴일총합) — DOUBLE
  • business_agent (업무대행자) — VARCHAR
  • nickname (회사계정) — VARCHAR
  • user_name (이름) — VARCHAR