All Tables Overview

A master index of every table in the database, grouped by schema — follow a link to see the full column-level detail on that domain's data dictionary page

The database has 90 tables in total, across 4 schemas:

• public — 63 tables (the system's main domains)
• appointment — 5 tables (an add-on app with its own schema, separate from public)
• bulletin — 8 tables (an add-on app with its own schema, separate from public)
• loyalty — 14 tables (an add-on app with its own schema, separate from public)

Schema public

Organization & Permissions

Table	Details
organization	Organizations & Plans
forgot_password	CMS Users & Authentication
password_history	CMS Users & Authentication
user	CMS Users & Authentication
organization_module	Roles & Module Permissions
system_module	Roles & Module Permissions
system_role	Roles & Module Permissions
system_role_module	Roles & Module Permissions

LINE OA & Friends

Table	Details
line_oa	LINE Official Account (Channel)
line_oa_app	LINE Official Account (Channel)
line_user	LINE Friends (LINE User)
import_mapping_job	Friend Import & Mapping
line_user_import	Friend Import & Mapping
line_user_import_detail	Friend Import & Mapping
customer_database	Uploaded Customer Database
customer_database_row	Uploaded Customer Database

Attributes & Audience

Table	Details
attribute_master	Attribute Definitions & System Variables
system_attribute	Attribute Definitions & System Variables
audience	Audience
audience_member_log	Audience

Campaign & Messaging

Table	Details
quick_reply	Message Library (Rich/Template/Quick Reply)
rich_message	Message Library (Rich/Template/Quick Reply)
template_message	Message Library (Rich/Template/Quick Reply)
campaign	Broadcast Campaigns
campaign_delivery_batch	Broadcast Campaigns
rich_menu	Rich Menu
rich_menu_action	Rich Menu
rich_menu_archive	Rich Menu
rich_menu_member	Rich Menu
auto_response	Auto-response

Tracking

Table	Details
tracking_line_users	Click Tracking
tracking_log	Click Tracking
tracking_token	Click Tracking
friend_track_campaign	Friend-source Tracking
friend_track_event	Friend-source Tracking
friend_track_ref	Friend-source Tracking

Forms & Menus

Table	Details
form_builder	Forms (Form Builder)
form_builder_rule	Forms (Form Builder)
form_submission	Forms (Form Builder)
otp_config	Forms (Form Builder)
menu_builder	Web Menus (Menu Builder)

Content

Table	Details
content_page	Content Pages
content_page_analytics	Content Pages
content_page_translation	Content Pages
content_page_utm	Content Pages
content_page_view	Content Pages
content_category	Content Categories & Link Collections
content_link	Content Categories & Link Collections
content_subcategory	Content Categories & Link Collections

Automation

Table	Details
workflow	Workflow Automation
workflow_version	Workflow Automation
scheduled_action	Trigger Rules & Scheduled Jobs
scheduled_trigger_execution	Trigger Rules & Scheduled Jobs
trigger_log	Trigger Rules & Scheduled Jobs
trigger_rule	Trigger Rules & Scheduled Jobs
event_outbox	pg_notify & Event Outbox

AI & Integration

Table	Details
ai_config	AI & Knowledge Base
knowledge_base	AI & Knowledge Base
knowledge_chunk	AI & Knowledge Base
knowledge_document	AI & Knowledge Base
bigquery_sync_config	BigQuery Sync
api_client	API Clients & API Keys
api_key	API Clients & API Keys

Schema appointment

Table	Details
appointment.booking	Appointment Booking
appointment.journey	Appointment Booking
appointment.location	Appointment Booking
appointment.service	Appointment Booking
appointment.staff	Appointment Booking

Schema bulletin

Table	Details
bulletin.audit_log	Bulletin Board (Forum)
bulletin.block	Bulletin Board (Forum)
bulletin.board	Bulletin Board (Forum)
bulletin.category	Bulletin Board (Forum)
bulletin.comment	Bulletin Board (Forum)
bulletin.post	Bulletin Board (Forum)
bulletin.reaction	Bulletin Board (Forum)
bulletin.report	Bulletin Board (Forum)

Schema loyalty

Table	Details
loyalty.account	Loyalty Cards & Membership
loyalty.audit_log	Loyalty Cards & Membership
loyalty.bonus_grant	Loyalty Cards & Membership
loyalty.bonus_rule	Loyalty Cards & Membership
loyalty.branch	Loyalty Cards & Membership
loyalty.card_instance	Loyalty Cards & Membership
loyalty.earn_token	Loyalty Cards & Membership
loyalty.milestone	Loyalty Cards & Membership
loyalty.program	Loyalty Cards & Membership
loyalty.reward	Loyalty Cards & Membership
loyalty.staff	Loyalty Cards & Membership
loyalty.transaction	Loyalty Cards & Membership
loyalty.tier	Loyalty Tiers
loyalty.tier_history	Loyalty Tiers