1 Default Layout Read table & column comments as mouse-over tooltips. user_id shift_id terminal_id user_id terminal_id user_id cash_drawer_id currency_id dpr_id id customer_id customer_no a_user dpreport_id shift_id terminal_id user_id terminal_id ticket_id owner_id item_group_id item_location_id item_vendor_id punit_id recipe_unit_id warehouse_id item_id vendor_id to_warehouse_id from_warehouse_id reference_id menu_item_id order_type_id kit_ticket_id pg_id kithen_ticket_id category_id group_id pg_id recepie tax_id menu_item_id menu_item_id terminal_id group_id tax_id menu_modifier_id discount_id menucategory_id discount_id menugroup_id discount_id menuitem_id menuitem_modifiergroup_id modifier_group menu_item_id pizza_price_id menuitem_id shift_id menumodifier_id pizzamodifierprice_id menumodifier_id multiplier_id pizza_modifier_price_id item_size menu_item_size order_type crust printer_id menu_item inventory_item recepie_id floor_id id floor_id customer_id user_id table_id booking_id table_id type_id assigned_user terminal_id virtual_printer_id gratuity_id shift_id terminal_id void_by_user owner_id ticket_id pg_id ticket_id size_modifier_id ticket_item_id modifier_id ticket_item_id ticket_itemid ticket_item_id ticket_item_id modifier_id id ticket_id id payout_reason_id payout_recepient_id terminal_id ticket_id user_id elt permissionid shift_id currentterminal n_user_type printer_id terminal_id user_id action_history id # action_time d action_name t description t user_id attendence_history id # clock_in_time d clock_out_time d clock_in_hour # clock_out_hour # clocked_out b user_id shift_id terminal_id cash_drawer id terminal_id cash_drawer_reset_history id # reset_time d user_id cooking_instruction id # description t coupon_and_discount id name t type # barcode t qualification_type # apply_to_all b minimum_buy # maximum_off # value # expiry_date d enabled b auto_apply b modifiable b never_expire b uuid t currency id code t name t symbol t exchange_rate # tolerance # buy_price # sales_price # main b currency_balance id # balance # currency_id cash_drawer_id dpr_id custom_payment id # name t required_ref_number b ref_number_field_name t customer auto_id loyalty_no t loyalty_point # social_security_number t picture ~ homephone_no t mobile_no t workphone_no t email t salutation t first_name t last_name t name t dob t ssn t address t city t state t zip_code t country t vip b credit_limit # credit_spent # credit_card_no t note t customer_properties id property_name t property_value t data_update_info id # last_update_time d delivery_address id # address t phone_extension t room_no t distance # customer_id delivery_charge id # name t zip_code t start_range # end_range # charge_amount # delivery_configuration id # unit_name t unit_symbol t charge_by_zip_code b delivery_instruction id # notes t customer_no drawer_assigned_history id # time d operation t a_user drawer_pull_report_voidtickets dpreport_id code # reason t hast t quantity # amount # employee_in_out_history id # out_time d in_time d out_hour # in_hour # clock_out b user_id shift_id terminal_id global_config id # pos_key t pos_value t gratuity id amount # paid b refunded b ticket_id owner_id terminal_id inventory_group id name t visible b inventory_item id create_time d last_update_date d name t package_barcode t unit_barcode t unit_per_package # sort_order # package_reorder_level # package_replenish_level # description t average_package_price # total_packages # total_recepie_units # unit_purchase_price # unit_selling_price # visible b punit_id recipe_unit_id item_group_id item_location_id item_vendor_id inventory_location id name t sort_order # visible b warehouse_id inventory_meta_code id # type t code_text t code_no # description t inventory_transaction id # transaction_date d quantity # unit_price # remark t tran_type # reference_id item_id vendor_id from_warehouse_id to_warehouse_id inventory_unit id # short_name t long_name t alt_name t conv_factor1 t conv_factor2 t conv_factor3 t inventory_vendor id name t visible b address t city t state t zip t country t email t phone t fax t inventory_warehouse id name t visible b item_order_type menu_item_id order_type_id kit_ticket_table_num kit_ticket_id table_id # kitchen_ticket id ticket_id # create_date d close_date d voided b sequence_number # status t server_name t ticket_type t pg_id kitchen_ticket_item id # cookable b ticket_item_id # ticket_item_modifier_id # menu_item_code t menu_item_name t menu_item_group_id # menu_item_group_name t quantity # fractional_quantity # fractional_unit b unit_name t sort_order # voided b status t kithen_ticket_id item_order # menu_category id name t translated_name t visible b beverage b sort_order # btn_color # text_color # menu_group id name t translated_name t visible b sort_order # btn_color # text_color # category_id menu_item id name t description t unit_name t translated_name t barcode t buy_price # stock_amount # price # discount_rate # visible b disable_when_stock_amount_is_zero b sort_order # btn_color # text_color # image ~ show_image_only b fractional_unit b pizza_type b default_sell_portion # group_id tax_id recepie pg_id menu_item_properties menu_item_id property_name t property_value t menu_item_size id name t translated_name t description t sort_order # size_in_inch # default_size b menu_item_terminal_ref menu_item_id terminal_id menu_modifier id name t translated_name t price # extra_price # sort_order # btn_color # text_color # enable b fixed_price b print_to_kitchen b section_wise_pricing b pizza_modifier b group_id tax_id menu_modifier_group id name t translated_name t enabled b exclusived b required b menu_modifier_properties menu_modifier_id property_name t property_value t menucategory_discount discount_id menucategory_id menugroup_discount discount_id menugroup_id menuitem_discount discount_id menuitem_id menuitem_modifiergroup id # min_quantity # max_quantity # sort_order # modifier_group menuitem_modifiergroup_id menuitem_pizzapirce menu_item_id pizza_price_id menuitem_shift id # shift_price # shift_id menuitem_id menumodifier_pizzamodifierprice menumodifier_id pizzamodifierprice_id modifier_multiplier_price id # price # multiplier_id menumodifier_id pizza_modifier_price_id multiplier name ticket_prefix t rate # sort_order # default_multiplier b main b btn_color # text_color # order_type id name t enabled b show_table_selection b show_guest_selection b should_print_to_kitchen b prepaid b close_on_paid b required_customer_data b delivery b show_item_barcode b show_in_login_screen b consolidate_tiems_in_receipt b allow_seat_based_order b hide_item_with_empty_inventory b has_forhere_and_togo b pre_auth_credit_card b bar_tab b show_price_on_button b show_stock_count_on_button b show_unit_price_in_ticket_grid b packaging_unit id name t short_name t factor # baseunit b dimension t payout_reasons id reason t payout_recepients id name t pizza_crust id name t translated_name t description t sort_order # default_crust b pizza_modifier_price id item_size pizza_price id price # menu_item_size crust order_type printer_configuration id # receipt_printer t kitchen_printer t prwts b prwtp b pkwts b pkwtp b unpft b unpfk b printer_group id name t is_default b printer_group_printers printer_id printer_name t purchase_order id order_id t name t recepie id menu_item recepie_item id # percentage # inventory_deductable b inventory_item recepie_id restaurant id # unique_id # name t address_line1 t address_line2 t address_line3 t zip_code t telephone t capacity # tables # cname t csymbol t sc_percentage # gratuity_percentage # ticket_footer t price_includes_tax b allow_modifier_max_exceed b shift id name t start_time d end_time d shift_len # shop_floor id name t occupied b image # shop_floor_template id name t default_floor b main b floor_id shop_floor_template_properties id property_name t property_value t shop_table id name t description t capacity # x # y # free b serving b booked b dirty b disable b floor_id shop_table_type id description t name t table_booking_info id from_date d to_date d guest_count # status t payment_status t booking_confirm t booking_charge # remaining_balance # paid_amount # booking_id t booking_type t user_id customer_id table_booking_mapping booking_id table_id table_type_relation table_id type_id tax id name t rate # terminal id name t terminal_key t opening_balance # current_balance # has_cash_drawer b in_use b active b location t floor_id # assigned_user terminal_printers id # terminal_id printer_name t virtual_printer_id ticket id global_id t create_date d closing_date d active_date d deliveery_date d creation_hour # paid b voided b void_reason t wasted b refunded b settled b drawer_resetted b sub_total # total_discount # total_tax # total_price # paid_amount # due_amount # advance_amount # number_of_guests # status t bar_tab b is_tax_exempt b is_re_opened b service_charge # delivery_charge # customer_id # delivery_address t customer_pickeup b delivery_extra_info t ticket_type t shift_id owner_id driver_id gratuity_id void_by_user terminal_id ticket_discount id # discount_id # name t type # auto_apply b minimum_amount # value # ticket_id ticket_item id item_id # item_count # item_quantity # item_name t item_unit_name t group_name t category_name t item_price # item_tax_rate # sub_total # sub_total_without_modifiers # discount # tax_amount # tax_amount_without_modifiers # total_price # total_price_without_modifiers # beverage b inventory_handled b print_to_kitchen b treat_as_seat b seat_number # fractional_unit b has_modiiers b printed_to_kitchen b status t stock_amount_adjusted b pizza_type b size_modifier_id ticket_id pg_id pizza_section_mode # ticket_item_addon_relation ticket_item_id list_order # modifier_id ticket_item_cooking_instruction ticket_item_id item_order # description t printedtokitchen b ticket_item_discount id # discount_id # name t type # auto_apply b minimum_quantity # value # amount # ticket_itemid ticket_item_modifier id item_id # group_id # item_count # modifier_name t modifier_price # modifier_tax_rate # modifier_type # subtotal_price # total_price # tax_amount # info_only b section_name t multiplier_name t print_to_kitchen b section_wise_pricing b status t printed_to_kitchen b ticket_item_id ticket_item_modifier_relation ticket_item_id list_order # modifier_id ticket_properties id property_name t property_value t ticket_table_num ticket_id table_id # transaction_properties id property_name t property_value t transactions id payment_type t global_id t transaction_time d amount # tips_amount # tips_exceed_amount # tender_amount # transaction_type t custom_payment_name t custom_payment_ref t custom_payment_field_name t payment_sub_type t captured b voided b authorizable b card_holder_name t card_number t card_auth_code t card_type t card_transaction_id t card_merchant_gateway t card_reader t card_aid t card_arqc t card_ext_data t gift_cert_number t gift_cert_face_value # gift_cert_paid_amount # gift_cert_cash_back_amount # drawer_resetted b note t terminal_id ticket_id user_id payout_reason_id payout_recepient_id user_permission name user_type id p_name t user_user_permission permissionid elt users auto_id user_id # user_pass t first_name t last_name t ssn t cost_per_hour # clocked_in b last_clock_in_time d last_clock_out_time d phone_no t is_driver b available_for_delivery b active b shift_id currentterminal n_user_type virtual_printer id name t type # priority # enabled b virtualprinter_order_type printer_id order_type t void_reasons id # reason_text t zip_code_vs_delivery_charge auto_id # zip_code t delivery_charge # drawer_pull_report id report_time d reg t ticket_count # begin_cash # net_sales # sales_tax # cash_tax # total_revenue # gross_receipts # giftcertreturncount # giftcertreturnamount # giftcertchangeamount # cash_receipt_no # cash_receipt_amount # credit_card_receipt_no # credit_card_receipt_amount # debit_card_receipt_no # debit_card_receipt_amount # refund_receipt_count # refund_amount # receipt_differential # cash_back # cash_tips # charged_tips # tips_paid # tips_differential # pay_out_no # pay_out_amount # drawer_bleed_no # drawer_bleed_amount # drawer_accountable # cash_to_deposit # variance # delivery_charge # totalvoidwst # totalvoid # totaldiscountcount # totaldiscountamount # totaldiscountsales # totaldiscountguest # totaldiscountpartysize # totaldiscountchecksize # totaldiscountpercentage # totaldiscountratio # user_id terminal_id

