tradlinx-test

Tables (4)

public (users)

  • userid (Key) — varChar(10) — Primary key — NOT NULL
  • pw (Field) — varChar(200)
  • username (Field2) — varChar(10)
  • createdAt (Field3) — timestamp
  • modifiedAt (Field4) — timestamp
  • role (Field5) — varChar(200)

public (article)

  • articleId (Key) — BigInt — Primary key — NOT NULL
  • userid (Key2) — varChar(15) — Foreign key → public.userid — NOT NULL
  • articleTitle (Field) — varChar(200)
  • articleContents (Field2) — text
  • createdAt (Field3) — timestamp
  • modifiedAt (Field4) — timestamp

public (comment)

  • commentId (Key) — BigInt — Primary key — NOT NULL
  • articleId (Key2) — BigInt — Foreign key → public.articleId — NOT NULL
  • userid (Key3) — varChar(15) — Foreign key → public.userid — NOT NULL
  • commentsContents (Field) — text
  • createdAt (Field2) — timestamp
  • modifiedAt (Field3) — timestamp

public (points)

  • pointId (Key) — BigInt — Primary key — NOT NULL
  • userid (Key2) — varChar(10) — Foreign key → public.userid — NOT NULL
  • articleId (Key3) — BigInt — Foreign key → public.articleId — NOT NULL
  • commentId (Key4) — BigInt — Foreign key → public.commentId — NOT NULL
  • point (Field) — integer