users
The user table stores user-related information for a hotel or property management system.
| Field Name | Type | Other | Index |
|---|---|---|---|
| id | int(11) | NOT NULL AUTO_INCREMENT, | PK |
| usertype | varchar(20) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| username | varchar(100) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| varchar(100) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | ||
| password | varchar(150) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| first_name | varchar(100) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| last_name | varchar(100) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| phone_number | varchar(25) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| package_id | int(11) | NOT NULL, | |
| subscription_plan_id | int(11) | NOT NULL, | |
| features | mediumtext | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| subscription_amount | mediumtext | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| subscription_type | mediumtext | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| extraroomamount | mediumtext | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| extraroomcount | mediumtext | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| primary_language | int(11) | NOT NULL, | |
| secondary_language | varchar(100) | NOT NULL, | |
| status | enum('active','inactive') | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | Ya |
| date | date NOT NULL | ||
| api_key | varchar(64) | NOT NULL, | |
| main_userid | bigint(20) | NOT NULL, | Ya |
| app_user | varchar(100) | NOT NULL, | |
| payment_cycle | enum('monthly','yearly') | NOT NULL, | |
| payment_amount | varchar(20) | NOT NULL, | |
| hotelku | int(11) | NOT NULL, | |
| channelku | int(11) | NOT NULL, | |
| lock_drag | varchar(3) | NOT NULL, | |
| pos | int(11) | NOT NULL, | |
| access | varchar(10) | NOT NULL, | |
| loyalty_id | varchar(100) | NOT NULL, | |
| show_hotelku | int(11) | NOT NULL, | |
| min_rows | int(11) | NOT NULL, | |
| dynamic_pricing | int(11) | NOT NULL, | |
| rate_Shopper | int(11) | NOT NULL, | |
| the_jurnal | int(11) | NOT NULL, | |
| hotelku_properties | varchar(1000) | NOT NULL, | |
| reset | int(11) | NOT NULL, | |
| minth | varchar(18) | NOT NULL, | |
| alpha | varchar(100) | NOT NULL, | |
| minth_temp | varchar(35) | NOT NULL, | |
| gui | int(11) | NOT NULL, | |
| show_bookingku | int(11) | NOT NULL, | |
| bookingku | int(11) | NOT NULL, | |
| show_crm | int(11) | NOT NULL, | |
| show_dynamic | int(11) | NOT NULL, | |
| application | int(11) | NOT NULL, | |
| dashboard | varchar(40) | DEFAULT NULL, | |
| main_userid2 | bigint(20) | NOT NULL, | Ya |
| menu | int(11) | NOT NULL, | |
| server | int(11) | NOT NULL, | |
| server_userid | int(11) | NOT NULL, | |
| privacy | tinyint(4) | DEFAULT '0', | |
| max_export_property | int(11) | DEFAULT '10', | |
| sso | tinyint(4) | DEFAULT '0', | |
| admin | int(11) | DEFAULT '0', | |
| reseller | int(11) | DEFAULT '0', | |
| migration_token | longtext | ||
| created_at | timestamp | NULL DEFAULT CURRENT_TIMESTAMP, | |
| updated_at | timestamp | NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
Below is a breakdown of each field:
Basic Identifiers
id: Unique identifier for each user.usertype: Type of user (e.g., admin, hotel owner, guest, reseller).username: Unique username for login.email: Email address of the user.password: Encrypted password for authentication.
Personal Information
first_name: User’s first name.last_name: User’s last name.phone_number: Contact number of the user.primary_language: Preferred language for communication.secondary_language: Secondary language option.
Subscription & Billing
package_id: The package or plan the user has subscribed to.subscription_plan_id: ID of the subscription plan.subscription_amount: Cost of the subscription.subscription_type: Type of subscription (e.g., monthly, yearly).payment_cycle: Frequency of payments.payment_amount: Amount due per cycle.extraroomamount: Additional charge for extra rooms.extraroomcount: Number of extra rooms added.loyalty_id: Associated loyalty program ID.
Account & Access Control
status: Account status (e.g., active, suspended).api_key: API key for external integrations.main_userid: If the user is part of an organization, this links to the main user.main_userid2: Another reference to a primary account.app_user: Indicates if the user accesses the system via a mobile app.access: Defines what features the user can access.admin: Whether the user has admin privileges.reseller: Indicates if the user is a reseller.sso: Whether the user has Single Sign-On (SSO) enabled.reset: Whether the user requires a password reset.
Features & System Settings
features: List of enabled features.hotelku: Access to hotel-related functionalities.channelku: Access to channel management.pos: Whether the user can access the POS (Point of Sale) system.lock_drag: Determines if drag-and-drop features are locked.rate_Shopper: Access to rate shopping features.dynamic_pricing: Whether dynamic pricing is enabled.the_jurnal: Indicates if the user has access to an accounting system.hotelku_properties: Number of properties managed by the user.min_rows: Minimum number of rows displayed in tables.minth: Internal field (possibly related to month settings).minth_temp: Temporary field related tominth.alpha: Internal feature flag.gui: User interface settings.server: Server-related settings.server_userid: ID of the server user.
Dashboard & UI Preferences
dashboard: Defines the user's dashboard settings.menu: Custom menu settings for the user.show_bookingku: Whether the user sees booking-related features.bookingku: Whether booking functionality is enabled.show_crm: Whether CRM features are visible.show_dynamic: Whether dynamic features are displayed.
Migration & Data Management
migration_token: Token used for data migration.max_export_property: Maximum number of properties the user can export.
Privacy & Security
privacy: Privacy settings for the user.
Timestamps
date: Account creation or last update date.created_at: Timestamp when the user was created.updated_at: Timestamp of the last update.