Table action_history

Indexes Field Name Data Type Description
* id serial
action_time timestamp
action_name varchar( 255 )
description varchar( 255 )
user_id integer
Indexes
action_history_pkey ON id
Foreign Keys
fk3f3af36b3e20ad51 ( user_id ) ref users (auto_id)

Table attendence_history

Indexes Field Name Data Type Description
* id serial
clock_in_time timestamp
clock_out_time timestamp
clock_in_hour smallint
clock_out_hour smallint
clocked_out bool
user_id integer
shift_id integer
terminal_id integer
Indexes
attendence_history_pkey ON id
Foreign Keys
fkdfe829a7660a5e3 ( shift_id ) ref shift (id)
fkdfe829a2ad2d031 ( terminal_id ) ref terminal (id)
fkdfe829a3e20ad51 ( user_id ) ref users (auto_id)

Table cash_drawer

Indexes Field Name Data Type Description
* id serial
terminal_id integer
Indexes
cash_drawer_pkey ON id
Foreign Keys
fk6221077d2ad2d031 ( terminal_id ) ref terminal (id)

Table cash_drawer_reset_history

Indexes Field Name Data Type Description
* id serial
reset_time timestamp
user_id integer
Indexes
cash_drawer_reset_history_pkey ON id
Foreign Keys
fk719418223e20ad51 ( user_id ) ref users (auto_id)

