CEMS_ERD Main

Tables (45)

action

  • action_id — int — Primary key — NOT NULL
  • action_preset_id — int — Foreign key → action_preset.action_preset_id — NOT NULL
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • action_conf — text — NOT NULL — json marshal string
  • action_name — varchar(40) — NOT NULL
  • action_type — varchar(20) — NOT NULL
  • action_desc — text — NOT NULL

action_preset

  • action_preset_id — int — Primary key — NOT NULL
  • vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
  • admin_id — int — Foreign key → vendor.admin_id — NOT NULL
  • action_conf — text — NOT NULL — json marshal string
  • action_name — varchar(40) — NOT NULL
  • action_type — varchar(20) — NOT NULL
  • action_desc — text — NOT NULL — description
  • is_delete — int — NOT NULL

admin

  • admin_id — int — Primary key — NOT NULL
  • user_id — varchar(100) — NOT NULL
  • user_pwd — varchar(64) — NOT NULL
  • level — int — NOT NULL
  • token — varchar(300)
  • is_delete — int — NOT NULL

ai_anomaly

  • anomaly_id — int — Primary key — NOT NULL
  • model_id — int — Foreign key → ai_model.model_id — NOT NULL — Model Training 누르면 생성
  • job_id — int — Foreign key → ai_job.job_id — NOT NULL
  • jobtag_id — int — Foreign key → ai_jobtag.jobtag_id — NOT NULL — basket 의 경우 -1로 통일
  • job_id (job_id2) — int — Foreign key → ai_jobtag.job_id — NOT NULL
  • job_id (job_id22) — int — Foreign key → ai_model.job_id — NOT NULL
  • anomaly_from — datetime — NOT NULL — anomaly 검출 데이터의 첫 anomaly 검사기간의 end timestamp
  • anomaly_to — datetime — NOT NULL — anomaly 검출 데이터의 마지막 anomaly 검사기간의 end timestamp
  • peak_score — float — NOT NULL
  • peak_date — datetime — NOT NULL
  • member_id — varchar(100) — NOT NULL

ai_job

  • job_id — int — Primary key — NOT NULL
  • board_id — varchar(30) — Foreign key → dashboard.board_id — NOT NULL
  • board_name — varchar(255) — NOT NULL — dashboard_name 찾아와서 넣기
  • job_name — varchar(255) — NOT NULL — job 생성시에 받아오는 이름
  • last_modified_date — datetime — NOT NULL — create시 createtime, 매 수정마다 업데이트
  • last_train_date — datetime — NOT NULL
  • last_predicted_date — datetime — NOT NULL
  • status — int — NOT NULL — status -1 ~ 5 문서 참고
  • update_period — int — NOT NULL — mvp에서 사용X
  • start_from — datetime — NOT NULL — 여러 Tag 중 수집 시작시간이 가장 느린 tag의 timestamp
  • predict_interval — int — NOT NULL
  • member_id — varchar(100) — NOT NULL
  • time_window_size — int — NOT NULL — 추천해주고, 입력받음
  • data_summary_duration — int — NOT NULL — 추천해주고, 입력받음
  • basket_epsilon — double — NOT NULL
  • lake_id — varchar(20) — NOT NULL
  • lake_key — varchar(255) — NOT NULL
  • messenger_id — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • create_time — datetime — NOT NULL
  • start_time — datetime — NOT NULL
  • destroy_time — datetime — NOT NULL

ai_jobtag

  • jobtag_id — int — Primary key — NOT NULL
  • job_id (job_id2) — int — Foreign key → ai_job.job_id — NOT NULL
  • tag_name — varchar(255) — NOT NULL — machlake 의 tag_name, unique 함을 가정
  • job_id — int — NOT NULL
  • is_in_basket — tinyint(1) — NOT NULL — basket 에 포함시킬지 여부. 입력받아야 함
  • is_detect_anomaly — tinyint(1) — NOT NULL — single tag detection 에 포함시킬지 여부. 입력받아야 함
  • data_per_hours — int — NOT NULL — mvp 사용 X
  • epsilon — double — NOT NULL — std 계산해서 줘야함
  • average — double — NOT NULL
  • std — double — NOT NULL
  • stdcnt — int — NOT NULL

