진도토건
테이블 (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 — =