Table cooking_instruction

Indexes Field Name Data Type Description
* id serial
description varchar( 60 )
Indexes
cooking_instruction_pkey ON id

Table coupon_and_discount

Indexes Field Name Data Type Description
* id serial
name varchar( 120 )
type integer
barcode varchar( 120 )
qualification_type integer
apply_to_all bool
minimum_buy integer
maximum_off integer
value float8
expiry_date timestamp
enabled bool
auto_apply bool
modifiable bool
never_expire bool
uuid varchar( 36 )
Indexes
coupon_and_discount_pkey ON id
coupon_and_discount_uuid_key ON uuid

Table currency

Indexes Field Name Data Type Description
* id serial
code varchar( 20 )
name varchar( 30 )
symbol varchar( 10 )
exchange_rate float8
tolerance float8
buy_price float8
sales_price float8
main bool
Indexes
currency_pkey ON id

Table currency_balance

Indexes Field Name Data Type Description
* id serial
balance float8
currency_id integer
cash_drawer_id integer
dpr_id integer
Indexes
currency_balance_pkey ON id
Foreign Keys
fk2cc0e08e9006558 ( cash_drawer_id ) ref cash_drawer (id)
fk2cc0e08e28dd6c11 ( currency_id ) ref currency (id)
fk2cc0e08efb910735 ( dpr_id ) ref drawer_pull_report (id)

Table custom_payment

Indexes Field Name Data Type Description
* id serial
name varchar( 60 )
required_ref_number bool
ref_number_field_name varchar( 60 )
Indexes
custom_payment_pkey ON id

Table customer

Indexes Field Name Data Type Description
* auto_id serial
loyalty_no varchar( 30 )
loyalty_point integer
social_security_number varchar( 60 )
picture bytea
homephone_no varchar( 30 )
mobile_no varchar( 30 )
workphone_no varchar( 30 )
email varchar( 40 )
salutation varchar( 60 )
first_name varchar( 60 )
last_name varchar( 60 )
name varchar( 120 )
dob varchar( 16 )
ssn varchar( 30 )
address varchar( 220 )
city varchar( 30 )
state varchar( 30 )
zip_code varchar( 10 )
country varchar( 30 )
vip bool
credit_limit float8
credit_spent float8
credit_card_no varchar( 30 )
note varchar( 255 )
Indexes
customer_pkey ON auto_id

Table customer_properties

Indexes Field Name Data Type Description
* id integer
* property_name varchar( 255 )
property_value varchar( 255 )
Indexes
customer_properties_pkey ON id, property_name
Foreign Keys
fkd43068347bbccf0 ( id ) ref customer (auto_id)

Table data_update_info

Indexes Field Name Data Type Description
* id serial
last_update_time timestamp
Indexes
data_update_info_pkey ON id

Table delivery_address

Indexes Field Name Data Type Description
* id serial
address varchar( 320 )
phone_extension varchar( 10 )
room_no varchar( 30 )
distance float8
customer_id integer
Indexes
delivery_address_pkey ON id
Foreign Keys
fk29aca6899e1c3cf1 ( customer_id ) ref customer (auto_id)

Table delivery_charge

Indexes Field Name Data Type Description
* id serial
name varchar( 220 )
zip_code varchar( 20 )
start_range float8
end_range float8
charge_amount float8
Indexes
delivery_charge_pkey ON id

Table delivery_configuration

Indexes Field Name Data Type Description
* id serial
unit_name varchar( 20 )
unit_symbol varchar( 8 )
charge_by_zip_code bool
Indexes
delivery_configuration_pkey ON id

Table delivery_instruction

Indexes Field Name Data Type Description
* id serial
notes varchar( 220 )
customer_no integer
Indexes
delivery_instruction_pkey ON id
Foreign Keys
fk29d9ca39e1c3d97 ( customer_no ) ref customer (auto_id)

Table drawer_assigned_history

Indexes Field Name Data Type Description
* id serial
time timestamp
operation varchar( 60 )
a_user integer
Indexes
drawer_assigned_history_pkey ON id
Foreign Keys
fk5a823c91f1dd782b ( a_user ) ref users (auto_id)

Table drawer_pull_report

Indexes Field Name Data Type Description
* id serial
report_time timestamp
reg varchar( 15 )
ticket_count integer
begin_cash float8
net_sales float8
sales_tax float8
cash_tax float8
total_revenue float8
gross_receipts float8
giftcertreturncount integer
giftcertreturnamount float8
giftcertchangeamount float8
cash_receipt_no integer
cash_receipt_amount float8
credit_card_receipt_no integer
credit_card_receipt_amount float8
debit_card_receipt_no integer
debit_card_receipt_amount float8
refund_receipt_count integer
refund_amount float8
receipt_differential float8
cash_back float8
cash_tips float8
charged_tips float8
tips_paid float8
tips_differential float8
pay_out_no integer
pay_out_amount float8
drawer_bleed_no integer
drawer_bleed_amount float8
drawer_accountable float8
cash_to_deposit float8
variance float8
delivery_charge float8
totalvoidwst float8
totalvoid float8
totaldiscountcount integer
totaldiscountamount float8
totaldiscountsales float8
totaldiscountguest integer
totaldiscountpartysize integer
totaldiscountchecksize integer
totaldiscountpercentage float8
totaldiscountratio float8
user_id integer
terminal_id integer
Indexes
drawer_pull_report_pkey ON id
drawer_report_time ON report_time
Foreign Keys
fkaec362202ad2d031 ( terminal_id ) ref terminal (id)
fkaec362203e20ad51 ( user_id ) ref users (auto_id)

