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