ai_model

  • model_id — int — Primary key — NOT NULL — Model Training 누르면 생성
  • job_id (job_id2) — int — Foreign key → ai_jobtag.job_id — NOT NULL
  • modelmeta_id — int — NOT NULL — 사용X
  • job_id — int — NOT NULL
  • jobtag_id — int — NOT NULL — 사용X
  • model_definition — text — config
  • model_category — int — NOT NULL — 사용X, 모델별 preprocessing parameter 등을 분리하기 위해
  • sequence_length — int — NOT NULL — 사용X
  • create_date — datetime — NOT NULL — Model Record 의 생성시간
  • version — int — NOT NULL

alarm

  • alarm_id — varchar(30) — Primary key — NOT NULL — {company_id}-a-*
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • min — float — NOT NULL
  • max — float — NOT NULL
  • alarm_name — varchar(100) — NOT NULL
  • tag_name — varchar(100) — NOT NULL
  • risk — int — NOT NULL
  • remark — text — NOT NULL — 알람 설명
  • notice_interval — int — NOT NULL — minute, 메신저 발신주기
  • alarm_type — varchar(30) — NOT NULL — range | ?
  • is_delete — varchar(1) — NOT NULL
  • last_modified — datetime — NOT NULL
  • modified_member — varchar(100) — NOT NULL

alarm_action

  • alarm_id — varchar(30) — Foreign key → alarm.alarm_id — NOT NULL
  • action_id — int — Foreign key → action.action_id — NOT NULL
  • msg_id — varchar(30) — Foreign key → messenger.msg_id
  • action_type — varchar(2) — NOT NULL

alarm_history

  • alarm_history_id — varchar(40) — Primary key — NOT NULL — {company_id}-a-*-{time}
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • alarm_id — varchar(30) — NOT NULL — {company_id}-a-*
  • alarm_value — float — NOT NULL — 발생 값
  • alarm_time — datetime — NOT NULL — 발생 시간
  • min — float — NOT NULL
  • max — float — NOT NULL
  • alarm_check — varchar(1) — NOT NULL
  • alarm_done — varchar(1) — NOT NULL
  • tag_id — varchar(30) — NOT NULL
  • alarm_type — varchar(10) — NOT NULL
  • ai_link — varchar(100) — NOT NULL — http://***/***
  • ai_reffer — varchar(100) — NOT NULL — ai time range
  • comment — text — NOT NULL — 발생한 알람 처리 현황

bill_additive

  • additive_id — int — Primary key — NOT NULL
  • vendor_id — int
  • company_id — int
  • when_date — datetime — 청구서 작성 일시
  • create_date — datetime — 내역 적용 일시 (해당월) ex:2022-05-01
  • summary — json — 청구 데이터 항목 스트링

bill_payment

  • history_id — int — Primary key — NOT NULL
  • vendor_id — int
  • company_id — int
  • when_date — datetime — 결재 내역 적용 일시 (ex: 2022-05-01)
  • create_date — datetime — 결재 시도 일시
  • total — decimal(20, 2) — 결재 금액
  • result — VARCHAR(128) — success | failure
  • detail — json — 결과에 대한 세부 결과를 기록

bill_price

  • price_id — int — Primary key — NOT NULL
  • type — int — NOT NULL — 0 : 종량제, 1: 정액제
  • vendor_id — int — 0 인 경우 모든 사업자의 default 가격
  • company_id — int — 0 인 경우 모든 사업자의 default 가격
  • description — VARCHAR(1024)
  • create_date — datetime — 가장 마지막의 가격 정보를 유지
  • price — json — JSON 형태로 모든 item에 대한 정보를 기록한다.
  • payback — float — payback을 위한 %를 기록 (0~0.99)

bill_statement

  • statement_id — int — Primary key — NOT NULL
  • platform_id — int — Primary key — vendor_id가 0일 경우에는 해당 플랫폼의 전체 청구 금액
  • vendor_id — int — 이 값이 있고, company_id가 0일 경우에는 해당 vendor의 전체 청구 금액
  • company_id — int — 이 값이 0인 경우는 platform 혹은 vendor의 전체 청구 금액을 저장할 때
  • billing_key — varchar(1024) — 결재를 위해 부여된 사용자 결재 키
  • price_id — int
  • when_date — datetime — 청구서 대상 연월 (ex: 2022-04)
  • create_date — datetime — 청구서 작성 일시 (실제 청구 월은 아니고, 데이터 관리 목적임) ex: 2022-05-11 11:22:33
  • total — decimal(60, 0) — 청구 금액
  • summary — json
  • detail — json — 계산에 사용된 장비 등 세부 사항에 대해 모두 기록함
  • modify — int — NOT NULL

category

  • category_name — VARCHAR(255) — NOT NULL
  • info — VARCHAR(255)

client

  • client_id — varchar(30) — Primary key — NOT NULL — {company_id}-c-*
  • client_ip — varchar(100) — NOT NULL
  • client_port — varchar(5) — NOT NULL — 0 - 65535
  • client_name — varchar(100) — NOT NULL
  • sysinfo_time — int — NOT NULL
  • timer_interval — int — NOT NULL
  • keep_data — int — NOT NULL
  • delete_interval — int — NOT NULL
  • use_origin_tag — varchar(1) — NOT NULL
  • use_base_time — varchar(1) — NOT NULL
  • max_taglet_idx — int — NOT NULL — taglet 등록 시 자동으로 1 증가..?
  • machlake_key — varchar(255) — NOT NULL — encode base64...(x-api-key)
  • machlake_id — varchar(20) — NOT NULL — lake id
  • tag_prefix — varchar(30) — NOT NULL — default : "{equip_name}_"
  • company_id — int — NOT NULL
  • equipment_id — int — NOT NULL — 테스트 후 삭제 예정(2022-07-29)

company

  • company_id — int — Primary key — NOT NULL
  • vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
  • logo_image_id — int — Foreign key → logo_image.logo_image_id — NOT NULL
  • copyright_id — int — Foreign key → copyright.copyright_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • email — varchar(100) — NOT NULL
  • phone — varchar(11) — NOT NULL
  • admin_id — varchar(100) — NOT NULL
  • installer_id — varchar(100) — NOT NULL
  • timezone_key — varchar(50) — NOT NULL
  • timezone_value — varchar(10) — NOT NULL
  • address — varchar(255) — NOT NULL
  • is_delete — int — NOT NULL
  • machlake_key — varchar(255) — NOT NULL — x-api-key
  • machlake_id — varchar(20) — NOT NULL — Machlake Lake ID
  • machlake_status — int — NOT NULL — 0: init, 1: wait, 2: creating, 3: running, -98: deleted, -99:error
  • lake_id — varchar(255) — NOT NULL — Machlake Owner ID
  • company_desc — varchar(255) — NOT NULL — company 정보, 예시는 리탈정리 -> 화면구성 -> 1.group 요약 페이지 -> 우측 하단 참고
  • company_config — varchar(1000) — NOT NULL — JSON
  • custom_home — varchar(100) — NOT NULL — 기본값은 공백으로 준다.
  • storage_period — int — NOT NULL — 저장기간(년)
  • payment_id — varchar(100) — NOT NULL — payple로 부터 받아오는 payment_id
  • create_date — datetime — 해당 company가 생성된 시간
  • machlake_use_date — datetime — 사용자가 machlake 사용 시작 시간

company_max_idx

  • company_id — int — Foreign key → company.company_id — NOT NULL
  • max_client_idx — int — NOT NULL
  • max_alarm_idx — int — NOT NULL
  • max_alarm_history_idx — int — NOT NULL
  • max_mail_group_idx — int — NOT NULL
  • max_msg_idx — int — NOT NULL
  • max_action_idx — int — NOT NULL
  • max_report_idx — int — NOT NULL
  • max_img_idx — int — NOT NULL
  • max_board_idx — int — NOT NULL
  • max_group_idx — int — NOT NULL

