property

22 rows


Description

Hotel / Property information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('property_id_seq'::regclass)
service_access_token.prop_id service_access_token_prop_id_fkey C
service_grant_property.prop_id service_grant_property_prop_id_fkey C
user_session.prop_id fk_user_session_property C
templates.prop_id fk_templates_prop_id C
apps.anchor_prop_id fk_apps_anchor_prop_id N
batch_report.prop_id fk_batch_report_prop_id C
configs.prop_id fk_configs_prop_id C
dashboard.prop_id fk_dashboard_prop_id C
group_permission_override.prop_id fk_group_permission_override_prop_id C
print_form.prop_id fk_print_form_prop_id C
property_app.prop_id fk_property_app_prop_id C
property_reports.prop_id property_reports_prop_id_fk C
service_token.prop_id fk_service_token_prop_id C
user_app_access.prop_id fk_user_app_access_prop_id C
user_group.prop_id fk_user_group_prop_id C
user_permission.prop_id fk_user_permission_prop_id C
user_permission_override.prop_id fk_user_permission_override_prop_id C
user_property.prop_id fk_user_property_prop_id C
user_roles.prop_id fk_user_roles_prop_id C
work_log.prop_id fk_work_log_prop_id C
configs.prop_id fk_sys_configs_prop_id C
property_job_queue.prop_id property_job_queue_prop_id_fkey C
s3_maintenance_queue.prop_id s3_maintenance_queue_prop_id_fkey C

Auto-generate
code citext 2147483647 null

Property code
name citext 2147483647 null

Property name
bytea 2147483647 √ null

Property logo image
enabled bool 1 √ true
prop_group_id int4 10 √ null
property_group.id fk_property_group_id N

Property Group Id
register_time timestamp 29,6 now()
service_url text 2147483647 √ null

Fromas service url
db_name text 2147483647 √ null

Fromas database path
db_host text 2147483647 √ null
db_port int4 10 √ null
logo_image_type text 2147483647 √ null
address1 text 2147483647 √ null
address2 text 2147483647 √ null
address3 text 2147483647 √ null
address4 text 2147483647 √ null
email text 2147483647 √ null
telephone text 2147483647 √ null
fax text 2147483647 √ null
website text 2147483647 √ null
company text 2147483647 √ null
branch_no text 2147483647 √ null
tax_id text 2147483647 √ null
sync_booking bool 1 √ null
sync_rate bool 1 √ null
sync_restriction bool 1 √ null
sync_avail bool 1 √ null
prop_key text 2147483647 √ null
expire_date date 13 √ null
max_room int4 10 √ null
prop_type text 2147483647 'live'::text
logo_url text 2147483647 √ null

Best-effort read model for displaying the property logo during Authen V2 selection.

Indexes

Constraint Name Type Sort Column(s)
property_pkey Primary key Asc id
unq_property_code Must be unique Asc code

Check Constraints

Constraint Name Constraint
property_prop_type_check (prop_type = ANY (ARRAY['live'::text, 'demo'::text, 'training'::text, 'sample'::text, 'blank'::text, 'test'::text]))

Relationships

Close relationships within degrees of separation