Table drawer_pull_report_voidtickets

Indexes Field Name Data Type Description
* dpreport_id integer
code integer
reason varchar( 255 )
hast varchar( 255 )
quantity integer
amount float8
Foreign Keys
fk98cf9b143ef4cd9b ( dpreport_id ) ref drawer_pull_report (id)

Table employee_in_out_history

Indexes Field Name Data Type Description
* id serial
out_time timestamp
in_time timestamp
out_hour smallint
in_hour smallint
clock_out bool
user_id integer
shift_id integer
terminal_id integer
Indexes
employee_in_out_history_pkey ON id
Foreign Keys
fk6d5db9fa7660a5e3 ( shift_id ) ref shift (id)
fk6d5db9fa2ad2d031 ( terminal_id ) ref terminal (id)
fk6d5db9fa3e20ad51 ( user_id ) ref users (auto_id)

Table global_config

Indexes Field Name Data Type Description
* id serial
pos_key varchar( 60 )
pos_value varchar( 220 )
Indexes
global_config_pkey ON id
global_config_pos_key_key ON pos_key

Table gratuity

Indexes Field Name Data Type Description
* id serial
amount float8
paid bool
refunded bool
ticket_id integer
owner_id integer
terminal_id integer
Indexes
gratuity_pkey ON id
Foreign Keys
fk34e4e3772ad2d031 ( terminal_id ) ref terminal (id)
fk34e4e3771df2d7f1 ( ticket_id ) ref ticket (id)
fk34e4e377aa075d69 ( owner_id ) ref users (auto_id)

Table inventory_group

Indexes Field Name Data Type Description
* id serial
* name varchar( 60 )
visible bool
Indexes
inventory_group_pkey ON id

Table inventory_item

Indexes Field Name Data Type Description
* id serial
create_time timestamp
last_update_date timestamp
name varchar( 60 )
package_barcode varchar( 30 )
unit_barcode varchar( 30 )
unit_per_package float8
sort_order integer
package_reorder_level integer
package_replenish_level integer
description varchar( 255 )
average_package_price float8
total_packages integer
total_recepie_units float8
unit_purchase_price float8
unit_selling_price float8
visible bool
punit_id integer
recipe_unit_id integer
item_group_id integer
item_location_id integer
item_vendor_id integer
Indexes
inventory_item_pkey ON id
Foreign Keys
fk7dc968362cd583c1 ( item_group_id ) ref inventory_group (id)
fk7dc9683695e455d3 ( item_location_id ) ref inventory_location (id)
fk7dc968369e60c333 ( item_vendor_id ) ref inventory_vendor (id)
fk7dc968363525e956 ( punit_id ) ref packaging_unit (id)
fk7dc968366848d615 ( recipe_unit_id ) ref packaging_unit (id)

Table inventory_location

Indexes Field Name Data Type Description
* id serial
* name varchar( 60 )
sort_order integer
visible bool
warehouse_id integer
Indexes
inventory_location_pkey ON id
Foreign Keys
fk59073b58c46a9c15 ( warehouse_id ) ref inventory_warehouse (id)

Table inventory_meta_code

Indexes Field Name Data Type Description
* id serial
type varchar( 255 )
code_text varchar( 255 )
code_no integer
description varchar( 255 )
Indexes
inventory_meta_code_pkey ON id

Table inventory_transaction

Indexes Field Name Data Type Description
* id serial
transaction_date timestamp
quantity integer
unit_price float8
remark varchar( 255 )
tran_type integer
reference_id integer
item_id integer
vendor_id integer
from_warehouse_id integer
to_warehouse_id integer
Indexes
inventory_transaction_pkey ON id
Foreign Keys
fkaf48f43b96a3d6bf ( item_id ) ref inventory_item (id)
fkaf48f43bd152c95f ( vendor_id ) ref inventory_vendor (id)
fkaf48f43beda09759 ( to_warehouse_id ) ref inventory_warehouse (id)
fkaf48f43bff3f328a ( from_warehouse_id ) ref inventory_warehouse (id)
fkaf48f43b5b397c5 ( reference_id ) ref purchase_order (id)

Table inventory_unit

Indexes Field Name Data Type Description
* id serial
short_name varchar( 255 )
long_name varchar( 255 )
alt_name varchar( 255 )
conv_factor1 varchar( 255 )
conv_factor2 varchar( 255 )
conv_factor3 varchar( 255 )
Indexes
inventory_unit_pkey ON id

Table inventory_vendor

Indexes Field Name Data Type Description
* id serial
* name varchar( 60 )
visible bool
* address varchar( 120 )
* city varchar( 60 )
* state varchar( 60 )
* zip varchar( 60 )
* country varchar( 60 )
* email varchar( 60 )
* phone varchar( 60 )
fax varchar( 60 )
Indexes
inventory_vendor_pkey ON id

Table inventory_warehouse

Indexes Field Name Data Type Description
* id serial
* name varchar( 60 )
visible bool
Indexes
inventory_warehouse_pkey ON id

Table item_order_type

Indexes Field Name Data Type Description
* menu_item_id integer
* order_type_id integer
Foreign Keys
fke2b8465789fe23f0 ( menu_item_id ) ref menu_item (id)
fke2b846573ac1d2e0 ( order_type_id ) ref order_type (id)

Table kit_ticket_table_num

Indexes Field Name Data Type Description
* kit_ticket_id integer
table_id integer
Foreign Keys
fk5696584bb73e273e ( kit_ticket_id ) ref kitchen_ticket (id)

Table kitchen_ticket

Indexes Field Name Data Type Description
* id serial
ticket_id integer
create_date timestamp
close_date timestamp
voided bool
sequence_number integer
status varchar( 30 )
server_name varchar( 30 )
ticket_type varchar( 20 )
pg_id integer
Indexes
kitchen_ticket_pkey ON id
Foreign Keys
fk341cbc275cf1375f ( pg_id ) ref printer_group (id)

Table kitchen_ticket_item

Indexes Field Name Data Type Description
* id serial
cookable bool
ticket_item_id integer
ticket_item_modifier_id integer
menu_item_code varchar( 255 )
menu_item_name varchar( 120 )
menu_item_group_id integer
menu_item_group_name varchar( 120 )
quantity integer
fractional_quantity float8
fractional_unit bool
unit_name varchar( 20 )
sort_order integer
voided bool
status varchar( 30 )
kithen_ticket_id integer
item_order integer
Indexes
kitchen_ticket_item_pkey ON id
Foreign Keys
fk1462f02bcb07faa3 ( kithen_ticket_id ) ref kitchen_ticket (id)

