진도토건

테이블 (11)

공수 신청 내역 (t_work_request_list)

  • id — int — 기본 키 — NOT NULL
  • year_month — varchar(7)
  • day — varchar(2)
  • request_time — datetime
  • site_gubun — varchar(200)
  • user_id — varchar(200)
  • user_name — varchar(200)
  • request_memo — varchar(1000)
  • approval_yn — char(1)
  • del_yn — char(1)
  • request_numberofdays — varchar(100)
  • user_id (user_id2) — varchar(200) — 외래 키 → 사용자 정보 원본.user_id — NOT NULL

달력 세팅 (t_calendar_info)

  • id — int — NOT NULL
  • year — varchar(4)
  • month — varchar(2)
  • total_day — int
  • start_point — int
  • reg_dtm — datetime

사용자 정보 (t_member_info)

  • member_id — varchar(200) — 기본 키 — NOT NULL
  • member_encrypt_passwd — varchar(200)
  • member_name — varchar(200)
  • member_nick_name — varchar(200)
  • member_tel — varchar(200)
  • member_mobile — varchar(200)
  • member_email_recv_yn — char(1)
  • member_sms_recv_yn — char(1)
  • member_encrypt_social_number — varchar(200)
  • member_birth — datetime
  • member_birth_west_yn — char(1)
  • member_sex — char(1)
  • member_merried_yn — char(1)
  • member_married_date — varchar(200)
  • member_img_path — varchar(max)
  • member_img_path_2 — varchar(max)
  • member_grade — char(1)
  • member_start_date — varchar(200)
  • member_end_date — varchar(200)
  • member_group_type — varchar(200)
  • created_dtm — datetime
  • h_zipcode — varchar(200)
  • h_addr1 — varchar(200)
  • h_addr2 — varchar(200)
  • corp_id — int
  • corp_dept_id — int
  • corp_name — varchar(200)
  • corp_role — varchar(200)
  • corp_level — varchar(200)
  • member_auth_status — char(1)
  • member_status — char(1)
  • member_name2 — varchar(200)
  • member_bank_name — varchar(200)
  • member_bank_number — varchar(200)
  • member_pay — varchar(200)
  • member_pay_status — varchar(200)
  • member_etc_memo — varchar(1000)
  • member_contract — varchar(200)
  • suprema_access_id — int
  • suprema_access_group — varchar(200)
  • suprema_credential_type — nchar(10)
  • erp_pm — varchar(4000)
  • site_gubun — varchar(200)
  • foreigner_yn — char(1)
  • member_eng_name — varchar(200)
  • member_passport_no — varchar(200)
  • member_nation — varchar(200)
  • member_stay_name — varchar(200)
  • daily_worker_yn — char(1)
  • attach1_upload_filename — varchar(200)
  • attach1_org_filename — varchar(200)
  • attach2_upload_filename — varchar(200)
  • attach2_org_filename — varchar(200)
  • member_signature — varchar(max)
  • member_signature2 — varchar(max)
  • member_signature3 — varchar(max)
  • member_signature4 — varchar(max)
  • member_signature5 — varchar(max)
  • member_signature6 — varchar(max)
  • admin_auth — varchar(3)

사용자 정보 원본 (t_suprema_user)

  • user_id — varchar(200) — 기본 키 — NOT NULL
  • user_uid — varchar(200)
  • user_name — varchar(200)
  • birth_date — datetime
  • group_name — varchar(200)
  • group_type — varchar(10)
  • gen — varchar(200)
  • tit — varchar(200)
  • phone — varchar(200)
  • email — varchar(200)
  • create_dtm — datetime
  • deleted_yn — char(1)
  • site_gubun — varchar(200)

월간 근무 달력 (t_member_working_calendar_info)

  • id — int — 기본 키 — NOT NULL
  • user_id — varchar(200) — NOT NULL
  • year — varchar(4)
  • month — varchar(2)
  • day — int
  • s_time — varchar(10)
  • s_photo — varchar(max)
  • e_time — varchar(10)
  • e_photo — varchar(max)
  • min_tiff — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • user_id (user_id2) — varchar(200) — 외래 키 → 사용자 정보 원본.user_id — NOT NULL

월간 근태 정보 (t_working_month_info)

  • id — int — 기본 키 — NOT NULL
  • year_month — varchar(7) — NOT NULL
  • user_id — varchar(200) — NOT NULL
  • user_name — varchar(200) — NOT NULL
  • company — varchar(200)
  • month_min_time — int
  • month_day — int
  • phone — varchar(200)
  • email — varchar(200)
  • site_gubun — varchar(200)
  • user_id (user_id2) — varchar(200) — 외래 키 → 사용자 정보 원본.user_id — NOT NULL

일일 근태 정보 (t_working_daily_info)

  • id — int — 기본 키 — NOT NULL
  • year_month_day — varchar(10) — NOT NULL
  • user_id — varchar(200)
  • user_name — varchar(200)
  • company — varchar(200)
  • phone — varchar(200)
  • email — varchar(200)
  • s_time — varchar(10)
  • s_device — varchar(200)
  • e_time — varchar(10)
  • e_device — varchar(200)
  • min_tiff — int
  • site_gubun — varchar(200)
  • memo — varchar(200)
  • e_time_edit — varchar(10)
  • s_photo — varchar(200)
  • e_photo — varchar(200)
  • approval_yn — char(1)
  • user_id (user_id2) — varchar(200) — 외래 키 → 사용자 정보 원본.user_id — NOT NULL

출입 정보 원본 (t_suprema_doorlog)

  • id — int — 기본 키 — NOT NULL
  • event_log_id — int — NOT NULL
  • user_id — varchar(200)
  • user_name — varchar(200)
  • user_group — varchar(200)
  • event_time — datetime
  • device_name — varchar(200)
  • img_folder_name — varchar(200)
  • img_file_name — varchar(200)
  • table_name — varchar(200)
  • site_gubun — varchar(200)
  • create_dtm — varchar(200)
  • user_id (user_id2) — varchar(200) — 외래 키 → 사용자 정보 원본.user_id — NOT NULL

팀 내 공수 신청 인원 (t_work_team_member_request_list)

  • id — int — 기본 키 — NOT NULL
  • team_id — int
  • user_id — varchar(200)
  • user_name — varchar(200)
  • del_yn — char(1)
  • user_id (user_id2) — varchar(200) — 외래 키 → 사용자 정보 원본.user_id — NOT NULL

팀별 공수 신청 내역 (t_work_team_request_list)

  • id — int — 기본 키 — NOT NULL
  • year_month — varchar(7)
  • day — varchar(2)
  • request_time — datetime
  • site_gubun — varchar(200)
  • company — varchar(200)
  • member — varchar(max)
  • request_numberofdays — nchar(10)
  • request_memo — varchar(1000)
  • person_cnt — varchar(1000)
  • approval_yn — char(1)
  • del_yn — char(1)

팀별 일일 근태 정보 (t_working_team_daily_info)

  • id — int — 기본 키 — NOT NULL
  • year_month_day — varchar(10)
  • company — varchar(200)
  • working_person_cnt — varchar(200)
  • site_gubun — varchar(200)
  • approval_yn — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =