CEMS ADMIN
Tables (14)
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
- action_name — varchar(40)
- action_type — varchar(20)
- action_desc — text
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
- action_name — varchar(40)
- action_type — varchar(20)
- action_desc — text
- is_delete — int
admin
- admin_id — int — Primary key — NOT NULL
- user_id — varchar(100)
- user_pwd — varchar(64)
- level — int
- token — varchar(300)
- is_delete — int
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
- copy_write_id — int — Foreign key → copyright.copyright_id — NOT NULL
- name — varchar(100)
- email — varchar(100)
- phone — varchar(11)
- admin_id — varchar(100)
- installer_id — varchar(100)
- timezone_key — varchar(50)
- timezone_value — varchar(10)
- address — varchar(255)
- is_delete — int
copyright (copy_write)
- 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
equipment
- equipment_id — int — Primary key — NOT NULL
- software_id — int — Foreign key → software.software_id — NOT NULL
- preset_id — int — Foreign key → preset.preset_id — NOT NULL
- patch_id — int — Foreign key → patch.patch_id — NOT NULL
- company_id — int — Foreign key → company.company_id — NOT NULL
- vendor_id — int — Foreign key → company.vendor_id — NOT NULL
- name — varchar(100)
- serial — varchar(100)
- ip — varchar(15)
- status — int
- create_date — datetime
- update_date — datetime
- is_assign — int
- is_delete — int
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
- create_date — datetime
- type — varchar(30)
- title — varchar(40)
- description — varchar(150)
- log — longblob
- is_delete — int
installer
- installer_id — int — Primary key — NOT NULL
- major — int
- minor — int
- hotfix — int
- create_date — datetime
- description — varchar(1000)
- src_path — varchar(300)
- download_count — int
- is_delete — int
logo_image
- logo_image_id — int — Primary key — NOT NULL
- vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
- name — varchar(100)
- src — longblob
- is_delete — int
patch
- patch_id — int — Primary key — NOT NULL
- name — varchar(100)
- description — varchar(1000)
- src_path — varchar(300)
- download_count — int
- is_delete — int
payment
- payment_id — int — Primary key — NOT NULL
- vendor_id — int — Foreign key → vendor.vendor_id — NOT NULL
- amount — int
- method — int
- description — varchar(300)
- status — int
- create_date — datetime
- contract_date — datetime
- is_delete — int
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)
- description — varchar(1000)
- src_path — varchar(300)
- create_date — datetime
- update_date — datetime
- download_count — int
- is_delete — int
software
- software_id — int — Primary key — NOT NULL
- name — varchar(100)
- major — int
- minor — int
- hotfix — int
- src_path — varchar(300)
- create_date — datetime
- update_date — datetime
- download_count — int
- is_delete — int
vendor (vender)
- vendor_id — int — Primary key — NOT NULL
- admin_id — int — Foreign key → admin.admin_id — NOT NULL
- name — varchar(100)
- user_id — varchar(100)
- user_pwd — varchar(64)
- create_date — datetime
- phone — varchar(11)
- email — varchar(100)
- token — varchar(300)
- status — int
- is_delete — int
- logo_image_id (log_image_id) — int
- copyright_id — int
- timezone_key — varchar(50)
- timezone_value — varchar(10)