sequences.md

Sequences

#	Sequence Name	Owner	Data Type	Start Value	Increment	Description
1	account.configuration_profiles_configuration_profile_id_seq	frapid_db_user	bigint	1	1
2	account.installed_domains_domain_id_seq	frapid_db_user	bigint	1	1
3	account.logins_login_id_seq	frapid_db_user	bigint	1	1
4	account.users_user_id_seq	frapid_db_user	bigint	1	1
5	audit.transaction_log_log_id_seq	frapid_db_user	bigint	1	1
6	auth.entity_access_policy_entity_access_policy_id_seq	frapid_db_user	bigint	1	1
7	auth.group_entity_access_policy_group_entity_access_policy_id_seq	frapid_db_user	bigint	1	1
8	auth.group_menu_access_policy_group_menu_access_policy_id_seq	frapid_db_user	bigint	1	1
9	auth.menu_access_policy_menu_access_policy_id_seq	frapid_db_user	bigint	1	1
10	cafesys.area_diagrams_area_diagram_id_seq	frapid_db_user	bigint	1	1
11	cafesys.checkout_details_checkout_detail_id_seq	frapid_db_user	bigint	1	1
12	cafesys.checkout_modifier_details_checkout_modifier_detail_id_seq	frapid_db_user	bigint	1	1
13	cafesys.checkouts_checkout_id_seq	frapid_db_user	bigint	1	1
14	cafesys.food_courses_food_course_id_seq	frapid_db_user	bigint	1	1
15	cafesys.ingredient_details_ingredient_detail_id_seq	frapid_db_user	bigint	1	1
16	cafesys.ingredients_ingredient_id_seq	frapid_db_user	bigint	1	1
17	cafesys.menu_details_menu_detail_id_seq	frapid_db_user	bigint	1	1
18	cafesys.menus_menu_id_seq	frapid_db_user	bigint	1	1
19	cafesys.modifier_detail_ingredients_modifier_detail_ingredient_id_seq	frapid_db_user	bigint	1	1
20	cafesys.modifier_details_modifier_detail_id_seq	frapid_db_user	bigint	1	1
21	cafesys.modifiers_modifier_id_seq	frapid_db_user	bigint	1	1
22	cafesys.pos_areas_pos_area_id_seq	frapid_db_user	bigint	1	1
23	cafesys.refunds_refund_id_seq	frapid_db_user	bigint	1	1
24	cafesys.wastes_waste_id_seq	frapid_db_user	bigint	1	1
25	cinesys.bod_cash_bod_cash_id_seq	frapid_db_user	bigint	1	1
26	cinesys.bookings_booking_id_seq	frapid_db_user	bigint	1	1
27	cinesys.cashiers_cashier_id_seq	frapid_db_user	bigint	1	1
28	cinesys.checkouts_checkout_id_seq	frapid_db_user	bigint	1	1
29	cinesys.counters_counter_id_seq	frapid_db_user	bigint	1	1
30	cinesys.distributors_distributor_id_seq	frapid_db_user	bigint	1	1
31	cinesys.eod_cash_eod_cash_id_seq	frapid_db_user	bigint	1	1
32	cinesys.film_formats_film_format_id_seq	frapid_db_user	bigint	1	1
33	cinesys.genres_genre_id_seq	frapid_db_user	bigint	1	1
34	cinesys.movie_categories_movie_category_id_seq	frapid_db_user	bigint	1	1
35	cinesys.movie_ratings_movie_rating_id_seq	frapid_db_user	bigint	1	1
36	cinesys.movies_movie_id_seq	frapid_db_user	bigint	1	1
37	cinesys.pricing_types_pricing_type_id_seq	frapid_db_user	bigint	1	1
38	cinesys.pricings_pricing_id_seq	frapid_db_user	bigint	1	1
39	cinesys.screens_screen_id_seq	frapid_db_user	bigint	1	1
40	cinesys.seat_types_seat_type_id_seq	frapid_db_user	bigint	1	1
41	cinesys.seating_arrangements_seating_arrangement_id_seq	frapid_db_user	bigint	1	1
42	cinesys.shifts_shift_id_seq	frapid_db_user	bigint	1	1
43	cinesys.shows_show_id_seq	frapid_db_user	bigint	1	1
44	cinesys.video_formats_video_format_id_seq	frapid_db_user	bigint	1	1
45	config.custom_field_setup_custom_field_setup_id_seq	frapid_db_user	bigint	1	1
46	config.custom_fields_custom_field_id_seq	frapid_db_user	bigint	1	1
47	config.email_queue_queue_id_seq	frapid_db_user	bigint	1	1
48	config.filters_filter_id_seq	frapid_db_user	bigint	1	1
49	config.kanban_details_kanban_detail_id_seq	frapid_db_user	bigint	1	1
50	config.kanbans_kanban_id_seq	frapid_db_user	bigint	1	1
51	config.smtp_configs_smtp_config_id_seq	frapid_db_user	bigint	1	1
52	core.app_dependencies_app_dependency_id_seq	frapid_db_user	bigint	1	1
53	core.apps_app_id_seq	frapid_db_user	bigint	1	1
54	core.currencies_currency_id_seq	frapid_db_user	bigint	1	1
56	core.marital_statuses_marital_status_id_seq	frapid_db_user	bigint	1	1
57	core.menus_menu_id_seq	frapid_db_user	bigint	1	1
58	core.offices_office_id_seq	frapid_db_user	bigint	1	1
59	finance.accounts_account_id_seq	frapid_db_user	bigint	1	1
60	finance.auto_verification_policy_auto_verification_policy_id_seq	frapid_db_user	bigint	1	1
61	finance.bank_accounts_bank_account_id_seq	frapid_db_user	bigint	1	1
62	finance.cash_flow_setup_cash_flow_setup_id_seq	frapid_db_user	bigint	1	1
63	finance.cash_repositories_cash_repository_id_seq	frapid_db_user	bigint	1	1
64	finance.cost_centers_cost_center_id_seq	frapid_db_user	bigint	1	1
65	finance.day_operation_day_id_seq	frapid_db_user	bigint	1	1
66	finance.day_operation_routines_day_operation_routine_id_seq	frapid_db_user	bigint	1	1
67	finance.exchange_rate_details_exchange_rate_detail_id_seq	frapid_db_user	bigint	1	1
68	finance.exchange_rates_exchange_rate_id_seq	frapid_db_user	bigint	1	1
69	finance.fiscal_year_fiscal_year_id_seq	frapid_db_user	bigint	1	1
70	finance.frequencies_frequency_id_seq	frapid_db_user	bigint	1	1
71	finance.frequency_setups_frequency_setup_id_seq	frapid_db_user	bigint	1	1
72	finance.journal_verification_policy_journal_verification_policy_id_seq	frapid_db_user	bigint	1	1
73	finance.merchant_fee_setup_merchant_fee_setup_id_seq	frapid_db_user	bigint	1	1
74	finance.payment_cards_payment_card_id_seq	frapid_db_user	bigint	1	1
75	finance.routines_routine_id_seq	frapid_db_user	bigint	1	1
76	finance.tax_setups_tax_setup_id_seq	frapid_db_user	bigint	1	1
77	finance.transaction_details_transaction_detail_id_seq	frapid_db_user	bigint	1	1
78	finance.transaction_documents_document_id_seq	frapid_db_user	bigint	1	1
79	finance.transaction_master_transaction_master_id_seq	frapid_db_user	bigint	1	1
80	foodcourt.bod_cash_bod_cash_id_seq	frapid_db_user	bigint	1	1
81	foodcourt.brands_brand_id_seq	frapid_db_user	bigint	1	1
82	foodcourt.cashiers_cashier_id_seq	frapid_db_user	bigint	1	1
83	foodcourt.checkout_details_checkout_detail_id_seq	frapid_db_user	bigint	1	1
84	foodcourt.checkouts_checkout_id_seq	frapid_db_user	bigint	1	1
85	foodcourt.counters_counter_id_seq	frapid_db_user	bigint	1	1
86	foodcourt.dealers_dealer_id_seq	frapid_db_user	bigint	1	1
87	foodcourt.eod_cash_eod_cash_id_seq	frapid_db_user	bigint	1	1
88	foodcourt.item_groups_item_group_id_seq	frapid_db_user	bigint	1	1
89	foodcourt.items_item_id_seq	frapid_db_user	bigint	1	1
90	foodcourt.pos_areas_pos_area_id_seq	frapid_db_user	bigint	1	1
91	foodcourt.purchase_details_purchase_detail_id_seq	frapid_db_user	bigint	1	1
92	foodcourt.purchases_purchase_id_seq	frapid_db_user	bigint	1	1
93	forums.announcements_announcement_id_seq	frapid_db_user	bigint	1	1
94	forums.attachments_attachment_id_seq	frapid_db_user	bigint	1	1
95	forums.categories_category_id_seq	frapid_db_user	bigint	1	1
96	forums.category_access_category_access_id_seq	frapid_db_user	bigint	1	1
97	forums.category_moderators_category_moderator_id_seq	frapid_db_user	bigint	1	1
98	forums.category_subscriptions_category_subscription_id_seq	frapid_db_user	bigint	1	1
99	forums.karma_karma_id_seq	frapid_db_user	bigint	1	1
100	forums.posts_post_id_seq	frapid_db_user	bigint	1	1
101	forums.thank_yous_thank_you_id_seq	frapid_db_user	bigint	1	1
102	forums.topic_subscriptions_topic_subscription_id_seq	frapid_db_user	bigint	1	1
103	forums.topics_topic_id_seq	frapid_db_user	bigint	1	1
104	forums.user_profiles_user_profile_id_seq	frapid_db_user	bigint	1	1
105	gatekeeper.access_setups_access_setup_id_seq	frapid_db_user	bigint	1	1
106	gatekeeper.terminals_terminal_id_seq	frapid_db_user	bigint	1	1
107	helpdesk.announcement_categories_announcement_category_id_seq	frapid_db_user	bigint	1	1
108	helpdesk.announcements_announcement_id_seq	frapid_db_user	bigint	1	1
109	helpdesk.attachments_attachment_id_seq	frapid_db_user	bigint	1	1
110	helpdesk.billing_cycles_billing_cycle_id_seq	frapid_db_user	bigint	1	1
111	helpdesk.billing_setup_billing_setup_id_seq	frapid_db_user	bigint	1	1
112	helpdesk.coupons_coupon_id_seq	frapid_db_user	bigint	1	1
113	helpdesk.customer_groups_customer_group_id_seq	frapid_db_user	bigint	1	1
114	helpdesk.customers_customer_id_seq	frapid_db_user	bigint	1	1
115	helpdesk.department_assignments_department_assignment_id_seq	frapid_db_user	bigint	1	1
116	helpdesk.departments_department_id_seq	frapid_db_user	bigint	1	1
117	helpdesk.invoice_details_invoice_detail_id_seq	frapid_db_user	bigint	1	1
118	helpdesk.invoices_invoice_id_seq	frapid_db_user	bigint	1	1
119	helpdesk.knowledgebase_categories_knowledgebase_category_id_seq	frapid_db_user	bigint	1	1
120	helpdesk.knowledgebase_knowledgebase_id_seq	frapid_db_user	bigint	1	1
121	helpdesk.knowledgebase_request_voting_knowledgebase_request_voting_seq	frapid_db_user	bigint	1	1
122	helpdesk.knowledgebase_requests_knowledgebase_request_id_seq	frapid_db_user	bigint	1	1
123	helpdesk.payment_methods_payment_method_id_seq	frapid_db_user	bigint	1	1
124	helpdesk.pricing_pricing_id_seq	frapid_db_user	bigint	1	1
125	helpdesk.products_product_id_seq	frapid_db_user	bigint	1	1
126	helpdesk.receipts_receipt_id_seq	frapid_db_user	bigint	1	1
127	helpdesk.sales_sales_id_seq	frapid_db_user	bigint	1	1
128	helpdesk.support_ticket_message_attach_support_ticket_message_attach_seq	frapid_db_user	bigint	1	1
129	helpdesk.support_ticket_message_open_h_support_ticket_message_open_h_seq	frapid_db_user	bigint	1	1
130	helpdesk.support_ticket_messages_support_ticket_message_id_seq	frapid_db_user	bigint	1	1
131	helpdesk.support_tickets_support_ticket_id_seq	frapid_db_user	bigint	1	1
132	helpdesk.ticket_escalations_ticket_escalation_id_seq	frapid_db_user	bigint	1	1
133	helpdesk.ticket_history_ticket_history_id_seq	frapid_db_user	bigint	1	1
134	helpdesk.ticket_priorities_ticket_priority_id_seq	frapid_db_user	bigint	1	1
135	hrm.attendances_attendance_id_seq	frapid_db_user	bigint	1	1
136	hrm.contracts_contract_id_seq	frapid_db_user	bigint	1	1
137	hrm.departments_department_id_seq	frapid_db_user	bigint	1	1
138	hrm.education_levels_education_level_id_seq	frapid_db_user	bigint	1	1
139	hrm.employee_experiences_employee_experience_id_seq	frapid_db_user	bigint	1	1
140	hrm.employee_identification_detai_employee_identification_detai_seq	frapid_db_user	bigint	1	1
141	hrm.employee_qualifications_employee_qualification_id_seq	frapid_db_user	bigint	1	1
142	hrm.employee_social_network_detai_employee_social_network_detai_seq	frapid_db_user	bigint	1	1
143	hrm.employee_types_employee_type_id_seq	frapid_db_user	bigint	1	1
144	hrm.employees_employee_id_seq	frapid_db_user	bigint	1	1
145	hrm.employment_statuses_employment_status_id_seq	frapid_db_user	bigint	1	1
146	hrm.exit_types_exit_type_id_seq	frapid_db_user	bigint	1	1
147	hrm.exits_exit_id_seq	frapid_db_user	bigint	1	1
148	hrm.identification_types_identification_type_id_seq	frapid_db_user	bigint	1	1
149	hrm.job_titles_job_title_id_seq	frapid_db_user	bigint	1	1
150	hrm.leave_applications_leave_application_id_seq	frapid_db_user	bigint	1	1
151	hrm.leave_benefits_leave_benefit_id_seq	frapid_db_user	bigint	1	1
152	hrm.leave_types_leave_type_id_seq	frapid_db_user	bigint	1	1
153	hrm.nationalities_nationality_id_seq	frapid_db_user	bigint	1	1
154	hrm.office_hours_office_hour_id_seq	frapid_db_user	bigint	1	1
155	hrm.pay_grades_pay_grade_id_seq	frapid_db_user	bigint	1	1
156	hrm.resignations_resignation_id_seq	frapid_db_user	bigint	1	1
157	hrm.roles_role_id_seq	frapid_db_user	bigint	1	1
158	hrm.shifts_shift_id_seq	frapid_db_user	bigint	1	1
159	hrm.social_networks_social_network_id_seq	frapid_db_user	bigint	1	1
160	hrm.terminations_termination_id_seq	frapid_db_user	bigint	1	1
161	inventory.attributes_attribute_id_seq	frapid_db_user	bigint	1	1
162	inventory.brands_brand_id_seq	frapid_db_user	bigint	1	1
163	inventory.checkout_details_checkout_detail_id_seq	frapid_db_user	bigint	1	1
164	inventory.checkouts_checkout_id_seq	frapid_db_user	bigint	1	1
165	inventory.compound_units_compound_unit_id_seq	frapid_db_user	bigint	1	1
166	inventory.counters_counter_id_seq	frapid_db_user	bigint	1	1
167	inventory.customer_types_customer_type_id_seq	frapid_db_user	bigint	1	1
168	inventory.customers_customer_id_seq	frapid_db_user	bigint	1	1
169	inventory.inventory_transfer_deliveries_inventory_transfer_delivery_i_seq	frapid_db_user	bigint	1	1
170	inventory.inventory_transfer_delivery_d_inventory_transfer_delivery_d_seq	frapid_db_user	bigint	1	1
171	inventory.inventory_transfer_request_de_inventory_transfer_request_de_seq	frapid_db_user	bigint	1	1
172	inventory.inventory_transfer_requests_inventory_transfer_request_id_seq	frapid_db_user	bigint	1	1
173	inventory.item_groups_item_group_id_seq	frapid_db_user	bigint	1	1
174	inventory.item_types_item_type_id_seq	frapid_db_user	bigint	1	1
175	inventory.item_variants_item_variant_id_seq	frapid_db_user	bigint	1	1
176	inventory.items_item_id_seq	frapid_db_user	bigint	1	1
177	inventory.shippers_shipper_id_seq	frapid_db_user	bigint	1	1
178	inventory.store_types_store_type_id_seq	frapid_db_user	bigint	1	1
179	inventory.stores_store_id_seq	frapid_db_user	bigint	1	1
180	inventory.supplier_types_supplier_type_id_seq	frapid_db_user	bigint	1	1
181	inventory.suppliers_supplier_id_seq	frapid_db_user	bigint	1	1
182	inventory.units_unit_id_seq	frapid_db_user	bigint	1	1
183	inventory.variants_variant_id_seq	frapid_db_user	bigint	1	1
184	production.bom_components_bom_component_id_seq	frapid_db_user	bigint	1	1
185	production.bom_finish_goods_bom_finish_good_id_seq	frapid_db_user	bigint	1	1
186	production.bom_types_bom_type_id_seq	frapid_db_user	bigint	1	1
187	production.boms_bom_id_seq	frapid_db_user	bigint	1	1
188	production.disassembly_expenses_disassembly_expenses_id_seq	frapid_db_user	bigint	1	1
189	production.expenses_in_progress_expenses_in_progress_id_seq	frapid_db_user	bigint	1	1
190	production.kanbans_kanban_id_seq	frapid_db_user	bigint	1	1
191	production.manufacturing_manufacturing_id_seq	frapid_db_user	bigint	1	1
192	production.manufacturing_summary_manufacturing_summary_id_seq	frapid_db_user	bigint	1	1
193	production.order_progress_order_progress_id_seq	frapid_db_user	bigint	1	1
194	production.order_statuses_order_status_id_seq	frapid_db_user	bigint	1	1
195	production.order_types_order_type_id_seq	frapid_db_user	bigint	1	1
196	production.orders_order_id_seq	frapid_db_user	bigint	1	1
197	production.plants_plant_id_seq	frapid_db_user	bigint	1	1
198	production.priorities_priority_id_seq	frapid_db_user	bigint	1	1
199	production.routing_routing_id_seq	frapid_db_user	bigint	1	1
200	production.routing_sequences_routing_sequence_id_seq	frapid_db_user	bigint	1	1
201	production.routing_types_routing_type_id_seq	frapid_db_user	bigint	1	1
202	production.scraps_scrap_id_seq	frapid_db_user	bigint	1	1
203	production.work_center_capacity_work_center_capacity_id_seq	frapid_db_user	bigint	1	1
204	production.work_center_costs_work_center_cost_id_seq	frapid_db_user	bigint	1	1
205	production.work_center_departments_work_center_department_id_seq	frapid_db_user	bigint	1	1
206	production.work_centers_work_center_id_seq	frapid_db_user	bigint	1	1
207	purchase.item_cost_prices_item_cost_price_id_seq	frapid_db_user	bigint	1	1
208	purchase.order_details_order_detail_id_seq	frapid_db_user	bigint	1	1
209	purchase.orders_order_id_seq	frapid_db_user	bigint	1	1
210	purchase.price_types_price_type_id_seq	frapid_db_user	bigint	1	1
211	purchase.purchase_returns_purchase_return_id_seq	frapid_db_user	bigint	1	1
212	purchase.purchases_purchase_id_seq	frapid_db_user	bigint	1	1
213	purchase.quotation_details_quotation_detail_id_seq	frapid_db_user	bigint	1	1
214	purchase.quotations_quotation_id_seq	frapid_db_user	bigint	1	1
215	sales.cashiers_cashier_id_seq	frapid_db_user	bigint	1	1
216	sales.closing_cash_closing_cash_id_seq	frapid_db_user	bigint	1	1
217	sales.coupons_coupon_id_seq	frapid_db_user	bigint	1	1
218	sales.customer_receipts_receipt_id_seq	frapid_db_user	bigint	1	1
219	sales.gift_card_transactions_transaction_id_seq	frapid_db_user	bigint	1	1
220	sales.gift_cards_gift_card_id_seq	frapid_db_user	bigint	1	1
221	sales.item_selling_prices_item_selling_price_id_seq	frapid_db_user	bigint	1	1
222	sales.late_fee_late_fee_id_seq	frapid_db_user	bigint	1	1
223	sales.opening_cash_opening_cash_id_seq	frapid_db_user	bigint	1	1
224	sales.order_details_order_detail_id_seq	frapid_db_user	bigint	1	1
225	sales.orders_order_id_seq	frapid_db_user	bigint	1	1
226	sales.payment_terms_payment_term_id_seq	frapid_db_user	bigint	1	1
227	sales.price_types_price_type_id_seq	frapid_db_user	bigint	1	1
228	sales.quotation_details_quotation_detail_id_seq	frapid_db_user	bigint	1	1
229	sales.quotations_quotation_id_seq	frapid_db_user	bigint	1	1
230	sales.returns_return_id_seq	frapid_db_user	bigint	1	1
231	sales.sales_sales_id_seq	frapid_db_user	bigint	1	1
232	social.feeds_feed_id_seq	frapid_db_user	bigint	1	1
233	website.categories_category_id_seq	frapid_db_user	bigint	1	1
234	website.configurations_configuration_id_seq	frapid_db_user	bigint	1	1
235	website.contacts_contact_id_seq	frapid_db_user	bigint	1	1
236	website.contents_content_id_seq	frapid_db_user	bigint	1	1
237	website.menu_items_menu_item_id_seq	frapid_db_user	bigint	1	1
238	website.menus_menu_id_seq	frapid_db_user	bigint	1	1

Related Contents

• Schema List
• Table List
• Sequence List
• Table of Contents