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