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