company_setting

  • company_id — int — Foreign key → company.company_id — NOT NULL
  • key — varchar(30) — NOT NULL
  • value — varchar(200) — NOT NULL
  • type — varchar(10) — NOT NULL
  • cost — VARCHAR(255)
  • emission_coefficient — VARCHAR(255)

copyright

  • copyright_id — int — Primary key — NOT NULL
  • vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
  • name — varchar(100)
  • content — varchar(300)
  • style — text
  • is_delete — int — NOT NULL

dashboard

  • board_id — varchar(30) — Primary key — NOT NULL
  • member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • board_name — varchar(100) — NOT NULL
  • panels — text — NOT NULL
  • range_bgn — varchar(30) — NOT NULL
  • range_end — varchar(30) — NOT NULL
  • refresh — varchar(30) — NOT NULL

equip_to_edge

  • equipment_id — int — Foreign key → equipment.equipment_id — NOT NULL
  • client_id — varchar(30) — Foreign key → client.client_id — NOT NULL
  • preset_id — int — Foreign key → equipment.preset_id — NOT NULL
  • software_id — int — Foreign key → equipment.software_id — NOT NULL
  • patch_id — int — Foreign key → equipment.patch_id — NOT NULL

equipment

  • equipment_id — int — Primary key — NOT NULL
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • vendor_id — int — Foreign key → company.vendor_id — NOT NULL
  • preset_id — int — Foreign key → preset.preset_id
  • software_id — int — Foreign key → software.software_id
  • patch_id — int — Foreign key → patch.patch_id
  • name — varchar(100) — NOT NULL
  • serial — varchar(100) — NOT NULL
  • ip — varchar(100)
  • status — int — NOT NULL
  • create_date — datetime — NOT NULL
  • update_date — datetime
  • is_assign — int — NOT NULL
  • is_delete — int — NOT NULL
  • is_grouped — int — NOT NULL
  • equipment_config — varchar(1000) — NOT NULL — JSON, 점검 주기 저장
  • equipment_desc — varchar(1000) — NOT NULL — JSON, 장치 정보를 저장
  • equipment_prefix — varchar(1000) — NOT NULL

equipment_log

  • equipment_log_id — int — Primary key — NOT NULL
  • equipment_id — int — Foreign key → equipment.equipment_id — NOT NULL
  • company_id — int — Foreign key → equipment.company_id — NOT NULL
  • vendor_id — int — Foreign key → equipment.vendor_id — NOT NULL
  • preset_id — int — Foreign key → equipment.preset_id — NOT NULL
  • software_id — int — Foreign key → equipment.software_id — NOT NULL
  • patch_id — int — Foreign key → equipment.patch_id — NOT NULL
  • create_date — datetime — NOT NULL
  • type — varchar(30) — NOT NULL
  • title — varchar(40) — NOT NULL
  • description — varchar(150) — NOT NULL
  • log — longblob — NOT NULL
  • is_delete — int — NOT NULL

group_info

  • group_id — varchar(30) — Primary key — NOT NULL
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • group_tree — text — NOT NULL

image

  • image_id — varchar(30) — Primary key — NOT NULL
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • image_blob — longblob — NOT NULL

installer

  • installer_id — int — Primary key — NOT NULL
  • major — int — NOT NULL
  • minor — int — NOT NULL
  • hotfix — int — NOT NULL
  • create_date — datetime — NOT NULL
  • description — varchar(1000) — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL

logo_image

  • logo_image_id — int — Primary key — NOT NULL
  • vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • src — longblob — NOT NULL
  • is_delete — int — NOT NULL

mail_group

  • mail_group_id — varchar(30) — Primary key — NOT NULL — {company_id}-mg-*
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • addr_list — text — NOT NULL — ["[email protected]", "[email protected]", "[email protected]"]
  • mail_group_name — varchar(40) — NOT NULL

