dashboard

Tables (3)

User (Untitled)

  • userid (Key) — BIGSERIAL — Primary key — NOT NULL
  • passwd (Field) — varchar
  • name (Field2) — String
  • created_at (Field3) — TIMESTAMP
  • updated_at (Field4) — TIMESTAMP

board (Untitled2)

  • boardNum (Key) — BIGSERIAL — Primary key — NOT NULL
  • userid (Key2) — BIGSERIAL — Foreign key → User.userid — NOT NULL
  • boardText (Field) — text
  • title (Field2) — varchar(400)
  • created_at (Field3) — TIMESTAMP
  • updated_at (Field4) — TIMESTAMP

comment (Untitled3)

  • commentNum (Key) — BIGSERIAL — Primary key — NOT NULL
  • boardNum (Key2) — BIGSERIAL — Foreign key → board.boardNum — NOT NULL
  • userid (Key22) — BIGSERIAL — Foreign key → board.userid — NOT NULL
  • userid (Key3) — BIGSERIAL — Foreign key → User.userid — NOT NULL
  • commentText (Field) — varchar(200)
  • created_at (Field2) — TIMESTAMP
  • updated_at (Field3) — TIMESTAMP