Table menu_category

Indexes Field Name Data Type Description
* id serial
* name varchar( 120 )
translated_name varchar( 120 )
visible bool
beverage bool
sort_order integer
btn_color integer
text_color integer
Indexes
menu_category_pkey ON id
food_category_visible ON visible

Table menu_group

Indexes Field Name Data Type Description
* id serial
* name varchar( 120 )
translated_name varchar( 120 )
visible bool
sort_order integer
btn_color integer
text_color integer
category_id integer
Indexes
menu_group_pkey ON id
menugroupvisible ON visible
Foreign Keys
fk4dc1ab7f2e347ff0 ( category_id ) ref menu_category (id)

Table menu_item

Indexes Field Name Data Type Description
* id serial
* name varchar( 120 )
description varchar( 255 )
unit_name varchar( 20 )
translated_name varchar( 120 )
barcode varchar( 120 )
* buy_price float8
stock_amount float8
* price float8
discount_rate float8
visible bool
disable_when_stock_amount_is_zero bool
sort_order integer
btn_color integer
text_color integer
image bytea
show_image_only bool
fractional_unit bool
pizza_type bool
default_sell_portion integer
group_id integer
tax_id integer
recepie integer
pg_id integer
Indexes
menu_item_pkey ON id
Foreign Keys
fk4cd5a1f35188aa24 ( group_id ) ref menu_group (id)
fk4cd5a1f35cf1375f ( pg_id ) ref printer_group (id)
fk4cd5a1f3f3b77c57 ( recepie ) ref recepie (id)
fk4cd5a1f3a4802f83 ( tax_id ) ref tax (id)

Table menu_item_properties

Indexes Field Name Data Type Description
* menu_item_id integer
* property_name varchar( 255 )
property_value varchar( 100 )
Indexes
menu_item_properties_pkey ON menu_item_id, property_name
Foreign Keys
fkf94186ff89fe23f0 ( menu_item_id ) ref menu_item (id)

Table menu_item_size

Indexes Field Name Data Type Description
* id serial
name varchar( 60 )
translated_name varchar( 60 )
description varchar( 120 )
sort_order integer
size_in_inch float8
default_size bool
Indexes
menu_item_size_pkey ON id

Table menu_item_terminal_ref

Indexes Field Name Data Type Description
* menu_item_id integer
* terminal_id integer
Foreign Keys
fk9ea1afc89fe23f0 ( menu_item_id ) ref menu_item (id)
fk9ea1afc2ad2d031 ( terminal_id ) ref terminal (id)

Table menu_modifier

Indexes Field Name Data Type Description
* id serial
name varchar( 120 )
translated_name varchar( 120 )
price float8
extra_price float8
sort_order integer
btn_color integer
text_color integer
enable bool
fixed_price bool
print_to_kitchen bool
section_wise_pricing bool
pizza_modifier bool
group_id integer
tax_id integer
Indexes
menu_modifier_pkey ON id
modifierenabled ON enable
Foreign Keys
fk59b6b1b75e0c7b8d ( group_id ) ref menu_modifier_group (id)
fk59b6b1b7a4802f83 ( tax_id ) ref tax (id)

Table menu_modifier_group

Indexes Field Name Data Type Description
* id serial
name varchar( 60 )
translated_name varchar( 60 )
enabled bool
exclusived bool
required bool
Indexes
menu_modifier_group_pkey ON id
mg_enable ON enabled

Table menu_modifier_properties

Indexes Field Name Data Type Description
* menu_modifier_id integer
* property_name varchar( 255 )
property_value varchar( 100 )
Indexes
menu_modifier_properties_pkey ON menu_modifier_id, property_name
Foreign Keys
fk1273b4bbb79c6270 ( menu_modifier_id ) ref menu_modifier (id)

Table menucategory_discount

Indexes Field Name Data Type Description
* discount_id integer
* menucategory_id integer
Foreign Keys
fk4f8523e3d3e91e11 ( discount_id ) ref coupon_and_discount (id)
fk4f8523e38d9ea931 ( menucategory_id ) ref menu_category (id)

Table menugroup_discount

Indexes Field Name Data Type Description
* discount_id integer
* menugroup_id integer
Foreign Keys
fke3790e40d3e91e11 ( discount_id ) ref coupon_and_discount (id)
fke3790e40113bf083 ( menugroup_id ) ref menu_group (id)

Table menuitem_discount

Indexes Field Name Data Type Description
* discount_id integer
* menuitem_id integer
Foreign Keys
fkd89ccdeed3e91e11 ( discount_id ) ref coupon_and_discount (id)
fkd89ccdee33662891 ( menuitem_id ) ref menu_item (id)

Table menuitem_modifiergroup

Indexes Field Name Data Type Description
* id serial
min_quantity integer
max_quantity integer
sort_order integer
modifier_group integer
menuitem_modifiergroup_id integer
Indexes
menuitem_modifiergroup_pkey ON id
Foreign Keys
fk312b355b6e7b8b68 ( menuitem_modifiergroup_id ) ref menu_item (id)
fk312b355b40fda3c9 ( modifier_group ) ref menu_modifier_group (id)

Table menuitem_pizzapirce

Indexes Field Name Data Type Description
* menu_item_id integer
* pizza_price_id integer
Foreign Keys
fk17bd51a089fe23f0 ( menu_item_id ) ref menu_item (id)
fk17bd51a0ae5d580 ( pizza_price_id ) ref pizza_price (id)

Table menuitem_shift

Indexes Field Name Data Type Description
* id serial
shift_price float8
shift_id integer
menuitem_id integer
Indexes
menuitem_shift_pkey ON id
Foreign Keys
fke03c92d533662891 ( menuitem_id ) ref menu_item (id)
fke03c92d57660a5e3 ( shift_id ) ref shift (id)

Table menumodifier_pizzamodifierprice

Indexes Field Name Data Type Description
* menumodifier_id integer
* pizzamodifierprice_id integer
Foreign Keys
fk572726f3ae3f2e91 ( menumodifier_id ) ref menu_modifier (id)
fk572726f374be2c71 ( pizzamodifierprice_id ) ref pizza_modifier_price (id)