member

  • member_id — varchar(100) — Primary key — NOT NULL — ***@***.***[email-form]
  • permission_id — varchar(30) — Foreign key → permission.permission_id — NOT NULL
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • board_id — varchar(30) — NOT NULL — {company_id}-bd-*
  • home_group — varchar(30) — NOT NULL — {group_id}, 로그인 후 최초 노출 그룹 ""일 경우 Root(TOP)
  • home_page — varchar(30) — NOT NULL — board(board_id 사용) | monitoring | home | map
  • password — varchar(255) — NOT NULL — 저장 시 password(), select 시 password()를 통해 비교, 복호화x
  • timezone_key — varchar(50) — NOT NULL
  • timezone_value — varchar(10) — NOT NULL
  • home_board — varchar(30) — NOT NULL — 사용자가 지정한 main borad
  • query_timeout — int — NOT NULL — 지정한 기본 board refresh 시간(sec)
  • create_date — datetime — 과금 시 일정 검사

messenger

  • msg_id — varchar(30) — Primary key — NOT NULL — {company_id}-ms-*
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • mail_group_id — varchar(30) — NOT NULL — {company_id}-mg-*
  • msg_conf — text — NOT NULL — json marshal string
  • msg_type — varchar(10) — NOT NULL
  • msg_name — varchar(40) — NOT NULL
  • msg_content — text — NOT NULL
  • is_late_send — int — NOT NULL — 지연발송여부 0 | 1

patch

  • patch_id — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • description — varchar(1000) — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL
  • old_major — int — NOT NULL
  • old_minor — int — NOT NULL
  • old_hotfix — int — NOT NULL
  • current_major — int — NOT NULL
  • current_minor — int — NOT NULL
  • current_hotfix — int — NOT NULL
  • category_name — varchar(50) — NOT NULL

payment

  • payment_id — int — Primary key — NOT NULL
  • vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
  • amount — int — NOT NULL
  • method — int — NOT NULL
  • description — varchar(300) — NOT NULL
  • status — int — NOT NULL
  • create_date — datetime — NOT NULL
  • contract_date — datetime
  • is_delete — int — NOT NULL

permission

  • permission_id — varchar(30) — Primary key — NOT NULL — admin | user | installer
  • name — varchar(30) — NOT NULL
  • info — text — NOT NULL

preset

  • preset_id — int — Primary key — NOT NULL
  • software_id — int — Foreign key → software.software_id — NOT NULL
  • vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • description — varchar(1000) — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • create_date — datetime — NOT NULL
  • update_date — datetime
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL

receive_late_report

  • rs_id — int — Foreign key → receive_setting.rs_id — NOT NULL
  • alarm_history_id — varchar(30) — Foreign key → alarm_history.alarm_history_id — NOT NULL — {company_id}-a-*-{time}
  • send_time — datetime — NOT NULL — yyyy-mm-dd hh24:mi:ss, 발송시간

receive_setting

  • rs_id — int — Primary key — NOT NULL
  • msg_id — varchar(30) — Foreign key → messenger.msg_id — NOT NULL — {company_id}-ms-*
  • time_set — text — NOT NULL — json marshal string
  • rs_conf — text — NOT NULL — json marshal string

report

  • report_id — varchar(30) — Primary key — NOT NULL — {company_id}-rp-*
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • board_id — varchar(30) — Foreign key → dashboard.board_id — NOT NULL — {company_id}-bd-*
  • member_id — varchar(100) — Foreign key → member.member_id — NOT NULL — ***@***.***[email-form]
  • mail_group_id — varchar(30) — Foreign key → mail_group.mail_group_id — NOT NULL — {company_id}-mg-*
  • sched_type — varchar(10) — NOT NULL
  • sched_value — varchar(10) — NOT NULL — 0,4,5,6| week : 0 ~ 6 | month : 1 ~ 31, last
  • sched_time — varchar(10) — NOT NULL — hh:mi
  • report_type — varchar(20) — NOT NULL
  • data_from — varchar(50) — NOT NULL — {발송시점}-3d
  • data_to — varchar(50) — NOT NULL — {발송시점}
  • csv_tag_list — text — PA-01, PA-02, CS-80 ...
  • csv_interval — int — 10
  • csv_interval_unit — VARCHAR(10)
  • csv_aggr — varchar(10)
  • report_title — varchar(100) — NOT NULL — 제목
  • report_start — datetime — NOT NULL — yyyy-mm-dd hh:24:mi:ss
  • report_stop — datetime — NOT NULL — yyyy-mm-dd hh:24:mi:ss
  • report_content — text — NOT NULL — 본문
  • report_name — varchar(100) — NOT NULL — report 명

