V000__seed_tables.sql |
0 |
Seed table DDL (currency, country, role, permission, chart_of_account, vat_rate) |
V001__seed_data.sql |
0 |
Reference data (currencies, countries, ~16 roles, permissions, SKR03, VAT) |
V100__create_organization.sql |
1 |
Organization entity |
V101__create_user.sql |
1 |
User entity |
V102__create_user_role.sql |
1 |
User-Role mapping |
V103__create_member.sql |
1 |
Member entity |
V104__create_audit_log.sql |
1 |
Audit log |
V105__create_membership_template.sql |
1 |
Membership template |
V106__create_contract.sql |
1 |
Contract entity |
V107__create_product.sql |
1 |
Product entity |
V200__create_bank_account.sql |
2 |
Bank account |
V201__create_transaction.sql |
2 |
Transaction entity |
V500__create_checkin.sql |
5 |
Check-in entity |
V501__create_access_control.sql |
5 |
Access zones, rules, credentials |
V502__create_resource.sql |
5 |
Resource entity |
V503__create_resource_booking.sql |
5 |
Resource booking |
V504__create_course.sql |
5 |
Course entity |
V600__create_communication.sql |
6 |
Communication + templates |
V601__create_event.sql |
6 |
Event entity |
V700__create_document.sql |
7 |
Document entity |
V701__create_import.sql |
7 |
Import job + template |
V800__create_crm.sql |
8 |
Lead, Deal, Activity, PipelineConfig |
V801__create_support.sql |
8 |
Ticket, TicketComment, KnowledgeBaseArticle |
V802__create_accounting.sql |
8 |
AccountingEntry, CostCenter |
V900__create_trainer_profile.sql |
9 |
Trainer profile extension |
V901__create_shop.sql |
9 |
ShopOrder, OrderLine, CartItem |
V902__create_franchise_config.sql |
9 |
Franchise configuration |