spa_newsfeed

Tables (3)

comment

  • postId — @default(autoincrement) — Foreign key → post.postId — NOT NULL
  • userId — @default(autoincrement) — Foreign key → user.userId — NOT NULL
  • commentId — @default(autoincrement)
  • name
  • CC
  • CL
  • CUA — @updatedAt
  • CCA — @default(now())

post

  • postId — @default(autoincrement) — Primary key — NOT NULL
  • userId — @default(autoincrement) — Foreign key → user.userId — NOT NULL
  • title
  • image
  • content
  • like — @default('0')
  • updatedAt — @updatedAt
  • createdAt — @default(now())

user

  • userId — @default(autoincrement) — Primary key — NOT NULL
  • email — @unique
  • password
  • name
  • age
  • gender
  • image