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