homecloud-platform
Tables (6)
Account
- id — TEXT — Primary key
- userId — TEXT — NOT NULL
- type — TEXT — NOT NULL
- provider — TEXT — NOT NULL
- providerAccountId — TEXT — NOT NULL
- refresh_token — TEXT
- access_token — TEXT
- expires_at — INTEGER
- token_type — TEXT
- scope — TEXT
- id_token — TEXT
- session_state — TEXT
App
- id — TEXT — Primary key
- name — TEXT — NOT NULL
- apiKey — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
File
- id — TEXT — Primary key
- id (id2) — TEXT — Foreign key → App.id
- filename — TEXT — NOT NULL
- key — TEXT — NOT NULL
- mimetype — TEXT — NOT NULL
- size — INTEGER — NOT NULL
- bucket — TEXT — NOT NULL
- userId — TEXT — NOT NULL
- appId — TEXT
- createdAt — TIMESTAMP(3) — NOT NULL
Session
- id — TEXT — Primary key
- sessionToken — TEXT — NOT NULL
- userId — TEXT — NOT NULL
- expires — TIMESTAMP(3) — NOT NULL
User
- id — TEXT — Primary key
- id (id2) — TEXT — Foreign key → File.id
- id (id22) — TEXT — Foreign key → File.id
- name — TEXT
- email — TEXT
- emailVerified — TIMESTAMP(3)
- image — TEXT
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
VerificationToken
- identifier — TEXT — Primary key — NOT NULL
- token — TEXT — NOT NULL
- expires — TIMESTAMP(3) — NOT NULL