Table modifier_multiplier_price

Indexes Field Name Data Type Description
* id serial
price float8
multiplier_id varchar( 20 )
menumodifier_id integer
pizza_modifier_price_id integer
Indexes
modifier_multiplier_price_pkey ON id
Foreign Keys
fk8a160993ae3f2e91 ( menumodifier_id ) ref menu_modifier (id)
fk8a16099391d62c51 ( multiplier_id ) ref multiplier (name)
fk8a1609939c9e4883 ( pizza_modifier_price_id ) ref pizza_modifier_price (id)

Table multiplier

Indexes Field Name Data Type Description
* name varchar( 20 )
ticket_prefix varchar( 20 )
rate float8
sort_order integer
default_multiplier bool
main bool
btn_color integer
text_color integer
Indexes
multiplier_pkey ON name

Table order_type

Indexes Field Name Data Type Description
* id serial
* name varchar( 120 )
enabled bool
show_table_selection bool
show_guest_selection bool
should_print_to_kitchen bool
prepaid bool
close_on_paid bool
required_customer_data bool
delivery bool
show_item_barcode bool
show_in_login_screen bool
consolidate_tiems_in_receipt bool
allow_seat_based_order bool
hide_item_with_empty_inventory bool
has_forhere_and_togo bool
pre_auth_credit_card bool
bar_tab bool
show_price_on_button bool
show_stock_count_on_button bool
show_unit_price_in_ticket_grid bool
Indexes
order_type_pkey ON id
order_type_name_key ON name

Table packaging_unit

Indexes Field Name Data Type Description
* id serial
name varchar( 30 )
short_name varchar( 10 )
factor float8
baseunit bool
dimension varchar( 30 )
Indexes
packaging_unit_pkey ON id
packaging_unit_name_key ON name

Table payout_reasons

Indexes Field Name Data Type Description
* id serial
reason varchar( 255 )
Indexes
payout_reasons_pkey ON id

Table payout_recepients

Indexes Field Name Data Type Description
* id serial
name varchar( 255 )
Indexes
payout_recepients_pkey ON id

Table pizza_crust

Indexes Field Name Data Type Description
* id serial
name varchar( 60 )
translated_name varchar( 60 )
description varchar( 120 )
sort_order integer
default_crust bool
Indexes
pizza_crust_pkey ON id

Table pizza_modifier_price

Indexes Field Name Data Type Description
* id serial
item_size integer
Indexes
pizza_modifier_price_pkey ON id
Foreign Keys
fkd3de7e7896183657 ( item_size ) ref menu_item_size (id)

Table pizza_price

Indexes Field Name Data Type Description
* id serial
price float8
menu_item_size integer
crust integer
order_type integer
Indexes
pizza_price_pkey ON id
Foreign Keys
fkeac11292dd545b77 ( menu_item_size ) ref menu_item_size (id)
fkeac11292a56d141c ( order_type ) ref order_type (id)
fkeac112927c59441d ( crust ) ref pizza_crust (id)

Table printer_configuration

Indexes Field Name Data Type Description
* id integer
receipt_printer varchar( 255 )
kitchen_printer varchar( 255 )
prwts bool
prwtp bool
pkwts bool
pkwtp bool
unpft bool
unpfk bool
Indexes
printer_configuration_pkey ON id

Table printer_group

Indexes Field Name Data Type Description
* id serial
* name varchar( 60 )
is_default bool
Indexes
printer_group_pkey ON id
printer_group_name_key ON name

Table printer_group_printers

Indexes Field Name Data Type Description
* printer_id integer
printer_name varchar( 255 )
Foreign Keys
fkc05b805e5f31265c ( printer_id ) ref printer_group (id)

Table purchase_order

Indexes Field Name Data Type Description
* id serial
order_id varchar( 30 )
name varchar( 30 )
Indexes
purchase_order_pkey ON id

Table recepie

Indexes Field Name Data Type Description
* id serial
menu_item integer
Indexes
recepie_pkey ON id
Foreign Keys
fk6b4e177764931efc ( menu_item ) ref menu_item (id)

Table recepie_item

Indexes Field Name Data Type Description
* id serial
percentage float8
inventory_deductable bool
inventory_item integer
recepie_id integer
Indexes
recepie_item_pkey ON id
Foreign Keys
fk855626db1682b10e ( inventory_item ) ref inventory_item (id)
fk855626dbcae89b83 ( recepie_id ) ref recepie (id)

Table restaurant

Indexes Field Name Data Type Description
* id integer
unique_id integer
name varchar( 120 )
address_line1 varchar( 60 )
address_line2 varchar( 60 )
address_line3 varchar( 60 )
zip_code varchar( 10 )
telephone varchar( 16 )
capacity integer
tables integer
cname varchar( 20 )
csymbol varchar( 10 )
sc_percentage float8
gratuity_percentage float8
ticket_footer varchar( 60 )
price_includes_tax bool
allow_modifier_max_exceed bool
Indexes
restaurant_pkey ON id

Table shift

Indexes Field Name Data Type Description
* id serial
* name varchar( 60 )
start_time timestamp
end_time timestamp
shift_len bigint
Indexes
shift_pkey ON id
shift_name_key ON name

Table shop_floor

Indexes Field Name Data Type Description
* id serial
name varchar( 60 )
occupied bool
image oid( 10 )
Indexes
shop_floor_pkey ON id

Table shop_floor_template

Indexes Field Name Data Type Description
* id serial
name varchar( 60 )
default_floor bool
main bool
floor_id integer
Indexes
shop_floor_template_pkey ON id
Foreign Keys
fkba6efbd68979c3cd ( floor_id ) ref shop_floor (id)

Table shop_floor_template_properties

Indexes Field Name Data Type Description
* id integer
* property_name varchar( 255 )
property_value varchar( 60 )
Indexes
shop_floor_template_properties_pkey ON id, property_name
Foreign Keys
fkd70c313ca36ab054 ( id ) ref shop_floor_template (id)

Table shop_table

Indexes Field Name Data Type Description
* id integer
name varchar( 20 )
description varchar( 60 )
capacity integer
x integer
y integer
free bool
serving bool
booked bool
dirty bool
disable bool
floor_id integer
Indexes
shop_table_pkey ON id
Foreign Keys
fk2458e9258979c3cd ( floor_id ) ref shop_floor (id)

