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