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 19 √ null
instance BIGINT 19 null
portfolio_instance.id portinstuser_ins2_fk R

fk to instance table
userid BIGINT 19 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

Close relationships within degrees of separation