Table shop_table_type

Indexes Field Name Data Type Description
* id serial
description varchar( 120 )
name varchar( 40 )
Indexes
shop_table_type_pkey ON id

Table table_booking_info

Indexes Field Name Data Type Description
* id serial
from_date timestamp
to_date timestamp
guest_count integer
status varchar( 30 )
payment_status varchar( 30 )
booking_confirm varchar( 30 )
booking_charge float8
remaining_balance float8
paid_amount float8
booking_id varchar( 30 )
booking_type varchar( 30 )
user_id integer
customer_id integer
Indexes
table_booking_info_pkey ON id
fromdate ON from_date
todate ON to_date
Foreign Keys
fk301c4de59e1c3cf1 ( customer_id ) ref customer (auto_id)
fk301c4de53e20ad51 ( user_id ) ref users (auto_id)

Table table_booking_mapping

Indexes Field Name Data Type Description
* booking_id integer
* table_id integer
Foreign Keys
fk6bc51417dc46948d ( table_id ) ref shop_table (id)
fk6bc51417160de3b1 ( booking_id ) ref table_booking_info (id)

Table table_type_relation

Indexes Field Name Data Type Description
* table_id integer
* type_id integer
Foreign Keys
fk93802290dc46948d ( table_id ) ref shop_table (id)
fk93802290f5d6e47b ( type_id ) ref shop_table_type (id)

Table tax

Indexes Field Name Data Type Description
* id serial
* name varchar( 20 )
rate float8
Indexes
tax_pkey ON id

Table terminal

Indexes Field Name Data Type Description
* id integer
name varchar( 60 )
terminal_key varchar( 120 )
opening_balance float8
current_balance float8
has_cash_drawer bool
in_use bool
active bool
location varchar( 320 )
floor_id integer
assigned_user integer
Indexes
terminal_pkey ON id
Foreign Keys
fke83d827c969c6de ( assigned_user ) ref users (auto_id)

Table terminal_printers

Indexes Field Name Data Type Description
* id serial
terminal_id integer
printer_name varchar( 60 )
virtual_printer_id integer
Indexes
terminal_printers_pkey ON id
Foreign Keys
fk99ede5fc2ad2d031 ( terminal_id ) ref terminal (id)
fk99ede5fcc433e65a ( virtual_printer_id ) ref virtual_printer (id)

Table ticket

Indexes Field Name Data Type Description
* id serial
global_id varchar( 16 )
create_date timestamp
closing_date timestamp
active_date timestamp
deliveery_date timestamp
creation_hour integer
paid bool
voided bool
void_reason varchar( 255 )
wasted bool
refunded bool
settled bool
drawer_resetted bool
sub_total float8
total_discount float8
total_tax float8
total_price float8
paid_amount float8
due_amount float8
advance_amount float8
number_of_guests integer
status varchar( 30 )
bar_tab bool
is_tax_exempt bool
is_re_opened bool
service_charge float8
delivery_charge float8
customer_id integer
delivery_address varchar( 120 )
customer_pickeup bool
delivery_extra_info varchar( 255 )
ticket_type varchar( 20 )
shift_id integer
owner_id integer
driver_id integer
gratuity_id integer
void_by_user integer
terminal_id integer
Indexes
ticket_pkey ON id
ticket_global_id_key ON global_id
creationhour ON creation_hour
deliverydate ON deliveery_date
drawerresetted ON drawer_resetted
ticketactivedate ON active_date
ticketclosingdate ON closing_date
ticketcreatedate ON create_date
ticketpaid ON paid
ticketsettled ON settled
ticketvoided ON voided
Foreign Keys
fk937b5f0cc188ea51 ( gratuity_id ) ref gratuity (id)
fk937b5f0c7660a5e3 ( shift_id ) ref shift (id)
fk937b5f0c2ad2d031 ( terminal_id ) ref terminal (id)
fk937b5f0c1f6a9a4a ( void_by_user ) ref users (auto_id)
fk937b5f0caa075d69 ( owner_id ) ref users (auto_id)
fk937b5f0cf575c7d4 ( driver_id ) ref users (auto_id)

Table ticket_discount

Indexes Field Name Data Type Description
* id serial
discount_id integer
name varchar( 30 )
type integer
auto_apply bool
minimum_amount integer
value float8
ticket_id integer
Indexes
ticket_discount_pkey ON id
Foreign Keys
fk1fa465141df2d7f1 ( ticket_id ) ref ticket (id)

Table ticket_item

Indexes Field Name Data Type Description
* id serial
item_id integer
item_count integer
item_quantity float8
item_name varchar( 120 )
item_unit_name varchar( 20 )
group_name varchar( 120 )
category_name varchar( 120 )
item_price float8
item_tax_rate float8
sub_total float8
sub_total_without_modifiers float8
discount float8
tax_amount float8
tax_amount_without_modifiers float8
total_price float8
total_price_without_modifiers float8
beverage bool
inventory_handled bool
print_to_kitchen bool
treat_as_seat bool
seat_number integer
fractional_unit bool
has_modiiers bool
printed_to_kitchen bool
status varchar( 255 )
stock_amount_adjusted bool
pizza_type bool
size_modifier_id integer
ticket_id integer
pg_id integer
pizza_section_mode integer
Indexes
ticket_item_pkey ON id
Foreign Keys
fk979f54665cf1375f ( pg_id ) ref printer_group (id)
fk979f54661df2d7f1 ( ticket_id ) ref ticket (id)
fk979f546633e5d3b2 ( size_modifier_id ) ref ticket_item_modifier (id)

Table ticket_item_addon_relation

Indexes Field Name Data Type Description
* ticket_item_id integer
* list_order integer
* modifier_id integer
Indexes
ticket_item_addon_relation_pkey ON ticket_item_id, list_order
Foreign Keys
fk9f199634dec6120a ( ticket_item_id ) ref ticket_item (id)
fk9f1996346c108ef0 ( modifier_id ) ref ticket_item_modifier (id)

Table ticket_item_cooking_instruction

Indexes Field Name Data Type Description
* ticket_item_id integer
* item_order integer
description varchar( 60 )
printedtokitchen bool
Indexes
ticket_item_cooking_instruction_pkey ON ticket_item_id, item_order
Foreign Keys
fk3825f9d0dec6120a ( ticket_item_id ) ref ticket_item (id)

