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