DPP

Tables (9)

t_platform_provisioning_log

  • log_id — bigint
  • tenant_id — varchar(20) — NOT NULL
  • service_id — varchar(20) — NOT NULL
  • schema_ver_id — varchar(20)
  • status — varchar(20)
  • error_msg — text
  • start_dt — timestamp
  • end_dt — timestamp

t_platform_service_info

  • service_id — varchar(20) — Primary key — NOT NULL
  • service_name — varchar(50)
  • service_desc — text
  • reg_id — varchar(50)
  • reg_dt — timestamp
  • mod_id — varchar(50)
  • mod_dt — timestamp

t_platform_service_schema_registry

  • schema_ver_id — varchar(20) — Primary key — NOT NULL
  • service_id — varchar(20) — Foreign key → t_platform_service_info.service_id — NOT NULL
  • version_tag — varchar(10)
  • script_path — varchar(255)
  • is_critical — char(1)
  • reg_dt — timestamp

t_platform_subscription_info

  • subscription_id — varchar(20) — Primary key — NOT NULL
  • subscription_name — varchar(50)
  • subscription_cost — decimal(15,2)
  • subscription_cycle — varchar(20)
  • reg_dt — timestamp

t_platform_tenant_db_mapping_info

  • db_name — varchar(50) — Primary key — NOT NULL
  • tenant_id — varchar(20) — Foreign key → t_platform_tenant_info.tenant_id — NOT NULL
  • db_type — varchar(50)
  • db_addr — varchar(50)
  • db_port — varchar(20)
  • db_access_id — varchar(20)
  • db_access_password — varchar(255)
  • is_dedicated — char(1)
  • reg_dt — timestamp

t_platform_tenant_info

  • tenant_id — varchar(20) — Primary key — NOT NULL
  • tenant_name — varchar(50)
  • tenant_status — varchar(10)
  • api_key — varchar(100)
  • tenant_addr — varchar(100)
  • tenant_boss — varchar(50)
  • reg_dt — timestamp
  • mod_dt — timestamp

t_platform_tenant_subscription_history

  • history_id — bigint
  • tenant_id — varchar(20) — Foreign key → t_platform_tenant_info.tenant_id — NOT NULL
  • subscription_id — varchar(20) — Foreign key → t_platform_subscription_info.subscription_id — NOT NULL
  • start_dt — timestamp
  • end_dt — timestamp
  • status — varchar(10)

t_platform_user_info

  • user_id — varchar(20) — Primary key — NOT NULL
  • tenant_id — varchar(20) — Foreign key → t_platform_tenant_info.tenant_id — NOT NULL
  • user_name — varchar(50)
  • role_id — varchar(20) — Foreign key → t_platform_user_role.role_id — NOT NULL
  • status — varchar(10)

t_platform_user_role

  • role_id — varchar(20) — Primary key — NOT NULL
  • role_name — varchar(50)