SDV-V0.1

Tables (6)

admin_users

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • role — VARCHAR(50)
  • company_name — VARCHAR(255)
  • business_license — VARCHAR(100)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

app_users

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • gender — VARCHAR(10)
  • status — VARCHAR(20)
  • created — TIMESTAMP
  • updated_at — TIMESTAMP

apps

  • id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • category — VARCHAR(255)
  • developer_id — BIGINT — Foreign key → admin_users.id
  • price — BIGINT

ota_apps

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → app_users.id
  • version — VARCHAR(255)
  • status — ENUM('RUN, 'STOP')
  • description — VARCHAR(255)
  • app_id — BIGINT — Foreign key → apps.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ota_configs

  • id — BIGINT — Primary key — NOT NULL
  • vin — VARCHAR(255)
  • ip — VARCHAR(255)
  • port — BIGINT
  • user_id — BIGINT — Foreign key → app_users.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

purchase_apps

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → app_users.id
  • app_id — BIGINT — Foreign key → apps.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • purchase_at — TIMESTAMP
  • expiration _at — TIMESTAMP
  • price — BIGINT