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