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)