pantheon tenent
Tables (35)
access_option
- access_option_id — smallint(6) — Primary key — NOT NULL
- access_name — varchar(50) — NOT NULL
- role — varchar(16) — NOT NULL
- default_value — varchar(2) — NOT NULL
- description — varchar(128) — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
admin_setting
- company_image_url — varchar(256)
- company_image_name — varchar(256)
- cl_image_url — varchar(256)
- cl_image_name — varchar(256)
- cl_theme — varchar(16)
- cl_background_color — varchar(16)
- cl_text_color — varchar(16)
- cl_text — varchar(2048)
- smsset_info — varchar(16)
- storageset_info — varchar(16)
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
advisor_category
- user_id — int(11) — Foreign key → tb_user.user_id — NOT NULL
- category_id — int(11) — Foreign key → category.category_id — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
advisor_group
- group_id — int(11) — Foreign key → group.group_id — NOT NULL
- user_id — int(11) — Foreign key → tb_user.user_id — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
allow_dom
- dom_id — int(11) — Primary key — NOT NULL
- dom_text — varchar(128)
- dom_memo — varchar(1028)
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
allow_ip
- ip_id — int(11) — Primary key — NOT NULL
- ip_text — varchar(128)
- ip_memo — varchar(1028)
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
auto_message
- amsg_id — int(11) — Primary key — NOT NULL
- msg_type — varchar(2)
- message — varchar(1024)
- active — varchar(1)
banword
- banw_id — int(11) — Primary key — NOT NULL
- word — varchar(128) — NOT NULL
- created_date — datetime
call_participant_history
- cpht_id — int(11) — Primary key — NOT NULL
- call_id — varchar(15) — NOT NULL
- participant_id — int(11)
- id — varchar(128)
- host — varchar(128)
- token — varchar(128)
- ws_id — varchar(128)
- participant_role — varchar(16)
- participant_type — varchar(16)
- signal_type — varchar(16)
- participant_location — varchar(16)
- audio_active — tinyint(1)
- video_active — tinyint(1)
- frame_rate — int(11)
- date — datetime
- join_date — datetime
- leave_date — datetime
category
- category_id — int(11) — Primary key — NOT NULL
- category_name — varchar(30) — NOT NULL
- category_name_short — varchar(10)
- parent_category_id — int(11) — Foreign key → category.category_id
- category_depth — smallint(6) — NOT NULL
- disp_order — smallint(6) — NOT NULL
- category_image — text
- category_description — varchar(500)
- del_flg — smallint(6) — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
client_terminal_info
- id — int(11) — Primary key — NOT NULL
- term_ip — varchar(44)
- site_name — varchar(16)
- site_code — int(11)
- term_name — varchar(16)
- term_code — varchar(50)
- created_date — datetime
- modified_date — datetime
content_capture
- capture_id — int(11) — Primary key — NOT NULL
- room_id — varchar(32) — Foreign key → room_history.room_id — NOT NULL
- file_name — varchar(256)
- size — int(11)
- format — varchar(128)
- create_date — datetime
content_chat
- chat_id — int(11) — Primary key — NOT NULL
- room_id — varchar(32) — Foreign key → room_history.room_id — NOT NULL
- chat — longtext
- chat_detail — longtext
- create_date — datetime
content_memo
- memo_id — int(11) — Primary key — NOT NULL
- room_id — varchar(128) — NOT NULL
- client_id — varchar(128)
- agent_id — varchar(128)
- memo_title — varchar(128)
- memo — varchar(1028)
- create_date — datetime
- modify_date — datetime
content_record
- record_id — int(11) — Primary key — NOT NULL
- room_id — varchar(32) — Foreign key → room_history.room_id — NOT NULL
- file_name — varchar(256)
- rec_turn — int(2) — NOT NULL
- seq_no — int(2) — NOT NULL
- intval — int(8) — NOT NULL
- user_type — varchar(12)
- size — int(11)
- play_time — int(11)
- format — varchar(256)
- create_date — datetime
content_size
- size_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → tb_user.user_id
- size — int(16)
- size_h — varchar(16)
- yymm — varchar(16)
content_views
- cont_id — int(11) — Primary key — NOT NULL
- sms_count — varchar(20) — NOT NULL
- sms_per — varchar(20) — NOT NULL
- storage_size — varchar(20) — NOT NULL
- storage_per — varchar(20) — NOT NULL
- yymm — varchar(8) — NOT NULL
- sms_send — varchar(8)
- storage_send — varchar(8)
fermi_notice
- noti_id — int(11) — Primary key — NOT NULL — 공지사항 아이디
- user_id — int(11) — Foreign key → tb_user.user_id
- title — varchar(128)
- seq_no — int(4) — 배열 순서
- contents — varchar(2048)
- hiding — varchar(1) — 화면 표시 여부
- start_date — datetime — 게시 시작일(포함)
- end_date — datetime — 게시 종료일(포함)
- created_date — datetime
- modified_date — datetime
gallery_folders
- fold_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → tb_user.user_id
- parnt_id — int(11)
- depth — int(2)
- name — varchar(128)
- path — varchar(1024)
- created_date — datetime
- modified_date — datetime
gallery_images
- imag_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → tb_user.user_id
- fold_id — int(11) — Foreign key → gallery_folders.fold_id — NOT NULL
- disp_idx — int(4) — NOT NULL
- name — varchar(128)
- path — varchar(1024)
- thumbnail_path — varchar(1024)
- size — int(16)
- created_date — datetime
- modified_date — datetime
group
- group_id — int(11) — Primary key — NOT NULL
- group_name — varchar(50) — NOT NULL
- group_type — smallint(6)
- parent_group_id — int(11) — Foreign key → group.group_id
- group_depth — smallint(6) — NOT NULL
- group_image — text
- group_description — varchar(500)
- del_flg — int(11) — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
group_category
- category_id — int(11) — Foreign key → category.category_id — NOT NULL
- group_id — int(11) — Foreign key → group.group_id — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
guest
- guest_id — int(11) — Primary key — NOT NULL
- phone_number — varchar(64)
- name — varchar(128)
- memo — varchar(128)
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
ip_camera_info
- id — int(11) — Primary key — NOT NULL
- ip — varchar(45)
- port — int(11)
- access_id — varchar(128)
- access_pw — varchar(256)
- name — varchar(128)
- created_date — datetime
- modified_date — datetime
keyword
- keyw_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → tb_user.user_id — NOT NULL
- keyword — varchar(128) — NOT NULL
- message — varchar(2048)
- created_date — datetime
language
- language_id — int(11) — Primary key — NOT NULL
- language_name_en — varchar(100) — NOT NULL
- language_name — varchar(50) — NOT NULL
- locale_code — varchar(10) — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
phone_books
- pbok_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → tb_user.user_id
- phone_number — varchar(64)
- name — varchar(128)
- memo — varchar(128)
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
room_history
- room_id — varchar(32) — Primary key — NOT NULL
- company — varchar(128)
- org_agt_id — varchar(128)
- caller — varchar(128)
- login_id — varchar(32)
- crname — varchar(128)
- callee — varchar(128)
- site_code — varchar(12)
- site_name — varchar(256)
- terminal_id — int(2)
- item_code — varchar(16)
- item_name — varchar(32)
- sms — varchar(1)
- sms_num — varchar(64)
- room_index — varchar(16)
- room_type — varchar(16)
- room_policy — varchar(16)
- req_url — varchar(256)
- content_path — varchar(256)
- create_date — datetime
- connected_date — datetime
- end_date — datetime
- room_status — varchar(16)
- is_missed — varchar(1)
- rate — int(2) — NOT NULL
- close_code — int(3)
- close_reason — varchar(128)
- sip_call_dir — int(11)
- sip_call_id — varchar(256)
- sip_uid — varchar(256)
- memo_title — varchar(256)
- client_name — varchar(256)
- client_phone — varchar(16)
- client_email — varchar(32)
- client_remark — varchar(128)
- content_chat — varchar(1)
- content_capture — varchar(1)
- content_record — varchar(1)
- content_memo — varchar(1)
- content_video_call — varchar(1)
- content_file_share — varchar(1)
- content_screen_share — varchar(1)
- invalid — varchar(1)
shop_service_option
- access_option_id — smallint(6) — Foreign key → access_option.access_option_id — NOT NULL
- value — varchar(100)
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
sms_count
- smsc_id — int(11) — Primary key — NOT NULL
- yymm — varchar(8) — NOT NULL
- count — int(11) — NOT NULL
sms_count_user
- smscu_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → tb_user.user_id — NOT NULL
- count — int(11) — NOT NULL
- total_call_count — int(11) — NOT NULL
- last_count — int(11) — NOT NULL
- last_total_call_count — int(11) — NOT NULL
tb_user
- user_id — int(11) — Primary key — NOT NULL
- login_id — varchar(32) — NOT NULL
- emp_num — varchar(50)
- position — varchar(50) — 직급/직책
- ext_num — varchar(50) — 내선번호
- password — varchar(256) — NOT NULL
- email — varchar(128)
- user_type — varchar(16) — NOT NULL
- salt — varchar(128) — NOT NULL
- name — varchar(128) — NOT NULL
- family_name — varchar(32)
- phone_number — varchar(32) — NOT NULL
- business — varchar(64) — NOT NULL
- user_image_url — varchar(256)
- tnt_id — int(11)
- lics_id — int(11)
- is_verified — varchar(1)
- wrong_count — int(4)
- web_password — varchar(256)
- web_salt — varchar(128)
- custom_ci — varchar(2)
- last_login_date — datetime
- last_logout_date — datetime
- create_date — datetime — NOT NULL
- modify_date — datetime
token
- id — int(16) — Primary key — NOT NULL
- room_id — varchar(32) — Foreign key → room_history.room_id
- token — varchar(16)
whatsnew
- noti_id — bigint(20) — Primary key — NOT NULL
- title — varchar(128) — NOT NULL
- noti_date — datetime — NOT NULL
- contents — varchar(2048)
- hiding — varchar(1) — NOT NULL — enable
- del_flg — smallint(6) — NOT NULL
- insert_id — varchar(16) — NOT NULL
- insert_date — datetime — NOT NULL
- update_id — varchar(16) — NOT NULL
- update_date — datetime — NOT NULL
- version — smallint(6)
work_schedule
- wksd_id — int(11) — Primary key — NOT NULL
- schedule_type — varchar(1)
- what_day — varchar(1)
- day_index — int(11)
- is_work — varchar(1)
- is_allday — varchar(1)
- stime — varchar(4)
- etime — varchar(4)
- date — varchar(8)
- schedule_contents — varchar(1024)