setting

  • key — varchar(30) — Primary key — NOT NULL
  • value — varchar(200) — NOT NULL
  • type — varchar(10) — NOT NULL

software

  • software_id — int — Primary key — NOT NULL
  • name — varchar(300) — NOT NULL
  • major — int — NOT NULL
  • minor — int — NOT NULL
  • hotfix — int — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • create_date — datetime — NOT NULL
  • update_date — datetime
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL
  • category_name — varchar(50) — NOT NULL

tag

  • tag_id — varchar(30) — Primary key — NOT NULL — {company_id}-c-*-*-*
  • taglet_id — varchar(30) — Foreign key → taglet.taglet_id — NOT NULL
  • equipment_id — int — Foreign key → equipment.equipment_id — NOT NULL
  • preset_id — int — Foreign key → equipment.preset_id — NOT NULL
  • software_id — int — Foreign key → equipment.software_id — NOT NULL
  • patch_id — int — Foreign key → equipment.patch_id — NOT NULL
  • tag_name — varchar(100) — NOT NULL
  • alias — varchar(100) — NOT NULL — default : {tag_name)
  • offset — float — NOT NULL — 0.0
  • scale — float — NOT NULL — 0 ~ 1.0
  • copy_data — varchar(1) — NOT NULL
  • save_data — varchar(1) — NOT NULL
  • effective_from — float — NOT NULL
  • effective_to — float — NOT NULL
  • effective_using — varchar(1) — NOT NULL
  • noinput_using — varchar(1) — NOT NULL

tag_name_maps

  • tag_id — varchar(30) — Foreign key → tag.tag_id — NOT NULL — {company_id}-c-*-*-*
  • alarm_id — varchar(30) — Foreign key → alarm.alarm_id — NOT NULL
  • preset_id — int — Foreign key → tag.preset_id — NOT NULL
  • software_id — int — Foreign key → tag.software_id — NOT NULL
  • patch_id — int — Foreign key → tag.patch_id — NOT NULL
  • max — float — NOT NULL
  • min — float — NOT NULL

taglet

  • taglet_id — varchar(30) — Primary key — NOT NULL
  • client_id — varchar(30) — Foreign key → client.client_id — NOT NULL
  • taglet_name — varchar(100) — NOT NULL
  • taglet_format — varchar(20) — NOT NULL
  • profile_id — varchar(50) — NOT NULL
  • max_tag_count — int — NOT NULL
  • taglet_config — text — NOT NULL
  • taglet_info — text — NOT NULL
  • byte_one — int — NOT NULL
  • byte_count — int — NOT NULL
  • byte_data_type — varchar — NOT NULL
  • byte_endian — varchar — NOT NULL
  • csv_skip_first — varchar — NOT NULL
  • csv_separator — varchar — NOT NULL
  • csv_time_column — int — NOT NULL
  • csv_header — varchar — NOT NULL
  • date_format — varchar — NOT NULL
  • max_tag_idx — int — NOT NULL

taglet_storage

  • profile_id — varchar(50) — Primary key — NOT NULL — taglet 실행파일 명
  • taglet_profile — longblob — NOT NULL — []byte
  • taglet_html — longblob — NOT NULL — []byte

vendor

  • vendor_id — int — Primary key — NOT NULL
  • admin_id — int — Foreign key → admin.admin_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • user_id — varchar(100) — NOT NULL
  • user_pwd — varchar(64) — NOT NULL
  • create_date — datetime — NOT NULL
  • phone — varchar(11) — NOT NULL
  • email — varchar(100) — NOT NULL
  • token — varchar(300)
  • status — int — NOT NULL
  • is_delete — int — NOT NULL
  • logo_image_id — int — NOT NULL
  • copyright_id — int — NOT NULL
  • timezone_key — varchar(50) — NOT NULL
  • timezone_value — varchar(10) — NOT NULL
  • custom_home — varchar(100) — NOT NULL — 기본값은 공백으로 준다.
  • abbr — varchar(10) — NOT NULL — abbreviation