DUC_Tech_Community

Tables (5)

Account

  • id — TEXT — Primary key — NOT NULL
  • 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

Post

  • id — SERIAL — Primary key — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT
  • published — BOOLEAN — NOT NULL
  • authorId — TEXT
  • postType — "PostType" — NOT NULL

Session

  • id — TEXT — Primary key — NOT NULL
  • sessionToken — TEXT — NOT NULL
  • userId — TEXT — NOT NULL
  • expires — TIMESTAMP(3) — NOT NULL

User

  • id — TEXT — Primary key — NOT NULL
  • name — TEXT
  • email — TEXT
  • emailVerified — TIMESTAMP(3)
  • image — TEXT

VerificationToken

  • identifier — TEXT — NOT NULL
  • token — TEXT — NOT NULL
  • expires — TIMESTAMP(3) — NOT NULL