📊 Showing 13 table(s)
View Mode:
| wpl6_easy_admins |
| Table Fields: |
| 1 | id | bigint(20) (NO) - PRI |
| 2 | user_id | bigint(20) (NO) - MUL |
| 3 | restaurant_uuid | varchar(36) (YES) - MUL |
| 4 | role | enum('super_admin','restaurant_admin') (YES) - Default: restaurant_admin |
| 5 | permissions | longtext (YES) |
| 6 | created_at | datetime (YES) - Default: current_timestamp() |
| 1 | id |
| 2 | user_id |
| 3 | restaurant_uuid |
| 4 | role |
| 5 | permissions |
| 6 | created_at |
| wpl6_easy_ayala |
| Table Fields: |
| 1 | id | bigint(20) unsigned (NO) - PRI |
| 2 | customer_name | varchar(255) (NO) |
| 3 | contact_name | varchar(255) (NO) |
| 4 | subject | varchar(255) (NO) |
| 5 | created_at | timestamp (NO) - Default: current_timestamp() |
| 6 | updated_at | timestamp (NO) - Default: current_timestamp() |
| 7 | period_key | char(7) (YES) - MUL |
| 8 | total_vat_incl | decimal(15,2) (NO) |
| 1 | id |
| 2 | customer_name |
| 3 | contact_name |
| 4 | subject |
| 5 | created_at |
| 6 | updated_at |
| 7 | period_key |
| 8 | total_vat_incl |
| wpl6_easy_css |
| Table Fields: |
| 1 | id | int(10) unsigned (NO) - PRI |
| 2 | css_name | varchar(191) (NO) - MUL |
| 3 | short_code | varchar(80) (YES) - MUL - Default: |
| 4 | lang | varchar(10) (NO) - Default: |
| 5 | scope | enum('core','admin','user','custom') (NO) - Default: custom |
| 6 | is_active | tinyint(1) (NO) - Default: 1 |
| 7 | version | varchar(32) (NO) - Default: 1.0.0 |
| 8 | css_content | longtext (NO) |
| 9 | author_user_id | bigint(20) unsigned (YES) |
| 10 | notes | text (YES) |
| 11 | created_at | timestamp (NO) - Default: current_timestamp() |
| 12 | updated_at | timestamp (NO) - Default: current_timestamp() |
| 1 | id |
| 2 | css_name |
| 3 | short_code |
| 4 | lang |
| 5 | scope |
| 6 | is_active |
| 7 | version |
| 8 | css_content |
| 9 | author_user_id |
| 10 | notes |
| 11 | created_at |
| 12 | updated_at |
| wpl6_easy_currency |
| Table Fields: |
| 1 | base_curr | varchar(3) (NO) - PRI |
| 2 | target_curr | varchar(3) (NO) - PRI |
| 3 | country_name | varchar(64) (YES) |
| 4 | flag_emoji | varchar(10) (YES) |
| 5 | rate | decimal(10,6) (NO) |
| 6 | date | datetime (YES) |
| 7 | currency_desc | varchar(64) (YES) |
| 1 | base_curr |
| 2 | target_curr |
| 3 | country_name |
| 4 | flag_emoji |
| 5 | rate |
| 6 | date |
| 7 | currency_desc |
| wpl6_easy_customers |
| Table Fields: |
| 1 | customer_id | bigint(20) unsigned (NO) - PRI |
| 2 | uuid_stamp | varchar(255) (NO) - UNI |
| 3 | first_name | varchar(50) (YES) - MUL |
| 4 | last_name | varchar(50) (YES) |
| 5 | email | varchar(100) (YES) |
| 6 | phone | varchar(20) (YES) - MUL |
| 7 | address | varchar(255) (YES) |
| 8 | city | varchar(100) (YES) |
| 9 | country | varchar(100) (YES) |
| 10 | currency | varchar(10) (YES) |
| 11 | language | varchar(10) (YES) |
| 12 | created_at | datetime (NO) - MUL - Default: current_timestamp() |
| 13 | date_last_update | datetime (YES) |
| 14 | cust_type | varchar(50) (YES) - MUL - Default: cust_billto |
| 15 | zip_code | varchar(20) (YES) |
| 1 | customer_id |
| 2 | uuid_stamp |
| 3 | first_name |
| 4 | last_name |
| 5 | email |
| 6 | phone |
| 7 | address |
| 8 | city |
| 9 | country |
| 10 | currency |
| 11 | language |
| 12 | created_at |
| 13 | date_last_update |
| 14 | cust_type |
| 15 | zip_code |
| wpl6_easy_eb_range_calculations |
| Table Fields: |
| 1 | id | bigint(20) (NO) - PRI |
| 2 | mobile | varchar(20) (YES) |
| 3 | voltage | int(11) (NO) |
| 4 | capacity | int(11) (NO) |
| 5 | weight | int(11) (NO) |
| 6 | speed | int(11) (NO) |
| 7 | pedal_assist | int(11) (NO) |
| 8 | efficiency | int(11) (NO) |
| 9 | calculated_range | int(11) (NO) |
| 10 | comment | text (YES) |
| 11 | calculation_date | datetime (YES) |
| 12 | share_token | varchar(32) (YES) - UNI |
| 13 | user_email | varchar(100) (YES) |
| 14 | access_code | varchar(6) (YES) |
| 15 | terrain | varchar(20) (NO) - Default: flat |
| 16 | created_by | varchar(20) (YES) - Default: user |
| 1 | id |
| 2 | mobile |
| 3 | voltage |
| 4 | capacity |
| 5 | weight |
| 6 | speed |
| 7 | pedal_assist |
| 8 | efficiency |
| 9 | calculated_range |
| 10 | comment |
| 11 | calculation_date |
| 12 | share_token |
| 13 | user_email |
| 14 | access_code |
| 15 | terrain |
| 16 | created_by |
| wpl6_easy_languages |
| Table Fields: |
| 1 | language_code | varchar(10) (NO) - PRI |
| 2 | language_name | varchar(50) (YES) |
| 3 | native_name | varchar(50) (YES) |
| 4 | country | varchar(50) (YES) |
| 5 | direction | enum('ltr','rtl') (YES) |
| 6 | is_active | tinyint(1) (YES) - Default: 1 |
| 7 | flag_emoji | varchar(10) (YES) |
| 8 | currency_code | varchar(3) (YES) |
| 1 | language_code |
| 2 | language_name |
| 3 | native_name |
| 4 | country |
| 5 | direction |
| 6 | is_active |
| 7 | flag_emoji |
| 8 | currency_code |
| wpl6_easy_permissions |
| Table Fields: |
| 1 | id | bigint(20) (NO) - PRI |
| 2 | role | varchar(50) (NO) - MUL |
| 3 | capability | varchar(100) (NO) - MUL |
| 4 | granted | tinyint(1) (YES) - Default: 1 |
| 5 | description | text (YES) |
| 6 | created_at | datetime (YES) - Default: current_timestamp() |
| 1 | id |
| 2 | role |
| 3 | capability |
| 4 | granted |
| 5 | description |
| 6 | created_at |
| wpl6_easy_restaurants |
| Table Fields: |
| 1 | id | bigint(20) (NO) - PRI |
| 2 | restaurant_uuid | varchar(36) (NO) - UNI |
| 3 | name | varchar(255) (NO) |
| 4 | domain | varchar(255) (YES) - MUL |
| 5 | subdomain | varchar(100) (YES) - MUL |
| 6 | country_code | varchar(2) (YES) - Default: US |
| 7 | language_default | varchar(2) (YES) - Default: EN |
| 8 | currency_default | varchar(3) (YES) - Default: USD |
| 9 | timezone | varchar(50) (YES) - Default: UTC |
| 10 | config | longtext (YES) |
| 11 | is_active | tinyint(1) (YES) - MUL - Default: 1 |
| 12 | created_at | datetime (YES) - Default: current_timestamp() |
| 13 | updated_at | datetime (YES) - Default: current_timestamp() |
| 14 | try_for_free | enum('yes','no') (YES) - Default: no |
| 15 | try_date_start | date (YES) |
| 16 | try_date_end | date (YES) |
| 17 | payment_ok | enum('yes','no') (YES) - Default: no |
| 18 | monthly_payment | decimal(10,2) (YES) - Default: 0.00 |
| 19 | payment_status | enum('active','pending','overdue','cancelled') (YES) - Default: pending |
| 20 | last_payment_date | date (YES) |
| 21 | next_payment_date | date (YES) |
| 22 | admin_user_id | bigint(20) (YES) |
| 23 | created_by | bigint(20) (YES) |
| 24 | status | enum('active','inactive','pending') (YES) - Default: active |
| 1 | id |
| 2 | restaurant_uuid |
| 3 | name |
| 4 | domain |
| 5 | subdomain |
| 6 | country_code |
| 7 | language_default |
| 8 | currency_default |
| 9 | timezone |
| 10 | config |
| 11 | is_active |
| 12 | created_at |
| 13 | updated_at |
| 14 | try_for_free |
| 15 | try_date_start |
| 16 | try_date_end |
| 17 | payment_ok |
| 18 | monthly_payment |
| 19 | payment_status |
| 20 | last_payment_date |
| 21 | next_payment_date |
| 22 | admin_user_id |
| 23 | created_by |
| 24 | status |
| wpl6_easy_sales_order |
| Table Fields: |
| 1 | order_no | bigint(20) unsigned (NO) - PRI |
| 2 | cust_id | bigint(20) unsigned (NO) - MUL |
| 3 | cust_shipto_id | bigint(20) unsigned (YES) - MUL |
| 4 | order_reopen | tinyint(1) (YES) |
| 5 | order_status | varchar(32) (YES) - MUL - Default: open-order |
| 6 | order_date_created | datetime (NO) - Default: current_timestamp() |
| 7 | order_date_updated | datetime (NO) - Default: current_timestamp() |
| 8 | date_2 | date (YES) |
| 9 | date_3 | date (YES) |
| 10 | resevation_table | tinyint(1) (YES) - Default: 0 |
| 11 | resevation_table_date | datetime (YES) |
| 12 | comment_1 | text (YES) |
| 13 | comment_2 | text (YES) |
| 14 | order_curr | varchar(10) (YES) |
| 15 | order_lang | varchar(10) (YES) |
| 16 | date_to_finish | datetime (YES) |
| 17 | order_type | varchar(32) (YES) |
| 1 | order_no |
| 2 | cust_id |
| 3 | cust_shipto_id |
| 4 | order_reopen |
| 5 | order_status |
| 6 | order_date_created |
| 7 | order_date_updated |
| 8 | date_2 |
| 9 | date_3 |
| 10 | resevation_table |
| 11 | resevation_table_date |
| 12 | comment_1 |
| 13 | comment_2 |
| 14 | order_curr |
| 15 | order_lang |
| 16 | date_to_finish |
| 17 | order_type |
| wpl6_easy_sales_order_det |
| Table Fields: |
| 1 | order_no | bigint(20) unsigned (NO) - PRI |
| 2 | order_line | int(10) unsigned (NO) - PRI |
| 3 | line_qty | decimal(12,3) (NO) - Default: 1.000 |
| 4 | post_id | bigint(20) unsigned (YES) - MUL |
| 5 | post_lang | varchar(10) (YES) |
| 6 | post_price | decimal(12,2) (YES) |
| 7 | date_a | datetime (NO) - Default: current_timestamp() |
| 8 | comment-1 | text (YES) |
| 9 | comment-2 | text (YES) |
| 10 | line_type | varchar(32) (YES) |
| 1 | order_no |
| 2 | order_line |
| 3 | line_qty |
| 4 | post_id |
| 5 | post_lang |
| 6 | post_price |
| 7 | date_a |
| 8 | comment-1 |
| 9 | comment-2 |
| 10 | line_type |
| wpl6_easy_system_key |
| Table Fields: |
| 1 | id | int(10) unsigned (NO) - PRI |
| 2 | subject | varchar(100) (NO) - MUL |
| 3 | key1 | varchar(100) (NO) |
| 4 | key2 | varchar(100) (NO) |
| 5 | value1 | text (YES) |
| 6 | value2 | text (YES) |
| 7 | last_update_date | datetime (NO) - Default: current_timestamp() |
| 1 | id |
| 2 | subject |
| 3 | key1 |
| 4 | key2 |
| 5 | value1 |
| 6 | value2 |
| 7 | last_update_date |
| wpl6_easy_user_profile_translations |
| Table Fields: |
| 1 | id | int(11) (NO) - PRI |
| 2 | text_key | varchar(100) (NO) - MUL |
| 3 | language_code | varchar(10) (NO) |
| 4 | translated_text | text (NO) |
| 5 | context | varchar(50) (YES) |
| 1 | id |
| 2 | text_key |
| 3 | language_code |
| 4 | translated_text |
| 5 | context |
