Portfolio Instance User Table Schema (portfolio_instance_user)


Description

user data for portfolio instances.

portfolio_instance_user table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
instance bigint 10 null
portfolio_instance.id portinstuser_ins2_fk R

fk to instance table

userid bigint 10 null
user.id portinstuser_use2_fk R

fk to user table

name varchar 255

name of config item

value longtext 2147483647 null

value of config item

Table contained -1 rows

portfolio_instance_user table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
portinstuser_ins_ix Performance Asc instance
portinstuser_use_ix Performance Asc userid

portfolio_instance_user table relationships