Table ticket_item_discount

Indexes Field Name Data Type Description
* id serial
discount_id integer
name varchar( 30 )
type integer
auto_apply bool
minimum_quantity integer
value float8
amount float8
ticket_itemid integer
Indexes
ticket_item_discount_pkey ON id
Foreign Keys
fk3df5d4fab9276e77 ( ticket_itemid ) ref ticket_item (id)

Table ticket_item_modifier

Indexes Field Name Data Type Description
* id serial
item_id integer
group_id integer
item_count integer
modifier_name varchar( 120 )
modifier_price float8
modifier_tax_rate float8
modifier_type integer
subtotal_price float8
total_price float8
tax_amount float8
info_only bool
section_name varchar( 20 )
multiplier_name varchar( 20 )
print_to_kitchen bool
section_wise_pricing bool
status varchar( 10 )
printed_to_kitchen bool
ticket_item_id integer
Indexes
ticket_item_modifier_pkey ON id
Foreign Keys
fk8fd6290dec6120a ( ticket_item_id ) ref ticket_item (id)

Table ticket_item_modifier_relation

Indexes Field Name Data Type Description
* ticket_item_id integer
* list_order integer
* modifier_id integer
Indexes
ticket_item_modifier_relation_pkey ON ticket_item_id, list_order
Foreign Keys
fk5d3f9acbdec6120a ( ticket_item_id ) ref ticket_item (id)
fk5d3f9acb6c108ef0 ( modifier_id ) ref ticket_item_modifier (id)

Table ticket_properties

Indexes Field Name Data Type Description
* id integer
* property_name varchar( 255 )
property_value varchar( 1000 )
Indexes
ticket_properties_pkey ON id, property_name
Foreign Keys
fk70ecd046223049de ( id ) ref ticket (id)

Table ticket_table_num

Indexes Field Name Data Type Description
* ticket_id integer
table_id integer
Foreign Keys
fk65af15e21df2d7f1 ( ticket_id ) ref ticket (id)

Table transaction_properties

Indexes Field Name Data Type Description
* id integer
* property_name varchar( 255 )
property_value varchar( 255 )
Indexes
transaction_properties_pkey ON id, property_name
Foreign Keys
fke3de65548e8203bc ( id ) ref transactions (id)

Table transactions

Indexes Field Name Data Type Description
* id serial
* payment_type varchar( 30 )
global_id varchar( 16 )
transaction_time timestamp
amount float8
tips_amount float8
tips_exceed_amount float8
tender_amount float8
* transaction_type varchar( 30 )
custom_payment_name varchar( 60 )
custom_payment_ref varchar( 120 )
custom_payment_field_name varchar( 60 )
* payment_sub_type varchar( 40 )
captured bool
voided bool
authorizable bool
card_holder_name varchar( 60 )
card_number varchar( 40 )
card_auth_code varchar( 30 )
card_type varchar( 20 )
card_transaction_id varchar( 255 )
card_merchant_gateway varchar( 60 )
card_reader varchar( 30 )
card_aid varchar( 120 )
card_arqc varchar( 120 )
card_ext_data varchar( 255 )
gift_cert_number varchar( 64 )
gift_cert_face_value float8
gift_cert_paid_amount float8
gift_cert_cash_back_amount float8
drawer_resetted bool
note varchar( 255 )
terminal_id integer
ticket_id integer
user_id integer
payout_reason_id integer
payout_recepient_id integer
Indexes
transactions_pkey ON id
transactions_global_id_key ON global_id
tran_drawer_resetted ON drawer_resetted
Foreign Keys
fkfe987155fc697d9e ( payout_reason_id ) ref payout_reasons (id)
fkfe987155ca43b6 ( payout_recepient_id ) ref payout_recepients (id)
fkfe9871552ad2d031 ( terminal_id ) ref terminal (id)
fkfe9871551df2d7f1 ( ticket_id ) ref ticket (id)
fkfe9871553e20ad51 ( user_id ) ref users (auto_id)

Table user_permission

Indexes Field Name Data Type Description
* name varchar( 40 )
Indexes
user_permission_pkey ON name

Table user_type

Indexes Field Name Data Type Description
* id serial
p_name varchar( 60 )
Indexes
user_type_pkey ON id

Table user_user_permission

Indexes Field Name Data Type Description
* permissionid integer
* elt varchar( 40 )
Indexes
user_user_permission_pkey ON permissionid, elt
Foreign Keys
fk2dbeaa4f8f23f5e ( elt ) ref user_permission (name)
fk2dbeaa4f283ecc6 ( permissionid ) ref user_type (id)

Table users

Indexes Field Name Data Type Description
* auto_id serial
user_id integer
* user_pass varchar( 16 )
first_name varchar( 30 )
last_name varchar( 30 )
ssn varchar( 30 )
cost_per_hour float8
clocked_in bool
last_clock_in_time timestamp
last_clock_out_time timestamp
phone_no varchar( 20 )
is_driver bool
available_for_delivery bool
active bool
shift_id integer
currentterminal integer
n_user_type integer
Indexes
users_pkey ON auto_id
users_user_id_key ON user_id
users_user_pass_key ON user_pass
Foreign Keys
fk4d495e87660a5e3 ( shift_id ) ref shift (id)
fk4d495e8d9409968 ( currentterminal ) ref terminal (id)
fk4d495e8897b1e39 ( n_user_type ) ref user_type (id)

Table virtual_printer

Indexes Field Name Data Type Description
* id serial
* name varchar( 60 )
type integer
priority integer
enabled bool
Indexes
virtual_printer_pkey ON id
virtual_printer_name_key ON name

Table virtualprinter_order_type

Indexes Field Name Data Type Description
* printer_id integer
order_type varchar( 255 )
Foreign Keys
fk9af7853bcf15f4a6 ( printer_id ) ref virtual_printer (id)

Table void_reasons

Indexes Field Name Data Type Description
* id serial
reason_text varchar( 255 )
Indexes
void_reasons_pkey ON id

Table zip_code_vs_delivery_charge

Indexes Field Name Data Type Description
* auto_id serial
* zip_code varchar( 10 )
* delivery_charge float8
Indexes
zip_code_vs_delivery_charge_pkey ON auto_id

Powered by DbSchema