table

Tables (3)

Board (CopyOfboard)

  • boardseq (Key) — int — Primary key — NOT NULL
  • userid (Key2) — varchar(100) — Foreign key → Member.userid — NOT NULL
  • boardtitle (Field2) — varchar(200)
  • boardcontents (Field3) — varchar(4000)

Member (member)

  • userid (Key) — varchar(100) — Primary key — NOT NULL
  • username (Field) — varchar(20)
  • userage (Field2) — int
  • useradress (Field3) — varchar(200)
  • userphonenumber (Field4) — varchar(11)

Post (post)

  • postseq (Key) — int — Primary key — NOT NULL
  • userid (Key2) — varchar(100) — Foreign key → Member.userid — NOT NULL
  • posttitle (Field) — varchar(200)
  • postcontents (Field2) — varchar(4000)