Sol-Project
Tables (30)
Admin
- admin_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
AlertLog
- alert_id — BIGINT
- store_id — BIGINT — NOT NULL
- alert_type — VARCHAR(50) — NOT NULL
- severity — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
AttendanceLog
- log_id — BIGINT
- user_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- record_type — VARCHAR(10) — NOT NULL
- record_time — DATETIME — NOT NULL
- client_ip — VARCHAR(45) — NOT NULL
AuditLog
- audit_id — BIGINT
- user_id — BIGINT
- action_type — VARCHAR(50) — NOT NULL
- target_table — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
BusinessNumber
- biz_id — BIGINT(20) — Primary key — NOT NULL
- owner_id — BIGINT(20) — NOT NULL
- biz_num — VARCHAR(10) — NOT NULL
CompetitorPrice
- competitor_id — BIGINT
- store_id — BIGINT — NOT NULL
- menu_name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- observation_date — DATE — NOT NULL
DemandForecast
- forecast_id — BIGINT
- store_id — BIGINT — NOT NULL
- forecast_date — DATE — NOT NULL
- predicted_sales_max — DECIMAL(10,2) — NOT NULL
- predicted_visitors — INT — NOT NULL
Employee
- employee_id — BIGINT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
EmployeeAssignment
- assignment_id — BIGINT(20) — Primary key — NOT NULL
- employee_id — BIGINT(20) — NOT NULL
- store_id — BIGINT(20) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
EmployeeDocument
- document_id — BIGINT(20) — Primary key — NOT NULL
- employee_id — BIGINT(20) — NOT NULL
- store_id — BIGINT(20) — NOT NULL
- doc_type — VARCHAR(50) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- retention_end_date — DATE — NOT NULL
ExchangeRule
- rule_id — BIGINT
- store_id — BIGINT — NOT NULL
- base_unit — VARCHAR(10) — NOT NULL
- factor — DECIMAL(10,5) — NOT NULL
Inventory
- item_id — BIGINT
- store_id — BIGINT — NOT NULL
- item_name — VARCHAR(100) — NOT NULL
- stock_qty — DECIMAL(10,3) — NOT NULL
- safety_qty — DECIMAL(10,3) — NOT NULL
- expiry_date — DATE
MenuItem
- menu_id — BIGINT
- store_id — BIGINT — NOT NULL
- menu_name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- calculated_cost — DECIMAL(10,2) — NOT NULL
OWNER
- OWNER_ID — BIGINT
- USERNAME — VARCHAR(50)
OnboardingData
- onboarding_id — BIGINT
- user_id — BIGINT — NOT NULL
- data_type — VARCHAR(50) — NOT NULL
- raw_json_data — JSON — NOT NULL
- upload_time — DATETIME — NOT NULL
Owner
- owner_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
OwnerDetail
- detail_id — BIGINT
- owner_id — BIGINT — NOT NULL
- biz_num — VARCHAR(10) — NOT NULL
OwnerSetting
- setting_id — BIGINT(20) — Primary key — NOT NULL
- owner_id — BIGINT(20) — NOT NULL
- setting_key — VARCHAR(50) — NOT NULL
- setting_value — VARCHAR(255)
OwnerSubscription
- owner_sub_id — BIGINT(20) — Primary key — NOT NULL
- owner_id — BIGINT(20) — NOT NULL
- sub_id — BIGINT(20) — NOT NULL
- start_date — DATE — NOT NULL
- expiry_date — DATE — NOT NULL
PayrollSetting
- setting_id — BIGINT
- user_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- wage_type — VARCHAR(20) — NOT NULL
- base_wage — DECIMAL(10,2) — NOT NULL
- deduction_items — JSON
PurchaseHistory
- purchase_id — BIGINT
- store_id — BIGINT — NOT NULL
- item_name — VARCHAR(100) — NOT NULL
- unit_price — DECIMAL(10,2) — NOT NULL
- purchase_date — DATE — NOT NULL
RecipeIngredient
- recipe_id — BIGINT
- menu_id — BIGINT — NOT NULL
- item_id — BIGINT — NOT NULL
- consumption_qty — DECIMAL(10,3) — NOT NULL
STORE
- STORE_ID — BIGINT
- OWNER_ID — BIGINT
- STORE_NAME — VARCHAR(100)
SalesTransaction
- transaction_id — BIGINT
- idempotency_key — VARCHAR(100)
- store_id — BIGINT — NOT NULL
- menu_id — BIGINT — NOT NULL
- transaction_time — DATETIME — NOT NULL
- sales_amount — DECIMAL(10,2) — NOT NULL
SessionLog
- session_id — BIGINT
- user_id — BIGINT — NOT NULL
- login_time — DATETIME — NOT NULL
- refresh_token — VARCHAR(255) — NOT NULL
StaffAssignment
- assignment_id — BIGINT
- employee_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- role — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
Store
- store_id — BIGINT
- owner_id — BIGINT — NOT NULL
- store_name — VARCHAR(100) — NOT NULL
- industry — VARCHAR(50) — NOT NULL
- pos_vendor — VARCHAR(50)
Subscription
- sub_id — BIGINT
- sub_name — VARCHAR(100) — NOT NULL
- monthly_price — DECIMAL(10,2) — NOT NULL
- is_active — BOOLEAN — NOT NULL
UserDocument
- document_id — BIGINT
- user_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- doc_type — VARCHAR(50) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- retention_end_date — DATE — NOT NULL
UserSubscription
- user_sub_id — BIGINT
- user_id — BIGINT — NOT NULL
- sub_id — BIGINT — NOT NULL
- start_date — DATE — NOT NULL
- expiry_date — DATE — NOT NULL