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)