article

Tables (3)

Member (user)

  • Field (id) — Primary key
  • Field2 (updateDate) — datetime
  • Field3 (loginPw) — varchar(50)
  • Field4 (name) — varchar(50)
  • Field5 (nickname) — narchar(50)
  • Key2 — NOT NULL
  • Key — NOT NULL

article (CopyOfUntitled)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → board.Key — NOT NULL
  • Field (id2) — Foreign key → Member.Field
  • Field (title) — varchar(100)
  • Field2 (upDate) — datetime
  • Field3 (body) — text
  • Field4 (view) — int
  • Field (reply) — text
  • Field (memberid) — int
  • Field

board (Untitled)

  • Key — Primary key — NOT NULL
  • Field (boardName) — varchar(50)