Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||||||||
| code | text | 2147483647 | null |
|
|
||||||||||||
| name | text | 2147483647 | null |
|
|
||||||||||||
| enabled | bool | 1 | true |
|
|
||||||||||||
| require_property | bool | 1 | true |
|
|
||||||||||||
| anchor_prop_id | int4 | 10 | √ | null |
|
|
|||||||||||
| access_from | text | 2147483647 | √ | null |
|
|
ถ้าตั้งค่า: ใช้สิทธิ์ user_app_access/property_app ของ app code นี้แทน (inherit ไม่ต้อง seed ซ้ำ); NULL = ใช้ของตัวเอง |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| apps_pkey | Primary key | Asc | id |
| apps_code_key | Must be unique | Asc | code |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| chk_apps_code_lower | (code = lower(code)) |
Relationships
Close relationships within degrees of separation
