FS
Tables (468)
activity_seq
- next_not_cached_value — bigint(21) — NOT NULL
- minimum_value — bigint(21) — NOT NULL
- maximum_value — bigint(21) — NOT NULL
- start_value — bigint(21) — NOT NULL — start value when sequences is created or value if RESTART is used
- increment — bigint(21) — NOT NULL — increment value
- cache_size — bigint(21) — NOT NULL
- cycle_option — tinyint(1) — NOT NULL — 0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed
- cycle_count — bigint(21) — NOT NULL — How many cycles have been done
adddesc
- id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- table_name — varchar(50) — NOT NULL
- filed_id — varchar(30) — NOT NULL
- field_name — varchar(30) — NOT NULL
- field_type — varchar(30) — NOT NULL
- field_code — varchar(30) — NOT NULL
- sort — int(11) — NOT NULL
- index — int(11) — NOT NULL
- input_item — varchar(100) — NOT NULL
- data_type — varchar(30) — NOT NULL
- field_name_1 — varchar(30) — NOT NULL
- field_name_2 — varchar(30) — NOT NULL
- field_name_3 — varchar(30) — NOT NULL
appkeymapping
- pakage_name — varchar(100) — Primary key — NOT NULL
- device_id — varchar(200) — Primary key — NOT NULL
- app_version — varchar(50) — NOT NULL
- cell_type — varchar(100) — NOT NULL
- token_value — varchar(200) — NOT NULL
appversion
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- cell_type — varchar(1) — Primary key — NOT NULL — 핸드폰종류(i : 아이폰, a:안드로이드)
- pakage_name — varchar(100) — Primary key — NOT NULL — 패키지명
- app_version — varchar(30) — 최신앱버젼
- app_url — varchar(100) — 다운url
comcodecustomgroup
- comp_id — varchar(30) — Primary key — NOT NULL
- group_code — varchar(20) — Primary key — NOT NULL
- group_name — varchar(50) — NOT NULL
- code_length — int(11)
- group_category — varchar(10)
- field_caption1 — varchar(50)
- field_caption2 — varchar(50)
- field_caption3 — varchar(50)
- field_caption4 — varchar(50)
- field_caption5 — varchar(50)
- descr — varchar(300)
- use_yn — varchar(1)
comcodecustommaster
- comp_id — varchar(30) — Primary key — NOT NULL
- group_code — varchar(20) — Primary key — NOT NULL
- sub_code — varchar(20) — Primary key — NOT NULL
- code_name — varchar(50) — NOT NULL
- extra_field1 — varchar(50)
- extra_field2 — varchar(50)
- extra_field3 — varchar(50)
- extra_field4 — varchar(50)
- extra_field5 — varchar(50)
- sort_seq — int(11)
- use_yn — varchar(1)
comcodegroup
- comp_id — varchar(30) — Primary key — NOT NULL
- group_code — varchar(20) — Primary key — NOT NULL
- group_name — varchar(50) — NOT NULL
- code_length — int(11) — NOT NULL
- group_category — varchar(10) — NOT NULL
- field_caption1 — varchar(50)
- field_caption2 — varchar(50)
- field_caption3 — varchar(50)
- field_caption4 — varchar(50)
- field_caption5 — varchar(50)
- descr — varchar(300)
- use_yn — varchar(1) — NOT NULL
- usercode_yn — varchar(1)
comcodemaster
- comp_id — varchar(30) — Primary key — NOT NULL
- group_code — varchar(20) — Primary key — NOT NULL
- sub_code — varchar(20) — Primary key — NOT NULL
- code_name — varchar(4000) — NOT NULL
- system_yn — varchar(1) — NOT NULL
- extra_field1 — varchar(50)
- extra_field2 — varchar(50)
- extra_field3 — varchar(50)
- extra_field4 — varchar(50)
- extra_field5 — varchar(50)
- sort_seq — int(11) — NOT NULL
- use_yn — varchar(1) — NOT NULL
- code_name_1 — varchar(4000) — NOT NULL
- code_name_2 — varchar(4000) — NOT NULL
- code_name_3 — varchar(60) — NOT NULL
comcodemaster_20220414
- comp_id — varchar(30) — NOT NULL
- group_code — varchar(20) — NOT NULL
- sub_code — varchar(20) — NOT NULL
- code_name — varchar(4000) — NOT NULL
- system_yn — varchar(1) — NOT NULL
- extra_field1 — varchar(50)
- extra_field2 — varchar(50)
- extra_field3 — varchar(50)
- extra_field4 — varchar(50)
- extra_field5 — varchar(50)
- sort_seq — int(11) — NOT NULL
- use_yn — varchar(1) — NOT NULL
- code_name_1 — varchar(4000) — NOT NULL
- code_name_2 — varchar(4000) — NOT NULL
- code_name_3 — varchar(60) — NOT NULL
comzipcode
- ZIPCODE — varchar(10)
- SEQ — varchar(10)
- SIDO — varchar(50)
- GUGUN — varchar(50)
- DONG — varchar(50)
- RI — char(50)
- BUNJI — varchar(50)
- BUILD — char(100)
- ADDRESS — varchar(200)
comzipcodemaster
- code — char(3) — Primary key — NOT NULL
- seq — int(11) — NOT NULL
- name — varchar(10) — NOT NULL
crmactivity
- activity_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_ref — varchar(30)
- act_type — varchar(20)
- act_purpose — varchar(20)
- act_category — varchar(2)
- act_date — varchar(8)
- act_date_old — varchar(8)
- act_subject — varchar(1000)
- act_text — longtext
- act_place_type — varchar(2)
- act_time — varchar(6)
- act_time_end — varchar(6)
- act_yn — varchar(1)
- act_input_time — datetime
- act_status — varchar(2)
- plan_date — varchar(8)
- plan_time — varchar(6)
- plan_time_end — varchar(6)
- plan_text — varchar(2000)
- plan_input_time — datetime
- employee_id — varchar(30)
- dept_code — varchar(10)
- comment — varchar(2000)
- create_time — datetime
- update_time — datetime
- create_user — varchar(30)
- update_user — varchar(30)
- act_text2 — longtext
crmactivitycalendar
- comp_id — varchar(30) — Primary key — NOT NULL
- employee_id — varchar(30) — Primary key — NOT NULL
- calendar_type — varchar(30) — Primary key — NOT NULL
- division — longtext
- default_yn — varchar(1)
- ent_act_yn — varchar(1) — 전사일정 체크 유무(부서캘린더)
- select_time — datetime
crmactivitycaroperation
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- activity_ref — varchar(30) — NOT NULL
- departure — varchar(10)
- car_type — varchar(10)
- mileage — decimal(18,3)
- passage_money — int(11)
- parking_fee — int(11)
crmactivitycomment
- comp_id — varchar(30) — NOT NULL
- activity_id — int(11) — NOT NULL
- activity_ref — varchar(30) — NOT NULL
- seq — smallint(5) — NOT NULL
- comment — varchar(1000) — NOT NULL
- create_user — varchar(30)
- create_time — datetime
crmactivitycoordinates
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- lat — varchar(20) — NOT NULL
- lng — varchar(20) — NOT NULL
- address1 — varchar(300) — NOT NULL
- address2 — varchar(300)
crmactivitydeleteinfo
- activity_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- plan_date — varchar(8)
crmactivityfiles
- comp_id — varchar(50) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- file_id — int(11) — Primary key — NOT NULL
- order_seq — int(11)
- create_time — datetime
- create_user — varchar(50)
crmactivitygooglecalendar
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- employee_id — varchar(30) — Primary key — NOT NULL
- google_id — varchar(300) — Primary key — NOT NULL
- event_id — varchar(300) — NOT NULL
crmactivitymail
- comp_id — varchar(30) — Primary key — NOT NULL
- mail_id — varchar(50) — Primary key — NOT NULL
- transfer_type — varchar(2)
- mail_title — varchar(1000)
- mail_content — longtext
- send_rcv_time — datetime
- send_address — varchar(200)
- rcv_address — longtext
- employee_id — varchar(30)
- create_time — datetime
- create_user — varchar(30)
crmactivitymemo
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- memo_text — varchar(4000)
- create_time — datetime
- update_time — datetime
- create_user — varchar(30)
- update_user — varchar(30)
crmactivityoutlookcalendar
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- employee_id — varchar(30) — Primary key — NOT NULL
- event_id — varchar(200) — Primary key — NOT NULL
- delete_on_graph_yn — varchar(1)
- create_time — datetime
- delete_time — datetime
crmactivityparticipant
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- contact_id — int(11) — Primary key — NOT NULL
- company_id — int(11)
- create_time — datetime — NOT NULL
- idx — int(11) — NOT NULL
crmactivityproduct
- comp_id — varchar(30) — Primary key — NOT NULL
- product_code — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- create_time — datetime
- create_user — varchar(30)
crmactivityuserdefined
- activity_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- text1 — varchar(100)
- text2 — varchar(100)
- text3 — varchar(100)
- text4 — varchar(100)
- text5 — varchar(100)
- text6 — varchar(100)
- text7 — varchar(100)
- text8 — varchar(100)
- text9 — varchar(100)
- text10 — varchar(100)
- number1 — bigint(20)
- number2 — bigint(20)
- number3 — bigint(20)
- number4 — bigint(20)
- number5 — bigint(20)
- number6 — bigint(20)
- number7 — bigint(20)
- number8 — bigint(20)
- number9 — bigint(20)
- number10 — bigint(20)
- select1 — varchar(20)
- select2 — varchar(20)
- select3 — varchar(20)
- select4 — varchar(20)
- select5 — varchar(20)
- select6 — varchar(20)
- select7 — varchar(20)
- select8 — varchar(20)
- select9 — varchar(20)
- select10 — varchar(20)
- radio1 — varchar(20)
- radio2 — varchar(20)
- radio3 — varchar(20)
- radio4 — varchar(20)
- radio5 — varchar(20)
- check1 — varchar(1)
- check2 — varchar(1)
- check3 — varchar(1)
- check4 — varchar(1)
- check5 — varchar(1)
- date1 — varchar(8)
- date2 — varchar(8)
- date3 — varchar(8)
- date4 — varchar(8)
- date5 — varchar(8)
- memo1 — varchar(1000)
- memo2 — varchar(1000)
- memo3 — varchar(1000)
- memo4 — varchar(1000)
- memo5 — varchar(1000)
crmactivityweeklydetail
- comp_id — varchar(30) — Primary key — NOT NULL
- report_yyyymm — varchar(6) — Primary key — NOT NULL
- report_week — varchar(2) — Primary key — NOT NULL
- employee_id — varchar(30) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- activity_id — int(11)
- activity_ref — varchar(30)
- status — varchar(100)
- set_info — varchar(100)
- issue — varchar(4000)
- action_item — varchar(1000)
- due_date — varchar(8)
- weekly_status — varchar(2)
crmactivityweeklyreport
- comp_id — varchar(30) — Primary key — NOT NULL
- report_yyyymm — varchar(6) — Primary key — NOT NULL
- report_week — varchar(2) — Primary key — NOT NULL
- employee_id — varchar(30) — Primary key — NOT NULL
- report_title — varchar(500)
- sales_target — varchar(2000)
- sales_info — varchar(2000)
- sales_etc — varchar(2000)
- weekly_descr — varchar(2000)
- next_week_descr — varchar(2000)
- businesstrip — varchar(2000)
- approval_user — varchar(30)
- approval_yn — varchar(1)
- approval_time — datetime
- approval_remark — varchar(2000)
- submit_date — datetime
- submit_yn — varchar(1)
- order_descr — varchar(2000)
- create_time — datetime
- update_time — datetime
- create_user — varchar(30)
- update_user — varchar(30)
crmactivitywithemp
- comp_id — varchar(30) — Primary key — NOT NULL
- activity_id — int(11) — Primary key — NOT NULL
- employee_id — varchar(30) — Primary key — NOT NULL
- activity_ref — varchar(30) — NOT NULL
- create_time — datetime
- create_user — varchar(30)
crmaddedfilesendmaillog
- mail_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- send_date — varchar(8) — NOT NULL
- product_code — varchar(30) — NOT NULL
- file_id — int(11) — NOT NULL
- create_user — varchar(30)
- create_time — datetime
crmaddedfilesendmailrecplog
- comp_id — varchar(30) — Primary key — NOT NULL
- mail_id — int(11) — Primary key — NOT NULL
- to_type — tinyint(3) — Primary key — NOT NULL
- contact_id — varchar(30) — Primary key — NOT NULL
- idx — int(11) — NOT NULL
crmalarm
- alarm_id — int(11) — Primary key — NOT NULL — 알람ID
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- alarm_message — varchar(500) — 알람 메시지
- alarm_page — varchar(150) — 알람이동 페이지
- employee_id — varchar(50) — 담당자
- read_yn — varchar(1) — 읽음:Y,안읽음:N
- create_time — timestamp — 등록시간
- create_user — varchar(50) — 등록자
- delete_yn — varchar(1)
crmanniversary
- comp_id — varchar(30) — Primary key — NOT NULL
- anniversary_id — varchar(30) — Primary key — NOT NULL
- anniversary_type — varchar(2)
- anniversary_date — varchar(8)
- lunar_solar — varchar(1)
- repeat_type — varchar(2)
- descr — varchar(300)
- alarm_yn — varchar(1)
- mobile_alarm_yn — varchar(1)
- create_user — varchar(30)
- create_time — datetime
- update_user — varchar(30)
- update_time — datetime
crmapiauth
- token_id — varchar(100) — Primary key — NOT NULL
- auth_prospect — char(5) — NOT NULL — 권한정보. 목록/상세/등록/변경/삭제 순으로 'Y/N' 문자열
- auth_contact — char(5) — NOT NULL — 권한정보. 목록/상세/등록/변경/삭제 순으로 'Y/N' 문자열
- auth_company — char(5) — NOT NULL — 권한정보. 목록/상세/등록/변경/삭제 순으로 'Y/N' 문자열
crmapikey
- token_id — varchar(100) — Primary key — NOT NULL
- comp_id — varchar(30) — NOT NULL
- pwd — varchar(128) — NOT NULL
- update_time — timestamp — NOT NULL
crmapproval
- comp_id — varchar(30) — Primary key — NOT NULL
- approval_id — varchar(30) — Primary key — NOT NULL
- approval_subject — varchar(500)
- approval_type — varchar(30)
- approval_status — varchar(30)
- confirm_req_user — varchar(30)
- confirm_req_time — datetime
- cur_process_seq — int(11)
- confirm_time — datetime
- delete_yn — varchar(1)
crmapprovalcomment
- comp_id — varchar(30) — Primary key — NOT NULL
- approval_id — varchar(30) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- comment — varchar(4000)
- create_time — datetime
- create_user — varchar(30)
crmapprovalemail
- comp_id — varchar(30) — Primary key — NOT NULL
- approval_id — varchar(30) — Primary key — NOT NULL
- subject — varchar(500)
- contents — longtext
- create_time — datetime
- create_user — varchar(30)
crmapprovalprocess
- comp_id — varchar(30) — Primary key — NOT NULL
- approval_id — varchar(30) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- confirm_user — varchar(30)
- real_confirm_user — varchar(30)
- confirm_time — datetime
- proc_status — varchar(2)
- confirm_remark — varchar(4000)
- last_process_yn — varchar(1)
crmautosaveoutmailparams
- idx — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — NOT NULL
- contact_id — int(11) — NOT NULL
- contact_email_addr — varchar(500) — NOT NULL
- employee_id — varchar(30) — NOT NULL
- emp_dept_code — varchar(10) — NOT NULL
- create_time — datetime — NOT NULL
crmboard
- board_id — int(11) — Primary key — NOT NULL
- employee_id — varchar(30) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- board_category — varchar(20) — NOT NULL
- board_title — varchar(200)
- background_class — varchar(20)
- menu_id — varchar(30) — NOT NULL
- ref_board_id — int(11)
- order_seq — int(11)
- create_time — datetime
crmboardincompany
- seq — int(11) — Primary key — NOT NULL
- board_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — NOT NULL
- point_color — varchar(300)
- order_seq — smallint(6)
- idx — int(11) — NOT NULL
crmboardincontact
- seq — int(11) — Primary key — NOT NULL
- board_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- contact_id — varchar(30) — NOT NULL
- contact_ref — varchar(30) — NOT NULL
- point_color — varchar(300)
- order_seq — smallint(6)
- idx — int(11) — NOT NULL
crmboardinopportunity
- seq — int(11) — Primary key — NOT NULL
- board_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- opportunity_id — int(11) — NOT NULL
- opportunity_ref — varchar(30) — NOT NULL
- point_color — varchar(300)
- order_seq — smallint(6)
- idx — int(11) — NOT NULL
crmcampaign
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- campaign_id — varchar(30) — Primary key — NOT NULL — 캠페인Id
- campaign_name — varchar(100) — 캠페인이름
- campaign_descr — varchar(1000) — 캠페인 설
- campaign_type — varchar(10) — 캠페인 종류
- campaign_status — varchar(10) — 켐페인상태
- employee_id — varchar(30) — 담당자
- start_date — varchar(8) — 시작일
- end_date — varchar(8) — 종료일
- template_id — int(11) — 탬플릿ID
- create_time — timestamp — 생성시간
- create_user — varchar(30) — 등록자
- update_time — datetime — 수정시간
- update_user — varchar(30) — 수정자
- delete_yn — varchar(1) — NOT NULL — 삭제여부
crmcampaignaction
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- action_id — int(11) — Primary key — NOT NULL — 활동ID
- task_id — int(11) — NOT NULL — 업무ID
- create_time — timestamp — 등록시간
- create_user — varchar(30) — 등록자
crmcampaignactionresponse
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- response_id — int(11) — Primary key — NOT NULL — 응답ID
- action_id — int(11) — Primary key — NOT NULL — 활동ID
- contact_id — int(11) — Primary key — NOT NULL — 고객ID
- target_id — int(11) — Primary key — NOT NULL — 타겟ID
- email_open — varchar(1) — EMAIL확인여부
- email_click — varchar(1) — EMAIL클릭여부
- email_block — varchar(1) — EMAIL발신금지여부
- sms_click — varchar(1) — SMS클릭여부
- sms_block — varchar(1) — SMS차단여부
- tm_positive — varchar(1) — TM긍정여부
- tm_negative — varchar(1) — TM부정여부
- dm_positive — varchar(1) — DM긍정여부
- dm_negative — varchar(1) — DM부정여부
- create_time — timestamp — 등록시간
- create_user — varchar(30) — 등록자
- update_time — datetime — 수정시간
- update_user — varchar(30) — 수정자
crmcampaignbudget
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- budget_id — int(11) — Primary key — NOT NULL — 예산ID
- campaign_id — int(11) — Primary key — NOT NULL — 캠페인ID
- budget_type — varchar(30) — 예산유형
- budget_amt — decimal(10, 2) — 금액
- forecast_yn — varchar(1) — 예상여부(예상Y,실제N)
- create_time — timestamp — 등록시간
- create_user — varchar(30) — 등록자
- update_time — datetime — 수정시간
- update_user — varchar(30) — 수정자
- delete_yn — varchar(1) — 삭제여부
crmcampaignbudgetdetail
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- budget_id — int(11) — Primary key — NOT NULL — 예산 ID
- seq — int(11) — Primary key — NOT NULL — 시퀀스
- budget_detail_desc — varchar(500) — 예산 상세 유형
- budget_detail_amt — decimal(10, 2) — 예산 상세 금액
- create_time — timestamp — 등록시간
- create_user — varchar(30) — 등록자
- update_time — datetime — 수정시간
- update_user — varchar(30) — 수정자
crmcampaignevent
- comp_id — varchar(30) — Primary key — NOT NULL
- campaign_id — varchar(30) — Primary key — NOT NULL
- campaign_event — varchar(10)
- campaign_term — varchar(10)
- start_date — varchar(8)
- end_date — varchar(8)
- campaign_hour — varchar(10)
- campaign_minute — varchar(10)
- descr — varchar(500)
- create_time — timestamp
- create_user — varchar(30)
- update_time — datetime
- update_user — varchar(30)
crmcampaignevent_old
- comp_id — varchar(30) — Primary key — NOT NULL
- campaign_id — varchar(30) — Primary key — NOT NULL
- campaign_event — varchar(10)
- campaign_term — varchar(10)
- start_date — varchar(8)
- end_date — varchar(8)
- campaign_hour — varchar(10)
- campaign_minute — varchar(10)
- descr — varchar(500)
- create_time — timestamp
- create_user — varchar(30)
- update_time — datetime
- update_user — varchar(30)
crmcampaignmail
- comp_id — varchar(30) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- mail_title — varchar(500)
- mail_content — varchar(4000)
- send_mail_yn — varchar(1)
- template_id — varchar(30)
- create_time — datetime
- create_user — varchar(30)
crmcampaignmail_old
- comp_id — varchar(30) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- mail_title — varchar(500)
- mail_content — varchar(4000)
- send_mail_yn — varchar(1)
- template_id — varchar(30)
- create_time — datetime
- create_user — varchar(30)
crmcampaignmailcontact
- comp_id — varchar(30) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- contact_id — varchar(30) — Primary key — NOT NULL
- create_time — datetime
- create_user — varchar(30)
crmcampaignproduct
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- campaign_id — int(11) — Primary key — NOT NULL — 캠페인Id
- product_code — varchar(30) — Primary key — NOT NULL — 제품코드
- create_time — timestamp — 등록시간
- create_user — varchar(30) — 등록자
crmcampaignschedule
- comp_id — varchar(30) — Primary key — NOT NULL
- campaign_id — varchar(30) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- campaign_date — varchar(8)
- campaign_hour — varchar(10)
- campaign_minute — varchar(10)
- campaign_desr — varchar(500)
- employee_id — varchar(30)
- send_yn — varchar(1)
- campaign_send_time — datetime
- campaign_send_endtime — datetime
- create_time — timestamp
- create_user — varchar(30)
crmcampaigntarget
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- campaign_id — int(11) — Primary key — NOT NULL — 캠페인 ID
- target_id — int(11) — Primary key — NOT NULL — 타겟 ID
- create_time — timestamp — 생성시간
- create_user — varchar(30) — 생성자
crmcampaigntask
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- task_id — int(11) — Primary key — NOT NULL — 업무ID
- campaign_id — int(11) — Primary key — NOT NULL — 캠페인ID
- step_code — varchar(10) — 캠페인상태
- task_code — varchar(10) — 업무코드
- task_status — varchar(10) — 업무상태
- employee_id — varchar(30) — 담당자
- channel — varchar(10) — 채널
- channel_template — varchar(10) — 채널탬플릿
- due_date — varchar(8) — 예정일
- create_time — timestamp — 등록일
- create_user — varchar(30) — 등록자
- update_time — datetime — 수정일
- update_user — varchar(30) — 수정자
crmcampaigntasktarget
- comp_id — varchar(30) — Primary key — NOT NULL
- task_id — int(11) — Primary key — NOT NULL
- target_id — int(11) — Primary key — NOT NULL
- create_time — timestamp
- create_user — varchar(30)
crmcardlist
- comp_id — varchar(50) — Primary key — NOT NULL
- key_id — int(11) — Primary key — NOT NULL
- card_no — varchar(50) — Primary key — NOT NULL — 카드번호
- bank_cd — varchar(50) — 카드사코드
- biz_no — varchar(50) — 사업자번호
- biz_nm — varchar(50) — 업체명
- mmbr_kr_nm — varchar(50) — 회원명(한글)
- mmbr_en_nm — varchar(50) — 회원명(영문)
- card_div — varchar(50) — 카드구분
- card_prod_div — varchar(50) — 카드상품구분
- card_grad — varchar(50) — 카드등급
- card_nick_nm — varchar(50) — 카드별칭
- expr_trm — varchar(50) — 유효기간
- card_sts — varchar(50) — 카드상태
- appr_dt — varchar(50) — 결재일자
- issue_dt — varchar(50) — 발급일자
- card_lmt_amt — varchar(50) — 카드총한도
- card_restlmt_amt — varchar(50) — 카드잔여한도
- os_limit_amt — varchar(50) — 해외총한도
- os_r_amt — varchar(50) — 해외잔여한도
- use_sts — varchar(50) — 사용여부
crmcardmapping
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- card_no — varchar(30) — Primary key — NOT NULL — 카드번호
- map_id — int(11) — NOT NULL — 매핑키
- employee_id — varchar(30) — NOT NULL — 담당자아이디
- create_user — varchar(30) — 생성자
- create_time — datetime — 생성일자
- update_user — varchar(30) — 수정자
- update_time — datetime — 수정일자
crmchatter
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- chatter_id — int(11) — Primary key — NOT NULL — 채터ID
- chatter_name — varchar(100) — 채팅방이름
- create_user — varchar(100) — 생성자
- create_time — timestamp — 생성시간
- update_user — varchar(50) — 수정자
- update_time — datetime — 수정시간
crmchatterdetail
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- chatter_id — varchar(50) — Primary key — NOT NULL — 채터ID
- seq — int(11) — Primary key — NOT NULL — 시퀀스
- share_type — varchar(50) — 공유내용타입
- share_id — varchar(50) — 공유내용ID
crmchatterfiles
- comp_id — varchar(30) — NOT NULL
- chatter_id — int(11) — NOT NULL
- file_id — int(11) — NOT NULL
- sort_seq — int(11)
crmchattermessage
- seq — bigint(20) — Primary key — NOT NULL — 시퀀스
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- chatter_id — varchar(30) — Primary key — NOT NULL — 채터ID
- employee_id — varchar(50) — NOT NULL — 메시지보낸사람
- message — longtext — 메시지내용
- create_time — timestamp — NOT NULL — 등록시간
crmchatteruser
- comp_id — varchar(30) — Primary key — NOT NULL — 회사코드
- chatter_id — int(11) — Primary key — NOT NULL — 채터ID
- employee_id — varchar(50) — Primary key — NOT NULL — 사용자ID
- create_user — varchar(50) — NOT NULL — 생성자
- create_time — timestamp — NOT NULL — 생성시간
crmcompany
- company_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- company_name — varchar(100)
- company_name_eng — varchar(100)
- es_company_name — varchar(100) — dept_name -> es_company_name 변경 edwin
- zip_code — varchar(10)
- address1 — varchar(300)
- address2 — varchar(300)
- website — varchar(500)
- company_phone — varchar(100)
- company_fax — varchar(100)
- mobile_phone — varchar(100) — comp_type -> mobile_phone 변경 edwin
- email_address — varchar(100) — comp_imp_level ->email_address 변경 edwin
- company_level — varchar(20)
- region_type — varchar(10)
- sido — varchar(2)
- gungu — varchar(30)
- business_no — varchar(20)
- start_date — varchar(8)
- ceo_name — varchar(50)
- sales_amt — varchar(50)
- our_sales_amt — decimal(18, 3)
- company_type — varchar(10)
- employee_cnt — int(11)
- register_date — varchar(8)
- delete_yn — varchar(1)
- employee_id — varchar(30)
- key_id — varchar(30)
- remark — varchar(4000)
- progress_status — varchar(30)
- create_time — datetime
- update_time — datetime
- create_user — varchar(30)
- update_user — varchar(30)
- addr_latitude — varchar(100)
- addr_longtitude — varchar(100)
- contact_count — int(11)
- upload_yn — varchar(1)
- remember_id — int(11)
- main_contact_id — int(11)
crmcompanyanniversary
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- anniversary_id — varchar(30) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- create_time — datetime
- create_user — varchar(30)
- idx — int(11) — NOT NULL
crmcompanyattach
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- attach_seq — int(11) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- org_file_name — varchar(300)
- server_file_name — varchar(300)
- file_size — int(11)
- create_time — datetime
- create_user — varchar(30)
- view_file_size — varchar(10)
- idx — int(11) — NOT NULL
crmcompanycomment
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- seq — smallint(6) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- comment — varchar(1000) — NOT NULL
- create_user — varchar(30)
- create_time — datetime
- idx — int(11) — NOT NULL
crmcompanycontract
- comp_id — varchar(30) — Primary key — NOT NULL
- contract_id — int(11) — Primary key — NOT NULL
- company_id — varchar(30) — Primary key — NOT NULL
- contract_ref — varchar(30) — NOT NULL
- company_ref — varchar(30)
- create_time — datetime
- create_user — varchar(30)
- idx — int(11) — NOT NULL
crmcompanycoordinates
- company_id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- succ_yn — char(1) — NOT NULL
- lat — varchar(20) — NOT NULL
- lng — varchar(20) — NOT NULL
- idx — int(11) — NOT NULL
crmcompanycoordinates_copy_20220623
- company_id_copy — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- succ_yn — char(1) — NOT NULL
- lat — varchar(20) — NOT NULL
- lng — varchar(20) — NOT NULL
- idx — int(11) — NOT NULL
crmcompanycorporation
- comp_id — varchar(30) — Primary key — NOT NULL
- reg_no — varchar(30) — Primary key — NOT NULL — 법인등록번호
- company_id — int(11) — 고객사 ID
- pros_company_name — varchar(100) — 잠재고객 고객사명
- create_time — datetime — NOT NULL
- create_user — varchar(30) — NOT NULL
crmcompanydelivery
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- delivery_id — varchar(30) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- create_time — datetime
- create_user — varchar(30)
- idx — int(11) — NOT NULL
crmcompanydeposit
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- deposit_id — varchar(30) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- create_time — datetime
- create_user — varchar(30)
- idx — int(11) — NOT NULL
crmcompanydetail
- id — int(11) — Primary key — NOT NULL
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — NOT NULL
- table_name — varchar(30) — NOT NULL
- add_field_id — varchar(30)
- add_field_value — varchar(200)
- FULLTEXT — KEY
- FULLTEXT — KEY
crmcompanyemphis
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- start_date — varchar(8) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- end_date — varchar(8)
- employee_id — varchar(30)
- cause_text — varchar(2000)
- create_time — datetime
- create_user — varchar(30)
- idx — int(11) — NOT NULL
crmcompanyfiles
- comp_id — varchar(50) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- file_id — int(11) — Primary key — NOT NULL
- order_seq — int(11)
- create_time — datetime
- create_user — varchar(50)
- idx — int(11) — NOT NULL
crmcompanylevelhistory
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- change_date — varchar(8)
- company_level — varchar(20)
- cause — varchar(4000)
- create_time — datetime
- create_user — varchar(30)
- idx — int(11) — NOT NULL
crmcompanymemo
- comp_id — varchar(30) — Primary key — NOT NULL
- company_id — int(11) — Primary key — NOT NULL
- seq — int(11) — Primary key — NOT NULL
- company_ref — varchar(30) — NOT NULL
- memo_text — varchar(4000)
- create_time — datetime
- update_time — datetime
- create_user — varchar(30)
- update_user — varchar(30)
- idx — int(11) — NOT NULL
and 388 more tables