property_app

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
prop_id int4 10 null
property.id fk_property_app_prop_id C
app_code text 2147483647 null
apps.code fk_property_app_app_code R
enabled bool 1 true
expire_date date 13 √ null
plan_code text 2147483647 √ null
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
pk_property_app Primary key Asc/Asc prop_id + app_code

Check Constraints

Constraint Name Constraint
chk_property_app_app_lower (app_code = lower(app_code))

Relationships

Close relationships within degrees of separation